JDBC reciever error

[Former Member]

hi,

I want to update the data using JDBC driver and I got the following error.

TransformException error in xml processor class: Error processing request in sax parser: Error when executing statement for table/stored proc. 'production_order' (structure 'StatementName'): com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'.

any help?

thank you

[Former Member · Accepted solution]

hi Moorthy,

I got the mapped message. It look like

<?xml version="1.0" encoding="UTF-8" ?>

- <ns1:MT_DBReciever xmlns:ns1="http://timken.com/poc">

- <StatementName>

- <production_order action="INSERT">

<table>production_order</table>

</production_order>

- <access>

<order_number>1</order_number>

<plant>AUX</plant>

<order_date>9/10/2006</order_date>

<completion_date>9/30/2006</completion_date>

<production_material>Pins</production_material>

<production_qty>100</production_qty>

<quantity_uom>Meters</quantity_uom>

<created_by>Joe</created_by>

<revision_number>101</revision_number>

<sfp_guage_file>file1</sfp_guage_file>

<sfp_file_1>file2</sfp_file_1>

<sfp_file_2>file3</sfp_file_2>

<sfp_file_3>file4</sfp_file_3>

<sfp_id>6.7</sfp_id>

<sfp_od>4.5</sfp_od>

<sfp_width>8.9</sfp_width>

<sfp_material>3.2</sfp_material>

<description>Produce Pins</description>

</access>

</StatementName>

- <StatementName1>

- <order_operation action="INSERT">

<table>order_operation</table>

</order_operation>

- <access>

<order_number>1</order_number>

<operation_id>Green</operation_id>

<routing_seq_num>1</routing_seq_num>

<work_center>Green</work_center>

<operation_status>None</operation_status>

<material_produced>GreenPins</material_produced>

<order_quantity>0.00</order_quantity>

<quantity_uom>Meters</quantity_uom>

<quantity_completed>0.00</quantity_completed>

<quantity_scrapped>0.00</quantity_scrapped>

<activity>Cut</activity>

<std_activity_quantity>60</std_activity_quantity>

<actual_activity_quantity>0.00</actual_activity_quantity>

<activity_quantity_uom>Min</activity_quantity_uom>

<activity_start_time>Constant</activity_start_time>

<activity_end_time>Constant</activity_end_time>

<description>Green</description>

</access>

</StatementName1>

- <StatementName2>

- <operation_material action="INSERT">

<table>operation_material</table>

</operation_material>

- <access>

<order_number>1</order_number>

<operation_id>Green</operation_id>

<routing_seq_num>1</routing_seq_num>

<material_id>Wire</material_id>

<material_source>GreenPins</material_source>

<std_material_usage>50</std_material_usage>

<actual_material_usage>0.00</actual_material_usage>

<usage_uom>Meters</usage_uom>

</access>

</StatementName2>

</ns1:MT_DBReciever>

any help pls..

[moorthy · Accepted solution]

Hi,

Is your database table name is production_order ?

If so it should end after all the field informations. i.e <b></production_order></b>

should be before <b></StatementName></b> ends..

Check this format with whatever link I posted in my first reply.

Regards,

Moorthy

[Former Member · Accepted solution]

thank you so much, that error is solved after the correction. Now i got another error:

2006-10-18 17:57:56 Error Unable to execute statement for table or stored procedure. 'production_order' (Structure 'StatementName') due to com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'production_order'.

2006-10-18 17:57:56 Error Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. 'production_order' (structure 'StatementName'): com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'production_order'.

my table name is production_order. should i specify the schema name also or is there anything else that I am doin wrong.

[moorthy · Accepted solution]

Hi,

Invalid object name ..probably because of Table name problem. Try to give with Capital Letter ..also confirm database table name and given table name production_order is exactly same. Try out changin the case

All fields in the table are matching the field names in the message structure...check out..

TO narrow down the problem, you can try out by passing one table information..

Regards,

Moorthy

[Former Member]

thank you, but where can i see the target structure.. i have created a DT as said in the help.

[former_member206604]

Hi,

Yes you would have created a DT for the target or receving end.. that is what I said as target structure. Can you post the target strucutre. Are you sure you have followed the exact strucutre thet is mentioned in the help.

Always post as much information as possible so that it will be easy for us to help.

Regards,

Prakash

[Former Member]

hi Prakash,

I am posting the target xsd .

<?xml version="1.0" encoding="ISO-8859-1"?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://timken.com/poc" targetNamespace="http://timken.com/poc">

<xsd:complexType name="DB_Reciever">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

01ab81205eda11dbcaf30050569d05b7

</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="StatementName">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37a05d2311dbcc06debf93b90409

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="production_order">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37a15d2311dba5f7debf93b90409

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="table" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

f5257af05ed911dbca0bd0f193b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

<xsd:attribute name="action" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37a25d2311dbae86debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:attribute>

</xsd:complexType>

</xsd:element>

<xsd:element name="access">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37a35d2311db9ebbdebf93b90409

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="order_number" type="xsd:integer">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37a45d2311dba1fddebf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="plant" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37a55d2311dbb4f5debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="order_date" type="xsd:date">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37a65d2311dba92bdebf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="completion_date" type="xsd:date">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37a75d2311db9a81debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="production_material" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37a85d2311dbaa19debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="production_qty" type="xsd:integer">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37a95d2311dbc1c7debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="quantity_uom" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37aa5d2311dbbd38debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="created_by" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37ab5d2311db9149debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="revision_number" type="xsd:integer">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37ac5d2311db9527debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="sfp_guage_file" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37ad5d2311db881cdebf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="sfp_file_1" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37ae5d2311dbc9e0debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="sfp_file_2" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37af5d2311dbb5b1debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="sfp_file_3" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37b05d2311db84dddebf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="sfp_id" type="xsd:decimal">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37b15d2311db904cdebf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="sfp_od" type="xsd:decimal">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37b25d2311dbb212debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="sfp_width" type="xsd:decimal">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37b35d2311dba9b6debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="sfp_material" type="xsd:decimal">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37b45d2311dbbfd9debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="description" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

e6cf37b55d2311dbbbd5debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

<xsd:element name="StatementName1">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2c05d2911dbc719debf93b90409

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="order_operation">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2c15d2911db9e56debf93b90409

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="table" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

f5257af15ed911dbbf29d0f193b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

<xsd:attribute name="action" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2c25d2911db9f87debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:attribute>

</xsd:complexType>

</xsd:element>

<xsd:element name="access">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2c35d2911dbcc78debf93b90409

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="order_number" type="xsd:integer">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2c45d2911db8ad1debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="operation_id" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2c55d2911dbb675debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="routing_seq_num" type="xsd:integer">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2c65d2911db81a7debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="work_center" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2c75d2911db93ccdebf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="operation_status" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2c85d2911dbbf81debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="material_produced" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2c95d2911dba6e0debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="order_quantity" type="xsd:integer">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2ca5d2911dbcb7bdebf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="quantity_uom" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2cb5d2911dbc4e2debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="quantity_completed" type="xsd:integer">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2cc5d2911dbad1edebf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="quantity_scrapped" type="xsd:integer">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2cd5d2911dbbc18debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="activity" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2ce5d2911dba48adebf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="std_activity_quantity" type="xsd:integer">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2cf5d2911db8ce7debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="actual_activity_quantity" type="xsd:integer">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2d05d2911dbc3fadebf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="activity_quantity_uom" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2d15d2911dbcc61debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="activity_start_time" type="xsd:date">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2d25d2911dbc79cdebf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="activity_end_time" type="xsd:date">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2d35d2911dbbf06debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="description" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2d45d2911dbc79cdebf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

<xsd:element name="StatementName2">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2d55d2911dbc760debf93b90409

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="operation_material">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2d65d2911dbc291debf93b90409

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="table" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

f5257af25ed911dbbc0dd0f193b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

<xsd:attribute name="action" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2d75d2911dbc4d6debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:attribute>

</xsd:complexType>

</xsd:element>

<xsd:element name="access">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2d85d2911dbbea7debf93b90409

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="order_number" type="xsd:integer">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2d95d2911dbafc2debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="operation_id" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2da5d2911dbc4a3debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="routing_seq_num" type="xsd:integer">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2db5d2911db8d4fdebf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="material_id" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2dc5d2911db806adebf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="material_source" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2dd5d2911dbb3cfdebf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="std_material_usage" type="xsd:integer">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2de5d2911dba861debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="actual_material_usage" type="xsd:integer">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2df5d2911dbaccfdebf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="usage_uom" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

79a1a2e05d2911dbc5a6debf93b90409

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:schema>

help is appreciated

[moorthy]

it is data type xsd.

It it is better to post Mapped Data ( after mapping of Source to Target Strcuture ) i.e output of mapped data..

with xml tags..you can get this from SXMB_MONI

Regards,

Moorthy

[Former Member]

hi Moorthy,

I am sry I couldnt find the msg in sxmb_moni so i am sending the mapping message.

/ns1:MT_DBReciever/StatementName/production_order/@action=const([value=INSERT]) /ns1:MT_DBReciever/StatementName/production_order/table=const([value=production_order]) /ns1:MT_DBReciever/StatementName/access=const([value=]) /ns1:MT_DBReciever/StatementName/access/order_number=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:ID= /ns1:MT_DBReciever/StatementName/access/plant=/ns0:ProductionSchedule/ns0:Location= /ns1:MT_DBReciever/StatementName/access/order_date=/ns0:ProductionSchedule/ns0:StartTime= /ns1:MT_DBReciever/StatementName/access/completion_date=/ns0:ProductionSchedule/ns0:EndTime= /ns1:MT_DBReciever/StatementName/access/production_material=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:MaterialProducedRequirement/ns0:MaterialClassID= /ns1:MT_DBReciever/StatementName/access/production_qty=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:MaterialProducedRequirement/ns0:Quantity= /ns1:MT_DBReciever/StatementName/access/quantity_uom=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:MaterialConsumedRequirement/ns0:MaterialDefinitionID= /ns1:MT_DBReciever/StatementName/access/created_by=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:Description= /ns1:MT_DBReciever/StatementName/access/revision_number=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:ProductProductionRuleID= /ns1:MT_DBReciever/StatementName/access/sfp_guage_file=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:ProductionParameter/ns0:ProductSegmentID= /ns1:MT_DBReciever/StatementName/access/sfp_file_1=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:ProductionParameter/ns0:ProcessSegmentID= /ns1:MT_DBReciever/StatementName/access/sfp_file_2=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:ProductionParameter/ns0:Parameter= /ns1:MT_DBReciever/StatementName/access/sfp_file_3=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:ProductionParameter/ns0:Any= /ns1:MT_DBReciever/StatementName/access/sfp_id=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:RequiredByRequestedSegmentResponse= /ns1:MT_DBReciever/StatementName/access/sfp_od=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:SegRek= /ns1:MT_DBReciever/StatementName/access/sfp_width=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:Any= /ns1:MT_DBReciever/StatementName/access/sfp_material=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentResponse= /ns1:MT_DBReciever/StatementName/access/description=/ns0:ProductionSchedule/ns0:Description= /ns1:MT_DBReciever/StatementName1/order_operation/@action=const([value=INSERT]) /ns1:MT_DBReciever/StatementName1/order_operation/table=const([value=order_operation]) /ns1:MT_DBReciever/StatementName1/access=const([value=]) /ns1:MT_DBReciever/StatementName1/access/order_number=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:ID= /ns1:MT_DBReciever/StatementName1/access/operation_id=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:EquipmentRequirement/ns0:EquipmentRequirementProperty/ns0:Description= /ns1:MT_DBReciever/StatementName1/access/routing_seq_num=ifWithoutElse([keepss=false]exists(/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:EquipmentRequirement/ns0:EquipmentRequirementProperty/ns0:Description=), counter([ini=1, inc=1])) /ns1:MT_DBReciever/StatementName1/access/work_center=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:EquipmentRequirement/ns0:Location= /ns1:MT_DBReciever/StatementName1/access/operation_status=const([value=None]) /ns1:MT_DBReciever/StatementName1/access/material_produced=concat([delimeter=]/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:EquipmentRequirement/ns0:EquipmentRequirementProperty/ns0:Description=, /ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:MaterialProducedRequirement/ns0:MaterialClassID=) /ns1:MT_DBReciever/StatementName1/access/order_quantity=const([value=0.00]) /ns1:MT_DBReciever/StatementName1/access/quantity_uom=const([value=Meters]) /ns1:MT_DBReciever/StatementName1/access/quantity_completed=const([value=0.00]) /ns1:MT_DBReciever/StatementName1/access/quantity_scrapped=const([value=0.00]) /ns1:MT_DBReciever/StatementName1/access/activity=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:EquipmentRequirement/ns0:EquipmentRequirementProperty/ns0:ID= /ns1:MT_DBReciever/StatementName1/access/std_activity_quantity=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:EquipmentRequirement/ns0:EquipmentRequirementProperty/ns0:Quantity= /ns1:MT_DBReciever/StatementName1/access/actual_activity_quantity=const([value=0.00]) /ns1:MT_DBReciever/StatementName1/access/activity_quantity_uom=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:EquipmentRequirement/ns0:EquipmentRequirementProperty/ns0:Value= /ns1:MT_DBReciever/StatementName1/access/activity_start_time=const([value=Constant]) /ns1:MT_DBReciever/StatementName1/access/activity_end_time=const([value=Constant]) /ns1:MT_DBReciever/StatementName1/access/description=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:EquipmentRequirement/ns0:EquipmentRequirementProperty/ns0:Description= /ns1:MT_DBReciever/StatementName2/operation_material/@action=const([value=INSERT]) /ns1:MT_DBReciever/StatementName2/operation_material/table=const([value=operation_material]) /ns1:MT_DBReciever/StatementName2/access=const([value=]) /ns1:MT_DBReciever/StatementName2/access/order_number=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:ID= /ns1:MT_DBReciever/StatementName2/access/operation_id=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:EquipmentRequirement/ns0:EquipmentRequirementProperty/ns0:Description= /ns1:MT_DBReciever/StatementName2/access/routing_seq_num=ifWithoutElse([keepss=false]exists(/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:EquipmentRequirement/ns0:EquipmentRequirementProperty/ns0:Description=), counter([ini=1, inc=1])) /ns1:MT_DBReciever/StatementName2/access/material_id=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:MaterialConsumedRequirement/ns0:MaterialClassID= /ns1:MT_DBReciever/StatementName2/access/material_source=concat([delimeter=]/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:EquipmentRequirement/ns0:EquipmentRequirementProperty/ns0:Description=, /ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:MaterialProducedRequirement/ns0:MaterialClassID=) /ns1:MT_DBReciever/StatementName2/access/std_material_usage=/ns0:ProductionSchedule/ns0:ProductionRequest/ns0:SegmentRequirement/ns0:EquipmentRequirement/ns0:Quantity= /ns1:MT_DBReciever/StatementName2/access/actual_material_usage=const([value=0.00]) /ns1:MT_DBReciever/StatementName2/access/usage_uom=const([value=Meters])

will this help solve my probelm?

[moorthy]

HI,

Possible errors may be-

1) Doucment formaty of the message - which is input to JDBC Receiver adapter may be incorrect.

Cjeck out this-

http://help.sap.com/saphelp_erp2005vp/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

2) Also check that, JDBC driver is installed correctly- for this

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Regards,

Moorthy

[former_member206604]

Hi Kumar,

Check if you have defined your structure properly, I guess there is some problem with the query that is generatred.

Check out these links

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Check if you have created and populated the target structure correctly.

Regards,

Prakash