User launches Controller. User chooses database, and enters their username/password. User clicks OK, and receives an error. After clicking OK (to acknowlege the error) the Controller client appears.
Description: Could not find a part of the path 'C:\Users\USERNAME\AppData\Roaming\Cognos\CCR\USERdatabasename'.
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object
Source, Object Description ...
There are several possible causes for similar errors.
- TIP: For more examples, see separate IBM Technote #1642447.
This Technote specifically relates to the scenario where the cause is invalid cache files inside the end user's profile.
By default, Controller stores cache files inside the folder %APPDATA%\Cognos\CCR
- These cache files are used to speed up the system (for the end users), for example when they are given menus to select parameters (for example 'company', 'actuality' and so on).
These cache files can potentially become invalid/corrupt if the Controller client crashes unexpectedly (for example, the user received an error the last time that they used Controller).
- Therefore, the exact root cause (for why the cache files became corrupt in the first place) can have many potential reasons, but one of them is that the customer is running an old version of Controller which contains a bug (which causes the Controller program to crash unexpectedly).
Resolving the problem
Long term fix:
Stop the Controller program from unexpectedly crashing during use. In general terms, this means:
- Upgrade to the latest version of Controller (to avoid known bugs)
- Ensure that your environment is in good condition (for example there are no network problems)
Delete local cache files on client device.
There are three different methods to delete cache files. Choose the method that is easiest/best for your environment:
Method #1 - Automatic (recommended long-term)
NOTE: This method only works for Controller 10.1.364 or later.
1. Launch Controller
2. Choose the relevant database (for example "production")
3. Logon as an administrator
5. Click tab "Server Preferences"
6. Inside "Variable Name" type "CLEARCACHEONEXIT"
8. Click Save
9. Close Controller
10. Repeat the above steps for each and every database connection where you want this behaviour to occur.
- TIP: For more details, see separate IBM Technote #1499456.
Method #2 - Manual (quick and easy instant workaround)
1. Launch Controller
2. Acknowledge error message, and continue into the main Controller client
3. Click "Maintain - Special Utilities - Clear Local Cache'.
Method #3 - Manual (can be done by I.T. administrator)
1. Launch Windows Explorer
2. Browse to the folder location mentioned in the error message
- For example: C:\Users\BADUSER\AppData\Roaming\Cognos\ccr
3. Delete all the files in the folder *except* for the file "ccr.config"
- In other words, delete all the *.DSS and *.DSD files (do not delete "ccr.config"):