My Oracle Support Banner

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

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