[JBoss JIRA] (TEIIDDES-2461) Allow using JBoss AS connection timeout property when trying to connect/find Teiid Server
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2461?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2461:
---------------------------------------------------
Debi Rieden <drieden(a)redhat.com> changed the Status of [bug 1197529|https://bugzilla.redhat.com/show_bug.cgi?id=1197529] from VERIFIED to CLOSED
> Allow using JBoss AS connection timeout property when trying to connect/find Teiid Server
> -----------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2461
> URL: https://issues.jboss.org/browse/TEIIDDES-2461
> Project: Teiid Designer
> Issue Type: Enhancement
> Reporter: Barry LaFond
> Assignee: Paul Richardson
> Labels: release_notes, verified_jbdsis-8.0.3.CR2
> Fix For: 9.0.3, 9.2
>
> Attachments: jboss-timeout-preference.png
>
>
> The teiid-designer cannot connect to remote JDV server by timeout exceptions[1]. However, the teiid-designer cannnot set timeout for it.
> [1]
> org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: java.io.IOException: java.net.ConnectException: JBAS012144: Could not connect to remote://XXXX:9999. The connection timed out
> at org.jboss.ide.eclipse.as.internal.management.as71.AS71Manager.execute(AS71Manager.java:336)
> at org.jboss.ide.eclipse.as.internal.management.as71.JBoss71ManagerService.execute(JBoss71ManagerService.java:171)
> at org.jboss.ide.eclipse.as.management.core.JBoss7ManagerServiceProxy.execute(JBoss7ManagerServiceProxy.java:87)
> at org.teiid.designer.runtime.adapter.JBoss7ServerUtil.executeRequest(JBoss7ServerUtil.java:66)
> at org.teiid.designer.runtime.adapter.JBoss7ServerUtil.isTeiidServer(JBoss7ServerUtil.java:192)
> at org.teiid.designer.runtime.adapter.TeiidServerAdapterFactory.adaptJBoss7Server(TeiidServerAdapterFactory.java:181)
> at org.teiid.designer.runtime.adapter.TeiidServerAdapterFactory.adaptServer(TeiidServerAdapterFactory.java:82)
> at org.teiid.designer.runtime.TeiidParentServerListener.serverChanged(TeiidParentServerListener.java:153)
> at org.eclipse.wst.server.core.internal.ServerNotificationManager.broadcastChange(ServerNotificationManager.java:125)
> at org.eclipse.wst.server.core.internal.Server.fireServerStateChangeEvent(Server.java:742)
> at org.eclipse.wst.server.core.internal.Server.setServerState(Server.java:650)
> at org.eclipse.wst.server.core.model.ServerBehaviourDelegate.setServerState(ServerBehaviourDelegate.java:143)
> at org.jboss.ide.eclipse.as.wtp.core.server.behavior.ControllableServerBehavior.setServerStarted(ControllableServerBehavior.java:201)
> at org.jboss.tools.as.core.server.controllable.internal.DeployableServerBehavior.setServerStarted(DeployableServerBehavior.java:127)
> at org.jboss.ide.eclipse.as.rse.core.StandardRSEStartLaunchDelegate.preLaunchCheck(StandardRSEStartLaunchDelegate.java:72)
> at org.jboss.ide.eclipse.as.rse.core.subsystems.RSECommandLineLaunchController.preLaunchCheck(RSECommandLineLaunchController.java:103)
> at org.jboss.ide.eclipse.as.wtp.core.server.launch.ControllableServerLaunchConfiguration.preLaunchCheck(ControllableServerLaunchConfiguration.java:86)
> at org.eclipse.debug.internal.core.LaunchConfiguration.launch(LaunchConfiguration.java:840)
> at org.eclipse.debug.internal.core.LaunchConfiguration.launch(LaunchConfiguration.java:739)
> at org.eclipse.debug.internal.core.LaunchConfiguration.launch(LaunchConfiguration.java:731)
> at org.eclipse.wst.server.core.internal.Server.startImpl2(Server.java:3541)
> at org.eclipse.wst.server.core.internal.Server.startImpl(Server.java:3477)
> at org.eclipse.wst.server.core.internal.Server$StartJob.run(Server.java:367)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
> Caused by: java.io.IOException: java.net.ConnectException: JBAS012144: Could not connect to remote://XXXX:9999. The connection timed out
> at org.jboss.as.controller.client.impl.AbstractModelControllerClient.executeForResult(AbstractModelControllerClient.java:129)
> at org.jboss.as.controller.client.impl.AbstractModelControllerClient.execute(AbstractModelControllerClient.java:71)
> at org.jboss.ide.eclipse.as.internal.management.as71.AS71Manager.execute(AS71Manager.java:325)
> ... 23 more
> Caused by: java.net.ConnectException: JBAS012144: JBAS012144: Could not connect to remote://XXXX:9999. The connection timed out
> at org.jboss.as.protocol.ProtocolConnectionUtils.connectSync(ProtocolConnectionUtils.java:131)
> at org.jboss.as.protocol.ProtocolConnectionManager$EstablishingConnection.connect(ProtocolConnectionManager.java:256)
> at org.jboss.as.protocol.ProtocolConnectionManager.connect(ProtocolConnectionManager.java:70)
> at org.jboss.as.protocol.mgmt.FutureManagementChannel$Establishing.getChannel(FutureManagementChannel.java:176)
> at org.jboss.as.controller.client.impl.RemotingModelControllerClient.getOrCreateChannel(RemotingModelControllerClient.java:144)
> at org.jboss.as.controller.client.impl.RemotingModelControllerClient$1.getChannel(RemotingModelControllerClient.java:65)
> at org.jboss.as.protocol.mgmt.ManagementChannelHandler.executeRequest(ManagementChannelHandler.java:115)
> at org.jboss.as.protocol.mgmt.ManagementChannelHandler.executeRequest(ManagementChannelHandler.java:98)
> at org.jboss.as.controller.client.impl.AbstractModelControllerClient.executeRequest(AbstractModelControllerClient.java:236)
> at org.jboss.as.controller.client.impl.AbstractModelControllerClient.execute(AbstractModelControllerClient.java:141)
> at org.jboss.as.controller.client.impl.AbstractModelControllerClient.executeForResult(AbstractModelControllerClient.java:127)
> ... 25 more
> Additional information:
> We want to set a property of "IAS7ManagementDetails.PROPERTY_TIMEOUT" via teiid-designer.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIIDDES-2316) Excel import creates wrong datatype for ROW_ID column
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2316?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2316:
---------------------------------------------------
Debi Rieden <drieden(a)redhat.com> changed the Status of [bug 1134006|https://bugzilla.redhat.com/show_bug.cgi?id=1134006] from VERIFIED to CLOSED
> Excel import creates wrong datatype for ROW_ID column
> -----------------------------------------------------
>
> Key: TEIIDDES-2316
> URL: https://issues.jboss.org/browse/TEIIDDES-2316
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export, Modeling, Teiid Integration
> Affects Versions: 8.6
> Environment: Teiid Designer 8.6.0.Alpha1
> Teiid 8.7.1
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Fix For: 8.6
>
>
> Following https://community.jboss.org/wiki/MicrosoftExcelDocumentIntoRelationalTable (Option 1 using Teiid Designer), the imported model has the ROW_ID column modeled with datatype "integer", which results in BigInteger runtime datatype. After adding this model to a vdb and deploying, the following queries work ok:
> {code:sql}
> SELECT * FROM Sheet1
> SELECT * FROM Sheet1 WHERE row_id > 2
> {code}
> but the following query fails:
> {code:sql}
> SELECT * FROM Sheet1 WHERE row_id = 2
> {code}
> The error is
> bq. org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: java.math.BigInteger cannot be cast to java.lang.Integer
> After changing the datatype to "int : xs:long" and redeploying, the above query works as expected.
> However, if I copy the generated dynamic vdb (attached) and deploy it on the server (without using Designer), running the query against that works.
> The DDL for import is
> {code:sql}
> SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;
> CREATE FOREIGN TABLE Sheet1 (
> ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'),
> FirstName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
> LastName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
> Age double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
> CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
> ) OPTIONS ("teiid_excel:FILE" 'names.xlsx', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIIDDES-2331) Issues with renaming Source Model (8.3.4.CR1 and 8.6.0 + Windows 7)
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2331?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2331:
---------------------------------------------------
Debi Rieden <drieden(a)redhat.com> changed the Status of [bug 1136771|https://bugzilla.redhat.com/show_bug.cgi?id=1136771] from VERIFIED to CLOSED
> Issues with renaming Source Model (8.3.4.CR1 and 8.6.0 + Windows 7)
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2331
> URL: https://issues.jboss.org/browse/TEIIDDES-2331
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.3.4, 8.6
> Environment: Windows 7
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Fix For: 9.0, 8.6.1, 9.0.1
>
> Attachments: Dataroles_project.zip, log.log, screenshot1.png, screenshot2.png, screenshot3.png, screenshot4.png, screenshot5.png
>
>
> There is couple of issues with renaming source model that is referenced in some view model.
> I am using project Dataroles_project.zip (attached)
> 1. I tried to rename Products_source.xmi to Products_source1.xmi
> * this generates some error in log but it works...
> *[screenshot1.png]
> 2. Rename Products_source1.xmi to Products_source2.xmi
> * this fails to rewrite the reference in view model
> * I changed the references manually
> *[screenshot2.png and screenshot3.png]
> 3. Remane Products_source2.xmi to Products_source3.xmi
> * this deletes tables from view model
> *[screenshot4.png and screenshot5.png]
> This problem occurs only on Windows, Linux is fine...
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months