Hi,

when i troubleshooting my collector, sentinel GUI message prompt
following:


Parsing failed: TypeError: Cannot call method "replace" of undefined;
input:

my release.js is following:
----------------------------------------------------------------------
Collector.prototype.initialize = function() {
this.PARSER.getOffsetData = function(input) {
if (typeof input.RXMap != "undefined") {
return input.RXMap.REQUEST_TM;
}
};
conn.addParser(this.PARSER.getOffsetData);
return true;
};

Collector.prototype.cleanup = function() {
return true;
};


Connector.prototype.sendQuery = function() {
return true;
};


Record.prototype.preParse = function(e) {
if (this.CONNECTION_ERROR != null || typeof this.RXMap == "undefined")
{ return false; }

if (this.CONNECTION_METHOD == "DATABASE") {

for (var field in this.RXMap) {
this[field] = this.RXMap[field];
}
}

return true;
};

Record.prototype.parse = function(e) {

var detstring =
this.RXMap.REQUEST_TM.replace(/(\d+)\/(\d+)\/(\d{4})\s(\S+)/g, '$1/$2/$3
$4 GMT');
var dt = new Date(detstring);
e.ObserverEventTime(dt);
return true;
};


Record.prototype.normalize = function(e) {
instance.SEND_EVENT =true;
return true;
};

Record.prototype.postParse = function(e) {
return true;
};


Record.prototype.reply = function(e) {
return true;

----------------------------------------------------------------------------
my sqlquery.base is following:

SELECT TOP 100 * FROM TS_QUERYBILLSIGNED_LOG WHERE REQUEST_TM > %s


My table sample is following:
----------------------------------------------------------------------------------

CUSTCODE,BEGIN_TM,END_TM,PAGEINDEX,QUERYTYPE,SYSTE MNAME,SIGNEDTYPE,CLIENTIP,CLIENTMAC,CLIENTNAME,MET HODNAME,REQUEST_TM,ANSWER_TM,ANSWER_TOTAL,ANSWER_C URRENTCOUNT,LOG_ID,WAYBILL_NOS
8710294837,12/30/2013,1/2/2014
23:59,0,0,CSS-CLIENT,0,221.213.26.241,6C-F0-49-CD-2C-CD,a0af75ce888346e,waybillSingedTotal,1/3/2014
14:50,1/3/2014 14:50,28,4,433676211,

-----------------------------------------------------------------------------------------
My table Schema is following:

USE [sfere]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ts_querybillsigned_log](
[CUSTCODE] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BEGIN_TM] [datetime] NULL,
[END_TM] [datetime] NULL,
[PAGEINDEX] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[QUERYTYPE] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SYSTEMNAME] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SIGNEDTYPE] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CLIENTIP] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CLIENTMAC] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CLIENTNAME] [varchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[METHODNAME] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQUEST_TM] [datetime] NULL,
[ANSWER_TM] [datetime] NULL,
[ANSWER_TOTAL] [numeric](20, 0) NULL,
[ANSWER_CURRENTCOUNT] [numeric](20, 0) NULL,
[LOG_ID] [numeric](30, 0) NOT NULL,
[WAYBILL_NOS] [varchar](400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Thanks
Best Regards!
Steve zeng


--
steve_zeng
------------------------------------------------------------------------
steve_zeng's Profile: https://forums.netiq.com/member.php?userid=3875
View this thread: https://forums.netiq.com/showthread.php?t=50290