Kbase P98534: Record is not available when the table's FOREIGN-OWNER is not informed
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/06/2005 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Record is not available when the table's FOREIGN-OWNER is not informed.
Running a FIND FIRST in EXCLUSIVE-LOCK
The FOREIGN-OWNER information of the table is set to ?
CAUSE:
This is a known issue being investigated by Development
FIX:
Change the FOREIGN-OWNER and set it to a valid Oracle user name.
There are 2 possible ways:
1- By modifying the .df file:
o Dump the schema holder's tables from the Data administration
o Add the FOREIGN-OWNER for each table:
ex.: FOREIGN-OWNER "User1"
o Delete the tables in the schema holder
o Load the tables from the modified .df file
2- By modifying the FOREIGN-OWNER from 4GL:
o Modify the value of the field "_for-owner" for each Oracle table contained in "_File"
For further information, see Solution P12505.
o Disconnect and re-connect to the schema holder
This is required otherwise the change will not be taken into account.