Kbase P125956: WebSpeed session crashes intermittently with Oracle error -3120
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/19/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1B
SYMPTOM(s):
WebSpeed session crashes intermittently with Oracle error -3120
oracle error 3120: "two-task conversion routine: integer overflow"
The problem is intermittently happen on the "FOR EACH/FIRST/LAST NO-LOCK" query
The Oracle table has a BLOB data type
No protrace file generated for the crash
WebSpeed agents connect the the Oracle DataServer schema holder
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
The workaround is to use the QUERY-TUNING(NO-LOOKAHEAD) on the FOR EACH/FIRST/LAST NO-LOCK query.
Example:
FOR FIRST <TableName> NO-LOCK
WHERE . . . . .
QUERY-TUNING(NO-LOOKAHEAD):
END.
...