Problem with receiver jdbc CC

[Former Member]

Hi,

Iam doing RFC to JDBC scenario..

The receiver JDBC adapte which i configured is giving me an error saying that "Unable to execute statement for table or stored procedure. 'HR_Employee' (Structure 'Statement') due to com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'."

Please help me to make out as what does this error mean and how to overcome it.

The message protocol i used is he XML SQL String and i have specified "NULL Value" in the field "interpretation of empty string values".

Helpful answers will definitely be rewarded.

Regards

Madhu

[Former Member]

Hi Madhulatha,

R u able to solve this error? If yes can you please share the solution. I am getting similalr kind of error.

Error processing request in sax parser: Error when executing statement for table/stored proc. 'UWCT' (structure 'statement3'): com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: Incorrect syntax near ','.

In my case, I am updating data in 3 tables. But only for 3rd Table I am getting this error.

And Strange part is with different Interface with same structure I am able to insert the data in UWCT table.

Dear All,

Can you please suggest?

-Gouri

[Former Member]

yes the error got resolved...

in receiver JDBC adpater i have mentioned the values as below:

Persistence : Database

DB Table Name : XIException

Key Column Name: XIExceptionCol1

Value Column Name : XIExceptionCol2

Regards

Madhu

[Former Member]

Hi Madhulatha,

The structure for the rcvr JDBC adapter should always be in this fashion

DT_TRG

Statement for the select/SQL statement

TableName(Node)

Action (Attribute)

Table (name of the table)

Access

DB Field1 Col names to be selected from table

Check this blog by Bhavesh

Hope this helps u out

Edited by: Mohd Tauseef Ibrahim on Jul 2, 2008 9:02 AM

Edited by: Mohd Tauseef Ibrahim on Jul 2, 2008 9:03 AM

Edited by: Mohd Tauseef Ibrahim on Jul 2, 2008 9:05 AM

[Former Member]

hi madhulatha

check this note

831162 - for frequently occuring problems with JDBC adapter

regards

kummari

[Former Member]

Hi Madhulata,

Paste your receiver xml structure, so that we can tell you what the error is.

Regards,

Shamly

[Former Member]

here is the xml structure

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

- <ns1:MT_HR_Employee xmlns:ns1="urn:csc-com:india:saphr:to:bwdfile">

- <tablename action="INSERT">

<table>HR_Employee</table>

</tablename>

- <access>

<CompanyCode />

<EffectiveDate />

<ActionType />

<EmployeeID />

<RegionalID />

<BusinessArea />

<CostCenter />

<Source />

<LastName />

<FirstName />

<MiddleName />

<EmployeeGroup />

<EmployeeSubGroup />

<Position />

<PositionTitle />

<VendorID />

<AlternateID />

<ShortName />

<GUID />

<EmploymentStatus />

<LaborCategory />

<PersonnelArea />

<PersonnelSubArea />

<OrganizatioalUnit />

<OrgUnitManager_1 />

<OrgUnitManager_2 />

<OrgUnitManager_3 />

<JobCode />

<GlobalTitleCode />

<JobTitle />

<PayscaleGroup />

<HIreDate />

<TerminationDate />

<ServiceDate />

<FileDate />

<DateOfBirth />

<Gender />

<PreviousExp />

</access>

</ns1:MT_HR_Employee>

[Former Member]

hi madhulata....

Statement is missing in ur receiver structure thats y its givin error.

ur receiver should be like this.

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

<ns1:MT_HR_Employee xmlns:ns1="urn:csc-com:india:saphr:to:bwdfile">

<Statement>

<tablename action="INSERT">

<table>HR_Employee</table>

</tablename>

<access>

<CompanyCode />

<EffectiveDate />

<ActionType />

<EmployeeID />

<RegionalID />

<BusinessArea />

<CostCenter />

<Source />

<LastName />

<FirstName />

<MiddleName />

<EmployeeGroup />

<EmployeeSubGroup />

<Position />

<PositionTitle />

<VendorID />

<AlternateID />

<ShortName />

<GUID />

<EmploymentStatus />

<LaborCategory />

<PersonnelArea />

<PersonnelSubArea />

<OrganizatioalUnit />

<OrgUnitManager_1 />

<OrgUnitManager_2 />

<OrgUnitManager_3 />

<JobCode />

<GlobalTitleCode />

<JobTitle />

<PayscaleGroup />

<HIreDate />

<TerminationDate />

<ServiceDate />

<FileDate />

<DateOfBirth />

<Gender />

<PreviousExp />

</access>

</Statement>

</ns1:MT_HR_Employee>

Insert Statement node in ur structure.

Sreedhar Goud L

[Former Member]

HI Madhu,

Your syntax for Update /Insert statement or to call stored procedure is not appropriate.

In the case of synchronous queries, results from database queries or return values of stored procedures can also be transferred.

Refer below format of payload in mapping

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

Thanks

Swarup

[Former Member]

Check if you have defined your structure properly, I guess there is some problem with the query that is generatred.

Doucment formaty of the message - which is input to JDBC Receiver adapter may be incorrect.

Check out this-

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

Also check that, JDBC driver is installed correctly- for this

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Check out these links

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

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

Check if you have created and populated the target structure correctly.

regards

kummari