Kbase P33810: Get error 915 when search using FIND FIRST on client-server connection
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Get error 915 when search using FIND FIRST on client-server connection
FIND FIRST pminsevt EXCLUSIVE WHERE
STRING(ROWID(pminsevt)) = tt-insevt.row-id NO-ERROR.
Lock table overflow, increase -L on server (915)
CAUSE:
Expected behavior: Is used a whole index (in this case the primary index).
The server will lock and sent to the client side for evaluation one by one all the records until he will get the right record.
Depending on the position in the database of the demanded record and depending on the -L database startup parameter, the system will give error 915.
FIX:
Search directly on ROWID or using a good index (not WHOLE-INDEX).
Ex.:
FIND FIRST pminsevt EXCLUSIVE WHERE
ROWID(pminsevt) = tt-insevt.row-id NO-ERROR.
You can check what is the used index compiling the program with XREF option.