Re: date format errors of schedule in sm.log (253 Views)
Reply
Advisor
darshana
Posts: 34
Registered: ‎01-02-2013
Message 1 of 3 (314 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

Honored Contributor
Piku
Posts: 3,972
Registered: ‎06-17-2010
Message 2 of 3 (291 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,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Assign Kudo, if found post useful and mark it accepted if solves the issue.
http://h30499.www3.hp.com/t5/Tips-and-Tricks/Kudos-what-where-how-and-why/m-p/5677925#U5677925
Occasional Visitor
APSM
Posts: 1
Registered: ‎06-17-2013
Message 3 of 3 (253 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
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.