search cancel

Moving model from Gen HE to CSE "prop fetch" error ptc 57

book

Article ID: 4043

calendar_today

Updated On:

Products

Gen Gen - Workstation Toolset Gen - Host Encyclopedia Gen - Run Time Distributed

Issue/Introduction

When moving a model, a subset, or a child model to Gen Client Server Encyclopedia (CSE) from the Gen Host Encyclopedia (HE), the following error message can be received when uploading to CSE:
PRgChr: column value out of range obj=1331128, ptc=2012426714, col=2147348480 Prop fetch: error fetching character property Object id = 1816004, ptc = 57  

Does this indicate a corruption in the model on the HE?

Environment

Release: Any

Cause

This is caused by having the property CONIND set.  This property was removed from the schema rules but may still be in models built with older releases of Gen.

Resolution

The property CONIND (pseudo-property ) was used briefly in the very early IEF/Gen releases, but has been obsolete for a long time. It can be deleted.

The SQL to find all "CONIND" Object properties in the Host Encyclopedia is:
SELECT * FROM DPRP WHERE PROP_TYPE_CODE = 57;

To delete the rows from DPRP:
DELETE FROM DPRP WHERE PROP_TYPE_CODE = 57;  

Then Checkout model/subset or child model and upload it to CSE.