mibuso.com

Microsoft Business Solutions online community
It is currently Sun Dec 28, 2014 4:10 pm

All times are UTC + 1 hour




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: [Solved] SQL server 2008 x64 - problem with posting
PostPosted: Thu Dec 15, 2011 10:07 am 
Offline

Joined: Fri May 29, 2009 12:23 pm
Posts: 30
Location: Zagreb
Country: Croatia (hr)
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 ?


Top
 Profile E-mail  
 
 Post subject: Re: SQL server 2008 x64 - problem with posting
PostPosted: Thu Dec 15, 2011 3:09 pm 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 9:13 am
Posts: 7705
Location: Milan
Country: Italy (it)
Try the debugger to see what is happening after the COMMIT that confirms the posting to the DB.

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting

»»» Mark your calendar: NAV TechDays 2015 - 19 & 20 November 2015 (!) ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
 Post subject: Re: SQL server 2008 x64 - problem with posting
PostPosted: Thu Dec 15, 2011 3:13 pm 
Offline

Joined: Fri May 29, 2009 12:23 pm
Posts: 30
Location: Zagreb
Country: Croatia (hr)
thanks,
that's good idea....


Top
 Profile E-mail  
 
 Post subject: Re: SQL server 2008 x64 - problem with posting
PostPosted: Thu Dec 15, 2011 4:11 pm 
Offline

Joined: Fri May 29, 2009 12:23 pm
Posts: 30
Location: Zagreb
Country: Croatia (hr)
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 :)


Top
 Profile E-mail  
 
 Post subject: Re: SQL server 2008 x64 - problem with posting
PostPosted: Thu Dec 15, 2011 7:46 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 11, 2004 8:05 pm
Posts: 5013
Location: Los Angeles, CA
Country: United States (us)
someone may have turned it on by mistake.

_________________
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work

Getting Started with Dynamics NAV 2013 Application Development = my book


Top
 Profile E-mail WWW  
 
 Post subject: Re: SQL server 2008 x64 - problem with posting
PostPosted: Thu Dec 15, 2011 8:44 pm 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 9:13 am
Posts: 7705
Location: Milan
Country: Italy (it)
With the change log you can track the future offenders.

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting

»»» Mark your calendar: NAV TechDays 2015 - 19 & 20 November 2015 (!) ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
 Post subject: Re: SQL server 2008 x64 - problem with posting
PostPosted: Fri Dec 16, 2011 9:10 am 
Offline

Joined: Fri May 29, 2009 12:23 pm
Posts: 30
Location: Zagreb
Country: Croatia (hr)
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.


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: