Hi gurus,
iam using odbc stage as source.
odbc--->transformer---->odbc.
i have created parameters for odbc connection, user name and password in administrator.
i called them through designer and used in the source stage,
i can view the data from source stage.i can compile the job without errors but when i run the job iam getting error.
went to director, iam getting
drs13..Transformer_2: |drs13..ODBC_0: DSD.BCIConnect Failed to map LOGON2. LOGON2: ??, NLS map: MS1252|
iam not able to analyze error.
i checked with the parameters, they are correct since i can view the data from source stage.
plz help me.
cheers;
vijay
peculiar problem when running job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
We are getting the exact same error. It is happing on the link coming out of a database read.
"DSD.BCIConect Failed to map LOGON2. LOGON2: ???, NLS map: MS1252"
The strange thing is, it does not always happen. The job runs throughout the day and it only intermittently gets this warning.
ray, I know this is an old post, but if you are still out there... did you find a solution to this?
This job is using datastage 7.5.
"DSD.BCIConect Failed to map LOGON2. LOGON2: ???, NLS map: MS1252"
The strange thing is, it does not always happen. The job runs throughout the day and it only intermittently gets this warning.
ray, I know this is an old post, but if you are still out there... did you find a solution to this?
This job is using datastage 7.5.