Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 298 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
NAS Automatic Restart
jelittlejohn
Member Posts: 61
Hi,
I searched the forum on this topic and found one thread but it did not solve my problem. I am hoping that if I bring this topic back up and provide a few extra details, someone can help me. My client is running NAV SQL client and I have NAS running on the same server with the SQL data. Every 30 minutes, NAS goes out and pulls in some data from an independent database and writes that data to a few fields in the Purchase Header and Purchase Line tables. Also, each evening, between 8:00 and 8:30, NAS runs a couple of reports, creates pdf files of these reports using the Bullzip pdf creator and then emails these pdf files to a few people using the smtp codeunit. All of this works great. However, whenever the server is rebooted, NAS does not restart properly. We have had a few hard shutdowns due to some weather related power problems and we have had some scheduled server reboots, but the result are the same. NAS appears to be started but it does not execute any of its tasks. NAS is logging on as the server administrator and is set to retry every 30 seconds on an error. I have looked at the event log. On the reboot, I see an error, generally "Database not valid" or something with connectivity issues, that always suggests that the NAS service is trying to start before the SQL service has completely started. 30 seconds later, NAS does retry and it appears to start properly. However, it will not perform it's tasks correctly until a manual restart of the service is done.
Does anyone have any experience with this issue? Any help would be greatly appreciated. I feel that if I could delay the start of the NAS service until all other services are started, it would work but I don't know how to make that happen.
Thanks in advance!
I searched the forum on this topic and found one thread but it did not solve my problem. I am hoping that if I bring this topic back up and provide a few extra details, someone can help me. My client is running NAV SQL client and I have NAS running on the same server with the SQL data. Every 30 minutes, NAS goes out and pulls in some data from an independent database and writes that data to a few fields in the Purchase Header and Purchase Line tables. Also, each evening, between 8:00 and 8:30, NAS runs a couple of reports, creates pdf files of these reports using the Bullzip pdf creator and then emails these pdf files to a few people using the smtp codeunit. All of this works great. However, whenever the server is rebooted, NAS does not restart properly. We have had a few hard shutdowns due to some weather related power problems and we have had some scheduled server reboots, but the result are the same. NAS appears to be started but it does not execute any of its tasks. NAS is logging on as the server administrator and is set to retry every 30 seconds on an error. I have looked at the event log. On the reboot, I see an error, generally "Database not valid" or something with connectivity issues, that always suggests that the NAS service is trying to start before the SQL service has completely started. 30 seconds later, NAS does retry and it appears to start properly. However, it will not perform it's tasks correctly until a manual restart of the service is done.
Does anyone have any experience with this issue? Any help would be greatly appreciated. I feel that if I could delay the start of the NAS service until all other services are started, it would work but I don't know how to make that happen.
Thanks in advance!
Jack Littlejohn
Clemson, SC
Clemson, SC
0
Comments
Please let us know if it works, as this might be useful someday.