Details
-
Bug
-
Resolution: Done
-
Major
-
jboss-fuse-6.2.1
-
None
-
%
Description
We are running into the following DB error:
15:14:43,040 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Thread-114) SQL Error: 22001, SQLState: 22001
15:14:43,041 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Thread-114) Value too long for column "VALUE VARCHAR(255)": "STRINGDECODE('<?xml version=\""1.0\"" encoding=\"
"UTF-8\""?><wsse:Security xmlns:wsse=\""http://schemas.xmlsoap.org/ws/2002/04/secext... (378)"; SQL statement:
insert into RTGOV_ACTIVITY_PROPERTIES (unitId, unitIndex, name, value) values (?, ?, ?, ?) [22001-168]
The scenario that leads to this is a SY application exposed through a SOAP endpoint, with two services with JMS in between. In addition, we have registered a custom EventProcessor which creates a Situation.
If we send in a SOAP request including security headers, this exception occurs.
As a workaround we manually execute
ALTER TABLE RTGOV_SITUATION_PROPERTIES ALTER COLUMN VALUE VARCHAR(65535);
ALTER TABLE RTGOV_ACTIVITY_PROPERTIES ALTER COLUMN VALUE VARCHAR(65535);
Please increase the size of these columns with the out of the box setup.
