DSXchange

I have a PX job with a dataset---->Standardize stage---->Filter----->sort then rest of the stages. Jobs runs fine in test server but when we move it to production it failed with bunch of warnings and errors like

errors-

Filter_125: StreetName_USADDR is not a valid field name
HouseNumber_USADDR is not a valid field name

Sort_24: Sort key field not found: HouseNumber_USADDR

Filter_27: The specified field: COST_ID does not exist in the view adapated schema.
The specified field: COST_ID does not exist in the view adapated schema.

everything is same as it was in test, I even tried enabling and disabling RCP since the Standardize stage uses RCP.

When I moved the same job from production to test its working fine.

Can anyone help me out here ?

What's different in production? In production have you provisioned the rule set used by the Standardize stage?

Thanks for the reply Ray. Actually I am not much familiar with Quality Stage part. Can you guide me how to check the rule set is provisioned ?

There is nothing different in production. I am using USADDR.SET in Standardize stage.

Provisioning is the act of transferring the Rule Set from the QualityStage client onto the server. Right click on the Rule Set and choose "Provision All" from the menu.

I did provision all and its working now, Thanks a bunch Ray.

Do we need to do that periodically ?

No, only once for each Rule Set, or each time you modify a Rule Set. However, you do need to do it onto each DataStage/QualityStage server machine; this is the step you missed.