Code: Select all
LKP1 LKP2
| |
V V
DRS --- IPC--TRANSFORMER --- IPC--DRS
But it is failing when MSSQL Server is used as source and target, we are getting the error like
Code: Select all
DataStage Job 741 Phantom 4936
Program "DSP.Close": Line 94, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT was raised in stage JOBNAME..TransformerName
Program "DSD.INTClose": Line 141, Unable to open the operating system file "DSD_BP.O/%".
[ENOENT] No such file or directory
Program "DSD.INTClose": Line 141, Unable to load file "".
Program "DSD.INTClose": Line 141, Unable to load subroutine.
Code: Select all
00089 002CC : 0F8 move "DSTAGE_RUN_E_0243" => _T0006
00089 002D2 : 0F8 move "Error %1 in $DSP.Abort" => _T0007
00089 002D8 : 196 subr "*DataStage*DSR_LOADSTRING" _T0006 _T0007 GCI.RESULT => ERROR
00090 002E6 : 0C2 jump 004A2:
00091 002EC : 0C2 jump 00344:
00092 002F4 : 2DE testfw 1 00344:
00093 002FC : 0F8 move 0 => GCI.RESULT
00094 00302 : 01E call "$DSP.Close" HANDLE GCI.RESULT
00095 0030C : 106 ne GCI.RESULT 0 => $R26
00095 00314 : 2DE testfw $R26 0033C:
00096 0031C : 0F8 move "DSTAGE_RUN_E_0244" => _T0008
00096 00322 : 0F8 move "Error %1 in $DSP.Close" => _T0009
00096 00328 : 196 subr "*DataStage*DSR_LOADSTRING" _T0008 _T0009 GCI.RESULT => ERROR
00097 00336 : 0C2 jump 004A2:
00098 0033C : 0C2 jump 00344:
00100 00344 : 0F8 move 0 => GCI.RESULT
00101 0034A : 01E call "$DS.ANYCLOSE" HANDLE GCI.RESULT
We are wondering why this error is coming when connecting to SQL Server DB alone and that too it is occuring only for some jobs and not for all jobs. Can someone suggest, how to proceed with this?