Bug 1039924
Summary: | Cannot delete users with OracleDB because of "ORA-02292: integrity constraint (XXXXX) violated" | ||
---|---|---|---|
Product: | [JBoss] JBoss Enterprise Portal Platform 6 | Reporter: | Peter Palaga <ppalaga> |
Component: | Portal | Assignee: | mposolda |
Status: | VERIFIED --- | QA Contact: | Tomas Kyjovsky <tkyjovsk> |
Severity: | unspecified | Docs Contact: | |
Priority: | unspecified | ||
Version: | 6.1.1 | CC: | cnakamura, epp-bugs, mposolda, tkonishi, tkyjovsk |
Target Milestone: | DR02 | ||
Target Release: | 6.1.1 | ||
Hardware: | Unspecified | ||
OS: | Unspecified | ||
Whiteboard: | |||
Fixed In Version: | Doc Type: | Bug Fix | |
Doc Text: |
It was discovered that the way the user.language value was stored in Oracle databases caused issues when trying to delete a user record. Oracle expects empty strings to be saved with null, and the portal left the value of user.language blank until a user selected their preferred locale. The fix populates the user.language field with null for new users created by the portal administrator, which corrects the originally reported issue.
Existing users may still have issues with deletion because the corresponding JBID_IO_ATTR_TEXT_VALUES Oracle table values contains incorrect user attributes. Customers in this situation must manually clean the table by executing the following SQL query against the database: delete from JBID_IO_ATTR_TEXT_VALUES where ATTR_VALUE is null;
|
Story Points: | --- |
Clone Of: | 1038482 | Environment: | |
Last Closed: | Type: | Bug | |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: | |||
Bug Depends On: | 1038482 | ||
Bug Blocks: |
Description
Peter Palaga
2013-12-10 10:32:44 UTC
Fixed in upstream for 6.1.1. Verified with 6.1.1.DR2. I've already proposed "Doc text" in cloned issue https://bugzilla.redhat.com/show_bug.cgi?id=1038482 so I am just copy-pasting here. |