Testing all datasource connections fail with an error, even though connection parameters are correct.
Symptom
DPR-ERR-2002 Unable to execute the request because there was no process available within the configured time limit
Cause
This error can occur if the Cognos 8 encryption folders are not longer valid.
Resolving the problem
Regenerate the encryption information by following these steps:
1. Stop the Cognos 8 service.
2. On the Cognos 8 server(s), navigate to the
3. Launch Cognos Configuration.
4. From the File menu select Export as... and save the settings as crnstartup.xml.backup (or similar) to the configuration folder. Note: This will create an unencrypted version of your Cognos Configuration settings exposing any passwords in the configuration.
5. Close Cognos Configuration
6. Delete the csk, signkeypair, encryptkeypair directories.
7. Rename the exported configuration file to cogstartup.xml.
8. Launch Cognos Configuration.
9. From the File menu, select Save. This will recreate the csk, encryptkeypair and signkeypair directories and re-encrypt all the configuration information.
10. Start the Cognos 8 service.