Erorr in JDBC Receiver Adapter ..

[Former Member]

Hi All,

I am getting error in jdbc receiver adpt.

I am using SQL Server 2000.

My input file is ..

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

<ns6:MT_SALETARGET_REQ xmlns:ns6="urn:ters.com">

- <STATEMENT>

- <TABLENAME ACTION="SELECT">

<TABLE>Saletargets</TABLE>

- <ACCESS>

<FiscalYear />

<YearMonth />

<ProductCode />

<TargetVolume />

<TargetValue />

</ACCESS>

<KEY>

<FiscalYear compareOperation="EQ">2007</FiscalYear>

<YearMonth compareOperation="EQ">200605</YearMonth>

</KEY>

</TABLENAME>

</STATEMENT>

</ns6:MT_SALETARGET_REQ>

Error IS :

<i>com.sap.aii.af.ra.ms.api.DeliveryException: ERROR:Processing request: Error when executing statement for table/stored proc. 'Saletargets': java.sql.SQLException: FATAL ERROR: Column 'FiscalYear' does not exist in table 'Saletargets'</i>Any Ideas?

Sumit

<b>Solved it ..FISCALYEAR is case sensitive ..</b>didnt know column names were case sensitive

Message was edited by: Sumit Khetawat

Message was edited by: Sumit Khetawat

[udo_martens · Accepted solution]

Hi Sumit,

your request tries to select column "FiscalYear" from table "Saletargets", which is obvisiosly not defined.

Regards,

Udo