Monday, February 11, 2019

JPS-10702: The datasource jndi/OPSSDS is not found


Symptoms: Some Oracle Retail products uses a catalog schemas to manage information regarding user data policies and password.
If used the RCU tool to generate it, it creates user like OPSS and MDS.
Oracle applications written in java and deployed on Weblogic might use datasources that are pointing to these schemas and registered on Weblogic policies.

Cause: If you have applied any hotfix to this application or changed something on the catalog, it might be unregistered or out-dated for Weblogic that will show this error.

JPS-10702: The datasource jndi/OPSSDS is not found.

Solution: Make sure the metadata information located on the files:

jps-config.xml - Validate if the database connection info is correct accordingly.
Eg:
<propertySet name="props.db.1">
            <property name="jdbc.url" value="jdbc:oracle:thin:@catdbsrv:1521:CATDB"/>


OPSSDataSource-7946-jdbc.xml - Make sure that the datasource info is correct pointing to the catalog.
Eg:
<name>OPSSDataSource</name>
  <jdbc-driver-params>
    <url>jdbc:oracle:thin:@catdbsrv:1521:CATDB</url>

After that, make a bounce on Weblogic and associate the datasource to a target-managed-servers (AdminServer and Your-Custom-Managed-Server)
Eg: Go to Weblogic > YourDomain > Services > Data Sources > OPSSDataSource
Click on Monitoring and Testing, click on each target and after that Test Data Source.

Also validate if this data source is added on your target managed server.
Eg: Go to Weblogic > YourDomain > Services > Data Sources > OPSSDataSource > Target

Even though this might not solve the problem. And if you check on Oracle Support, you will find tons of doc IDs talking about this error code.
Check for more logs of you application to see if there is any other clearer message or hint. If you find any other solution, please comment here and enrich the internet knowledge base.





No comments:

Post a Comment

Configure the Oracle DB Access Control List to avoid error like ORA-24247: network access denied

Symptoms:  You try to make external connections from the Oracle Database and receive erros like ORA-24247: network access denied by access c...