Error parsing XML generated from JDBC Stored Procedure

[Tim Scoff]

I have a Stored Procedure that returns a cursor based on dynamic SQL so Tibco BusinessWorks is not able to use the Schema that I created for the returned cursor and parse the data. When I remove the namespace from a single schema the Parse Schema activity works perfectly, but I have several Stored Procedures and they all work the same way and when I remove the namespace from two schemas I get errors because Tibco can't pick which schema to use. But when I add the namespace back into the schema I get the following error, so I need to add the namespace into the XML that is returned by the JDBC Call Procedure Activity. I saved the XML that is returned to the JDBC Call Procedure Activity as a file and I attached the file to this question. How do I add the missing namespace to the XML before I feed it into the Parse XML Activity please Thank you!!

15:32:03.640 ERROR [bwEngThread:In-Memory Process Worker-2] com.tibco.bw.core - TIBCO-BW-CORE-500050: The BW process [poc.Process] instance faulted, JobId [bw0a100], ProcessInstanceId [bw0a100], ParentProcessInstanceId [-], Module [POC:1.0.0.qualifier], Application [POC.application:1.0].

TIBCO-BW-CORE-500064: Activity [Parse_Accounts_Folder_Level] error.

com.tibco.bx.core.faults.BxException: Activity output data validation error. The output data from activity [Parse_Accounts_Folder_Level] in process [poc.Process], module [POC] does not conform to the activity output schema. Invalid element name: expected: {http://www.example.org/Accounts_Folder_Level}Resultsets, actual: Resultsets Schema=

schema-element({http://www.example.org/Accounts_Folder_Level}Resultsets) {http://www.example.org/Accounts_Folder_Level}ResultsetsType

Sequence

schema-element({http://www.example.org/Accounts_Folder_Level}ResultSet1) {http://www.example.org/Accounts_Folder_Level}ResultSet1Type

Sequence

schema-element({http://www.example.org/Accounts_Folder_Level}Record1) {http://www.example.org/Accounts_Folder_Level}Record1Type

Sequence

schema-element({http://www.example.org/Accounts_Folder_Level}ACCT_ID) {http://www.w3.org/2001/XMLSchema}string

schema-element({http://www.example.org/Accounts_Folder_Level}ACCT_NAME) {http://www.w3.org/2001/XMLSchema}string

Sequence

Sequence

Sequence

Data=218J5 WPS PART A

-{ActivityName=Parse_Accounts_Folder_Level}.

...

com.tibco.bx.core.faults.BxException: Activity output data validation error. The output data from activity [Parse_Accounts_Folder_Level] in process [poc.Process], module [POC] does not conform to the activity output schema. Invalid element name: expected: {http://www.example.org/Accounts_Folder_Level}Resultsets, actual: Resultsets Schema=

schema-element({http://www.example.org/Accounts_Folder_Level}Resultsets) {http://www.example.org/Accounts_Folder_Level}ResultsetsType

Sequence

schema-element({http://www.example.org/Accounts_Folder_Level}ResultSet1) {http://www.example.org/Accounts_Folder_Level}ResultSet1Type

Sequence

schema-element({http://www.example.org/Accounts_Folder_Level}Record1) {http://www.example.org/Accounts_Folder_Level}Record1Type

Sequence

schema-element({http://www.example.org/Accounts_Folder_Level}ACCT_ID) {http://www.w3.org/2001/XMLSchema}string

schema-element({http://www.example.org/Accounts_Folder_Level}ACCT_NAME) {http://www.w3.org/2001/XMLSchema}string

Sequence

Sequence

Sequence

Data=218J5 WPS PART A

at com.tibco.bx.core.BxSystemImpl.customizeValidationException(BxSystemImpl.java:2470)

at com.tibco.bx.util.BxValidationHelper.validate(BxValidationHelper.java:34)

at com.tibco.bx.core.behaviors.activity.BxExtensionBehavior.validateOutput(BxExtensionBehavior.java:125)

at com.tibco.bx.core.behaviors.activity.BxExtensionBehavior.doEval(BxExtensionBehavior.java:163)

at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.eval(BxActivityBaseBehavior.java:817)

at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.eval(BxActivityBaseBehavior.java:1)

at com.tibco.pvm.infra.api.impl.util.director.IpmEventDirectorBase.handleModelEvent(IpmEventDirectorBase.java:195)

at com.tibco.pvm.infra.api.impl.util.director.IpmEventDirectorBase.handleEvent(IpmEventDirectorBase.java:111)

at com.tibco.pvm.infra.support.work.impl.WorkItemAbstract.execute(WorkItemAbstract.java:177)

at com.tibco.pvm.im.rt.xm.util.work.ImxSTWorkRunnable.doWorkBlock(ImxSTWorkRunnable.java:170)

at com.tibco.pvm.infra.services.engine.impl.STWorkRunnable.run(STWorkRunnable.java:50)

at com.tibco.pvm.im.rt.xm.util.work.ImxSTWorkRunnable.run(ImxSTWorkRunnable.java:62)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:748)