cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-00942: table or view does not exist

manoj_khavatkopp
Active Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

manoj_khavatkopp
Active Contributor
0 Kudos

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

naveen_chichili
Active Contributor
0 Kudos

Hi Manoj,

Check if the user has the access/authorizations to the schema you are trying to access from the DB.

Regards,

Naveen    

former_member257758
Participant
0 Kudos

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.

manoj_khavatkopp
Active Contributor
0 Kudos

Thanks guyz let me check with the databse and get back to u !!

Former Member
0 Kudos

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

javier_alcubilla
Contributor
0 Kudos

Hi Manoj

It seems that the connection is ok. Oracle is retuning that error becausa can't find the Table in the db

Please check the calling structure:

This is a correct structure

Regards

Javi

manoj_khavatkopp
Active Contributor
0 Kudos

Hi javier,

I have followed the same structure as u gave but getting the same error.

Thanks

javier_alcubilla
Contributor
0 Kudos

Try changing this tag:

- <dbTableName action="INSERT">



to


- <MYTABLE action="INSERT">

iaki_vila
Active Contributor
0 Kudos

Hi Manoj,

Try to use the name of the schema before the name table: myschema.mytable.

Regards.

manoj_khavatkopp
Active Contributor
0 Kudos

can u tell me how u do this ? bcoz the payload which i mentioned above is generated once i test in RWB with source payload (taken from Message mapping)

manoj_khavatkopp
Active Contributor
0 Kudos

Ya i got it how to do it but the issue remain same in CC