[jira] [Commented] (ODE-831) value too long for type character varying(255)

["René Bos (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ODE-831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13114554#comment-13114554 ] 

René Bos commented on ODE-831:
------------------------------

I was wondering why this issue is still pending. It gives serious issues when invoking a external webservice fails when using faultOnFailure=true! 

The process will become in an undefined state if the webservice call fails and the fault message was too long (more than 255 characters). 

Example process snippet (I want to totaly ignore mail sending errors):

<!-- Invoke the email webservice -->
<invoke inputVariable="webserviceCallInput_Bevestiging_aanvraag" operation="sendEmailBestelling" outputVariable="webserviceCallOutput_Bevestiging_aanvraag" partnerLink="NtierMailServiceLink" portType="NtierMailService:NtierMailServicePortType">
	
	<ext:failureHandling xmlns:ext="http://ode.apache.org/activityRecovery">
		<ext:faultOnFailure>true</ext:faultOnFailure>
	</ext:failureHandling>

	<catchAll>
		<empty/>
	</catchAll>
</invoke>

I have this problem in Ode 1.3.2 but in the package from Ode 1.3.5 I still see the 255 character column. Can someone please change the affected version? A major bug in the 1.3.x branch is more important than one in the (unreleased) 2.x branch)

Regards, 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: 2.0-beta2
>            Reporter: Terry Mueller
>
> 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