Anonymous_User Absent Member.
Absent Member.
225 views

Re: MSSQL Collector Problem

Hi ibasaran,
in the raw data tap, do your records have the field "col_safahatid" in this
exact form?

Norbert

P.S.: Question regarding custom collector should be posted to the
novell.devsup.plugin-sdk fourm.

>>> On 27.10.2012 at 16:44, ibasaran<ibasaran@no-mx.forums.netiq.com>

wrote:

> Hi All,
>
> i am getting trouble with my custom mssql collector. My collector
> below;
>
> Collector.prototype.initialize = function(){
>
> this.PARSER.getOffsetData = function(input){
> if (typeof input.RXMap != "undefined") {
> return input.RXMap.col_safahatid;
> }
> }
> conn.addParser(this.PARSER.getOffsetData);
> return true;
> }
>
> when i debug saying always "input is undefined"
>
> Connector.prototype.sendQuery = function(){
> if (this.CONNECTION_STATUS == "NEED‑QUERY") {
> conn.send(instance.CONFIG.DBQuery);
> }
> return true;
> };
>
> Record.prototype.preParse = function(e){
> if (this.CONNECTION_ERROR != null) {
> return false;
> }
> if ((this.CONNECTION_METHOD == "DATABASE" && this.CONNECTION_MODE ==
> "map")) {
> for (var field in this.RXMap) {
> this[field] = this.RXMap[field];
> }
> }
> return true;
> };
>
> Every time "this.CONNECTION_ERROR" saying "NODATA" and it not resuming
> to parse metot.
>
> My sqlquery.base below
>
> SELECT
> TOP %d
> SAFAHAT_ID as SAFAHATID,
> SAFAHAT_ADI as SAFAHATADI,
> SAFAHAT_ACIKLAMA as SAFAHATACIKLAMA
> FROM TEST_SAFAHAT
> WHERE SAFAHAT_ID > %s
> ORDER BY SAFAHAT_ID
>
>
> i am giving 20 to max row.
>
> When i try open raw data trap always coming first 20 record and
> looping. first 20 record coming again and again. What is my problem ?


0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.