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;
Environment
- Red Hat JBoss Operations Network (JON) 3.1.2, 3.2.0
- Oracle database
- The detail line in the event source is very long (4000 and more characters) and contains international (e.g. 16 bit) characters;
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Close
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.