[JBoss JIRA] (TEIIDDES-3117) Dynamic VDB is not generated properly for UDF function
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3117?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-3117:
-----------------------------------
Release Notes Docs Status: Not Yet Documented
Documentation needs to get added to clarify how a user adds the custom user property for existing/deployed UDF jars as modules. (see previous comment)
> 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
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 11.1.1
>
>
> 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)
8 years, 6 months
[JBoss JIRA] (TEIIDDES-3123) Deploy XML VDB takes a long time.
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3123?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-3123:
-----------------------------------
Fix Version/s: 11.1.1
> Deploy XML VDB takes a long time.
> ---------------------------------
>
> Key: TEIIDDES-3123
> URL: https://issues.jboss.org/browse/TEIIDDES-3123
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 11.1
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 11.1.1
>
> Attachments: SourceColumnsProject.zip, screenshot.png
>
>
> When I generate XML VDB from VDB, the designer adds "<metadata type="NATIVE"/>" property to XML VDB. It causes performance issue because deploy XML VDB takes a long time.
> The time between deploy VDB (added to the repository) and set VDB to active:
> With "metadata native" property: 3 minutes.
> Without "metadata native" property: <1 seconds.
> For this example, I use XML VDB (in the project from attachments) which connects to MS SQL Server database.
> When I use another connection with a lot of tables and schemas, it takes very long (more than 30minutes).
> I think that it is not necessary to add this property by default to all XML VDBs only if it is necessary for specific VDB. For users who want to use this property will be good to add a new checkbox to the 'options' tab in the 'Save as VDB XML file' wizard. (screenshot)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 6 months
[JBoss JIRA] (TEIIDDES-3123) Deploy XML VDB takes a long time.
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3123?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-3123.
------------------------------------
Resolution: Done
master: https://github.com/Teiid-Designer/teiid-designer/commit/12e90ee0cba1438ee...
> Deploy XML VDB takes a long time.
> ---------------------------------
>
> Key: TEIIDDES-3123
> URL: https://issues.jboss.org/browse/TEIIDDES-3123
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 11.1
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 11.1.1
>
> Attachments: SourceColumnsProject.zip, screenshot.png
>
>
> When I generate XML VDB from VDB, the designer adds "<metadata type="NATIVE"/>" property to XML VDB. It causes performance issue because deploy XML VDB takes a long time.
> The time between deploy VDB (added to the repository) and set VDB to active:
> With "metadata native" property: 3 minutes.
> Without "metadata native" property: <1 seconds.
> For this example, I use XML VDB (in the project from attachments) which connects to MS SQL Server database.
> When I use another connection with a lot of tables and schemas, it takes very long (more than 30minutes).
> I think that it is not necessary to add this property by default to all XML VDBs only if it is necessary for specific VDB. For users who want to use this property will be good to add a new checkbox to the 'options' tab in the 'Save as VDB XML file' wizard. (screenshot)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 6 months
[JBoss JIRA] (TEIIDDES-3123) Deploy XML VDB takes a long time.
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3123?page=com.atlassian.jira.plu... ]
Van Halbert reassigned TEIIDDES-3123:
-------------------------------------
Assignee: Barry LaFond
> Deploy XML VDB takes a long time.
> ---------------------------------
>
> Key: TEIIDDES-3123
> URL: https://issues.jboss.org/browse/TEIIDDES-3123
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 11.1
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Critical
> Attachments: SourceColumnsProject.zip, screenshot.png
>
>
> When I generate XML VDB from VDB, the designer adds "<metadata type="NATIVE"/>" property to XML VDB. It causes performance issue because deploy XML VDB takes a long time.
> The time between deploy VDB (added to the repository) and set VDB to active:
> With "metadata native" property: 3 minutes.
> Without "metadata native" property: <1 seconds.
> For this example, I use XML VDB (in the project from attachments) which connects to MS SQL Server database.
> When I use another connection with a lot of tables and schemas, it takes very long (more than 30minutes).
> I think that it is not necessary to add this property by default to all XML VDBs only if it is necessary for specific VDB. For users who want to use this property will be good to add a new checkbox to the 'options' tab in the 'Save as VDB XML file' wizard. (screenshot)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 6 months
[JBoss JIRA] (TEIIDDES-3123) Deploy XML VDB takes a long time.
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3123?page=com.atlassian.jira.plu... ]
Van Halbert edited comment on TEIIDDES-3123 at 10/19/17 12:53 PM:
------------------------------------------------------------------
The native only required for when the translator is infinispan-hotrod. This doesn't need to be used otherwise.
I tried the latest Teiid Designer beta2 build [1] and this DOES appear to be occurring. If you generate the xml, its there. However, the internal vdb.xml does not have it.
here's part of what i generated
{code}
<model name="Test">
<source connection-jndi-name="Test" name="Test" translator-name="jdbc"/>
<metadata type="DDL"><![CDATA[
CREATE FOREIGN TABLE TTable (
newColumn_1 string(4000)
) OPTIONS(UPDATABLE 'TRUE');
]]></metadata>
<metadata type="NATIVE"/>
</model>
{code}
[1] http://download.jboss.org/jbosstools/oxygen/staging/builds/integration-st...
was (Author: rhn-engineering-vhalbert):
The native only required for when the translator is infinispan-hotrod. This doesn't need to be used otherwise.
I tried the latest Teiid Designer beta2 build [1] and this DOES appear to be occurring. If you generate the xml, its there. However, the internal vdb.xml does not have it.
[1] http://download.jboss.org/jbosstools/oxygen/staging/builds/integration-st...
> Deploy XML VDB takes a long time.
> ---------------------------------
>
> Key: TEIIDDES-3123
> URL: https://issues.jboss.org/browse/TEIIDDES-3123
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 11.1
> Reporter: Matej Kralik
> Priority: Critical
> Attachments: SourceColumnsProject.zip, screenshot.png
>
>
> When I generate XML VDB from VDB, the designer adds "<metadata type="NATIVE"/>" property to XML VDB. It causes performance issue because deploy XML VDB takes a long time.
> The time between deploy VDB (added to the repository) and set VDB to active:
> With "metadata native" property: 3 minutes.
> Without "metadata native" property: <1 seconds.
> For this example, I use XML VDB (in the project from attachments) which connects to MS SQL Server database.
> When I use another connection with a lot of tables and schemas, it takes very long (more than 30minutes).
> I think that it is not necessary to add this property by default to all XML VDBs only if it is necessary for specific VDB. For users who want to use this property will be good to add a new checkbox to the 'options' tab in the 'Save as VDB XML file' wizard. (screenshot)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 6 months
[JBoss JIRA] (TEIIDDES-3123) Deploy XML VDB takes a long time.
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3123?page=com.atlassian.jira.plu... ]
Van Halbert edited comment on TEIIDDES-3123 at 10/19/17 12:52 PM:
------------------------------------------------------------------
The native only required for when the translator is infinispan-hotrod. This doesn't need to be used otherwise.
I tried the latest Teiid Designer beta2 build [1] and this DOES appear to be occurring. If you generate the xml, its there. However, the internal vdb.xml does not have it.
[1] http://download.jboss.org/jbosstools/oxygen/staging/builds/integration-st...
was (Author: rhn-engineering-vhalbert):
The native only required for when the translator is infinispan-hotrod. This doesn't need to be used otherwise.
I tried the latest Teiid Designer beta2 build [1] and this DOES appear to be occurring.
[1] http://download.jboss.org/jbosstools/oxygen/staging/builds/integration-st...
> Deploy XML VDB takes a long time.
> ---------------------------------
>
> Key: TEIIDDES-3123
> URL: https://issues.jboss.org/browse/TEIIDDES-3123
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 11.1
> Reporter: Matej Kralik
> Priority: Critical
> Attachments: SourceColumnsProject.zip, screenshot.png
>
>
> When I generate XML VDB from VDB, the designer adds "<metadata type="NATIVE"/>" property to XML VDB. It causes performance issue because deploy XML VDB takes a long time.
> The time between deploy VDB (added to the repository) and set VDB to active:
> With "metadata native" property: 3 minutes.
> Without "metadata native" property: <1 seconds.
> For this example, I use XML VDB (in the project from attachments) which connects to MS SQL Server database.
> When I use another connection with a lot of tables and schemas, it takes very long (more than 30minutes).
> I think that it is not necessary to add this property by default to all XML VDBs only if it is necessary for specific VDB. For users who want to use this property will be good to add a new checkbox to the 'options' tab in the 'Save as VDB XML file' wizard. (screenshot)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 6 months
[JBoss JIRA] (TEIIDDES-3123) Deploy XML VDB takes a long time.
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3123?page=com.atlassian.jira.plu... ]
Van Halbert edited comment on TEIIDDES-3123 at 10/19/17 12:51 PM:
------------------------------------------------------------------
The native only required for when the translator is infinispan-hotrod. This doesn't need to be used otherwise.
I tried the latest Teiid Designer beta2 build [1] and this DOES appear to be occurring.
[1] http://download.jboss.org/jbosstools/oxygen/staging/builds/integration-st...
was (Author: rhn-engineering-vhalbert):
The native only required for when the translator is infinispan-hotrod. This doesn't need to be used otherwise.
I tried the latest Teiid Designer beta2 build [1] and this doesn't appear to be occurring.
[1] http://download.jboss.org/jbosstools/oxygen/staging/builds/integration-st...
> Deploy XML VDB takes a long time.
> ---------------------------------
>
> Key: TEIIDDES-3123
> URL: https://issues.jboss.org/browse/TEIIDDES-3123
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 11.1
> Reporter: Matej Kralik
> Priority: Critical
> Attachments: SourceColumnsProject.zip, screenshot.png
>
>
> When I generate XML VDB from VDB, the designer adds "<metadata type="NATIVE"/>" property to XML VDB. It causes performance issue because deploy XML VDB takes a long time.
> The time between deploy VDB (added to the repository) and set VDB to active:
> With "metadata native" property: 3 minutes.
> Without "metadata native" property: <1 seconds.
> For this example, I use XML VDB (in the project from attachments) which connects to MS SQL Server database.
> When I use another connection with a lot of tables and schemas, it takes very long (more than 30minutes).
> I think that it is not necessary to add this property by default to all XML VDBs only if it is necessary for specific VDB. For users who want to use this property will be good to add a new checkbox to the 'options' tab in the 'Save as VDB XML file' wizard. (screenshot)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 6 months
[JBoss JIRA] (TEIIDDES-3123) Deploy XML VDB takes a long time.
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3123?page=com.atlassian.jira.plu... ]
Van Halbert edited comment on TEIIDDES-3123 at 10/19/17 12:50 PM:
------------------------------------------------------------------
The native only required for when the translator is infinispan-hotrod. This doesn't need to be used otherwise.
I tried the latest Teiid Designer beta2 build [1] and this doesn't appear to be occurring.
[1] http://download.jboss.org/jbosstools/oxygen/staging/builds/integration-st...
was (Author: rhn-engineering-vhalbert):
The native only required for when the translator is infinispan-hotrod. This doesn't need to be used otherwise.
I tried the latest Teiid Designer beta2 build and this doesn't appear to be occurring.
> Deploy XML VDB takes a long time.
> ---------------------------------
>
> Key: TEIIDDES-3123
> URL: https://issues.jboss.org/browse/TEIIDDES-3123
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 11.1
> Reporter: Matej Kralik
> Priority: Critical
> Attachments: SourceColumnsProject.zip, screenshot.png
>
>
> When I generate XML VDB from VDB, the designer adds "<metadata type="NATIVE"/>" property to XML VDB. It causes performance issue because deploy XML VDB takes a long time.
> The time between deploy VDB (added to the repository) and set VDB to active:
> With "metadata native" property: 3 minutes.
> Without "metadata native" property: <1 seconds.
> For this example, I use XML VDB (in the project from attachments) which connects to MS SQL Server database.
> When I use another connection with a lot of tables and schemas, it takes very long (more than 30minutes).
> I think that it is not necessary to add this property by default to all XML VDBs only if it is necessary for specific VDB. For users who want to use this property will be good to add a new checkbox to the 'options' tab in the 'Save as VDB XML file' wizard. (screenshot)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 6 months