'ORA-39346: data loss in character set conversion for object SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY' error importing database after upgrade to Oracle 12c in RSA Identity Governance & Lifecycle
3 years ago
Originally Published: 2020-04-20
Article Number
000044966
Applies To
RSA Product Set:  RSA Identity Governance & Lifecycle 
RSA Version/Condition:  7.0
 
Issue
After an upgrade to version 7.0 or higher of RSA Identity Governance & Lifecycle that required an Oracle database upgrade to 12c, the import of the database fails with the following error when executing $AVEKSA_HOME/database/DBA/AVDB/scripts/AVDB_Import_AVUSER.sh. The error is seen in the terminal output during the import and in the import log file ($AVEKSA_HOME/AveksaExportImportDir/Import_AVDB_avuser.log).
 
ORA-39346: data loss in character set conversion for object SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY Processing object type SCHEMA_EXPORT/TYPE/TYPE_BODY

 
Cause
This issue is caused by an Oracle defect which does not properly handle the import of an Oracle 11 database into an Oracle 12c database. The full details regarding this Oracle defect are noted in Oracle Metalink article Doc ID 1958604.1. Note that an Oracle Metalink account is required to access this Oracle Metalink article.
 
Resolution
RSA Identity Governance & Lifecycle Engineering has reviewed this Oracle defect and determined that this error is benign with regards to the RSA Identity Governance & Lifecycle application. No additional steps are required for the successful import of the database, as long as this is the only error message seen in the terminal output or the import log ($AVEKSA_HOME/AveksaExportImportDir/Import_AVDB_avuser.log) when executing the import script ($AVEKSA_HOME/database/DBA/AVDB/scripts/AVDB_Import_AVUSER.sh).
 

Related Articles

Trending Articles

Don't see what you're looking for?