Microsoft Dynamics NAV (Archived)

Excel Buffer | Could not find a part of the path

(0) Share

Report

Posted on by subrata.bauri

1,144

Dear All,

An Enduser is facing the below error message during execution of Export To Excel Report in NAV 2016.

Microsoft Dynamics NAV
---------------------------

A call to Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.WorkbookWriter.Create failed with this message: Could not find a part of the path
'C:\ProgramData\Microsoft\Microsoft Dynamics NAV\90\Server\MicrosoftDynamicsNavServer$DynamicsNAV90\
users\default\Woods\TEMP\__TEMP__589ed7d71b1c4d29b30f4815e1a78ac2.tmp.xlsx'.
---------------------------
OK
---------------------------

How to solve it ?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Andrey Baludin 3,941 on at

Like (0)

Report

RE: Excel Buffer | Could not find a part of the path

1. Check that your dotnet variables has RunOnClient property = yes

2. Check that your user has an access to Microsoft Dynamics NAV folder

Was this reply helpful? Yes No
subrata.bauri 1,144 on at

Like (0)

Report

RE: Excel Buffer | Could not find a part of the path

I'm not using dotnet variables, using Excel Buffer.

NavUserPassword Credential is used in the NAV Instance. RemoteUser are not to able execute the report.

Was this reply helpful? Yes No
Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: Excel Buffer | Could not find a part of the path

Is it a custom export or the standard one? It seems that NAV is searching for a temporary file at Server side.NAV code is executed at Server side, so if you create a temporary file on the client you’ve to upload to the server.

Was this reply helpful? Yes No
subrata.bauri 1,144 on at

Like (0)

Report

RE: Excel Buffer | Could not find a part of the path

Facing the same problem while executing base Report called "Trial Balance", Report ID : 6.

Was this reply helpful? Yes No
subrata.bauri 1,144 on at

Like (0)

Report

RE: Excel Buffer | Could not find a part of the path

@Andrey Baludin

Thanks for your reply.

All dot net variables have RunOnClient property = yes in Excel Buffer Table.

But when Users are trying to execute the export to excel report built on Excel Buffer, the generated excel file is trying to find the path in the NAV Server instead of Local Temp path.

Was this reply helpful? Yes No
Suggested answer

Zaid Tariq 2,274 on at

Like (0)

Report

RE: Excel Buffer | Could not find a part of the path

Hi,

The reason could be, you are referring to the temp path at server. Use the client temp path instead.

Was this reply helpful? Yes No
subrata.bauri 1,144 on at

Like (0)

Report

RE: Excel Buffer | Could not find a part of the path

Hi Zaid,

I'm not referring anything anywhere in the reports which are built on Excel Buffer table. Few clients are able to execute & few does not.

Was this reply helpful? Yes No
subrata.bauri 1,144 on at

Like (0)

Report

RE: Excel Buffer | Could not find a part of the path

The problem has been solved.

The problem was in the Excel Buffer Table.

Now Every Users are able to execute as per last information received from the client Site.

Thanks to everybody for their Time.

Was this reply helpful? Yes No
MuniKam 5 on at

Like (0)

Report

RE: Excel Buffer | Could not find a part of the path

What was the issue in the Excel Buffer table and how did you resolve it?

Was this reply helpful? Yes No