DataStage Job 113 Phantom 21941

[ksfun]

After running the job provide the following warning message:-

BSCServicesRoundRobin..Partitioner: DSD.INTOpen Active stage starting, tracemode = 0.

Attempting to Cleanup after ABORT raised in stage BSCSContrServicesMigRoundRobin..Partitioner

BSCSServicesRoundRobin..Partitioner: DSD.INTClose Active stage finishing.
7 rows read from L_Services
6 rows written to R_incservices9
0 rows written to R_incservices8
0 rows written to R_incservices7
0 rows written to R_incservices6
0 rows written to R_incservices5
0 rows written to R_incservices4
0 rows written to R_incservices3
0 rows written to R_incservices2
0 rows written to R_incservices1

DataStage Job 113 Phantom 21941
Program "JOB.352603420.DT.1384058246.TRANS1": Line 109, Variable previously undefined. Zero length string used.
Program "JOB.352603420.DT.1384058246.TRANS1": Line 109, Incorrect VOC entry for .
Program "JOB.352603420.DT.1384058246.TRANS1": Line 109, Unable to load subroutine.
Attempting to Cleanup after ABORT raised in stage BSCSServicesRoundRobin..Partitioner
DataStage Phantom Aborting with @ABORT.CODE = 3

Job BSCServicesRoundRobin aborted.

Thanks for helping :)

[kcbland]

Go to the project directory, subdirectory RT_BP113 (DataStage Job 113 Phantom message). The error message indicates that a function call in the transformer has a variable unassigned. It also appears that variable relates to a variable subroutine name (Unable to load subroutine) which is attempting to be called with a blank (zero length string used message).

Check file JOB.352603420.DT.1384058246.TRANS1 which is the DS BASIC version of the transformer stage. Around line 109 is the call to the subroutine logic. You need to figure out why the argument being used was never assigned prior to calling.

[ksfun]

Thanks for your reply. We have solve this problem.

Initially,we used the Link Partitioner Stage to distribute partitioned rows to 9 output links direct from the transformer stage. This made the job aborted with warning message.

We find out that, the Transformer Stage and Link Partitioner Stage are the active stage. Active Stage can not direct link to.

Finally we change the design as below:-

Transformer Stage link to a Sequential Stage to collect together first, then use Link Partitioner Stage to distribute to 9 output links.

After we use this design, the problem was solved.


Thank you very much!

[nkln@you]

Hi,

I m having a similar problem. The error i got was
DataStage Job 870 Phantom 2765
Program "DSD.StageRun": Line 571, Incorrect VOC entry for 0.
Program "DSD.StageRun": Line 571, Unable to load subroutine.
Attempting to Cleanup after ABORT raised in stage Job1..Link_Partitioner_14
DataStage Phantom Aborting with @ABORT.CODE = 3

I am using link partitioner to divied the incoming rows to 3 seq. files and then from these 3 seq. files i am loading a table.
The structure is
Oci Stage----> Link Partitioner--- > 3 seq. files---> 3 trasnformer--> Oci Stage.

What is wrong in this? and How do i correct it?

[ray.wurlod]

Find the name of the routine that is being called and make sure it is properly cataloged in the VOC.