"ORA-00933: SQL command not properly ended" Error with NMS 2.5.0.1.4 Scada Alarm Create Failure
(Doc ID 2852733.1)
Last updated on MARCH 02, 2022
Applies to:
Oracle Utilities Network Management System - Version 2.5.0.0.0 to 2.5.0.1.0 [Release 2.5] Oracle Network Management for Utilities - DMS - Version 2.5.0.0.0 to 2.5.0.1.0 [Release 2.5] Information in this document applies to any platform.
Symptoms
NMS 2.5.0.1.4 scada alarm create failure
SCADA alarms creation fails due to invalid SQL. A comma is missing in the statement updates the row in the DDS_ALARM_LOG
ERROR
-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR while processing command 'UPDATE dds_alarm_log SET external_id = :external_id, user_time = TO_TIMESTAMP(:user_time, 'MM/DD/YYYY HH24:MI:SS:FF3') limit = :limit, rti_alias = :rti_alias, state = :state , description = :description, term_station = :term_station, active = :active, when_deactivated = :when_d, silence = :silence, who_ack = :who_ack, time_ack=TO_DATE(:time_ack,'MM/DD/YYYY HH24:MI:SS') WHERE alarm_cls=:alarm_cls AND alarm_idx=:alarm_idx' ORA-00933: SQL command not properly ended
Changes
Cause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!