When trying to execute a crystal check on one of my development systems I found a problem after trying to fix another problem. All the crystals were going to error status and the message was coming up:
File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 404 – ORA-01017: invalid username/password; logon denied (200,0)
It turns out that the PSACCESSPRFL table had an extra entry which was invalid for the environment. Once I removed the invalid entry from the PSACCESSPRFL table the problem was resolved.