Creating Views for IDM Reports gives error "Cannot change name of view column"

  • 7022056
  • 10-Oct-2017
  • 10-Oct-2017


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.