September 2009 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-786) Minor performance enhancements

by Ramesh Reddy (JIRA)

Minor performance enhancements ------------------------------ Key: TEIID-786 URL: https://jira.jboss.org/jira/browse/TEIID-786 Project: Teiid Issue Type: Quality Risk Affects Versions: 6.2.0 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 6.2.0 This used as bucket for couple of minor performance enhancements in the Teiid project. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

16 years, 6 months

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-791) M2 build getting NPE when connecting to VDB

by Paul Nittel (JIRA)

M2 build getting NPE when connecting to VDB ------------------------------------------- Key: TEIID-791 URL: https://jira.jboss.org/jira/browse/TEIID-791 Project: Teiid Issue Type: Bug Environment: 6.2.0 M2, fedora 10, Java build 1.6.0_11-b03 Reporter: Paul Nittel Assignee: Steven Hawkins I found I get this NPE when connecting to the admin VDB. I see this using both a simple JDBC test tool and AdminShell. 2009-08-18 10:07:51,957 ERROR [Worker0_SocketWorker1] org.teiid.ADMIN - Unexpected exception for session 0 java.lang.NullPointerException at com.metamatrix.jdbc.EmbeddedConnectionFactoryImpl.getProcess(EmbeddedConnectionFactoryImpl.java:382) at com.metamatrix.dqp.embedded.admin.DQPMonitoringAdminImpl.getProcesses(DQPMonitoringAdminImpl.java:377) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.metamatrix.core.util.MixinProxy.invoke(MixinProxy.java:48) at com.metamatrix.jdbc.EmbeddedConnectionFactoryImpl$1.invoke(EmbeddedConnectionFactoryImpl.java:364) at $Proxy22.getProcesses(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.teiid.transport.AdminAuthorizationInterceptor.invoke(AdminAuthorizationInterceptor.java:122) at $Proxy22.getProcesses(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:100) at com.metamatrix.common.queue.WorkerPoolFactory$StatsCapturingSharedThreadPoolExecutor$1.run(WorkerPoolFactory.java:211) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

16 years, 6 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-795) Embedded connection issues after restart

by Ramesh Reddy (JIRA)

Embedded connection issues after restart ---------------------------------------- Key: TEIID-795 URL: https://jira.jboss.org/jira/browse/TEIID-795 Project: Teiid Issue Type: Bug Affects Versions: 6.2.0 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 6.2.0 After the restart of the embedded using the Admin API, the previous active connection continues to use the old instance of the Embedded and gets into NPE as the old instance taken down. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

16 years, 6 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-809) Path to config file has been remove from deploy.properties and Teiid is looking in the wrong location.

by John Doyle (JIRA)

Path to config file has been remove from deploy.properties and Teiid is looking in the wrong location. ------------------------------------------------------------------------------------------------------ Key: TEIID-809 URL: https://jira.jboss.org/jira/browse/TEIID-809 Project: Teiid Issue Type: Bug Components: Embedded Affects Versions: 6.2.0 Environment: File path Teiid embedded running in SQuirrel SQL. Build of 8-28 Reporter: John Doyle Assignee: Steven Hawkins Fix For: 6.2.0 Earlier versions of deploy.properties had this line. dqp.configFile=./deploy/configuration.xml This line is gone from the current version of the file, and Teiid is looking in the top level folder, not the ./deploy folder for the configuration.xml -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

16 years, 6 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-818) Error returned from SQL Server: Incorrect syntax near: NULLS

by Paul Nittel (JIRA)

Error returned from SQL Server: Incorrect syntax near: NULLS ------------------------------------------------------------ Key: TEIID-818 URL: https://jira.jboss.org/jira/browse/TEIID-818 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.2.0 Environment: Fedora 10, build from 8/31/09, Java HotSpot(TM) Server VM (build 11.0-b16, mixed mode) Reporter: Paul Nittel Assignee: Steven Hawkins Running the TPCR queries has worked previously, I believe even with Teiid from a short while back. Now it's not. This particular query is detailed below. Transformation text: SELECT S_NAME, COUNT(*) AS numwait FROM TPCR.SUPPLIER, TPCR.LINEITEM AS l1, TPCR.ORDERS, TPCR.NATION WHERE (S_SUPPKEY = L_SUPPKEY) AND (O_ORDERKEY = L_ORDERKEY) AND (O_ORDERSTATUS = 'F') AND (L_RECEIPTDATE > L_COMMITDATE) AND (EXISTS (SELECT * FROM TPCR.LINEITEM AS l2 WHERE (l2.L_ORDERKEY = l1.L_ORDERKEY) AND (l2.L_SUPPKEY <> l1.L_SUPPKEY))) AND (NOT (EXISTS (SELECT * FROM TPCR.LINEITEM AS l3 WHERE (l3.L_ORDERKEY = l1.L_ORDERKEY) AND (l3.L_SUPPKEY <> l1.L_SUPPKEY) AND (l3.L_RECEIPTDATE > l3.L_COMMITDATE)))) AND (S_NATIONKEY = N_NATIONKEY) AND (N_NAME = 'SAUDI ARABIA') GROUP BY S_NAME Query I executed: select * from vTpcr.Q21 ORDER BY numwait desc, s_name LIMIT 100; Error I received: 2009-09-02 10:42:23,491 ERROR [Worker0_QueryProcessorQueue1] org.teiid.DQP - Unexpected exception for request 0.0 [MetaMatrixComponentException] 170: Error Code:170 Message:Error Code:170 Message:Error occurred on connector TPCR Connector<2> - Error Code:170 Message:Line 1: Incorrect syntax near 'NULLS'. Executing statement: [SQL: SELECT TOP 100 * FROM (SELECT g_0.S_NAME AS c_0, COUNT(*) AS c_1 FROM SUPPLIER g_0, LINEITEM g_1, ORDERS g_2, NATION g_3 WHERE (g_0.S_SUPPKEY = g_1.L_SUPPKEY) AND (g_2.O_ORDERKEY = g_1.L_ORDERKEY) AND (g_0.S_NATIONKEY = g_3.N_NATIONKEY) AND (g_1.L_RECEIPTDATE > g_1.L_COMMITDATE) AND (EXISTS (SELECT g_4.L_ORDERKEY, g_4.L_PARTKEY, g_4.L_SUPPKEY, g_4.L_LINENUMBER, g_4.L_QUANTITY, g_4.L_EXTENDEDPRICE, g_4.L_DISCOUNT, g_4.L_TAX, g_4.L_RETURNFLAG, g_4.L_LINESTATUS, g_4.L_SHIPDATE, g_4.L_COMMITDATE, g_4.L_RECEIPTDATE, g_4.L_SHIPINSTRUCT, g_4.L_SHIPMODE, g_4.L_COMMENT FROM LINEITEM g_4 WHERE (g_4.L_ORDERKEY = g_1.L_ORDERKEY) AND (g_4.L_SUPPKEY <> g_1.L_SUPPKEY))) AND (NOT (EXISTS (SELECT g_5.L_ORDERKEY, g_5.L_PARTKEY, g_5.L_SUPPKEY, g_5.L_LINENUMBER, g_5.L_QUANTITY, g_5.L_EXTENDEDPRICE, g_5.L_DISCOUNT, g_5.L_TAX, g_5.L_RETURNFLAG, g_5.L_LINESTATUS, g_5.L_SHIPDATE, g_5.L_COMMITDATE, g_5.L_RECEIPTDATE, g_5.L_SHIPINSTRUCT, g_5.L_SHIPMODE, g_5.L_COMMENT FROM LINEITEM g_5 WHERE (g_5.L_ORDERKEY = g_1.L_ORDERKEY) AND (g_5.L_SUPPKEY <> g_1.L_SUPPKEY) AND (g_5.L_RECEIPTDATE > g_5.L_COMMITDATE)))) AND (g_2.O_ORDERSTATUS = 'F') AND (g_3.N_NAME = 'SAUDI ARABIA') GROUP BY g_0.S_NAME) AS X ORDER BY c_1 DESC NULLS LAST, c_0] 1 [ConnectorException]Error Code:170 Message:Error occurred on connector TPCR Connector<2> - Error Code:170 Message:Line 1: Incorrect syntax near 'NULLS'. This failed both in the Designer (running the version from 8/31) and Teiid (9/1, running as a server). I'll attach the server log and project to this defect. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

16 years, 6 months

4
11
0 / 0

[JBoss JIRA] Created: (TEIID-793) Admin connection is not being auth

by Ramesh Reddy (JIRA)

Admin connection is not being auth ---------------------------------- Key: TEIID-793 URL: https://jira.jboss.org/jira/browse/TEIID-793 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 6.2.0 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Priority: Blocker Fix For: 6.2.0 Currently the admin connections made using "ServerAdminFactory" were not subject to the login restrictions, so the connection is wide open. This needs to be fixed. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

16 years, 6 months

2
5
0 / 0

[JBoss JIRA] Created: (TEIID-802) Move the properties defined in DQPConfigSource into DQpEmbeddedProperties

by Ramesh Reddy (JIRA)

Move the properties defined in DQPConfigSource into DQpEmbeddedProperties -------------------------------------------------------------------------- Key: TEIID-802 URL: https://jira.jboss.org/jira/browse/TEIID-802 Project: Teiid Issue Type: Quality Risk Components: Common, Embedded, Server Affects Versions: 6.2.0 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Priority: Minor Fix For: 6.2.0 Currently there are some properties defined under DQConfigSource class that are used by the engine code. The main class for the properties is defined under DQPEmbeddedProperties. We need consolidate them and I see few properties defined but not reading them in the code. Also, rename the properties to match the functionality where needed. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

16 years, 6 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-804) Source download is currently not in form which is readily consumable by the developers

by Ramesh Reddy (JIRA)

Source download is currently not in form which is readily consumable by the developers -------------------------------------------------------------------------------------- Key: TEIID-804 URL: https://jira.jboss.org/jira/browse/TEIID-804 Project: Teiid Issue Type: Bug Components: Build/Kits Affects Versions: 6.1.0 Reporter: Ramesh Reddy Assignee: Steven Hawkins Fix For: 6.2.0 The teiid-source-{version}.zip that is distributed along with runtime kits is not in development consumable form. However it is good for debugging purposes or just reference for the source code. The users looking for the development mean while should get the source code from anonymous svn location. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

16 years, 6 months

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-812) Embedded deployment is creating "log" directory in wrong location

by Ramesh Reddy (JIRA)

Embedded deployment is creating "log" directory in wrong location ----------------------------------------------------------------- Key: TEIID-812 URL: https://jira.jboss.org/jira/browse/TEIID-812 Project: Teiid Issue Type: Bug Components: Embedded Affects Versions: 6.2.0 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 6.2.0 When Teiid used in the "embedded" with "file-path" profile, like deployed JBoss AS, it is creating the log directory where the parent process is started from instead of placing it under "{teiid-home}/log" directory. It is expected that when using "classpath-profile" it will create under the {user.dir} -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

16 years, 6 months

1
3
0 / 0

[JBoss JIRA] Created: (TEIID-840) admin-roles appears to be ignored and allegedly privileged users cannot execute methods appropriately

by Paul Nittel (JIRA)

admin-roles appears to be ignored and allegedly privileged users cannot execute methods appropriately ----------------------------------------------------------------------------------------------------- Key: TEIID-840 URL: https://jira.jboss.org/jira/browse/TEIID-840 Project: Teiid Issue Type: Bug Components: AdminApi Affects Versions: 6.2.0 Environment: fedora 10, Teiid 6.2 RC1 Reporter: Paul Nittel Assignee: Steven Hawkins Attachments: admin-roles.properties, deploy.properties Connecting as admin, I am able to execute this command string to see the group(s) to which pnittel belongs: c=getGroupsForUser( "pnittel"); for (cb:c) { print( cb.getName() ); } Connecting as pnittel, I cannot execute that same command. pnittel is a member of the itgroup and that group is assigned all three roles. I'm attaching deploy.properties and admin-roles.properties. Here's the dialog: admin $ connectAsAdmin("pnittel","mm","mm://localhost:31000"); conn-1[mm://localhost:31000] $ c=getGroupsForUser( "pnittel"); for (cb:c) { print( cb.getName() ); } Remote exception: Administrator [pnittel@TheDap], session [3] does not have any required role [Admin.SystemAdmin] so is not authorized to perform the action [getGroupsForUser]. ... Original type hierarchy [org.teiid.adminapi.AdminProcessingException, org.teiid.adminapi.AdminException, com.metamatrix.core.MetaMatrixCoreException]. conn-1[mm://localhost:31000] $ // Error: EvalError: The collection, array, map, iterator, or enumeration portion of a for statement cannot be null. : at Line: 3 : in file: <unknown file> : for ( cb : c ) { conn-1[mm://localhost:31000] $ conn-1[mm://localhost:31000] $ disconnect(); admin $ connectAsAdmin("admin","teiid","mm://localhost:31000"); conn-2[mm://localhost:31000] $ c=getGroupsForUser( "pnittel"); for (cb:c) { print( cb.getName() ); } conn-2[mm://localhost:31000] $ itgroup@TheDap -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

16 years, 6 months

2
5
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2009