DDLIMP utility crashes when DB Includes an index with Column 1
(Doc ID 1998141.1)
Last updated on JUNE 02, 2023
Applies to:
Siebel CRM - Version 8.2.2.14 [IP2014] and laterInformation in this document applies to any platform.
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
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 |
References |