My Oracle Support Banner

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 13, 2019

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***

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 ()"


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!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.