Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Locked Record In Way!!!

Status
Not open for further replies.

kpreda

Technical User
Mar 21, 2003
11
US
While starting selecting orders to invoice our computer shut down, we logged back in and started to print our invoices. We received an error stating that there was a locked record in the way and stopped printing invoices. When you go into progression help in the progression information it shows the user as logged in twice. How do I get rid of one of them without losing my invoicing?
 
First of all, make sure no one is in OE, maintain, OE setup, (or in AR, Maintain, AR Setup if you are using service invoices).

Secondly, get everyone out of Macola and delete all files in the users directory under your Macola root directory.

If this does not work pleaselet me know.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
dgilsdorf@trianglepartners.com
 
If after you follow Don's instruction and it still doesn't work you may have to start and stop the engine.
If you are running Novell you do this by making sure everyone is out of Macola and any other application that may be running Pervasive, then from the command prompt type "bstop" and you'll get a message stating the engine has stopped. Then you type "bstart" to restart the engine.
In windows you need to to know if you are running MSQL or PSQL. The concept is the same but there is an extra step with PSQL. Make sure everyone is out of Macola and all other applications that may be using the engine. Get to the "services" icon then with MSQL go to the Microsoft SQL and click on stop and when stopped then click on start. With PSQL you must stop both the Relational PSQL service and the Transactional PSQL service.Then restart them both.

THIS IS NOT FOR BEGINNERS IF YOU DO NOT KNOW EXACTLY WHAT I'M TALKING ABOUT DO NOT TRY THIS!!!!!

Steve Henley
trianglepartners.com
Exact Software consulting, sales and implementations.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top