ORA-12505 error when creating Report Builder data source - CA Service Catalog
Article ID: 435161
Updated On:
Products
Issue/Introduction
When creating a new Report Builder data source for an Oracle database, the screen shows a field for "Service Name".
However when you use Service Name in that field you receive an error message
Test failed. [ Cannot create PoolableConnectionFactory Listener refused the connection with the following error ORA 12505 TNS listener does not currently know of SID given in connection descriptor ]
When typing the SID instead of the Service Name, the connection test succeeds.
Steps to reproduce:
- In the CA Service Catalog UI, navigate to Administration -> Report Builder
- Click the "Create Data Object" button
- Click the "Query Builder" button
- Click the "Add Data Source" button
- Fill in the details for the new data source, selecting "Oracle" as the type of database, and using the TNS Service Name in the field labelled "Service Name"
- Click the "Test button and see the error:
Test failed. [ Cannot create PoolableConnectionFactory Listener refused the connection with the following error ORA 12505 TNS listener does not currently know of SID given in connection descriptor ]
- Click OK. In the "Service Name" field, change the value to be the SID
- Click "Test" and see the "success" message
Test successful.
Environment
Service Catalog 17.4.0 - 17.4.5
When creating the data source for an Oracle database
Cause
The Report Builder UI mislabels the 'SID' field as 'Service Name', leading to incorrect JDBC URL assembly.
Resolution
Targeted to be fixed in SDM 17.4.6 (tentative 4th quarter 2026) and in SDM 17.5 (tentative 3rd quarter 2026). These target dates are estimates only and could change. Please monitor the Service Management Community web page or the Service Management Product Support page for the latest updates.
Additional Information
Feedback
