Kbase P81661: A ProDataSet with multiple buffers on one temp-table causes problems with AppServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/18/2007 |
|
Status: Verified
FACT(s) (Environment):
OpenEdge 10.x
All Supported Operating Systems
OpenEdge Category: Language (4GL/ABL)
SYMPTOM(s):
A ProDataSet with multiple buffers on one temp-table causes problems with AppServer
ProDataSet has two buffers pointing for same temp-table
Duplicate records are created
** <file-name> already exists with <field/value...>. (132)
CAUSE:
It should not be possible to use multiple buffers on single temp-table in a dataset. The reason for this is that one of the design requirements of the ProDataSet is to map closely to the .NET dataset, and .NET is not capable of handling multiple buffers on a single table.
CAUSE:
Bug# OE00104623
FIX:
Upgrade to OpenEdge 10.0B or later release.
The later releases handle this limitation better, and raise an appropriate error message when it is hit, instead of reporting the symptoms that would occur later on in the process.
Possible workarounds for the limitation:
1. Within the dataset, use multiple temp-tables instead of multiple buffers.
2. Manage the second buffer outside of the dataset. Note that for this to work, the FILL logic also needs to be modified to ensure the single temp-table in the dataset has all required records.