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

paddypower
paddypower Member Posts: 98
edited 2013-06-20 in NAV/Navision Classic Client
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

Comments

  • matttrax
    matttrax Member Posts: 2,309
    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.
    Matt Traxinger - ArcherPoint
  • paddypower
    paddypower Member Posts: 98
    Thank you I will get our developer to have a look cheers

    Paddy Power
  • paddypower
    paddypower Member Posts: 98
    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
    garak Member Posts: 3,263
    ](*,) an error like that (also the Change Log) was also in the first release of the 4.0 in the German version.
    Do you make it right, it works too!
  • bob_up
    bob_up Member Posts: 155
    Here is the fix
    http://support.microsoft.com/kb/2250231

Categories