Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Problems with NAV 2013 R2 Services
nuno.silva
Member Posts: 29
Hi,
We have a production environment, NAV 2013 R2 build 38455, with one service plus four instances of that service on the same server. The main service is where the users connect to NAV, then I have on instance for webservices, other instance for run NAS and the other two instances where we are running two stores of LS Retail add on.
We are having two problems:
1. Sometimes when the first user in the morning tries to connect to RTC get the error that the table user personalization is blocked by other user and it is only possible to connect with RTC after we open the table and save it. We already saw in SQL server that the user that is blocking is the user itself. We don’t have any idea why this is happening.
2. The other strange behavior is related with object changes, if I had a new field to a table or code somewhere else, I see it reflect on the development environment but on the RTC no. for example we had a field to a table save it but when we run a process that is using the new filed and we get the error of a unexpected SQL error, invalid column Name ‘new column’ statement could not be prepared. Other situation is add a new code to a codeunit, save it, but when run the codeunit the RTC ignores the new lines. If I make the debug I can see the code on the debug window but it will never run the new code, passes by it like it does not exist. I have to restart the services then make the changes and then all service instances can see the modifications, then for period of time all works fine but after some time it happens again.
Anyone already have experience this beahviours?
Thanks in advance,
We have a production environment, NAV 2013 R2 build 38455, with one service plus four instances of that service on the same server. The main service is where the users connect to NAV, then I have on instance for webservices, other instance for run NAS and the other two instances where we are running two stores of LS Retail add on.
We are having two problems:
1. Sometimes when the first user in the morning tries to connect to RTC get the error that the table user personalization is blocked by other user and it is only possible to connect with RTC after we open the table and save it. We already saw in SQL server that the user that is blocking is the user itself. We don’t have any idea why this is happening.
2. The other strange behavior is related with object changes, if I had a new field to a table or code somewhere else, I see it reflect on the development environment but on the RTC no. for example we had a field to a table save it but when we run a process that is using the new filed and we get the error of a unexpected SQL error, invalid column Name ‘new column’ statement could not be prepared. Other situation is add a new code to a codeunit, save it, but when run the codeunit the RTC ignores the new lines. If I make the debug I can see the code on the debug window but it will never run the new code, passes by it like it does not exist. I have to restart the services then make the changes and then all service instances can see the modifications, then for period of time all works fine but after some time it happens again.
Anyone already have experience this beahviours?
Thanks in advance,
===============
Nuno Silva
Nuno Silva
0