Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1097482

Summary:	Generating WS From Source Procedure Fails when Direction Type for Column is RETURN
Product:	[JBoss] JBoss Data Virtualization 6	Reporter:	Anu Saji <asaji>
Component:	Tooling	Assignee:	jolee
Status:	CLOSED UPSTREAM	QA Contact:
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	unspecified	CC:	jolee
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:	When Teiid Designer generates a web service for a source model, it does not check for a RETURN direction type. This can cause the generation of the web service model gto fail with an error stating that there is no root.	Story Points:	---
Clone Of:		Environment:
Last Closed:	2025-02-10 03:35:49 UTC	Type:	Support Patch
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Anu Saji 2014-05-14 02:33:14 UTC

Description of problem:

(Wording taken from https://issues.jboss.org/browse/TEIIDDES-2155)
When generating a web service for a source model, we check for direction types of OUT and IN/OUT, but do not check for a type of RETURN. This cause the ws model generation to fail with an error stating their is no root.

Need to add check for RETURN direction type.


Version-Release number of selected component (if applicable):
Teiid Designer 8.3.2
DV 6

How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:

Customer seeing the following exceptions in their server.log

***********************************************************************
17:30:54,707 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue15) Removing tuplesource for the request Kww+PrQVE/W5.6
17:30:54,707 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue15) Removing TupleBuffer: 22
17:30:54,708 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue15) Sending error to client Kww+PrQVE/W5.6: org.teiid.core.TeiidProcessingException: TEIID30151 Error building Source for context item.
	at org.teiid.query.xquery.saxon.XQueryEvaluator.evaluateXQuery(XQueryEvaluator.java:140) [teiid-engine-8.4.2.jar:8.4.2]
	at org.teiid.query.processor.relational.XMLTableNode$1.run(XMLTableNode.java:226) [teiid-engine-8.4.2.jar:8.4.2]
	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.2.jar:8.4.2]
	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.2.jar:8.4.2]
	at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.2.jar:8.4.2]
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [rt.jar:1.6.0_71]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [rt.jar:1.6.0_71]
	at java.lang.Thread.run(Thread.java:680) [rt.jar:1.6.0_71]
Caused by: nu.xom.ParsingException: org.xml.sax.SAXParseException: The prefix "xsi" for attribute "xsi:nil" associated with an element type "m:DerivedSk" is not bound.
	at nu.xom.Builder.build(Unknown Source) [xom-1.2.7-redhat-3.jar:1.2.7-redhat-3]
	at nu.xom.Builder.build(Unknown Source) [xom-1.2.7-redhat-3.jar:1.2.7-redhat-3]
	at org.teiid.query.xquery.saxon.XQueryEvaluator.evaluateXQuery(XQueryEvaluator.java:134) [teiid-engine-8.4.2.jar:8.4.2]
	... 7 more
Caused by: net.sf.saxon.trans.XPathException: org.xml.sax.SAXParseException: The prefix "xsi" for attribute "xsi:nil" associated with an element type "m:DerivedSk" is not bound.
	at org.teiid.query.xquery.saxon.SaxonReader.parse(StreamingUtils.java:171) [teiid-engine-8.4.2.jar:8.4.2]
	... 10 more
Caused by: net.sf.saxon.trans.XPathException: org.xml.sax.SAXParseException: The prefix "xsi" for attribute "xsi:nil" associated with an element type "m:DerivedSk" is not bound.
	at net.sf.saxon.event.Sender.sendSAXSource(Sender.java:417) [saxonhe-9.2.1.5.jar:]
	at net.sf.saxon.event.Sender.send(Sender.java:182) [saxonhe-9.2.1.5.jar:]
	at net.sf.saxon.Configuration.buildDocument(Configuration.java:3317) [saxonhe-9.2.1.5.jar:]
	at net.sf.saxon.Configuration.buildDocument(Configuration.java:3262) [saxonhe-9.2.1.5.jar:]
	at org.teiid.query.xquery.saxon.SaxonReader.parse(StreamingUtils.java:169) [teiid-engine-8.4.2.jar:8.4.2]
	... 10 more
Caused by: org.xml.sax.SAXParseException: The prefix "xsi" for attribute "xsi:nil" associated with an element type "m:DerivedSk" is not bound.
	at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
	at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source)
	at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
	at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
	at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
	at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
	at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
	at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
	at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
	at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
	at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
	at net.sf.saxon.event.Sender.sendSAXSource(Sender.java:397) [saxonhe-9.2.1.5.jar:]
	... 14 more
****************************************************************************
Expected results:


Additional info:

Comment 2 JBoss JIRA Server 2014-05-16 14:40:08 UTC

Barry LaFond <blafond> updated the status of jira TEIIDDES-2155 to Resolved

Comment 3 jolee 2014-05-16 16:05:58 UTC

8.3.x on git:Teiid-Designer/teiid-designer.git

commit c75bdceab46d9c58d59ab32060c88f5d483521e0
Merge: fb77227 9817ab0
Author: Barry LaFond <blafond>
Date:   Fri May 16 11:04:08 2014 -0500

    Merge pull request #351 from johnathonlee/TEIIDDES-2155
    
    TEIIDDES-2155

commit 9817ab01f7ff5448389778ea44c41156ab55a3b9
Author: Ted Jones <jonested>
Date:   Wed May 14 16:59:38 2014 -0500

    TEIIDDES-2155: Added check for RETURN direction type when generating a ws for a source stored procedure.

Comment 4 jolee 2014-05-22 20:51:22 UTC

Removing association from https://issues.jboss.org/browse/TEIIDDES-2155 and CP blocking status until actual status/need for this can be determined.

Comment 5 Red Hat Bugzilla 2025-02-10 03:35:49 UTC

This product has been discontinued or is no longer tracked in Red Hat Bugzilla.