when i call query rule rule!mdm_getallcountries() i am getting the following err

anjannat over 10 years ago

when i call query rule rule!mdm_getallcountries() i am getting the following error,
Expression evaluation error in rule 'mdm_getallcountries' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected TypedValue type: FacetOptionCfg (id=688). Expected: IS_MDM_COUNTRY^5 (id=6748). accessor=TypedValueFieldAccessor{dt=IS_MDM_COUNTRY^5 (id=6748), fieldName=countryId, fieldDtId=1, fieldIndexes=[0]},
Here "is_mdm_Country" is a CDT having the countryId,countryName,created date,user.thanks in advance..............

...

Discussion posts and replies are publicly visible

0 Eduardo Fuentes
Appian Employee
over 10 years ago

This error indicates there's an issue with your DT_MODEL table. Notice how Appian is trying to find your CDT in the corresponding row of the DT_MODEL table in the primary data source using the external ID it has registered but since your DT_MODEL doesn't correspond to this environments' engines then the external ID is actually not for your CDT but for an out of the box data type FacetOptionCfg
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 10 years ago

This can be introduced by deleting the content of the DT_MODEL table, by making the environment point to the wrong primary DS or if this environment was upgraded the the primary DS wasn't upgraded and the environment was connected to a clean new primary DS.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 anjannat over 10 years ago

is there anything that we can do to resolve it?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 10 years ago

1. Create an application with all your CDTs in another environment
2. Delete the CDTs in this environment
3. Import the app from step #1 so your CDTs get a new external ID

Or find the right data source by finding a back-up or investigating what happened with the original one.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 anjannat over 10 years ago

thank You....eduardo fuentes,now its workiing fine.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sainadhn over 10 years ago

Hi,I also have the same problem. even doing the steps suggested by Mr.eduardo iam geting the same error.is there any other alternative?plz suggest
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 10 years ago

Depending on how big the lack of synchronization is you may need to repeat this procedure several times: Delete CDTs- Reimport until the ":counter" in process design syncs with the current value of the primary key "sequence" in that table. If you cannot find the original primary DS then keep repeating these steps.

Keep in mind that in order to avoid this issue you should never touch the DT_MODEL table and you should always bring it with you when upgrading to a newer version.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel