Skip to Content
author's profile photo Former Member
0
Former Member

invalid identifier

Posted on Nov 29, 2007 at 04:37 PM 189 Views

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Vijayashankar Konam
    Vijayashankar Konam
    Posted on Nov 29, 2007 at 04:39 PM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 05:10 PM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 05:11 PM
    0

    sorry it is not throwing any error in Oracle

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 12:07 AM
    0

    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
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.