bfongpon
28th August 2007, 19:17
Hi,

I try to import new data ( session )

once all filled I continue and get these messages :

VRC file in use
table adv111 locked

its hapen now every time i try to import data whichever the vrc i can select.

Any advise ???

I cannot restart BaaN server .

Thanksfor your helps

dilipk.pandey
28th August 2007, 19:29
Hi,

Can you check out in session ttstpdellocks?
Or you can check the table ttadv997 and ttadv998 (application locks) for locks...the session based on this table is ttadv9598m000 - Application Locks, where one can remove if any lock is there...I hope this should work but not sure...just thought to share with you what I know...

All the very best...

Thank you.
Regards,
Dilip.

kaukul
29th August 2007, 06:42
Dilip is right...this is application lock problem.

This problem occurs when user tries to run the Import session and his login gets killed while the session is under progress.

Removing application lock will resolve the issue...

bfongpon
29th August 2007, 10:46
Hello ,

you are right

I unlock the table adv111 whith session ttstpdellocks.
and the Issue resolved.

Thanks a lot folks :)

Bye

Bruno