====== ====== ===== Issue ===== Repeated/Frequent Database Corruption ===== Explanation of Issue ===== Some users experience a repeated problem with database corruption. This can be caused by inconsistent connections to the network. ===== Severity ===== **Normal**. User is not down though repeated nature of problem is frustrating. ===== Possible Root Cause(s) ===== - **Power Management** [[recommended_network_troubleshooting]] Windows installs with certain Power Management settings preset to conserve energy, but is not condusive for live database transfers - **Network Connectivity** [[benchmark]] Networking speeds between the server and client machine are substandard for editing live databases. Recommended Read/Write speeds are 2000kbs - 10000kbs for a regular network. (For a GB Network, the speeds are 20000kbs - 30000kbs.) - **Anti-Virus/Firewall** These can block your client machines from access Cyrious across the network - **Network Problem** This is an issue that will probably have to be resolved by hiring a tech in your local area. You can try to narrow down the location of the source of the problem yourself somewhat. ===== Power Management Resolution ===== ==== Disable Power Managment on all computers with Cyrious ==== - Right click on My Computer - Select Properties - Click on the Hardware tab in the System Properties - Click on the Device Manager button in the System Properties - Expand the Network Adapters in the Device Manager - Double click on anything that opens up below the Network Adapters - Select the Power Management tab - Uncheck any checkboxes that are checked - Click the OK button * Repeat if there are multiple Network adapters - Close the Device Manager - Click on the Advance tab - Click the Setting buttons in the Performance field in the System Properties - Select the Data Execution Prevention tab in the Performance Options - Ensure that the top radio button is selected (Turn on DEP for essential Windows programs and services only) - Click the OK button in the Performance Options - Click the OK button in the System Properties - Right click anywhere on the open Desktop - Select Properties - Select the Screen Saver tab in the Display Properties - Click the Power button - Ensure that all settings are set to Never * you do not have to change the Turn off monitor settings - Select the Hibernation tab in the Power Options Properties - Ensure the Enable Hibernation checkbox is unchecked - Click OK in the Power Options Properties - Click OK in the Display Properties ==Test Network Connectivity Resolution== [[benchmark]] ==Anti-Virus/Firewall Resolution== - Verify that the anti-virus software or firewall is set to allow Cyrious.
Setting the proper permissions is done by adding it to the list of exceptions as a trusted program.
- In some cases, this may not work with all anti-virus progams such as Trend Micro.
To verify that the problem is caused by the anti-virus, completely disable the anti-virus program then try to recreate the problem. If successfully it is recommend contacting the anti-virus support team to further assist and/or consider other anti-virus alternatives such as [[http://www.microsoft.com/security_essentials/|Microsoft Security Essentials]] if supported by their operating system
==Network - Troubleshooting the location of the issue== - If your error typically pops up on one computer first all the time, it is likely that is the problem computer. - Run the [[benchmark]] utility to determine which computers are having speed issues.
If all the client machines are getting poor results, it is likely the networking problem is from the server to the router.
If it is just one client machine gettting poor results, it is likely the networking problem is from that client to the router.
- Disable the problem computer (not the Server) OR don't use Cyrious on that computer to see if the problem goes away.
If it does, that confirms the problem is between that client and the router
- If multiple computers seem to be the problem, don't use Cyrious on any computer except the server.
If the error continues and you are only using the server - the problem probably lies between the server and the router
If the error stops, start using one client machine and the server to see if the problem starts up again. If it does, stop using that machine and use another machine with the server. If the error continues after using on every machine, this will definitely confirm the problem between the server and the router
==Easily replacable items==
These are things you can possibly replace yourself and not have to contact a computer/network tech, depending on your skill level.
- Network Interface Card (NIC) - this is the card in the computer that you plug the Cat-5/Cat-6 cable into. - Cat-5/Cat-6 cable - Router
**Note:** We recommend a Gigabyte (GB) network
==Recommended Networking Gear==
This is what we are recommending, not brand names, but network type.
- Cat-6 cable - GB NIC - GB Router ===== Version Information ===== * Reported : 6/29/2009 * Version(s): * Fixed in : ===== Related Errors ===== [[sms_issue_-_cyrious_running_slow|SMS Issue - Cyrious running slow]]