Troubleshooting: Connection to IMPAX RIS database fails

Issue

In the Business Services Configuration tool, the connection test for the IMPAX RIS database is successful. However, all connections to the IMPAX RIS database fail and IMPAX RIS data cannot be retrieved in the IMPAX Client (the IMPAX RIS parameter window returns only NULL values).

Details

In the sqlnet.ora file on the Application Server, following you find the following configuration:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

In the PACS web services logging, the following error is written:

ORA-12640: Authentication adapter initialization failed

Solution

In most of the cases, the Oracle Client and Server are in different domains. Sometimes, the problem occurs because the Windows Authentication to the Windows Database server gives security issues for the Client communication.

Setting SQLNET.AUTHENTICATION_SERVICES= (NONE) is a workaround; however, the exact root cause must be identified and fixed.