OCS server fails to start due to ORA-00942 error
Article ID: KB0075680
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.
Environment
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.
Issue/Introduction
Additional Information
https://docs.tibco.com/pub/af/4.0.0/doc/pdf/TIB_af_4.0_installation.pdf
Feedback
