[JBoss JIRA] (TEIID-3708) Undeployable dynamic VDB at start-up time removes all previously deployed artifacts
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3708?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-3708:
-------------------------------
Priority: Blocker (was: Major)
> Undeployable dynamic VDB at start-up time removes all previously deployed artifacts
> -----------------------------------------------------------------------------------
>
> Key: TEIID-3708
> URL: https://issues.jboss.org/browse/TEIID-3708
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 8.7.1.6_2
> Reporter: Juraj Duráni
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 8.12.x
>
>
> If standalone/deployments directory contains undeployable dynamic VDB at start-up (reload) time all deployments previously deployed via mangement CLI are undeployed.
> Log:
> {code:text}
> 13:42:48,993 INFO [org.jboss.as] (MSC service thread 1-4) JBAS015899: JBoss Red Hat JBoss Data Virtualization 6.2.0 (AS 7.5.3.Final-redhat-2) starting
> ...
> ...
> ...
> 13:42:53,258 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) JBAS014612: Operation ("deploy") failed - address: ([("deployment" => "oo-vdb.xml")]) - failure description: {"JBAS014671: Failed services" => {"jboss.teiid.vdb.odata.1" => "org.jboss.msc.service.StartException in service jboss.teiid.vdb.odata.1: org.teiid.deployers.VirtualDatabaseException: TEIID40093 Model Source specified with no source information in VDB odata.1
> Caused by: org.teiid.deployers.VirtualDatabaseException: TEIID40093 Model Source specified with no source information in VDB odata.1"}}
> 13:42:53,300 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS015859: Deployed "QT_MySql55_Push.vdb" (runtime-name : "QT_MySql55_Push.vdb")
> 13:42:53,301 INFO [org.jboss.as.server] (ServerService Thread Pool -- 30) JBAS015859: Deployed "oo-vdb.xml" (runtime-name : "oo-vdb.xml")
> 13:42:53,302 INFO [org.jboss.as.server] (ServerService Thread Pool -- 52) JBAS015859: Deployed "modeshape-cmis.war" (runtime-name : "modeshape-cmis.war")
> 13:42:53,302 INFO [org.jboss.as.server] (ServerService Thread Pool -- 30) JBAS015859: Deployed "integration-platform-console.war" (runtime-name : "integration-platform-console.war")
> 13:42:53,302 INFO [org.jboss.as.server] (ServerService Thread Pool -- 52) JBAS015859: Deployed "modeshape-webdav.war" (runtime-name : "modeshape-webdav.war")
> 13:42:53,302 INFO [org.jboss.as.server] (ServerService Thread Pool -- 52) JBAS015859: Deployed "modeshape-rest.war" (runtime-name : "modeshape-rest.war")
> 13:42:53,303 INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report
> JBAS014777: Services which failed to start: service jboss.teiid.vdb.odata.1: org.jboss.msc.service.StartException in service jboss.teiid.vdb.odata.1: org.teiid.deployers.VirtualDatabaseException: TEIID40093 Model Source specified with no source information in VDB odata.1
> 13:42:53,330 INFO [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on http://127.0.0.1:9990/management
> 13:42:53,330 INFO [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990
> 13:42:53,331 ERROR [org.jboss.as] (Controller Boot Thread) JBAS015875: JBoss Red Hat JBoss Data Virtualization 6.2.0 (AS 7.5.3.Final-redhat-2) started (with errors) in 4336ms - Started 619 of 664 services (1 services failed or missing dependencies, 100 services are lazy, passive or on-demand)
> 13:42:53,529 INFO [org.jboss.web] (ServerService Thread Pool -- 26) JBAS018224: Unregister web context: /modeshape-rest
> 13:42:53,538 INFO [org.jboss.web] (ServerService Thread Pool -- 19) JBAS018224: Unregister web context: /modeshape-webdav
> 13:42:53,540 INFO [org.jboss.web] (ServerService Thread Pool -- 18) JBAS018224: Unregister web context: /modeshape-cmis
> 13:42:53,544 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50026 VDB "QT_MySql55_Push.1[Source{Source=Source, mysql5, MySQL55_PushDS}, XQTRecursiveSchema{}, BQT2{}, SP{SP=SP, mysql5, MySQL55_PushDS}, VirtProcs{}, XQTSchema{}, XQTRecursiveDoc{}, XQT{}, BQT1{}, VQT{}, XQTNestedDoc{}, XQTDoc{}]" undeployed.
> 13:42:53,569 INFO [javax.enterprise.resource.webservices.jaxws.servlet.http] (ServerService Thread Pool -- 18) WSSERVLET15: JAX-WS servlet destroyed
> 13:42:53,572 INFO [javax.enterprise.resource.webservices.jaxws.server.http] (ServerService Thread Pool -- 18) WSSERVLET13: JAX-WS context listener destroyed
> 13:42:53,578 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015877: Stopped deployment modeshape-rest.war (runtime-name: modeshape-rest.war) in 50ms
> 13:42:53,580 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015877: Stopped deployment oo-vdb.xml (runtime-name: oo-vdb.xml) in 43ms
> 13:42:53,582 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015877: Stopped deployment modeshape-webdav.war (runtime-name: modeshape-webdav.war) in 45ms
> 13:42:53,583 INFO [org.jboss.as.server.deployment] (MSC service thread 1-5) JBAS015877: Stopped deployment QT_MySql55_Push.vdb (runtime-name: QT_MySql55_Push.vdb) in 46ms
> 13:42:53,607 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015877: Stopped deployment modeshape-cmis.war (runtime-name: modeshape-cmis.war) in 70ms
> 13:42:53,647 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS015858: Undeployed "oo-vdb.xml" (runtime-name: "oo-vdb.xml")
> 13:42:53,648 INFO [org.jboss.as.repository] (DeploymentScanner-threads - 2) JBAS014901: Content removed from location /home/jdurani/redhat/data-virtualization/dv_6.2.0/untouched_tmp3/standalone/data/content/45/9c1839c446e700d7f0b713f5f949b068fbeb24/content
> 13:42:53,648 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS015858: Undeployed "QT_MySql55_Push.vdb" (runtime-name: "QT_MySql55_Push.vdb")
> 13:42:53,649 INFO [org.jboss.as.repository] (DeploymentScanner-threads - 2) JBAS014901: Content removed from location /home/jdurani/redhat/data-virtualization/dv_6.2.0/untouched_tmp3/standalone/data/content/a3/b37a584c66a65d33bf194ffa9fc0e93c83b9ca/content
> 13:42:53,649 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS015858: Undeployed "modeshape-webdav.war" (runtime-name: "modeshape-webdav.war")
> 13:42:53,651 INFO [org.jboss.as.repository] (DeploymentScanner-threads - 2) JBAS014901: Content removed from location /home/jdurani/redhat/data-virtualization/dv_6.2.0/untouched_tmp3/standalone/data/content/f2/00c83231bcb7a63276d49ac9e01bcbbde30424/content
> 13:42:53,651 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS015858: Undeployed "modeshape-cmis.war" (runtime-name: "modeshape-cmis.war")
> 13:42:53,652 INFO [org.jboss.as.repository] (DeploymentScanner-threads - 2) JBAS014901: Content removed from location /home/jdurani/redhat/data-virtualization/dv_6.2.0/untouched_tmp3/standalone/data/content/2b/4d8dbcf74227d075e54215d1f330da494a4b22/content
> 13:42:53,657 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS015858: Undeployed "modeshape-rest.war" (runtime-name: "modeshape-rest.war")
> 13:42:53,658 INFO [org.jboss.as.controller] (DeploymentScanner-threads - 2) JBAS014774: Service status report
> JBAS014777: Services which failed to start: service jboss.teiid.vdb.odata.1
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month
[JBoss JIRA] (TEIID-3827) multi-source view insert throwing TEIID30492 error
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3827?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3827:
---------------------------------------
The only explianition for the original issue is that designer is allowing the multi-source property to be set on virtual models.
> multi-source view insert throwing TEIID30492 error
> --------------------------------------------------
>
> Key: TEIID-3827
> URL: https://issues.jboss.org/browse/TEIID-3827
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.3
> Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> MySQL 5.7 and Postgres 9.4
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
> Attachments: joined_vdb.vdb
>
>
> I'm trying to POC this multi-source INSERT. I have a MySQL DB and Postgres DB on my local machine. Added the drivers, datasource, and created a VBL with 1:1 mapping to my test tables. I created an EBL that is a join of my two tables. Both VBLs and EBL are set to support updates. I'm trying to work through this error.
> {quote}
> insert into "Joined_EBL"."joined2"(idtestm, randomstring, idtestp, randomint) values(0, 'randomstring', 0, 12345)
> org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryValidatorException: Remote TEIID30492 A multi-source table, Joined_EBL.joined2, cannot be used in an INSERT with query expression or SELECT INTO statement.
> {quote}
> I updated my INSERT tab on the EBL transformation page with the following.
> {code}FOR EACH ROW
> BEGIN ATOMIC
> INSERT INTO Postgres_VBL.testp (Postgres_VBL.testp.idtestp, Postgres_VBL.testp.randomint) VALUES (0, "NEW".randomint);
> INSERT INTO MySQL_VBL.testm (MySQL_VBL.testm.idtestm, MySQL_VBL.testm.randomstring) VALUES (0, "NEW".randomstring);
> END
> {code}
> Postgres table
> {code}
> CREATE TABLE testp
> (
> idtestp integer NOT NULL,
> randomint integer,
> CONSTRAINT pk_id PRIMARY KEY (idtestp)
> )
> WITH (
> OIDS=FALSE
> );
> ALTER TABLE testp
> OWNER TO postgres;
> {code}
> MySQL table
> {code}
> CREATE TABLE `testm` (
> `idtestm` int(11) NOT NULL AUTO_INCREMENT,
> `randomstring` varchar(45) DEFAULT NULL,
> PRIMARY KEY (`idtestm`),
> UNIQUE KEY `idtestm_UNIQUE` (`idtestm`)
> ) ENGINE=InnoDB DEFAULT CHARSET=tis620;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month
[JBoss JIRA] (TEIID-3827) multi-source view insert throwing TEIID30492 error
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3827?page=com.atlassian.jira.plugin... ]
Steven Hawkins edited comment on TEIID-3827 at 11/18/15 8:42 AM:
-----------------------------------------------------------------
The only explanation for the original issue is that designer is allowing the multi-source property to be set on virtual models.
was (Author: shawkins):
The only explianition for the original issue is that designer is allowing the multi-source property to be set on virtual models.
> multi-source view insert throwing TEIID30492 error
> --------------------------------------------------
>
> Key: TEIID-3827
> URL: https://issues.jboss.org/browse/TEIID-3827
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.3
> Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> MySQL 5.7 and Postgres 9.4
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
> Attachments: joined_vdb.vdb
>
>
> I'm trying to POC this multi-source INSERT. I have a MySQL DB and Postgres DB on my local machine. Added the drivers, datasource, and created a VBL with 1:1 mapping to my test tables. I created an EBL that is a join of my two tables. Both VBLs and EBL are set to support updates. I'm trying to work through this error.
> {quote}
> insert into "Joined_EBL"."joined2"(idtestm, randomstring, idtestp, randomint) values(0, 'randomstring', 0, 12345)
> org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryValidatorException: Remote TEIID30492 A multi-source table, Joined_EBL.joined2, cannot be used in an INSERT with query expression or SELECT INTO statement.
> {quote}
> I updated my INSERT tab on the EBL transformation page with the following.
> {code}FOR EACH ROW
> BEGIN ATOMIC
> INSERT INTO Postgres_VBL.testp (Postgres_VBL.testp.idtestp, Postgres_VBL.testp.randomint) VALUES (0, "NEW".randomint);
> INSERT INTO MySQL_VBL.testm (MySQL_VBL.testm.idtestm, MySQL_VBL.testm.randomstring) VALUES (0, "NEW".randomstring);
> END
> {code}
> Postgres table
> {code}
> CREATE TABLE testp
> (
> idtestp integer NOT NULL,
> randomint integer,
> CONSTRAINT pk_id PRIMARY KEY (idtestp)
> )
> WITH (
> OIDS=FALSE
> );
> ALTER TABLE testp
> OWNER TO postgres;
> {code}
> MySQL table
> {code}
> CREATE TABLE `testm` (
> `idtestm` int(11) NOT NULL AUTO_INCREMENT,
> `randomstring` varchar(45) DEFAULT NULL,
> PRIMARY KEY (`idtestm`),
> UNIQUE KEY `idtestm_UNIQUE` (`idtestm`)
> ) ENGINE=InnoDB DEFAULT CHARSET=tis620;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month
[JBoss JIRA] (TEIID-3827) multi-source view insert throwing TEIID30492 error
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3827?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-3827:
------------------------------------
Steve,
Any suggestions that might have helped eliminate your misunderstanding would be appreciated.
> multi-source view insert throwing TEIID30492 error
> --------------------------------------------------
>
> Key: TEIID-3827
> URL: https://issues.jboss.org/browse/TEIID-3827
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.3
> Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> MySQL 5.7 and Postgres 9.4
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
> Attachments: joined_vdb.vdb
>
>
> I'm trying to POC this multi-source INSERT. I have a MySQL DB and Postgres DB on my local machine. Added the drivers, datasource, and created a VBL with 1:1 mapping to my test tables. I created an EBL that is a join of my two tables. Both VBLs and EBL are set to support updates. I'm trying to work through this error.
> {quote}
> insert into "Joined_EBL"."joined2"(idtestm, randomstring, idtestp, randomint) values(0, 'randomstring', 0, 12345)
> org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryValidatorException: Remote TEIID30492 A multi-source table, Joined_EBL.joined2, cannot be used in an INSERT with query expression or SELECT INTO statement.
> {quote}
> I updated my INSERT tab on the EBL transformation page with the following.
> {code}FOR EACH ROW
> BEGIN ATOMIC
> INSERT INTO Postgres_VBL.testp (Postgres_VBL.testp.idtestp, Postgres_VBL.testp.randomint) VALUES (0, "NEW".randomint);
> INSERT INTO MySQL_VBL.testm (MySQL_VBL.testm.idtestm, MySQL_VBL.testm.randomstring) VALUES (0, "NEW".randomstring);
> END
> {code}
> Postgres table
> {code}
> CREATE TABLE testp
> (
> idtestp integer NOT NULL,
> randomint integer,
> CONSTRAINT pk_id PRIMARY KEY (idtestp)
> )
> WITH (
> OIDS=FALSE
> );
> ALTER TABLE testp
> OWNER TO postgres;
> {code}
> MySQL table
> {code}
> CREATE TABLE `testm` (
> `idtestm` int(11) NOT NULL AUTO_INCREMENT,
> `randomstring` varchar(45) DEFAULT NULL,
> PRIMARY KEY (`idtestm`),
> UNIQUE KEY `idtestm_UNIQUE` (`idtestm`)
> ) ENGINE=InnoDB DEFAULT CHARSET=tis620;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month
[JBoss JIRA] (TEIID-3828) Build failed due to artifact 'org.jboss.oreva:odata-core:jar:0.8.11-SNAPSHOT' can not be resolved
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3828?page=com.atlassian.jira.plugin... ]
Steven Hawkins reassigned TEIID-3828:
-------------------------------------
Assignee: Ramesh Reddy (was: Steven Hawkins)
Ramesh is going to be produce a new oreva build for 8.13.
> Build failed due to artifact 'org.jboss.oreva:odata-core:jar:0.8.11-SNAPSHOT' can not be resolved
> -------------------------------------------------------------------------------------------------
>
> Key: TEIID-3828
> URL: https://issues.jboss.org/browse/TEIID-3828
> Project: Teiid
> Issue Type: Bug
> Components: Build/Kits
> Affects Versions: 8.13
> Reporter: Kylin Soong
> Assignee: Ramesh Reddy
> Fix For: 8.13
>
>
> translator-odata use a SNAPSHOT dependency
> {code}
> <dependency>
> <groupId>org.jboss.oreva</groupId>
> <artifactId>odata-core</artifactId>
> </dependency>
> {code}
> which can not be resolved, with the folllowing erros:
> {code}
> [ERROR] Failed to execute goal on project translator-odata: Could not resolve dependencies for project org.jboss.teiid.connectors:translator-odata:bundle:8.13.0.Alpha1-SNAPSHOT: The following artifacts could not be resolved: org.jboss.oreva:odata-core:jar:0.8.11-SNAPSHOT, org.jboss.oreva:common:jar:0.8.11-SNAPSHOT: Failure to find org.jboss.oreva:odata-core:jar:0.8.11-SNAPSHOT in ...
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month
[JBoss JIRA] (TEIID-3830) Install script executed failed due to threads subsystem be removed
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3830?page=com.atlassian.jira.plugin... ]
Kylin Soong updated TEIID-3830:
-------------------------------
Issue Type: Bug (was: Component Upgrade)
Priority: Blocker (was: Major)
> Install script executed failed due to threads subsystem be removed
> ------------------------------------------------------------------
>
> Key: TEIID-3830
> URL: https://issues.jboss.org/browse/TEIID-3830
> Project: Teiid
> Issue Type: Bug
> Components: Build/Kits
> Affects Versions: 8.13
> Reporter: Kylin Soong
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 8.13
>
>
> According to WFLY-462, the central thread pool configuration(threads subsystem) already be removed since 9.0.0.CR2, these two scripts:
> * teiid-standalone-mode-install.cli
> * teiid-domain-mode-install.cli
> be affected, specifically the following lines cli can not executed:
> {code}
> /subsystem=threads/unbounded-queue-thread-pool=teiid-async:add(max-threads=4)
> /subsystem=teiid:add(async-thread-pool=teiid-async, resultset-cache-infinispan-container=teiid-cache, preparedplan-cache-infinispan-container=teiid-cache, policy-decider-module=org.jboss.teiid)
> {code}
> The corresponding error looks
> {code}
> Failed to get the list of the operation properties: "WFLYCTL0030: No resource definition is registered for address [
> ("subsystem" => "threads"),
> ("unbounded-queue-thread-pool" => "teiid-async")
> ]"
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month
[JBoss JIRA] (TEIID-3830) Install script executed failed due to threads subsystem be removed
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3830?page=com.atlassian.jira.plugin... ]
Kylin Soong updated TEIID-3830:
-------------------------------
Description:
According to WFLY-462, the central thread pool configuration(threads subsystem) already be removed since 9.0.0.CR2, these two scripts:
* teiid-standalone-mode-install.cli
* teiid-domain-mode-install.cli
be affected, specifically the following lines cli can not executed:
{code}
/subsystem=threads/unbounded-queue-thread-pool=teiid-async:add(max-threads=4)
/subsystem=teiid:add(async-thread-pool=teiid-async, resultset-cache-infinispan-container=teiid-cache, preparedplan-cache-infinispan-container=teiid-cache, policy-decider-module=org.jboss.teiid)
{code}
The corresponding error looks
{code}
Failed to get the list of the operation properties: "WFLYCTL0030: No resource definition is registered for address [
("subsystem" => "threads"),
("unbounded-queue-thread-pool" => "teiid-async")
]"
{code}
was:
According to WFLY-462, the central thread pool configuration(threads subsystem) already be removed since 9.0.0.CR2, these two scripts(teiid-standalone-mode-install.cli, teiid-domain-mode-install.cli) be affected, specifically the following lines cli can not executed:
{code}
/subsystem=threads/unbounded-queue-thread-pool=teiid-async:add(max-threads=4)
/subsystem=teiid:add(async-thread-pool=teiid-async, resultset-cache-infinispan-container=teiid-cache, preparedplan-cache-infinispan-container=teiid-cache, policy-decider-module=org.jboss.teiid)
{code}
The corresponding error looks
{code}
Failed to get the list of the operation properties: "WFLYCTL0030: No resource definition is registered for address [
("subsystem" => "threads"),
("unbounded-queue-thread-pool" => "teiid-async")
]"
{code}
> Install script executed failed due to threads subsystem be removed
> ------------------------------------------------------------------
>
> Key: TEIID-3830
> URL: https://issues.jboss.org/browse/TEIID-3830
> Project: Teiid
> Issue Type: Component Upgrade
> Components: Build/Kits
> Affects Versions: 8.13
> Reporter: Kylin Soong
> Assignee: Steven Hawkins
> Fix For: 8.13
>
>
> According to WFLY-462, the central thread pool configuration(threads subsystem) already be removed since 9.0.0.CR2, these two scripts:
> * teiid-standalone-mode-install.cli
> * teiid-domain-mode-install.cli
> be affected, specifically the following lines cli can not executed:
> {code}
> /subsystem=threads/unbounded-queue-thread-pool=teiid-async:add(max-threads=4)
> /subsystem=teiid:add(async-thread-pool=teiid-async, resultset-cache-infinispan-container=teiid-cache, preparedplan-cache-infinispan-container=teiid-cache, policy-decider-module=org.jboss.teiid)
> {code}
> The corresponding error looks
> {code}
> Failed to get the list of the operation properties: "WFLYCTL0030: No resource definition is registered for address [
> ("subsystem" => "threads"),
> ("unbounded-queue-thread-pool" => "teiid-async")
> ]"
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month
[JBoss JIRA] (TEIID-3830) Install script executed failed due to threads subsystem be removed
by Kylin Soong (JIRA)
Kylin Soong created TEIID-3830:
----------------------------------
Summary: Install script executed failed due to threads subsystem be removed
Key: TEIID-3830
URL: https://issues.jboss.org/browse/TEIID-3830
Project: Teiid
Issue Type: Component Upgrade
Components: Build/Kits
Affects Versions: 8.13
Reporter: Kylin Soong
Assignee: Steven Hawkins
Fix For: 8.13
According to WFLY-462, the central thread pool configuration(threads subsystem) already be removed since 9.0.0.CR2, these two scripts(teiid-standalone-mode-install.cli, teiid-domain-mode-install.cli) be affected, specifically the following lines cli can not executed:
{code}
/subsystem=threads/unbounded-queue-thread-pool=teiid-async:add(max-threads=4)
/subsystem=teiid:add(async-thread-pool=teiid-async, resultset-cache-infinispan-container=teiid-cache, preparedplan-cache-infinispan-container=teiid-cache, policy-decider-module=org.jboss.teiid)
{code}
The corresponding error looks
{code}
Failed to get the list of the operation properties: "WFLYCTL0030: No resource definition is registered for address [
("subsystem" => "threads"),
("unbounded-queue-thread-pool" => "teiid-async")
]"
{code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month
[JBoss JIRA] (TEIID-3827) multi-source view insert throwing TEIID30492 error
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIID-3827?page=com.atlassian.jira.plugin... ]
Steve Tran commented on TEIID-3827:
-----------------------------------
After a lot of trial and error, we can close this ticket out as invalid.
I misunderstood what the Multi-source checkbox did on the VDB, which lead to the original error. My real issue was not using the XA datasources correctly. I have VDB inserting into two different databases now, with rollback if something erred. Pretty sweet. I'll try to clean this up and submit it as an example since I didn't see many examples of this - if anyone thinks it's a good idea. Otherwise, thanks for your help.
> multi-source view insert throwing TEIID30492 error
> --------------------------------------------------
>
> Key: TEIID-3827
> URL: https://issues.jboss.org/browse/TEIID-3827
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.3
> Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> MySQL 5.7 and Postgres 9.4
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
> Attachments: joined_vdb.vdb
>
>
> I'm trying to POC this multi-source INSERT. I have a MySQL DB and Postgres DB on my local machine. Added the drivers, datasource, and created a VBL with 1:1 mapping to my test tables. I created an EBL that is a join of my two tables. Both VBLs and EBL are set to support updates. I'm trying to work through this error.
> {quote}
> insert into "Joined_EBL"."joined2"(idtestm, randomstring, idtestp, randomint) values(0, 'randomstring', 0, 12345)
> org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryValidatorException: Remote TEIID30492 A multi-source table, Joined_EBL.joined2, cannot be used in an INSERT with query expression or SELECT INTO statement.
> {quote}
> I updated my INSERT tab on the EBL transformation page with the following.
> {code}FOR EACH ROW
> BEGIN ATOMIC
> INSERT INTO Postgres_VBL.testp (Postgres_VBL.testp.idtestp, Postgres_VBL.testp.randomint) VALUES (0, "NEW".randomint);
> INSERT INTO MySQL_VBL.testm (MySQL_VBL.testm.idtestm, MySQL_VBL.testm.randomstring) VALUES (0, "NEW".randomstring);
> END
> {code}
> Postgres table
> {code}
> CREATE TABLE testp
> (
> idtestp integer NOT NULL,
> randomint integer,
> CONSTRAINT pk_id PRIMARY KEY (idtestp)
> )
> WITH (
> OIDS=FALSE
> );
> ALTER TABLE testp
> OWNER TO postgres;
> {code}
> MySQL table
> {code}
> CREATE TABLE `testm` (
> `idtestm` int(11) NOT NULL AUTO_INCREMENT,
> `randomstring` varchar(45) DEFAULT NULL,
> PRIMARY KEY (`idtestm`),
> UNIQUE KEY `idtestm_UNIQUE` (`idtestm`)
> ) ENGINE=InnoDB DEFAULT CHARSET=tis620;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month
[JBoss JIRA] (TEIID-3829) olingo module junit test failed
by Kylin Soong (JIRA)
Kylin Soong created TEIID-3829:
----------------------------------
Summary: olingo module junit test failed
Key: TEIID-3829
URL: https://issues.jboss.org/browse/TEIID-3829
Project: Teiid
Issue Type: Bug
Components: Build/Kits
Affects Versions: 8.13
Reporter: Kylin Soong
Assignee: Steven Hawkins
Fix For: 8.13
olingo module junit test failed:
{code}
Results :
Failed tests:
TestODataSQLBuilder.testEq:431->te:400->helpTest:227 expected:<...g0 WHERE g0.e1 = {t'[04]:20:02'} ORDER BY g0...> but was:<...g0 WHERE g0.e1 = {t'[16]:20:02'} ORDER BY g0...>
TestODataSQLBuilder.testTimeMethods:552->te:400->helpTest:227 expected:<...YEAR({ts'2008-10-13 [04]:20:02.0'}) = 2008 O...> but was:<...YEAR({ts'2008-10-13 [16]:20:02.0'}) = 2008 O...>
Tests run: 109, Failures: 2, Errors: 0, Skipped: 0
{code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month