Progression 7.7 Reset Allocations (running 4+ days)
Progression 7.7 Reset Allocations (running 4+ days)
(OP)
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.
RE: Progression 7.7 Reset Allocations (running 4+ days)
John
RE: Progression 7.7 Reset Allocations (running 4+ days)
Could you tell me, what does the file validation process do and is it data safe? I'm concerned that I may do something that would have a negative effect on the data in the database.
And I would like to think our support provider could help us, but when I asked them about the process, their response began with "As far as I know..."
Unfortunately, when I say those words it usually means that I have no clue what I am talking about and simply pulling stuff from the air, so I expect nothing different when someone else says those words to me...
RE: Progression 7.7 Reset Allocations (running 4+ days)
Also allocation come from open sales orders and open manufacturing orders (POP or Shop Floor Orders). I would look at the raw data to make sure there are no "junk records" at the beginning or the ending of these tables.
Reset allocation essentially sets the allocation to zero, then recalculates it based on the open sales and manufacturing orders as mentioned above.
Post back if you have any questions.
Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html
RE: Progression 7.7 Reset Allocations (running 4+ days)
Because of the size of our IMINVTRX file, it initially took some time to start going - it looked as though it had hung for about 10-15 minutes, then it began processing IMINVTRX records and reset the Lot master table where needed etc.
This went a long way towards cleaning things up as we had inexplicable items on order and allocated with no real evidence of them actually being so.