JDBC Adapter Error

[Former Member]

Hi I am getting an Error when i am making a Synch call to JDBC using MS Access.

<b>Result:

<SAP:Error>

<SAP:Category>XIAdapterFramework</SAP:Category>

<SAP:Code>PARSING.GENERAL</SAP:Code>

<SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: ERROR:Processing request: Error when executing statement for table/stored proc. 'Customer': java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.</SAP:AdditionalText>

</SAP:Error></b>

Can any one tell me Where I am doing mistake due to which I got this Error.

Thanks

Farooq.

[MichalKrawczyk · Accepted solution]

Hi,

try: logSQLStatement

from SAP note: 801367

to find out the real sql stametemt

you can post it directly on DB and check why this error happend

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[Former Member · Accepted solution]

Michal I just cross check the SAP Note 801367 - XI 3.0 JDBC Adapter: Additional Parameters, but I didnt get any useful tips from there...is this Error because for SQL statement that I created as DT and MT?

[justin_santhanam · Accepted solution]

Farooq,

Which target structure you are using?

Best regards,

raj.

[MichalKrawczyk · Accepted solution]

hi,

>>>>Additional Parameters, but I didnt get any useful tips from there

? not possible

if you set this parameter you see the real sql statement in messagingsystem

you will see <b>ALL</b> <b>the errors</b> that way

do it and start your message flow and you will see everything

(if can be ither wrong DT or not fully filled in mapping)

but logsqlstatement will show you everything

Regards,

michal

[Former Member · Accepted solution]

I am using :

<b>For request....</b>

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

<xsd:schema targetNamespace="https:sap.com/XI/WebService2JDBC" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="https:sap.com/XI/WebService2JDBC">

<xsd:element name="MT_JDCB_Request" type="DT_JDBC_Request" />

<xsd:complexType name="DT_JDBC_Request">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">51dd0f702d1411dcc1bb000c2967ead8</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="Statement">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">dd3162a02cbb11dc8206cbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="tableName">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">dd3162a12cbb11dcc087cbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="table" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">dd3162a22cbb11dccd71cbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="access">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">dd3162a32cbb11dc8f11cbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="CustomerName" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">2670e9402cbc11dc8497cbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="CutomerID" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">2670e9412cbc11dc9efecbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Balance" type="xsd:float">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">2670e9422cbc11dcc5bfcbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="AccountType" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">2670e9432cbc11dca015cbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

<xsd:element name="Key">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">7db722a02cbc11dcc973cbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="CustomerID" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">7db722a12cbc11dcb438cbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

<xsd:attribute name="action" type="xsd:string" use="required" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">dd3162a52cbb11dccdcccbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

</xsd:attribute>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:schema>

<b>Response</b>

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

<xsd:schema targetNamespace="https:sap.com/XI/WebService2JDBC" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="https:sap.com/XI/WebService2JDBC">

<xsd:element name="MT_JDBC_Request_response" type="DT_JDBC_Request_response" />

<xsd:complexType name="DT_JDBC_Request_response">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">c4f45e102d1311dca561000c2967ead8</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="Statement_response">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">dd3162a02cbb11dc8206cbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="row" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">dd3162a12cbb11dcc087cbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="CustomerName" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">025d1cd02cbd11dcb35dcbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="CustomerID" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">025d1cd12cbd11dccfb7cbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Balance" type="xsd:float">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">025d1cd22cbd11dc95bacbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Address" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">025d1cd32cbd11dc9d73cbb4c0a84b01</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:schema>

Thanks

Farooq

[Former Member · Accepted solution]

Message in MONI

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

- <ns:MT_JDCB_Request xmlns:ns="https:sap.com/XI/WebService2JDBC">

- <Statement>

- <tableName action="SELECT">

<table>Customer</table>

- <access>

<CustomerName />

<CutomerID />

<Balance />

<AccountType />

</access>

- <Key>

<CustomerID>1001</CustomerID>

</Key>

</tableName>

</Statement>

</ns:MT_JDCB_Request></b>

[MichalKrawczyk · Accepted solution]

Hi,

just do what I said and you will see the error

Regards,

michal

[Former Member · Accepted solution]

Michal I did that but still same log in MONI..here are the steps :

1. In the JDBC Receiver adapter--> Additionnal Parameter..

I added one entry called :

Name : logSQLStatement

Value : true

These are the setting right?

[justin_santhanam · Accepted solution]

Farooq,

Did you copied and paste directly from the MONI, if yes can u please verify the column names, the second Column u given as <b>CutomerID</b>. Is it correct? Moreover please follow as our Michal suggested.

Best regards,

raj.

[justin_santhanam · Accepted solution]

Farooq,

The settings are correct.Go ahead , and reply back the findings.:-)

Best regards,

raj.

[MichalKrawczyk · Accepted solution]

Hi,

>>>>Michal I did that but still same log in MONI..here are the steps :

OK I get the issue now

not in MONI but in messaging system (like I mentioned eariler)

this is the URL where you can find it:

http://<host>:<port>/MessagingSystem/monitor/monitor.jsp

do you see it now ?

Regards,

michal

[Former Member · Accepted solution]

No I am getting same sql error after all the setting and adapter activation

[justin_santhanam · Accepted solution]

Farooq,

You can find the SQl Logs in the audit log as mentioned in the Note. Please follow the URL Michal given, also see my previous reply for the column name.

Best regards,

raj.

[Former Member · Accepted solution]

Hey Raj Good catch, that Error gone, but When I am sending the message from

HTTP client I am getting blank response instead of some entries, Basically

same thing happen with me for HTTP to RFC also I am getting blank message.

<b>Result:

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

<ns:MT_JDBC_Request_response xmlns:ns="https:sap.com/XI/WebService2JDBC"><Statement_response></Statement_response></ns:MT_JDBC_Request_response></b>

[Former Member · Accepted solution]

Michal what does this URL stand for... is it same as Message Monitoring from

RWB?

[justin_santhanam · Accepted solution]

Farooq,

Yes its the same, as in Message Monitoring from RWB. In Message Monitoring u have to choose Adapter Engine and check for audit logs.

Best regards,

raj.

[Former Member · Accepted solution]

Raj, I am making Sych SOAP to JDBC. But I am using HTTP client to send the message IE directly.

Now I am not seeing message in MONI (Using QoS = BE in HTTP client), also I am getting blank message from XI as a response.

Could you please tell me why its so?

Once SOAP2JDBC works I will give u max points for the right answer

Thanks

Farooq.

[Former Member · Accepted solution]

In Addition I am not using any BPM for this (SP 9, XI 3.0)

I am calling Inbound Interface and mapping in the Interface Determination..

Also when I am uisng QoS = EO in HTTP client I am getting message in MONI

[MichalKrawczyk · Accepted solution]

hi,

SXMB_ADM

integration engine configuration

set paramameter - <b>logging_sync</b> to 1

simlilar to my blog:

/people/michal.krawczyk2/blog/2005/05/10/xi-i-cannot-see-some-of-my-messages-in-the-sxmbmoni

Regards,

michal

[Former Member · Accepted solution]

Thanks Michal..

Problem Resolved...Rewarded Points

[MichalKrawczyk · Accepted solution]

thanks

Regards,

michal