Return
-
Title
Foglight: java.sql.SQLException Clob is too large to be stored in a Java String -
Description
Foglight: java.sql.SQLException Clob is too large to be stored in a Java String
Management Server Log:
java.sql.SQLException: Clob is too large to be stored in a Java Stringat oracle.jdbc.driver.T4CClobAccessor.getString(T4CClobAccessor.java:450)at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1297)at org.jboss.resource.adapter.jdbc.WrappedResultSet.getString(WrappedResultSet.java:875) -
Cause
There are corruptions in Foglight repository's LOB values.java.sql.SQLException: Clob is too large to be stored in a Java Stringat oracle.jdbc.driver.T4CClobAccessor.getString(T4CClobAccessor.java:450)at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1297)at org.jboss.resource.adapter.jdbc.WrappedResultSet.getString(WrappedResultSet.java:875)The driver thinks that the CLOB value that is being loaded is greater than 2gb in size. -
Resolution
Workaround 1:
Truncate the affected tables
Workaround 2:
Restore from backup when the repository was in a last known good state.