JDBC Look up error

[former_member640968]

Hi,

I able to see the below error while using JDBC look up in PI 7.3. Could you please help what the issue is about? Thanks in advance.

Exception:[com.sap.aii.mapping.lookup.LookupException: Exception during processing the payload. Error when calling an adapter by using the communication channel JDBC_IPP_DBTable_Receiver (Party: , Service: BC_KCEU_IPP_Service, Object ID: 9a468411ed8e3da7a76cce28ad4701bf) XI AF API call failed. Module exception: (No information available). Cause Exception: 'Error processing request in sax parser: Error when executing statement for table/stored proc. 'table' (structure 'statement'): com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'SalesOrganization'.'. com.sap.aii.mapping.lookup.LookupException: Error when calling an adapter by using the communication channel JDBC_IPP_DBTable_Receiver (Party: , Service: BC_KCEU_IPP_Service, Object ID: 9a468411ed8e3da7a76cce28ad4701bf) XI AF API call failed. Module exception: (No information available). Cause Exception: 'Error processing request in sax parser: Error when executing statement for table/stored proc. 'table' (structure 'statement'): com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'SalesOrganization'.'.

SalesOrganization is the first field in the lookup on the target end. I also tried removing it but again the same error but with a different field.

in class com.sap.aii.mappingtool.flib7.SelectSingle method selectSingle[Database columns {[MaterialNumber]}, Database columns {[SalesOrganization], [DepartureCountry], [TaxCategory], [TaxClassification]}, false, JDBC_IPP_DBTable_Receiver (Party: , Service: BC_KCEU_IPP_Service, Object ID: 9a468411ed8e3da7a76cce28ad4701bf), [Lcom.sap.aii.ib.bom.flib.types.MTRecord;@3761ef0d, com.sap.aii.mappingtool.tf7.rt.ResultListImpl@7e955ae2, com.sap.aii.mappingtool.tf7.rt.Context@7f81ec5a]

[gagandeep_batra]

Hi Sudheer,

Can you  also check with data which you send to Lookup also

some time that may also contain quote(') which cause this type of error.

Regards

Gagan

[Former Member]

HI Sudheer

Just check the query. Also execute the query in the database and check whether it is working or not? and also Check out the Driver

Preethi.

[Former Member]

hello Sudheer,

Can you please add in you target structure details in your map and also the actual output xml..

Looks like the table name, structure is not what is being expected at the database end.

Regards.

Ninu