# The Basics of Troubleshooting Sage Evolution Queries

“When you have eliminated the impossible, whatever remains, however improbable, must be the truth.”

Sir Arthur Conan Doyle (Creator of Sherlock Holmes)

OUTLINE:

This blog discusses the basic concept of, and several valuable principles on how to perform a proper troubleshooting exercise to analyse and resolve issues in general, but also focusing on especially Sage Evolution queries that are due to any kind of errors and issues.

By applying the insight gained from this blog you will be empowered to resolve many of your own Sage Evolution queries.

But the end result should take you much further: You can also apply the basic principles discussed below on a wide variety of other applications’ technical and complex queries as well as resolving day to day problems that you may encounter.

TROUBLESHOOTING DEFINED

Troubleshooting is a form of problem solving, often applied to repair failed products or processes on a machine or a system.

It is a logical, systematic search for the source of a problem in order to solve it, and make the product or process operational again.

Troubleshooting is needed to identify the symptoms. Determining the most likely cause is a process of elimination—eliminating potential causes of a problem. Finally, troubleshooting requires confirmation that the solution restores the product or process to its working state.

In general, troubleshooting is the identification or diagnosis of "trouble" in the management flow of a system caused by a failure of some kind. The problem is initially described as symptoms of malfunction, and troubleshooting is the process of determining and remedying the causes of these symptoms.

https://en.wikipedia.org/wiki/Troubleshooting

Simply stated, the core premise of troubleshooting can be summed up as below:

The power of elimination and logical deduction to ultimately fix a problem!

TROUBLESHOOTING’S BASIC STEPS TO BE APPLIED TO ANY KIND OF PROBLEM

1. Identify the problem.
2. Establish a theory of probably cause. (Question the obvious)
3. Test the theory to determine cause.
4. Establish a plan of action to resolve the problem and implement the solution.
5. Verify full system functionality and if applicable implement preventative measures.
6. Document findings, actions and outcomes.

To elaborate a bit further on the above steps, also consider the following insight:

Usually troubleshooting is applied to something that has suddenly stopped working, since its previously working state forms the expectations about its continued behavior.

The initial focus is often on recent changes to the system or to the environment in which it exists. (For example, a printer that "was working when it was plugged in over there").

COINCIDENCE AND HOW IT SKEWS CORRELATION VS CAUSALITY

There is a well-known principle that correlation does not always imply

For example, the failure of a device shortly after it has been plugged into a different outlet doesn't necessarily mean that the events were related.

This is because the failure could have been a matter of mere coincidence. Therefore, troubleshooting demands rather than

APPLYING THE SCIENTIFIC METHOD AS PART OF TROUBLESHOOTING

There is a remarkable overlapping between general troubleshooting principles and the Scientific Method as is clearly illustrated in the image below.

FIRST OBJECTIVE: IDENTIFY AND UNDERSTAND THE PROBLEM

It can never be overstated how important it is to first clearly understand the problem/query/issue (PQI) before even moving on to any other steps in the troubleshooting cycle.

You should therefore form a very detailed understanding of all relevant factors as part of systematically eliminating the possible causes of the PQI.

Especially referring to Sage Evolution, consider the following vital questions to be asked and answered:

1. Sage Evolution version and build?
2. When exactly is the PQI message observed/experienced? When doing what exactly? e.g. when running the Inventory Valuation report with these specific filters.
3. Obtain a proper screenshot/s of any relevant error messages for further analysis by yourself and/or others (e.g. Sage Evolution Support).
4. How regularly is this PQI observed per user? E.g. each time the action in question 2 is performed? Or is it only occurring randomly?
5. Was the action performed in question 2 above working fine before?
6. If yes on question 5 above, what recently changed on your network, e.g. recent Evolution upgrade, change of Evolution server, new Windows user, other software installed on the Evolution server or local workstations (e.g. new Windows update or new anti-virus software installs or updates), any network changes whatsoever, etc.?
7. What happens exactly after the PQI is observed/experienced? E.g. Evolution closes or if clicking OK on the error, the user can continue etc.?
8. Has Evolution already been uninstalled and re-installed on the problematic workstation/s?
9. Operating System and edition (e.g. Home, Professional) version of the workstation. Obtain a screenshot of one of the affected workstation’s Computer (or My Computer) Properties screen.
10. Operating System and edition (e.g. Home, Professional) version of the Evolution Server PC? Obtain a screenshot of the affected terminal’s Computer (or My Computer) Properties screen.
11. Is the PQI observed/experienced on all Evolution companies? Even on a newly created demo company as well at the client’s site? If unsure, please test.
12. Are all users on the network observing the same PQI on their PC’s? If unsure, please test on the other workstations while logging on as the specific PC’s own Evolution agent.
13. Are there any third-party applications that integrate into the Evolution company?
14. Are there any kind of foreign database objects (Triggers, Views, Tables, Stored Procedures) linked to the Evolution company database for any reason whatsoever?
15. What versions of .NET Framework have been installed and are active on the affected workstation/s?
16. Has the PQI been tested by switching off the local PC’s Anti-Virus protection and Windows Firewall?

There may be even more factors added to the above questionnaire but at least you should get the basic idea here:

As much information as possible is always essential to define the PQI in its fullest sense. Only then should you move on to resolve it.

SECOND OBJECTIVE: FORMING A WELL-THOUGHT-OUT HYPOTHESIS

Now that you have a firm grip on your PQI, the next logical step should be to develop a hypothesis on the true cause of the PQI and how to then resolve it.

According to the Merriam Webster dictionary, a hypothesis can be defined as follows:

1:   a:  an assumption or concession made for the sake of argument

b:  an interpretation of a practical situation or condition taken as the ground for

action

2:   a tentative assumption made in order to draw out and test its logical        or empirical consequences

3:   the antecedent clause of a conditional statement

The main aim here is to always think logically in defining your hypothesis and then to ultimately resolve the PQI.

It should be extremely helpful to start thinking like a detective in your troubleshooting endeavour and ultimately finding the solution.