String or binary data would be truncated.

[vishnu_pallamreddy]

Hi All,

Our scenario was proxy to jdbc.

in sxmb_moni i got message "processed successfully".

but in runtime workbench i got "String or binary data would be truncated."

what is the error and reason for this?

Please give me the solution to this issue as soon as possible.

Please any one could provide solutiont to this issue now urgent.

Thnks,

vishnu.

[Former Member · Accepted solution]

Hi Vishnu,

Double check your fields in your jdbc database table to make sure they can handle the length of the data being passed in.

Hope this help.

Regards,

Jo

[vishnu_pallamreddy · Accepted solution]

Hi jo,

i checked so many times but i got same error "String or binary data would be truncated."

                           or

  "java.lang.NumberFormatException".

[Former Member · Accepted solution]

Hi,

Can you plz, paste here full error details you have got and if possible the payload.

Rgds,

Jo

[vishnu_pallamreddy · Accepted solution]

Hi Jo,

some times i got this error

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SAP.usp_InsertEmployeeChange' (structure 'Statement'): com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.

and

some times i got this error.

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SAP.usp_InsertEmployeeChange' (structure 'Statement'): java.lang.NumberFormatException

PayLoad:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?><!-- Response --> <SOAP:Envelope xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SAP="http://sap.com/xi/XI/Message/30"><SOAP:Header><SAP:Main versionMajor="003" versionMinor="001" SOAP:mustUnderstand="1" wsu:Id="wsuid-main-92ABE13F5C59AB7FE10000000A1551F7" xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsu="http://www.docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd"><SAP:MessageClass>ApplicationMessage</SAP:MessageClass><SAP:ProcessingMode>asynchronous</SAP:ProcessingMode><SAP:MessageId>00505686-5997-1EE2-87EB-F1369966EC69</SAP:MessageId><SAP:TimeSent>2012-10-26T11:23:18Z</SAP:TimeSent><SAP:Sender><SAP:Service>DE1CLNT200</SAP:Service><SAP:Interface namespace="urn:Muni.org:Time:PersonnelDataToTimeKeepingSystems">MOAEmployeePersonnelDataAWWU_OUT</SAP:Interface></SAP:Sender><SAP:Receiver><SAP:Party agency="" scheme=""/><SAP:Service>KRONOS_MLP_Time_Business_System_D</SAP:Service><SAP:Interface namespace="urn:KRONOS:MLP:Time:PersonnelDataFromSAP">KRONOSMLPEmployeePersonnelData_In</SAP:Interface><SAP:Mapping notRequired="M"><SAP:ObjectId>my7+S2ghMTaU54AP6sidug==</SAP:ObjectId><SAP:SWCV>Wy/QAFIQEeGFD/A8CqAIfw==</SAP:SWCV><SAP:SP>-1</SAP:SP></SAP:Mapping></SAP:Receiver><SAP:Interface namespace="urn:KRONOS:MLP:Time:PersonnelDataFromSAP">KRONOSMLPEmployeePersonnelData_In</SAP:Interface></SAP:Main><SAP:ReliableMessaging SOAP:mustUnderstand="1" xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/"><SAP:QualityOfService>ExactlyOnce</SAP:QualityOfService></SAP:ReliableMessaging><SAP:HopList SOAP:mustUnderstand="1" xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/"><SAP:Hop timeStamp="2012-10-26T11:23:18Z" wasRead="false"><SAP:Engine type="BS">DE1CLNT200</SAP:Engine><SAP:Adapter namespace="http://sap.com/xi/XI/System">XI</SAP:Adapter><SAP:MessageId>00505686-1DA2-1EE2-87EB-F13066C8BAE7</SAP:MessageId><SAP:Info>3.0</SAP:Info></SAP:Hop><SAP:Hop timeStamp="2012-10-26T11:23:16Z" wasRead="false"><SAP:Engine type="IS">is.06.moaserpdi1</SAP:Engine><SAP:Adapter namespace="http://sap.com/xi/XI/System">XI</SAP:Adapter><SAP:MessageId>00505686-5997-1EE2-87EB-F1369966EC69</SAP:MessageId><SAP:Branch><SAP:MessageId>00505686-5997-1EE2-87EB-F1369966CC69</SAP:MessageId><SAP:Service>AWWU_WTT_Business_System_D</SAP:Service></SAP:Branch><SAP:Branch><SAP:MessageId>00505686-5997-1EE2-87EB-F1369966EC69</SAP:MessageId><SAP:Service>KRONOS_MLP_Time_Business_System_D</SAP:Service></SAP:Branch><SAP:Info>3.0</SAP:Info></SAP:Hop></SAP:HopList><SAP:RunTime xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/"><SAP:Date>20121026</SAP:Date><SAP:Time>032316</SAP:Time><SAP:Host>MOASERPDI1</SAP:Host><SAP:SystemId>DI1</SAP:SystemId><SAP:SystemNr>06</SAP:SystemNr><SAP:OS>Windows NT</SAP:OS><SAP:DB>MSSQL</SAP:DB><SAP:Language/><SAP:ProcStatus>003</SAP:ProcStatus><SAP:AdapterStatus>000</SAP:AdapterStatus><SAP:User>PIAPPLDI1</SAP:User><SAP:TraceLevel>3</SAP:TraceLevel><SAP:Logging>1</SAP:Logging><SAP:LogSeqNbr>005</SAP:LogSeqNbr><SAP:RetryLogSeqNbr>000</SAP:RetryLogSeqNbr><SAP:PipelineIdInternal>SAP_CENTRAL</SAP:PipelineIdInternal><SAP:PipelineIdExternal>CENTRAL</SAP:PipelineIdExternal><SAP:PipelineElementId/><SAP:PipelineStartElementId>5EC3C53B4BB7B62DE10000000A1148F5</SAP:PipelineStartElementId><SAP:PipelineService/><SAP:QIdInternal>XBTO5___0000</SAP:QIdInternal><SAP:CommitActor>X</SAP:CommitActor><SAP:ParentId ChildNo="0" ChildTotal="0">005056861DA21EE287EBF13066C8BAE7</SAP:ParentId><SAP:SplitNumber>0</SAP:SplitNumber><SAP:NumberOfRetries>0</SAP:NumberOfRetries><SAP:NumberOfManualRetries>0</SAP:NumberOfManualRetries><SAP:TypeOfEngine client="100">CENTRAL</SAP:TypeOfEngine><SAP:PlsrvExceptionCode/><SAP:EOReferenceRuntime type="TID">0AA0087F1348508A72A50117</SAP:EOReferenceRuntime><SAP:EOReferenceInbound type="TID"/><SAP:EOReferenceOutbound type="TID"/><SAP:MessageSizePayload>2479</SAP:MessageSizePayload><SAP:MessageSizeTotal>40789</SAP:MessageSizeTotal><SAP:PayloadSizeRequest>2479</SAP:PayloadSizeRequest><SAP:PayloadSizeRequestMap>4323</SAP:PayloadSizeRequestMap><SAP:PayloadSizeResponse>0</SAP:PayloadSizeResponse><SAP:PayloadSizeResponseMap>0</SAP:PayloadSizeResponseMap><SAP:Reorganization>INI</SAP:Reorganization><SAP:AdapterInbound>IENGINE</SAP:AdapterInbound><SAP:AdapterOutbound>AENGINE</SAP:AdapterOutbound><SAP:InterfaceAction>DEL</SAP:InterfaceAction><SAP:RandomNumber>45</SAP:RandomNumber><SAP:AckStatus>000</SAP:AckStatus><SAP:SkipReceiverDetermination/><SAP:QueueLocation>3</SAP:QueueLocation><SAP:Sender_Agreement_GUID>55772ACE009A396794576E5A81DE81E6</SAP:Sender_Agreement_GUID><SAP:Receiver_Agreement_GUID>47FAAF5D9CE93BD38F76E319C3BF593C</SAP:Receiver_Agreement_GUID><SAP:Serialize_Children>X</SAP:Serialize_Children><SAP:VersionPayloadRef>004</SAP:VersionPayloadRef></SAP:RunTime><SAP:PerformanceHeader xmlns:SAP="http://sap.com/xi/XI/Message/30"><SAP:RunTimeItem><SAP:Name type="ADAPTER_IN">INTEGRATION_ENGINE_HTTP_ENTRY</SAP:Name><SAP:Timestamp type="begin" host="MOASERPDI1">20121026112316.728</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="ADAPTER_IN">INTEGRATION_ENGINE_HTTP_ENTRY</SAP:Name><SAP:Timestamp type="end" host="MOASERPDI1">20121026112316.745</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="CORE">INTEGRATION_ENGINE</SAP:Name><SAP:Timestamp type="begin" host="MOASERPDI1">20121026112316.746</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="CORE">INTEGRATION_ENGINE</SAP:Name><SAP:Timestamp type="end" host="MOASERPDI1">20121026112316.749</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="DBQUEUE">DB_ENTRY_QUEUING</SAP:Name><SAP:Timestamp type="begin" host="MOASERPDI1">20121026112316.749</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">PLSRV_XML_VALIDATION_RQ_INB</SAP:Name><SAP:Timestamp type="begin" host="MOASERPDI1">20121026112316.75</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">PLSRV_XML_VALIDATION_RQ_INB</SAP:Name><SAP:Timestamp type="end" host="MOASERPDI1">20121026112316.752</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">PLSRV_RECEIVER_DETERMINATION</SAP:Name><SAP:Timestamp type="begin" host="MOASERPDI1">20121026112316.776</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">PLSRV_RECEIVER_DETERMINATION</SAP:Name><SAP:Timestamp type="end" host="MOASERPDI1">20121026112316.782</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">PLSRV_INTERFACE_DETERMINATION</SAP:Name><SAP:Timestamp type="begin" host="MOASERPDI1">20121026112316.791</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">PLSRV_INTERFACE_DETERMINATION</SAP:Name><SAP:Timestamp type="end" host="MOASERPDI1">20121026112316.794</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">PLSRV_RECEIVER_MESSAGE_SPLIT</SAP:Name><SAP:Timestamp type="begin" host="MOASERPDI1">20121026112316.802</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">PLSRV_RECEIVER_MESSAGE_SPLIT</SAP:Name><SAP:Timestamp type="end" host="MOASERPDI1">20121026112316.825</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="DBQUEUE">DB_SPLITTER_QUEUING</SAP:Name><SAP:Timestamp type="begin" host="MOASERPDI1">20121026112316.825</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="DBQUEUE">DB_SPLITTER_QUEUING</SAP:Name><SAP:Timestamp type="end" host="MOASERPDI1">20121026112316.965</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">PLSRV_MAPPING_REQUEST</SAP:Name><SAP:Timestamp type="begin" host="MOASERPDI1">20121026112316.979</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">PLSRV_MAPPING_REQUEST</SAP:Name><SAP:Timestamp type="end" host="MOASERPDI1">20121026112317.003</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">PLSRV_OUTBOUND_BINDING</SAP:Name><SAP:Timestamp type="begin" host="MOASERPDI1">20121026112317.067</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">PLSRV_OUTBOUND_BINDING</SAP:Name><SAP:Timestamp type="end" host="MOASERPDI1">20121026112317.105</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">PLSRV_XML_VALIDATION_RQ_OUT</SAP:Name><SAP:Timestamp type="begin" host="MOASERPDI1">20121026112317.151</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">PLSRV_XML_VALIDATION_RQ_OUT</SAP:Name><SAP:Timestamp type="end" host="MOASERPDI1">20121026112317.152</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">PLSRV_CALL_ADAPTER</SAP:Name><SAP:Timestamp type="begin" host="MOASERPDI1">20121026112317.206</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">HTTP_SEND</SAP:Name><SAP:Timestamp type="begin" host="MOASERPDI1">20121026112317.212</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">HTTP_SEND</SAP:Name><SAP:Timestamp type="end" host="MOASERPDI1">20121026112317.363</SAP:Timestamp></SAP:RunTimeItem><SAP:RunTimeItem><SAP:Name type="PLSRV">PLSRV_CALL_ADAPTER</SAP:Name><SAP:Timestamp type="end" host="MOASERPDI1">20121026112317.364</SAP:Timestamp></SAP:RunTimeItem></SAP:PerformanceHeader><SAP:System SOAP:mustUnderstand="1" xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/"><SAP:Record namespace="http://www.sap.com/webas/712/soap/features/runtime/metering/" name="CallingType">SA</SAP:Record></SAP:System><SAP:Diagnostic SOAP:mustUnderstand="1" xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/"><SAP:TraceLevel>Information</SAP:TraceLevel><SAP:Logging>Off</SAP:Logging></SAP:Diagnostic><SAP:OutboundBinding xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/"><SAP:OutboundBindingEntry version="30"><SAP:OutboundBindingObjectId>47FAAF5D9CE93BD38F76E319C3BF593C</SAP:OutboundBindingObjectId><SAP:FromPartyName/><SAP:FromServiceName>DE1CLNT200</SAP:FromServiceName><SAP:ToPartyName/><SAP:ToServiceName>KRONOS_MLP_Time_Business_System_D</SAP:ToServiceName><SAP:ToInterfaceName>KRONOSMLPEmployeePersonnelData_In</SAP:ToInterfaceName><SAP:ToInterfaceNamespace>urn:KRONOS:MLP:Time:PersonnelDataFromSAP</SAP:ToInterfaceNamespace><SAP:OutboundBindingAttributes><SAP:AdapterTypeData/></SAP:OutboundBindingAttributes><SAP:HeaderMapping><SAP:FieldMapping/></SAP:HeaderMapping><SAP:ChannelEntry version="30"><SAP:PartyName>*</SAP:PartyName><SAP:ServiceName>KRONOS_MLP_Time_Business_System_D</SAP:ServiceName><SAP:ChannelName>JDBCReceiverKRONOSMLPEmployeePersonnelData</SAP:ChannelName><SAP:AdapterName>JDBC</SAP:AdapterName><SAP:AdapterNamespace>http://sap.com/xi/XI/System</SAP:AdapterNamespace><SAP:AdapterSWCV>8ED90F952DA411DEA915D23A0A424100</SAP:AdapterSWCV><SAP:AdapterEngineType>AE</SAP:AdapterEngineType><SAP:AdapterEngineName/><SAP:MessageProtocol>XML_SQL</SAP:MessageProtocol><SAP:MessageProtocolVersion>3.0.0527</SAP:MessageProtocolVersion><SAP:TransportProtocol>JDBC</SAP:TransportProtocol><SAP:TransportProtocolVersion/><SAP:ChannelDirection>O</SAP:ChannelDirection><SAP:FromPartyAgency/><SAP:FromPartySchema/><SAP:ToPartySchema/><SAP:ToPartyAgency/><SAP:ChannelAttributes><SAP:AdapterTypeData/></SAP:ChannelAttributes></SAP:ChannelEntry></SAP:OutboundBindingEntry></SAP:OutboundBinding><SAP:Trace xmlns:SAP="http://sap.com/xi/XI/Message/30"><Trace level="1" type="T">Party normalization: sender </Trace>

<Trace level="3" type="T">Sender scheme external = </Trace>

<Trace level="3" type="T">Sender agency external = </Trace>

<Trace level="3" type="T">Sender party external = </Trace>

<Trace level="3" type="T">Sender party normalized = </Trace>

<Trace level="1" type="T">Determining the sender agreement </Trace>

<Trace level="3" type="T">##### DG: 0</Trace>

<Trace level="3" type="T">##### TO: 3</Trace>

<Trace level="1" type="T">XMB was called with URL /sap/xi/engine?type=entry</Trace>

<Trace level="2" type="T">Request Line = POST /sap/xi/engine?type=entry HTTP/1.0</Trace>

<Trace level="2" type="T">Host = moaserpdi1.muniverse.net:50600</Trace>

<Trace level="2" type="T">Server protocol = HTTP/1.0</Trace>

<Trace level="2" type="T">Remote address = 10.160.8.204</Trace>

<Trace level="1" type="T">User = PIAPPLDI1</Trace>

<Trace level="1" type="T">Process ID: 4936</Trace>

<Trace level="1" type="T">Work Process ID: 14 </Trace>

<Trace level="1" type="T">Message ID = 005056861DA21EE287EBF13066C8BAE7</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-ENTER_XMS">

<Trace level="1" type="T">CL_XMS_MAIN-&gt;DETERMINE_EXT_PID: CENTRAL</Trace>

<Trace level="3" type="T">##### DG: 0</Trace>

<Trace level="3" type="T">##### TO: 3</Trace>

<Trace level="1" type="T">Hop engine name = is.06.moaserpdi1</Trace>

<Trace level="1" type="T">Hop engine type = IS</Trace>

<Trace level="1" type="T">Hop adapter name = XI</Trace>

<Trace level="1" type="T">Hop adapter namespace = http://sap.com/xi/XI/System</Trace>

<Trace level="1" type="B" name="CL_XMS_TROUBLESHOOT-ENTER_PLSRV">

<Trace level="3" type="T">No triggers found. OK. </Trace>

</Trace>

<Trace level="3" type="T">system-ID = DI1</Trace>

<Trace level="3" type="T">client = 100</Trace>

<Trace level="3" type="T">language = E</Trace>

<Trace level="3" type="T">user = PIAPPLDI1</Trace>

<Trace level="1" type="Timestamp">2012-10-26T11:23:16Z ALA  </Trace>

</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_UC_EXECUTE"></Trace><!-- ************************************ -->

<Trace level="1" type="T">PLNAME = CENTRAL</Trace>

<Trace level="1" type="T">QOS = EO</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PIPELINE_ASYNC">

<Trace level="3" type="T">QOS = EO</Trace>

<Trace level="3" type="T">Generate prefixed queue name </Trace>

<Trace level="1" type="T">Queue name : XBTI0008</Trace>

<Trace level="1" type="T">Going to persist message </Trace>

</Trace>

<Trace level="3" type="T">Version number = 000</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PIPELINE_SYNC">

<Trace level="1" type="T">&gt;&gt;&gt;PID delete old pid determination coding </Trace>

<Trace level="3" type="T">Pipeline-Elements for pipeline SAP_CENTRAL</Trace>

<Trace level="3" type="T">0001 PLSRV_XML_VALIDATION_RQ_INB</Trace>

<Trace level="3" type="T">0002 PLSRV_RECEIVER_DETERMINATION</Trace>

<Trace level="3" type="T">0003 PLSRV_INTERFACE_DETERMINATION</Trace>

<Trace level="3" type="T">0004 PLSRV_RECEIVER_MESSAGE_SPLIT</Trace>

<Trace level="3" type="T">0005 PLSRV_MAPPING_REQUEST</Trace>

<Trace level="3" type="T">0006 PLSRV_OUTBOUND_BINDING</Trace>

<Trace level="3" type="T">0007 PLSRV_XML_VALIDATION_RQ_OUT</Trace>

<Trace level="3" type="T">0008 PLSRV_CALL_ADAPTER</Trace>

<Trace level="3" type="T">0009 PLSRV_XML_VALIDATION_RS_INB</Trace>

<Trace level="3" type="T">0010 PLSRV_MAPPING_RESPONSE</Trace>

<Trace level="3" type="T">0011 PLSRV_XML_VALIDATION_RS_OUT</Trace>

<Trace level="1" type="Timestamp">2012-10-26T11:23:16Z ALA Begin of pipeline processing PLSRVID = CENTRAL</Trace>

<Trace level="1" type="B" name="PLSRV_XML_VALIDATION_RQ_INB">

<Trace level="1" type="Timestamp">2012-10-26T11:23:16Z ALA Start of pipeline service processing PLSRVID= PLSRV_XML_VALIDATION_RQ_INB</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV">

<Trace level="3" type="T">Calling pipeline service: PLSRV_XML_VALIDATION_RQ_INB</Trace>

<Trace level="3" type="T">Reading Pipeline-Service specification... </Trace>

<Trace level="3" type="T">PLSRVTYPE  = </Trace>

<Trace level="3" type="T">ADRESSMOD  = LOCAL</Trace>

<Trace level="3" type="T">P_CLASS    = CL_XMS_PLSRV_VALIDATION</Trace>

<Trace level="3" type="T">P_IFNAME   = IF_XMS_PLSRV</Trace>

<Trace level="3" type="T">P_METHOD   = ENTER_PLSRV</Trace>

<Trace level="3" type="T"> </Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV_LOCAL">

<Trace level="1" type="B" name="CL_XMS_PLSRV_VALIDATION-ENTER_PLSRV">

<Trace level="3" type="T">Pipeline Service = PLSRV_XML_VALIDATION_RQ_INB </Trace>

<Trace level="3" type="T">Skip Inbound Validation =  </Trace>

<Trace level="3" type="T">Skip Outbound Validation =  </Trace>

<Trace level="3" type="T">Area = XML_VALIDATION_INB </Trace>

<Trace level="1" type="T">Reading sender agreement </Trace>

<Trace level="3" type="T">Validation Mode = No Validation </Trace>

<Trace level="1" type="T">Inbound validation by Integration Engine does not take place </Trace>

</Trace>

</Trace>

</Trace>

<Trace level="1" type="Timestamp">2012-10-26T11:23:16Z ALA End of pipeline service processing PLSRVID= PLSRV_XML_VALIDATION_RQ_INB</Trace>

</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-WRITE_MESSAGE_LOG_TO_PERSIST">

<Trace level="2" type="T">Persisting original message </Trace>

<Trace level="3" type="T">Message-Version = 000</Trace>

<Trace level="3" type="T">Pipeline CENTRAL</Trace>

<Trace level="1" type="T">--start of determination of sender interface action </Trace>

<Trace level="1" type="T">select interface MOAEmployeePersonnelDataAWWU_OUT</Trace>

<Trace level="1" type="T">select interface namespace urn:Muni.org:Time:PersonnelDataToTimeKeepingSystems</Trace>

<Trace level="1" type="T">no interface action for sender found </Trace>

<Trace level="1" type="T">hence keep interface action INIT</Trace>

<Trace level="1" type="T">--end of determination of sender interface action </Trace>

</Trace>

<Trace level="1" type="B" name="PLSRV_RECEIVER_DETERMINATION">

<Trace level="1" type="Timestamp">2012-10-26T11:23:16Z ALA Start of pipeline service processing PLSRVID= PLSRV_RECEIVER_DETERMINATION</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV">

<Trace level="3" type="T">Calling pipeline service: PLSRV_RECEIVER_DETERMINATION</Trace>

<Trace level="3" type="T">Reading Pipeline-Service specification... </Trace>

<Trace level="3" type="T">PLSRVTYPE  = </Trace>

<Trace level="3" type="T">ADRESSMOD  = LOCAL</Trace>

<Trace level="3" type="T">P_CLASS    = CL_RD_PLSRV</Trace>

<Trace level="3" type="T">P_IFNAME   = IF_XMS_PLSRV</Trace>

<Trace level="3" type="T">P_METHOD   = ENTER_PLSRV</Trace>

<Trace level="3" type="T"> </Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV_LOCAL">

<Trace level="1" type="B" name="CL_RD_PLSRV-ENTER_PLSRV">

<Trace level="1" type="T">R E C E I V E R - D E T E R M I N A T I O N </Trace>

<Trace level="1" type="T"> Cache content is up to date </Trace>

<Trace level="2" type="T">Start without given receiver </Trace>

<Trace level="2" type="T">Using Receiver Determination 98A9A572755E3A23AF23DB5B0BE3BD8C </Trace>

<Trace level="2" type="T">Classic Receiver Determination via Rules. </Trace>

<Trace level="3" type="T">...create rule engine </Trace>

<Trace level="2" type="T">Check conditions for rule line no. 1  </Trace>

<Trace level="2" type="T">...valid Receiver w/o Condition:  - KRONOS_MLP_Time_Business_System_D </Trace>

<Trace level="2" type="T">Check conditions for rule line no. 2  </Trace>

<Trace level="2" type="T">...valid Receiver w/o Condition:  - AWWU_WTT_Business_System_D </Trace>

<Trace level="2" type="T">No Receiver found behaviour: 0  </Trace>

<Trace level="2" type="T">Number of Receivers:2  </Trace>

</Trace>

</Trace>

</Trace>

<Trace level="1" type="Timestamp">2012-10-26T11:23:16Z ALA End of pipeline service processing PLSRVID= PLSRV_RECEIVER_DETERMINATION</Trace>

</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-WRITE_MESSAGE_LOG_TO_PERSIST">

<Trace level="3" type="T">Persisting message after plsrv call </Trace>

<Trace level="3" type="T">Message-Version = 001</Trace>

<Trace level="3" type="T">Pipeline CENTRAL</Trace>

</Trace>

<Trace level="1" type="B" name="PLSRV_INTERFACE_DETERMINATION">

<Trace level="1" type="Timestamp">2012-10-26T11:23:16Z ALA Start of pipeline service processing PLSRVID= PLSRV_INTERFACE_DETERMINATION</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV">

<Trace level="3" type="T">Calling pipeline service: PLSRV_INTERFACE_DETERMINATION</Trace>

<Trace level="3" type="T">Reading Pipeline-Service specification... </Trace>

<Trace level="3" type="T">PLSRVTYPE  = </Trace>

<Trace level="3" type="T">ADRESSMOD  = LOCAL</Trace>

<Trace level="3" type="T">P_CLASS    = CL_ID_PLSRV</Trace>

<Trace level="3" type="T">P_IFNAME   = IF_XMS_PLSRV</Trace>

<Trace level="3" type="T">P_METHOD   = ENTER_PLSRV</Trace>

<Trace level="3" type="T"> </Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV_LOCAL">

<Trace level="1" type="B" name="CL_ID_PLSRV-ENTER_PLSRV">

<Trace level="1" type="T">I N T E R F A C E - D E T E R M I N A T I O N </Trace>

<Trace level="1" type="T"> Cache content is up to date </Trace>

<Trace level="2" type="T">Check conditions for (Inb: Party Srvc If)  AWWU_WTT_Business_System_D AWWUWTTPersonnelData_In </Trace>

<Trace level="2" type="T">...valid InbIf without Condition: AWWUWTTPersonnelData_In </Trace>

<Trace level="2" type="T">Check conditions for (Inb: Party Srvc If)  KRONOS_MLP_Time_Business_System_D KRONOSMLPEmployeePersonnelData_In </Trace>

<Trace level="2" type="T">...valid InbIf without Condition: KRONOSMLPEmployeePersonnelData_In </Trace>

<Trace level="2" type="T">Number of receiving Interfaces:2  </Trace>

</Trace>

</Trace>

</Trace>

<Trace level="1" type="Timestamp">2012-10-26T11:23:16Z ALA End of pipeline service processing PLSRVID= PLSRV_INTERFACE_DETERMINATION</Trace>

</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-WRITE_MESSAGE_LOG_TO_PERSIST">

<Trace level="3" type="T">Persisting message after plsrv call </Trace>

<Trace level="3" type="T">Message-Version = 002</Trace>

<Trace level="3" type="T">Pipeline CENTRAL</Trace>

</Trace>

<Trace level="1" type="B" name="PLSRV_RECEIVER_MESSAGE_SPLIT"></Trace><!-- ************************************ -->

<Trace level="1" type="Timestamp">2012-10-26T11:23:16Z ALA Start of pipeline service processing PLSRVID= PLSRV_RECEIVER_MESSAGE_SPLIT</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV">

<Trace level="3" type="T">Calling pipeline service: PLSRV_RECEIVER_MESSAGE_SPLIT</Trace>

<Trace level="3" type="T">Reading Pipeline-Service specification... </Trace>

<Trace level="3" type="T">PLSRVTYPE  = </Trace>

<Trace level="3" type="T">ADRESSMOD  = LOCAL</Trace>

<Trace level="3" type="T">P_CLASS    = CL_XMS_PLSRV_RECEIVER_SPLIT2</Trace>

<Trace level="3" type="T">P_IFNAME   = IF_XMS_PLSRV</Trace>

<Trace level="3" type="T">P_METHOD   = ENTER_PLSRV</Trace>

<Trace level="3" type="T"> </Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV_LOCAL">

<Trace level="1" type="B" name="CL_XMS_PLSRV_RECEIVER_SPLIT2->ENTER_PLSRV"></Trace><!-- ************************************ -->

<Trace level="1" type="T">number of receivers: 2 </Trace>

<Trace level="1" type="T">Multi-receiver split case </Trace>

<Trace level="1" type="T">----------------------------------------------- </Trace>

<Trace level="1" type="T">Splitting loop start </Trace>

<Trace level="1" type="T">----------------------------------------------- </Trace>

<Trace level="2" type="T">child 1 </Trace>

<Trace level="1" type="T">Post-split internal queue name = XBTOK___0000</Trace>

<Trace level="1" type="T">Persisting split kid = 0050568659971EE287EBF1369966CC69</Trace>

<Trace level="1" type="T">Generated prefixed queue name = </Trace>

<Trace level="1" type="T">Schedule message in qRFC environment </Trace>

<Trace level="3" type="T">Setup qRFC Scheduler </Trace>

<Trace level="3" type="T">Call qRFC .... MsgGuid = 0050568659971EE287EBF1369966CC69</Trace>

<Trace level="3" type="T">Call qRFC .... Version = 000</Trace>

<Trace level="3" type="T">Call qRFC .... Pipeline = CENTRAL</Trace>

<Trace level="3" type="T">OK. </Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-WRITE_MESSAGE_TO_PERSIST">

<Trace level="3" type="T">Persisting message Status = 012</Trace>

<Trace level="3" type="T">Message version 000</Trace>

<Trace level="3" type="T">Pipeline CENTRAL</Trace>

<Trace level="1" type="T">--start of determination of sender interface action </Trace>

<Trace level="1" type="T">select interface MOAEmployeePersonnelDataAWWU_OUT</Trace>

<Trace level="1" type="T">select interface namespace urn:Muni.org:Time:PersonnelDataToTimeKeepingSystems</Trace>

<Trace level="1" type="T">no interface action for sender found </Trace>

<Trace level="1" type="T">hence keep interface action INIT</Trace>

<Trace level="1" type="T">--end of determination of sender interface action </Trace>

<Trace level="1" type="T">--start of determination of receiver interface action </Trace>

<Trace level="1" type="T">loop 0000000001</Trace>

<Trace level="1" type="T">select interface AWWUWTTPersonnelData_In</Trace>

<Trace level="1" type="T">select interface namespace urn:www.AWWU.com:TM:TimeDataFromSAP</Trace>

<Trace level="1" type="T">end of loop 0000000001</Trace>

<Trace level="1" type="T">no interface action for sender or receiver found </Trace>

<Trace level="1" type="T">hence set interface action to DEL</Trace>

<Trace level="1" type="T">--end of determination of receiver interface action </Trace>

</Trace>

<Trace level="2" type="T">child 2 </Trace>

<Trace level="1" type="T">Post-split internal queue name = XBTO5___0000</Trace>

<Trace level="1" type="T">Persisting split kid = 0050568659971EE287EBF1369966EC69</Trace>

<Trace level="1" type="T">Generated prefixed queue name = </Trace>

<Trace level="1" type="T">Schedule message in qRFC environment </Trace>

<Trace level="3" type="T">Setup qRFC Scheduler </Trace>

<Trace level="3" type="T">Call qRFC .... MsgGuid = 0050568659971EE287EBF1369966EC69</Trace>

<Trace level="3" type="T">Call qRFC .... Version = 000</Trace>

<Trace level="3" type="T">Call qRFC .... Pipeline = CENTRAL</Trace>

<Trace level="3" type="T">OK. </Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-WRITE_MESSAGE_TO_PERSIST"></Trace><!-- ************************************ -->

<Trace level="3" type="T">Persisting message Status = 012</Trace>

<Trace level="3" type="T">Message version 000</Trace>

<Trace level="3" type="T">Pipeline CENTRAL</Trace>

<Trace level="1" type="T">--start of determination of sender interface action </Trace>

<Trace level="1" type="T">select interface MOAEmployeePersonnelDataAWWU_OUT</Trace>

<Trace level="1" type="T">select interface namespace urn:Muni.org:Time:PersonnelDataToTimeKeepingSystems</Trace>

<Trace level="1" type="T">no interface action for sender found </Trace>

<Trace level="1" type="T">hence keep interface action INIT</Trace>

<Trace level="1" type="T">--end of determination of sender interface action </Trace>

<Trace level="1" type="T">--start of determination of receiver interface action </Trace>

<Trace level="1" type="T">loop 0000000001</Trace>

<Trace level="1" type="T">select interface KRONOSMLPEmployeePersonnelData_In</Trace>

<Trace level="1" type="T">select interface namespace urn:KRONOS:MLP:Time:PersonnelDataFromSAP</Trace>

<Trace level="1" type="T">end of loop 0000000001</Trace>

<Trace level="1" type="T">no interface action for sender or receiver found </Trace>

<Trace level="1" type="T">hence set interface action to DEL</Trace>

<Trace level="1" type="T">--end of determination of receiver interface action </Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-PERSIST_READ_MESSAGE">

<Trace level="3" type="T">Message was read from persist layer. OK. </Trace>

<Trace level="3" type="T">Message properties in XMB object were setup. OK. </Trace>

</Trace>

<Trace level="1" type="T">Process ID: 11660</Trace>

<Trace level="1" type="T">Work Process ID: 16 </Trace>

<Trace level="3" type="T">message version successfully read from persist version= 000</Trace>

<Trace level="2" type="T">Increment log sequence to 001</Trace>

<Trace level="1" type="T">Exception from packaging: No messages for constructing a package available.</Trace>

<Trace level="1" type="T">Continue single processing </Trace>

<Trace level="3" type="T">##### DG: 0</Trace>

<Trace level="3" type="T">##### TO: 3</Trace>

<Trace level="1" type="T">Starting async processing with pipeline CENTRAL</Trace>

<Trace level="3" type="T">system-ID = DI1</Trace>

<Trace level="3" type="T">client = 100</Trace>

<Trace level="3" type="T">language = E</Trace>

<Trace level="3" type="T">user = PIAPPLDI1</Trace>

<Trace level="1" type="Timestamp">2012-10-26T11:23:16Z ALA  </Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PIPELINE_SYNC"></Trace><!-- ************************************ -->

<Trace level="1" type="T">&gt;&gt;&gt;PID delete old pid determination coding </Trace>

<Trace level="3" type="T">Pipeline-Elements for pipeline SAP_CENTRAL</Trace>

<Trace level="3" type="T">0001 PLSRV_XML_VALIDATION_RQ_INB</Trace>

<Trace level="3" type="T">0002 PLSRV_RECEIVER_DETERMINATION</Trace>

<Trace level="3" type="T">0003 PLSRV_INTERFACE_DETERMINATION</Trace>

<Trace level="3" type="T">0004 PLSRV_RECEIVER_MESSAGE_SPLIT</Trace>

<Trace level="3" type="T">0005 PLSRV_MAPPING_REQUEST</Trace>

<Trace level="3" type="T">0006 PLSRV_OUTBOUND_BINDING</Trace>

<Trace level="3" type="T">0007 PLSRV_XML_VALIDATION_RQ_OUT</Trace>

<Trace level="3" type="T">0008 PLSRV_CALL_ADAPTER</Trace>

<Trace level="3" type="T">0009 PLSRV_XML_VALIDATION_RS_INB</Trace>

<Trace level="3" type="T">0010 PLSRV_MAPPING_RESPONSE</Trace>

<Trace level="3" type="T">0011 PLSRV_XML_VALIDATION_RS_OUT</Trace>

<Trace level="1" type="Timestamp">2012-10-26T11:23:16Z ALA Begin of pipeline processing PLSRVID = CENTRAL</Trace>

<Trace level="1" type="T">Start with pipeline element PLEL= 5EC3C53B4BB7B62DE10000000A1148F5</Trace>

<Trace level="1" type="B" name="PLSRV_MAPPING_REQUEST">

<Trace level="1" type="Timestamp">2012-10-26T11:23:16Z ALA Start of pipeline service processing PLSRVID= PLSRV_MAPPING_REQUEST</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV">

<Trace level="3" type="T">Calling pipeline service: PLSRV_MAPPING_REQUEST</Trace>

<Trace level="3" type="T">Reading Pipeline-Service specification... </Trace>

<Trace level="3" type="T">PLSRVTYPE  = </Trace>

<Trace level="3" type="T">ADRESSMOD  = LOCAL</Trace>

<Trace level="3" type="T">P_CLASS    = CL_MAPPING_XMS_PLSRV3</Trace>

<Trace level="3" type="T">P_IFNAME   = IF_XMS_PLSRV</Trace>

<Trace level="3" type="T">P_METHOD   = ENTER_PLSRV</Trace>

<Trace level="3" type="T"> </Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV_LOCAL">

<Trace level="1" type="B" name="CL_MAPPING_XMS_PLSRV3-ENTER_PLSRV">

<Trace level="2" type="T">......attachment XI_Context not found </Trace>

<Trace level="3" type="T">Mapping already defined in interface determination </Trace>

<Trace level="3" type="T">Object ID of Interface Mapping 9B2EFE4B6821313694E7800FEAC89DBA </Trace>

<Trace level="3" type="T">Version ID of Interface Mapping 5B2FD000521011E1850FF03C0AA0087F </Trace>

<Trace level="1" type="T">Interface Mapping urn:Muni.org:Time:PersonnelDataToTimeKeepingSystems MOAEmployeePersonnelData_Out_to_KRONOSMLPEmployeePersonnelData_In_OM </Trace>

<Trace level="3" type="T">Mapping Steps 1  JAVA_JDK com/sap/xi/tf/_MOAEmployeePersonnelData_to_KRONOSMLPEmployeePersonnelData_MM_ </Trace>

<Trace level="3" type="T">MTOM Attachments are Transferred to the Payload </Trace>

<Trace level="3" type="T">Dynamic Configuration Is Empty </Trace>

<Trace level="2" type="T">Mode 0  </Trace>

<Trace level="2" type="T">Call method execute of the application Java mapping com.sap.xi.tf._MOAEmployeePersonnelData_to_KRONOSMLPEmployeePersonnelData_MM_ </Trace>

<Trace level="1" type="T"> *** START APPLICATION TRACE *** </Trace>

<Trace level="3" type="T">Document start </Trace>

<Trace level="3" type="T">Start tag [ns1:KRONOSMLPEmployeePersonnelData] </Trace>

<Trace level="3" type="T">Add raw attribute [ xmlns:ns1=&quot;urn:KRONOS:MLP:Time:PersonnelDataFromSAP&quot;] </Trace>

<Trace level="3" type="T">Start tag [Statement] </Trace>

<Trace level="3" type="T">Start tag [usp_InsertEmployeeChange] </Trace>

<Trace level="3" type="T">Add attribute: [Action]=[EXECUTE] </Trace>

<Trace level="3" type="T">Start tag [table] </Trace>

<Trace level="3" type="T">Put value [SAP.usp_InsertEmployeeChange] </Trace>

<Trace level="3" type="T">Close tag [table] </Trace>

<Trace level="3" type="T">Start tag [Employee_ID] </Trace>

<Trace level="3" type="T">Add attribute: [isInput]=[true] </Trace>

<Trace level="3" type="T">Add attribute: [type]=[numeric] </Trace>

<Trace level="3" type="T">Put value [70000075] </Trace>

<Trace level="3" type="T">Close tag [Employee_ID] </Trace>

<Trace level="3" type="T">Start tag [Effective_Date] </Trace>

<Trace level="3" type="T">Add attribute: [isInput]=[true] </Trace>

<Trace level="3" type="T">Add attribute: [type]=[date] </Trace>

<Trace level="3" type="T">Put value [2012-01-02] </Trace>

<Trace level="3" type="T">Close tag [Effective_Date] </Trace>

<Trace level="3" type="T">Start tag [Department_ID] </Trace>

<Trace level="3" type="T">Add attribute: [isInput]=[true] </Trace>

<Trace level="3" type="T">Add attribute: [type]=[varchar] </Trace>

<Trace level="3" type="T">Put value [850725] </Trace>

<Trace level="3" type="T">Close tag [Department_ID] </Trace>

<Trace level="3" type="T">Start tag [Full_Time_Equivalent] </Trace>

<Trace level="3" type="T">Add attribute: [isInput]=[true] </Trace>

<Trace level="3" type="T">Add attribute: [type]=[numeric] </Trace>

<Trace level="3" type="T">Put value [1.00] </Trace>

<Trace level="3" type="T">Close tag [Full_Time_Equivalent] </Trace>

<Trace level="3" type="T">Start tag [Standard_Hours] </Trace>

<Trace level="3" type="T">Add attribute: [isInput]=[true] </Trace>

<Trace level="3" type="T">Add attribute: [type]=[numeric] </Trace>

<Trace level="3" type="T">Put value [40.00] </Trace>

<Trace level="3" type="T">Close tag [Standard_Hours] </Trace>

<Trace level="3" type="T">Start tag [Birthdate] </Trace>

<Trace level="3" type="T">Add attribute: [isInput]=[true] </Trace>

<Trace level="3" type="T">Add attribute: [type]=[date] </Trace>

<Trace level="3" type="T">Put value [1974-08-02] </Trace>

<Trace level="3" type="T">Close tag [Birthdate] </Trace>

<Trace level="3" type="T">Start tag [First_Name] </Trace>

<Trace level="3" type="T">Add attribute: [isInput]=[true] </Trace>

<Trace level="3" type="T">Add attribute: [type]=[varchar] </Trace>

<Trace level="3" type="T">Put value [Robert] </Trace>

<Trace level="3" type="T">Close tag [First_Name] </Trace>

<Trace level="3" type="T">Start tag [Middle_Name] </Trace>

<Trace level="3" type="T">Add attribute: [isInput]=[true] </Trace>

<Trace level="3" type="T">Add attribute: [type]=[varchar] </Trace>

<Trace level="3" type="T">Put value [m] </Trace>

<Trace level="1" type="T"> *** TRACE TRUNCATED (for more details see Visual Administrator -&gt; LogViewer)*** </Trace>

<Trace level="1" type="T">#Dynamic Header entries= 0000000000 </Trace>

<Trace level="3" type="T">Dynamic Configuration Is Empty </Trace>

<Trace level="1" type="T">attachments  #remove= 000000 #set= 000000 #copy= 000000 </Trace>

<Trace level="1" type="T">ContentType application/xml </Trace>

</Trace>

</Trace>

</Trace>

<Trace level="1" type="Timestamp">2012-10-26T11:23:17Z ALA End of pipeline service processing PLSRVID= PLSRV_MAPPING_REQUEST</Trace>

</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-WRITE_MESSAGE_LOG_TO_PERSIST">

<Trace level="3" type="T">Persisting message after plsrv call </Trace>

<Trace level="3" type="T">Message-Version = 001</Trace>

<Trace level="3" type="T">Pipeline CENTRAL</Trace>

</Trace>

<Trace level="1" type="B" name="PLSRV_OUTBOUND_BINDING">

<Trace level="1" type="Timestamp">2012-10-26T11:23:17Z ALA Start of pipeline service processing PLSRVID= PLSRV_OUTBOUND_BINDING</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV">

<Trace level="3" type="T">Calling pipeline service: PLSRV_OUTBOUND_BINDING</Trace>

<Trace level="3" type="T">Reading Pipeline-Service specification... </Trace>

<Trace level="3" type="T">PLSRVTYPE  = </Trace>

<Trace level="3" type="T">ADRESSMOD  = LOCAL</Trace>

<Trace level="3" type="T">P_CLASS    = CL_XMS_PLSRV_OUTBINDING</Trace>

<Trace level="3" type="T">P_IFNAME   = IF_XMS_PLSRV</Trace>

<Trace level="3" type="T">P_METHOD   = ENTER_PLSRV</Trace>

<Trace level="3" type="T"> </Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV_LOCAL">

<Trace level="1" type="B" name="CL_XMS_PLSRV_OUTBINDING-ENTER_PLSRV">

<Trace level="2" type="T">O U T B O U N D - B I N D I N G </Trace>

<Trace level="2" type="T"> Cache content is up to date </Trace>

<Trace level="2" type="T">determine  OUTBOUND BINDING  for: </Trace>

<Trace level="2" type="T">-DE1CLNT200 </Trace>

<Trace level="2" type="T">-KRONOS_MLP_Time_Business_System_D </Trace>

<Trace level="2" type="T">urn:KRONOS:MLP:Time:PersonnelDataFromSAP.KRONOSMLPEmployeePersonnelData_In </Trace>

<Trace level="2" type="T">Channel found: * - KRONOS_MLP_Time_Business_System_D - JDBCReceiverKRONOSMLPEmployeePersonnelData </Trace>

<Trace level="2" type="T">no header mapping defined </Trace>

</Trace>

</Trace>

</Trace>

<Trace level="1" type="Timestamp">2012-10-26T11:23:17Z ALA End of pipeline service processing PLSRVID= PLSRV_OUTBOUND_BINDING</Trace>

</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-WRITE_MESSAGE_LOG_TO_PERSIST">

<Trace level="3" type="T">Persisting message after plsrv call </Trace>

<Trace level="3" type="T">Message-Version = 002</Trace>

<Trace level="3" type="T">Pipeline CENTRAL</Trace>

</Trace>

<Trace level="1" type="B" name="PLSRV_XML_VALIDATION_RQ_OUT">

<Trace level="1" type="Timestamp">2012-10-26T11:23:17Z ALA Start of pipeline service processing PLSRVID= PLSRV_XML_VALIDATION_RQ_OUT</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV">

<Trace level="3" type="T">Calling pipeline service: PLSRV_XML_VALIDATION_RQ_OUT</Trace>

<Trace level="3" type="T">Reading Pipeline-Service specification... </Trace>

<Trace level="3" type="T">PLSRVTYPE  = </Trace>

<Trace level="3" type="T">ADRESSMOD  = LOCAL</Trace>

<Trace level="3" type="T">P_CLASS    = CL_XMS_PLSRV_VALIDATION</Trace>

<Trace level="3" type="T">P_IFNAME   = IF_XMS_PLSRV</Trace>

<Trace level="3" type="T">P_METHOD   = ENTER_PLSRV</Trace>

<Trace level="3" type="T"> </Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV_LOCAL">

<Trace level="1" type="B" name="CL_XMS_PLSRV_VALIDATION-ENTER_PLSRV">

<Trace level="3" type="T">Pipeline Service = PLSRV_XML_VALIDATION_RQ_OUT </Trace>

<Trace level="3" type="T">Skip Inbound Validation =  </Trace>

<Trace level="3" type="T">Skip Outbound Validation =  </Trace>

<Trace level="3" type="T">Area = XML_VALIDATION_OUT </Trace>

<Trace level="1" type="T">Reading receiver agreement </Trace>

<Trace level="3" type="T">Validation Mode = No Validation </Trace>

<Trace level="1" type="T">Outbound validation does not take place </Trace>

</Trace>

</Trace>

</Trace>

<Trace level="1" type="Timestamp">2012-10-26T11:23:17Z ALA End of pipeline service processing PLSRVID= PLSRV_XML_VALIDATION_RQ_OUT</Trace>

</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-WRITE_MESSAGE_LOG_TO_PERSIST">

<Trace level="3" type="T">Persisting message after plsrv call </Trace>

<Trace level="3" type="T">Message-Version = 003</Trace>

<Trace level="3" type="T">Pipeline CENTRAL</Trace>

</Trace>

<Trace level="1" type="B" name="PLSRV_CALL_ADAPTER">

<Trace level="1" type="Timestamp">2012-10-26T11:23:17Z ALA Start of pipeline service processing PLSRVID= PLSRV_CALL_ADAPTER</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV"></Trace><!-- ************************************ -->

<Trace level="3" type="T">Calling pipeline service: PLSRV_CALL_ADAPTER</Trace>

<Trace level="3" type="T">Reading Pipeline-Service specification... </Trace>

<Trace level="3" type="T">PLSRVTYPE  = =SWITCH=</Trace>

<Trace level="3" type="T">ADRESSMOD  = SD</Trace>

<Trace level="3" type="T">P_CLASS    = </Trace>

<Trace level="3" type="T">P_IFNAME   = </Trace>

<Trace level="3" type="T">P_METHOD   = </Trace>

<Trace level="3" type="T"> </Trace>

<Trace level="3" type="T">PLSRVTYPE  = AENGINE</Trace>

<Trace level="3" type="T">ADRESSMOD  = SD</Trace>

<Trace level="3" type="T">P_CLASS    = CL_XMS_PLSRV_IE_ADAPTER</Trace>

<Trace level="3" type="T">P_IFNAME   = IF_XMS_PLSRV</Trace>

<Trace level="3" type="T">P_METHOD   = ENTER_PLSRV</Trace>

<Trace level="3" type="T"> </Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-CALL_PLSRV_LOCAL"></Trace><!-- ************************************ -->

<Trace level="1" type="B" name="CL_XMS_PLSRV_IE_ADAPTER-ENTER_PLSRV">

<Trace level="3" type="T">Channel for adapter engine: JDBC</Trace>

<Trace level="1" type="B" name="CL_XMS_PLSRV_CALL_XMB-CALL_XMS_HTTP">

<Trace level="2" type="T">return fresh values from cache </Trace>

<Trace level="1" type="T">Get logon data for adapter engine (SAI_AE_DETAILS_GET): </Trace>

<Trace level="1" type="T">URL = http://moaserpdi1.muniverse.net:50600/MessagingSystem/receive/AFW/XI</Trace>

<Trace level="1" type="T">User = PIISDI1</Trace>

<Trace level="1" type="T">Cached = X</Trace>

<Trace level="3" type="T">Creating HTTP-client </Trace>

<Trace level="3" type="T">HTTP-client: creation finished</Trace>

<Trace level="1" type="T">Security: Basic authentication </Trace>

<Trace level="1" type="T">Serializing message object... </Trace>

<Trace level="1" type="T">Tuning - AFW_MAXREQUESTCONTENTLENGTH 2000000000</Trace>

<Trace level="1" type="T">HTTP Multipart document length: 7815 </Trace>

<Trace level="3" type="T">HTTP-client: sending http-request...</Trace>

<Trace level="1" type="T">Timeout: 1000 </Trace>

<Trace level="1" type="T">HTTP-client: request sent</Trace>

<Trace level="3" type="T">HTTP-client: request sent</Trace>

<Trace level="3" type="T">HTTP-client: Receiving http-response...</Trace>

<Trace level="1" type="T">HTTP-client: response received</Trace>

<Trace level="3" type="T">HTTP-client: checking status code...</Trace>

<Trace level="1" type="T">HTTP-client: status code = 202</Trace>

<Trace level="3" type="T">HTTP-client: closing...</Trace>

</Trace>

</Trace>

</Trace>

</Trace>

<Trace level="1" type="Timestamp">2012-10-26T11:23:17Z ALA End of pipeline service processing PLSRVID= PLSRV_CALL_ADAPTER</Trace>

</Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-WRITE_MESSAGE_LOG_TO_PERSIST">

<Trace level="3" type="T">Persisting message after plsrv call </Trace>

<Trace level="3" type="T">Message-Version = 004</Trace>

<Trace level="3" type="T">Pipeline CENTRAL</Trace>

</Trace>

<Trace level="3" type="T">Async processing: skip mapping of response </Trace>

</Trace>

<Trace level="3" type="T">system-ID = DI1</Trace>

<Trace level="3" type="T">client = 100</Trace>

<Trace level="3" type="T">language = E</Trace>

<Trace level="3" type="T">user = PIAPPLDI1</Trace>

<Trace level="1" type="Timestamp">2012-10-26T11:23:17Z ALA  </Trace>

<Trace level="1" type="B" name="CL_XMS_MAIN-WRITE_MESSAGE_TO_PERSIST"></Trace><!-- ************************************ -->

<Trace level="3" type="T">Persisting message Status = 003</Trace>

<Trace level="3" type="T">Message version 005</Trace>

<Trace level="3" type="T">Pipeline CENTRAL</Trace>

</SAP:Trace></SOAP:Header><SOAP:Body><SAP:Manifest wsu:Id="" xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:wsu="http://www.docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd"/></SOAP:Body></SOAP:Envelope>

Please fast JO.

Thanks,

vishnu.

[vishnu_pallamreddy · Accepted solution]

Hi Jo,

how can i know which field was truncated in "jdbc".

is it possible or not?

Thanks,

vishnu.

[Former Member · Accepted solution]

Hi,

Check the type of this field "usp_InsertEmployeeChange" on you table .

The two cases of the error u have got means that you are inserting data that does not fit in your table's column.

If your column name can hold 10 characters, and you try to insert 'rameshmca rk', you can get this error.

If you show us your table definition and the query you use to insert the data, we can help you finding out the exact cause.

Hope this help,

Rgds,

Jo

[baskar_gopalakrishnan2 · Accepted solution]

>how can i know which field was truncated in "jdbc".is it possible or not?

Yes possible. Please check database table definitions about field size for each columns and what do you send values from jdbc to database for those columns.  Also you can use the same data and test outside pi using toad or some database query tool. See what error message you get.  I think the problem causing due to your data.

[vishnu_pallamreddy · Accepted solution]

Hi Jo,

That is not a field. i refer "usp_InsertEmployeeChange" this one as just structure.

actually that is stored procedure "sap.usp_InsertEmployeeChange".

my scenario was proxy to jdbc.

i am sending the data from proxy directly to jdbc.

thanks,

vishnu

[vishnu_pallamreddy · Accepted solution]

Hi Baskar,

I think the problem was not with my data i sure about this.

is there any other problems for this issue?

Thanks,

vishnu.

[gagandeep_batra · Accepted solution]

hi vishnu,

check for any extra space may come with data?

Regards

Gagan

[Former Member · Accepted solution]

Hi Vishnu,

Can you check on your source data and the response you send to jdbc,

You can also try to send manually your request to jdbc to find wich data caused the issue.

Rgds,

Jo

[vishnu_pallamreddy · Accepted solution]

Hi Jo,

I check in so many types.

i send data to jdbc manually,  at this time also i got same error "String or binary data would be truncated."

why i am get this error?

Thanks,

vishnu.

[Former Member · Accepted solution]

Hi Vishnu,

So your issue comes on the format of your data.

Can you give to me your query to send to jdbc plz? 

Rgds,

Jo

[vishnu_pallamreddy · Accepted solution]

No Jo,

my issue not with my data format.

i am sending data from proxy to jdbc directly.

Thanks,

vishnu.

[Former Member · Accepted solution]

Vishnu,

Ok, check the Table name what you had entered, may be it is not correct. Plz, ask DB team about the table name table and use the same.

Those links my help you :http://help.sap.com/saphelp_nwpi711/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Here you can find the same issue http://scn.sap.com/thread/3222769

Rgds,

Jo

[vishnu_pallamreddy · Accepted solution]

Hi Jo,

Actually in mapping i map "table" with "stored procedure name",

is it correct or not?

see my mapping in the screen shot.

[Former Member · Accepted solution]

Vishnu,

the screen shot does not appear, can you past it again ?

Also, make sure that JDBC receiver structure is correct.

Can you use "logSQLStatement" and its value as "true" under JDBC receiver adapter (advanced tab) and paste here the sql statement formed at runtime..

[vishnu_pallamreddy · Accepted solution]

Hi Jo,

check it once

[Former Member · Accepted solution]

Hi Vishnu,

The file is corrupt , make the format *.jpg

Can you use "logSQLStatement" and its value as "true" under JDBC receiver adapter (advanced tab) and paste here the sql statement formed.

So we can chech it together.

[vishnu_pallamreddy · Accepted solution]

thank you Jo,

once i check with my DBTeam, let you inform.

thanks,

vishnu.

[Former Member · Accepted solution]

Your welcome,

Wish you a nice week end then.

Regards,

Jo

[anand_shankar10]

Hi Vishnu,

As you have mentioned that you are calling a stored procedure than the issue may be with the data types.

As in the stored procedure that data type and length for each fields are mentioned and the source value that is getting into the JDBC table are not in synch, hence this error.

The error for truncation is because of the length of the field value and the other error is for the format of the field (data type).

Suggest you to check with the DB team and give them the list of all field values and ask them to enter it in the table. This way it will be easier to see if these are the error possibilities.

Regards

Anand