[JBoss JIRA] (TEIIDDES-2805) Error message not helpful when you try to execute VDB with no credentials defined for JDBC connection to server
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2805?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2805:
-----------------------------------
Description:
I defined new connection to server and forgot to set username and password for JDBC connection to server.
After I hit execute on VDB TD shows an error in Errors view:
"Could not deploy the following VDB for execution: FlatFileVdb1.vdb"
In the Stack Trace there is: "Error acquiring connection profile properties"
I looks like there are some problems with connection profile in the source model to me. This is not true, the VDB was deployed. Problem was that there were no credentials set for JDBC connection to teiid. It took me a while to figure it out.
After I enter username and password everything works.
It looks like this is a consequence of TEIIDDES-2435.
was:
I defined new connection to server and forgot to set username and password for JDBC connection to server.
After I hit execute TD shows an error in Errors view:
"Could not deploy the following VDB for execution: FlatFileVdb1.vdb"
In the Stack Trace there is: "Error acquiring connection profile properties"
I looks like there are some problems with connection profile in the source model to me. This is not true, the VDB was deployed. Problem was that there were no credentials set for JDBC connection to teiid. It took me a while to figure it out.
After I enter username and password everything works.
It looks like this is a consequence of TEIIDDES-2435.
> Error message not helpful when you try to execute VDB with no credentials defined for JDBC connection to server
> ---------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2805
> URL: https://issues.jboss.org/browse/TEIIDDES-2805
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0
> Reporter: Matus Makovy
> Attachments: Screen Shot 2016-03-07 at 14.01.30.png
>
>
> I defined new connection to server and forgot to set username and password for JDBC connection to server.
> After I hit execute on VDB TD shows an error in Errors view:
> "Could not deploy the following VDB for execution: FlatFileVdb1.vdb"
> In the Stack Trace there is: "Error acquiring connection profile properties"
> I looks like there are some problems with connection profile in the source model to me. This is not true, the VDB was deployed. Problem was that there were no credentials set for JDBC connection to teiid. It took me a while to figure it out.
> After I enter username and password everything works.
> It looks like this is a consequence of TEIIDDES-2435.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 9 months
[JBoss JIRA] (TEIIDDES-2805) Error message not helpful when you try to execute VDB with no credentials defined for JDBC connection to server
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2805?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2805:
-----------------------------------
Attachment: Screen Shot 2016-03-07 at 14.01.30.png
> Error message not helpful when you try to execute VDB with no credentials defined for JDBC connection to server
> ---------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2805
> URL: https://issues.jboss.org/browse/TEIIDDES-2805
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0
> Reporter: Matus Makovy
> Attachments: Screen Shot 2016-03-07 at 14.01.30.png
>
>
> I defined new connection to server and forgot to set username and password for JDBC connection to server.
> After I hit execute TD shows an error in Errors view:
> "Could not deploy the following VDB for execution: FlatFileVdb1.vdb"
> In the Stack Trace there is: "Error acquiring connection profile properties"
> I looks like there are some problems with connection profile in the source model to me. This is not true, the VDB was deployed. Problem was that there were no credentials set for JDBC connection to teiid. It took me a while to figure it out.
> After I enter username and password everything works.
> It looks like this is a consequence of TEIIDDES-2435.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 9 months
[JBoss JIRA] (TEIIDDES-2805) Error message not helpful when you try to execute VDB with no credentials defined for JDBC connection to server
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2805?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2805:
-----------------------------------
Summary: Error message not helpful when you try to execute VDB with no credentials defined for JDBC connection to server (was: Error message not helpful when you try to execute VDB with no credentials defined for JBDC connection to server)
> Error message not helpful when you try to execute VDB with no credentials defined for JDBC connection to server
> ---------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2805
> URL: https://issues.jboss.org/browse/TEIIDDES-2805
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0
> Reporter: Matus Makovy
>
> I defined new connection to server and forgot to set username and password for JDBC connection to server.
> After I hit execute TD shows an error in Errors view:
> "Could not deploy the following VDB for execution: FlatFileVdb1.vdb"
> In the Stack Trace there is: "Error acquiring connection profile properties"
> I looks like there are some problems with connection profile in the source model to me. This is not true, the VDB was deployed. Problem was that there were no credentials set for JDBC connection to teiid. It took me a while to figure it out.
> After I enter username and password everything works.
> It looks like this is a consequence of TEIIDDES-2435.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 9 months
[JBoss JIRA] (TEIIDDES-2805) Error message not helpful when you try to execute VDB with no credentials defined for JBDC connection to server
by Matus Makovy (JIRA)
Matus Makovy created TEIIDDES-2805:
--------------------------------------
Summary: Error message not helpful when you try to execute VDB with no credentials defined for JBDC connection to server
Key: TEIIDDES-2805
URL: https://issues.jboss.org/browse/TEIIDDES-2805
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 10.0
Reporter: Matus Makovy
I defined new connection to server and forgot to set username and password for JDBC connection to server.
After I hit execute TD shows an error in Errors view:
"Could not deploy the following VDB for execution: FlatFileVdb1.vdb"
In the Stack Trace there is: "Error acquiring connection profile properties"
I looks like there are some problems with connection profile in the source model to me. This is not true, the VDB was deployed. Problem was that there were no credentials set for JDBC connection to teiid. It took me a while to figure it out.
After I enter username and password everything works.
It looks like this is a consequence of TEIIDDES-2435.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 9 months
[JBoss JIRA] (TEIIDDES-2804) Resource adapter is not refreshed after I hit execute VDB
by Matus Makovy (JIRA)
Matus Makovy created TEIIDDES-2804:
--------------------------------------
Summary: Resource adapter is not refreshed after I hit execute VDB
Key: TEIIDDES-2804
URL: https://issues.jboss.org/browse/TEIIDDES-2804
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 10.0
Reporter: Matus Makovy
I have a VDB with source model that references a data source (resource adapter - flat file) with name that already exists on server. Let's say the name is "adapter1".
After I hit execute on VDB, it is deployed and I can submit a query. Submitting query reports an error that a flat file is not found. When I look to standalone.xml, the resource adapter "adapter1" is not changed and there is still the old one with wrong path to file. (both RA are of the same type - file)
It looks like when I execute a VDB, TD checks if there is data source (resource adapter) with name specified in VDB. If there is such data source it doesn't check other properties of the data source (RA) (at least it looks like that, maybe it checks the type of RA).
Or is this a server issue ?
This may seem like a crazy use case, but when you go through the "import from flat file" wizard twice (with different projects) and don't change the model names you end up with two projects with same source model names. Default source model name in the wizard is "SourceModel" and I think TD uses source model name as data source name for VDB.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 9 months
[JBoss JIRA] (TEIIDDES-2559) Load and saving non-workspace vdb fails to retain udf jars and other files
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2559?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2559:
-----------------------------------
Attachment: UdfVdb.vdb
> Load and saving non-workspace vdb fails to retain udf jars and other files
> --------------------------------------------------------------------------
>
> Key: TEIIDDES-2559
> URL: https://issues.jboss.org/browse/TEIIDDES-2559
> Project: Teiid Designer
> Issue Type: Bug
> Components: Patch Release, VDB & Execution
> Affects Versions: 9.0.2
> Reporter: Paul Richardson
> Assignee: Paul Richardson
> Fix For: 10.0.1, 9.2.1
>
> Attachments: UdfVdb.vdb
>
>
> Vdbs that contain either udf libaries or 'other files' are prone to losing these files when edited in Designer.
> This only occurs if the vdb is not part of a project, in that its constituent files are not part of the workspace.
> When such a vdb is opened by the editor, the archive is extracted to the staging area and the metadata loaded into the in-memory model. The vdb can be edited and saved.
> However, the save results in the udf jars and 'other files' not being included in the updated archive.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 9 months
[JBoss JIRA] (TEIIDDES-2559) Load and saving non-workspace vdb fails to retain udf jars and other files
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2559?page=com.atlassian.jira.plu... ]
Matus Makovy commented on TEIIDDES-2559:
----------------------------------------
I tried it on linux (Fedora 23) and I am not able to import the VDB. Maybe there is something wrong with my VDB (it was created on MAC with TD 10.0.0.Beta3), I'll attach it here.
> Load and saving non-workspace vdb fails to retain udf jars and other files
> --------------------------------------------------------------------------
>
> Key: TEIIDDES-2559
> URL: https://issues.jboss.org/browse/TEIIDDES-2559
> Project: Teiid Designer
> Issue Type: Bug
> Components: Patch Release, VDB & Execution
> Affects Versions: 9.0.2
> Reporter: Paul Richardson
> Assignee: Paul Richardson
> Fix For: 10.0.1, 9.2.1
>
> Attachments: UdfVdb.vdb
>
>
> Vdbs that contain either udf libaries or 'other files' are prone to losing these files when edited in Designer.
> This only occurs if the vdb is not part of a project, in that its constituent files are not part of the workspace.
> When such a vdb is opened by the editor, the archive is extracted to the staging area and the metadata loaded into the in-memory model. The vdb can be edited and saved.
> However, the save results in the udf jars and 'other files' not being included in the updated archive.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 9 months
[JBoss JIRA] (TEIIDDES-2559) Load and saving non-workspace vdb fails to retain udf jars and other files
by Paul Richardson (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2559?page=com.atlassian.jira.plu... ]
Paul Richardson edited comment on TEIIDDES-2559 at 3/7/16 5:50 AM:
-------------------------------------------------------------------
[~mmakovy]
* Have successfully imported the vdb using Import -> Filesystem.
(Update)
* Reproduced the NoSuchElementException reported in TEIIDDES-2803 and created a PR for a fix.
* Have edited the vdb, resaved and it retains the udf jar
Both on linux.
was (Author: phantomjinx):
[~mmakovy]
* Have successfully imported the vdb using Import -> Filesystem.
* Have edited the vdb, resaved and it retains the udf jar
Both on linux.
> Load and saving non-workspace vdb fails to retain udf jars and other files
> --------------------------------------------------------------------------
>
> Key: TEIIDDES-2559
> URL: https://issues.jboss.org/browse/TEIIDDES-2559
> Project: Teiid Designer
> Issue Type: Bug
> Components: Patch Release, VDB & Execution
> Affects Versions: 9.0.2
> Reporter: Paul Richardson
> Assignee: Paul Richardson
> Fix For: 10.0.1, 9.2.1
>
>
> Vdbs that contain either udf libaries or 'other files' are prone to losing these files when edited in Designer.
> This only occurs if the vdb is not part of a project, in that its constituent files are not part of the workspace.
> When such a vdb is opened by the editor, the archive is extracted to the staging area and the metadata loaded into the in-memory model. The vdb can be edited and saved.
> However, the save results in the udf jars and 'other files' not being included in the updated archive.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 9 months
[JBoss JIRA] (TEIIDDES-2803) VDB could not be validated after import from File system
by Paul Richardson (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2803?page=com.atlassian.jira.plu... ]
Paul Richardson reassigned TEIIDDES-2803:
-----------------------------------------
Assignee: Paul Richardson
> VDB could not be validated after import from File system
> --------------------------------------------------------
>
> Key: TEIIDDES-2803
> URL: https://issues.jboss.org/browse/TEIIDDES-2803
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0
> Environment: MAC OS X
> Reporter: Matus Makovy
> Assignee: Paul Richardson
> Attachments: UdfVDB1.vdb
>
>
> After I import attached VDB to new project (using Import -> File System) TD says that this VDB could not be validated. The VDB was created in the same TD (same version and environment).
> Error view:
> The Teiid Designer vdb file "UdfVDB1.vdb" could not be validated
> {code:java}
> java.util.NoSuchElementException
> at java.util.ArrayList$Itr.next(ArrayList.java:854)
> at java.util.Collections$UnmodifiableCollection$1.next(Collections.java:1042)
> at org.teiid.designer.vdb.VdbUtil.validateVdbModelsInWorkspace(VdbUtil.java:689)
> at org.teiid.designer.vdb.ui.build.VdbBuilder.refreshVdbFileMarkers(VdbBuilder.java:167)
> at org.teiid.designer.vdb.ui.build.VdbBuilder.buildInternal(VdbBuilder.java:137)
> at org.teiid.designer.core.builder.AbstractTeiidProjectBuilder.build(AbstractTeiidProjectBuilder.java:76)
> at org.eclipse.core.internal.events.BuildManager$2.run(BuildManager.java:734)
> at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
> at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:205)
> at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:245)
> at org.eclipse.core.internal.events.BuildManager$1.run(BuildManager.java:300)
> at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
> at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:303)
> at org.eclipse.core.internal.events.BuildManager.basicBuildLoop(BuildManager.java:359)
> at org.eclipse.core.internal.events.BuildManager.build(BuildManager.java:382)
> at org.eclipse.core.internal.events.AutoBuildJob.doBuild(AutoBuildJob.java:144)
> at org.eclipse.core.internal.events.AutoBuildJob.run(AutoBuildJob.java:235)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 9 months
[JBoss JIRA] (TEIIDDES-2803) VDB could not be validated after import from File system
by Paul Richardson (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2803?page=com.atlassian.jira.plu... ]
Paul Richardson commented on TEIIDDES-2803:
-------------------------------------------
PR: https://github.com/Teiid-Designer/teiid-designer/pull/547
> VDB could not be validated after import from File system
> --------------------------------------------------------
>
> Key: TEIIDDES-2803
> URL: https://issues.jboss.org/browse/TEIIDDES-2803
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0
> Environment: MAC OS X
> Reporter: Matus Makovy
> Assignee: Paul Richardson
> Attachments: UdfVDB1.vdb
>
>
> After I import attached VDB to new project (using Import -> File System) TD says that this VDB could not be validated. The VDB was created in the same TD (same version and environment).
> Error view:
> The Teiid Designer vdb file "UdfVDB1.vdb" could not be validated
> {code:java}
> java.util.NoSuchElementException
> at java.util.ArrayList$Itr.next(ArrayList.java:854)
> at java.util.Collections$UnmodifiableCollection$1.next(Collections.java:1042)
> at org.teiid.designer.vdb.VdbUtil.validateVdbModelsInWorkspace(VdbUtil.java:689)
> at org.teiid.designer.vdb.ui.build.VdbBuilder.refreshVdbFileMarkers(VdbBuilder.java:167)
> at org.teiid.designer.vdb.ui.build.VdbBuilder.buildInternal(VdbBuilder.java:137)
> at org.teiid.designer.core.builder.AbstractTeiidProjectBuilder.build(AbstractTeiidProjectBuilder.java:76)
> at org.eclipse.core.internal.events.BuildManager$2.run(BuildManager.java:734)
> at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
> at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:205)
> at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:245)
> at org.eclipse.core.internal.events.BuildManager$1.run(BuildManager.java:300)
> at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
> at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:303)
> at org.eclipse.core.internal.events.BuildManager.basicBuildLoop(BuildManager.java:359)
> at org.eclipse.core.internal.events.BuildManager.build(BuildManager.java:382)
> at org.eclipse.core.internal.events.AutoBuildJob.doBuild(AutoBuildJob.java:144)
> at org.eclipse.core.internal.events.AutoBuildJob.run(AutoBuildJob.java:235)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 9 months