Kbase P115906: Passing shared temp-table as output table parameter causes random issues
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/01/2009 |
|
Status: Verified
SYMPTOM(s):
Passing shared temp-table as output table parameter causes random issues
Using shared temp-tables
Passing shared temp-table as OUTPUT TABLE parameter
The following errors may occur when using the temp-table after it was passed as a parameter:
Temp-table schema for <name> not found. (3273)
Unable to create schema information for temp-table <table>. (3244)
SYSTEM ERROR: rmmak failed, retcode=-20011 (1106)
SYSTEM ERROR: rmmak failed, retcode=<value> (1106)
Session may crash
Session may hang
FACT(s) (Environment):
OpenEdge 10.0x
OpenEdge 10.1A
All Supported Operating Systems
CAUSE:
Bug# OE00128684
FIX:
Upgrade to OpenEdge 10.1A02 or later
Upgrade to OpenEdge 10.1B or later
Workaround:
Do not pass the shared temp-table as output parameter directly. Instead, copy it to an intermediate temp-table and pass that as the output parameter.
Note that depending on the amount of data in the temp-table, this may have a noticable performance impact.