September 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3130) NPE in excel translator if xlsx file is missing

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3130?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3130. ----------------------------------- Resolution: Done Updated the logic to throw a better exception if the file is missing and to not produce an npe on close. > NPE in excel translator if xlsx file is missing > ----------------------------------------------- > > Key: TEIID-3130 > URL: https://issues.jboss.org/browse/TEIID-3130 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7 > Environment: OS: fedora20 > arch: x86_64 > java: sun 1.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > Attachments: NPE_missing_excel_file.zip > > > If xlsx file, which is pointed by resource adater & source model (in VDB) is missing, then any query ends with NPE. > Actual result: NullPointerException > Expected result: some better message or exception (e.g. FileNotFoundException or some TeiidException with good mesage) -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3130) NPE in excel translator if xlsx file is missing

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3130?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3130: ---------------------------------- Fix Version/s: 8.7.1 8.9 Affects Version/s: 8.7 Component/s: Misc. Connectors > NPE in excel translator if xlsx file is missing > ----------------------------------------------- > > Key: TEIID-3130 > URL: https://issues.jboss.org/browse/TEIID-3130 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7 > Environment: OS: fedora20 > arch: x86_64 > java: sun 1.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > Attachments: NPE_missing_excel_file.zip > > > If xlsx file, which is pointed by resource adater & source model (in VDB) is missing, then any query ends with NPE. > Actual result: NullPointerException > Expected result: some better message or exception (e.g. FileNotFoundException or some TeiidException with good mesage) -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3121) Teiid Standalone Server

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3121?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3121: --------------------------------------- Looks good. Ramesh is this what you were thinking or were you looking for something maven based so that we wouldn't have to know the download urls and/or something that was end users and not devs? > Teiid Standalone Server > ----------------------- > > Key: TEIID-3121 > URL: https://issues.jboss.org/browse/TEIID-3121 > Project: Teiid > Issue Type: Feature Request > Components: Build/Kits > Reporter: Tom Arnold > Fix For: Open To Community > > > Perform the server installation steps as part of the build and add the result to the downloads page. It seems like this is something that everyone who isn't using the embedded kit has to do anyways, and would hopefully eliminate confusion caused by people trying to deploy the runtime in unsupported versions of JBoss. > * Teiid Runtime > * Teiid Web Console > * JBoss EAP 6.1 Alpha > * Resteasy JAX-RS Patch > End result would simplify the installation process to: > 1. Unzip Teiid server. > 2. Run `bin/add-user.sh` script. > 3. Deploy custom translators, VDB, etc. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2831) Add a full ddl example to the ldap translator docs

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-2831?page=com.atlassian.jira.plugin... ] Kylin Soong updated TEIID-2831: ------------------------------- Forum Reference: https://developer.jboss.org/message/742528 > Add a full ddl example to the ldap translator docs > -------------------------------------------------- > > Key: TEIID-2831 > URL: https://issues.jboss.org/browse/TEIID-2831 > Project: Teiid > Issue Type: Task > Components: Documentation > Reporter: Steven Hawkins > Assignee: Kylin Soong > > It would be helpful to have a full example of LDAP metadata. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3123) Exception when using dense_rank() in Teiid Development

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3123?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3123. ----------------------------------- Fix Version/s: (was: 9.x) (was: 8.8) Resolution: Done While Teiid order by null it will not accept it in the parser, so to remain consistent pushdown will be prevented in the case where there is an order by null. Generally we can remove the null ordering if there are multiple order by keys. > Exception when using dense_rank() in Teiid Development > ------------------------------------------------------ > > Key: TEIID-3123 > URL: https://issues.jboss.org/browse/TEIID-3123 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.8 > Reporter: Joseph CHIDIAC > Assignee: Steven Hawkins > Fix For: 8.9 > > > SELECT DISTINCT > subQueryTable.jiraissue_ASSIGNEE AS jiraissue_ASSIGNEE, > dense_rank() over(order by subQueryTable.jiraissue_ID DESC) as CalculatedField1 > FROM jiraissue > LEFT OUTER JOIN > (SELECT jiraissue_sub.ASSIGNEE AS jiraissue_ASSIGNEE, > COUNT(IFNULL(jiraissue_sub.ID, -2147483648)) > AS jiraissue_ID > FROM jiraissue jiraissue_sub > WHERE ((jiraissue_sub.RESOLUTIONDATE BETWEEN NULL > AND PARSETIMESTAMP( > '2014-09-10 18:46:28', > 'yyyy-MM-dd HH:mm:ss'))) > GROUP BY jiraissue_sub.ASSIGNEE) subQueryTable > ON jiraissue.ASSIGNEE = > subQueryTable.jiraissue_ASSIGNEE > > The query sent to the JDBC : > SELECT DISTINCT DENSE_RANK() OVER (ORDER BY NULL DESC) FROM "JIRADB"."dbo"."jiraissue" g_0 > > and i got this error : > > java.sql.SQLException: Windowed functions do not support constants as ORDER BY clause expressions. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3130) NPE in excel translator if xlsx file is missing

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-3130?page=com.atlassian.jira.plugin... ] Juraj Duráni updated TEIID-3130: -------------------------------- Attachment: NPE_missing_excel_file.zip resource adapter, VDB, xlsx file, server log > NPE in excel translator if xlsx file is missing > ----------------------------------------------- > > Key: TEIID-3130 > URL: https://issues.jboss.org/browse/TEIID-3130 > Project: Teiid > Issue Type: Bug > Environment: OS: fedora20 > arch: x86_64 > java: sun 1.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Attachments: NPE_missing_excel_file.zip > > > If xlsx file, which is pointed by resource adater & source model (in VDB) is missing, then any query ends with NPE. > Actual result: NullPointerException > Expected result: some better message or exception (e.g. FileNotFoundException or some TeiidException with good mesage) -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3130) NPE in excel translator if xlsx file is missing

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-3130: ----------------------------------- Summary: NPE in excel translator if xlsx file is missing Key: TEIID-3130 URL: https://issues.jboss.org/browse/TEIID-3130 Project: Teiid Issue Type: Bug Environment: OS: fedora20 arch: x86_64 java: sun 1.7 Reporter: Juraj Duráni Assignee: Steven Hawkins If xlsx file, which is pointed by resource adater & source model (in VDB) is missing, then any query ends with NPE. Actual result: NullPointerException Expected result: some better message or exception (e.g. FileNotFoundException or some TeiidException with good mesage) -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3129) Limit is not added with multiple nulls in select on outer query to an inline view

by Sanjeev Gour (JIRA)

Sanjeev Gour created TEIID-3129: ----------------------------------- Summary: Limit is not added with multiple nulls in select on outer query to an inline view Key: TEIID-3129 URL: https://issues.jboss.org/browse/TEIID-3129 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.9 Reporter: Sanjeev Gour Assignee: Steven Hawkins When a query does multiple null selects in the in the outer query to an inline view and you only have a DISTINCT constant selected from the view definition, a limit 1 is expected to be applied to the inline view query which does not happen. Here is the sample query- SELECT DISTINCT c1, null as c2, null as c3 FROM( SELECT c1, c2 FROM ( SELECT 'const_col_1' as c1, ID as c2 FROM FIRST_SCHEMA.FIRST_TABLE UNION ALL SELECT 'const_col_2' as c1, ID as c2 FROM SECOND_SCHEMA.SECOND_TABLE ) as v ) as v1 The query will contain queries to the inline view without a limit like the following- SELECT 'const_col_1' FROM h2extended.TEST.FIRST_SCHEMA.FIRST_TABLE AS g_0 -------------------LIMIT 1 is not applied here Full query plan and the detail are capture in this discussion- https://developer.jboss.org/thread/248787 -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3124) InetAddress getLocalHost return UnknownHostException cause Teiid service start failed in JBoss Server

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3124?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3124: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1108418|https://bugzilla.redhat.com/show_bug.cgi?id=1108418] from NEW to MODIFIED > InetAddress getLocalHost return UnknownHostException cause Teiid service start failed in JBoss Server > ----------------------------------------------------------------------------------------------------- > > Key: TEIID-3124 > URL: https://issues.jboss.org/browse/TEIID-3124 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7 > Environment: JDV 6.x > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 8.7.1, 8.9 > > > After install JDV 6.0.0.GA via > java -jar jboss-dv-installer-6.0.0.GA-redhat-4.jar > start JDV throw the following exception cause some of servers start failed: > ~~~ > 17:17:35,824 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-8) MSC000001: Failed to start service jboss.teiid.transport.jdbc: org.jboss.msc.service.StartException in service jboss.teiid.transport.jdbc: Failed to start service > at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1767) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_55] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_55] > at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_55] > Caused by: org.teiid.core.TeiidRuntimeException: TEIID40065 Failed to resolve the bind address > at org.teiid.transport.SocketConfiguration.resolveHostName(SocketConfiguration.java:82) > at org.teiid.transport.SocketConfiguration.getHostAddress(SocketConfiguration.java:103) > at org.teiid.transport.SocketListener.<init>(SocketListener.java:55) > at org.teiid.jboss.TransportService.start(TransportService.java:157) > at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1] > at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1] > ... 3 more > 17:17:35,844 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-4) MSC000001: Failed to start service jboss.teiid.transport.odbc: org.jboss.msc.service.StartException in service jboss.teiid.transport.odbc: Failed to start service > at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1767) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_55] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_55] > at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_55] > Caused by: org.teiid.core.TeiidRuntimeException: TEIID40065 Failed to resolve the bind address > at org.teiid.transport.SocketConfiguration.resolveHostName(SocketConfiguration.java:82) > at org.teiid.transport.SocketConfiguration.getHostAddress(SocketConfiguration.java:103) > at org.teiid.transport.SocketListener.<init>(SocketListener.java:55) > at org.teiid.transport.ODBCSocketListener.<init>(ODBCSocketListener.java:43) > at org.teiid.jboss.TransportService.start(TransportService.java:181) > at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1] > at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1] > ... 3 more > ~~~ -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3128) Issue while querying Salesforce.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3128?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3128. ----------------------------------- Resolution: Done Moved the inner join handling into the translator. This will then appropriately handle both the parent to child (converted to child to parent) and child to parent to cases. > Issue while querying Salesforce. > --------------------------------- > > Key: TEIID-3128 > URL: https://issues.jboss.org/browse/TEIID-3128 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.4 > Reporter: Pranav K > Assignee: Steven Hawkins > Fix For: 8.9 > > > (I am using Teiid Embedded 8.8.0.Final) > Please refer to this forum thread for exact analysis/details: https://developer.jboss.org/thread/248796 > Steps to reproduce at my end: > 1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account. > 2) Execute the queries as shown in the steps below > 3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR) > -Changing the order of the From part makes it run fine -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2014