HOUSEKEEP - Open Day/Close Day - Error occured:- 2147467259-->Cannot open database "shoperccc" requested in the login - The login failed

ERROR CATEGORY: Day Open / Day Close

ERROR: Error occured:- 2147467259-->Cannot open database "shoperccc" requested in the login - The login failed
OCURANCE: While trying to open the day or close the day

CAUSE: Shoper database has become corrupt

SOLUTION:

1) Repair the corrupt database OR

2) Restore the previous working database

PRECAUTION:

Repairing the database is not always possible. It actually depends on the degree of corruption which your database has gone through.

Restoring the previous working database is the best possible option but it may cause some data loss as the last backup available would be of the last day-end. So, the transactions made today will have to be re-entered into Shoper.

Restoration of the backup is a pretty easy activity, but care must be taken to ensure that the data file path are correctly entered.

HOW TO AVOID THIS ERROR:

Database corruption usually occurs due to the two reasons mentioned below. Care must be taken to avoid their occurance which will ensure smooth Shoper operations.

1) Power Fluctuations - If your shop is in a area where there is regular load-shedding or there are voltage fluctuations, then you must use a UPS to avoid database corruption.

2) Proper Shutdown of your PC - The computer must be properly shut-down when you close during the night. Switching off the mains before shut-down or doing a PC restart when shoper is running should be strictly avoided.