Loading an ASCII database save fails with ORA-39002 error.

Document ID : KB000051622
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

An ASCII database load will fail with the following errors:

Initial checks completed. Starting load ...
Starting IMPORT with type SCHEMA...
Error: SQLCODE=-39002 SQLTEXT=ORA-39002: invalid operation
ORA-06512: at "SYS.DBMS_SYS_ERROR", line
Error: ORA-39002: invalid operation
Refer to log /.tdb/oracle_datapump/imp.log for more details..
Error: The program nhiLoadDb failed.
Error: nhiLoadDb failed.
 

This is due to a permissions issue on the imp.log file.

The $NH_USER did not have permission to delete and create a new imp.log and the load failed with the error above. Changing the owner of imp.log to $NH_USER with chown will allow the load to complete.

In the future when there is a permissions issue on this file, a message similar to the following will be returned:

"The current user does not have write permission for <path to save>/<save name>.tdb/oracle_datapump/imp.log." 

Problem Ticket: PRD00047519

Solution

The issue documented above has been resolved in the following release(s):

eHealth 6.2.2

eHealth Service Packs are available for download from support.ca.com. Please review the README file for each Service Pack prior to installing. CA Technologies recommends that users always keep eHealth current by installing the latest Service Pack available.