February 2017 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-3038) Designer is not aware of the system schema "SYSADMIN"

by Tom Johnston (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3038?page=com.atlassian.jira.plu... ] Tom Johnston commented on TEIIDDES-3038: ---------------------------------------- I just tested JBDS Version: 10.3.0.GA Build id: GA-v20170218-1636-B94 Build date: 20170218-1636 With Teiid Designer 11.0.1.Final-v20170208-2046-B4143 org.teiid.designer.feature.feature.group JBoss by Red Hat And still the error: > Designer is not aware of the system schema "SYSADMIN" > ----------------------------------------------------- > > Key: TEIIDDES-3038 > URL: https://issues.jboss.org/browse/TEIIDDES-3038 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.2 > Environment: Teiid Designer 10.0.2.Final-v20161108-1636-B72 org.teiid.designer.feature.feature.group JBoss by Red Hat > Reporter: Tom Johnston > Assignee: Barry LaFond > > SELECT > a.*, b.TablesUsed, b.isPhysical > FROM > (SELECT DISTINCT ((x.SchemaName || '.') || x.Name) AS FQN_Object, ((x.Uses_schemaName || '.') || x.Uses_Name) AS tablesUsed, y.isPhysical FROM SYSADMIN.Usage AS x, SYS.Schemas AS y WHERE (y.name = x.SchemaName) AND (x.schemaName NOT IN ('SYS', 'SYSADMIN')) ORDER BY ((x.SchemaName || '.') || x.Name)) AS a LEFT OUTER JOIN (SELECT DISTINCT ((x.SchemaName || '.') || x.Name) AS FQN_Object, ((x.Uses_schemaName || '.') || x.Uses_Name) AS tablesUsed, y.isPhysical FROM SYSADMIN.Usage AS x, SYS.Schemas AS y WHERE (y.Name = x.SchemaName) AND (x.schemaName NOT IN ('SYS', 'SYSADMIN')) ORDER BY ((x.SchemaName || '.') || x.Name)) AS B ON a.TablesUsed = b.FQN_Object > Results in > ERROR: Group does not exist: SYSADMIN.Usage AS x -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3038) Designer is not aware of the system schema "SYSADMIN"

by Tom Johnston (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3038?page=com.atlassian.jira.plu... ] Tom Johnston edited comment on TEIIDDES-3038 at 2/28/17 2:38 PM: ----------------------------------------------------------------- I just tested JBDS Version: 10.3.0.GA Build id: GA-v20170218-1636-B94 Build date: 20170218-1636 With Teiid Designer 11.0.1.Final-v20170208-2046-B4143 org.teiid.designer.feature.feature.group JBoss by Red Hat And still the error: The query is parsable but not resolvable. Resolver Error: Group does not exist: SYSADMIN.Usage AS x was (Author: virtualdatabase): I just tested JBDS Version: 10.3.0.GA Build id: GA-v20170218-1636-B94 Build date: 20170218-1636 With Teiid Designer 11.0.1.Final-v20170208-2046-B4143 org.teiid.designer.feature.feature.group JBoss by Red Hat And still the error: > Designer is not aware of the system schema "SYSADMIN" > ----------------------------------------------------- > > Key: TEIIDDES-3038 > URL: https://issues.jboss.org/browse/TEIIDDES-3038 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.2 > Environment: Teiid Designer 10.0.2.Final-v20161108-1636-B72 org.teiid.designer.feature.feature.group JBoss by Red Hat > Reporter: Tom Johnston > Assignee: Barry LaFond > > SELECT > a.*, b.TablesUsed, b.isPhysical > FROM > (SELECT DISTINCT ((x.SchemaName || '.') || x.Name) AS FQN_Object, ((x.Uses_schemaName || '.') || x.Uses_Name) AS tablesUsed, y.isPhysical FROM SYSADMIN.Usage AS x, SYS.Schemas AS y WHERE (y.name = x.SchemaName) AND (x.schemaName NOT IN ('SYS', 'SYSADMIN')) ORDER BY ((x.SchemaName || '.') || x.Name)) AS a LEFT OUTER JOIN (SELECT DISTINCT ((x.SchemaName || '.') || x.Name) AS FQN_Object, ((x.Uses_schemaName || '.') || x.Uses_Name) AS tablesUsed, y.isPhysical FROM SYSADMIN.Usage AS x, SYS.Schemas AS y WHERE (y.Name = x.SchemaName) AND (x.schemaName NOT IN ('SYS', 'SYSADMIN')) ORDER BY ((x.SchemaName || '.') || x.Name)) AS B ON a.TablesUsed = b.FQN_Object > Results in > ERROR: Group does not exist: SYSADMIN.Usage AS x -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3045) Issues with creating SOAP WAR

by Steve Tran (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3045?page=com.atlassian.jira.plu... ] Steve Tran commented on TEIIDDES-3045: -------------------------------------- I think building the war in the target directory is a good idea. I'm working on a client laptop so I don't have any control over the anti-virus settings. > Issues with creating SOAP WAR > ----------------------------- > > Key: TEIIDDES-3045 > URL: https://issues.jboss.org/browse/TEIIDDES-3045 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.1, 10.1 > Environment: Windows 7, 64-bit > JBoss Developer Studio 10.2.0.GA > JBoss Data Virt Development (Teiid Designer) Integration Stack 10.1.0.GA > > Reporter: Steve Tran > Attachments: Screenshot from 2017-02-24 14-40-13.png, jbds.log > > > Creating the SOAP war file usually works the first time if it's a brand new file, but if I need to regenerate the file for whatever reason, I have to attempt it 3 to 4 times before it will actually work. I thought it was something filesystem related, so after each failed attempt, I would refresh my project tree using the double refresh arrows, or I would right-click on the parent node and click refresh. If I'm lucky, it'll work right after the refresh trick, but it usually takes 3-4 times of trying before it finally takes. > This was also happening on JBDS 9. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3045) Issues with creating SOAP WAR

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3045?page=com.atlassian.jira.plu... ] Ted Jones commented on TEIIDDES-3045: ------------------------------------- Maybe an anti-virus software issue? That was an issue here: https://www.eclipse.org/forums/index.php/t/277909/ Assuming you have anit-virus software running, can you omit the JBDS install folder and subfolders? Alternatively, we can build the WAR in another location (perhaps the target directory?). > Issues with creating SOAP WAR > ----------------------------- > > Key: TEIIDDES-3045 > URL: https://issues.jboss.org/browse/TEIIDDES-3045 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.1, 10.1 > Environment: Windows 7, 64-bit > JBoss Developer Studio 10.2.0.GA > JBoss Data Virt Development (Teiid Designer) Integration Stack 10.1.0.GA > > Reporter: Steve Tran > Attachments: Screenshot from 2017-02-24 14-40-13.png, jbds.log > > > Creating the SOAP war file usually works the first time if it's a brand new file, but if I need to regenerate the file for whatever reason, I have to attempt it 3 to 4 times before it will actually work. I thought it was something filesystem related, so after each failed attempt, I would refresh my project tree using the double refresh arrows, or I would right-click on the parent node and click refresh. If I'm lucky, it'll work right after the refresh trick, but it usually takes 3-4 times of trying before it finally takes. > This was also happening on JBDS 9. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3045) Issues with creating SOAP WAR

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3045?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3045: ---------------------------------------- the log does appear to indicate "Access is denied". I think the War generator compiles java classes in some tmp/scratch folder, so appears that on Windows, it's having issues writing to that location. > Issues with creating SOAP WAR > ----------------------------- > > Key: TEIIDDES-3045 > URL: https://issues.jboss.org/browse/TEIIDDES-3045 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.1, 10.1 > Environment: Windows 7, 64-bit > JBoss Developer Studio 10.2.0.GA > JBoss Data Virt Development (Teiid Designer) Integration Stack 10.1.0.GA > > Reporter: Steve Tran > Attachments: Screenshot from 2017-02-24 14-40-13.png, jbds.log > > > Creating the SOAP war file usually works the first time if it's a brand new file, but if I need to regenerate the file for whatever reason, I have to attempt it 3 to 4 times before it will actually work. I thought it was something filesystem related, so after each failed attempt, I would refresh my project tree using the double refresh arrows, or I would right-click on the parent node and click refresh. If I'm lucky, it'll work right after the refresh trick, but it usually takes 3-4 times of trying before it finally takes. > This was also happening on JBDS 9. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3045) Issues with creating SOAP WAR

by Steve Tran (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3045?page=com.atlassian.jira.plu... ] Steve Tran commented on TEIIDDES-3045: -------------------------------------- I've attached a snip of the logs. I thought it was a Windows permissions issues, so I shutdown JBDS and selected to "Run as Administrator". Same error still. > Issues with creating SOAP WAR > ----------------------------- > > Key: TEIIDDES-3045 > URL: https://issues.jboss.org/browse/TEIIDDES-3045 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.1, 10.1 > Environment: Windows 7, 64-bit > JBoss Developer Studio 10.2.0.GA > JBoss Data Virt Development (Teiid Designer) Integration Stack 10.1.0.GA > > Reporter: Steve Tran > Attachments: Screenshot from 2017-02-24 14-40-13.png, jbds.log > > > Creating the SOAP war file usually works the first time if it's a brand new file, but if I need to regenerate the file for whatever reason, I have to attempt it 3 to 4 times before it will actually work. I thought it was something filesystem related, so after each failed attempt, I would refresh my project tree using the double refresh arrows, or I would right-click on the parent node and click refresh. If I'm lucky, it'll work right after the refresh trick, but it usually takes 3-4 times of trying before it finally takes. > This was also happening on JBDS 9. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3045) Issues with creating SOAP WAR

by Steve Tran (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3045?page=com.atlassian.jira.plu... ] Steve Tran updated TEIIDDES-3045: --------------------------------- Attachment: jbds.log > Issues with creating SOAP WAR > ----------------------------- > > Key: TEIIDDES-3045 > URL: https://issues.jboss.org/browse/TEIIDDES-3045 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.1, 10.1 > Environment: Windows 7, 64-bit > JBoss Developer Studio 10.2.0.GA > JBoss Data Virt Development (Teiid Designer) Integration Stack 10.1.0.GA > > Reporter: Steve Tran > Attachments: Screenshot from 2017-02-24 14-40-13.png, jbds.log > > > Creating the SOAP war file usually works the first time if it's a brand new file, but if I need to regenerate the file for whatever reason, I have to attempt it 3 to 4 times before it will actually work. I thought it was something filesystem related, so after each failed attempt, I would refresh my project tree using the double refresh arrows, or I would right-click on the parent node and click refresh. If I'm lucky, it'll work right after the refresh trick, but it usually takes 3-4 times of trying before it finally takes. > This was also happening on JBDS 9. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3045) Issues with creating SOAP WAR

by Steve Tran (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3045?page=com.atlassian.jira.plu... ] Steve Tran commented on TEIIDDES-3045: -------------------------------------- [~blafond] Yes, I am saving the war in a folder that's inside of my project. > Issues with creating SOAP WAR > ----------------------------- > > Key: TEIIDDES-3045 > URL: https://issues.jboss.org/browse/TEIIDDES-3045 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.1, 10.1 > Environment: Windows 7, 64-bit > JBoss Developer Studio 10.2.0.GA > JBoss Data Virt Development (Teiid Designer) Integration Stack 10.1.0.GA > > Reporter: Steve Tran > Attachments: Screenshot from 2017-02-24 14-40-13.png > > > Creating the SOAP war file usually works the first time if it's a brand new file, but if I need to regenerate the file for whatever reason, I have to attempt it 3 to 4 times before it will actually work. I thought it was something filesystem related, so after each failed attempt, I would refresh my project tree using the double refresh arrows, or I would right-click on the parent node and click refresh. If I'm lucky, it'll work right after the refresh trick, but it usually takes 3-4 times of trying before it finally takes. > This was also happening on JBDS 9. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3045) Issues with creating SOAP WAR

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3045?page=com.atlassian.jira.plu... ] Ted Jones commented on TEIIDDES-3045: ------------------------------------- Hey [~sqtran], can you please add the Designer log as well? Thanks > Issues with creating SOAP WAR > ----------------------------- > > Key: TEIIDDES-3045 > URL: https://issues.jboss.org/browse/TEIIDDES-3045 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.1, 10.1 > Environment: Windows 7, 64-bit > JBoss Developer Studio 10.2.0.GA > JBoss Data Virt Development (Teiid Designer) Integration Stack 10.1.0.GA > > Reporter: Steve Tran > Attachments: Screenshot from 2017-02-24 14-40-13.png > > > Creating the SOAP war file usually works the first time if it's a brand new file, but if I need to regenerate the file for whatever reason, I have to attempt it 3 to 4 times before it will actually work. I thought it was something filesystem related, so after each failed attempt, I would refresh my project tree using the double refresh arrows, or I would right-click on the parent node and click refresh. If I'm lucky, it'll work right after the refresh trick, but it usually takes 3-4 times of trying before it finally takes. > This was also happening on JBDS 9. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3045) Issues with creating SOAP WAR

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3045?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3045: ---------------------------------------- [~sqtran] and are you saving your SOAP war to a workspace/project folder? > Issues with creating SOAP WAR > ----------------------------- > > Key: TEIIDDES-3045 > URL: https://issues.jboss.org/browse/TEIIDDES-3045 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.1, 10.1 > Environment: Windows 7, 64-bit > JBoss Developer Studio 10.2.0.GA > JBoss Data Virt Development (Teiid Designer) Integration Stack 10.1.0.GA > > Reporter: Steve Tran > Attachments: Screenshot from 2017-02-24 14-40-13.png > > > Creating the SOAP war file usually works the first time if it's a brand new file, but if I need to regenerate the file for whatever reason, I have to attempt it 3 to 4 times before it will actually work. I thought it was something filesystem related, so after each failed attempt, I would refresh my project tree using the double refresh arrows, or I would right-click on the parent node and click refresh. If I'm lucky, it'll work right after the refresh trick, but it usually takes 3-4 times of trying before it finally takes. > This was also happening on JBDS 9. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 9 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues February 2017