(RPA) Support Tip: Oracle SQLError: 17401 SQLState: 99999, Protocol Violation


The RPA central login page does not show the option for LDAP/internal login. In general.log following error is seen,

xxx-xx-xx 09:53:23,694 [local-scheduler-persisted_Worker-15] (SqlExceptionHelper.java:129) WARN - SQL Error: 17401,
SQLState: 99999
xxxx-xx-xx 09:53:23,697 [local-scheduler-persisted_Worker-15] (SqlExceptionHelper.java:131) ERROR - Protocol violation
xxxx-xx-xx 09:53:23,702 [local-scheduler-persisted_Worker-15] (TransactionAspectSupport.java:539) ERROR - Application exception overridden by rollback exception org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [ SELECT DISTINCT EXEC_STATE_ID FROM OO_EXECUTION_QUEUES WHERE     (STATUS = 7) OR     (STATUS = 8) OR     (STATUS = 6)]; SQL state [99999]; error code [17412]; Bigger type length than Maximum; nested exception is java.sql.SQLException: Bigger type length than Maximum

The protocol violation error might be related to having multiple driver versions which for some reason are conflicting or caused by a bad compilation of the java driver (getting the jdbc driver for the wrong version of java).

Make sure that the driver version is correct for the product. Make sure that in the central/lib, central tomcat/lib only one version of the oracle jdbc driver is present.

In this case, there were two versions of ojdbc in the Tomcat/lib directory. After the older one was removed, all seemed to work.


Support Tip
Comment List