February 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5246) Simplify Teiid configuration when using an external load balancer

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5246: ------------------------------------- Summary: Simplify Teiid configuration when using an external load balancer Key: TEIID-5246 URL: https://issues.jboss.org/browse/TEIID-5246 Project: Teiid Issue Type: Quality Risk Components: Server Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 10.2 When using an external load balancer it requires that the server disable ping checks and set max session age (to clean up any orphaned sessions). This is not specifically called out in the documentation. For future releases we should eliminate the need to explicitly change the configuration when using an external load balancer. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5123) Osisoft translator - Cannot cast String to Float if value is negative

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-5123?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-5123: ------------------------------------------------ Jan Stastny <jstastny(a)redhat.com> changed the Status of [bug 1506201|https://bugzilla.redhat.com/show_bug.cgi?id=1506201] from ON_QA to CLOSED > Osisoft translator - Cannot cast String to Float if value is negative > --------------------------------------------------------------------- > > Key: TEIID-5123 > URL: https://issues.jboss.org/browse/TEIID-5123 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.12.x-6.4 > Reporter: Andrej Šmigala > Assignee: Ramesh Reddy > Fix For: 10.1 > > > Casting a string containing a negative value (e.g. '-24') to float fails with > {noformat}com.osisoft.rdsa.RdsaException: [PIOLEDBENT] Cannot convert -24 from String to Single.{noformat} > This seems to be a bug in Osisoft PI SQL DAS (server-side not the JDBC driver), as connecting to the PI server using Osisoft's SQL Commander and running > {code:sql}select cast(N'-24' as single){code} > results in the same error. > I think the best course of action would be to document this behaviour of the PI server as known issue and NOT work around it. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5244) Text Based LoginModule does not find properties files

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-5244?page=com.atlassian.jira.plugin... ] Ramesh Reddy edited comment on TEIID-5244 at 2/1/18 1:05 PM: ------------------------------------------------------------- [~gadeyne.bram] can you try {code} ${jboss.server.config.dir} {code} was (Author: rareddy): [~gadeyne.bram] can you try ${jboss.server.config.dir} ? > Text Based LoginModule does not find properties files > ----------------------------------------------------- > > Key: TEIID-5244 > URL: https://issues.jboss.org/browse/TEIID-5244 > Project: Teiid > Issue Type: Bug > Affects Versions: 10.1 > Reporter: Bram Gadeyne > Assignee: Steven Hawkins > > Hi, > I have this in my configuration: > {code:xml} > <security-domain name="teiid-security" cache-type="default"> > <authentication> > <login-module code="UsersRoles" flag="required"> > <module-option name="usersProperties" value="$(jboss.server.config.dir)/teiid-security-users.properties"/> > <module-option name="rolesProperties" value="$(jboss.server.config.dir)/teiid-security-roles.properties"/> > </login-module> > </authentication> > </security-domain> > {code} > The two files teiid-security-roles.properties and teiid-security-users.properties are located in the configuration directory of wildfly. > I see this error message in the logs: It seems like teiid is using the value as a directory. > 2018-02-01 15:20:40,918 ERROR [org.jboss.security] (NIO1) PBOX00261: Failed to load users/passwords/roles files: java.io.IOException: PBOX00072: Properties file $(jboss.server.config.dir)/teiid-security-users.properties/defaultUsers.properties not found > at org.jboss.security.auth.spi.Util.loadProperties(Util.java:212) > at org.jboss.security.auth.spi.UsersRolesLoginModule.loadUsers(UsersRolesLoginModule.java:205) > at org.jboss.security.auth.spi.UsersRolesLoginModule.createUsers(UsersRolesLoginModule.java:219) > at org.jboss.security.auth.spi.UsersRolesLoginModule.initialize(UsersRolesLoginModule.java:146) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5244) Text Based LoginModule does not find properties files

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-5244?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-5244: ------------------------------------- [~gadeyne.bram] can you try ${jboss.server.config.dir} ? > Text Based LoginModule does not find properties files > ----------------------------------------------------- > > Key: TEIID-5244 > URL: https://issues.jboss.org/browse/TEIID-5244 > Project: Teiid > Issue Type: Bug > Affects Versions: 10.1 > Reporter: Bram Gadeyne > Assignee: Steven Hawkins > > Hi, > I have this in my configuration: > {code:xml} > <security-domain name="teiid-security" cache-type="default"> > <authentication> > <login-module code="UsersRoles" flag="required"> > <module-option name="usersProperties" value="$(jboss.server.config.dir)/teiid-security-users.properties"/> > <module-option name="rolesProperties" value="$(jboss.server.config.dir)/teiid-security-roles.properties"/> > </login-module> > </authentication> > </security-domain> > {code} > The two files teiid-security-roles.properties and teiid-security-users.properties are located in the configuration directory of wildfly. > I see this error message in the logs: It seems like teiid is using the value as a directory. > 2018-02-01 15:20:40,918 ERROR [org.jboss.security] (NIO1) PBOX00261: Failed to load users/passwords/roles files: java.io.IOException: PBOX00072: Properties file $(jboss.server.config.dir)/teiid-security-users.properties/defaultUsers.properties not found > at org.jboss.security.auth.spi.Util.loadProperties(Util.java:212) > at org.jboss.security.auth.spi.UsersRolesLoginModule.loadUsers(UsersRolesLoginModule.java:205) > at org.jboss.security.auth.spi.UsersRolesLoginModule.createUsers(UsersRolesLoginModule.java:219) > at org.jboss.security.auth.spi.UsersRolesLoginModule.initialize(UsersRolesLoginModule.java:146) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5243) Embedded SessionService does not monitor sessions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5243?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5243: ---------------------------------- Fix Version/s: 10.0.3 > Embedded SessionService does not monitor sessions > ------------------------------------------------- > > Key: TEIID-5243 > URL: https://issues.jboss.org/browse/TEIID-5243 > Project: Teiid > Issue Type: Bug > Components: Embedded > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.2, 10.0.3, 10.1.1 > > > Max session age and ping are not enforced with Teiid embedded as the start method is not explicitly called. Ping is only an issue for remote Teiid JDBC in a clustered configuration. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5245) Killed remote jdbc connections to an embedded server allowed to continue

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5245: ------------------------------------- Summary: Killed remote jdbc connections to an embedded server allowed to continue Key: TEIID-5245 URL: https://issues.jboss.org/browse/TEIID-5245 Project: Teiid Issue Type: Bug Components: Server Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 10.2, 10.0.3, 9.3.7, 10.1.1 Checks for session.isClosed occur in the full server and localserverconnection, but not when using a remote jdbc connections to an embedded server. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5206) Allow exponential values in OData V4 payloads with decimals

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-5206?page=com.atlassian.jira.plugin... ] Ramesh Reddy reopened TEIID-5206: --------------------------------- The precision and scale checks are being made on exponential form than the denormalized form. > Allow exponential values in OData V4 payloads with decimals > ----------------------------------------------------------- > > Key: TEIID-5206 > URL: https://issues.jboss.org/browse/TEIID-5206 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.12 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.12.x-6.4 > > > This is link to the upstream Olingo issue https://issues.apache.org/jira/browse/OLINGO-1150 -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5097) Cannot run time-based queries against Osisoft PI

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-5097?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-5097: ------------------------------------------------ Jan Stastny <jstastny(a)redhat.com> changed the Status of [bug 1500814|https://bugzilla.redhat.com/show_bug.cgi?id=1500814] from ON_QA to CLOSED > Cannot run time-based queries against Osisoft PI > ------------------------------------------------ > > Key: TEIID-5097 > URL: https://issues.jboss.org/browse/TEIID-5097 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Connector > Affects Versions: 8.12.x-6.4 > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Fix For: 10.1 > > > Osisoft PI supports a relative time literals syntax, e.g. > {code:sql} > select * from dvqe.Data.Archive a where a.time between '*-14d' and '*' > {code} > will select all data between right now and 14 days ago, and > {code:sql} > select * from dvqe.Data.Archive a where a.time > 'y' > {code} > will select all data after yesterday midnight. > The string literals are converted to time values in the PI Server > Running the same queries through teiid however returns incorrect results, because teiid pushes a cast to string on the Time column, which results in string comparison on the datasource: > {code:sql|title=Pushed query} > SELECT TOP 100 cast(g_0.[ElementAttributeID] as String), g_0.[Time] AS c_1, g_0.[Value] AS c_2, g_0.[ValueInt] AS c_3, g_0. > [ValueDbl] AS c_4, g_0.[ValueStr] AS c_5, cast(g_0.[ValueGuid] as String), g_0.[ValueDateTime] AS c_7, g_0.[Status] AS c_8, g_0.[Annotated] AS c_9, g_0.[IsGood] A > S c_10, g_0.[Questionable] AS c_11, g_0.[Substituted] AS c_12 FROM [dvqe].[Data].[Archive] AS g_0 WHERE cast(g_0.[Time] AS String) > 'y' > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5243) Embedded SessionService does not monitor sessions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5243?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5243. ----------------------------------- Resolution: Done Added the start call in EmbeddedServer. > Embedded SessionService does not monitor sessions > ------------------------------------------------- > > Key: TEIID-5243 > URL: https://issues.jboss.org/browse/TEIID-5243 > Project: Teiid > Issue Type: Bug > Components: Embedded > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.2, 10.1.1 > > > Max session age and ping are not enforced with Teiid embedded as the start method is not explicitly called. Ping is only an issue for remote Teiid JDBC in a clustered configuration. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5206) Allow exponential values in OData V4 payloads with decimals

by Jan Stastny (JIRA)

[ https://issues.jboss.org/browse/TEIID-5206?page=com.atlassian.jira.plugin... ] Jan Stastny commented on TEIID-5206: ------------------------------------ It seems like that, look at the [1] * private static boolean validatePrecisionAndScale does not account for the E8 part of the number. So it parses everything before decimal point, then after decimal point, but the exponential part is not reflected in the precision/scale validation. [1] https://github.com/jzhao-talend/olingo-odata4/blob/f67f12bbfc52902bc5bd8a... > Allow exponential values in OData V4 payloads with decimals > ----------------------------------------------------------- > > Key: TEIID-5206 > URL: https://issues.jboss.org/browse/TEIID-5206 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.12 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.12.x-6.4 > > > This is link to the upstream Olingo issue https://issues.apache.org/jira/browse/OLINGO-1150 -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 11 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2018