Siebel Database Upgrade From 15.18 To 22.3 Runs Until Completion, But Upgphys DDLIMP Utility Sends Error ORA-01756: quoted string not properly terminated
(Doc ID 2875515.1)
Last updated on JUNE 13, 2022
Applies to:Siebel CRM - Version 22.3 and later
Information in this document applies to any platform.
Siebel Development environment was upgraded from IP 15.18 to version 22.3.
The logs show it executed until completion, but there are errors while running ddlimp utility of Upgphys.
The error can be seen in <siebel-root>\upgphys_dev_155\output\sync_tab.log:
The following steps can be executed to reproduce the Siebel Database upgrade:
1. Run Siebel Database Configuration Wizard > Upgrade > Upgrep.
2. If successful, run the Incremental Repository Merge from Siebel Tools, check the conflicts, mark them solved and run Fullpublish.
3. Run Siebel Database Configuration Wizard > Upgrade > Upgphys
Detailed instructions to run the steps above can be found in Siebel Database Upgrade Guide 22.3 > Performing a Siebel Incremental Repository Merge
Custom tables were initially created directly in the database and then created in Tools.
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