[JBoss JIRA] (TEIID-3911) Nearly all odata4 errors reported as internal server errors
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3911?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3911:
-------------------------------------
Can we make this resolved Steve?
> Nearly all odata4 errors reported as internal server errors
> -----------------------------------------------------------
>
> Key: TEIID-3911
> URL: https://issues.jboss.org/browse/TEIID-3911
> Project: Teiid
> Issue Type: Sub-task
> Components: OData
> Affects Versions: 8.12
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5
>
>
> From the TeiidServiceHandler we generally rethrow our exceptions as ODataApplicationExceptions that have a status code of 500 - however even using a different status code still results in a 500 error as the Olingo framework expects exception subclasses to be used (see ErrorHandler.handleException - a general application exception is always a 500 error).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-4112) ORA-32039: recursive WITH clause must have column alias list
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-4112?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-4112:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1322935
Bugzilla Update: Perform
> ORA-32039: recursive WITH clause must have column alias list
> ------------------------------------------------------------
>
> Key: TEIID-4112
> URL: https://issues.jboss.org/browse/TEIID-4112
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.2.6_2
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
>
> If running a WITH table AS(...) query to Oracle and the query schema name is the same as the subquery name i.e. EWI. you receive the Oracle error:
> ORA-32039: recursive WITH clause must have column alias list
> If you modify the query to
> WITH EWI1 AS ....
> then it works.
> Query:
> ======================================================
> with EWI AS (
> SELECT
> A.cis_code,
> B.ewi_id,
> B.Action_Code,
> B.Action_Comments,
> B.Action_Date,
> VP.LONG_NAME AS "PERSON_LONG_NAME",
> B.Action_Taken_By_ECD_ID,
> D.Notes,
> D.Notes_Date,
> C.EWI_Sub_Type_Code,
> C.Narrative,
> C.Last_Update_Date,
> C.Last_Updated_By
> FROM
> "V_PARTY_STATUS" A inner join v_ewi_action B On A.cis_code = B.cis_code inner join v_ewi C ON B.ewi_id = C.ewi_id INNER JOIN V_PERSON VP ON B.Action_Taken_By_ECD_ID = VP.ECD_ID
> AND B.ACTION_TAKEN_BY_RACFID = VP.WINDOWS_LOGON
> AND B.ACTION_TAKEN_BY_DOMAIN = VP.DOMAIN left outer join v_ewi_notes D ON C.ewi_id = D.ewi_id
> where
> A.agreed_monitoring_code='ENHANCED_MONITORING'
> AND A.party_status_code not in ('INAC',
> 'GARB')
> AND B.Action_Code = 'ENHANCED_MONITORING'
> AND B.task_status_code = 'FINISHED'
> ) select * from EWI
> ======================================================
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-4112) ORA-32039: recursive WITH clause must have column alias list
by Debbie Steigner (JIRA)
Debbie Steigner created TEIID-4112:
--------------------------------------
Summary: ORA-32039: recursive WITH clause must have column alias list
Key: TEIID-4112
URL: https://issues.jboss.org/browse/TEIID-4112
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7.2.6_2
Reporter: Debbie Steigner
Assignee: Steven Hawkins
If running a WITH table AS(...) query to Oracle and the query schema name is the same as the subquery name i.e. EWI. you receive the Oracle error:
ORA-32039: recursive WITH clause must have column alias list
If you modify the query to
WITH EWI1 AS ....
then it works.
Query:
======================================================
with EWI AS (
SELECT
A.cis_code,
B.ewi_id,
B.Action_Code,
B.Action_Comments,
B.Action_Date,
VP.LONG_NAME AS "PERSON_LONG_NAME",
B.Action_Taken_By_ECD_ID,
D.Notes,
D.Notes_Date,
C.EWI_Sub_Type_Code,
C.Narrative,
C.Last_Update_Date,
C.Last_Updated_By
FROM
"V_PARTY_STATUS" A inner join v_ewi_action B On A.cis_code = B.cis_code inner join v_ewi C ON B.ewi_id = C.ewi_id INNER JOIN V_PERSON VP ON B.Action_Taken_By_ECD_ID = VP.ECD_ID
AND B.ACTION_TAKEN_BY_RACFID = VP.WINDOWS_LOGON
AND B.ACTION_TAKEN_BY_DOMAIN = VP.DOMAIN left outer join v_ewi_notes D ON C.ewi_id = D.ewi_id
where
A.agreed_monitoring_code='ENHANCED_MONITORING'
AND A.party_status_code not in ('INAC',
'GARB')
AND B.Action_Code = 'ENHANCED_MONITORING'
AND B.task_status_code = 'FINISHED'
) select * from EWI
======================================================
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-4017) EXECUTE IMMEDIATE in anonymous procedure ignores permissions
by Juraj Duráni (JIRA)
[ https://issues.jboss.org/browse/TEIID-4017?page=com.atlassian.jira.plugin... ]
Juraj Duráni commented on TEIID-4017:
-------------------------------------
Thanks for clarification. So I expect that \[1\] is not true and you just ignored it. I will set related BZ to VERIFY.
\[1\]
{quote}
I'll get 1 as value that is also wrong because we have no permissions to execute testSelect() procedure even from another procedure.
{quote}
> EXECUTE IMMEDIATE in anonymous procedure ignores permissions
> ------------------------------------------------------------
>
> Key: TEIID-4017
> URL: https://issues.jboss.org/browse/TEIID-4017
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12
> Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 9.0, 8.12.5, 8.13.2, 8.7.5.6_2
>
>
> I've found a bug when executing a query in the EXECUTE IMMEDIATE clause. It ignores permissions.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-4017) EXECUTE IMMEDIATE in anonymous procedure ignores permissions
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4017?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4017:
---------------------------------------
Juraj,
That is a misunderstanding of data roles - they are not applied transitively. As long as you have permission to execute at the user query level, everything else below is allowed.
> EXECUTE IMMEDIATE in anonymous procedure ignores permissions
> ------------------------------------------------------------
>
> Key: TEIID-4017
> URL: https://issues.jboss.org/browse/TEIID-4017
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12
> Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 9.0, 8.12.5, 8.13.2, 8.7.5.6_2
>
>
> I've found a bug when executing a query in the EXECUTE IMMEDIATE clause. It ignores permissions.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months