1. Please help support our sponsors by considering their products and services.
    Our sponsors enable us to maintain high-speed Internet connection and fast webservers.
    They support this free information and knowledge exchange forum service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions

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