Bug 877032 - [JON] Cannot delete a package in a new created Repositories
Summary: [JON] Cannot delete a package in a new created Repositories
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: JBoss Operations Network
Classification: JBoss
Component: Content
Version: JON 3.1.1
Hardware: All
OS: All
unspecified
high
Target Milestone: DR01
: JON 3.3.0
Assignee: Lukas Krejci
QA Contact: Mike Foley
URL:
Whiteboard:
Depends On: 878596
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-11-15 15:04 UTC by bkramer
Modified: 2018-11-29 19:26 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of: 877034
: 877034 878596 (view as bug list)
Environment:
Last Closed: 2014-10-30 14:03:58 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)
before-deletion (218.12 KB, image/png)
2014-08-05 12:40 UTC, Armine Hovsepyan
no flags Details
delete-button-click (332.62 KB, image/png)
2014-08-05 12:40 UTC, Armine Hovsepyan
no flags Details
after-deletion (217.78 KB, image/png)
2014-08-05 12:40 UTC, Armine Hovsepyan
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Red Hat Knowledge Base (Solution) 266313 0 None None None Never

Description bkramer 2012-11-15 15:04:47 UTC
Description of problem:
When Oracle is used as a backend database, attempt to delete newly created package in a repository fails with the following Exception:

Failed to delete packages: [I@7d7cec2f from repository: 10051 Error: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query

In the rhq-server-log4j.log file the following is logged:

2012-11-15 14:49:19,381 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 920, SQLState: 42000
2012-11-15 14:49:19,382 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-00920: invalid relational operator


Version-Release number of selected component (if applicable):
JON 3.1.1
Oracle 

How reproducible:
always

Steps to Reproduce:
1. Navigate to Administration -> Content -> Repositories and create new repository;
2. In the new repository, create new package;
3. Attempt to delete newly created package;
  
Actual results:
Newly created package is not deleted with above Exception

Expected results:
Newly created package is successfully deleted.

Additional info:
Tested the same on Postgres - works fine.

Comment 2 Lukas Krejci 2014-05-21 13:43:51 UTC
This seems to work fine with Oracle 11g, which is the minimum supported version for JON 3.3.

Tested both with RHQ 4.12.0-SNAPSHOT and JON 3.2.1.

Comment 3 Simeon Pinder 2014-07-31 15:51:36 UTC
Moving to ON_QA as available to test with brew build of DR01: https://brewweb.devel.redhat.com//buildinfo?buildID=373993

Comment 4 Armine Hovsepyan 2014-08-05 12:40:05 UTC
Created attachment 924197 [details]
before-deletion

Comment 5 Armine Hovsepyan 2014-08-05 12:40:32 UTC
Created attachment 924198 [details]
delete-button-click

Comment 6 Armine Hovsepyan 2014-08-05 12:40:53 UTC
Created attachment 924199 [details]
after-deletion

Comment 7 Armine Hovsepyan 2014-08-05 12:41:14 UTC
verified in jon 3.3 dr1
screen-shots attached

Comment 9 Larry O'Leary 2014-10-30 14:03:58 UTC
Looks like this shouldn't have made it this far. Based on comment 2 I believe this BZ should have been CLOSED WONTFIX as it applies to 3.1 and earlier.

If anyone disagrees, please re-open the bug with your logic/reasoning.

For clarity: 

WONTFIX: This issue does not occur in Oracle Database 11g which is the earliest supported Oracle Database version beginning with JBoss ON 3.2. Oracle Database 10g was deprecated in JBoss ON 3.0 and support for it was removed in JBoss ON 3.2. As 3.2 is the latest maintenance version of JBoss ON, this issue will not be fixed for previous releases of JBoss ON.


Note You need to log in before you can comment on or make changes to this bug.