My Oracle Support Banner

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

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
  Goal
  Solution

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