Siebel DDLDICT Utility is Failing When Connected to an Older Siebel Database Version Implemented in DB2 Z/OS. Error: DIC-05 szexpression flag is invalid (Doc ID 3002004.1)

Last updated on APRIL 11, 2024

Applies to:

Symptoms

The synchronize schema is a pre-upgrade step required for Siebel upgrades, or Incremental Repository Merge (IRM), when Siebel databases are implemented in IBM DB2 Z/OS.

The synchronize schema utility includes the execution of DDLDICT. The same DDLDICT is executed when the Siebel upgrade first UPGREP starts. In both cases, Siebel is accessing an older Siebel database version, and DDLDICT utility is not able to process this older release Siebel database. It fails as follows:

If running the pre-upgrade step synchronize schema, the error can be seen in the <siebel-root>\log\ddlsync_mf\output\expschem.log file. If executing the first upgrep, the error can be found in <siebel-root>\log\upgrep_dev_<source_version>_mf_m\output\ddldict_staging.log file.

The following topics describe the steps to reproduce the issue while synchronizing the schema before the upgrade and while starting the upgrade upgrep phase:

To execute the schema synchronization before the upgrade, see the detailed steps at Siebel Upgrade Guide for DB2 For Z/OS > Creating the Siebel Staging Database > Required Tasks before Creating the Staging Database.

To start the Upgrade Upgrep phase, by running the Database Configuration Wizard > Upgrade > Upgrep > zSeries Staging of files for Upgrep, see Siebel Upgrade Guide for DB2 For Z/OS > Creating the Siebel Staging Database > Creating the Staging Database Schema DDL Files. 

Changes

Cause

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