In our application, we get an excel file from external system in a mapped folder. PRPC has read/write access to this folder. We need to parse this excel file and load the data onto the workpage. We are using MSOParseExcelFile OOB activity for this.

However, we observed that the activity works if the file is in service export folder and not when in any other folder.

The java step in the activity logs an error when we use a folder other than service export path.

java.io.FileNotFoundException: file://default:/opt/ABC/shared/report/AA-2670_Report.xlsx

When we pass following file name to the activity -

/opt/ABC/shared/report/AA-2670_Report.xlsx

But in the logs, Pega prints the filename by prepending it with "file://default:"

Has anybody come across this issue? Is there a different way to pass the file name when it exists on a mapped folder?

Your help in resolving the issue is highly appreciated.

Thanks in advance.

Dev

***Updated by moderator: Lochan. Removed user added Ask the Expert tag. Apologies for confusion, shouldn't have been an end-user option.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.