Collections MAX is a desktop-based debt collection software suite that runs on the Windows Operating System. It can be installed on a single computer or a dedicated server network. CollectionsMAX is a database-driven application that uses MySQL service in the back-end to run on the server.
Since Collections Max is a database-driven application, SSD Windows VPS is the most recommended hosting option. You can refer to our different SSD Windows VPS here.
Following are some of the frequent problems with Collections Max software and its possible solutions.
1. Often, you can access your VPS, but Collections Max runs too slow or does not even work. In such cases, you can try these suggestions –
- First, make sure that MySQL is running on your server. Type services.msc in the Run box, and a window will appear with a list of all services running.
- Next, check the status of the MySQL service. If it is stopped, start it from the Services window. Restart the MySQL service if it is already started and your issue persists.
- Make sure that the MySQL service is not utilizing 100% CPU. This could be the possible root cause of the slowness issue. In that case, you can try to Restart the MySQL service or reboot your VPS.
However, if this does not fix your issue, you should consider purchasing an additional vCPU or upgrading the current VPS plan to the next level.
- Make sure there is enough free space on your VPS; if there i'sn't, log in to your server and remove the unwanted data. You may need to reboot your VPS after removing unwanted data because many services might have crashed due to disk space issues. Additionally, receiving an Error code 28 indicates that your server is out of disk space. In such cases, you should consider purchasing additional disk space or upgrading your VPS to the next higher plan.
- If you face connection issues after migrating your data from the old server to the new server, you should check the permission constraints. Make sure that the MySQL database user has the necessary permissions over the MySQL database. Such failures occur when the permissions are not set in the new server.
2. If you are facing a timeout expired error in Collections Max like the given below:
- Mainly, this error occurs when you have too many idle connections. When you have too many idle connections, the MySQL server will eventually drop them out due to extensive memory consumption, and the above error will surface. When too many idle connections are not reclaimed, this could take the entire MySQL server down since MySQL will stop responding to requests.
- In several cases, you may face this error when a connection is idle and it is considered in use. The mySQL server tries to re-establish the connection, and it cannot because the maximum number of connections has been reached in the thread pool. To fix this issue, log in to the server and, invoke the MySQL Instance Configuration Wizard, re-configure for a higher number of connections (try 100 or more as the default is 20).
- You can also try to create a call-back for the day. The call-back system will ping the server every minute. It will keep the connection open.
While re-configuring the instance, ensure that strict mode is not enabled (uncheck the box) and do not modify the root password.
- Sometimes, anti-virus software installed on the VPS/ computer can also close idle connections. If you find such type of software, then remove it and use anti-virus software that doesn't close idle connections.
You can refer to the Collections Max official forum for more information about such issues.
Please note that the above options are only the collection of past incidents, which may or may not be applied to your issue.
For further support, you can contact the service provider of Collections Max for your concern problem(s).