ORA-01461: can bind a LONG value only for insert into a LONG column in the JBoss ON server.log file

Issue

• We are seeing this error in the server.log which hints at wrong DB schema:

09:35:44,652 WARN  [org.rhq.enterprise.server.event.EventManagerBean] (http-/0.0.0.0:8443-39) addEventData: Insert of events failed : ORA-01461: can bind a LONG value only for insert into a LONG column
09:35:44,652 WARN  [org.rhq.enterprise.server.event.EventManagerBean] (http-/0.0.0.0:8443-39)      : ORA-01461: can bind a LONG value only for insert into a LONG column

• Our alerts that should be triggered every time free swap space is below 10 GB are not triggered anymore and I can see in JON log file the following error:

2014-04-14 10:54:43,517 WARN  [org.rhq.enterprise.server.event.EventManagerBean]      : ORA-01461: can bind a LONG value only for insert into a LONG column
2014-04-14 10:55:44,122 WARN  [org.rhq.enterprise.server.event.EventManagerBean] addEventData: Insert of events failed : ORA-01461: can bind a LONG value only for insert into a LONG column

• Events are not added to the database;