March 2017 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-3066) Teiid Designer can't import Oracle Unique Key Constraints

by Steve Tran (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3066?page=com.atlassian.jira.plu... ] Steve Tran commented on TEIIDDES-3066: -------------------------------------- Uploaded an image from DBeaver vs JBDS. In the DBeaver image, it shows that the MER_CGT_PRICING has a Unique Constraint. In the JBDS image, there isn't any constraints listed under the MER_CGT_PRICING table. I know I highlighted the wrong table in the JBDS image, but look at the MER_CGT_PRICING table. It has nothing showing even though I expanded the node. > Teiid Designer can't import Oracle Unique Key Constraints > --------------------------------------------------------- > > Key: TEIIDDES-3066 > URL: https://issues.jboss.org/browse/TEIIDDES-3066 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 10.1 > Environment: Windows 7 > JBoss Developer Studio 10.3.0.GA > Teiid Designer 10.2.0.GA > Reporter: Steve Tran > Attachments: dbeaver.png, jbds.png > > > I can't import any unique key constraints from an Oracle table. > This might be an Eclipse issue because I can't see the UK in the Database Development perspective. If I use another Eclipse based tool such as DBeaver, it works just fine. > The same ojdbc6.jar was used with both tools. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3066) Teiid Designer can't import Oracle Unique Key Constraints

by Steve Tran (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3066?page=com.atlassian.jira.plu... ] Steve Tran updated TEIIDDES-3066: --------------------------------- Attachment: jbds.png dbeaver.png > Teiid Designer can't import Oracle Unique Key Constraints > --------------------------------------------------------- > > Key: TEIIDDES-3066 > URL: https://issues.jboss.org/browse/TEIIDDES-3066 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 10.1 > Environment: Windows 7 > JBoss Developer Studio 10.3.0.GA > Teiid Designer 10.2.0.GA > Reporter: Steve Tran > Attachments: dbeaver.png, jbds.png > > > I can't import any unique key constraints from an Oracle table. > This might be an Eclipse issue because I can't see the UK in the Database Development perspective. If I use another Eclipse based tool such as DBeaver, it works just fine. > The same ojdbc6.jar was used with both tools. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3056) UnsupportedOperationException clicking a source model function category in Function Builder

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3056?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-3056. ------------------------------------ Resolution: Done 11.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/d9fdf4c15c0e42342... > UnsupportedOperationException clicking a source model function category in Function Builder > ------------------------------------------------------------------------------------------- > > Key: TEIIDDES-3056 > URL: https://issues.jboss.org/browse/TEIIDDES-3056 > Project: Teiid Designer > Issue Type: Bug > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: 11.0.2 > > > looks like the FunctionTree.getFunctionsInCategory() is returning a Collections.emptySet() which FunctionLibrary.getFunctionForms() tries to do an *addAll()* > {code} > !ENTRY org.eclipse.ui 4 0 2017-03-07 13:27:01.647 > !MESSAGE Unhandled event loop exception > !STACK 0 > java.lang.UnsupportedOperationException > at java.util.AbstractCollection.add(AbstractCollection.java:262) > at java.util.AbstractCollection.addAll(AbstractCollection.java:344) > at org.teiid.query.function.FunctionLibrary.getFunctionForms(FunctionLibrary.java:150) > at org.teiid.query.ui.builder.model.FunctionEditorModel.setCategory(FunctionEditorModel.java:267) > at org.teiid.designer.transformation.ui.builder.expression.FunctionEditor.handleCategorySelected(FunctionEditor.java:261) > at org.teiid.designer.transformation.ui.builder.expression.FunctionEditor$1.widgetSelected(FunctionEditor.java:130) > at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:249) > at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) > at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5219) > at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1340) > at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4553) > at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4143) > at org.eclipse.jface.window.Window.runEventLoop(Window.java:818) > at org.eclipse.jface.window.Window.open(Window.java:794) > at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.showExpressionBuilder(SqlEditorPanel.java:1205) > at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanelWrapper.showExpressionBuilder(SqlEditorPanelWrapper.java:123) > at org.teiid.designer.transformation.ui.editors.sqleditor.actions.LaunchExpressionBuilder.doRun(LaunchExpressionBuilder.java:50) > {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3066) Teiid Designer can't import Oracle Unique Key Constraints

by Steve Tran (JIRA)

Steve Tran created TEIIDDES-3066: ------------------------------------ Summary: Teiid Designer can't import Oracle Unique Key Constraints Key: TEIIDDES-3066 URL: https://issues.jboss.org/browse/TEIIDDES-3066 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 10.1 Environment: Windows 7 JBoss Developer Studio 10.3.0.GA Teiid Designer 10.2.0.GA Reporter: Steve Tran I can't import any unique key constraints from an Oracle table. This might be an Eclipse issue because I can't see the UK in the Database Development perspective. If I use another Eclipse based tool such as DBeaver, it works just fine. The same ojdbc6.jar was used with both tools. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2795) Check if URL contains empty spaces

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2795?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2795: ---------------------------------------- per comments on TEIIDDES-2493, there's not much we can do to prevent spaces from being used and pushed to Teiid during data source creation. And because a user could connect to a Teiid Server on ANY OS system... there's no way clean way to ensure that the URL is correctly set anyway. > Check if URL contains empty spaces > ---------------------------------- > > Key: TEIIDDES-2795 > URL: https://issues.jboss.org/browse/TEIIDDES-2795 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 10.0.1 > Environment: Fedora 23 > Reporter: Matej Kralik > Fix For: 11.0.2 > > Attachments: Screenshot from 2016-02-25 15-08-51.png > > > When I tried to reproduce this bug ([TEIIDDES-2493|https://issues.jboss.org/browse/TEIIDDES-2493]) > I've found a way how set file whose path contains empty string. I set the file path as a URL and use import from remote flat file. Problem is same as ([TEIIDDES-2493|https://issues.jboss.org/browse/TEIIDDES-2493]). > When i created datasource, file path is written to the standalone.xml with empty space. > {code:java} > <config-property name="EndPoint"> > file:/home/mkralik/Downloads/folder with space/productdata_data.csv > </config-property> > {code} > I think user -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3055) non-integer VDB version missing validation warning

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3055?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-3055. ------------------------------------ Resolution: Done 11.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/2545601dd5b10daba... > non-integer VDB version missing validation warning > -------------------------------------------------- > > Key: TEIIDDES-3055 > URL: https://issues.jboss.org/browse/TEIIDDES-3055 > Project: Teiid Designer > Issue Type: Bug > Components: Validation, VDB & Execution > Affects Versions: 11.0.1 > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: 11.0.2 > > > The VDB validation logic is missing the logic to catch a number format exception when validating the VDB version string. Need to wrap the logic in a try/catch block in VdbUtil.validateVdbModelsInWorkspace() > Here's an example of a message: *The PartsSupplier VDB's version number 1.0.1 is not an integer and will not deploy to a Teiid runtime version less than 9.0. Your current default Teiid server version is: 8.12.5* -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3055) non-integer VDB version missing validation warning

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3055?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3055: ---------------------------------------- new message for validation WARNING: The testVDB VDB's version number 1.2.3 is not an integer and will not deploy to a Teiid runtime version less than 9.0. Your current default Teiid server version is: 8.12.5. > non-integer VDB version missing validation warning > -------------------------------------------------- > > Key: TEIIDDES-3055 > URL: https://issues.jboss.org/browse/TEIIDDES-3055 > Project: Teiid Designer > Issue Type: Bug > Components: Validation, VDB & Execution > Affects Versions: 11.0.1 > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: 11.0.2 > > > The VDB validation logic is missing the logic to catch a number format exception when validating the VDB version string. Need to wrap the logic in a try/catch block in VdbUtil.validateVdbModelsInWorkspace() > Here's an example of a message: *The PartsSupplier VDB's version number 1.0.1 is not an integer and will not deploy to a Teiid runtime version less than 9.0. Your current default Teiid server version is: 8.12.5* -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2965) translator override gets overwritten on synchronize all

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2965?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2965. ------------------------------------ Resolution: Done 11.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/3591852c9e20cae40... > translator override gets overwritten on synchronize all > ------------------------------------------------------- > > Key: TEIIDDES-2965 > URL: https://issues.jboss.org/browse/TEIIDDES-2965 > Project: Teiid Designer > Issue Type: Bug > Reporter: Omar Khan > Assignee: Barry LaFond > Fix For: 11.0.2 > > > The latest 10.1 seems to override the translators set in the VDB when synchronizing all or individual. > Please refer to this thread for more details: > https://developer.jboss.org/thread/272835 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2940) Moving model out of folder breaks imports

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2940?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2940: ----------------------------------- Priority: Critical (was: Major) > Moving model out of folder breaks imports > ----------------------------------------- > > Key: TEIIDDES-2940 > URL: https://issues.jboss.org/browse/TEIIDDES-2940 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.2 > Environment: Windows 7, Windows 8, Win 10 > Reporter: Matus Makovy > Priority: Critical > Fix For: 11.0.2 > > Attachments: Screen Shot 2016-10-18 at 14.45.03.png > > > After I move (for example) from folder directly into project folder the imports on view model (that depends on this model) break. > This happens only on win 7 and 8. > See attached screenshot -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2880) New preview not working with table that calls UDF function

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2880?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2880: ----------------------------------- Priority: Critical (was: Major) > New preview not working with table that calls UDF function > ----------------------------------------------------------- > > Key: TEIIDDES-2880 > URL: https://issues.jboss.org/browse/TEIIDDES-2880 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.1 > Environment: MAC > Reporter: Matus Makovy > Priority: Critical > Fix For: 11.0.2 > > Attachments: view.xmi > > > I have a view model with UDF function defined as procedure and a table that uses this UDF procedure. Transformation SQL looks like this: > {code:SQL} > SELECT > udfConcatNull(hsqldbParts.PARTS.PART_NAME, hsqldbParts.PARTS.PART_WEIGHT) AS NAME_WEIGHT > FROM > hsqldbParts.PARTS > {code} > When I hit Preview Data on that table, the dynamic VDB that is generated looks like this: > {code:xml} > <?xml version="1.0" encoding="UTF-8" standalone="yes"?> > <vdb name="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7" version="1"> > <description>Importer VDB</description> > <property name="UseConnectorMetadata" value="true" /> > <property name="deployment-name" value="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7-vdb.xml" /> > <model name="view" type="VIRTUAL" visible="true"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW tab ( > NAME_WEIGHT string > ) > AS > select udfConcatNull(hsqldbParts.PARTS.PART_NAME,hsqldbParts.PARTS.PART_WEIGHT) as NAME_WEIGHT from hsqldbParts.PARTS; > ]]></metadata> > </model> > <model name="hsqldbParts" type="PHYSICAL" visible="true"> > <source name="hsqldbParts" translator-name="oracle" connection-jndi-name="null" /> > <metadata type="DDL"><![CDATA[ > CREATE FOREIGN TABLE PARTS ( > PART_ID string(4) NOT NULL OPTIONS(NAMEINSOURCE '"PART_ID"', NATIVE_TYPE 'CHAR', FIXED_LENGTH 'TRUE'), > PART_NAME string(255) OPTIONS(NAMEINSOURCE '"PART_NAME"', NATIVE_TYPE 'VARCHAR2'), > PART_COLOR string(30) OPTIONS(NAMEINSOURCE '"PART_COLOR"', NATIVE_TYPE 'VARCHAR2'), > PART_WEIGHT string(255) OPTIONS(NAMEINSOURCE '"PART_WEIGHT"', NATIVE_TYPE 'VARCHAR2'), > CONSTRAINT PK_PARTS PRIMARY KEY(PART_ID) > ) OPTIONS(NAMEINSOURCE '"PARTSSUPPLIER"."PARTS"') > ]]></metadata> > </model> > </vdb> > {code} > If I see correctly, the UDF procedure is not in the dynamic VDB. > I know that the situation about dynamic VDBs and UDF functions in JAR files is complicated and I am not sure right now how this should be resolved. > But in my opinion the udf procedure should be in the dynamic VDB and there should be a warning that TD won't deploy the JAR to the server and if user wants to make a preview, the JAR should be deployed to the server manually. (If I remember correctly there is one when user is trying to generate dynamic VDB from static VDB with UDF function) > View model attached -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues March 2017