When Running a Migration Plan that Includes Schema Service Export It Intermittently Fails with DDLDICT-ERR-1026 / DDLDICT-ERR-1028 Errors
(Doc ID 2970815.1)
Last updated on AUGUST 29, 2023
Applies to:
Siebel CRM - Version 23.8 and laterInformation in this document applies to any platform.
Symptoms
When running a Migration Plan that includes Schema Service Export it intermittently fails with the following errors:
DDLDICT-ERR-1028: Unable to write index "indexname" (UTLCfgWrite (objtype))
The errors are recorded in the ddlexport log file located under the siebelfs/migration/<archive_id>/log directory.
Below is a snippet of the information found in the ddlexport_<string>.log file:
...
2023-08-18 12:21:07 Reading index X_DD_TRGTGRPMBR_F1 ...
2023-08-18 12:21:07 Reading index X_DD_TRGTGRPMBR_F2 ...
2023-08-18 12:21:07 Found 5059 tables and 25900 indexes.
2023-08-18 12:21:07 Writing DDL file...
2023-08-18 12:21:21 DDLDICT-ERR-1026: Unable to write table "S_QUOTA" (UTLCfgWrite (objtype)).
2023-08-18 12:21:22 DDLDICT-ERR-1022: Unable to write ddl file "/apl/siebelnfs/fs/a/1/migration/1-B6YCQ0/schema/ddlexport_3A0B56395A96.ctl" (UTLDbFileTblWrite).
2023-08-18 12:21:22 Error in MainFunction (UTLDbFileWrite).
2023-08-18 12:21:22 Error in Main function...
2023-08-18 12:21:23 (logapi.cpp (184) err=1 sys=2) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 2, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)
The related object name varies every time the error is returned, it can be a given table or index object.
If the ddldict export is manually executed outside of the Migration Application context the failure cannot reproduced.
STEPS
1. Execute a migration plan that includes Schema Service
2. It may eventually fail with the above mentioned errors
Changes
Siebel 23.8 Monthly Update installation on top of Siebel 23.5
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 |
| Changes |
| Cause |
| Solution |
| References |