Home » Categories » Solutions by Business Process » Utilities |
Network File In Use |
Article Number: 2217 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 7:34 PM
|
Network File In Use – the DIAMOND.D02 is the multi-user control file for the Datafile system and is accessed thousands of times during operations in the Datafile system. As you open a database file or record the system opens this file to update the control file to show that you have this record open, similarly as you exit the system updates this file to clear these locks. During each update the system places a file lock to prevent other users updating this file – this lock takes fractions of a second but if another user tries to update during this time they will receive a ‘network file in use’ or ‘waiting for diamond.d02’ message.
This message, if seen at all, should automatically clear itself – when this message stays on screen and requires user intervention to resolve its a symptom of another problem.
You can sometimes determine the ‘error’ message being returned to Datafile that is resulting in the ‘Waiting’ message by adding an entry LOGLOCK=TRUE to the DATAFILE.INI. This logs to the SYSERR.DAT error file the response received from the network that is triggering the message. Googling this response can then give pointers to network triggers that result in that message.
One such reason can be the use of mapped drives – if the mapped drive is disconnected or disabled, even temporarily, then Datafile could report the waiting for / error accessing message.
An alternative to mapped drives is to use the UNC path to access the Datafile system – i.e. a shortcut along the lines of \\SERVER\DATAFILE\DFWIN\PROGRAMS\DFWIN.EXErather than F:\DFWIN\PROGRAMS\DFWIN.EXE for example. This may not be a simple change of shortcut, you would need to look at other paths in the Datafile system – i.e. location of files and DATAFILE.INI paths are relative (DATA\DEM-SLA.DFD for example). The DFWIN.INI, if in use, may need updating for the UNC path also.
You may also wish to look at our Knowledgebase article - http://datafile.co.uk/kb/article/smb2-smb3-and-opportunistic-locking-2132.html
|
Attachments
![]() There are no attachments for this article.
|
Accept Forward Period Dates on Automatic Imports
Viewed 1972 times since Fri, Jun 8, 2012
Input File Pathname - Stock Batch Update
Viewed 1832 times since Thu, Jul 5, 2012
Report Specification - Sales/Purchase Batch Updates
Viewed 1784 times since Thu, Jul 5, 2012
Adding / Updating Account Details - Sales/Purchase Batch Updates
Viewed 1846 times since Thu, Jul 5, 2012
Input File Pathname - Job Costing Batch Update
Viewed 1698 times since Thu, Jul 5, 2012
Confirm Printer - Stock Batch Update
Viewed 1776 times since Thu, Jul 5, 2012
Data Interchange Omit First Row from Import
Viewed 2092 times since Fri, May 27, 2016
End of Batch Update - Job Costing Batch Update
Viewed 1790 times since Thu, Jul 5, 2012
Scanning Options on the Ledger Enquiry
Viewed 1965 times since Wed, Jun 13, 2012
Run Time Prompt - Sales/Purchase Batch Updates
Viewed 1688 times since Thu, Jul 5, 2012
|