Hi Experts,
I doing a interface HTTP--JDBC synchronous.While i test the scenario, i'm getting the following error
Result:
<SAP:Error><SAP:Category>XIAdapterFramework</SAP:Category><SAP:Code>MESSAGE.GENERAL</SAP:Code><SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'kss_activity_stg' (structure 'STATEMENT'): java.sql.SQLException: ORA-00904: "KEY": invalid identifier
</SAP:AdditionalText></SAP:Error>
Can you please help me out in this regard?
thanks
Pravin
This error is thrown by the ORACLE and caught in the adapter module. Ask you DB people to look into the error. They should be solving it in seconds..
VJ
Rodrigo Pertierra.
I am using the following parameters in JDBC adapter
Drivers: oracle.jdbc.driver.OracleDriver
Connection:jdbc:oracle:thin:@10.190.16.2:1521:TRETAIL
Username and Password
Unchecked Key Tags Mandatory
Persistence : Local
Select Query
'SELECT esiid, address, city, state, zipcode, status, tdsp from tdsp_esiid WHERE tdsp = 'CPL_ENERGY'
THX
PC
Add a comment