[JBoss JIRA] (TEIID-5259) Add the ability to override the teiid-alias-naming-cache
by Van Halbert (JIRA)
Van Halbert created TEIID-5259:
----------------------------------
Summary: Add the ability to override the teiid-alias-naming-cache
Key: TEIID-5259
URL: https://issues.jboss.org/browse/TEIID-5259
Project: Teiid
Issue Type: Enhancement
Components: JDG Connector
Reporter: Van Halbert
Assignee: Steven Hawkins
Add the ability to override the teiid-alias-naming-cache that is preset in the logic. This is needed because of the bash rules for not allowing dashing in variable values.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-5258) TEIID30151 Error building Source for context item
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5258?page=com.atlassian.jira.plugin... ]
Work on TEIID-5258 started by Steven Hawkins.
---------------------------------------------
> TEIID30151 Error building Source for context item
> -------------------------------------------------
>
> Key: TEIID-5258
> URL: https://issues.jboss.org/browse/TEIID-5258
> Project: Teiid
> Issue Type: Bug
> Components: XML Connector
> Affects Versions: 10.1
> Environment: teiid-10.1.0 on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Attachments: failed.json
>
>
> When running the following script:
> {code:sql}
> Begin
> with t As (
> Select campaign_id, email_address, activity
> From (
> call files.getFiles(pathAndPattern => 'failed.json')
> ) f
> Cross Join
> XmlTable (
> '/root/emails'
> Passing JsonToXml('root', f.file)
> Columns
> campaign_id string,
> list_id string,
> list_is_active boolean,
> email_id string,
> email_address string,
> activity xml
> ) x
> Where activity Is Not Null
> )
> Select *
> From t Cross Join XmlTable (
> '/root/activity'
> Passing XmlElement(root, t.activity)
> Columns
> action string,
> "timestamp" timestamp,
> url string,
> ip string
> ) a;
> End;
> {code}
> teiid throws out the following error:
> {code:noformat}
> 2018-02-13 17:55:47,054 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue7) /okCCfP2/yjh TEIID30020 Processing exception for request /okCCfP2/yjh.0 'TEIID30151 Error building
> Source for context item.'. Originally TeiidProcessingException StaxToEventBridge.java:325.: org.teiid.core.TeiidProcessingException: TEIID30151 Error building Source for context item
> .
> at org.teiid.query.xquery.saxon.XQueryEvaluator.evaluateXQuery(XQueryEvaluator.java:163)
> at org.teiid.query.processor.relational.XMLTableNode$1.run(XMLTableNode.java:265)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: nu.xom.ParsingException
> at nu.xom.Builder.build(Unknown Source)
> at nu.xom.Builder.build(Unknown Source)
> at org.teiid.query.xquery.saxon.XQueryEvaluator.evaluateXQuery(XQueryEvaluator.java:157)
> ... 7 more
> Caused by: java.lang.NullPointerException
> at net.sf.saxon.evpull.StaxToEventBridge.getSystemId(StaxToEventBridge.java:325)
> at net.sf.saxon.evpull.StaxToEventBridge.getSystemId(StaxToEventBridge.java:385)
> at net.sf.saxon.event.ContentHandlerProxyLocator.getSystemId(ContentHandlerProxyLocator.java:72)
> at nu.xom.XOMHandler.startElement(Unknown Source)
> at net.sf.saxon.event.ContentHandlerProxy.startContent(ContentHandlerProxy.java:373)
> at org.teiid.query.xquery.saxon.ContentHandlerProxyReceiver.startContent(StreamingUtils.java:291)
> at net.sf.saxon.event.ProxyReceiver.startContent(ProxyReceiver.java:177)
> at org.teiid.query.xquery.saxon.PathMapFilter.startContent(PathMapFilter.java:226)
> at net.sf.saxon.event.TreeReceiver.startContent(TreeReceiver.java:220)
> at net.sf.saxon.evpull.EventIteratorToReceiver.copy(EventIteratorToReceiver.java:78)
> at net.sf.saxon.event.Sender.sendPullEventSource(Sender.java:559)
> at net.sf.saxon.event.Sender.send(Sender.java:132)
> at net.sf.saxon.Configuration.buildDocument(Configuration.java:3361)
> at net.sf.saxon.Configuration.buildDocument(Configuration.java:3303)
> at org.teiid.query.xquery.saxon.SaxonReader.parse(StreamingUtils.java:175)
> ... 10 more
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-5210) GitBook integration is broken
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5210?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5210:
---------------------------------------
We have gotten a few announcements of failed sync'ing, but that still requires manual intervention.
In talking to the docs team they will keep us apprised of their recommended github pages / jekyll publishing approach. More than likely we'll move the docs and the community site to that.
> GitBook integration is broken
> -----------------------------
>
> Key: TEIID-5210
> URL: https://issues.jboss.org/browse/TEIID-5210
> Project: Teiid
> Issue Type: Bug
> Components: Documentation
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 10.2
>
>
> GitBooks are no longer syncing to our github.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-5118) Osisoft Translator - NPE when using ORDER BY
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-5118?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-5118:
------------------------------------------------
Debi Rieden <drieden(a)redhat.com> changed the Status of [bug 1505739|https://bugzilla.redhat.com/show_bug.cgi?id=1505739] from VERIFIED to CLOSED
> Osisoft Translator - NPE when using ORDER BY
> --------------------------------------------
>
> Key: TEIID-5118
> URL: https://issues.jboss.org/browse/TEIID-5118
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.12.x-6.4
> Reporter: Andrej Šmigala
> Assignee: Ramesh Reddy
> Priority: Critical
> Labels: CR2
> Fix For: 10.0, 8.12.x-6.4
>
> Attachments: osisoft-pi-vdb.xml
>
>
> Any query with an ORDER BY clause run against Osisoft PI datasource fails with a NullPointerException
> Stack trace:
> {noformat}
> 10:17:09,235 ERROR [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue17) Connector worker process failed for atomic-request=mcBkcBzOiieD.5.0.5: java.lang.NullPointerException
> at org.teiid.translator.jdbc.pi.PISQLConversionVisitor.visit(PISQLConversionVisitor.java:157) [translator-jdbc-8.12.11.6_4.jar:8.12.11.6_4]
> at org.teiid.language.ColumnReference.acceptVisitor(ColumnReference.java:72) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.visitor.SQLStringVisitor.append(SQLStringVisitor.java:91) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.translator.jdbc.SQLConversionVisitor.append(SQLConversionVisitor.java:130) [translator-jdbc-8.12.11.6_4.jar:8.12.11.6_4]
> at org.teiid.language.visitor.SQLStringVisitor.visit(SQLStringVisitor.java:737) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.SortSpecification.acceptVisitor(SortSpecification.java:53) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.visitor.SQLStringVisitor.append(SQLStringVisitor.java:91) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.translator.jdbc.SQLConversionVisitor.append(SQLConversionVisitor.java:130) [translator-jdbc-8.12.11.6_4.jar:8.12.11.6_4]
> at org.teiid.language.visitor.SQLStringVisitor.append(SQLStringVisitor.java:102) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.visitor.SQLStringVisitor.visit(SQLStringVisitor.java:733) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.OrderBy.acceptVisitor(OrderBy.java:45) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.visitor.SQLStringVisitor.append(SQLStringVisitor.java:91) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.translator.jdbc.SQLConversionVisitor.append(SQLConversionVisitor.java:130) [translator-jdbc-8.12.11.6_4.jar:8.12.11.6_4]
> at org.teiid.language.visitor.SQLStringVisitor.visit(SQLStringVisitor.java:790) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.Select.acceptVisitor(Select.java:110) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.language.visitor.SQLStringVisitor.append(SQLStringVisitor.java:91) [teiid-api-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.translator.jdbc.SQLConversionVisitor.append(SQLConversionVisitor.java:130) [translator-jdbc-8.12.11.6_4.jar:8.12.11.6_4]
> at org.teiid.translator.jdbc.TranslatedCommand.translateCommand(TranslatedCommand.java:76) [translator-jdbc-8.12.11.6_4.jar:8.12.11.6_4]
> at org.teiid.translator.jdbc.JDBCBaseExecution.translateCommand(JDBCBaseExecution.java:120) [translator-jdbc-8.12.11.6_4.jar:8.12.11.6_4]
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:114) [translator-jdbc-8.12.11.6_4.jar:8.12.11.6_4]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:363)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_141]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_141]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_141]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_141]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy79.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_141]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_141]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_141]
> at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_141]
> {noformat}
> I tried remote debugging the server process and it appears that when running query such as
> {code:sql}
> SELECT FloatNum FROM BQT1.SmallA ORDER BY FloatNum ASC
> {code}
> the PISQLConversionVisitor.visit(ColumnReference obj) is called twice, the first time the ColumnReference object has value "g_0.FloatNum" and all fields set, the second time the object has only name set to "c_2" and nothing else (table, metadata object etc).
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-4315) HBase Quickstart issues
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-4315?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-4315:
------------------------------------------------
Debi Rieden <drieden(a)redhat.com> changed the Status of [bug 1335002|https://bugzilla.redhat.com/show_bug.cgi?id=1335002] from VERIFIED to CLOSED
> HBase Quickstart issues
> -----------------------
>
> Key: TEIID-4315
> URL: https://issues.jboss.org/browse/TEIID-4315
> Project: Teiid
> Issue Type: Bug
> Components: Quick Starts
> Affects Versions: 9.x
> Reporter: Van Halbert
> Assignee: Van Halbert
> Priority: Minor
> Fix For: 8.12.x-6.4, 9.3.1
>
>
> remove.cli script does not work. You need to remove items in revers order. You cannot remove driver if some data source is still using it. Please update remove.cli script:
> From:
> > module remove --name=org.apache.phoenix
> > /subsystem=datasources/jdbc-driver=phoenix:remove()
> > /subsystem=datasources/data-source=QSPhoenixDS:remove()
> To:
> > /subsystem=datasources/data-source=QSPhoenixDS:remove()
> > /subsystem=datasources/jdbc-driver=phoenix:remove()
> > module remove --name=org.apache.phoenix
> -------
> As far as I know, option 'enabled=true' of 'add' operation for data-source is deprecated in CLI. Moreover, user needs to reload server to be able to use create data source. Please, update the script like follows:
> From:
> > /subsystem=datasources/data-source=QSPhoenixDS:add(jndi-name="java:/QSPhoenixDS",driver-name=phoenix,connection-url=jdbc:phoenix:127.0.0.1:2181,user-name=sa,password=sa,enabled=true,use-java-context=true)
> To:
> > /subsystem=datasources/data-source=QSPhoenixDS:add(jndi-name="java:/QSPhoenixDS",driver-name=phoenix,connection-url=jdbc:phoenix:127.0.0.1:2181,user-name=sa,password=sa,use-java-context=true)
> > /subsystem=datasources/data-source=QSPhoenixDS:enable
> ------
> Files: hbase-as-a-datasource/README.md, hbase-as-a-datasource/src/scripts/setup.cli
> Line: 57 - 3) Setup Phoenix Data Source
> 1 - --resources=phoenix-4.2.1-client.jar
> Please add an instruction to update phoenix version in setup.cli script if user uses different version of phoenix/hbase.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-4892) oData v4 error using $expand
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-4892?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-4892:
------------------------------------------------
Debi Rieden <drieden(a)redhat.com> changed the Status of [bug 1506985|https://bugzilla.redhat.com/show_bug.cgi?id=1506985] from VERIFIED to CLOSED
> oData v4 error using $expand
> ----------------------------
>
> Key: TEIID-4892
> URL: https://issues.jboss.org/browse/TEIID-4892
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Affects Versions: 9.1.4
> Environment: Teiid 9.1.4 with WildFly 10.0.0.Final running on Windows server 2012 R2 Datacenter Edition.
> Reporter: Marco Monti
> Assignee: Steven Hawkins
> Fix For: 9.3, 8.12.x-6.4, 9.1.5, 9.2.3
>
> Attachments: server.log
>
>
> Hello,
>
> we are querying Teiid 9.1.4 using the following oData v4 syntax:
>
> {{http://host:port/odata4/<vdbname>/<model-name>/<table-name>?$expand=<navigation>}}
>
> It doesn't matter what navigation property we choose; we always get following error message:
>
> {{{"error":{"code":null,"message":"String index out of range: -1"}}}}
>
> Please find the attached logfile.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-5258) TEIID30151 Error building Source for context item
by dalex dalex (JIRA)
[ https://issues.jboss.org/browse/TEIID-5258?page=com.atlassian.jira.plugin... ]
dalex dalex updated TEIID-5258:
-------------------------------
Steps to Reproduce:
1. Add file resource adapter configuration in standalone-teiid.xml and put in the testdata folder the failed.json file (see in attachment):
{code:xml}
<resource-adapter id="file">
<module slot="main" id="org.jboss.teiid.resource-adapter.file"/>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.file.FileManagedConnectionFactory" jndi-name="java:/files" enabled="true" pool-name="files">
<config-property name="AllowParentPaths">
true
</config-property>
<config-property name="ParentDirectory">
C:/testdata
</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
{code}
2. Add translator "myFiles" in /deployments/test-vdb.xml:
{code:xml}
<translator name="myFiles" type="file"/>
{code}
3. Add "files" model in /deployments/test-vdb.xml:
{code:xml}
<model name="files">
<source name="files" translator-name="myFiles" connection-jndi-name="java:/files"/>
</model>
{code}
4. Run the following script:
{code:sql}
Begin
with t As (
Select campaign_id, email_address, activity
From (
call files.getFiles(pathAndPattern => 'failed.json')
) f
Cross Join
XmlTable (
'/root/emails'
Passing JsonToXml('root', f.file)
Columns
campaign_id string,
list_id string,
list_is_active boolean,
email_id string,
email_address string,
activity xml
) x
Where activity Is Not Null
)
Select *
From t Cross Join XmlTable (
'/root/activity'
Passing XmlElement(root, t.activity)
Columns
action string,
"timestamp" timestamp,
url string,
ip string
) a;
End;
{code}
was:
1. Add file resource adapter configuration in standalone-teiid.xml and put in the testdata folder the failed.json file (see in attachment):
{code:xml}
<resource-adapter id="file">
<module slot="main" id="org.jboss.teiid.resource-adapter.file"/>
<connection-definitions>
<connection-definition class-name="org.teiid.resource.adapter.file.FileManagedConnectionFactory" jndi-name="java:/files" enabled="true" pool-name="files">
<config-property name="AllowParentPaths">
true
</config-property>
<config-property name="ParentDirectory">
C:/testdata
</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
{code}
2. Add translator "myFiles" in /deployments/test-vdb.xml:
{code:xml}
<translator name="myFiles" type="file"/>
{code}
3. Add "files" model in /deployments/test-vdb.xml:
{code:xml}
<model name="files">
<source name="files" translator-name="myFiles" connection-jndi-name="java:/files"/>
</model>
{code}
4. Run the following script:
{code:query}
Begin
with t As (
Select campaign_id, email_address, activity
From (
call files.getFiles(pathAndPattern => 'failed.json')
) f
Cross Join
XmlTable (
'/root/emails'
Passing JsonToXml('root', f.file)
Columns
campaign_id string,
list_id string,
list_is_active boolean,
email_id string,
email_address string,
activity xml
) x
Where activity Is Not Null
)
Select *
From t Cross Join XmlTable (
'/root/activity'
Passing XmlElement(root, t.activity)
Columns
action string,
"timestamp" timestamp,
url string,
ip string
) a;
End;
{code}
> TEIID30151 Error building Source for context item
> -------------------------------------------------
>
> Key: TEIID-5258
> URL: https://issues.jboss.org/browse/TEIID-5258
> Project: Teiid
> Issue Type: Bug
> Components: XML Connector
> Affects Versions: 10.1
> Environment: teiid-10.1.0 on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Attachments: failed.json
>
>
> When running the following script:
> {code:sql}
> Begin
> with t As (
> Select campaign_id, email_address, activity
> From (
> call files.getFiles(pathAndPattern => 'failed.json')
> ) f
> Cross Join
> XmlTable (
> '/root/emails'
> Passing JsonToXml('root', f.file)
> Columns
> campaign_id string,
> list_id string,
> list_is_active boolean,
> email_id string,
> email_address string,
> activity xml
> ) x
> Where activity Is Not Null
> )
> Select *
> From t Cross Join XmlTable (
> '/root/activity'
> Passing XmlElement(root, t.activity)
> Columns
> action string,
> "timestamp" timestamp,
> url string,
> ip string
> ) a;
> End;
> {code}
> teiid throws out the following error:
> {code:noformat}
> 2018-02-13 17:55:47,054 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue7) /okCCfP2/yjh TEIID30020 Processing exception for request /okCCfP2/yjh.0 'TEIID30151 Error building
> Source for context item.'. Originally TeiidProcessingException StaxToEventBridge.java:325.: org.teiid.core.TeiidProcessingException: TEIID30151 Error building Source for context item
> .
> at org.teiid.query.xquery.saxon.XQueryEvaluator.evaluateXQuery(XQueryEvaluator.java:163)
> at org.teiid.query.processor.relational.XMLTableNode$1.run(XMLTableNode.java:265)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: nu.xom.ParsingException
> at nu.xom.Builder.build(Unknown Source)
> at nu.xom.Builder.build(Unknown Source)
> at org.teiid.query.xquery.saxon.XQueryEvaluator.evaluateXQuery(XQueryEvaluator.java:157)
> ... 7 more
> Caused by: java.lang.NullPointerException
> at net.sf.saxon.evpull.StaxToEventBridge.getSystemId(StaxToEventBridge.java:325)
> at net.sf.saxon.evpull.StaxToEventBridge.getSystemId(StaxToEventBridge.java:385)
> at net.sf.saxon.event.ContentHandlerProxyLocator.getSystemId(ContentHandlerProxyLocator.java:72)
> at nu.xom.XOMHandler.startElement(Unknown Source)
> at net.sf.saxon.event.ContentHandlerProxy.startContent(ContentHandlerProxy.java:373)
> at org.teiid.query.xquery.saxon.ContentHandlerProxyReceiver.startContent(StreamingUtils.java:291)
> at net.sf.saxon.event.ProxyReceiver.startContent(ProxyReceiver.java:177)
> at org.teiid.query.xquery.saxon.PathMapFilter.startContent(PathMapFilter.java:226)
> at net.sf.saxon.event.TreeReceiver.startContent(TreeReceiver.java:220)
> at net.sf.saxon.evpull.EventIteratorToReceiver.copy(EventIteratorToReceiver.java:78)
> at net.sf.saxon.event.Sender.sendPullEventSource(Sender.java:559)
> at net.sf.saxon.event.Sender.send(Sender.java:132)
> at net.sf.saxon.Configuration.buildDocument(Configuration.java:3361)
> at net.sf.saxon.Configuration.buildDocument(Configuration.java:3303)
> at org.teiid.query.xquery.saxon.SaxonReader.parse(StreamingUtils.java:175)
> ... 10 more
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month
[JBoss JIRA] (TEIID-5258) TEIID30151 Error building Source for context item
by dalex dalex (JIRA)
dalex dalex created TEIID-5258:
----------------------------------
Summary: TEIID30151 Error building Source for context item
Key: TEIID-5258
URL: https://issues.jboss.org/browse/TEIID-5258
Project: Teiid
Issue Type: Bug
Components: XML Connector
Affects Versions: 10.1
Environment: teiid-10.1.0 on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final)
Reporter: dalex dalex
Assignee: Steven Hawkins
Attachments: failed.json
When running the following script:
{code:sql}
Begin
with t As (
Select campaign_id, email_address, activity
From (
call files.getFiles(pathAndPattern => 'failed.json')
) f
Cross Join
XmlTable (
'/root/emails'
Passing JsonToXml('root', f.file)
Columns
campaign_id string,
list_id string,
list_is_active boolean,
email_id string,
email_address string,
activity xml
) x
Where activity Is Not Null
)
Select *
From t Cross Join XmlTable (
'/root/activity'
Passing XmlElement(root, t.activity)
Columns
action string,
"timestamp" timestamp,
url string,
ip string
) a;
End;
{code}
teiid throws out the following error:
{code:noformat}
2018-02-13 17:55:47,054 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue7) /okCCfP2/yjh TEIID30020 Processing exception for request /okCCfP2/yjh.0 'TEIID30151 Error building
Source for context item.'. Originally TeiidProcessingException StaxToEventBridge.java:325.: org.teiid.core.TeiidProcessingException: TEIID30151 Error building Source for context item
.
at org.teiid.query.xquery.saxon.XQueryEvaluator.evaluateXQuery(XQueryEvaluator.java:163)
at org.teiid.query.processor.relational.XMLTableNode$1.run(XMLTableNode.java:265)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: nu.xom.ParsingException
at nu.xom.Builder.build(Unknown Source)
at nu.xom.Builder.build(Unknown Source)
at org.teiid.query.xquery.saxon.XQueryEvaluator.evaluateXQuery(XQueryEvaluator.java:157)
... 7 more
Caused by: java.lang.NullPointerException
at net.sf.saxon.evpull.StaxToEventBridge.getSystemId(StaxToEventBridge.java:325)
at net.sf.saxon.evpull.StaxToEventBridge.getSystemId(StaxToEventBridge.java:385)
at net.sf.saxon.event.ContentHandlerProxyLocator.getSystemId(ContentHandlerProxyLocator.java:72)
at nu.xom.XOMHandler.startElement(Unknown Source)
at net.sf.saxon.event.ContentHandlerProxy.startContent(ContentHandlerProxy.java:373)
at org.teiid.query.xquery.saxon.ContentHandlerProxyReceiver.startContent(StreamingUtils.java:291)
at net.sf.saxon.event.ProxyReceiver.startContent(ProxyReceiver.java:177)
at org.teiid.query.xquery.saxon.PathMapFilter.startContent(PathMapFilter.java:226)
at net.sf.saxon.event.TreeReceiver.startContent(TreeReceiver.java:220)
at net.sf.saxon.evpull.EventIteratorToReceiver.copy(EventIteratorToReceiver.java:78)
at net.sf.saxon.event.Sender.sendPullEventSource(Sender.java:559)
at net.sf.saxon.event.Sender.send(Sender.java:132)
at net.sf.saxon.Configuration.buildDocument(Configuration.java:3361)
at net.sf.saxon.Configuration.buildDocument(Configuration.java:3303)
at org.teiid.query.xquery.saxon.SaxonReader.parse(StreamingUtils.java:175)
... 10 more
{code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 1 month