W
wchinn2
Guest
When using the dataserver for MS SQL, when a locked record is being accessed in the ABL it gives a "Database Status" message something like: "cust in use by another user on tty ?. Wait or choose CANCEL to stop. (2624)." Please add the ability to see this information when the lock occurs. Although the lock message can be delayed for those cases when the lock will be fairly short in duration (we currently delay the lock message by 4 seconds using -Dsrv PRGRS_NATIVE_LOCKWAIT,4000) to eliminate this message showing up too soon, we have run into issues where locks are sometimes being placed on the database by applications outside of the ABL, and the locks appear in several places throughout the system. Tracing these down in a timely fashion has been very difficult without being able to identify what user placed the lock and where the user is located. Even through the information can be found in SQL Server and a trace can be made to track long running queries, it often requires some very timely research to identify what was happening when the lock occurred.
Continue reading...
Continue reading...