JDBC lookup problem: XI AF API call failed.

[deviprasad_pothireddy]

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.

[agasthuri_doss]

Hi,

Check out the Driver and as Satish mentioned check the SQL statement in database.

Regards

Agasthuri Doss

[Former Member]

HI,

See the below link

http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0/content.htm

Also

Also read thru this to get more idea on lookups - http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0

Lookup’s in XI made simpler - /people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

How to check JDBC SQL Query Syntax and verify the query results inside a User Defined Function of the Lookup API -

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

/people/prasad.illapani/blog/2006/10/25/how-to-check-jdbc-sql-query-syntax-and-verify-the-query-results-inside-a-user-defined-function-of-the-lookup-api

Lookups - /people/morten.wittrock/blog/2006/03/30/wrapping-your-mapping-lookup-api-code-in-easy-to-use-java-classes

Lookups - /people/alessandro.guarneri/blog/2006/03/27/sap-xi-lookup-api-the-killer

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0/content.htm

/people/sap.user72/blog/2005/12/06/optimizing-lookups-in-xi

Lookups with XSLT - https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8e7daa90-0201-0010-9499-cd347ffb...

/people/sravya.talanki2/blog

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/05a3d62e-0a01-0010-14bc-adc8efd4...

Regards

Chilla

[Former Member]

Prasad,

Its complaining about the incorrect syntax in your query. Just check the query. Also execute the query in the database and check whether it is working or not?

---Satish