Skip to Content
0
Former Member
Apr 21, 2007 at 12:25 PM

JDBC lookup problem: XI AF API call failed.

86 Views

Hi all,

I have done a http-jdbc(syn) scenario and it is working fine.

Now i have created another Integartion and mapping objects. Now i have created one advanced user defined function to do xi-lookup. i have used the above service and communication channel.

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/2219. [original link is broken] [original link is broken] [original link is broken] [original link is broken]

the user defined function executed sucessfully, but it is giving error.as shown in below

error->

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

<ns0:Role_MT xmlns:ns0="urn://jdbcLookup"><URole>Exception during processing the payload.Problem when calling an adapter by using communication channel jdbc_recevier_ch (Party: , Service: deviexportimport, Object ID: 617a3c17b16c3f7b93128dabbd33b41d) XI AF API call failed. Module exception: (No information available). Cause Exception: &apos;Error processing request in sax parser: Error when executing statement for table/stored proc. &apos;table&apos; (structure &apos;statement&apos;): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near &apos;kumar&apos;.&apos;.

com.sap.aii.mapping.lookup.LookupException: Problem when calling an adapter by using communication channel jdbc_recevier_ch (Party: , Service: deviexportimport, Object ID: 617a3c17b16c3f7b93128dabbd33b41d) XI AF API call failed. Module exception: (No information available). Cause Exception: &apos;Error processing request in sax parser: Error when executing statement for table/stored proc. &apos;table&apos; (structure &apos;statement&apos;): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near &apos;kumar&apos;.&apos;.

at com.sap.aii.ibrun.server.lookup.AdapterProxyLocal.execute(AdapterProxyLocal.java:131): --> and so on.

-


this is input data

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

<ns0:LoginData_MT xmlns:ns0="urn://jdbcLookup">

<UserName>kumar</UserName>

<Password>kumar</Password>

</ns0:LoginData_MT>

Please help me to solve this problem.

Regards,

Deviprasad.