March 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4024) Server fails to shutdown if vdb with REST service generation is deployed

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4024?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4024: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1315279 Bugzilla Update: Perform > Server fails to shutdown if vdb with REST service generation is deployed > ------------------------------------------------------------------------ > > Key: TEIID-4024 > URL: https://issues.jboss.org/browse/TEIID-4024 > Project: Teiid > Issue Type: Bug > Components: VDB > Affects Versions: 8.12.5 > Environment: DV 6.3 ER1 > Reporter: Filip Elias > Assignee: Barry LaFond > Attachments: nosource-vdb.xml, server_trace.log > > > DV sometimes won't stop if vdb with REST service generation is deployed. > Server log is in the attachment. > When the server is killed and started again, it will stop correctly. > The issue is random. Server fails to stop in 50% of cases. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4024) Server fails to shutdown if vdb with REST service generation is deployed

by Filip Elias (JIRA)

Filip Elias created TEIID-4024: ---------------------------------- Summary: Server fails to shutdown if vdb with REST service generation is deployed Key: TEIID-4024 URL: https://issues.jboss.org/browse/TEIID-4024 Project: Teiid Issue Type: Bug Components: VDB Affects Versions: 8.12.5 Environment: DV 6.3 ER1 Reporter: Filip Elias Assignee: Barry LaFond Attachments: nosource-vdb.xml, server_trace.log DV sometimes won't stop if vdb with REST service generation is deployed. Server log is in the attachment. When the server is killed and started again, it will stop correctly. The issue is random. Server fails to stop in 50% of cases. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4024) Server fails to shutdown if vdb with REST service generation is deployed

by Filip Elias (JIRA)

[ https://issues.jboss.org/browse/TEIID-4024?page=com.atlassian.jira.plugin... ] Filip Elias updated TEIID-4024: ------------------------------- Steps to Reproduce: Steps to reproduce: # Install a clean copy of DV 6.3 ER1 # Deploy nosource-vdb.xml (in the attachment) using CLI: deploy /pathtovdb/nosource-vdb.xml # Shutdown the server using CLI: shutdown was: Steps to reproduce: # Create a clean copy of DV 6.3 ER1 # Deploy nosource-vdb.xml (in the attachment) using CLI: deploy /pathtovdb/nosource-vdb.xml # Shutdown the server using CLI: shutdown > Server fails to shutdown if vdb with REST service generation is deployed > ------------------------------------------------------------------------ > > Key: TEIID-4024 > URL: https://issues.jboss.org/browse/TEIID-4024 > Project: Teiid > Issue Type: Bug > Components: VDB > Affects Versions: 8.12.5 > Environment: DV 6.3 ER1 > Reporter: Filip Elias > Assignee: Barry LaFond > Attachments: nosource-vdb.xml, server_trace.log > > > DV sometimes won't stop if vdb with REST service generation is deployed. > Server log is in the attachment. > When the server is killed and started again, it will stop correctly. > The issue is random. Server fails to stop in 50% of cases. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4014) remove oid from system tables

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4014?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4014. ----------------------------------- Resolution: Done Removed the oid and updated the docs. > remove oid from system tables > ----------------------------- > > Key: TEIID-4014 > URL: https://issues.jboss.org/browse/TEIID-4014 > Project: Teiid > Issue Type: Task > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0 > > > The oid column on system tables is unused and should be removed. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3984) Enhance Reference Architecture document

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3984?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3984: --------------------------------------- I agree we don't need a terminology page just for the architecture section. It may be good to change elevate the page in the hierarchy and make it a general glossary. > Enhance Reference Architecture document > --------------------------------------- > > Key: TEIID-3984 > URL: https://issues.jboss.org/browse/TEIID-3984 > Project: Teiid > Issue Type: Sub-task > Components: Documentation > Affects Versions: 9.x > Reporter: Kylin Soong > Assignee: Steven Hawkins > Fix For: 9.x > > > Architecture document lack the DQP Processing and Buffer Management doc, current [1] have very limited content, it's should be better if we can add document for DQP Processing, a Details Architecture Figure, some depicts of Buffer Management, it will be better. > [1] https://teiid.gitbooks.io/documents/content/reference/Architecture.html -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3998) EDS 5.3 jdbc driver virtual procedure call against JDV 6.2.3

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3998?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3998: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1311213|https://bugzilla.redhat.com/show_bug.cgi?id=1311213] from NEW to ASSIGNED > EDS 5.3 jdbc driver virtual procedure call against JDV 6.2.3 > ------------------------------------------------------------ > > Key: TEIID-3998 > URL: https://issues.jboss.org/browse/TEIID-3998 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12 > Environment: eds-5.3.1_1_2015-jdbc > Reporter: Filip Elias > Assignee: Steven Hawkins > Attachments: server1.log > > > We identified an issue when trying to connect with EDS 5.3 jdbc driver to JDV 6.2.3 instance. > The problem is caused by virtual procedure execution. > Query performed: > EXEC View.hiddenUpdate(456,'changed') > View definition: > {code} > <model name="View" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIRTUAL PROCEDURE hiddenUpdate(ID integer,CUSTOMERNAME string) AS BEGIN > MERGE INTO Customers(id,customername) VALUES(ID,CUSTOMERNAME); > END > ]]> </metadata> > </model> > {code} > NPE excepton: > {code} > Exception in thread "main" java.lang.NullPointerException > at org.teiid.jdbc.StatementImpl.executeUpdate(StatementImpl.java:342) > at jdbcdriver.JDBCClient.executeUpdate(JDBCClient.java:59) > at jdbcdriver.JDBCClient.main(JDBCClient.java:52) > {code} > Client code: > {code} > @Test > public void procedureInvalidateCacheTest(){ > String sqlSelectAll = "/*+ cache */SELECT * FROM Customers;"; > try{ > > Utils.executeUpdate(con,"INSERT INTO Customers(id,customername) VALUES (456, 'Testing 1');"); > > ResultSet empty = Utils.executeQuery(con, sqlSelectAll); > Assert.assertTrue(empty.next(), "ResultSet should be empty"); > > try{ > Thread.sleep(3000); > }catch(InterruptedException ie){ > > } > > Utils.executeUpdate(con,"EXEC View.hiddenUpdate(456,'changed')"); > > ResultSet full = Utils.executeQuery(con, sqlSelectAll); > Assert.assertTrue(full.next(), "ResultSet shouldn't be empty"); > > int custId = full.getInt(1); > String custName = full.getString(2); > Assert.assertEquals(custId, 456,"Returned row with wrong customer id"); > Assert.assertEquals(custName,"changed","PROCEDURE with UPDATE query didn't invalidate the cache:returned row with wrong customer name"); > > > }catch(SQLException se){ > LOG.error("Error during performing sql query on teiid",se); > Assert.fail("Error during performing sql query on teiid", se); > } > } > static Connection getTeiidConnectionUser1() throws SQLException { > LOG.info("Getting Teiid connection for user1."); > return TeiidDriver.getInstance().connect(TEIID_URL_USER1, null); > } > static int executeUpdate(Connection con, String sql) throws SQLException{ > LOG.info("Executing update [connection: " + con + "]: " + sql + "."); > Statement s = con.createStatement(); > return s.executeUpdate(sql); > } > {code} > Server log is in the attachment. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4002) Configuring of JDG DSL resource adapter still requires marshaller and protobuf when using annotations to define schema

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4002?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4002: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1312196|https://bugzilla.redhat.com/show_bug.cgi?id=1312196] from NEW to ASSIGNED > Configuring of JDG DSL resource adapter still requires marshaller and protobuf when using annotations to define schema > ---------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-4002 > URL: https://issues.jboss.org/browse/TEIID-4002 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.x > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Blocker > > To improve the usability of JDG as a materialized data source, the resource-adapter needs to be changed to not require the marshaller/protobuf file when the the pojo class has the defined annotations for specifying the schema. > Currently, the marshaller(s) and protobuf are required. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4022) Materialization issue dynamic SQL command can't be executed due ambiguous group name

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4022?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4022: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1314890|https://bugzilla.redhat.com/show_bug.cgi?id=1314890] from NEW to MODIFIED > Materialization issue dynamic SQL command can't be executed due ambiguous group name > -------------------------------------------------------------------------------------- > > Key: TEIID-4022 > URL: https://issues.jboss.org/browse/TEIID-4022 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.12.x > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.12.5, 8.13.2 > > > The defined model for materialization: > {code} > <model name="PersonMatModel" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE view PersonMatView > ( > name string, > id integer, > email string > ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'TRUE', > MATERIALIZED_TABLE 'PersonMatCache.Person', > "teiid_rel:MATVIEW_TTL" 60000, > "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute PersonMatCache.native(''truncate cache'');', > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute PersonMatCache.native(''swap cache names'');', > "teiid_rel:MATERIALIZED_STAGE_TABLE" 'PersonMatCache.Person', > "teiid_rel:MATVIEW_SHARE_SCOPE" 'NONE', > "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', > "teiid_rel:MATVIEW_STATUS_TABLE" 'Accounts.status', > "teiid_rel:MATVIEW_ONERROR_ACTION" 'THROW_EXCEPTION') > AS SELECT name, id, email from PersonInfoModel.Person; > ]]> > </metadata> > </model> > {code} > causes the following exception: > {code} > org.teiid.api.exception.query.QueryProcessingException: TEIID30168 Couldn't > execute the dynamic SQL command "EXECUTE IMMEDIATE ('SELECT count(*) as > rowCount FROM ' || matViewTable) AS rowCount integer INTO #load_count" with > the SQL statement "('SELECT count(*) as rowCount FROM ' || matViewTable)" due > to: Group specified is ambiguous, resubmit the query by fully qualifying the group > name: Person > {code} > And executing the following internal call that Teiid uses does produce the non-qualifed name > {ccode} > SELECT TargetName from SYSADMIN.MatViews WHERE VDBName = 'PeopleMat' AND SchemaName = 'PersonMatModel' AND Name = 'PersonMatView' > {code} > returns: Person -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2709) Quickstart - drools-integration uses drools 5 instead of drools 6

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2709?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2709: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1022650|https://bugzilla.redhat.com/show_bug.cgi?id=1022650] from MODIFIED to ON_QA > Quickstart - drools-integration uses drools 5 instead of drools 6 > ------------------------------------------------------------------- > > Key: TEIID-2709 > URL: https://issues.jboss.org/browse/TEIID-2709 > Project: Teiid > Issue Type: Enhancement > Components: Quick Starts > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Van Halbert > > The drools-integration quick start uses drools 5, instead of drools 6. > And its not a matter of swapping out the versions due to api changes drools 6. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2982) Allow to change visibility to a model from imported vdb

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2982?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2982: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1098405|https://bugzilla.redhat.com/show_bug.cgi?id=1098405] from MODIFIED to ON_QA > Allow to change visibility to a model from imported vdb > ------------------------------------------------------- > > Key: TEIID-2982 > URL: https://issues.jboss.org/browse/TEIID-2982 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.7 > Reporter: Kenichi Takemura > Assignee: Steven Hawkins > Fix For: 8.9 > > > When a new vdb uses import-vdb, changing(override) visibility to a model from imported vdb would need to hide non-related model to the new vdb. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2016