Receiver JDBC adapter

[Former Member]

Hi All,

I have configured a file-xi-jdbc scenario based on the blog 1772. What is the value I have to give for the element TABLE in mapping? I have used a constant with the name of my table in that constant.

In RWB I get an error for the receiver JDBC adapter. The error is

Receiver Adapter v1027 for Party '', Service 'NMHG_SQL_SERVER':

Configured at 13:45:51 2006-08-08

Last message processing started 13:59:31 2006-08-08, Error: Transform error in xml processor class, rollback:

ERROR:Processing request: Error when executing statement for table/stored proc. 'jai_tab': java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near ')'.

at com.sap.aii.adapter.jdbc.xml2sql.service(xml2sql.java:175)

at com.sap.aii.adapter.jdbc.XI2JDBC.onInternalMessage(XI2JDBC.java:266)

at com.sap.aii.adapter.jdbc.SapAdapterServiceFrameImpl.callSapAdapter_i(SapAdapterServiceFrameImpl.java:170)

at com.sap.aii.adapter.jdbc.SapAdapterServiceFrameImpl.callSapAdapter(SapAdapterServiceFrameImpl.java:146)

at com.sap.aii.af.modules.CallAdapterWithMessageBean.process_receiver(CallAdapterWithMessageBean.java:206)

at com.sap.aii.af.modules.CallAdapterWithMessageBean.process(CallAdapterWithMessageBean.java:161)

at com.sap.aii.af.mp.module.ModuleLocalLocalObjectImpl1.process(ModuleLocalLocalObjectImpl1.java:103)

at com.sap.aii.af.mp.ejb.ModuleProcessorBean.process(ModuleProcessorBean.java:221)

at com.sap.aii.af.mp.processor.ModuleProcessorLocalLocalObjectImpl0.process(ModuleProcessorLocalLocalObjectImpl0.java:103)

at com.sap.aii.af.listener.AFWListenerBean.onMessage(AFWListenerBean.java:216)

at com.sap.aii.af.listener.AFWListenerLocalObjectImpl0.onMessage(AFWListenerLocalObjectImpl0.java:103)

at com.sap.aii.af.ra.ms.impl.ServicesImpl.deliver(ServicesImpl.java:262)

at com.sap.aii.adapter.xi.ms.XIEventHandler.onDeliver(XIEventHandler.java:611)

at com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.invokeHandler(ReceiveConsumer.java:353)

at com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.onMessage(ReceiveConsumer.java:98)

at com.sap.aii.af.ra.ms.impl.core.queue.Queue.run(Queue.java:419)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:94)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:162)

Pls tell me what this error means and how to debug it?

Thanks & Regards,

Jai Shankar.

Message was edited by: Jai Shankar

[bhavesh_kantilal · Accepted solution]

Jai,

Can you post your Receiver Data type on the forum so we can assist you better.

Meanwhile take a look at this link,

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

TABLE should contain the name of the table.it is optional.

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi Bhavesh,

My receiver data type is

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

DT_TARGET

<STATMENTNAME>

<TEST action="insert">

<TABLE>jai_tab</TABLE>

</TEST>

<access>

<Emp_Id>4</Emp_Id>

<Emp_Name>6</Emp_Name>

<Department>5</Department>

<Status>3</Status>

</access>

</STATMENTNAME>

Here access is an attribute and TABLE is an element.

Thanks & Regards,

Jai Shankar.

[bhavesh_kantilal · Accepted solution]

Jai,

You have cloase the TEST tag before access and that is the error. Yhis is how it should be.

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

DT_TARGET

<STATMENTNAME>

<TEST action="insert">

<TABLE>jai_tab</TABLE>

<access>

<Emp_Id>4</Emp_Id>

<Emp_Name>6</Emp_Name>

<Department>5</Department>

<Status>3</Status>

</access>

<b></TEST></b>

</STATMENTNAME></i>

<i>Here access is an attribute and TABLE is an element.</i>

I think you meant ACTION is an Attribute. Corerect me if I am wrong

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi Bhavesh,

You did it again. The scenario works fine now. Thanks a lot.

Thanks & Regards,

Jai Shankar.

[bhavesh_kantilal · Accepted solution]

Jai,

Its a pleasure

Regards,

Bhavesh

[udo_martens]

Hi Jai,

XML is case sensitiv. Use element <b><table></b> and put the table name of the database. May be full qualified like "MYDATABASE.MYTABLE".

Regards,

Udo