Diagnostics
Symptom
(FOC1400) SQLCODE IS 942 (HEX: 000003AE)
(FOC1409) SQL TABLE NOT FOUND. (FOR TABLE: CHECK SEGNAME AND TABLE)
(FOC1500) : ORA-00942: table or view does not exist
(FOC1500) : Erroneous token: TEK_HDCNT_INTRNL
(FOC1406) SQL OPEN CURSOR ERROR. : TEK_HDCNT_INTRNL
Problem
When creating a synonym against an Oracle database instance, some tables cannot be located. Using some of the existing synonyms results in the error messages above.
Solution
The edasprof.prf file contained two Oracle adapter connections strings with the same connection names, but they referenced different database instances. In these cases, the incorrect connection string was being used. Removing the duplicate adapter connections string entry resolved the issue.