Excel Export Issue

asMTZ

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

vaprog

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.