AnsweredAssumed Answered

AFX Sybase Connector - Failed to route event via endpoint

Question asked by Devani Nagaratnam on Mar 20, 2017

Hi,

I have configured AFX connector for Sybase database. We are using Stored Procedure to create an account. But when I test the capability of Create account, I am getting the below error.  Could anyone let me how to solve this error.

.

 

Message : Failed to route event via endpoint: DefaultOutboundEndpoint{endpointUri=jdbc://CreateAccount, connector=EEJdbcConnector
{
name=AppsecDb-Shell.connector
lifecycle=start
this=6a416fa0
numberOfConcurrentTransactedReceivers=4
createMultipleTransactedReceivers=false
connected=true
supportedProtocols=[jdbc]
serviceOverrides=<none>
}
, name='endpoint.jdbc.CreateAccount', 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-42999
--------------------------------------------------------------------------------
Exception stack is:
1. JZ0SB: Parameter index out of range: 3.(SQL Code: 0, SQL State: + JZ0SB) (java.sql.SQLException)
com.sybase.jdbc3.jdbc.ErrorMessage:-1 (null)
2. Failed to route event via endpoint: DefaultOutboundEndpoint{endpointUri=jdbc://CreateAccount, connector=EEJdbcConnector
{
name=AppsecDb-Shell.connector
lifecycle=start
this=6a416fa0
numberOfConcurrentTransactedReceivers=4
createMultipleTransactedReceivers=false
connected=true
supportedProtocols=[jdbc]
serviceOverrides=<none>
}
, name='endpoint.jdbc.CreateAccount', 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: JZ0SB: Parameter index out of range: 3.
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
at com.sybase.jdbc3.jdbc.ParamManager.for(Unknown Source)
at com.sybase.jdbc3.jdbc.ParamManager.doSetParam(Unknown Source)
+ 3 more (set debug level logging or '-Dmule.verbose.exceptions=true' for everything)
********************************************************************************

Regards,

Devani N

Outcomes