October 2017 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-3119) Save relationship model as another relationship model makes errors on view model

by Matej Kralik (JIRA)

Matej Kralik created TEIIDDES-3119: -------------------------------------- Summary: Save relationship model as another relationship model makes errors on view model Key: TEIIDDES-3119 URL: https://issues.jboss.org/browse/TEIIDDES-3119 Project: Teiid Designer Issue Type: Bug Affects Versions: 11.1 Reporter: Matej Kralik Attachments: SaveAsProject.zip, screenshot1.png, screenshot2.png, screenshot3.png I have source model and view model which uses source model for view tables. I want to save source model as new source model to another folder (screenshot1). I check that I don't want to modify view model (because original source model is still there) (screenshot2). This action causes errors in the view model (errors appear after Project->Clean). {code:java} Sql transformation in the model viewModel contains the unresolved reference file:/home/mkralik/workspace_testDesigner/SaveAsProject/partsupplier.xmi {code} The errors show to a model which doesn't exist because the saved new model has a different name (partsupplierSaveAs.xmi) but I uncheck modify view model so view model should still use original model. Next, the original source model was disappeared from transformation editor. (screenshot3)I must edit transformation (delete the last letter and add the letter back). After that, I am able to click on 'Save/Validate SQL ' button for fix error. After that error is disappeared. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3118) Error using option to generate xml from VDB

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3118?page=com.atlassian.jira.plu... ] Van Halbert updated TEIIDDES-3118: ---------------------------------- Attachment: designer.log > Error using option to generate xml from VDB > ------------------------------------------- > > Key: TEIIDDES-3118 > URL: https://issues.jboss.org/browse/TEIIDDES-3118 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 11.1.1 > Reporter: Van Halbert > Assignee: Barry LaFond > Attachments: designer.log, projectset.zip > > > Using the attached project set. When the view model is included when trying the option: Modeling ==> Generate VDB XML and error is encountered. > If I remove the view model and save the vdb, then try the generate option, it works. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3118) Error using option to generate xml from VDB

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3118?page=com.atlassian.jira.plu... ] Van Halbert reassigned TEIIDDES-3118: ------------------------------------- Assignee: Barry LaFond > Error using option to generate xml from VDB > ------------------------------------------- > > Key: TEIIDDES-3118 > URL: https://issues.jboss.org/browse/TEIIDDES-3118 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 11.1.1 > Reporter: Van Halbert > Assignee: Barry LaFond > Attachments: projectset.zip > > > Using the attached project set. When the view model is included when trying the option: Modeling ==> Generate VDB XML and error is encountered. > If I remove the view model and save the vdb, then try the generate option, it works. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3118) Error using option to generate xml from VDB

by Van Halbert (JIRA)

Van Halbert created TEIIDDES-3118: ------------------------------------- Summary: Error using option to generate xml from VDB Key: TEIIDDES-3118 URL: https://issues.jboss.org/browse/TEIIDDES-3118 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 11.1.1 Reporter: Van Halbert Attachments: projectset.zip Using the attached project set. When the view model is included when trying the option: Modeling ==> Generate VDB XML and error is encountered. If I remove the view model and save the vdb, then try the generate option, it works. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3117) Dynamic VDB is not generated properly for UDF function

by Matej Kralik (JIRA)

Matej Kralik created TEIIDDES-3117: -------------------------------------- Summary: Dynamic VDB is not generated properly for UDF function Key: TEIIDDES-3117 URL: https://issues.jboss.org/browse/TEIIDDES-3117 Project: Teiid Designer Issue Type: Bug Affects Versions: 11.1 Environment: Fedora 26 Reporter: Matej Kralik Priority: Critical I have a project with UDF function. I mark jar as deployable and it is on the server. Static VDB works fine, but when I generate dynamic VDB and want it to deploy on the server, the server shows me an error: {code:java} 15:50:26,282 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-4) MSC000001: Failed to start service jboss.deployment.unit."myUdfVdb-vdb.xml".DEPENDENCIES: org.jboss.msc.service.StartException in service jboss.deployment.unit."myUdfVdb-vdb.xml".DEPENDENCIES: JBAS018733: Failed to process phase DEPENDENCIES of deployment "myUdfVdb-vdb.xml" at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:184) [jboss-as-server-7.5.16.Final-redhat-1.jar:7.5.16.Final-redhat-1] at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:2064) [jboss-msc-1.1.7.SP1-redhat-1.jar:1.1.7.SP1-redhat-1] at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1987) [jboss-msc-1.1.7.SP1-redhat-1.jar:1.1.7.SP1-redhat-1] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_121] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_121] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_121] Caused by: org.jboss.as.server.deployment.DeploymentUnitProcessingException: TEIID50088 Failed to load module MyTestUdf-1.0-SNAPSHOT for UDF in VDB myUdfVdb.1:org.jboss.modules.ModuleNotFoundException: MyTestUdf-1.0-SNAPSHOT:main at org.teiid.jboss.VDBDependencyDeployer.deploy(VDBDependencyDeployer.java:85) at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:177) [jboss-as-server-7.5.16.Final-redhat-1.jar:7.5.16.Final-redhat-1] ... 5 more {code} According to EAP [documentation|https://access.redhat.com/documentation/en-US/JBoss_Enterpr...], a module is automatically created after jar file is deployed. Name of the module is *deployment.<runtime jar name>* however designer generated lib properties *only* with <jarFileName>. The name is wrong too because when designer deploying jar file, the runtime name is set with suffix (.jar f.e. runtime-name: "MyTestUdf-1.0-SNAPSHOT.jar") *Actual property* {code:java} <property name="lib" value="MyTestUdf-1.0-SNAPSHOT"/> {code} *Valid property* {code:java} <property name="lib" value="deployment.MyTestUdf-1.0-SNAPSHOT.jar"/> {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

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

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2880?page=com.atlassian.jira.plu... ] Matej Kralik updated TEIIDDES-2880: ----------------------------------- Attachment: UDFProject.zip > 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 > Assignee: Barry LaFond > Priority: Critical > Fix For: 11.1 > > Attachments: UDFProject.zip, 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.5.0#75005)

7 years, 2 months

1
0
0 / 0

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

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2880?page=com.atlassian.jira.plu... ] Matej Kralik reopened TEIIDDES-2880: ------------------------------------ Preview still doesn't work. I set jar file as deployable and it was deployed on the server. But preview doesn't work. In the server log: {code:java} TEIID31080 view.tab validation error: TEIID30068 The function 'udfConcatNull(hsqldbParts.PARTS.PART_NAME, hsqldbParts.PARTS.PART_WEIGHT)' is an unknown form. Check that the function name and number of arguments is correct. {code} I noticed that in the "Preview VDB XML Content" missing: +*<property name="lib" value="deployment.MyTestUdf-1.0-SNAPSHOT"/>*+ Preview VDB XML Content: {code:java} <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <vdb name="PREVIEW-1e69aa9a-ac0d-40ed-b83d-0a771287fecd" version="1"> <description>Importer VDB</description> <property name="UseConnectorMetadata" value="true" /> <model name="view" type="VIRTUAL" visible="true"> <metadata type="DDL"><![CDATA[ CREATE VIEW tab ( NAME_WEIGHT string(510) ) OPTIONS(UPDATABLE 'TRUE') 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="java:/hsqldbParts" /> <metadata type="DDL"><![CDATA[ CREATE FOREIGN TABLE PARTS ( PART_ID string(4) NOT NULL OPTIONS(NAMEINSOURCE '"PART_ID"', FIXED_LENGTH 'TRUE'), PART_NAME string(255) OPTIONS(NAMEINSOURCE '"PART_NAME"'), PART_COLOR string(30) OPTIONS(NAMEINSOURCE '"PART_COLOR"'), PART_WEIGHT string(255) OPTIONS(NAMEINSOURCE '"PART_WEIGHT"'), CONSTRAINT PK_PARTS PRIMARY KEY(PART_ID) OPTIONS(NAMEINSOURCE '"PK_PARTS"') ) OPTIONS(NAMEINSOURCE '"PARTSSUPPLIER"."PARTS"', UPDATABLE 'TRUE'); ]]></metadata> </model> </vdb> {code} > 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 > Assignee: Barry LaFond > Priority: Critical > Fix For: 11.1 > > 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.5.0#75005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3048) INSERT in source model with JDG as data source returns a Handling Results Sets problem dialog

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3048?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-3048. ------------------------------------ Assignee: Barry LaFond Resolution: Done master: https://github.com/Teiid-Designer/teiid-designer/commit/713b0ee1b8278af07... > INSERT in source model with JDG as data source returns a Handling Results Sets problem dialog > --------------------------------------------------------------------------------------------- > > Key: TEIIDDES-3048 > URL: https://issues.jboss.org/browse/TEIIDDES-3048 > Project: Teiid Designer > Issue Type: Bug > Environment: MacOS > JBDS 10.3.0 > JBDSIS 10.0.2 > JDV 6.3.4 > JDG 6.6.1 > Reporter: Cojan van Ballegooijen > Assignee: Barry LaFond > Fix For: 11.1.1 > > Attachments: Screen Shot 2017-03-02 at 00.48.51.png, Screen Shot 2017-03-02 at 00.56.07.png > > > When inserting rows from JBDS to a source model which is connected to a JDG data source it generate an Handling Result Sets problem dialog but the row is inserted into the cache. After clicking Ok. the next dialog hangs. You have to click Cancel to remove the dialog. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3048) INSERT in source model with JDG as data source returns a Handling Results Sets problem dialog

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3048?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-3048: --------------------------------------- I've reproduced it and found the following error in the JBDS .log: !ENTRY org.eclipse.core.jobs 4 2 2017-10-11 08:47:45.802 !MESSAGE An internal error occurred during: "Handle Result Sets". !STACK 0 java.lang.NullPointerException at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable.loopThroughResults(TeiidAdHocScriptRunnable.java:499) at org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable.handleSuccess(ResultSupportRunnable.java:419) at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable.access$7(TeiidAdHocScriptRunnable.java:1) at org.teiid.datatools.connectivity.ui.TeiidAdHocScriptRunnable$HandleSuccessJob.run(TeiidAdHocScriptRunnable.java:406) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:56) > INSERT in source model with JDG as data source returns a Handling Results Sets problem dialog > --------------------------------------------------------------------------------------------- > > Key: TEIIDDES-3048 > URL: https://issues.jboss.org/browse/TEIIDDES-3048 > Project: Teiid Designer > Issue Type: Bug > Environment: MacOS > JBDS 10.3.0 > JBDSIS 10.0.2 > JDV 6.3.4 > JDG 6.6.1 > Reporter: Cojan van Ballegooijen > Fix For: 11.1.1 > > Attachments: Screen Shot 2017-03-02 at 00.48.51.png, Screen Shot 2017-03-02 at 00.56.07.png > > > When inserting rows from JBDS to a source model which is connected to a JDG data source it generate an Handling Result Sets problem dialog but the row is inserted into the cache. After clicking Ok. the next dialog hangs. You have to click Cancel to remove the dialog. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3048) INSERT in source model with JDG as data source returns a Handling Results Sets problem dialog

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3048?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3048: ---------------------------------------- [~cvanball] and do you have a server log? > INSERT in source model with JDG as data source returns a Handling Results Sets problem dialog > --------------------------------------------------------------------------------------------- > > Key: TEIIDDES-3048 > URL: https://issues.jboss.org/browse/TEIIDDES-3048 > Project: Teiid Designer > Issue Type: Bug > Environment: MacOS > JBDS 10.3.0 > JBDSIS 10.0.2 > JDV 6.3.4 > JDG 6.6.1 > Reporter: Cojan van Ballegooijen > Fix For: 11.1.1 > > Attachments: Screen Shot 2017-03-02 at 00.48.51.png, Screen Shot 2017-03-02 at 00.56.07.png > > > When inserting rows from JBDS to a source model which is connected to a JDG data source it generate an Handling Result Sets problem dialog but the row is inserted into the cache. After clicking Ok. the next dialog hangs. You have to click Cancel to remove the dialog. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 2 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues October 2017