DDLSync Crashes When Function Based Index with Constant Expression Exists
(Doc ID 2961117.1)
Last updated on SEPTEMBER 28, 2023
Applies to:
Siebel Tools - Version 22.11 and laterInformation in this document applies to any platform.
Symptoms
DDLSync Crashes When Function Based Index with a constant expression like "1" or "ROW_ID,1" is used.
Following is observed in upgwiz.log:
UpgradeLog UpgradeInfo 3 00000002646d4a6c:0 2023-05-24 17:17:32 Executing (D:\sba\ses\siebsrvr\bin\ddlimp.exe /u SIEBEL /p ******** /c "BLD02_AC_SBL_DSN" /g SSE_ROLE /f D:\sba\ses\dbsrvr\oracle\schema.ddl /e n /B SIEBEL_DATA /X SIEBEL_INDX /R Y /W Y /9 Y /s N /l D:\sba\ses\siebsrvr\log\ddlsync\output\ddlsync1.log)
UpgradeLog UpgradeError 1 00000002646d4a6c:0 2023-05-24 17:24:20 (err=-1073740791) was returned by application (D:\sba\ses\siebsrvr\bin\ddlimp.exe /u SIEBEL /p ******** /c "BLD02_AC_SBL_DSN" /g SSE_ROLE /f D:\sba\ses\dbsrvr/oracle/schema.ddl /e n /B SIEBEL_DATA /X SIEBEL_INDX /R Y /W Y /9 Y /s N /l D:\sba\ses\siebsrvr\log\ddlsync\output/ddlsync1.log).
UpgradeLog UpgradeError 1 00000002646d4a6c:0 2023-05-24 17:24:20 There was an error in launching the application.
UpgradeLog UpgradeError 1 00000002646d4a6c:0 2023-05-24 17:24:20 Execute file action failed.
UpgradeLog UpgradeError 1 00000002646d4a6c:0 2023-05-24 17:24:20 Error executing action ().
UpgradeLog UpgradeInfo 3 00000002646d4a6c:0 2023-05-24 17:24:20 Status Message (Errors encountered)
The issue can be reproduced at will with the following steps:
1. Create a function based index in Siebel Tools or Siebel Web Tools, for details refer to Guidelines for Creating a Function-Based Index
2. Apply Table from Siebel Tools
3. Run ddlsync to synchronize Siebel Repository Definitions and the Physical Siebel Schema, for details refer to Bookshelf
4. Siebel Crashes
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 |