on 09-07-2006 6:57 AM
Hi,
I am Desinged and Configured i am getting error message while passeing a message from idoc-xi-Oralce.
Below message been displayed
Error
Unable to execute statement for table or stored procedure. 'dbTableName' (Structure 'STATEMENT') due to java.sql.SQLException: ORA-00942: table or view does not exist
2006-09-06 18:13:26
Error
Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. 'dbTableName' (structure 'STATEMENT'): java.sql.SQLException: ORA-00942: table or view does not exist
Need an Helpful answers
Thanks
Hari
Hi Hari,
Try to specify to use the following format for the table name:
<schema name>.<table name>
Some of the receiver JDBC actions don't allow you to use ".", but others allow it.
Cheers,
Ofer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The error clearly states XI can not find the table.
Check the table name(It is case sensitive).
Regards,
Jai Shankar.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hari,
Can you please paste the Data type / payload going out of MONI to the JDBC adapter ..
And also the INSERT / UPDATE query that you are trying
Regards,
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bhavesh,
Here is payload data
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:MT_DMZ_SAP_CONTRACT_RE xmlns:ns0="http://sap.com/xi/CRMtoXIUpdateOracle">
- <STATEMENT>
- <dbTableName action="UPDATE_INSERT">
<sap_contract>sap_contract</sap_contract>
- <access>
<CTC_CONTRACT_ID>0005000084</CTC_CONTRACT_ID>
<CTC_CONTRACT_TYPE_CD>ZRES</CTC_CONTRACT_TYPE_CD>
<CTC_YEAR>empty</CTC_YEAR>
<CREATE_DATE>08/16/20</CREATE_DATE>
<CREATED_BY>DZTHOMAS</CREATED_BY>
<CTC_SIGN_DATE>08/16/20</CTC_SIGN_DATE>
<MODIFY_DATE>09/06/20</MODIFY_DATE>
<MODIFIED_BY>KICAIRNES</MODIFIED_BY>
</access>
</dbTableName>
</STATEMENT>
</ns0:MT_DMZ_SAP_CONTRACT_RE>
Thanks for helping me for all
THanks
Hari
Hari,
The point is simple here..!!
You are trying an UPDATE_INSERT and there is no KEY..
Just do the following,
Make action as INSERT . This will insert a row into the table which is what you are trying I guess..
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:MT_DMZ_SAP_CONTRACT_RE xmlns:ns0="http://sap.com/xi/CRMtoXIUpdateOracle">
- <STATEMENT>
- <dbTableName action="<b>INSERT</b>">
<sap_contract>sap_contract</sap_contract>
- <access>
<CTC_CONTRACT_ID>0005000084</CTC_CONTRACT_ID>
<CTC_CONTRACT_TYPE_CD>ZRES</CTC_CONTRACT_TYPE_CD>
<CTC_YEAR>empty</CTC_YEAR>
<CREATE_DATE>08/16/20</CREATE_DATE>
<CREATED_BY>DZTHOMAS</CREATED_BY>
<CTC_SIGN_DATE>08/16/20</CTC_SIGN_DATE>
<MODIFY_DATE>09/06/20</MODIFY_DATE>
<MODIFIED_BY>KICAIRNES</MODIFIED_BY>
</access>
</dbTableName>
</STATEMENT>
</ns0:MT_DMZ_SAP_CONTRACT_RE>
Regards,
Bhavesh
If you only need to do insert use insert in ACTION attrribute, if you need update or an insert go for UPDATE_INSERT .
The key tag must contain the values you specify in where condition, for ex. if you want your SQL to look like this
UPDATE <TABLEE-NAME> set field1 = "value" where field2 = "value2"
Your key tag should contain <field2> and it should be mapped with value2(either from source structure or with a constant.
Regards,
Jai Shankar.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.