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 laterInformation in this document applies to any platform.
Symptoms
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.
Changes
Siebel database upgrade is executed.
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 |
Changes |
Cause |
Solution |
References |