We had one WFE server and upgraded to 2 WFE servers with a load balancer. We are using the SharePoint Server Standard edition. Because we are using the Standard edition and do not have access to BI webparts we needed a workaround to pull data from an excel file.
Users upload a daily excel file to a document library with some data. The custom webpart saves this excel spreadsheet to the C drive on the server and then displays the data.
Ever since we moved to the new servers the data is not being loaded from the excel file on the C drive. Could this be a security issue? I copied the code over to our development environment and it worked perfectly. I can't figure out how to trouble shoot this. Any help would be greatly appreciated.