Identity Manager Reporting 4.5.x
Identity Manager Reporting 4.6.x
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
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.