Consultor Eletrônico



Kbase P131338: DynSDO starts raising error 12766 after schema change
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   02/03/2010
Status: Verified

SYMPTOM(s):

Saving record via Dynamic SmartDataObject (DynSDO)

Call to validation hook in Data Logic Procedure (DLP) fails

<program-name> Cannot bind BY-REFERENCE parameter tables or datasets unless column datatypes, positions, extents and indexes match for tables <name> and <name>. (12766)

<DLP procedure name> Cannot bind BY-REFERENCE parameter tables or datasets unless column datatypes, positions, extents and indexes match for tables RowObjUpd and rowObjUpd. (12766)

FACT(s) (Environment):

OpenEdge 10.1B
OpenEdge 10.1C
Dynamics
All Supported Operating Systems

CHANGE:

Entity definitions were modified (calculated field was changed or database schema changes were imported)

CAUSE:

DynSDO's using the entities were not updated to reflect the changes made to the entities.
As a result, at runtime the temp-table schemas used by the DynSDO and it's DLP no longer match, which will trigger the errors seen.

FIX:

Update the affected DynSDO's by removing and re-adding the modified fields.