search

CenturyLinkCloud / mdw

https://centurylinkcloud.github.io/mdw/
MIT License
46 stars 10 forks source link

Overlong activity log messages cause runtime SQLException #802

Closed donaldoakes closed 4 years ago

donaldoakes commented 4 years ago

Log messages greater than 4000 characters cause exceptions like the following during activity execution. Note: Does not affect workflow progress. Only prevents log output persistence in ACTIVITY_LOG, and viewing in MDWHub's Inspector Log tab.

java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) ~[driver-11.2.0.3.jar!/:11.2.0.3.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) ~[driver-11.2.0.3.jar!/:11.2.0.3.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) ~[driver-11.2.0.3.jar!/:11.2.0.3.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) ~[driver-11.2.0.3.jar!/:11.2.0.3.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) ~[driver-11.2.0.3.jar!/:11.2.0.3.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) ~[driver-11.2.0.3.jar!/:11.2.0.3.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) ~[driver-11.2.0.3.jar!/:11.2.0.3.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044) ~[driver-11.2.0.3.jar!/:11.2.0.3.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329) ~[driver-11.2.0.3.jar!/:11.2.0.3.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584) ~[driver-11.2.0.3.jar!/:11.2.0.3.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665) ~[driver-11.2.0.3.jar!/:11.2.0.3.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352) ~[driver-11.2.0.3.jar!/:11.2.0.3.0]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.1.jar!/:2.1.1]
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) ~[commons-dbcp2-2.1.1.jar!/:2.1.1]
at com.centurylink.mdw.dataaccess.DatabaseAccess.logExecuteUpdate(DatabaseAccess.java:366) ~[mdw-common-6.1.30.jar!/:na]
at com.centurylink.mdw.dataaccess.DatabaseAccess.runUpdate(DatabaseAccess.java:497) ~[mdw-common-6.1.30.jar!/:na]
at com.centurylink.mdw.dataaccess.DatabaseAccess.runUpdate(DatabaseAccess.java:486) ~[mdw-common-6.1.30.jar!/:na]
at com.centurylink.mdw.service.data.WorkflowDataAccess.addActivityLog(WorkflowDataAccess.java:281) ~[mdw-services-6.1.30.jar!/:na]
... 17 common frames omitted