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
I would enable debug mode and check the logs for additional information
Best practice in debugging AFX connectors?