I am new to the Macola ERP software, and have had no training whatsoever.
I am the administrator of the server and working on an issue that has been here since I started with the company, and our support doesn't really support us...
I am having an issue with the reset allocations process.
I can only seem to get it to run relatively stable on the server itself, as clients tend to error out. When running the software, it is showing as not responding. My guess is that it is just poorly coded and has no progress monitoring in the process itself.
When I look in the Activity Monitor in SQL Server, I can watch the particular session IDs associated with the process and see that every about 15-30 seconds an insert is issued. When I trace the session, it seems to be select after select after select. The week before this, I traced the entire process and ended up with ~120 GB of trace information. At only a few bytes per trace line, that seems to be a HUGELY inefficient process. Our company isn't that big to have that much information to cause a trace of that size...
This weekend, I started the process on Friday evening. As of this morning (Wednesday), the process is *still* running.
I can't get any answers as to what the purpose of this process is, or what could possibly be taking it so long to complete. Our support simply tells us that they think it is something in our environment, perhaps networking issues. Which obviously is a cheap way to blame us for an issue they don't know how to fix since we ruled out networking issues by running the process directly on the server itself.
I'm getting very frustrated. I was hoping someone here may be able to shed some light on me. This forum seems to be my last hope of getting anything accomplished...
Thanks in advance.
I am the administrator of the server and working on an issue that has been here since I started with the company, and our support doesn't really support us...
I am having an issue with the reset allocations process.
I can only seem to get it to run relatively stable on the server itself, as clients tend to error out. When running the software, it is showing as not responding. My guess is that it is just poorly coded and has no progress monitoring in the process itself.
When I look in the Activity Monitor in SQL Server, I can watch the particular session IDs associated with the process and see that every about 15-30 seconds an insert is issued. When I trace the session, it seems to be select after select after select. The week before this, I traced the entire process and ended up with ~120 GB of trace information. At only a few bytes per trace line, that seems to be a HUGELY inefficient process. Our company isn't that big to have that much information to cause a trace of that size...
This weekend, I started the process on Friday evening. As of this morning (Wednesday), the process is *still* running.
I can't get any answers as to what the purpose of this process is, or what could possibly be taking it so long to complete. Our support simply tells us that they think it is something in our environment, perhaps networking issues. Which obviously is a cheap way to blame us for an issue they don't know how to fix since we ruled out networking issues by running the process directly on the server itself.
I'm getting very frustrated. I was hoping someone here may be able to shed some light on me. This forum seems to be my last hope of getting anything accomplished...
Thanks in advance.