Skip to Content
0
Former Member
Nov 08, 2005 at 01:18 PM

Insert a record into MSAccess table.

18 Views

Hello Friends

I have posted this qustion before but my problem is not solved.

Iam trying to insert a row into MSAccess table from a legacy file through XI. Iam succcessfull in retrieving the data from the table but not able to insert the data into the table.

It gives the error.

<b>Receiver Adapter v1109 for Party '', Service 'ORACLE_SERVER_BS':

Configured at 08:42:06 2005-11-08

Last message processing started 12:50:06 2005-11-08, Error: TransformException error in xml processor class, rollback:

Error processing request in sax parser: Error when executing statement for table/stored proc. 'VendorMaster': java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

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

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

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:204)

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

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:220)

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

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

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

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

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:448)

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)</b>

My source structure is

Vendor

>Vendor_number

>Last_name

..

..

My Target structure is

VendorMaster

>Insert

>VendorMaster

action

table

>access

VendorNumber

LastName

..

..

Can anyone please solve this...

Thanks in Advance.