RFC to JDBC Scenario

[Former Member]

Hi all,

I am getting below error in JDBC, while loading the data

com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'USER.STRUCTURE' (structure 'sqlStatement'): java.sql.SQLException: ORA-00984: column not allowed here

XML File going to JDBC.

<?xml version="1.0" encoding="UTF-8" ?> 
- <ns1:MT_STRUCTURE_REQ xmlns:ns1="http://*******.com/Interfaces">
- <sqlStatement>
- <dbTableName action="INSERT">
  <table>USER.STRUCTURE</table> 
- <access>
  <ID>20110330191939</ID> 
  <HIRE_TYPE>RETURNING</HIRE_TYPE> 
  <REQ_NUMBER>0000000070</REQ_NUMBER> 
  <PERNR>00150871</PERNR> 
  <EMPLOYEEGROUP>N</EMPLOYEEGROUP> 
  <EMPLOYEESUBGROUP>PS</EMPLOYEESUBGROUP> 
  <NETWORK_UID>CZG863</NETWORK_UID> 
  <FIRST_NAME>TESTFNAME</FIRST_NAME> 
  <LAST_NAME>TESTLNAME</LAST_NAME> 
  <BUILDING>ALR</BUILDING> 
  <BADGE>X</BADGE> 
  <BUILDING_ACCESS>X</BUILDING_ACCESS> 
  <PHONE_VMAIL>X</PHONE_VMAIL> 
  <EMAIL>X</EMAIL> 
  <COMPUTER>X</COMPUTER> 
  <REMOTE_ACCESS>X</REMOTE_ACCESS> 
  <OFFICE_NO>4</OFFICE_NO> 
  <OFFICE_KEY_NEEDED>X</OFFICE_KEY_NEEDED> 
  <NAME_PLATE /> 
  <SPECIAL_AREA /> 
  <BUILDING_AREA /> 
  <TIME_RESTRICTION /> 
  <BUILDING_ACCESS_LIKE>JI62</BUILDING_ACCESS_LIKE> 
  <DOT_NON_DOT>N</DOT_NON_DOT> 
  <CREDIT_CARD /> 
  <SPECIAL_REQUEST /> 
  <SUBMITTED_DATE hasQuot="No">( TO_DATE( '' , 'MM/DD/YYYY' ) )</SUBMITTED_DATE> 
  <SUBMITTED_BY>LMN030</SUBMITTED_BY> 
  <APC_CONTACT /> 
  <SOFTWARE_REQUESTED /> 
  <SAP_WORK_FLOW_OJB_TYPE>ZONBOARDNE</SAP_WORK_FLOW_OJB_TYPE> 
  <SAP_WORK_FLOW_OJB_KEY>0000000070</SAP_WORK_FLOW_OJB_KEY> 
  <REQUESTED_START_DATE>( TO_DATE( '' , 'MM/DD/YYYY' ) )</REQUESTED_START_DATE> 
  <REQUEST_CREATED_BY>LMN030</REQUEST_CREATED_BY> 
  </access>
  <key1 /> 
  </dbTableName>
  </sqlStatement>
  </ns1:MT_IMS_356_CASE_CREAT_SQL_REQ>

Its not clear , which column JDBC is pointing to??

any ideas..........

-santosh

[Former Member · Accepted solution]

While performing insert "KEY" is not required! Modify your data type accordingly

http://help.sap.com/saphelp_nwpi71/helpdata/EN/44/7b85050e6c3675e10000000a114a6b/frameset.htm

Regards

Ramg

[Former Member · Accepted solution]

Thanks ram,

I disabled the key & tried again....

But, still getting same error.

-santosh.

[Former Member · Accepted solution]

It seems the column that you defined under Access are not in sync with DB table columns. check your table columns and DT structure.

Regards

Ramg

[baskar_gopalakrishnan2]

>> Its not clear , which column JDBC is pointing to??

Few tips .....

a) Check the database column one by one and make sure that you mentioned exactly same as db in the access node.

b) Go to advanced tab in jdbc reciever channel. Specify logSQLStatement = true as parameter and run the test. See you get any specfic error message related to column in the adapter engine level.

[Former Member]

Thanks all,

Should the sequence of DT fields must be exactly similar to DB fields ??

-santosh.

[aashish_sinha]

HI,

I hope so, sequence should be similar to DB table. Have a look into below link.

http://help.sap.com/saphelp_srm40/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards

Aashish Sinha