APT_CombinedOperator Controller

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
surez2000
Premium Member
Premium Member
Posts: 16
Joined: Sat Oct 28, 2006 2:13 pm
Location: SINGAPORE
Contact:

APT_CombinedOperator Controller

Post by surez2000 »

Hi All,

When I use a OCI stage I can view the data but when I write this to a sequential file the following error throws up (In Windows platform).

APT_CombinedOperatorController,0

caught Unknown exception from run locally().....(.......).

Fatal: Oracle OCI_1,0:Failure durng execution of operator logic.

Fatal: APT_CombinedOperatorController,0:Fatal Error:Fatal:Plugin stage property(TRANSSIZE) is not defined for stages.

Fatal: node_node1: Player1 terminated unexpectedly.

and also TRANSSIZE is not set.

Any help is appreciated.
Last edited by surez2000 on Tue Jan 16, 2007 10:28 am, edited 2 times in total.
Knowledge is Collection of Facts and Wisdom is Simplifying those Facts.

Suresh Nair
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

What is your full job desing? What is the full error log?
What is the message about TRANSSIZE?
If you feel the message is cryptic, enable APT_DISABLE_COMBINATION to False at job level. Reset the job, to get more detailed log.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
surez2000
Premium Member
Premium Member
Posts: 16
Joined: Sat Oct 28, 2006 2:13 pm
Location: SINGAPORE
Contact:

Post by surez2000 »

The error is as follows:


Fatal: Oracle OCI_1,0:Failure durng execution of operator logic.

Fatal: APT_CombinedOperatorController,0:Fatal Error:Fatal:Plugin stage property(TRANSSIZE) is not defined for stages.

Fatal: node_node1: Player1 terminated unexpectedly.


I just tried to write a Oracle file to a sequential file and the aove error throws up.
Knowledge is Collection of Facts and Wisdom is Simplifying those Facts.

Suresh Nair
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

What is the Transaction size that you have set in the OCI stage? If nothing is given, give some value.
Have you tried resetting the job to find "From previous log..." error message?
Have you tried disabling the combination of operator?
Is this topic resolved with workaround? If not you can delete the other duplicate post and edit the current post to change the topic heading if required.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

What is the workaround. What was the problem that you had. This is a rare problem and would really appreciate it if you share the solution with us. Also, you can delete your other post referring to the same problem.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply