Absent Member.. JasonCantrell Absent Member..
Absent Member..
92 views

[OO Support Tip] Rollback process will fail if new NULL content inserted in a 10.01 install

Issue:

Using Operations Orchestration, if new content is inserted into a 10.01 install which includes a selection list with a NULL value, then this will cause the rollback process to fail. In 10.00 a NULL value cannot be inserted.

 

Resolution:

Delete all rows with value == Null under table OO_SELECTION_LIST_VALUES before the downgrade is performed.
Here is the query:
delete from OO_SELECTION_LIST_VALUES where SELECTION_LIST_VALUE is null
In case the upgrade to 10.01 is attempted again, the redeployment of the CP that contains the Null values must occur.
Here is the solution for the central liquibase changes file in case this is corrected in the code at a later point:
 <changeSet author="central" id="delete empty selection list">
        <rollback>
            <delete tableName="OO_SELECTION_LIST_VALUES">
                <where>SELECTION_LIST_VALUE IS NULL</where>
            </delete>
        </rollback>
    </changeSet>
Important: This code should be at the end of the file since in the rollback it should run first.

Direct link to the document:

http://support.openview.hp.com/selfsolve/document/KM00564136

HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Labels (2)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.