1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

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

Discussion in 'TSM Reporting & Monitoring' started by pfviv, Dec 4, 2012.

  1. pfviv

    pfviv ADSM.ORG Member

    Joined:
    Nov 24, 2011
    Messages:
    39
    Likes Received:
    0
    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
     
  2.  
  3. domino

    domino ADSM.ORG Senior Member

    Joined:
    Nov 16, 2005
    Messages:
    720
    Likes Received:
    32
    Occupation:
    System Engineer
    Location:
    Germany
    seems to be a wrong time
    try: show time

    check your clock settings
     
  4. pfviv

    pfviv ADSM.ORG Member

    Joined:
    Nov 24, 2011
    Messages:
    39
    Likes Received:
    0
    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
     
  5. pfviv

    pfviv ADSM.ORG Member

    Joined:
    Nov 24, 2011
    Messages:
    39
    Likes Received:
    0
    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
     
  6. merouan

    merouan ADSM.ORG Member

    Joined:
    Feb 27, 2013
    Messages:
    18
    Likes Received:
    0
    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
     

Share This Page