OUCSS 2.1 SP1 Fails With ORA-00904: "A"."EMAIL_SENT_FOR_FIRST_ERROR": Invalid Identifier

(Doc ID 2003295.1)

Last updated on APRIL 24, 2015

Applies to:

Oracle Utilities Customer Self Service - Version 2.1.0.1 and later
Information in this document applies to any platform.

Symptoms

ErrorProcessingMaster composite fails to deploy on startup. Log files show that the composite contains SQL that included a column that does not exist on the associated table:

Query name: [ErrorProcessingMasterInputSelect], Descriptor name: [ErrorProcessingMasterInput.IntegrationErrLookup]. Polling the database for events failed on this iteration.
Caused by java.sql.SQLSyntaxErrorException: ORA-00904: "A"."EMAIL_SENT_FOR_FIRST_ERROR": invalid identifier

SQL> desc integration_err_lookup;
 Name Null? Type
 ----------------------------------------- -------- ----------------------------
 LOOKUP_ID NOT NULL NUMBER
 IP_NAME NOT NULL VARCHAR2(200)
 PROCESSING_STATUS VARCHAR2(100)
 RUN_FLAG VARCHAR2(2)
 NEXT_RUNTIME DATE
 HALT_FOR_ERROR VARCHAR2(2)
 RUNTIME_INTERVAL VARCHAR2(20)
 EMAIL_ID VARCHAR2(200)
 EMAIL_CONTENT_TYPE VARCHAR2(400)
 EMAIL_XSL VARCHAR2(1000)
 ERROR_COUNT_PER_PROCESSING NUMBER
 EMAIL_ATTACHMENT_LOCATION VARCHAR2(1000)
 EMAIL_ATTACHMENT_FLAG VARCHAR2(2)
 PUBLISH_HUMAN_TASK_FLAG VARCHAR2(2)
 ID_HUMAN_TASK VARCHAR2(1000)
 LAST_UPDATED_DATE DATE
 PURGE_ERROR_STORE_FLAG VARCHAR2(2)
 PURGE_PROCESSING_STATUS_FLAG VARCHAR2(2)
 PURGE_FREQUENCY VARCHAR2(20)
 NEXT_PURGE_DATE DATE
 PURGE_FILE_NAME VARCHAR2(4000)

There are six services under Utilities/Utility, of those six, ErrorHandling and ErrorProcessMaster are not available in EM after server startup.

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