January 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Closed: (TEIID-1334) java.net.URISyntaxException starting jboss-soa-p-5 (i.e. with Teiid) installed on LINUX under folder name containing spaces

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1334?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-1334. --------------------------------- > java.net.URISyntaxException starting jboss-soa-p-5 (i.e. with Teiid) installed on LINUX under folder name containing spaces > --------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-1334 > URL: https://issues.jboss.org/browse/TEIID-1334 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 7.1 > Reporter: Barry LaFond > Assignee: Van Halbert > Fix For: 7.1.1 > > > Installed jboss-soa-p-5 in a folder under a "Test Designer Folder" folder. Installed EDS on top of it and ran the "ant" build to configure SOA for Teiid and Modeshape. > Installed JBDS and created/started an instance of JBoss AS server connection > On start-up got errrors: > DEPLOYMENTS MISSING DEPENDENCIES: > Deployment "VDBDeployer" is missing the following dependencies: > Dependency "SystemVDBDeployer" (should be in state "Create", but is actually in state "**ERROR**") > DEPLOYMENTS IN ERROR: > Deployment "SystemVDBDeployer" is in error due to the following reason(s): java.net.URISyntaxException: Illegal character in path at index 23: file:/home/blafond/Test Designer Folder/ServerInstalls/jboss-soa-p-5/jboss-as/server/default/deployers/teiid.deployer/teiid-metadata-7.1.1.jar/System.vdb, **ERROR** > I changed the containing folder and removed the spaces, restarted everything and did NOT receiver the error. > See attached file for Stack Trace. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 2 months

1
0
0 / 0

[JBoss JIRA] Closed: (TEIID-211) subquery optimization

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-211?page=com.atlassian.jira.plugin.... ] Steven Hawkins closed TEIID-211. -------------------------------- > subquery optimization > --------------------- > > Key: TEIID-211 > URL: https://issues.jboss.org/browse/TEIID-211 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 6.0.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 7.3 > > > Implement rewriter (and planner) optimizations for subqueries based upon semi and anti semi join capabilities. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 2 months

1
0
0 / 0

[JBoss JIRA] Created: (TEIID-1340) Unable to delete vdb using JOPR, throws exception

by Van Halbert (JIRA)

Unable to delete vdb using JOPR, throws exception ------------------------------------------------- Key: TEIID-1340 URL: https://jira.jboss.org/browse/TEIID-1340 Project: Teiid Issue Type: Bug Components: Jopr Plugin Reporter: Van Halbert Assignee: Ted Jones Fix For: 7.1.1 Tried to delete a vdb from JOPR and an exception is shown in the console. To reproduce: - copy the examples portfolio-vdb.xml to the deploy directory - i restarted the server (for kicks and grins) - went to admin-console and viewed the vdbs, the portfolio says it is down (because I didn't setup all the data sources) - selected the portfolio vdb, and press the delete action button. This exception is seen: Failed to delete Virtual Database (VDB)s 'DynamicPortfolio.1' - java.lang.Exception: Failed to stop deployment 'DynamicPortfolio.1' - cause: java.lang.RuntimeException: org.jboss.profileservice.spi.NoSuchDeploymentException: Failed to find deployment in file: DynamicPortfolio.1 at org.teiid.rhq.plugin.Facet.deleteResource(Facet.java:409) 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.rhq.core.pc.inventory.ResourceContainer$ComponentInvocationThread.call(ResourceContainer.java:525) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) 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:637) -- 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

15 years, 2 months

3
2
0 / 0

[JBoss JIRA] Closed: (TEIID-962) Create new system function to dump temp table contents to file.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-962?page=com.atlassian.jira.plugin.... ] Steven Hawkins closed TEIID-962. -------------------------------- > Create new system function to dump temp table contents to file. > ----------------------------------------------------------------- > > Key: TEIID-962 > URL: https://issues.jboss.org/browse/TEIID-962 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 6.0.0 > Environment: All > Reporter: Ken Johnson > Assignee: Ramesh Reddy > Fix For: 7.2 > > > A requirement to produce a CSV file reflecting the contents of a query result set so it can be subsequently FTP'd or email'd. In Nov 07 implemented this feature using the exec connector, a shell script and mods to JDBCISQL. > Suggested capability: function will take the following parameters: > - Temp table name as string > - Target file name (path qualified) as string > - Delimiter as string > When invoked, the specified temp table contents will be written out to the specified file using the specified delimiter to separate the column values. > This generic capability will allow the CSV file thats needed and subsequently process it with other UDF functionality as necessary. > Open questions: > 1. How does file path behave in a clustered environment? Is it relative to the MM Server install dir or fully qualified? > Suggest this feature remain undocumented for the short term. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 2 months

1
0
0 / 0

[JBoss JIRA] Closed: (TEIID-982) Materialized Views should be treated as a service in MMx through the Console

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-982?page=com.atlassian.jira.plugin.... ] Steven Hawkins closed TEIID-982. -------------------------------- > Materialized Views should be treated as a service in MMx through the Console > ---------------------------------------------------------------------------- > > Key: TEIID-982 > URL: https://issues.jboss.org/browse/TEIID-982 > Project: Teiid > Issue Type: Feature Request > Components: Jopr Plugin > Reporter: Marc Shirley > Assignee: Ted Jones > Fix For: 7.1.1 > > > Should be a service, controlled in Console, logs controlled by Log Settings, viewable by Log Viewer. There should also be a way to verify success/failure, last run time, from within Console. This could also be linked into the scheduling service (JBEDSP-144) if that existed. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 2 months

1
0
0 / 0

[JBoss JIRA] Created: (TEIID-1361) Salesforce IN predicate handling

by Steven Hawkins (JIRA)

Salesforce IN predicate handling -------------------------------- Key: TEIID-1361 URL: https://jira.jboss.org/browse/TEIID-1361 Project: Teiid Issue Type: Bug Components: Salesforce Connector Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 7.1.1, 7.3 If the name in source of the table of an IN left hand expression do not match exactly with the Teiid name, the the translator will erroneously drop the predicate. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 2 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1348) Internal Mat View of table with Primary Key gets dpulicate key error when populating temporary mat view table

by Paul Nittel (JIRA)

Internal Mat View of table with Primary Key gets dpulicate key error when populating temporary mat view table ------------------------------------------------------------------------------------------------------------- Key: TEIID-1348 URL: https://jira.jboss.org/browse/TEIID-1348 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1.1 Environment: Fedora 12, SOA-P ER3, JBDS 4.0 Beta1 Reporter: Paul Nittel Assignee: Steven Hawkins Fix For: 7.1.1 I was testing Internal Materialized Views when I encountered this. I had modeled a bookInfo (books and publishers) view with a PK of the ISBN column. This was cloned to SonOfbookInfo and materialized views set to true. I deployed this in a VDB and queried with SQuirreL: select title from BooksInfo.SonOfbookInfo This resulted in a duplicate key error (excerpt below... whole log is attached.) 2010-11-04 10:50:16,450 ERROR [org.teiid.PROCESSOR.MATVIEWS] (Worker99_QueryProcessorQueue3659) Failed to load materialized view table #MAT_BOOKSINFO.SONOFBOOKINFO. [TeiidProcessingException]Duplicate key at org.teiid.query.tempdata.TempTable.insertTuple(TempTable.java:550) at org.teiid.query.tempdata.TempTable.access$200(TempTable.java:71) at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.tuplePassed(TempTable.java:106) at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:207) at org.teiid.query.tempdata.TempTable.insert(TempTable.java:446) at org.teiid.query.tempdata.TempTableDataManager.loadGlobalTable(TempTableDataManager.java:513) at org.teiid.query.tempdata.TempTableDataManager.registerQuery(TempTableDataManager.java:410) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:182) at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:170) at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:197) at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:118) at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250) at org.teiid.query.processor.relational.LimitNode.open(LimitNode.java:110) at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:98) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:134) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:249) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:183) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:189) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290) 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) -- 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

15 years, 2 months

2
4
0 / 0

[JBoss JIRA] Created: (TEIID-1273) Add support of INSERT Statements

by julien reboul (JIRA)

Add support of INSERT Statements -------------------------------- Key: TEIID-1273 URL: https://jira.jboss.org/browse/TEIID-1273 Project: Teiid Issue Type: Feature Request Reporter: julien reboul Assignee: Steven Hawkins Please add support for INSERT statements inside a VDB. At least for the inderlying sources that can handle it (SQL Datasources for instance). -- 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

15 years, 2 months

3
5
0 / 0

[JBoss JIRA] Created: (TEIID-1289) hasNext causes indexing issue

by Steven Hawkins (JIRA)

hasNext causes indexing issue ----------------------------- Key: TEIID-1289 URL: https://jira.jboss.org/browse/TEIID-1289 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 7.1.1 Over a sequence of steps, a call to hasNext will casue the BatchIterator to not save it's state appropriately on a mark call. -- 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

15 years, 2 months

1
2
0 / 0

[JBoss JIRA] Created: (TEIID-1360) with clause not processed in views

by Steven Hawkins (JIRA)

with clause not processed in views ---------------------------------- Key: TEIID-1360 URL: https://jira.jboss.org/browse/TEIID-1360 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.2 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 7.3 Due to their handling in RelationalPlanner, with clauses are not processed in views or inline views. User commands and procedure command statements work as expected. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years, 2 months

1
2
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2011