jdbc sender error

[sahana_ps]

hi all,

Database-level error reported by JDBC driver while executing statement 'SELECT * FROM TABLE_NAME'. The JDBC driver returned the following error message: 'java.sql.SQLException: ORA-00942: table or view does not exist '. For details, contact your database server vendor.

can anyone help to solve this issue?

[Former Member · Accepted solution]

HI sahana,

The error can be because of several reasons.

1) you may be giving the wrong credentials (the user name and password to connect to the db, or the wrong data base schema name)

2) the table you are looking for is not there in the data base

3) you may be specifying the table name incorrectly

If you have a separate data base editor like TOAD or sql developer try to run the same query there in the editor. You will get the exact reason for the error.

Regards

Harisankar

[sahana_ps]

thank you all for ur reply.i resolved this issue by using schema_name.table_name in select query

[baskar_gopalakrishnan2]

Check the same query using database client tool like TOAD to make sure you have such table name and table which corresponds to the schema. Check with DBA whether you need to access table name only via schema name. This is pure configuration issue.

[naveen_chichili]

Hi,

Check if your table which you are trying to access is present in your DB.Aslo ensure that you are providing the right table name in the PI Configuration.

Thanks and Regards,

Naveen

[Former Member]

Hi Sahana,

I'd try to specify not only the table name, but also the schema. As you know, you are accesing the table from outside of SAP, so the schema name is not assumed by the RDBMS.

Please try with this SELECT * FROM SCHEMA.TABLE_NAME

Keep in mind that, depending on your installation, SCHEMA can be "SAPR3" or "SAP<SID>"

Hope this helps

Best Regards

Francisco

[Former Member]

Hi,

Addition to the above.check the user name you are using is able to access that table or DB....

HTH

Rajesh

[Former Member]

by looking the error it seems either ur table does not exist on DB or u r using wrong table name...

cross chk the same and execute the same select statement in DB...

[PriyankaAnagani]

Hi,

Please check whether the table name that you've given is correct or not. Go through this discussion.

Regards,

Priyanka