Product:
Cognos Controller version 8.5.1

Symptom:
The Enhanced Reporting Optimization (ERO) does not work anymore, but it has before upgrade to new version of Cognos Controller.

Can be that you have changed the name of the controller database from Default to default.

Cause:
The settings for ERO are stored in the Windows Registry on the Controller Application Server.
Under a registry key for each database name, defined in Controller Configuration.
When you create new database – you must remember to setup the ERO values for the new database.

Solution:
Start Regedit on the Cognos Controller server
Ensure that the values under key;

[HKEY_LOCAL_MACHINE\SOFTWARE\VB and VBA Program Settings\FrangoController\Shares\default]

Are correct for ;

"server"="databaseservername"
"share"="ero$"

Check that each key for each database are correct.

www.cogknowhow.com