Error: QUERY EVENT: Invalid begin date - 00/00/1900.

pfviv

ADSM.ORG Member
Joined
Nov 24, 2011
Messages
43
Reaction score
0
Points
0
PREDATAR Control23

Hi.

When I am running this query:

SELECT E.STATUS,E.RESULT FROM EVENTS E,CLIENT_SCHEDULES S WHERE E.SCHEDULE_NAME=S.SCHEDULE_NAME AND
E.DOMAIN_NAME=S.DOMAIN_NAME AND S.ACTION NOT IN ('DEPLOY') AND E.SCHEDULED_START >CURRENT_TIMESTAMP -24 hour

It returns this error: QUERY EVENT: Invalid begin date - 00/00/1900.

It started a couple of day ago.

Any idea?

Rhel 5.8
Tsm 6.2.3

Ivan
 
PREDATAR Control23

Hi.
Tanks for the replay
Seems the time is correct

tsm: SYM6>show time
Session established with server SYM6: Linux/x86_64
Server Version 6, Release 2, Level 3.100
Server date/time: 05-12-2012 16:56:14 Last access: 05-12-2012 10:31:46


Current Date and Time on the Server
----------------------------------------
05-12-2012 16:56:15
UTC (GMT) Date/Time is: 12/05/2012 03:56:15 PM
Last Noted Date/Time is: 12/05/2012 04:56:14 PM
Daylight Savings Time is in effect: NO
 
PREDATAR Control23

Hi.

I cant find a solution to the problem on this server.
I see the date on the server is in format DD-MM-YYYY and the invalid date is YYYY/MM/DD. Could this be the problem?
I have some other servers with same date format and no problems.
Any input is appreciated.

Ivan
 
PREDATAR Control23

Hi.

I cant find a solution to the problem on this server.
I see the date on the server is in format DD-MM-YYYY and the invalid date is YYYY/MM/DD. Could this be the problem?
I have some other servers with same date format and no problems.
Any input is appreciated.

Ivan

here's the solution
http://www-01.ibm.com/support/docview.wss?uid=swg1IC92301

select * from TSMDB1.SCHEDULE_EVENT
WHERE actstart='1956-09-05-00.00.00.000000';

and then you delete these rows
delete from TSMDB1.SCHEDULE_EVENT
WHERE actstart='1956-09-05-00.00.00.000000';

Good luck
 
Top