Problem with Columns

samsuf2002 · Post by **samsuf2002** » Fri Feb 13, 2009 12:28 pm

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 ?

ray.wurlod · Post by **ray.wurlod** » Fri Feb 13, 2009 2:11 pm

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

samsuf2002 · Post by **samsuf2002** » Fri Feb 13, 2009 2:18 pm

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 ?

samsuf2002 · Post by **samsuf2002** » Fri Feb 13, 2009 3:59 pm

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

ray.wurlod · Post by **ray.wurlod** » Fri Feb 13, 2009 4:13 pm

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.

samsuf2002 · Post by **samsuf2002** » Fri Feb 13, 2009 4:22 pm

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

Do we need to do that periodically ?

ray.wurlod · Post by **ray.wurlod** » Sat Feb 14, 2009 2:06 am

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.