JDBC adapter error

[Former Member]

Hello, I am trying to configure a scenario which uses the JDBC adapter. I have read a few weblogs and looked over the sap help page on the structure of the message for XML-SQL. I am getting the following error in the runtime workbench (communication channel monitoring): ORA-00984: column not allowed here

I think this may be a result of several possible issues.

1. Perhaps I have made my XML target structure incorrectly. It looks as follows:

si_order_structure
     STATEMENT
          TABLENAME
               action (constant: INSERT)
               TABLE (table: SI_ORDER)
               access
                    tablenames
                    etc
                    etc

Should the STATEMENT and TABLENAME be mapped to anything? A constant of some sort?

The message payload in runtime workbench looks like this:

  <?xml version="1.0" encoding="UTF-8" ?> 
- <ns0:si_order_structure xmlns:ns0="http://server.com/ECC/HJ">
- <STATEMENT>
- <TABLENAME action="INSERT">
  <TABLE>SI_ORDER</TABLE> 
- <access>
  <TRANS_NUMBER>PWSTESTSAP</TRANS_NUMBER> 
  <TRAN_TYPE>A</TRAN_TYPE> 
  <STAGED_DATE>05-APR-2007</STAGED_DATE> 
  <PROCESS_FLAG>N</PROCESS_FLAG> 

Any advice would be greatly appreciated!

[MichalKrawczyk · Accepted solution]

Hi Ethan,

since you need to be able to find errors youself

you need to learn to search for them:)

to see exactly what kind of query is executed by jdbc adapter use:

logSQLStatement parameter

from SAP note: 801367

this will show you everything you need

Regards,

michal

[Former Member · Accepted solution]

Thanks Michal, ironically enough I had actually turned this on yesterday shortly after posting this question and solved it. Neverless, thanks a lot for your input