Error: The link contains no derivation rules

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
divya_ascential
Participant
Posts: 7
Joined: Sat Jul 15, 2006 9:37 pm

Error: The link contains no derivation rules

Post by divya_ascential »

Hi all

iam doing a job for parsing XML input and placing into tables.
The job structure is:

seq_file-> XML Input stage -> Transformer -> ODBC stage


Iam getting a warning at XML input stage:-

Error: The link contains no derivation rules

after this there are fatal errors:

- Error occurred in call to ORPHCallActivePluginInitialize().

- the runLocally() of combination of 3 operators , partition 0 of 1, processID 11,399 on node1 failed.

- APT_CombinedOperatorController(0),0: Operator terminated abnormally: runLocally did not return APT_StatusOk

- main_program: Unexpected exit status 1

and the job gets aborted .... :(

I have checked the derivations of the XSD, the datatypes in transformer and all the possibilities i know.

Plz help.

Thanks.
Divya
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Can you garner any more information from the generated OSH? It appears to be complaining about a link - are you certain it's the XML input link? Can you post the exact and complete text of this error message? I presume that the job compiles without error.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Try a run with APT_Combine_Operator = 'FALSE'.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

He means APT_DISABLE_COMBINATION of course. :wink:

This will allow you to narrow down the problem to the specific operator in which it is occurring, rather than be bewildered by operators combining to execute in the same process.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Or the similar option available in Transformer.
I always miss those APT* variable with the given huge list. :evil:
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

That's just not good enough, is it? :wink:
What do you do when you have to use one "for real"?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply