How to check if a table is locked in Nav

(0) Share

Report

Posted on by Community Member

Hi,

Now, when I run a report sometimes I get error table xxx is locked; and it terminates.

Do we have any method in Nav; where we can check if a table is currently locked? then we can set wait until it unlocks ?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (0)

Report

Hey Hungto,

Check out his link if it helps you.

dynamicsuser.net/.../62972

Was this reply helpful? Yes No
Suggested answer

Jatin Patel 2,641 on at

Like (3)

Report

Hi,

Here is a script to identify locked tables in the SQL Server.

SELECT

OBJECT_NAME(p.OBJECT_ID) AS TableName,

resource_type, resource_description

FROM sys.dm_tran_locks l

JOIN sys.partitions p ON l.resource_associated_entity_id = p.hobt_id

When you run above script, it will display table name and lock on it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you!

But I need somethings that I can embedded in my report. Because when our users run the report, they cannot run script and check. I want the report to check and response correspondingly

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

thanks for your reply: but I see the below question still pending.

Honestly, I haven't because I was wondering if there is a way of doing something like:

How I can do below task ?

IF table_is_locked THEN

skip_posting

ELSE

insert_record

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report

you could run jatin's code using ADO in c/al.

for that follow my blog post moxie4nav.wordpress.com/.../executing-sql-select-statement-in-cal

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I tried the locktable but it doesn't work. I set the wait to true, and expect the report will wait but still run time error

Was this reply helpful? Yes No