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

Last updated on AUGUST 09, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.

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

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