Receiver JDBC Channel Error : Incorrect syntax near 'OR'

[Former Member]

hi,

we are facing the below error at the receiver communication channel:

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'table' (structure 'statement'): com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'OR'.

When we again reprocess the message,it shows the exact error at the channel.

Any ideas why the first error shows up?

[baskar_gopalakrishnan2]

The problem is that you dont follow the target message according to jdbc receiver spec

Please follow this link

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/content.htm

if you have trouble, provide your target structure here. we will help you.

[Former Member]

the interfaces executed well in one environment but facing error whn transferred to another environment.

[Former Member]

Hi, Anu

The most probable it's that your target XML it's not correct because it haven't a correct format.

Please, check your target XML and see

http://help.sap.com/saphelp_nwpi711/helpdata/en/48/465581929734d9e10000000a42189d/frameset.htm

Regards,

Carme

[rajasekhar_reddy14]

paste your mapping output from SXMB_MONI..