on 09-22-2014 8:24 AM
Hi experts,
Please please help me out of this,
I have Proxy --->> Oracle table Scenario
When i check in my CC i m getting the following error.
Unable to execute statement for table or stored procedure. 'MYTABLE' (Structure 'Statement') due to java.sql.SQLException: ORA-00942: table or view does not exist
This is the payload in SXMB_MONI :-
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:PaymentDataDB xmlns:ns0="urnmynamesapce">
- <Statement>
- <dbTableName action="INSERT">
<table>MYTABLE</table>
- <access>
<PAYID>dsadsd</PAYID>
<MEMONBR>fsdfsd</MEMONBR>
<ISSUEDT>02-02-14</ISSUEDT>
<AMT>fsdfsdf</AMT>
<CRCY>sdfsdf</CRCY>
</access>
</dbTableName>
</Statement>
</ns0:PaymentDataDB>
And i'm sure i have entered the correct credintials on recevier JDBC channel.
Please help me on this.
Thanks,
Manoj K
Guyz i have checked the database the table exist with exact structure that i created in PI but still i am facing the same issue of "Table Not Found " error.
This is the Error i m getting in my receiver CC :
JDBC Adapter Receiver Channel JDBC_RCV_CustomerDataDB: Processing started; party / service RCV_STSTEM
Unable to execute statement for table or stored procedure. 'MYTABLE' (Structure 'Statement') due to java.sql.SQLException: ORA-00942: table or view does not exist
Please help me out of this i m stuck up here
Thanks,
Manoj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Manoj,
some times you will get the error, if the user you have mentioned in JDBC receiver channel does not have enough permissions to connect to right DB where the table (you have mentioned in mapping) resides.
Also check your JDBC channel log.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks guyz let me check with the databse and get back to u !!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check with the Database team regarding the table name as the error clearly indicates that it could not identify the table name.
BR,
Anirban
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
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.