My Oracle Support Banner

Argus Interchange Stops Importing XMLs After the Argus Safety Database is Upgraded. E2BReceive Log Shows "ORA-08002: sequence S_REPORT_ID.CURRVAL is not yet defined in this session" (Doc ID 2374142.1)

Last updated on MAY 30, 2024

Applies to:

Oracle Life Sciences Argus Safety - Version 8.1 to 8.4 [Release 8.1 to 8.4]
Information in this document applies to any platform.



Symptoms

Argus Interchange stops importing XML files after the Argus Safety database is upgraded.  The ESM_E2BImport log file shows "ORA-08002: sequence S_REPORT_ID.CURRVAL is not yet defined in this session"

Intermittently, Argus Interchange will process some XMLs and then stop processing the rest of the XMLs in the incoming folder.


The ESM_E2BImport log file shows:

Changes

Upgrading the Argus database to 8.1 or later.

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
References


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