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
DRS stage error
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 41
- Joined: Tue Jan 24, 2006 3:43 pm
- Location: United States
- Contact:
DRS stage error
Knowledge is Power
-
- Premium Member
- Posts: 41
- Joined: Tue Jan 24, 2006 3:43 pm
- Location: United States
- Contact:
This is resolved
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