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 ?