August 2010 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1218) AdminShell help for changeVDBConnectionType is "Cancel a request"

by Paul Nittel (JIRA)

AdminShell help for changeVDBConnectionType is "Cancel a request" ----------------------------------------------------------------- Key: TEIID-1218 URL: https://jira.jboss.org/browse/TEIID-1218 Project: Teiid Issue Type: Bug Components: Tools Affects Versions: 7.1 Environment: All Reporter: Paul Nittel Assignee: Steve Hawkins Priority: Trivial Start AdminShell and enter \ah (to get help). In the list, you'll see the following: groovy:000> \ah /* method(arg count) -- description */ addDataRoleMapping(4) -- Adds a role to the specified policy adminHelp() -- Show help for all admin methods adminHelp(1) -- Show help for the given admin method assignToModel(6) -- Assign a translator and data source to a source Model cancelRequest(2) -- Cancel a request changeVDBConnectionType(3) -- Cancel a request clearCache(1) -- Clear the given cache It looks like a cut & paste error for the changeVDBConnectionType method. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

4
3
0 / 0

[JBoss JIRA] Created: (TEIID-1030) Provide ability to retrieve a VDB archive from ModeShape repository and then deploy the Teiid runtime.

by Van Halbert (JIRA)

Provide ability to retrieve a VDB archive from ModeShape repository and then deploy the Teiid runtime. ------------------------------------------------------------------------------------------------------ Key: TEIID-1030 URL: https://jira.jboss.org/jira/browse/TEIID-1030 Project: Teiid Issue Type: Feature Request Components: Jopr Plugin Reporter: Van Halbert Assignee: Ted Jones Fix For: 7.1 Provide the ability to retrieve VDB archives from ModeShape repository and then deployed to Teiid runtime -- 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

14 years, 2 months

4
4
0 / 0

[JBoss JIRA] Created: (TEIID-1225) Reuse procedure plans

by Steve Hawkins (JIRA)

Reuse procedure plans --------------------- Key: TEIID-1225 URL: https://jira.jboss.org/browse/TEIID-1225 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Fix For: 7.1.1 Stored procedure plans should be reused as much as possible - not just if the client is using a prepared statement. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-1224) Stored Procedures - java exception being thrown relating to pre-evaluation of uncorrelated subqueries

by Warren Gibson (JIRA)

Stored Procedures - java exception being thrown relating to pre-evaluation of uncorrelated subqueries ----------------------------------------------------------------------------------------------------- Key: TEIID-1224 URL: https://jira.jboss.org/browse/TEIID-1224 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1 Environment: Teiid 7.1 Final Reporter: Warren Gibson Assignee: Steve Hawkins Several BQT Stored Procedures are returning "java.lang.ClassCastException: org.teiid.query.processor.relational.ProjectNode cannot be cast to org.teiid.query.processor.relational.AccessNode" An example of a failing query is: SELECT IntKey, IntNum FROM BQT2.MediumB WHERE IntNum = (EXEC SP.sp_count_rows_between(10, 20)) ORDER BY IntKey Log file for this query is attached. Engineering analysis indicates the issue is related pre-evaluation of uncorrelated subqueries. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

3
3
0 / 0

[JBoss JIRA] Created: (TEIID-1216) Cannot pass xml result from one select as critera to another select

by John Doyle (JIRA)

Cannot pass xml result from one select as critera to another select ------------------------------------------------------------------- Key: TEIID-1216 URL: https://jira.jboss.org/browse/TEIID-1216 Project: Teiid Issue Type: Bug Affects Versions: 7.1 Environment: Teiid 7.1 CR2 on RHEL 5 Reporter: John Doyle Assignee: Steve Hawkins I've created a VDB with procedures to create and parse XML, as wall as one to invoke the WS connector. SQL that unites them all into a single call passing the created XML into the invoke procedure is failing: SELECT t.* FROM table (EXEC cis.CountryInfoServiceXML.CapitalCity.create_CapitalCity('US')) AS request, table (EXEC CountryInfoService.invoke('SOAP11', '', request.xml_out, 'http://www.oorsprong.org/websamples.countryinfo/CountryInfoService.wso')) AS response, table (EXEC cis.CountryInfoServiceXML.CapitalCity.extract_CapitalCityResponse(RESPONSE.result)) AS t; 13:23:02,501 ERROR [PROCESSOR] Unexpected exception for request wHnSpxDdmkGB.5 [TeiidComponentException] ERR.015.006.0033: Error Code:ERR.015.006.0033 Message:Unable to evaluate request.xml_out: No value was available at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:389) at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:629) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 2 months

3
3
0 / 0

[JBoss JIRA] Updated: (TEIID-992) Improve update of source costing statistics

by Steve Hawkins (JIRA)

[ https://jira.jboss.org/browse/TEIID-992?page=com.atlassian.jira.plugin.sy... ] Steve Hawkins updated TEIID-992: -------------------------------- Fix Version/s: 8.0 > Improve update of source costing statistics > ------------------------------------------- > > Key: TEIID-992 > URL: https://jira.jboss.org/browse/TEIID-992 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors, Query Engine > Reporter: Marc Shirley > Fix For: 8.0 > > > It is very important that we support the ability to update source statistics at runtime. This is important due to the changing nature of read/write sources and differences between a development data source and a production data source. > The following options should be possible: > 1) Update model/source statistics on VDB deployment. > 2) Update model/source statistics on connector startup. > 3) Update model/source statistics on at a scheduled time. > 4) Update model/source statistics upon a manual request. > case 5920 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 4 months

1
0
0 / 0

[JBoss JIRA] Resolved: (TEIID-993) Enhance XML processing to execute relational queries in parallel when possible

by Steve Hawkins (JIRA)

[ https://jira.jboss.org/browse/TEIID-993?page=com.atlassian.jira.plugin.sy... ] Steve Hawkins resolved TEIID-993. --------------------------------- Resolution: Deferred We are unlikely to implement this anytime soon. > Enhance XML processing to execute relational queries in parallel when possible > ------------------------------------------------------------------------------ > > Key: TEIID-993 > URL: https://jira.jboss.org/browse/TEIID-993 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Steven Hawkins > > Per feedback from Barry, was reviewing XML processing and because we execute all queries serially in our XML processing. However, conceptually, we could often execute multiple mapping class and/or temp table queries in parallel. When time permits it might be benefitial to investigate this. > All mapping classes at depth "n" in the document model are independent of each other, so they can be executed in parallel. Each mapping class may have input sets to any ancestor mapping class up to depth "n-1", or may select from any temp table up to depth "n" (the same depth). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 4 months

1
0
0 / 0

[JBoss JIRA] Created: (TEIID-1207) Fix Yahoo Translator to work with "Dynamic Portfoilo" example

by Ramesh Reddy (JIRA)

Fix Yahoo Translator to work with "Dynamic Portfoilo" example ------------------------------------------------------------- Key: TEIID-1207 URL: https://jira.jboss.org/browse/TEIID-1207 Project: Teiid Issue Type: Task Components: Misc. Connectors Affects Versions: 7.0 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Priority: Minor Fix For: 7.1 The "DynamicPortfoilo" example is driven between "text" and "relational" source, and shows how these two sources can be integrated into single view. Where as Yahoo translator is written as extension, where user can replace the "text" translator and use "yahoo" translator and get the delayed quotes from Yahoo web site. which are more or less real time. This shows the user ability switch sources and keep the top level model work as before. However, currently "yahoo translator" does not expose the metadata so that it can be used with dynamic vdb scenario. This needs to be fixed for example purposes. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 4 months

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-1201) Property 'Url' with value 'vfsfile:/home/pnittel/Teiid71/jboss-5.1.0.GA/server/default/deploy/EyeTuneZ-vdb.xml' is not a valid URL

by Paul Nittel (JIRA)

Property 'Url' with value 'vfsfile:/home/pnittel/Teiid71/jboss-5.1.0.GA/server/default/deploy/EyeTuneZ-vdb.xml' is not a valid URL ---------------------------------------------------------------------------------------------------------------------------------- Key: TEIID-1201 URL: https://jira.jboss.org/browse/TEIID-1201 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1 Environment: Fedora 12, Java(TM) SE Runtime Environment (build 1.6.0_17-b04), Teiid 7.1CR2 build 8/10 Reporter: Paul Nittel Assignee: Steve Hawkins While trying to recreate the iTunes E2E test, I deployed a dynamic VDB which points to my iTunes XML file. When first deployed, it produced the error in the title. Subsequent tries to get it to fail, failed, but Ramesh noted AdminShell's getVDBs() method would trigger it. [AdminComponentException] 0: Error Code:0 Message:Error Code:0 Message:Property 'Url' with value 'vfsfile:/home/pnittel/Teiid71CR2_0810/jboss-5.1.0.GA/server/default/deploy/EyeTuneZ-vdb.xml' is not a valid URL. 1 [AdminComponentException] 0: Error Code:0 Message:Property 'Url' with value 'vfsfile:/home/pnittel/Teiid71CR2_0810/jboss-5.1.0.GA/server/default/deploy/EyeTuneZ-vdb.xml' is not a valid URL. 2 [InvalidPropertyException] 0: Property 'Url' with value 'vfsfile:/home/pnittel/Teiid71CR2_0810/jboss-5.1.0.GA/server/default/deploy/EyeTuneZ-vdb.xml' is not a valid URL. 3 [IllegalArgumentException]Conversion from String to java.net.URL is not supported at org.teiid.client.util.ExceptionUtil.convertException(ExceptionUtil.java:72) at org.teiid.jboss.deployers.RuntimeEngineDeployer$1.invoke(RuntimeEngineDeployer.java:252) at $Proxy258.getVDBs(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:81) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188) at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:160) at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:149) at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:210) at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:100) at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545) at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:754) at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:144) at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545) at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:754) at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:302) at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:317) at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:299) at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:216) at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:80) at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545) at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:540) at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:274) at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:261) at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:340) at org.jboss.netty.channel.socket.nio.NioWorker.processSelectedKeys(NioWorker.java:272) at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:192) at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) at org.jboss.netty.util.internal.IoWorkerRunnable.run(IoWorkerRunnable.java:46) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: [AdminComponentException] 0: Error Code:0 Message:Property 'Url' with value 'vfsfile:/home/pnittel/Teiid71CR2_0810/jboss-5.1.0.GA/server/default/deploy/EyeTuneZ-vdb.xml' is not a valid URL. 1 [InvalidPropertyException] 0: Property 'Url' with value 'vfsfile:/home/pnittel/Teiid71CR2_0810/jboss-5.1.0.GA/server/default/deploy/EyeTuneZ-vdb.xml' is not a valid URL. 2 [IllegalArgumentException]Conversion from String to java.net.URL is not supported at org.teiid.adminapi.jboss.Admin.getVDBs(Admin.java:229) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) at org.teiid.jboss.deployers.RuntimeEngineDeployer$1.invoke(RuntimeEngineDeployer.java:246) ... 33 more Caused by: Property 'Url' with value 'vfsfile:/home/pnittel/Teiid71CR2_0810/jboss-5.1.0.GA/server/default/deploy/EyeTuneZ-vdb.xml' is not a valid URL.Conversion from String to java.net.URL is not supported at org.teiid.core.util.PropertiesUtils.setBeanProperty(PropertiesUtils.java:998) at org.teiid.adminapi.jboss.AdminObjectBuilder.buildAO(AdminObjectBuilder.java:70) at org.teiid.adminapi.jboss.Admin.getVDBs(Admin.java:225) ... 39 more Caused by: java.lang.IllegalArgumentException: Conversion from String to java.net.URL is not supported at org.teiid.core.util.StringUtil.valueOf(StringUtil.java:1006) at org.teiid.core.util.PropertiesUtils.setBeanProperty(PropertiesUtils.java:994) ... 41 more Appropriate artifacts will be attached. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 4 months

3
4
0 / 0

[JBoss JIRA] Created: (TEIID-1177) Allow for implicit temp table definition with just a query, omitting the columns

by Steve Hawkins (JIRA)

Allow for implicit temp table definition with just a query, omitting the columns --------------------------------------------------------------------------------- Key: TEIID-1177 URL: https://jira.jboss.org/browse/TEIID-1177 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.1 Reporter: Steve Hawkins Assignee: Steve Hawkins Priority: Optional Fix For: 7.1 currently you must use target columns to define a temp table with a query expression: insert into #temp (x, y,z) select x, y, z from t but the following should be allowed as well: insert into #temp select x, y, z from t -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 4 months

1
2
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2010