HPE Service Manager / Service Center Support and News Forum
Showing results for 
Search instead for 
Do you mean 

date format errors of schedule in sm.log

Highlighted
Advisor

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

2 REPLIES
Honored Contributor Honored Contributor

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.
Occasional Visitor

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