Announcement

Collapse
No announcement yet.

ORA-20000: Undefined time zone for location ORA-06512: at "GLOGOWNER.UTC", line 26

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • ORA-20000: Undefined time zone for location ORA-06512: at "GLOGOWNER.UTC", line 26

    Hey All

    I am trying to update an eventdate in IE_SHIPMENTSTATUS table using the below code :-



    UPDATE IE_SHIPMENTSTATUS
    SET EVENTDATE = $event_date - (utc.get_local_Date($event_date,
    (SELECT S.SOURCE_LOCATION_GID
    FROM SS_STATUS_HISTORY SS ,
    SHIPMENT S
    WHERE SS.SHIPMENT_GID = S.SHIPMENT_GID
    AND SS.I_TRANSACTION_NO = $I_TRANSACTION
    AND S.SHIPMENT_GID = $GID
    AND SS.DOMAIN_NAME = 'KNEU/VEDAN'
    )) - $event_date)
    WHERE
    SHIPMENT_GID = $GID
    AND STATUS_CODE_GID = 'KNEU/VEDAN.0141'

    Seems to be very simple update statement but , I am getting below error for this statement :-
    Agent KNEU/VEDAN.SHIPMENT_TENDERED_V02 failed

    [SQL_STATEMENT] UPDATE IE_SHIPMENTSTATUS SET EVENTDATE = ? - (utc.get_local_Date(?, (SELECT S.SOURCE_LOCATION_GID FROM SS_STATUS_HISTORY SS , SHIPMENT S WHERE SS.SHIPMENT_GID = S.SHIPMENT_GID AND SS.I_TRANSACTION_NO = ? AND S.SHIPMENT_GID = ? AND SS.DOMAIN_NAME = 'KNEU/VEDAN' )) - ?) WHERE SHIPMENT_GID = ? AND STATUS_CODE_GID = 'KNEU/VEDAN.0141' ; [2018-09-24 08:09:08.0, 2018-09-24 08:09:08.0, 345944191, KNEU/VEDAN.20180924-S-00004, 2018-09-24 08:09:08.0, KNEU/VEDAN.20180924-S-00004]

    java.sql.SQLException: ORA-20000: Undefined time zone for location ORA-06512: at "GLOGOWNER.UTC", line 26

    Just to give a background , we are inserting an event in IE-SHIPMENTSTATUS table upon shipment tendered and and same way upon
    tender accepted. I want to update the timezone of the event dates .

    When I ran the agent it gave the error mentioned above.

    Could this be because of the privileges of the user on database or has anyone found a solution to this issue.

    Thanks!!

    Ayush
Working...
X