ORA-00980: synonym translation is no longer valid

[Former Member]

Hi,

The messages are recorded with jdbc adapter to oracle database. The jdbc adapter is in error status. The following error occured:

JDBC Message processing failed, due to Error processing request in sax parser: Error when executing statement for table/stored proc. 'LGC_AMBALAJ_HAKEDIS_BASLIK' (structure 'STATEMENT1'): java.sql.SQLException: ORA-00980: synonym translation is no longer valid

Thanks in Advance

Nurhan

[Former Member · Accepted solution]

Copy the generated SQL query from the Channle monitoring log.

Run it on the DB SQL editor usign the SAP PI user you defined in the channel.

I belive this issue has to do with a missing synonym definision.

Forword your tests results to a DBA to provide the relevant synonym.

[Former Member]

Hi,

This problem is due to not be the corresponding table on database.

Thanks for your help

Nurhan

[baskar_gopalakrishnan2]

>ORA-00980: synonym translation is no longer valid

ORA-00980: synonym translation is no longer valid" is a common error can happen for many reasons. Some of them are

1. You created a synonym on non-existing object by mistake.

2. You dropped an object but you did not drop the synonyms referencing the object.

[GabrielSagaya]

Check out with your DB Admin regarding this

http://www.dba-oracle.com/sf_ora_00980_synonym_translation_is_no_longer_valid.htm

[Former Member]

What type of call is? Select, insert, SP, update?

Probably, there're some error in parameters type or Statement Structure (or in Select string)