SAS Real-Time Decision Manager 6.7 displays a [resource] is not initialized and cannot be used message even if a connection exists. This message is displayed instead of the real error message returned by the database. As a result, it is difficult to find the real error message to correct the issue.

Here is an example of the reported message:

com.sas.analytics.ph.RTDMException: JDBC Connection Pool for Resource OracleDB is not initialized and cannot be used.

Note that the above message is also a valid error message that occurs when there are connection issues. To determine whether you have a connection issue, run the diagnostics.jsp to validate the connection. The diagnostics.jsp prints the output of the validation. 

To call the diagnostics.jsp, use the following links for the Design or Engine server:

    Design: http://<hostname>/RTDMDesign/jsp/Diagnostics.jsp

    Engine: http://<hostname>/RTDM/Diagnostics.jsp

Here is an example of a valid connection. This example includes an Oracle connection with the OracleDB resource name.

Oracle OracleDB: CONNECTED

This issue occurs due to a database exception, such as constraint exceptions, missing tables, or similar database-initiated errors. 

Workaround

Install the hot fix for this issue to view the real error message.

You can also engage your Database Administrator (DBA) and ask them to investigate whether they see the error on the database side.