Getting Errors When Running Create_all.sh on pluggable database for 6.4.3 Installation
(Doc ID 2759691.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Transportation Management - Version 6.4.3 and laterInformation in this document applies to any platform.
Symptoms
Getting errors when running create_all.sh in Pluggable Database
After installing OTM643 application software, when running "create_all.sh" file to create master data in OTM database we are getting lot of unexpected errors w.r.t reportowner.
Attached log file for your reference!
ERROR
-----------------------
Creating REPORTOWNER footprint triggers...
SCHEMA NAME IS REPORTOWNER
Running reportowner_grants...
Creating REPORTOWNER comments...
COMMENT ON TABLE REPORT_T IS 'The REPORT table contains the list of standard and customized reports. One record per report.'
*
ERROR at line 1:
ORA-00942: table or view does not exist
COMMENT ON COLUMN REPORT_T.REPORT_GID IS 'GC3 Global indetifier for the entity. Is created by concatenating Domain Name,"." and XID.'
*
ERROR at line 1:
ORA-00942: table or view does not exist
COMMENT ON COLUMN REPORT_T.REPORT_DESC IS 'Report description.'
*
ERROR at line 1:
ORA-00942: table or view does not exist
COMMENT ON COLUMN REPORT_T.REPORT_GROUP_GID IS 'GC3 Global indetifier for the entity. Is created by concatenating Domain Name,"." and XID.'
*
ERROR at line 1:
ORA-00942: table or view does not exist
COMMENT ON COLUMN REPORT_T.DOMAIN_NAME IS 'Domain of the User. Is used for creating the GID.'
*
ERROR at line 1:
ORA-00942: table or view does not exist
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run create_all.sh
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 |
Cause |
Solution |
References |