Author Topic: Rogue Record Locks  (Read 6947 times)

precisonline

  • President
  • Administrator
  • Rock Star
  • *****
  • Posts: 1612
    • Precision Solutions
Rogue Record Locks
« on: April 24, 2007, 05:22:09 PM »
We're currently chasing down some situations in the Activant/Prelude app where record locks don't get released from Sales Order or Quote Entry.  This appears to cause the continuous printer to stop until that record lock is released.  I've personally seen it at a couple of different sites, one running V17 and another on V18.  Does anyone else see this kind of thing happening, or have you worked out specifically which program(s) might be leaving the locks?
« Last Edit: June 27, 2007, 12:07:54 PM by precisonline »
-Kevin
Accidents "happen"; success, however, is planned and executed.

Dave Sokoloski

  • Newbie
  • *
  • Posts: 2
Re: Rogue Record Locks
« Reply #1 on: August 03, 2007, 11:56:57 AM »
When we converted to V19.5 in April 2007 we had the exact same problem.  What it turned out to be was orders that had order acknowledgements.  The pick ticket would print fine via the continuous printer however the order ack got stuck.  We don't print order ack, we fax or email them.  When the order ack was printed, there was no problem.  Basically the continuous printer driver was locking the record before it tried to open it.  So when it went to open it, well the record was locked.  It took Prelude 4 days to fix it completely.

Support told me they were going to roll the changes made to our continuous driver back to base even thou it technically is a ā€œuser form.ā€

Prelude blamed the problem on the fact that we were NOT using Optio and that we were the first non Optio to upgrade to V19.5.

We did not discover the problem with email/ fax of order ack until go live because the system had to be under a certain amount of load and we had that feature turned off during testing.  We had fax/ email turned off in company setup so that as people tested the system they would not inadvertantly send stuff to customers and vendors.  We did turn on Fax/ Email at one point so that a select number of people could make sure it worked, but then we turned it back off.  It took some system load to trigger this problem.



precisonline

  • President
  • Administrator
  • Rock Star
  • *****
  • Posts: 1612
    • Precision Solutions
Re: Rogue Record Locks
« Reply #2 on: August 03, 2007, 12:00:26 PM »
So was the problem actually with the user form code, or was it somewhere else?
-Kevin
Accidents "happen"; success, however, is planned and executed.

Dave Sokoloski

  • Newbie
  • *
  • Posts: 2
Re: Rogue Record Locks
« Reply #3 on: August 14, 2007, 10:05:27 AM »
Problem was in the Continuous Printer code.  The continuous printer is considered a user form.