[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, 1 month
[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, 1 month
[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, 1 month
[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, 1 month
[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, 1 month
[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, 1 month
[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, 1 month
[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, 1 month
[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, 1 month
[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, 1 month