Troubleshooting
Problem
SCHEMA_OWNER is validated even though data source is used for Multi Fulfillment and Selling Suite 8.x application
Symptom
There are 2 ways for Sterling Multi Fulfillment and Selling application 8.x to connect to database. One is through the jdbc.properties and the other is through Oracle connection pooling. If it connects database through connection pooling, all database login information will be read from data source configured in the application server. However, we have observed that DB_SCHEMA_OWNER in jdbc.properties also gets validated when the application is started. If you use a user that is a user belonging to a different schema, the application will not be able to start.
Error Message<Error ErrorCode="ORA-942"
<Attribute
Name="ErrorCode" Value="ORA-942"/>
<Attribute Name="ErrorDescription"
Value="ORA-00942: table or view does not exist
"/>
<Attribute
Name="SQLStatement" Value=" SELECT /*YANTRA*/ YFS_LOCALE.* FROM YFS_LOCALE
YFS_LOCALE "/>
<Attribute Name="SQLState" Value="42000"/>
<Attribute Name="DBErrorCode" Value="942"/>
<Attribute
Name="TransactionIsolationLevel" Value="2"/>
<Error
ErrorCode="java.sql.SQLException" ErrorDescription=""
ErrorRelatedMoreInfo="ORA-00942: table or view does not exist
">
<Stack>java.sql.SQLException: ORA-00942: table or view does not exist
Resolving The Problem
This issue can be resolved by overriding disservice to <empty> in customer_overrides.
For example:
disservice=
Historical Number
NFX9708
Product Synonym
[<p><b>]Escalation ID[</b><p>];138753;[<p><b>]Severity[</b><p>];Normal;[<p><b>]Type[</b><p>];NormalFix
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21558759