XML Assembly Stage Error

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
visvacfirvin
Premium Member
Premium Member
Posts: 49
Joined: Fri Dec 14, 2007 1:43 pm

XML Assembly Stage Error

Post by visvacfirvin »

Hi, I've been using XML assembly stage to parse XML files. So far it was good but recently i started getting error in one of the file type. XML Schema looks as below with hierarchy indicated by tab.

Code: Select all

Root
	Header Attributes
	Parent 1
		Child attributes
		List 1 (key)
		List 2 (message)
		List 3 (detail)

		Parent 2
			Child attributes	
			List 21
			List 22
			List 23

			Parent 3
				Child attributes
				List 31
				List 32
				List 33
This is my logic to flatten out the lists.
1. List 1 has 1 element but repetitive. Same for List 2 and 3.
2. Joined List 1 and 2 using Order join.
3. Joined List 1 and 3 using Order join.
4. Join outcome of step 2 and 3 using HJoin using key and generate final consolidated list.
5. Repeat the same for List 21,22 and 23. Similarly for 31, 32 and 33.
6. Its a complex schema with multiple XSD files and List(1,2,3) , List (21,22,23) etc share same XSD.
7. My issue is when I use the logic mentioned above, it works fine till the lists in Parent 2. When i hit Parent 3, i get following error.
Message bundle error Can't find resource for bundle com.ibm.e2.Bundle_E2_engine_msgs_en_US, key E2IllegalStateException.startItemAfterFinishVector

Fatal Error: 2015-12-20 22:09:25,493 Fatal [OrderJoin_Clm_Cd_Msg] [] Invalid parent cursor
com.ibm.e2.core.exceptions.E2IllegalStateException: StartItemAfterFinishVector runtimeOperator = 'UserRuntimeOperatorFrame:Op-RT-8[OrderJoin_Clm_Cd_Msg]', debugVectorName = '{urn:ibm:e2:operator:Op-51:output-port:output}result'
at com.ibm.e2.core.exceptions.E2IllegalStateException$FactoryImpl.startItemAfterFinishVector(E2IllegalStateException$FactoryImpl.java:307)
at com.ibm.e2.core.framework.runtime.daapi.WriteCursorImpl.startItem(WriteCursorImpl.java:187)
I'm completely lost on what to change. Is this a bug in datastage 8.5. Please help

Thanks,
Firvin
Post Reply