Creating Views for IDM Reports gives error "Cannot change name of view column"
This document (7022056) is provided subject to the disclaimer at the end of this document.
When this issue comes up, you should see a line that is commented out at the top of the SQL command about Drop View.
-- DROP VIEW idm_rpt_cfg.idmrpt_idv_acct_v;
Uncomment this line - remove the rest of the SQL command, and run just the Drop View. This should be successful. Once you've done this, comment the line back out, and run the rest of the command again and it should work.
This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.
- Document ID:7022056
- Creation Date:10-OCT-17
- Modified Date:10-OCT-17
- NetIQIdentity ManagerIdentity Manager Roles Based Provisioning Module
Did this document solve your problem? Provide Feedback