Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

<(CM) Support tip>Unable to make change to System Option after running Security Filter Converter

Incident description :

HPE CM Administrator may find that the warning message about Security Filter Converter needs to be run is still received when attempting to make change to System Options. Though Security Filter Converter has been run, and it says all the threads are completed successfully.

Cause                         :  

There are still some records in the DB that haven’t been converted to the new Security Filter Converter model, and HPE CM won’t flag the system for the new Security Filter model until all records are converted to the new Security Filter model.

Resolution                :

When the issue is encountered , please :

1, Execute the SQL below and if it returns a number other than 0,   please run the Security Filter again.

SELECT COUNT(*) FROM TSRECORD WHERE ( ( rcAclGroupKey = 0 OR rcAclGroupKey IS NULL ) AND rcAccessIsCont = 'F' AND EXISTS ( SELECT 1 FROM TSACCESSCO WHERE ( axObject = 6 AND axObjectUri = TSRECORD.uri AND axType = 2 AND axSubType = 2 ) ) ) ORDER BY uri ASC ; 

2, Once the above SQL query returns 0, it indicates all records have been converted to the new Security Filter model, then execute the SQL below to make sure it returns 0 row as well :


If the above SQL returns 0 row, then restart HPE CM Client , and HPE CM Administrator should be able to make change to System Options.


0 Replies
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.