My Favorites


Please to see your favorites.

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.


Identity Manager Reporting 4.5.x
Identity Manager Reporting 4.6.x
Oracle Database


When trying to use reports from IDM Reporting, trying to execute the provided SQL commands to create the necessary views for the reports fails. The error that typically comes up is similar to the following:

The error can vary slightly, depending on the Report that you are trying to setup, and depending on if you are using Postgres or Oracle Database, however there will always be the similarity of "cannot change name of the view column '(value)' to  '(value)'".

The SQL error is specific to Postgres (error code will likely be different in Oracle DB). More info on the error SQL state: 42P16 can be found here


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.


There isn't much further explanation other than the error that is given. A specific explanation isn't known - however it's likely that dropping the original view resolves the problem because it allows the recreation of all the new/required columns for the report you are trying to setup. 


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 Manager
      Identity Manager Roles Based Provisioning Module

Did this document solve your problem? Provide Feedback