Argus Report Scheduling AG Process is Not Scheduling Any Reports and Writing the Error "SQL execution error, ORA-00936: missing expression" into Error Log
Last updated on FEBRUARY 02, 2018
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.
***Checked for relevance on 02-Feb-2018***
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 ()"
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