Excel Export Issue

asMTZ
Member Posts: 1
Hi All,
for context am using Microsoft Dynamics NAV 2017
am currently diagnosing an issue with one machine that fails to export an item ledger entry to excel
here is the basic issue
when we try to export few lines to excel it exports with no issues
as soon as the lines grows to be a lot it fails with an error message
"The server "DynamicsNAV100" was unable to process the request. The application will close."
I checked the event viewer and i saw the following stack trace and this is a part of it
Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavServerSessionException
Message: <ii>The server "DynamicsNAV100" was unable to process the request. The application will close.</ii>
HResult: -2146233088
Type: System.IO.DirectoryNotFoundException
Message: <ii>Could not find a part of the path '2wajcwyn.szn'.</ii>
StackTrace:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
what i gathered from this that it tried to find a file using the hint of the error (Could not find a part of the path '2wajcwyn.szn')
but i have no complete path to look for.
What I did is the following
* Increased the line limit for the records to be exported in clientUserConfiguration file
* Checked with different Known working user on different machine
* fully repaired both NAV/office
* Install excel add in component
* cleared temp
all with no result, so that led me that the issue is with something related to the configuration with the machine
I reach to a dead end and i have no clue where to go next or where to check
your help is much appreciated
for context am using Microsoft Dynamics NAV 2017
am currently diagnosing an issue with one machine that fails to export an item ledger entry to excel
here is the basic issue
when we try to export few lines to excel it exports with no issues
as soon as the lines grows to be a lot it fails with an error message
"The server "DynamicsNAV100" was unable to process the request. The application will close."
I checked the event viewer and i saw the following stack trace and this is a part of it
Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavServerSessionException
Message: <ii>The server "DynamicsNAV100" was unable to process the request. The application will close.</ii>
HResult: -2146233088
Type: System.IO.DirectoryNotFoundException
Message: <ii>Could not find a part of the path '2wajcwyn.szn'.</ii>
StackTrace:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
what i gathered from this that it tried to find a file using the hint of the error (Could not find a part of the path '2wajcwyn.szn')
but i have no complete path to look for.
What I did is the following
* Increased the line limit for the records to be exported in clientUserConfiguration file
* Checked with different Known working user on different machine
* fully repaired both NAV/office
* Install excel add in component
* cleared temp
all with no result, so that led me that the issue is with something related to the configuration with the machine
I reach to a dead end and i have no clue where to go next or where to check
your help is much appreciated
0
Answers
-
I would guess that file is a temp file which gets stored either in the system's TEMP folder or in a folder in ProgramData (something like C:\ProgramData\Microsoft\Microsoft Dynamics NAV\100\Server ...)
And I would guess that your antivirus is blocking the file.0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions