Recently I have been having difficulty retrieving my A/P data in to TB.
I get the message that the file has been locked by another program.
No other program is open.

I am using Adagio on a server.

Any ideas?

Hi, 'Bal',

Can you tell us what versions(release dates) of both Adagio AP and Adagio T&B you are using?

It sounds like the problem has recently started occurring. Is anyone else using Adagio? You can tell by selected Help | Active Users from the main menu of one of our modules. Is anyone else accessing the data in any way using Plus? Is your office using any other 3rd party programs that access the Adagio data?

AP and TB are updated to the most current versions.

No one else is using Adagio at the same time. Someone else enters the payables data. I post the payables data, then retrieve into TB.

No 3rd party access to Adagio data.

I think this may have started after the latest AP update but I am not sure.

The 2nd line from the Help | About screen shows the Version # and Date. This information is always useful.

When everyone is out of Adagio go into your data folder and detete the EZSEMTAB.xxx where xxx is your data selector.

Then, making sure you are the only one working, start up Time Billing and try the retrieve.

If you still get the message let us know the exact wording...hopefully the message say's what file the system thinks is locked.

It says the the aptbtch file is locked.

I was finally able to retrieve it but this is not very convenient.
(I had already tried shutting down and rebooting. That did nothing.)

I ran a data integrity check on A/P. It returned no errors.
I ran a data integrity check on TB. It returned no errors.
I opened A/P.
I opened TB.
I retrieved data successfully.

Version:
AP 8.1A (080821)
TB 8.1A (080516)

Glad to hear you've got the transactions in now. Hopefully the hurdle has been surpassed and this will work from now on.

Something had occurred that prevented the process from working correctly for you. With these versions, I am able to post AP batches and immediately retrieve them into TB without locking messages, so there is more to this than just posting batches and retrieving.

The APTBBTCH file is the file that AP writes to when batches are posted, and TB uses to retrieve from to create the Disbursement batch. If the file was not locked on the server, then perhaps the ezsemtab or eztasks files contained invalid information, as Michael indicated. None of these 3 scenarios would be solved by rebooting a workstation.

May I suggest that your computer technician run \softrak\system\SetServerForAdagio.exe on the server. The server will have to be re-started if any settings are changed.

Failure to properly set the options here can result in locks not being released.

I was getting the error message again so I ran
\softrak\system\SetServerForAdagio.exe on the server, disabled the opprtunistic locking and this did not solve the problem.

Any other ideas?

This just started happening and at first it was only occasionally.

Thanks a lot!

Hi bal,

Could you indicate the exact wording of the error message? That might help in determining where the error exists, and help to determine a cause. In a previous post, you indicated that the APTBBTCH file was locked - is that the wording of the message?

For example, if you get an error that a specific user is doing a process that prevents you from retrieving, then the likely cause is that one of the EZSEMTAB.dat or EZTASKS.LD4 files were not cleared correctly when a user finished doing a task or shut down. The issue may also be that the server is holding onto the file, outside what Adagio is able to deal with. Perhaps the problem started when a Windows Security Update was installed.

You also mentioned that you are the person who posts the AP batches. Prior to starting Time&Billing and attempting to retrieve the batch, what do you do with AP? Are there any functions still open like Edit Invoice Batches or posting journals or so on?