JBoss ON provisioning bundles summary page diplays error "more than one row returned by a subquery used as an expression" after creating new bundle version when an earlier bundle version had been deleted

Solution Unverified - Updated -

Issue

  • Problem with bundle versions

  • Creation of new bundle version results in the following error message in the server log:

    ERROR: more than one row returned by a subquery used as an expression

  • The following error message is shown Failed to load bundle with the latest version data

  • Bundle is no longer visible on Bundles summary page after new versions of an existing bundle is created
  • Bundles screen loads with an “unknown” error
  • The user-interface (UI) for managing bundles appears with an “unknown” error

  • When accessing the bundles page the following error appears in the server log:

    WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1427, SQLState: 21000
ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-01427: single-row subquery returns more than one row

Environment

  • Red Hat JBoss Operations Network (ON) 3.0, 3.0.1, 3.1, 3.1.1, 3.1.2
  • At least 2 versions of a JBoss ON provisioning bundle created for a single bundle
  • A previous version of the JBoss ON provisioning bundle has been deleted
  • A new version of the existing JBoss ON provisioning bundle has been created resulting in a total of 3 or more bundle versions for a single bundle
  • Accessing the Bundles summary page (for example, http://localhost:7080/coregui/#Bundles)

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content