Consultor Eletrônico



Kbase P119400: Deploying a dynamics calculated field in a dynamic SDO results in error.
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   11/10/2006
Status: Unverified

FACT(s) (Environment):

Dynamics

SYMPTOM(s):

Deploying a dynamics calculated field in a dynamic SDO results in error.

Failed to add columns to the RowObjectTable.
Could not create Calculated Field' <fieldname> ' from Repository.
Calculated fields must be defined for an Entity.

Stack trace is:


icfstart.p (d:\progress\101A\gui\dynamics\icfstart.r) at line 519
initializeSession d:\progress\101A\gui\dynamics\af\app\afxmlcfgp.r (d:\progress\101A\gui\dynamics\af\app\afxmlcfgp.r) at line 2569
startProcedure d:\progress\101A\gui\dynamics\af\app\afxmlcfgp.r (d:\progress\101A\gui\dynamics\af\app\afxmlcfgp.r) at line 4404
D:\progress\101A\gui\_ab.r (D:\progress\101A\gui\_ab.r) at line 426
adeuib/_uibmain.p (adeuib/_uibmain.r) at line 17816
USER-INTERFACE-TRIGGER adeuib/_uibmain.p (adeuib/_uibmain.r) at line 5055
choose_run adeuib/_uibmain.p (adeuib/_uibmain.r) at line 8646
call_run adeuib/_uibmain.p (adeuib/_uibmain.r) at line 5712
launch_object adeuib/_uibmain.p (adeuib/_uibmain.r) at line 11859
launchContainer d:\progress\101A\gui\dynamics\af\app\afsessrvrp.r (d:\progress\101A\gui\dynamics\af\app\afsessrvrp.r) at line 10445
initializeObject ry/uib/rydyncontw.w (d:\progress\101A\gui\dynamics\ry\uib\rydyncontw.r) at line 5154
initializeObject ry/app/rydynwindp.p (d:\progress\101A\gui\dynamics\ry\app\rydynwindp.r) at line 2128
initializeObject ry/app/rydynframp.p (d:\progress\101A\gui\dynamics\ry\app\rydynframp.r) at line 3732
initializeObject adm2/containr.p (D:\progress\101A\gui\adm2\containr.r) at line 10360
initializeDataObjects adm2/containr.p (D:\progress\101A\gui\adm2\containr.r) at line 9670
initializeObject adm2/data.p (D:\progress\101A\gui\adm2\data.r) at line 11412
createObjects adm2/data.p (D:\progress\101A\gui\adm2\data.r) at line 4631
createRowObjectTable adm2/data.p (D:\progress\101A\gui\adm2\data.r) at line 22165
--> prepareRowObjectColumns d:\progress\101A\gui\dynamics\ry\app\ryrepsrvrp.r (d:\progress\101A\gui\dynamics\ry\app\ryrepsrvrp.r) at line 29305

Deploying the RYCSO dataset for an SDO with a new calculated field results in errors when the container using the SDO is run.

CAUSE:

The calculated field is not defined as an entity in the target Repository.

FIX:

To define the calculated field as an entity, a datafield ADO file must be created and loaded for it. In total there should be 3 ado's created from the RYCSO dataset. One for the SDO, one for the entity table and one for the calculated field.

As an example, if a calculated field (testCalc) is added to an employee dynamic smartDataObject, then the following 3 ado files should be deployed:

testCalc.ado
employee.ado
employeefullo.ado

Alternatively, open the SDO in the Appbuilder and save it into the target repository. This will register the calculated field as an entity.