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 ?
Problem with Columns
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
Problem with Columns
hi sam here
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.