Nas 4.0 Sp1

Arhontis

Hello everyone,

I am making some research on NAS and I have the following problem:

First of all I am using the SQL Server part of the NAS.
I have made a custom parameter (TEST) and run a specific codeunit.
I have build a navision timer (interval=1 sec) and added some code at the OnTimer that locktable(TRUE) and add a rec in a table (every second).
All works fine...
I made a codeunit (to test) that locktable(TRUE) the same record, adds a record and then waits for 20 seconds (waits by using repeat until and time check).
The NAS waits for a little and then creates an event in the application Event Viewer that says:
".... The test NAS table cannot be changed because it is locked by another user."
After that another event:
"....The server will attempt to initialize every 30 seconds until this is successful." which is known...

And (here is the problem) after that every 30 secs creates an event that says:
"..... The Breakpoint already exists.

Identification fields and values:

Object ID='5801',Object Type='Codeunit',Trigger Line='2',Code No='1'
."

I have checked that cu and it has a breakpoit at that place, I remove it and after a while it appears again.

I am not very familiar with the use of NAS, if someone could give me some directions or corrections I would really appreciate it...

kine

In SP1 there is new command and property of the database - timeout. By default it is 10seconds. If Navision is trying to obtain lock on some record and this request is not fulfilled in this timeout, you got error. After error, NAS is restarting (if the error is not called within nested transaction for example through IF Codeunit.RUN then...).

If you want, you can change this timeout through new C/AL command TIMEOUT. If you set it to 0, Navision will wait infinitely (like in previous versions).

Arhontis

Thanks Kine... Always with a suggestion...

I searched the TIMEOUT C/AL routine but didn't found something (and the compiler doesn't recognized it) and the version of the exe is:
Version GR 4.0 SP1 (4.0 SP1)

I tried the:

LOCKTIMEOUT(FALSE);

in the start of the NAS code and NAS waits infinitely. This covers me, but have you any ideas about the events that where raised? (The breakpoint event).
[/code]

kine

try to search for bookmarks.xml or something like that and delete the file (somewhere in the client directory, NAS directory or Application settings)

Arhontis

Bullseye!

To be exact, the file is named "NavBP.xml" and it is in the "Documents and Settings\<USERID>\Application Data".

I deleted it and I didn't use any LOCKTIMEOUT and NAS informed me in the event viewer that he can't do something right now because the table is locked, but he tries again after a few seconds secs and he reconnects and all goes well... I even made a 60 secs locktable (outside the NAS) and Nas tried 3 times to do the same job and all is well...


Thanks alot Kine...
Just tell me the year, and I will send you the wine...

kine

I am happy that you found the file. I just remember that there is some file with the breakpoints but I didn't know the exact name... 8)

Thanks for the offer of the wine, I know that Greek wines are very good, but I am not drinking wine (I am abstainer). But my grandpa has vineyard... :-)