My Oracle Support Banner

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

Last updated on APRIL 26, 2018

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

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
Symptoms
Cause
Solution


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