on 11-29-2007 4:37 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
sorry it is not throwing any error in Oracle
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
VJ,
When i execute the same SQL statement in Oracle, it is throwing any error from the oracle side.has it got something to do with the configuration of the adapter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.