COGNOS 8.3 – sqlpreparewithoptions status = -17 Error

I have seen this issue couple of times on the machine where there are too many users or at places where the DB is massive. My general solution to this issue is to restart COGNOS services every night (setting up a scheduled job) or weekly once. If this does not work then try the alternative solution.
The alternative steps that I do follow are:
1. Go to task manager, look for Derby.exe under the process and end the process.
2. Go to COGNOS/c8/bin and delete all the *.dmp files. (DMP – Are basically memory / error dump files)
3. Increase the memory size in the COGNOS Configuration.
4. Restart COGNOS.