Product:
Cognos Controller 10.4.2
Issue:
After change of SQL server to Cognos Controller, ERO reports does not work.
Error message:
Solution:
Ask the DBA to ensure that the SQL login (frango) you are using to the Controller database have the server roles: bulkadmin and public
You check what SQL login you are using in Cognos Controller Configuration.
More information:
https://www.ibm.com/docs/en/cognos-controller