Service Manager / Service Center Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

date format errors of schedule in sm.log

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.
Highlighted
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