OCS server fails to start due to ORA-00942 error

OCS server fails to start due to ORA-00942 error

book

Article ID: KB0075680

calendar_today

Updated On:

Products Versions
TIBCO Fulfillment Order Management 4.0.0, OM 5-LR

Description


When trying to start up OCS service, it fails to start and below error is logged in ocs-loca.log file:
==
 Error starting ApplicationContext. To display the auto-configuration report re-run your application with 'debug' enabled.
18 janv. 2018 12:08:23,933 ERROR [main] SpringApplication Application startup failed
org.hibernate.exception.SQLGrammarException: could not extract ResultSet
    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
....
....
at com.tibco.fom.configShare.FOSStarter.main(FOSStarter.java:124) [configShare-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
===

Please refer to attached ocs-local.log for full trace.
 

Issue/Introduction

How to fix OCS server startup failure because of ORA-00942 error

Environment

ALL

Resolution


This is due to misconfiguration, value set for below property in ConfigValues_OCS.xml file is not good:
===
<ConfValue description="Hibernate Default Catalog" name="Hibernate Default Catalog" propname="com.tibco.af.ocs.hibernate.default_catalog" sinceVersion="3.0" visibility="Basic">
                                <ConfString default="aff_ocs" value="FOM4OCS"/>
                        </ConfValue>
===
To fix this issue, you need to use for this flag OCS database user.  
 

Additional Information

FOM 4.0.0 installation guide:
https://docs.tibco.com/pub/af/4.0.0/doc/pdf/TIB_af_4.0_installation.pdf

Attachments

OCS server fails to start due to ORA-00942 error get_app
Powered by Wolken Software