[Solved]  Arithmetic operation resulted in a workflow 

  

Have you ever encountered "Arithmetic operation resulted in a workflow"?

after deployed or installed your application to remote server or clients computer, user happened to use your program over a period of time and error popped out. Your program may be in arithmetic operation resulted in a workflow vb.net, arithmetic operation resulted in a workflow oracle, arithmetic operation resulted in a workflow windows 10, arithmetic operation resulted in a asp.net.

This is what will happen next..

Your client raises a ticket to solve this high critical issue, and imaging you haven't done this before - what would you do?

If you are reading here, yes you are at right place to grab solution.

Before get into the solution let's find what caused this error

What is root cause?

If you are beginner to any programming language, it is good to learn how program function behind logic executed, and better way to optimize and utilize the memory allocation.

Any variable declaration will occupy memory depends on the types such as int, string, array, float, point etc. Each variable has highest or maximum size allotted by default. 

There are times unknowingly or coding practice will lead to exceed the maximum size, and uncleared memory size after function or logic executed.


What will happen of uncleared memory? 

Just a hint, any variable declaration will affect gradually your computer memory. Apart from RAM memory, local computer physical location stores any file you open gets saved automatically as reference. If you do not clear this temporary folder the size keeps increasing and causes slowness and yields overflow error anytime. 

Where is that - physical folder saves files?

It is in operating system (os) folder c:\ drive. Yes-now let's see in detail step by step  


Step 1:  Close the opened application
Step 2:  Go to Run command (Windows + R) 
Step 3:  Type %temp% 
Step 4:  Press enter
Step 5:  Select all the files and delete (To clear local memory cache)
Step 6:  Re-start the machine if possible
Step 7:  Re-run the application as Administrator again.
  

Find this error message caused below image and circled, red underline.


 





Summary  

Thank you for getting until here.

After fixing this error, I am sure you will have pleasant day.

I am happy that shared a piece of information learned - would help you today.

Finally, this article explains how variable declaration affects memory allocation and exceed memory size causes overflow exception and solution to get it fixed.