| Summary: | JON 3.0 Beta install issue ... database-related | ||
|---|---|---|---|
| Product: | [Other] RHQ Project | Reporter: | Mike Foley <mfoley> |
| Component: | Database | Assignee: | Simeon Pinder <spinder> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Mike Foley <mfoley> |
| Severity: | high | Docs Contact: | |
| Priority: | medium | ||
| Version: | 4.1 | CC: | hrupp, spinder |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | Type: | --- | |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
mfoley retesting now with clean db... additional information: 1) this is oracle 2) this does NOT happen with a clean db. reducing severity as i don't believe upgrade to JON 3 Beta from RHQ 4.1.1 is supported upgrade path. This should be fixed by svn rev: 11201 and available in org.jboss.on-jboss-on-parent-3.0.0.BETA1-2 Tag and greater. missing value not set for is_private data. verified by Pune in JON 3 Beta qualification and in this Jenkins job http://hudson.rhq.lab.eng.bos.redhat.com:8080/hudson/job/overnight-rhq-4.0/395/ marking VERIFIED BZs to CLOSED/CURRENTRELEASE changing status of VERIFIED BZs for JON 2.4.2 and JON 3.0 to CLOSED/CURRENTRELEASE |
Description of problem: JON 3.0 Beta install issue ... database-related Version-Release number of selected component (if applicable): JON 3.0 Beta How reproducible: 100%. Me and spinder Steps to Reproduce: 1. basic install, overwrite existing database Actual results: error reported below Expected results: clean install Additional info: Failed to save properties and fully deploy - JON Server will not function properly Cause: java.sql.SQLException:Failed to create rows in table [RHQ_REPO] [ErrorCode=[1400]; SQLState=[23000]; Message=[ORA-01400: cannot insert NULL into ("RHQ"."RHQ_REPO"."IS_PRIVATE") ]; Type=[java.sql.SQLException]][SQLException=Failed to create rows in table [RHQ_REPO] [ErrorCode=[1400]; SQLState=[23000]; Message=[ORA-01400: cannot insert NULL into ("RHQ"."RHQ_REPO"."IS_PRIVATE") ]; Type=[java.sql.SQLException]]] -> java.sql.SQLException:ORA-01400: cannot insert NULL into ("RHQ"."RHQ_REPO"."IS_PRIVATE") [SQLException=ORA-01400: cannot insert NULL into ("RHQ"."RHQ_REPO"."IS_PRIVATE") ]