DRS stage error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
pratapsriram
Premium Member
Premium Member
Posts: 41
Joined: Tue Jan 24, 2006 3:43 pm
Location: United States
Contact:

DRS stage error

Post by pratapsriram »

The job has a simple transformation.
DRS(Source) -> Lookup -> Lookup -> Transform -> DRS(Target).

The job completes successfully with warnings.
The first warning is:
APT_CombinedOperatorController,0: Invalid character(s) ([xD1]) found converting string (code point(s): Warning: Trfm_STG_ADW_PROVIDER_PLAN_prov.STG_ADW_ProviderPlan: ProgramMRefId = 2...) from codepage UTF-8 to Unicode, substituting.

When I debug the job by 'view data' from the designer, I get the error:
Trfm_STG_ADW_PROVIDER_PLAN_prov..STG_Provider_Contract: Pin 1 not initialized
Trfm_STG_ADW_PROVIDER_PLAN_prov..STG_Provider_Contract.DSLink1: DSP.Close Error -100 in $DSP.Close.

Has anyone seen this error before? I tried searching the forum and could not find any posts. What does 'Pin1 not initialized' mean? Is this a job related error or an engine related error?

Any suggestions are greatful.

Thanks,
MS
Knowledge is Power
pratapsriram
Premium Member
Premium Member
Posts: 41
Joined: Tue Jan 24, 2006 3:43 pm
Location: United States
Contact:

This is resolved

Post by pratapsriram »

The above error is due to the mismatch between the NLS settings for the job during run time to the NLS setting in the Server map. A detailed article is given in this LINK. So to view data change the NLS setting of the DRS stage to Project Default and try the 'View Data'.
Knowledge is Power
Post Reply