You Cannot make any changes in the database until a ..

paddypower

TOPIC : You Cannot make any changes in the database until a transaction has been started.

Hi Everyone,

Funny problem

Version NAV 2009 SP1
Database: SQL

When users have entered a Sales order and they press the F9 (Statistics) button they get the above error. This does not happen on all the orders and I have tried to look at why but there is no common element or field.

I have looked at other posts and it does not seem to relate to this post.

Thanks

Thanks for your help


Paddy Power

matttrax

You'll want to turn on the debugger to find the line of offending code. It is probably contained in a conditional clause (IF condition THEN do something).

There are certain triggers that you cannot perform transactions (writes / modifies / deletes) in. You probably have some custom code that is sometimes doing that.

paddypower

Thank you I will get our developer to have a look cheers

Paddy Power

paddypower

ISSUE SOLVED

This is a BUG in NAV 2009 SP1 GB. I will report!

The above error has occured because of settings in the Log Entries table.

If you select "all fields" for table 36 or 37 you get this error. Once these have been removed the error is gone.

Thanks to my developer Tony Brown for finding this horrible error.

Thanks

PaddyPower

garak

](*,) an error like that (also the Change Log) was also in the first release of the 4.0 in the German version.

bob_up

Here is the fix
http://support.microsoft.com/kb/2250231