Issue Loading Ack On Database - ORA-00904: : invalid identifier,Source: OraOLEDB (Doc ID 1380880.1)

Last updated on NOVEMBER 29, 2011

Applies to:

Oracle Argus Safety - Version: 4.1.3.1B and later   [Release: 4.1 and later ]
Information in this document applies to any platform.

Goal

Oracle Argus Safety 4.2 migration

In order to prepare the migration from Argus 4.2 to Argus 7, we recently updated the database to move it from WEISO to UTF8 format and migrated from 10.2.0.4 to 10.2.0.5.

After this change loading E2B acknowledgments results in the following error:


"25-Nov-2011 1:48:33 PM:
==========
Start Receive Process for File : D:\path1\path2\ci123456789.123456@myackfile.ack
=========="
"25-Nov-2011 1:48:34 PM: System Error, unable to update the SAFETYREPORT table for ' REPORT_ID ' 12345'.
System Error Error #: -2147217900,
Desc.: ORA-00904: : invalid identifier,Source: OraOLEDB"

What is the cause of this ?


Solution

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