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
- 305 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
NAV Kill Process Issues
Big_D
Member Posts: 207
Hi Mibuso.com World - hope all well 
!
Wrote a routine in NAV that kills idle user processors if they surpass an hour of inactivity. One admin user logs in and runs this routine under a job queue (in NAV Client not a NAS routine). This routine works great 99% of the time but every now and again the admin user gets the error...
This message is for C/AL programmers:
The call to member Execute failed. Microsoft OLE DB Provider for SQL Server returned the following message:
User does not have permission to use the KILL statement.
The User resets the Job Queue and it works perfectly again until the above error happens again! This routine runs for weeks with no problems and then the above happens - any suggestions?
With thanks
!Wrote a routine in NAV that kills idle user processors if they surpass an hour of inactivity. One admin user logs in and runs this routine under a job queue (in NAV Client not a NAS routine). This routine works great 99% of the time but every now and again the admin user gets the error...
This message is for C/AL programmers:
The call to member Execute failed. Microsoft OLE DB Provider for SQL Server returned the following message:
User does not have permission to use the KILL statement.
The User resets the Job Queue and it works perfectly again until the above error happens again! This routine runs for weeks with no problems and then the above happens - any suggestions?
With thanks
Big D signing off!
0
Comments
The routine isn't using NAS or an additional user - as I customised the routine to run the Job Queue when the admin user logs into the NAV client.
With thanks