Welcome, Guest. Please Login.
05/25/25 at 13:14:52
News:
Home Help Search Login


Pages: 1
Send Topic Print
sm-j-c (Read 480 times)
lburns
Member
**




Posts: 75
Gender: female
sm-j-c
05/17/06 at 06:57:25
 
I am running both a master level and a transactional level reconciliation, type A.  The system seems to lock each time, on the same part number while working on the transactional reconciliation.  Any ideas as to why...and more so, what to do??  I have some data integrity issues and need to run this....
 
Thanks in advance!
 
Laurie
Back to top
 
 

Laurie Burns
Excel Connection USA
dba classic 2004.1/Evo-ERP
is tech build 11/08/2007
pervasive 8.0
Email wigal2000   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: sm-j-c
Reply #1 - 05/22/06 at 13:36:31
 
My guess would be some kind of corruption in the INVTXN file for a record for that item.  Can you see it in Maintain Database?
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
lburns
Member
**




Posts: 75
Gender: female
Re: sm-j-c
Reply #2 - 05/23/06 at 20:13:44
 
I had to get the system up and going last week - dealt with it in pervasive.
Back to top
 
 

Laurie Burns
Excel Connection USA
dba classic 2004.1/Evo-ERP
is tech build 11/08/2007
pervasive 8.0
Email wigal2000   IP Logged
dameng
Senior Member
****


DBA / EVO Software
Consultant

Posts: 275
Gender: male
Re: sm-j-c
Reply #3 - 06/22/06 at 14:01:54
 
i fixed it,  
 
first by making sure all users were out. then i made sure the operating system didn't have any files locked ( which i think there were some)  
did a reboot of the server,
then did a Rebuild of the bkicmstr, bkicloc, mticmstr using the pervasive rebuild utility.
 
then i ran sm-j-c at their server running 1st the master level, then seperately running the transaction level.
 
i suspect some record was locked by the server o/s which caused the initial problem.
Back to top
 
 

Dave Mengelkamp
Digital Consulting
760.832.2536
davemeng@earthlink.net
Email WWW   IP Logged
Pages: 1
Send Topic Print