DDLIMP utility crashes when DB Includes an index with Column 1 (Doc ID 1998141.1)

Last updated on JUNE 02, 2023

Applies to:

Symptoms

On : 8.2.2.14 [IP2014] version, System Admin

ddlimp.exe process crashes on OS level

When manually running the command:

C:\siebel\8.2.2.0.0\ses\siebsrvr\bin\ddlimp.exe /u siebel /p siebel /c "SBA_82_DSN" /f C:\siebel\8.2.2.0.0\ses\dbsrvr\oracle\ddl.ctl /t y /i n /e y /B SIEBEL_IDX_TS /X SIEBEL_DATA_TS /G SSE_ROLE /R Y /l C:\siebel\8.2.2.0.0\ses\siebsrvr\log\upgrep_dev_822\output\ddlctl_tab.log /W Y

the command crashes , and nothing is written into ddlctl_tab.log.

Issue is also encpountered durin Upgrade/IRM.

ERROR
-----------------------
Call Stack from dump file for the crashing DDLIMP process:

kernel32!UnhandledExceptionFilter+5f
msvcr110!__crtUnhandledException+14
sslcdb!CSSModuleConverter::FileGetLine+1083
sslcdb!CSSModuleConverter::FileGetLine+1274
sslcdb!CSSModuleConverter::FileGetLine+11a6
sslcdb!UTLDbNameToDbSpecificSchemaSqlStyle+9770
sslcdb!UTLDbNameToDbSpecificSchemaSqlStyle+55bb
sslcdb!UTLDbDsTblRead+d46
sslcdb!UTLDbDdlDbProcess+3ef
ddlimp+31c4
ddlimp+36e8
kernel32!BaseThreadInitThunk+e
ntdll!__RtlUserThreadStart+70
ntdll!_RtlUserThreadStart+1b

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a custom index such:

CREATE INDEX "SIEBEL"."CX_SAMI_F1" ON "SIEBEL"."S_ORDR_DOC_LIT" ("LIT_ID", 1)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
TABLESPACE "SIEBEL_DATA" ;

2. open CMD command line window
3. cd C:\siebel\8.2.2.0.0\ses\siebsrvr\bin
4. ddlimp.exe /u siebel /p siebel /c "SBA_82_DSN" /f C:\siebel\8.2.2.0.0\ses\dbsrvr\oracle\ddl.ctl /t y /i n /e y /B SIEBEL_IDX_TS /X SIEBEL_DATA_TS /G SSE_ROLE /R Y /l C:\siebel\8.2.2.0.0\ses\siebsrvr\log\upgrep_dev_822\output\ddlctl_tab.log /W Y

Cause

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