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: … [View More]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) [View Less]

8 years, 4 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 > … [View More]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) [View Less]

8 years, 4 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:… [View More]//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) [View Less]

8 years, 4 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: … [View More]

8 years, 4 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 &… [View More]

8 years, 4 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: … [View More]

8 years, 4 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 &… [View More]

8 years, 4 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: … [View More]

8 years, 4 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 > … [View More]

8 years, 4 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 > … [View More]

8 years, 4 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2016