ERROR CATEGORY: Shoper opening
ERROR: Security database is wrongly specified in the configuration table. Please connect it and login again!
OCCURANCE: While opening Shoper, after double clicking on the Shoper icon
CAUSE: Security database 'tspsysdb9' is missing or has become corrupt
SOLUTION:
1) Restore the last working 'tspsysdb9' database
2) This can also happen if you SQL server program has become corrupted. This can easily be checked.
Goto Start -> Run. Type 'services.msc'. This will open the services screen. Check if 'SQL server (SQLEXPRESS) service is running.
If it is not in start mode, try starting it.
PRECAUTION:
Restoration of the backup is a pretty easy activity, but care must be taken to ensure that the data file path are correctly entered.
If SQL server has become corrupted, then there is very little option but to reinstall the 'SQL server' program which means that even Shoper has to be reinstalled.
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.
