My Oracle Support Banner

UPGREP_PROD_nnn Records ORA-00942 Error Against S_WEB_TMPL_RX and S_TU_CHAP_INT Tables. (Doc ID 2981499.1)

Last updated on OCTOBER 18, 2023

Applies to:

Siebel CRM - Version 17.0 [IP2017] and later
Information in this document applies to any platform.


When the production mode upgrade (upgrep + upgphys) is executed, siebsrvr/log/upgrep_prod_nnn/output/EnableWorkspace_[TIME_STAMP]/ws_rep_upd.log shows the following error. (nnn corresponds to Siebel version where the database is upgraded from.)


 Here are the steps to reproduce.

1. Run upgrep and upgphys for the development environment.
2. Copy schema.ddl and custrep.dat from development to dbsrvr/oracle/ directory on the production system.
3. Run Siebel Database Configuration wizard with the following options.
- Environment Type: Production
- Upgrade Options: Upgrade Custom Database Schema (upgrep and upgphys)
4. Run the upgrade wizard.

While the upgrade wizard should finish successfully, the above errors are recorded in ws_rep_upd.log.


 Siebel database upgrade is executed.


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.