Symptom
After setting Up Change Tracker application, ping test shows the followings:
"Cannot establish a connection. For details, see message area."
"Database access error occured. See logs for details."
As a result the Change Tracker application in portal shows empty fields and no options can be chosen.
In defaultTrace files the following exception can be found:
...
Exception of type com.sap.sql.log.OpenSQLException caught: Exception of type java.sql.SQLException caught: Invalid Oracle URL specified: OracleDataSource.makeURL..
[EXCEPTION]
com.sap.sql.log.OpenSQLException: Exception of type java.sql.SQLException caught: Invalid Oracle URL specified: OracleDataSource.makeURL.
...
Caused by: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
...
Read more...
Environment
AS Java all versions with Oracle database.
Product
Keywords
MDM, MDM change tracker, change tracker, MDB_Finance_MD_ChangeTracker, JDBC Custom DataSources, url, property name, lower case, upper case, empty field, MDM Change Tracker application, Change Tracker application, resource details, application resources, oracle, database, oracle database, case sensitive, SQLException, Invalid Oracle URL specified, OracleDataSource.makeURL, OracleDataSource, Database access error occured, See logs for details, Cannot establish a connection, For details, see message area , KBA , BC-JAS-PER-SQL , Relational Persistence: Open SQLJ, Open JDBC , BC-DB-ORA , Oracle , BC-JAS-ADM-ADM , Administration , BC-JAS-TRH , Transactions and Resource Handling , MDM-FN-TC-CT , Change Tracker WEB UI , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.