Exception during Extract rule connecting to external database
Exception occurs when running the Business Intelligence Exchange (BIX) Extract rule to connect to an external database.
The DataSource java:comp/env/jdbc/sqlPEGAPHL is invalid: Unable to obtain DataSource object: code: SQLState: Unexpected exception resolving reference Message: DatabaseException caused by prior exception: javax.naming.NamingException: Unexpected exception resolving reference [Root exception is java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerDriver] DatabaseException caused by prior exception: java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerDriver | SQL Code: 0 | SQL State: null The DataSource java:comp/env/jdbc/sqlPEGAPHL is invalid: A connection could not be obtained.
Steps to Reproduce
- Create a BIX Extract rule whose output data is saved in an external database
- Create a Database rule which used JDBC connection pool details
- Run the Extract rule
A defect or configuration issue in the operating environment.
ResolutionPerform the following local-change:
Add the mssql-jdbc-7.2.1.jre8.jar file in lib directory of Tomcat server and restart the server.