DSXchange

Dear All,

My job design Look like this


Odbc-----------------Xfm-----------------Oracle
(Sql Server)


when i tried to view data from oracle oci stage i am getting the following error

pin 1 not initialized

DSLink1:DSP.Close Error - 100 in $DSP.Close

Please help me in resolving this.

Thanks & Regards
Sundar

Help us help you. Is this your first time trying to access Oracle from a job? If not, is there anything different about this one from others that work?

Dear Chulett,

For Testing , we got the Dsx from the Production and import in to the Testing server, For all the OCI stage in the project, i am getting this error.

Thanks,
Sundar

Has this 'Testing server' been configured for Oracle? What is different about it from Production other than the server it lives on?

I know I'm reviving a very old thread, but I just had this same error in a job today under the same circumstances (moving something to production).

I determined that someone had manually changed the DSParams file for the project to add some new production environment variables and had introduced an error into the file, in essence corrupting the project. This affected px jobs differently, they were giving memory faults, where server jobs were having this problem with the "pin 1 not initialized".

I removed the bad lines from the DSParams file and the error messages went away. Marking this one "resolved" for now.

I get these errors when I do a "View Data" for my DB2 stage (API) whose NLS is set to "OFF". We did this because we were having "glibc" errors when the NLS is set to Project default. But, the jobs run fine though.