[JBoss JIRA] (TEIIDDES-3107) Source model for file is not generated properly
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3107?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-3107:
----------------------------------------
Verified that this is a server issue with VDB's ( *.vdb and -vdb.xml) that contain the source model with getTextFiles() procedure with 5 result set columns. Logged TEIID-5084
> Source model for file is not generated properly
> -----------------------------------------------
>
> Key: TEIIDDES-3107
> URL: https://issues.jboss.org/browse/TEIIDDES-3107
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 11.1
> Environment: Fedora
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 11.1.1
>
> Attachments: FlatFileProject.zip, productdata_data.csv
>
>
> I generate source and view model from flat file. Preview data works fine. I create VDB and test it. I use the same query ( _select * from "ViewModelForFlatFile"."viewTable"_ ) as for the preview but it failed.
> Error:
> {code:java}
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 SourceModelForFlatFile: Inproper results returned. Expected 5 columns, but was 2
> {code}
> Error log from a server:
> {code:java}
> 17:16:30,075 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=lOIYsaWz3vDW.0.3.0: java.lang.AssertionError: Inproper results returned. Expected 5 columns, but was 2
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:439)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:236)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_121]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_121]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_121]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_121]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy76.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309)
> 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_121]
> 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:1142) [rt.jar:1.8.0_121]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_121]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_121]
> {code}
> This issue is only when a flat file is local (because remote flat file uses another function in the source model (invokeHttp)).
> The same issue is with XML file.
> We noticed that old designer generated ReusltSet for procedure *getTextFiles* in the Source model with two parameters (file and filePath) but new designer generates ResultSet with five parameters (file, filePath, lastModified, created, size). This may be a problem.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 2 months
[JBoss JIRA] (TEIIDDES-3107) Source model for file is not generated properly
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3107?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-3107.
------------------------------------
Resolution: Done
> Source model for file is not generated properly
> -----------------------------------------------
>
> Key: TEIIDDES-3107
> URL: https://issues.jboss.org/browse/TEIIDDES-3107
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 11.1
> Environment: Fedora
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 11.1.1
>
> Attachments: FlatFileProject.zip, productdata_data.csv
>
>
> I generate source and view model from flat file. Preview data works fine. I create VDB and test it. I use the same query ( _select * from "ViewModelForFlatFile"."viewTable"_ ) as for the preview but it failed.
> Error:
> {code:java}
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 SourceModelForFlatFile: Inproper results returned. Expected 5 columns, but was 2
> {code}
> Error log from a server:
> {code:java}
> 17:16:30,075 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=lOIYsaWz3vDW.0.3.0: java.lang.AssertionError: Inproper results returned. Expected 5 columns, but was 2
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:439)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:236)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_121]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_121]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_121]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_121]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy76.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309)
> 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_121]
> 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:1142) [rt.jar:1.8.0_121]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_121]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_121]
> {code}
> This issue is only when a flat file is local (because remote flat file uses another function in the source model (invokeHttp)).
> The same issue is with XML file.
> We noticed that old designer generated ReusltSet for procedure *getTextFiles* in the Source model with two parameters (file and filePath) but new designer generates ResultSet with five parameters (file, filePath, lastModified, created, size). This may be a problem.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 2 months
[JBoss JIRA] (TEIIDDES-3107) Source model for file is not generated properly
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3107?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-3107:
----------------------------------------
[~mkralik]I also imported your project, and "Set Connection Profile" on your generated source model to my local product_data file. Preview worked fine for your view_table. So ER2 does contain the 5 parameter procedure support
> Source model for file is not generated properly
> -----------------------------------------------
>
> Key: TEIIDDES-3107
> URL: https://issues.jboss.org/browse/TEIIDDES-3107
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 11.1
> Environment: Fedora
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 11.1.1
>
> Attachments: FlatFileProject.zip, productdata_data.csv
>
>
> I generate source and view model from flat file. Preview data works fine. I create VDB and test it. I use the same query ( _select * from "ViewModelForFlatFile"."viewTable"_ ) as for the preview but it failed.
> Error:
> {code:java}
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 SourceModelForFlatFile: Inproper results returned. Expected 5 columns, but was 2
> {code}
> Error log from a server:
> {code:java}
> 17:16:30,075 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=lOIYsaWz3vDW.0.3.0: java.lang.AssertionError: Inproper results returned. Expected 5 columns, but was 2
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:439)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:236)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_121]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_121]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_121]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_121]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy76.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309)
> 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_121]
> 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:1142) [rt.jar:1.8.0_121]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_121]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_121]
> {code}
> This issue is only when a flat file is local (because remote flat file uses another function in the source model (invokeHttp)).
> The same issue is with XML file.
> We noticed that old designer generated ReusltSet for procedure *getTextFiles* in the Source model with two parameters (file and filePath) but new designer generates ResultSet with five parameters (file, filePath, lastModified, created, size). This may be a problem.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 2 months
[JBoss JIRA] (TEIIDDES-3107) Source model for file is not generated properly
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3107?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-3107:
----------------------------------------
[~mkralik] I just retested against an instance of 6.4.0.ER2 which generated the 5 parameter getTextFile() procedure. I walked through the guides view and Preview Data was successful.
> Source model for file is not generated properly
> -----------------------------------------------
>
> Key: TEIIDDES-3107
> URL: https://issues.jboss.org/browse/TEIIDDES-3107
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 11.1
> Environment: Fedora
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 11.1.1
>
> Attachments: FlatFileProject.zip, productdata_data.csv
>
>
> I generate source and view model from flat file. Preview data works fine. I create VDB and test it. I use the same query ( _select * from "ViewModelForFlatFile"."viewTable"_ ) as for the preview but it failed.
> Error:
> {code:java}
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 SourceModelForFlatFile: Inproper results returned. Expected 5 columns, but was 2
> {code}
> Error log from a server:
> {code:java}
> 17:16:30,075 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=lOIYsaWz3vDW.0.3.0: java.lang.AssertionError: Inproper results returned. Expected 5 columns, but was 2
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:439)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:236)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_121]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_121]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_121]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_121]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy76.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309)
> 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_121]
> 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:1142) [rt.jar:1.8.0_121]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_121]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_121]
> {code}
> This issue is only when a flat file is local (because remote flat file uses another function in the source model (invokeHttp)).
> The same issue is with XML file.
> We noticed that old designer generated ReusltSet for procedure *getTextFiles* in the Source model with two parameters (file and filePath) but new designer generates ResultSet with five parameters (file, filePath, lastModified, created, size). This may be a problem.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 2 months
[JBoss JIRA] (TEIIDDES-3103) Execute VDB in the Guides doesn't work
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3103?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-3103:
--------------------------------------
Assignee: Barry LaFond
> Execute VDB in the Guides doesn't work
> --------------------------------------
>
> Key: TEIIDDES-3103
> URL: https://issues.jboss.org/browse/TEIIDDES-3103
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 11.1
> Environment: Fedora 26
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Minor
> Fix For: 11.1.1
>
> Attachments: guides.mkv, screenshot.png
>
>
> Last step (execute VDB) in the first guide (Model JDBC Source) doesn't work. After click on the "Execute VDB" shows wizard for choosing VDB (screenshot1). After click OK, VDB is not deployed.
> I noticed that it doesn't work in the other guides as well.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 2 months
[JBoss JIRA] (TEIIDDES-3103) Execute VDB in the Guides doesn't work
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3103?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-3103:
-----------------------------------
Fix Version/s: 11.1.1
> Execute VDB in the Guides doesn't work
> --------------------------------------
>
> Key: TEIIDDES-3103
> URL: https://issues.jboss.org/browse/TEIIDDES-3103
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 11.1
> Environment: Fedora 26
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Minor
> Fix For: 11.1.1
>
> Attachments: guides.mkv, screenshot.png
>
>
> Last step (execute VDB) in the first guide (Model JDBC Source) doesn't work. After click on the "Execute VDB" shows wizard for choosing VDB (screenshot1). After click OK, VDB is not deployed.
> I noticed that it doesn't work in the other guides as well.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 2 months
[JBoss JIRA] (TEIIDDES-3106) Add edit to source model name when data source is JDG
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3106?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-3106:
-----------------------------------
Fix Version/s: 11.1.1
> Add edit to source model name when data source is JDG
> -----------------------------------------------------
>
> Key: TEIIDDES-3106
> URL: https://issues.jboss.org/browse/TEIIDDES-3106
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Validation
> Affects Versions: 11.2
> Reporter: Van Halbert
> Fix For: 11.1.1
>
>
> Infinispan restricts the name of the source model name because the protobuf code is based on java package naming constraints. Therefore, would like to add a validation check when the data source is JDG (e.g., translator=infinispan-hotrod) to check if the source model name on contains alpha/numeric/underscore characters. Dashes are one of those characters that is not allowed.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 2 months
[JBoss JIRA] (TEIIDDES-3106) Add edit to source model name when data source is JDG
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3106?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-3106:
--------------------------------------
Assignee: Barry LaFond
> Add edit to source model name when data source is JDG
> -----------------------------------------------------
>
> Key: TEIIDDES-3106
> URL: https://issues.jboss.org/browse/TEIIDDES-3106
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Validation
> Affects Versions: 11.2
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Fix For: 11.1.1
>
>
> Infinispan restricts the name of the source model name because the protobuf code is based on java package naming constraints. Therefore, would like to add a validation check when the data source is JDG (e.g., translator=infinispan-hotrod) to check if the source model name on contains alpha/numeric/underscore characters. Dashes are one of those characters that is not allowed.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 2 months
[JBoss JIRA] (TEIIDDES-3107) Source model for file is not generated properly
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3107?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-3107:
-----------------------------------
Fix Version/s: 11.1.1
> Source model for file is not generated properly
> -----------------------------------------------
>
> Key: TEIIDDES-3107
> URL: https://issues.jboss.org/browse/TEIIDDES-3107
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 11.1
> Environment: Fedora
> Reporter: Matej Kralik
> Priority: Blocker
> Fix For: 11.1.1
>
> Attachments: FlatFileProject.zip, productdata_data.csv
>
>
> I generate source and view model from flat file. Preview data works fine. I create VDB and test it. I use the same query ( _select * from "ViewModelForFlatFile"."viewTable"_ ) as for the preview but it failed.
> Error:
> {code:java}
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 SourceModelForFlatFile: Inproper results returned. Expected 5 columns, but was 2
> {code}
> Error log from a server:
> {code:java}
> 17:16:30,075 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=lOIYsaWz3vDW.0.3.0: java.lang.AssertionError: Inproper results returned. Expected 5 columns, but was 2
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:439)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:236)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_121]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_121]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_121]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_121]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy76.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309)
> 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_121]
> 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:1142) [rt.jar:1.8.0_121]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_121]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_121]
> {code}
> This issue is only when a flat file is local (because remote flat file uses another function in the source model (invokeHttp)).
> The same issue is with XML file.
> We noticed that old designer generated ReusltSet for procedure *getTextFiles* in the Source model with two parameters (file and filePath) but new designer generates ResultSet with five parameters (file, filePath, lastModified, created, size). This may be a problem.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 2 months
[JBoss JIRA] (TEIIDDES-3107) Source model for file is not generated properly
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3107?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-3107:
--------------------------------------
Assignee: Barry LaFond
> Source model for file is not generated properly
> -----------------------------------------------
>
> Key: TEIIDDES-3107
> URL: https://issues.jboss.org/browse/TEIIDDES-3107
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 11.1
> Environment: Fedora
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 11.1.1
>
> Attachments: FlatFileProject.zip, productdata_data.csv
>
>
> I generate source and view model from flat file. Preview data works fine. I create VDB and test it. I use the same query ( _select * from "ViewModelForFlatFile"."viewTable"_ ) as for the preview but it failed.
> Error:
> {code:java}
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 SourceModelForFlatFile: Inproper results returned. Expected 5 columns, but was 2
> {code}
> Error log from a server:
> {code:java}
> 17:16:30,075 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=lOIYsaWz3vDW.0.3.0: java.lang.AssertionError: Inproper results returned. Expected 5 columns, but was 2
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:439)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:236)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_121]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_121]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_121]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_121]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy76.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309)
> 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_121]
> 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:1142) [rt.jar:1.8.0_121]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_121]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_121]
> {code}
> This issue is only when a flat file is local (because remote flat file uses another function in the source model (invokeHttp)).
> The same issue is with XML file.
> We noticed that old designer generated ReusltSet for procedure *getTextFiles* in the Source model with two parameters (file and filePath) but new designer generates ResultSet with five parameters (file, filePath, lastModified, created, size). This may be a problem.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 2 months