SQL server 2008 x64 - problem with posting

mpudja

Hi everyone,

We using navision 5.0 with 17 users and we have sql 2008 x64.
Problem is when someone post e.g. Item Journal , Purchase Invoice etc, navision at the end of posting suddenly freeze, after that user must force client to shut down it and start it again to continue with work. Very strange is that entries are successfully posted.

doe's anyone know what's going on ?

kriki

Try the debugger to see what is happening after the COMMIT that confirms the posting to the DB.

mpudja

thanks,
that's good idea....

mpudja

kriki,

thank's for helping me....I've noticed when I post Purchase Invoice that debugger stoped at line UpdateAnalysisView.Updateall in CU90.

Now I have turn off option 'Update on Posting' in Analysis View and for now I'll update it when I'll need it.

But, question is, what caused this....before day or two we didn't have this problem....

thanks for enlightened me

Alex_Chow

someone may have turned it on by mistake.

kriki

With the change log you can track the future offenders.

mpudja

Yesterday I was create new trace on sql to see what's happening. I've noticed that one user post Purhcase Inv. and I saw that trace on sql insert data in analysis view entry started from 01.01.2006. When I had open the table I saw that is empty!

I don't know who deleted all data. Now I've update all data and now it's ok.

thanks a lot to everyone.