MQSeries.net :: View topic

OffirMid · Posted: Tue Jun 20, 2006 1:01 am Post subject: Values switch between parameters

Hi

I'm experiencing a wierd problem. When polling date from ISeries, the values between the 2 key fields switch causing the numeric field (IDCONO) to get the text value and the String field (IDSUNO) to get the numeric value. This causes a NumberFormatException.

I have checked all the maps and BOs on my side and my customer have checked the triggers on the AS/400 side and they all seem to be correct with the right values. Any idea on what can be the problem?

[Time: 2006/06/19 12:08:47.014] [System: ConnectorAgent] [SS: sampleConnector] [Thread: appPolling (#668423413)] [Type: Trace]
[Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting retrieve] ]
[Time: 2006/06/19 12:08:47.014] [System: ConnectorAgent] [SS: sampleConnector] [Thread: appPolling (#668423413)] [Type: Trace]
[Mesg: :select IDSUNO,IDCONO,IDALSU,IDCFI1,IDCFI2,IDCFI3,IDCFI4,IDCFI5,IDCHID,IDCHNO,IDCOR2
,IDCORG,IDCSCD,IDDTFM,IDECAR,IDEDIT,IDHAFE,IDLMDT,IDLNCD,IDMEPF,IDPHN2,IDPHN
O,IDPODA,IDRGDT,IDRGTM,IDSTAT,IDSUAL,IDSUCM,IDSUCO,IDSUNM,IDSUTY,IDTFNO,IDTI
ZO,IDTLNO,IDTXID,IDVRNO,IDDESV from CIDMAS00 where IDSUNO=400 and
IDCONO=TST001 ]
[Time: 2006/06/19 12:08:47.357] [System: ConnectorAgent] [SS: sampleConnector] [Thread: appPolling (#668423413)] [Type: Trace]
[Mesg: :[Type: Trace] [MsgID: 37016] [Mesg: Values that are being set on the PreparedStatement:] ]
[Time: 2006/06/19 12:08:47.357] [System: ConnectorAgent] [SS: sampleConnector] [Thread: appPolling (#668423413)] [Type: Trace]
[Mesg: :400 ]
[Time: 2006/06/19 12:08:47.357] [System: ConnectorAgent] [SS: sampleConnector] [Thread: appPolling (#668423413)] [Type: Trace]
[Mesg: :TST001 ]
[Time: 2006/06/19 12:08:47.373] [System: ConnectorAgent] [SS: sampleConnector] [Thread: appPolling (#668423413)] [Type: Trace]
[Mesg: :<StartHeader> <Version = 3.0> <EndHeader> <StartBO:MY_BO>
BusinessObject = MY_BO
Verb = Retrieve
Locale = en_US
IDSUNO = 400
IDCONO = TST001
AfterDeltaUpdateSP = CxIgnore
AfterRetrieveByContentSP = CxIgnore
AfterRetrieveSP = CxIgnore
AfterRetrieveUpdateSP = CxIgnore
AfterUpdateSP = CxIgnore
BeforeCreateSP = CxIgnore
BeforeDeleteSP = CxIgnore
BeforeDeltaUpdateSP = CxIgnore
BeforeRetrieveByContentSP = CxIgnore
BeforeRetrieveSP = CxIgnore
BeforeRetrieveUpdateSP = CxIgnore
BeforeUpdateSP = CxIgnore
CreateSP = CxIgnore
DeleteSP = CxIgnore
DeltaUpdateSP = CxIgnore
IDALSU = CxIgnore
IDCFI1 = CxIgnore
IDCFI2 = CxIgnore
IDCFI3 = CxIgnore
IDCFI4 = CxIgnore
IDCFI5 = CxIgnore
IDCHID = CxIgnore
IDCHNO = CxIgnore
RetrieveUpdateSP = CxIgnore
IDCOR2 = CxIgnore
IDCORG = CxIgnore
IDCSCD = CxIgnore
AfterDeleteSP = CxIgnore
IDDTFM = CxIgnore
IDECAR = CxIgnore
IDEDIT = CxIgnore
IDHAFE = CxIgnore
IDLMDT = CxIgnore
IDLNCD = CxIgnore
IDMEPF = CxIgnore
IDPHN2 = CxIgnore
IDPHNO = CxIgnore
IDPODA = CxIgnore
IDRGDT = CxIgnore
IDRGTM = CxIgnore
IDSTAT = CxIgnore
IDSUAL = CxIgnore
IDSUCM = CxIgnore
IDSUCO = CxIgnore
IDSUNM = CxIgnore
RetrieveSP = CxIgnore
IDSUTY = CxIgnore
IDTFNO = CxIgnore
IDTIZO = CxIgnore
IDTLNO = CxIgnore
IDTXID = CxIgnore
IDVRNO = CxIgnore
RetrieveByContentSP = CxIgnore
UpdateSP = CxIgnore
IDDESV = CxIgnore
AfterCreateSP = CxIgnore
ObjectEventId = CxIgnore
<EndBO:MY_BO>]
[Time: 2006/06/19 12:08:47.373] [System: ConnectorAgent] [SS: sampleConnector] [Thread: appPolling (#668423413)] [Type: Trace]
[Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering testDBStatus] ]
[Time: 2006/06/19 12:08:47.373] [System: ConnectorAgent] [SS: sampleConnector] [Thread: appPolling (#668423413)] [Type: Trace]
[Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting testDBStatus] ]
[Time: 2006/06/19 12:08:47.373] [System: ConnectorAgent] [SS: sampleConnector] [Thread: appPolling (#668423413)] [Type: Trace]
[Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering releaseConnection] ]
[Time: 2006/06/19 12:08:47.373] [System: ConnectorAgent] [SS: sampleConnector] [Thread: appPolling (#668423413)] [Type: Trace]
[Mesg: :[Type: Trace] [MsgID: 90019] [Mesg: Exiting releaseConnection] ]
[Time: 2006/06/19 12:08:47.373] [System: ConnectorAgent] [SS: sampleConnector] [Thread: appPolling (#668423413)] [Type: Trace]
[Mesg: :
com.crossworlds.cwconnectorapi.exceptions.VerbProcessingFailedException:
[Type: Error] [MsgID: 37011] [Mesg: NumberFormatException occurred while setting the values on the prepared statement]
at com.crossworlds.connectors.JDBC.JDBCBOhandler.doVerbFor(JDBCBOhandler.java:1
601)
at com.crossworlds.cwconnectorapi.CWConnectorBOHandler.doVerbFor(CWConnectorBOH
andler.java:127)
at CxCommon.BusinessObject.doVerbFor(BusinessObject.java:2179)
at com.crossworlds.cwconnectorapi.CWConnectorBusObj.doVerbFor(CWConnectorBusObj
.java:126)
at com.crossworlds.connectors.JDBC.JDBCConnectorAgent.pollForEvents(JDBCConnect
orAgent.java:1299)
at
AppSide_Connector.BusObjJavaInterface.poll(BusObjJavaInterface.java:584)
at AppSide_Connector.AppCalls.poll(AppCalls.java:192)
at AppSide_Connector.AgentBusinessObjectManager.poll(AgentBusinessObjectManager
.java:716)
at AppSide_Connector.AppPolling.poll(AppPolling.java:310)
]
[Time: 2006/06/19 12:08:47.373] [System: ConnectorAgent] [SS: sampleConnector] [Thread: appPolling (#668423413)] [Type: Trace]
[Mesg: :[Type: Trace] [MsgID: 90018] [Mesg: Entering updateEventStatus] ]
[Time: 2006/06/19 12:08:47.467] [System: ConnectorAgent] [SS: sampleConnector] [Thread: appPolling (#668423413)] [Type: Trace]
[Mesg: :[Type: Trace] [MsgID: 37021] [Mesg: Database Commited Successfully] ]
[Time: 2006/06/19 12:08:47.467] [System: ConnectorAgent] [SS: sampleConnector] [Thread: appPolling (#668423413)] [Type: Trace]
[Mesg: :[Type: Trace] [MsgID: 37022] [Mesg: DBManager Operation success] ]