Kbase P34387: Getting error 725 when compiling procedure against schema holder and foreign database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/19/2006 |
|
Status: Unverified
FACT(s) (Environment):
DataServer
SYMPTOM(s):
Getting error 725 when compiling procedure against schema holder and schema image
Getting error 725 when compiling procedure against schema holder and foreign database
Getting error 725 when running application against SQL Server
Getting error 725 when running application against ORACLE
Getting error 725 when running application against foreign database
Unknown or ambiguous table <table>. (725)
Program uses schema image name when referencing a hidden table
Program uses schema image name when referencing the _user table: <schema-image-name>._user
_user is a hidden table that resides within Progress Schema holder
CAUSE:
The issue here is that the program is incorrectly referencing the wrong database name. It should reference the SCHEMA HOLDER name rather than the schema image name. All hidden tables reside within a Progress db, type PROGRESS, thus not the schema holder.
FIX:
Program needs to be changed so that it will reference the schema holder name, not the schema image name.
<schema-holder-name>._user