E-INST : Unable To Create Table For Demo Database, NO MESSAGES ACCESSIBLE error (Doc ID 2166478.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

On : 8.55 version, DataMover

When attempting to run the database import in data mover,
the following error occurs.

ERROR
-----------------------
Started: Tue Jul 19 07:56:16 2016
Data Mover Release: 8.55.08
Database: CPSDEMO (ENG)
Indexing export file E:\HCM922\data\hcengs.db
Input file: E:\HCM922\data\hcengs.db (ENG)
Importing COMPETENCY_TBLX
 Creating Table COMPETENCY_TBLX
==>NO MESSAGES ACCESSIBLE==> (76,62)
Error: Unable to process create statement for COMPETENCY_TBLX
Ended: Tue Jul 19 08:10:49 2016
Unsuccessful completion

Another example:

 Creating Table EO_TRAN_CAT_LNG
 Import EO_TRAN_CAT_LNG 0
 Building required indexes for EO_TRAN_CAT_LNG
 Updating statistics for EO_TRAN_CAT_LNG
Records remaining: 17649
Importing EPO_CASCADE_AET
 Creating Table EPO_CASCADE_AET
==>NO MESSAGES ACCESSIBLE==> (76,62)
Error: Unable to process create statement for EPO_CASCADE_AET
 SQL Spaces: 0 Tables: 1271 Triggers: 0 Indexes: 1562 Views: 0
Ended: Tue Jul 19 08:36:27 2016
Unsuccessful completion

 Creating Table EPO_PGITEM_LANG
==>NO MESSAGES ACCESSIBLE==> (76,62)
Error: Unable to process create statement for EPO_PGITEM_LANG
 SQL Spaces: 0 Tables: 18 Triggers: 0 Indexes: 19 Views: 0
Ended: Tue Jul 19 08:39:08 2016
Unsuccessful completion



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. load the hcm92ora.dms script in datamover.
2. Provide all the required details.
3. Run the script.

Cause

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