AnsweredAssumed Answered

Connector capability failing in workflow but not in test mode

Question asked by Paul Cherrier on Apr 5, 2017
Latest reply on Apr 10, 2017 by Boris Lekumovich

We have a connector with an update account capability that works when the connector is in test mode but fails in the workflow.

 

We're getting the following error.

 

Message : Failed to route event via endpoint: DefaultOutboundEndpoint{endpointUri=jdbc://UpdateAccount, connector=EEJdbcConnector { name=MIS-Dispatcher-User-Connector.connector lifecycle=start this=5f200f46 numberOfConcurrentTransactedReceivers=4 createMultipleTransactedReceivers=false connected=true supportedProtocols=[jdbc] serviceOverrides= } , name='endpoint.jdbc.UpdateAccount', mep=REQUEST_RESPONSE, properties={queryTimeout=-1}, transactionConfig=Transaction{factory=null, action=INDIFFERENT, timeout=0}, deleteUnacceptedMessages=false, initialState=started, responseTimeout=10000, endpointEncoding=UTF-8, disableTransportTransformer=false}. Message payload is of type: NullPayload Code : MULE_ERROR--2 --------------------------------------------------------------------------------

 

Exception stack is: 1. Invalid column type(SQL Code: 17004, SQL State: + 99999) (java.sql.SQLException) oracle.jdbc.driver.OraclePreparedStatement:8809 (null) 2. Failed to route event via endpoint: DefaultOutboundEndpoint{endpointUri=jdbc://UpdateAccount, connector=EEJdbcConnector { name=MIS-Dispatcher-User-Connector.connector lifecycle=start this=5f200f46 numberOfConcurrentTransactedReceivers=4 createMultipleTransactedReceivers=false connected=true supportedProtocols=[jdbc] serviceOverrides= } , name='endpoint.jdbc.UpdateAccount', mep=REQUEST_RESPONSE, properties={queryTimeout=-1}, transactionConfig=Transaction{factory=null, action=INDIFFERENT, timeout=0}, deleteUnacceptedMessages=false, initialState=started, responseTimeout=10000, endpointEncoding=UTF-8, disableTransportTransformer=false}. Message payload is of type: NullPayload (org.mule.api.transport.DispatchException) org.mule.transport.AbstractMessageDispatcher:117 (http://www.mulesoft.org/docs/site/current3/apidocs/org/mule/api/transport/DispatchException.html) --------------------------------------------------------------------------------

 

Root Exception stack trace: java.sql.SQLException: Invalid column type at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8809) at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8286) at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:9060) + 3 more (set debug level logging or '-Dmule.verbose.exceptions=true' for everything)

 

Connector

 

Workflow

Outcomes