#18023 - 07/28/09 10:16 AM
Retrieving Data from AP to TB
|
Adagio Ace
Registered: 03/29/99
Posts: 216
Loc: Ottawa
|
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?
|
|
Top
|
|
|
|
|
#18032 - 07/28/09 01:33 PM
Re: Retrieving Data from AP to TB
[Re: Softrak Support]
|
Adagio Ace
Registered: 03/29/99
Posts: 216
Loc: Ottawa
|
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.
|
|
Top
|
|
|
|
|
#18033 - 07/28/09 01:47 PM
Re: Retrieving Data from AP to TB
[Re: bal]
|
Adagio Ace
Registered: 03/29/99
Posts: 216
Loc: Ottawa
|
I think this may have started after the latest AP update but I am not sure.
|
|
Top
|
|
|
|
|
#18034 - 07/28/09 02:19 PM
Re: Retrieving Data from AP to TB
[Re: bal]
|
Adagio Virtuoso
Registered: 02/07/02
Posts: 839
Loc: Vancouver, BC
|
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.
|
|
Top
|
|
|
|
|
#18035 - 07/28/09 02:35 PM
Re: Retrieving Data from AP to TB
[Re: Michael Mulrooney]
|
Adagio Ace
Registered: 03/29/99
Posts: 216
Loc: Ottawa
|
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)
|
|
Top
|
|
|
|
|
#18039 - 07/28/09 03:47 PM
Re: Retrieving Data from AP to TB
[Re: Softrak Support]
|
Adagio Virtuoso
Registered: 06/02/04
Posts: 694
Loc: Prince George BC
|
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.
_________________________
Ralph Allan
Business Computer Centre
Prince George BC Canada
|
|
Top
|
|
|
|
|
#18083 - 07/31/09 12:59 PM
Re: Retrieving Data from AP to TB
[Re: Ralph Allan]
|
Adagio Ace
Registered: 03/29/99
Posts: 216
Loc: Ottawa
|
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!
|
|
Top
|
|
|
|
|
#18085 - 07/31/09 01:48 PM
Re: Retrieving Data from AP to TB
[Re: Softrak Support]
|
Adagio Virtuoso
Registered: 02/07/02
Posts: 839
Loc: Vancouver, BC
|
Make sure that everyone, including yourself, has exited AP before you try the Retrieve in TB
|
|
Top
|
|
|
|
|
#18086 - 07/31/09 02:13 PM
Re: Retrieving Data from AP to TB
[Re: Softrak Support]
|
Adagio Ace
Registered: 03/29/99
Posts: 216
Loc: Ottawa
|
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? The error message is "data/APTBBTCH file is locked. Another program may be using the file" Usually I close A/P before opening TB when I want to retrieve data. I have no problem retrieving into the Ledger. I have no problem retrieving Billings into Receivables. It is ONLY payblaes into TB that is the problem.
|
|
Top
|
|
|
|
|
#18087 - 07/31/09 02:15 PM
Re: Retrieving Data from AP to TB
[Re: Michael Mulrooney]
|
Adagio Ace
Registered: 03/29/99
Posts: 216
Loc: Ottawa
|
Make sure that everyone, including yourself, has exited AP before you try the Retrieve in TB No one else is using Adagio when I retrieve.
|
|
Top
|
|
|
|
|
#18118 - 08/05/09 09:40 AM
Re: Retrieving Data from AP to TB
[Re: bal]
|
Adagio Ace
Registered: 03/29/99
Posts: 216
Loc: Ottawa
|
|
|
Top
|
|
|
|
|
|
0 registered (),
78
Guests and
0
Spiders online. |
|
Key:
Admin,
Global Mod,
Mod
|
|
1872 Members
5 Forums
14527 Topics
70937 Posts
Max Online: 432 @ 01/20/25 10:17 PM
|
|
|
|
|
|
|
|
1
|
2
|
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
|
10
|
11
|
12
|
13
|
14
|
15
|
16
|
|
17
|
18
|
19
|
20
|
21
|
22
|
23
|
|
24
|
25
|
26
|
27
|
28
|
29
|
30
|
|
31
|
|
|
|
|
|
|
|
|
Previous Topic
Index