Argus Report Scheduling AG Process is Not Scheduling Any Reports and Writing the Error "SQL execution error, ORA-00936: missing expression" into Error Log (Doc ID 2140905.1)

Last updated on MAY 22, 2016

Applies to:

Oracle Argus Safety - Version 6.0 to 8.0.1 [Release 6.0 to 8.0]
Information in this document applies to any platform.

Symptoms

DESCRIPTION: Argus Report scheduling service not working. Appears to be blocked from completing scheduling by the following error condition.


ERROR MESSAGES: "P_ERROR_TEXT set to DEFAULT: Failure code 500301001 for report scheduling of case XXXXXXXXXXXXX.Case Priorities assessed 0 Case Reporting Scheduled 0 Case Event Assessment 0"

NAVIGATION / REPLICATION PATH:

The following is found in CMN_Error_log table:
"Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-00936: missing expression

By using the following SQL statement:

SELECT DISTINCT case_master.case_id, -1 seq_num FROM case_master WHERE CASE_MASTER.CASE_ID IN (153818634) AND CASE_MASTER.CASE_ID IN ()"


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms