October 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4303) Insert into temporary table fails

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4303?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4303. --------------------------------- > Insert into temporary table fails > --------------------------------- > > Key: TEIID-4303 > URL: https://issues.jboss.org/browse/TEIID-4303 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.0 > Reporter: Bram Gadeyne > Assignee: Steven Hawkins > Attachments: debugplan.txt > > > When executing a insert query in a temporary table the execution fails with the following error: > 2016-06-28 08:54:35,700 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 3bZw8VxEr4t7.26.4.30 Closed execution > 2016-06-28 08:54:35,700 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 3bZw8VxEr4t7.26.4.30 Closed connection > 2016-06-28 08:54:35,700 DEBUG [org.teiid.COMMAND_LOG] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 END SRC COMMAND: endTime=2016-06-28 08:54:35.7 requestID=3bZw8VxEr4t7.26 sourceCommandID=4 executionID=30 txID=TransactionImple < ac, BasicAction: 0:ffff7f000101:2f4a8c3a:576d4165:72fc status: ActionStatus.ABORTED > modelName=iziswh translatorName=sybase sessionID=3bZw8VxEr4t7 principal=veerle@teiid-security finalRowCount=21504 cpuTime(ns)=120503397 > 2016-06-28 08:54:35,701 INFO [org.teiid.COMMAND_LOG] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 ERROR USER COMMAND: endTime=2016-06-28 08:54:35.701 requestID=3bZw8VxEr4t7.26 txID=TransactionImple < ac, BasicAction: 0:ffff7f000101:2f4a8c3a:576d4165:72fc status: ActionStatus.ABORTED > sessionID=3bZw8VxEr4t7 principal=veerle@teiid-security vdbName=vdb3 vdbVersion=14 finalRowCount=null > 2016-06-28 08:54:35,701 WARN [org.teiid.PROCESSOR] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 TEIID30020 Processing exception for request 3bZw8VxEr4t7.26 'TEIID30223 javax.transaction.RollbackException: ARJUNA016083: Can't register synchronization because the transaction is in aborted state'. Originally TeiidProcessingException TransactionImple.java:396. Enable more detailed logging to see the entire stacktrace. > 2016-06-28 08:54:35,701 WARN [com.arjuna.ats.arjuna] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 ARJUNA012077: Abort called on already aborted atomic action 0:ffff7f000101:2f4a8c3a:576d4165:72fc > 2016-06-28 08:54:35,702 INFO [org.teiid.COMMAND_LOG] (Worker12_QueryProcessorQueue243) 3bZw8VxEr4t7 END USER COMMAND: endTime=2016-06-28 08:54:35.702 requestID=3bZw8VxEr4t7.26 txID=null sessionID=3bZw8VxEr4t7 principal=veerle@teiid-security vdbName=vdb3 vdbVersion=14 finalRowCount=0 -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4414) VDB with old version is removed from the repository

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4414?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4414. --------------------------------- > VDB with old version is removed from the repository > --------------------------------------------------- > > Key: TEIID-4414 > URL: https://issues.jboss.org/browse/TEIID-4414 > Project: Teiid > Issue Type: Bug > Environment: Fedora 23 > Reporter: Matej Kralik > > When I deploy the second version of VDB, first version which is on the server will be undeployed. > In my opinion, on the server should be both VDB. > Server log when I deploy the second version of VDB: > 10:36:29,763 INFO [org.jboss.as.repository] (management-handler-thread - 11) JBAS014900: Content added at location /home/mkralik/newDir/server-installer/dv-6.3.0.ER2/target/jboss-eap-6.4/standalone/data/content/f7/642a972e99109eb02cf552cff4bfd06f179724/content > 10:36:29,765 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-15) TEIID40120 VDB DatarolesVDB.1 will be removed from the repository > 10:36:29,765 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-15) TEIID40119 VDB DatarolesVDB.1 removed from the repository > 10:36:29,766 INFO [org.teiid.RUNTIME] (MSC service thread 1-15) TEIID50026 VDB "DatarolesVDB.1[Products_view{}, Products_source{Products_source=Products_source, oracle, Products_source}]" undeployed. > 10:36:29,767 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-3) TEIID40120 VDB DatarolesVDB.1 will be removed from the repository > 10:36:29,769 INFO [org.jboss.as.server.deployment] (MSC service thread 1-12) JBAS015877: Stopped deployment DatarolesVDB.vdb (runtime-name: DatarolesVDB.vdb) in 5ms > 10:36:29,770 INFO [org.jboss.as.server.deployment] (MSC service thread 1-13) JBAS015876: Starting deployment of "DatarolesVDB.vdb" (runtime-name: "DatarolesVDB.vdb") > 10:36:29,785 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-15) TEIID40118 VDB DatarolesVDB.2 added to the repository > 10:36:29,785 INFO [org.teiid.RUNTIME] (MSC service thread 1-15) TEIID50029 VDB DatarolesVDB.2 model "Products_view" metadata is currently being loaded. Start Time: 5/30/16 10:36 AM > 10:36:29,786 INFO [org.teiid.RUNTIME] (MSC service thread 1-15) TEIID50029 VDB DatarolesVDB.2 model "Products_source" metadata is currently being loaded. Start Time: 5/30/16 10:36 AM > 10:36:29,791 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50030 VDB DatarolesVDB.2 model "Products_source" metadata loaded. End Time: 5/30/16 10:36 AM > 10:36:29,792 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50030 VDB DatarolesVDB.2 model "Products_view" metadata loaded. End Time: 5/30/16 10:36 AM > 10:36:29,810 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 1) TEIID40003 VDB DatarolesVDB.2 is set to ACTIVE > 10:36:29,827 INFO [org.jboss.as.server] (management-handler-thread - 11) JBAS015865: Replaced deployment "DatarolesVDB.vdb" with deployment "DatarolesVDB.vdb" > 10:36:29,827 INFO [org.jboss.as.repository] (management-handler-thread - 11) JBAS014901: Content removed from location /home/mkralik/newDir/server-installer/dv-6.3.0.ER2/target/jboss-eap-6.4/standalone/data/content/b0/7f37d82389f48b61922095c3d118870fda6116/content -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4033) View model - named attributes in mapping statement are not automatically mapped to the corresponding column in the table definition

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4033?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4033. --------------------------------- > View model - named attributes in mapping statement are not automatically mapped to the corresponding column in the table definition > ----------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-4033 > URL: https://issues.jboss.org/browse/TEIID-4033 > Project: Teiid > Issue Type: Feature Request > Components: VDB > Affects Versions: 8.7.2.6_2 > Environment: Dynamic VDB: > <?xml version="1.0" encoding="UTF-8" standalone="no"?> > <vdb name="dollar" version="1"> > <description/> > <property name="validationDateTime" value="Tue Mar 08 07:37:23 CST 2016"/> > <property name="validationVersion" value="8.7.3"/> > <model name="SOURCE_MODEL"> > <source connection-jndi-name="Debbie2" name="Debbie2" translator-name="postgresql"/> > <metadata type="DDL"><![CDATA[ > CREATE FOREIGN TABLE mytable ( > id integer NOT NULL OPTIONS(NAMEINSOURCE '"id"', NATIVE_TYPE 'int4', CASE_SENSITIVE 'FALSE', FIXED_LENGTH 'TRUE', SEARCHABLE 'ALL_EXCEPT_LIKE'), > name string(40) OPTIONS(NAMEINSOURCE '"name"', NATIVE_TYPE 'text'), > age integer OPTIONS(NAMEINSOURCE '"age"', NATIVE_TYPE 'int4', CASE_SENSITIVE 'FALSE', FIXED_LENGTH 'TRUE', SEARCHABLE 'ALL_EXCEPT_LIKE'), > address string(200) OPTIONS(NAMEINSOURCE '"address"', NATIVE_TYPE 'text'), > CONSTRAINT pk_mytableid PRIMARY KEY(id) > ) OPTIONS(NAMEINSOURCE '"public"."mytable"', CARDINALITY '3') > ]]></metadata> > </model> > <model name="VIEW_MODEL" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW MY_VIEW ( > ID integer NOT NULL, > NAME string(40), > ADDRESS string(200), > CONSTRAINT FKI_MY_VIEW PRIMARY KEY(ID) > ) > AS > SELECT "ID" as ID, "ADDRESS" as ADDRESS, "NAME" as NAME FROM SOURCE_MODEL.mytable; > ]]></metadata> > </model> > </vdb> > Reporter: Debbie Steigner > Assignee: Barry LaFond > > Unexpected sequential dependency between virtual table column order and mapping column sequence. > The TEIID statement to create a virtual table goes like: > CREATE VIEW TargetModelViewName ( > ColumnA … 1 > ColumnB … 2 > ColumnC …) … 3 > AS SELECT > SourceModel.SourceTable.ColX AS ColumnA, 1 > SourceModel.SourceTable.ColY AS ColumnB, 2 > SourceModel.SourceTable.ColZ AS ColumnC; 3 > In any 4th+ generation query language a positional dependency is not expected, and therefore the following statement should also work, but fails in the TEIID > CREATE VIEW TargetModelViewName ( > ColumnA … 1 > ColumnB … 2 > ColumnC …) … 3 > AS SELECT > SourceModel.SourceTable.ColX AS ColumnA, 1 > SourceModel.SourceTable.ColZ AS ColumnC, 3 > SourceModel.SourceTable.ColY AS ColumnB; 2 -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4527) Add cache-hint to dynamically create internal materialization

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4527?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4527. --------------------------------- > Add cache-hint to dynamically create internal materialization > ------------------------------------------------------------- > > Key: TEIID-4527 > URL: https://issues.jboss.org/browse/TEIID-4527 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine, Server > Affects Versions: 9.2 > Reporter: Van Halbert > Assignee: Steven Hawkins > > Add the ability to use a cache-hint that will dynamically create an internal materialization of the results that can then be queried. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4316) Accumulo translator: null values not returned for <> criteria in WHERE clause

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4316?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4316. --------------------------------- > Accumulo translator: null values not returned for <> criteria in WHERE clause > ----------------------------------------------------------------------------- > > Key: TEIID-4316 > URL: https://issues.jboss.org/browse/TEIID-4316 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Jan Stastny > Assignee: Ramesh Reddy > > For columns, which contain some null values, a query like: > {code:sql} > SELECT nullable_column FROM table_name WHERE nullable_column <> some_value > {code} > doesn't return null values. > Simple select works: > {code:sql} > SELECT nullable_column FROM table_name > {code} > returns all rows regardless whether they are null or not. > IS NULL criteria in WHERE clause also work: > {code:sql} > SELECT nullable_column FROM table_name WHERE nullable_column IS NULL > {code} > returns correct number of null values. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4388) If model fails to load native metadata, VDB has still status LOADING

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4388?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4388. --------------------------------- > If model fails to load native metadata, VDB has still status LOADING > -------------------------------------------------------------------- > > Key: TEIID-4388 > URL: https://issues.jboss.org/browse/TEIID-4388 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.5 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > If one model fails to load native metadata, VDB's status is still LOADING. > {code:plain|title=CLI status} > [standalone@localhost:9999 /] /subsystem=teiid:get-vdb(vdb-name=test,vdb-version=1) > { > "outcome" => "success", > "result" => { > "vdb-name" => "test", > "status" => "LOADING", > "vdb-version" => 1, > ... > "models" => [ > { > "model-name" => "Source1", > ... > "metadata-status" => "LOADED" > }, > { > "model-name" => "Source2", > ... > "validity-errors" => [ > { > "severity" => "INFO", > "message" => "TEIID50029 VDB test.1 model \"Source2\" metadata is currently being loaded. Start Time: 8/17/16 7:41 AM" > }, > { > "severity" => "ERROR", > "message" => "TEIID31178 Could not obtain connection for schema Source2, but one is required for metadata load. " > } > ], > ... > "metadata-status" => "FAILED" > }, > { > "model-name" => "Source3", > ... > "metadata-status" => "LOADED" > } > ] > } > } > {code} -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4361) OData V4 - filter is not working if speces are replaced with '+'

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4361?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4361. --------------------------------- > OData V4 - filter is not working if speces are replaced with '+' > ---------------------------------------------------------------- > > Key: TEIID-4361 > URL: https://issues.jboss.org/browse/TEIID-4361 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.12.5 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > If spaces in the URL are replaced with '+', Teiid returns error: > {code:plain|title=Working URL} > http://localhost:8080/odata4/static.1/Source/auth?$filter=id eq 1 > {code} > {code:plain|title=Not-working URL} > http://localhost:8080/odata4/static.1/Source/auth?$filter=id+eq+1 > {code} > {code:xml|title=VDB} > <vdb name="static" version="1"> > <model name="Source" type="VIRTUAL"> > <metadata type="DDL"> > <![CDATA[create view auth (id integer primary key) as select 1]]> > </metadata> > </model> > </vdb> > {code} > {code:xml|title=Error} > <error xmlns="http://docs.oasis-open.org/odata/ns/metadata"> > <code>null</code> > <message> > The types 'Edm.Boolean' and 'Edm.Int32' are not compatible. > </message> > </error> > {code} -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4204) Examples dynamicvdb-restservice - rest client returns always empty body

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4204?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4204. ----------------------------------- Fix Version/s: 9.0 Resolution: Done Marking the fix version as 9.0 as that is when the docs were updated. > Examples dynamicvdb-restservice - rest client returns always empty body > ------------------------------------------------------------------------ > > Key: TEIID-4204 > URL: https://issues.jboss.org/browse/TEIID-4204 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Affects Versions: 8.12.5 > Reporter: Van Halbert > Assignee: Kylin Soong > Priority: Minor > Fix For: 9.0 > > > Description of problem: > rest-client returns always empty body for every request like follows: > [jdurani@localhost resteasy-client]$ java -cp target/dependency/*:target/dynamicvdb-resteasy-client.jar org.jboss.teiid.quickstart.PortfolioClient > JAX-RS 2.0 Client API -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4204) Examples dynamicvdb-restservice - rest client returns always empty body

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4204?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-4204: ----------------------------------- > Examples dynamicvdb-restservice - rest client returns always empty body > ------------------------------------------------------------------------ > > Key: TEIID-4204 > URL: https://issues.jboss.org/browse/TEIID-4204 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Affects Versions: 8.12.5 > Reporter: Van Halbert > Assignee: Kylin Soong > Priority: Minor > > Description of problem: > rest-client returns always empty body for every request like follows: > [jdurani@localhost resteasy-client]$ java -cp target/dependency/*:target/dynamicvdb-resteasy-client.jar org.jboss.teiid.quickstart.PortfolioClient > JAX-RS 2.0 Client API -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4204) Examples dynamicvdb-restservice - rest client returns always empty body

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4204?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4204: ---------------------------------- Fix Version/s: (was: 9.1) > Examples dynamicvdb-restservice - rest client returns always empty body > ------------------------------------------------------------------------ > > Key: TEIID-4204 > URL: https://issues.jboss.org/browse/TEIID-4204 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Affects Versions: 8.12.5 > Reporter: Van Halbert > Assignee: Kylin Soong > Priority: Minor > > Description of problem: > rest-client returns always empty body for every request like follows: > [jdurani@localhost resteasy-client]$ java -cp target/dependency/*:target/dynamicvdb-resteasy-client.jar org.jboss.teiid.quickstart.PortfolioClient > JAX-RS 2.0 Client API -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2016