Kbase P127409: Error 7331 occurs when repositioning to ROWID on Progress table and a DataServer table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/12/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1B
MS SQL DataServer
Oracle DataServer
SYMPTOM(s):
Including tables from Progress database and DataServer database in a query
Error 7331 occurs when using REPOSITION-TO-ROWID or REPOSITION <query> TO ROWID <rowid>
Examples:
<query>:REPOSITION-TO-ROWID(BUFFER <Progress>.<Table>:ROWID, BUFFER <DataServer>.<Table>:ROWID).
REPOSITION <query> TO ROWID ROWID(<Progress>), ROWID(<DataServer>).
Cannot reposition query <name> to recid/rowid(s) given. (7331)
With DataServer for Oracle, Progress record is available but Oracle record is not
With DataServer for MS SQL Server, neither record is available
Problem does not occur when using only Progress tables
Problem does not occur when using only DataServer tables
CAUSE:
This is a known issue
FIX:
Only reposition to the rowid of the Progress buffer. For example, use:
hQuery:REPOSITION-TO-ROWID(BUFFER sports.employee:ROWID).
Instead of:
hQuery:REPOSITION-TO-ROWID(BUFFER sports.employee:ROWID,
BUFFER oe10.department:ROWID).