[JBoss JIRA] (TEIIDDES-2219) Preview Issue - when non-Type4 JDBC driver is used.
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2219?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2219:
-----------------------------------
Fix Version/s: 11.0
(was: 10.0.2)
> Preview Issue - when non-Type4 JDBC driver is used.
> ---------------------------------------------------
>
> Key: TEIIDDES-2219
> URL: https://issues.jboss.org/browse/TEIIDDES-2219
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview, Patch Release
> Affects Versions: 8.5
> Reporter: Mark Drilling
> Assignee: Mark Drilling
> Fix For: 11.0
>
> Attachments: ojdbc14.jar
>
>
> Encountered issue when trying to preview an Oracle source table in Designer. The preview failed with the following in the server log:
> 10:39:44,877 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) TEIID30020 Processing exception for request N0JYBgYp8yw2.0 'TEIID30498 Capabilities for OracleSource were not avaialable. The command could not be planned properly.'. Originally QueryPlannerException PlanToProcessConverter.java:324. Enable more detailed logging to see the entire stacktrace.
> Upon debug, I found that the 'type' for my deployed oracle driver 'ojdbc14.jar' was not found on the server. The ojdbc14.jar was actually getting deployed in ExecutionAdmin, but the type was not present - because it was not a type4 jdbc driver.
> However, the preview proceeded (and failed) with the above exception.
> We need to investigate and handle this case more gracefully in Designer. The preview should not proceed - we should catch this error and display to the user - and stop the preview attempt.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-1949) Unable to create function from the reconciler
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1949?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-1949.
------------------------------------
Resolution: Won't Fix
Not worth the time/resources to implement this and there is a workaround.
> Unable to create function from the reconciler
> ----------------------------------------------
>
> Key: TEIIDDES-1949
> URL: https://issues.jboss.org/browse/TEIIDDES-1949
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs
> Affects Versions: 8.3
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Priority: Minor
> Fix For: 10.0.2
>
>
> Description of problem: Trying to create a function to concatenate last and first names, but nothing would return from dialog after pressing OK. Looking in the log, NPE was found:
> java.lang.NullPointerException
> at org.teiid.query.function.FunctionTree.getFunction(FunctionTree.java:386)
> at org.teiid.query.function.FunctionLibrary.findFunction(FunctionLibrary.java:141)
> at org.teiid.query.function.FunctionLibrary.findFunction(FunctionLibrary.java:1)
> at org.teiid.designer.transformation.ui.reconciler.ReconcilerPanel.syncFunction(ReconcilerPanel.java:725)
> at org.teiid.designer.transformation.ui.reconciler.ReconcilerPanel.expressionButtonPressed(ReconcilerPanel.java:681)
> at org.teiid.designer.transformation.ui.reconciler.ReconcilerPanel$6.widgetSelected(ReconcilerPanel.java:364)
> at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-1732) Stream line steps to implement all the steps around materialization
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1732?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-1732:
-----------------------------------
Fix Version/s: 11.0
(was: 10.0.2)
> Stream line steps to implement all the steps around materialization
> --------------------------------------------------------------------
>
> Key: TEIIDDES-1732
> URL: https://issues.jboss.org/browse/TEIIDDES-1732
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Modeling
> Affects Versions: 8.2
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Fix For: 11.0
>
>
> Would like to stream line the steps to putting materialization to work. Example:
> - Right mouse click on view, select materialization
> - present wizard to walk thru the following options:
> - create physical table based on selected view/table (export/import of ddl is supported, but would like the table automatically created)
> - put name of mat table into the selected table/view to be materialized
> - [optional] export DDL (file system or clipboard)
> - [optional] create procedure that has the "select into" for refreshing
> Having the procedure provides the immediate ability to call to refresh, without having to remember what tables. Also, with the feature of native queries, could add the truncate call to clear the table.
> Once thru this wizard, (I think) everything is in place to do materialization for the specified table.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-1618) Support partition statistics
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1618?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-1618:
-----------------------------------
Fix Version/s: 11.0
(was: 10.0.2)
> Support partition statistics
> ----------------------------
>
> Key: TEIIDDES-1618
> URL: https://issues.jboss.org/browse/TEIIDDES-1618
> Project: Teiid Designer
> Issue Type: Feature Request
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Fix For: 11.0
>
>
> The stats gathering feature does not take into account of partition statistics. Most of our query hit a single partition and using the global stats is not a true indication of the statistics for the single partition. It would be nice if Teiid engine can differentiate the usage of global and partition statistics during the optimisation and planning stages.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-1386) Cannot multi-select schema contents when building response procedure result set (Web Service as input)
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1386?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-1386:
-----------------------------------
Fix Version/s: 11.0
(was: 10.0.2)
> Cannot multi-select schema contents when building response procedure result set (Web Service as input)
> ------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1386
> URL: https://issues.jboss.org/browse/TEIIDDES-1386
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 7.7.1
> Reporter: Paul Nittel
> Assignee: Barry LaFond
> Fix For: 11.0
>
> Attachments: CannotMultiSelect.png
>
>
> When modeling the response result set for an incoming Web Service, the user must select each attribute individually and click the Add button. Intuitively, I tried to multi-select the attributes, but that is not permitted. It should be. :-) Screenshot is attached.
> I used the Oorsprong FullCountryInfo operation which has several output attributes from which to choose.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2860) deleting MATVIEW deletes the upper view model
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2860?page=com.atlassian.jira.plu... ]
Van Halbert edited comment on TEIIDDES-2860 at 6/22/16 1:52 PM:
----------------------------------------------------------------
In this case, its deleting the parent in the relationship, the view.
As for having to click Preview to uncheck, can there be an option when deleting to uncheck (not delete) the parent?
was (Author: van.halbert):
In this case, its deleting the parent in the relationship, not the child.
As for having to click Preview to uncheck, can there be an option when deleting to uncheck (not delete) the parent?
> deleting MATVIEW deletes the upper view model
> ---------------------------------------------
>
> Key: TEIIDDES-2860
> URL: https://issues.jboss.org/browse/TEIIDDES-2860
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling
> Affects Versions: 10.0.2
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Priority: Blocker
>
> When deleting MATVIEW it also wants to delete the view model from where it came. You should be able to delete the MATVIEW table and rerun the MATVIEW creation.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2860) deleting MATVIEW deletes the upper view model
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2860?page=com.atlassian.jira.plu... ]
Van Halbert commented on TEIIDDES-2860:
---------------------------------------
In this case, its deleting the parent in the relationship, not the child.
As for having to click Preview to uncheck, can there be an option when deleting to uncheck (not delete) the parent?
> deleting MATVIEW deletes the upper view model
> ---------------------------------------------
>
> Key: TEIIDDES-2860
> URL: https://issues.jboss.org/browse/TEIIDDES-2860
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling
> Affects Versions: 10.0.2
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Priority: Blocker
>
> When deleting MATVIEW it also wants to delete the view model from where it came. You should be able to delete the MATVIEW table and rerun the MATVIEW creation.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2860) deleting MATVIEW deletes the upper view model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2860?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2860:
----------------------------------------
[~vhalbert2] This behavior is consistent with the Eclipse refactor framework which relies on dependency checks. In this case it finds the dependency (view model). You can click *Preview...* button on the dialog and uncheck the view model.
> deleting MATVIEW deletes the upper view model
> ---------------------------------------------
>
> Key: TEIIDDES-2860
> URL: https://issues.jboss.org/browse/TEIIDDES-2860
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling
> Affects Versions: 10.0.2
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Priority: Blocker
>
> When deleting MATVIEW it also wants to delete the view model from where it came. You should be able to delete the MATVIEW table and rerun the MATVIEW creation.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2860) deleting MATVIEW deletes the upper view model
by Van Halbert (JIRA)
Van Halbert created TEIIDDES-2860:
-------------------------------------
Summary: deleting MATVIEW deletes the upper view model
Key: TEIIDDES-2860
URL: https://issues.jboss.org/browse/TEIIDDES-2860
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Affects Versions: 10.0.2
Reporter: Van Halbert
Priority: Blocker
When deleting MATVIEW it also wants to delete the view model from where it came. You should be able to delete the MATVIEW table and rerun the MATVIEW creation.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months