Kbase P34388: Create physical table within foreign db when getting error 725
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/06/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
Can not change the program
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:
1. Create a physical table, in this case it's _user, within the foreign database
2. Pull the physical table back into the Progress schema image, via the DataServer UPDATE/ADD Table Definitions
3. And finally, load the .d and/or the data through the Data Administration Menu
This way, you do not need to change the program. The new table will reside within the schema image, and the program explicitly states:
<schema-image-name>._user