Report gives an error but keeps locking tables

matias_jaure

Hello,
We have a problem with a report that we have in a job to run every 30 minutes. This report run the Post batch (automatically post all orders in Realease state). Sometimes, it gives an error because some table that it's trying to use is locked. There would not be a problem if the report wouldn't keep blocking other tables, the most common one is Sales Line.
When someone goes and click OK in the error message, other users can work again. So, we think that this report is locking the tables. The Transaction Type of the Report is <Update No Locks>. We are using Navision 4.03 with SQL.

Thanks for ur time!

Matias

garak

do you run with update 6 :?:

Please read this http://www.mibuso.com/forum/viewtopic.p ... highlight=

matias_jaure

garak wrote:

do you run with update 6 :?:

Please read this http://www.mibuso.com/forum/viewtopic.p ... highlight=

It's 4.03, How I check if I have that update?

garak

check build no

matias_jaure

garak wrote:

check build no

In Help->About? there is not

garak

finsql.exe -> right mouse Button -> Properties -> Version (or so)

matias_jaure

garak wrote:

finsql.exe -> right mouse Button -> Properties -> Version (or so)

I have to verify that with DBA, they don't allow me to do that find of things :x ... If there is that version, what should I do?

garak

Take a look here at "Waldo"s BLOG

http://dynamicsuser.net/blogs/waldo/arc ... dated.aspx

for the Links to mbs.microsoft.com/knowledgebase you neet passport login

garak

What you should do is: Update your system (first your testsystem, i hope you have one ;-) ) and test the update. If you are not a partner, please connect to your navision partner and tell him your problem. Normaly the partner should you inform if you have the update contract.

Regards

Alterant

To find out a build number you can click Help -> About and double click on version description.

In Waldo's blog you should pay attention to Update 6.2 KB945349.

Waldo

8)
I accidenlty ran into this thread ... .
Cool!

Savatage

Waldo wrote:

8)
I accidenlty ran into this thread ... .
Cool!

See all that time blogging didn't go to waste \:D/

Waldo

apparently