Kbase P128620: Errors 13123 and 13032 occur with READ-XML method using long temp-table names
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/20/2008 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1B
OpenEdge 10.1C
All Supported Operating Systems
SYMPTOM(s):
Writing a ProDataSet to XML with WRITE-XML method and then reading generated XML file back in with READ-XML method
Process fails with errors 13123 and 13032 on READ-XML method
Index name is limited to 32 characters. (13123)
Unable to create Temp-Table or dataset schema from XML Schema. (13032)
Temp-tables in code have long names (32 characters)
Temp-tables both have primary unique indexes with the same name
CAUSE:
Bug# OE00164059
CAUSE:
This is a known issue, caused by the Unique indexes having the same name. The temp-table name is appended to the index name in order to generate a unique index name. This results in an index name exceeding the 32 character limit being written to the XML file.
Index #1
<xsd:unique name="Main" prodata:primaryIndex="true">
Index #2
<xsd:unique name="ttb45678901234567890123456789012_Main" prodata:primaryIndex="true">
FIX:
Option #1
Upgrade to 10.1C01
Option #2
Use shorter temp-table names
Option #3
Use different names for the unique indexes