Migration Application Generates An Empty Package To Cause (DDLIMP-ERR-1021: Unable to read ddl file) Error.
(Doc ID 2771388.1)
Last updated on APRIL 26, 2021
Applies to:
Siebel CRM - Version 18.8 to 20.3 [Release V17]Information in this document applies to any platform.
Symptoms
When migration application is executed, it generates an empty package (zip file) on "source" environment". When "target' environment attempts to deploy the changes, the first step ddlimp fails with DDLIMP-ERR-1021: Unable to read ddl file because there is no input file in the specified location
The issue can be reproduced at will with the following steps:
1) On the source SMC, "Primary Siebel File System" on the Enterprise Profile points to "\\Ew12s17o12\fs". This is the initial setting.
2) On the source srvrmgr, "FileSystem Enterprise Parameter" is updated to "\\ew12s17o12\FS2". So it has a different value from one at 1).
srvrmgr:ew12s17o12> list advanced ent param filesystem show PA_VALUE
PA_VALUE
------------------------------------------------------------------------
\\ew12s17o12\FS2
3) On the source, "Migration Package Location" is set to "\\ew12s17o12\migration" on the migration profile.
4) On the source, login to the migration application then create "FullRR" plan.
5) Execution of "FullRR" fails at "Schema Service"/"Import".
6) On the target, ddlimp log file shows it could not read "\\ew12s17o122\SIA17\migration\1-1DIU\schema\ddlexport_39FA42D960EE.ctl". This is the detail of the failure at 5).
7) On "\\ew12s17o122\SIA17\migration\1-1DIU\schema" (based on the FileSystem on the target), there is no ddlexport_39FA42D960EE.ctl.
D:\>dir \\ew12s17o122\SIA17\migration\1-1DIU\schema
Volume in drive \\ew12s17o122\SIA17 is Data
Volume Serial Number is F242-E9D5
Directory of \\ew12s17o122\SIA17\migration\1-1DIU\schema
04/23/2021 12:26 PM <DIR> .
04/23/2021 12:26 PM <DIR> ..
0 File(s) 0 bytes
8) On "\\ew12s17o12\FS2\migration\1-1DIU" (based on the FileSystem parameter on the source srvrmgr) "ddlexport_39FA42D960EE.ctl" DOES exists under schema.
D:\>dir /s \\ew12s17o12\FS2\migration\1-1DIU
Volume in drive \\ew12s17o12\FS2 is Data
Volume Serial Number is F242-E9D5
Directory of \\ew12s17o12\FS2\migration\1-1DIU
04/23/2021 12:26 PM <DIR> .
04/23/2021 12:26 PM <DIR> ..
04/23/2021 12:15 PM <DIR> dat
04/23/2021 12:26 PM 311 ExportManifest.mf
04/23/2021 12:15 PM <DIR> inp
04/23/2021 12:26 PM <DIR> log
04/23/2021 12:15 PM <DIR> rul
04/23/2021 12:25 PM <DIR> schema
1 File(s) 311 bytes
Directory of \\ew12s17o12\FS2\migration\1-1DIU\dat
04/23/2021 12:15 PM <DIR> .
04/23/2021 12:15 PM <DIR> ..
04/23/2021 12:26 PM 108,974,989 repexport_39FA42D9612D.dat
04/23/2021 12:15 PM 13,675,470 seedexport_39FA42D961F8.dat
2 File(s) 122,650,459 bytes
Directory of \\ew12s17o12\FS2\migration\1-1DIU\inp
04/23/2021 12:15 PM <DIR> .
04/23/2021 12:15 PM <DIR> ..
0 File(s) 0 bytes
Directory of \\ew12s17o12\FS2\migration\1-1DIU\log
04/23/2021 12:26 PM <DIR> .
04/23/2021 12:26 PM <DIR> ..
04/23/2021 12:26 PM 2,912 CreateManifest_39FA42E2D9AD.log
04/23/2021 12:25 PM 2,331,430 ddlexport_39FA42D960EE.log
04/23/2021 12:15 PM 1,856 GetFSeedWMK_39FA42D961E9.log
04/23/2021 12:15 PM 1,620 GetRRInfo_39FA42D9610E.log
04/23/2021 12:26 PM 15,252 repexport_39FA42D9612D.log
04/23/2021 12:15 PM 2,525 seedexport_39FA42D961F8.log
6 File(s) 2,355,595 bytes
Directory of \\ew12s17o12\FS2\migration\1-1DIU\rul
04/23/2021 12:15 PM <DIR> .
04/23/2021 12:15 PM <DIR> ..
0 File(s) 0 bytes
Directory of \\ew12s17o12\FS2\migration\1-1DIU\schema
04/23/2021 12:25 PM <DIR> .
04/23/2021 12:25 PM <DIR> ..
04/23/2021 12:25 PM 18,336,676 ddlexport_39FA42D960EE.ctl
1 File(s) 18,336,676 bytes
Total Files Listed:
10 File(s) 143,343,041 bytes
9) On "\\ew12s17o12\migration" (based on "Migration Package Location" on SMC), "FullRR1-1DIU.zip" exists but the size seems too small.
D:\>dir /s \\ew12s17o12\migration
Volume in drive \\ew12s17o12\migration is Data
Volume Serial Number is F242-E9D5
Directory of \\ew12s17o12\migration
04/23/2021 12:26 PM <DIR> .
04/23/2021 12:26 PM <DIR> ..
04/23/2021 12:26 PM 22 FullRR1-1DIU.zip
1 File(s) 22 bytes
10) It actually has no contents.
11) On "\\ew12s17o12\FS\migration\1-1DIU\log" (based on "Primary Siebel File System" on SMC), there is "createPackage_179003259bd.log". It indicates this location is used for the creation of the migration package.
D:\>dir /s \\ew12s17o12\FS\migration\1-1DIU
Volume in drive \\ew12s17o12\FS is Data
Volume Serial Number is F242-E9D5
Directory of \\ew12s17o12\FS\migration\1-1DIU
04/23/2021 12:26 PM <DIR> .
04/23/2021 12:26 PM <DIR> ..
04/23/2021 12:26 PM <DIR> log
0 File(s) 0 bytes
Directory of \\ew12s17o12\FS\migration\1-1DIU\log
04/23/2021 12:26 PM <DIR> .
04/23/2021 12:26 PM <DIR> ..
04/23/2021 12:26 PM 237 createPackage_179003259bd.log
1 File(s) 237 bytes
Total Files Listed:
1 File(s) 237 bytes
Changes
Location of File System parameter has been changed since the initial deployment.
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 |