DPR-ERR-2082 error while using excel file as external datasource via "Manage External Data" functionality in Report Studio
While selecting a excel file as the external data file in Report Studio 10.1 user gets the following error:
"DPR-ERR-2082 An error has occurred.Please contact your administrator.The complete error has been logged by CAF with SecureID:2011-07-21-18:01:16.595-#99"
(Refer "Error_External_Data.JPG" for the error screenshot)
cogserver.log does not show any specific error.
1. Some of the columns in the Excel file do not have headings.
2. Corrupt Excel file.
Resolving the problem
1. If some of the columns in the Excel file do not have headings then put the headings for the corresponding columns.
2. If all the columns have headings then create a new Excel file to be used as external data source.