[ https://issues.apache.org/jira/browse/ODE-831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13114589#comment-13114589 ]
René Bos commented on ODE-831: ------------------------------ Hi Tammo, I forget to mention that I indeed tried that fix. At least, a part of it. I changed the column size of fault_explanation from 255 to unlimited (character varying in PostgreSQL). That worked, the fault is catched and ignored in my case. I changed it to unlimited because I believe the size of 4096 is specified nowhere but is a somewhat guessed value. The fault may come from ODE itself in case of a fault thrown from a failure or from a external webservice throwing a fault. Especially the last one is not guaranteed to be 4096 characters or less. René > value too long for type character varying(255) > ---------------------------------------------- > > Key: ODE-831 > URL: https://issues.apache.org/jira/browse/ODE-831 > Project: ODE > Issue Type: Bug > Components: BPEL Runtime > Affects Versions: 1.3.5 > Reporter: Terry Mueller > Fix For: 1.4 > > Attachments: FailingInvokeWithFaultOnFailure.log, > FailingInvokeWithFaultOnFailure.log > > > Caused by: <openjpa-1.3.0-SNAPSHOT-r422266:938588 nonfatal general error> > org.apache.openjpa.persistence.PersistenceException: ERROR: value too long > for type character varying(255) {prepstmnt 1445067100 INSERT INTO > ODE_MESSAGE_EXCHANGE (MESSAGE_EXCHANGE_ID, ACK_TYPE, CALLEE, CHANNEL, > CORRELATION_ID, CORRELATION_KEYS, CORRELATION_STATUS, CREATE_TIME, DIRECTION, > EPR, FAILURE_TYPE, FAULT, FAULT_EXPLANATION, INST_RES, ISTYLE, OPERATION, > PARTNER_LINK_MODEL_ID, PATTERN, PIPED_ID, PIPED_PID, PORT_TYPE, > PROPAGATE_TRANS, RESOURCE, STATUS, TIMEOUT, CORRELATOR, PLINK, PROCESS, > INSTANCE, REQUEST, RESPONSE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(String) > hqejbhcnphr5asgqkdgdr4, (String) FAILURE, (String) > {urn:xml-gov-au:edais:ncp:UA-BTV1000R:2.3.0r2}TestCase_UA-BTV1000R_S..., > (null) null, (null) null, (null) null, (null) null, (Timestamp) 2010-05-24 > 11:24:48.46, (int) 77, (null) null, (String) FORMAT_ERROR, (null) null, > (String) Unable to evaluate apply property alias > "{urn:xml-gov-au:edais:ncp:U..., (boolean) false, (String) UNRELIABLE, > (String) process, (int) 26, (String) REQUEST_RESPONSE, (null) null, (null) > null, (null) null, (boolean) false, (null) null, (String) ACK, (long) 900000, > (null) null, (null) null, (long) 1554, (null) null, (long) 2068, (null) > null]} [code=0, state=22001] > FailedObject: org.apache.ode.dao.jpa.MessageExchangeDAOImpl@6bdcccbf > at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4360) > at > org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4325) > at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102) > at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:72) > at > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:127) > at > org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:81) > at > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:93) > at > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:81) > at > org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:549) > at > org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106) > at > org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59) > at > org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89) > at > org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72) > at > org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:723) > at > org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130) > ... 16 more -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira