Welcome, Guest. Please Login.
05/13/25 at 07:37:47
News:
Home Help Search Login


ISTech Support Forum › Evo-ERP and DBA Classic › Items ‹ Previous topic | Next topic ›
Pages: 1
Send Topic Print
Update Material Standard Costs (Read 2510 times)
IT Department
Member
**




Posts: 63
Gender: male
Update Material Standard Costs
10/29/10 at 05:06:41  
Hello,
    We are having difficulty Updating the Material Standard Costs under the Items > IN menu in DBA. It should normally take about 15-20 minutes to complete however, as soon as someone enters A and presses enter the Update Material Standard Costs box exits out and nothing happens.
 
I have tried rebooting the server that hosts the DBA program but it did nothing to help.
 
Can someone please help?
 
Thanks in Advance!
Back to top
 
 
IT Department   IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1517
Gender: male
Re: Update Material Standard Costs
Reply #1 - 10/29/10 at 05:20:52  
Sounds like you have a corrupted item entry in the beginning of the table. Try bringing up each of the first dozen or so items in IN-B and see if you receive an error. Could be other things, but that will give you something to try. You can also try doing a range of items with IN-L-E by entering the From item number with the tenth or twentieth item in your inventory through to the last item. That could help you narrow down exactly where the problem lies.
Back to top
 
 

Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
IT Department
Member
**




Posts: 63
Gender: male
Re: Update Material Standard Costs
Reply #2 - 10/29/10 at 05:55:53  
I will try that and see how it goes, thanks.
   
 
 Any other suggestions in the meantime?
Back to top
 
 
IT Department   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Update Material Standard Costs
Reply #3 - 10/29/10 at 14:35:11  
For reference, the problem was a file bigger than 2GB
Back to top
 
 
Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
IT Department
Member
**




Posts: 63
Gender: male
Re: Update Material Standard Costs
Reply #4 - 10/01/12 at 07:17:58  
Not sure if my previous message got through. I am seeing this problem again.
 
DBA 2004.1 update 12/15/07.  
 
How can I fix the problem and with which file. I presume BKICMSTR.B. Will a reindex help it.  
 
Thanks  
Shanthi
Back to top
 
 
IT Department   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Update Material Standard Costs
Reply #5 - 10/01/12 at 08:35:24  
We have 11,000 Sku's (171 MB)
If your table is bigger than 2GB, I can calculate that you could have over 1.2 Million Sku's ???
 
Ouchhhh
 
 lips sealed
 
Kelloggs
Back to top
 
 
Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
IT Department
Member
**




Posts: 63
Gender: male
Re: Update Material Standard Costs
Reply #6 - 10/01/12 at 09:15:18  
As far as I can see only ISMICADT.B is over 2G. What can I do to fix that. And is that the cause of this problem.
 
Thanks
shanthi
Back to top
 
 
IT Department   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Update Material Standard Costs
Reply #7 - 10/01/12 at 09:26:36  
That cann't be!!! There is something wrong with that table.
 
Are you a big company? Many employees on DBA?
 
If not just ask everybody to log off. Make a backup of your entire system  
then re-index that table.
 
Other way to do this is to create a play company  
Then do the re-index there, see if that make a difference....
 
UT-C  Reindex File
 
 Tongue
 
Kelloggs
 
Back to top
 
 
Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
IT Department
Member
**




Posts: 63
Gender: male
Re: Update Material Standard Costs
Reply #8 - 10/01/12 at 15:06:19  
It turns out Lynn told us previously to delete the file. I did that but am still seeing the problem. From my previous motes there is a dbaif program. I am not sure what that is. I am in the process of reindexing the files. Any ideas what more I can do.
Back to top
 
 
IT Department   IP Logged
IT Department
Member
**




Posts: 63
Gender: male
Re: Update Material Standard Costs
Reply #9 - 10/02/12 at 07:01:19  
Thank you all for your help. For reference, I deleted the two ISMICADT.B and ISMICADT^01 files and the used UT-A -> DBAIF to recreate it but the file does not seem to have been created. Everything is working fine howerver.
Back to top
 
 
IT Department   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Update Material Standard Costs
Reply #10 - 10/02/12 at 07:36:16  
The ISMICADT file is on of the audit files that tracks changes to inventory items and if you frequently roll standard costs, it can get very large.  There is a default setting to disable the change tracking for standard cost rollup.  There is also a setting in Pervasive on the server (Version 9 or later) to enable file size larger than 2 GB which will allow the file to grow rather than create the ^01 extension file when it hits 2 GB which is what makes Evo/DBA blow up.
Back to top
 
 
Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print
ISTech Support Forum › Evo-ERP and DBA Classic › Items ‹ Previous topic | Next topic ›

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.

Valid XHTML Valid CSS Powered by Perl Source Forge