This article describes, how to do troubleshooting for Excel sheet upload in Enspire application.


Below are prerequisite need to check if excel uploading has any issues.


  • First enable to Error log from system utilities for respective module, so that you can find exact issue.

       

  • Check the Excel connecting string in system utility. 

[Note: The connecting should be like below]

For Excel lower than 2007 (.xls): Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}; Extended Properties='Excel 8.0;HDR={1}'

For Excel 2007 and above (.xlsx) : Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}; Extended Properties='Excel 8.0;HDR={1}'



  • Check MS Office licensed version is installed or not in server. 
  • Check MS Office has logged in with proper Microsoft credential.


If the above steps are fine and still you are facing issue in excel upload.. check the LOG folder inside API folder, If any programming related issue is there contact technical team.


If error log found like below


  1. System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)). 
  2. Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
  3. Assembly 'Microsoft.Office.Interop.Excel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' uses 'office, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' which has a higher version than referenced assembly 'office, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'
  4. OR there is no error but still the loader is loading continuously



If any of above error found then please follow the below steps.


Solution-1 :


  1. Start
  2. Run
  3. mmc -32
  4. File
  5. Add Remove Snap-in
  6. Component Services
  7. Add
  8. OK
  9. Console Root
  10. Component Services
  11. Computers
  12. My Computer
  13. DCOM Config
  14. Microsoft Excel Application -> Right click -> Properties
  15. On Security tab, give full permissions to the domain user/IIS_User.
  16. On Identiy tab -> change to Interactive User


Solution-2 : 

    

            1. Go to IIS-> Application Pool

            2. Select Advance Setting

            3. Configure the "Enable 32 bit application" as TRUE.

            4. Configure the "Identity" as ApplicationPoolIndentity.

Solution-3 :

  1. Start
  2. Run
  3. mmc -32
  4. File
  5. Add Remove Snap-in
  6. Component Services
  7. Add
  8. OK
  9. Console Root
  10. Component Services
  11. Computers
  12. My Computer
  13. DCOM Config
  14. Microsoft Excel Application -> Right click -> Properties
  15. Location
  16. Checkbox the Run application on the computer where the data is located and Run application on this computer.     


Please find the below screenshot for your reference.