Question

9
Replies
4209
Views
sabaf985 Member since 2013 9 posts
Cognizant Technology Solutions
Posted: 4 years ago
Last activity: 4 years ago
Closed
Solved

Getting File not found exception while Parsing excel file

Hi All,

 

I am uploading the excel file using file path control and trying to parse it using OOTB activity MSOParseExcelFile. I am getting File not found exception while Parsing excel file.

 

Also the pyFileUpload property is not being populated in pxRequestor Page. So I am hardcoding path and passing it as a parameter to MSOParseExcelFile activity, but still getting the below error in logs.

 

2016-08-09 13:24:32,305 [-bio-8080-exec-19751] [dalProcess] [ ] [ FXMM:01.01.01] (rseExcelFile._baseclass.Action) ERROR pegacloud.io|ip-10-123-0-55.eu-west-1.compute.internal - java.io.FileNotFoundException: file://default:/Users/584539/Desktop/TestingExportData1.xlsx

2016-08-09 13:24:32,306 [-bio-8080-exec-19751] [dalProcess] [ ] [ FXMM:01.01.01] (rseExcelFile._baseclass.Action) ERROR pegacloud.io|ip-10-123-0-55.eu-west-1.compute.internal - Error in parsing Excel file C:\Users\584539\Desktop\TestingExportData1.xlsx

 

Error in Tracer : Getting the below error message in tracer The uploaded file template could not be recognized. Please upload a valid file. Refer to template OpInfo_tmp1 for details.

 

The uploaded file is same as template but still getting the error.

 

Please help. Thanks In Advance.

***Updated by moderator: Lochan to add Category***

Data Integration
Moderation Team has archived post
Share this page LinkedIn