SYMPTOM

A stambia session ends with status WITH_ERRORS, and the action that failed has the following error in CORE_RET_MESS

java.sql.SQLException: SQL Exception
at com.indy.engine.main.connections.b.b(SourceFile:247)
at com.indy.engine.main.connections.b.a(SourceFile:314)
at com.indy.engine.main.connections.JDBCConnectionContainerI.<init≶(SourceFile:33)
at com.indy.engine.action.common.ActionCodeTypeI.setConnection(SourceFile:400)
at com.indy.engine.actionCodes.JdbcToXmlActionCodeI.executeSimpleCode(SourceFile:701)
at com.indy.engine.action.common.ActionCodeTypeI.executeCode(SourceFile:1608)
at com.indy.engine.action.common.ActionCodeTypeI.run(SourceFile:1767)
at java.lang.Thread.run(Unknown Source)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'

...

The message generally contains the name of the JDBC driver required for connecting to the database (oracle.jdbc.driver.OracleDriver, com.ibm.db2.jcc.DB2Driver, com.mysql.jdbc.Driver, org.postgresql.Driver, com.microsoft.sqlserver.jdbc.SQLServerDriver, etc.)

SOLUTION

Install the missing JDBC driver in the directory stambiaRuntime/lib/jdbc of the Runtime that executed the session.

If the Runtime is installed as a Windows service, also remove and reinstall the service:

> installEngineAsService.bat -r <service name>

> installEngineAsService.bat -i <service name>

And then restart the Runtime.