date format errors of schedule in sm.log (262 Views)
Reply
Advisor
darshana
Posts: 34
Registered: ‎01-02-2013
Message 1 of 3 (262 Views)

date format errors of schedule in sm.log

Hi,

 

I am using HPSM 9.31.1008 p1 with Oracle db on Linux. I am receiving starnge errors in sm.log

 

3172(  3440) 01/28/2013 17:22:04  RTE E date format ' 1000-01-03 09:08:00' unrecognized in sqlda (scheduler,select.class)
  3172(  3440) 01/28/2013 17:22:04  RTE E sqociTOD(): SQL type = 5 (STRING); data =            1000-01-03 09:08:00
  3172(  3440) 01/28/2013 17:22:04  RTE E Unable to parse date for column EXPIRATION (scheduler,select.class)
  3172(  3440) 01/28/2013 17:22:04  RTE E Incomplete record, could not process data for table SCHEDULEM1 in file schedule identified by key: schedule.id=2684263 (scheduler,select.class)

 

I have not done any configuration changes to sm in last 2 weeks. I checked this schedule. it is mapped with 1 incident's 25% slo. I deleted that incident. then i deleted this scheule_id entry from db, but still I am getting this error whenever I am restarting my HPSM service.

 

Kinldy help.

 

Thanks,

Darshana

Please use plain text.
Honored Contributor
Piku
Posts: 3,839
Registered: ‎06-17-2010
Message 2 of 3 (239 Views)

Re: date format errors of schedule in sm.log

Hi ,
did you checked what is value there in expiration field of the scheduler having id as 2684263 .
It seems date format is wrongly saved in the this field.

Try to correct/change it .

hth,
Please use plain text.
Occasional Visitor
APSM
Posts: 1
Registered: ‎06-17-2013
Message 3 of 3 (201 Views)

Re: date format errors of schedule in sm.log

Hi,
I am getting below error in sm.log file...can anyone please help to resolve this issue:

4628( 4820) 06/14/2013 17:07:29 RTE E Incomplete record, could not process data for table PROBSUMMARYM1 in file probsummary identified by key: number="IM55957"
4628( 4820) 06/14/2013 17:07:29 RTE E date format '14-JUN-13' unrecognized in sqlda
4628( 4820) 06/14/2013 17:07:29 RTE E sqociTOD(): SQL type = 5 (STRING); data = 14-JUN-13
4628( 4820) 06/14/2013 17:07:29 RTE E Unable to parse date for column OPEN_TIME
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation