Excel Exporter error, removing duplicate Jarfiles does not resolve issue

0
I’m getting the following error when trying to export excel file: An error occurred while executing an action of Hub.Order_Overview.actionButton5: Expected response body to be JSON. Instead received: "" Error: An error occurred while executing an action of Hub.Order_Overview.actionButton5: Expected response body to be JSON. Instead received: ""     at http://localhost:8080/mxclientsystem/mxui/mxui.js?638155302416729430:68:147886     at we (http://localhost:8080/mxclientsystem/mxui/mxui.js?638155302416729430:24:6501)     at i (http://localhost:8080/mxclientsystem/mxui/mxui.js?638155302416729430:24:6402)     at x (http://localhost:8080/mxclientsystem/mxui/mxui.js?638155302416729430:66:5472)   I’ve removed duplicate commons-io and poi jar files and this still keeps happening. At this point I don’t know what can solve this issue. This is the only Excel related module in the project.        
asked
6 answers
2

The Latest Excel Exporter Module is having poi 5.2.2 version libraries, Replacing all poi libraries with the poi  4.1.2 version will solve the issue. 

answered
1

This has nothing to do with Jars. Clean the deployment Directory and check the security.

answered
1

There is still some duplicate jar in your images. Removed them one by one and it should work. 

answered
1

We recently upgrade one of our apps from Mendix 8.18 to 9.23 and had similar issue. What worked for us was to delete all .jar files from Project-main\userlib and from Project-main\deployment\model\lib\userlib, then upgrade all marketplace modules again.We recently upgrade one of our apps from Mendix 8.18 to 9.23 and had similar issue. What worked for us was to delete all .jar files from Project-main\userlib and from Project-main\deployment\model\lib\userlib, then upgrade all marketplace modules again.

answered
1

Had the same issue, Excel exporter V7.4.1.

 

In my userlib folder there were the following conflicting files:

 

  • org.apache.poi.poi-5.2.2 conflicting with poi.5.2.5.jar 
  • org.apache.poi.poi-ooxml-5.2.2 conflicting with poi-ooxml-5.2.2
  • org.apache.poi.poi-ooxml-lite-5.2.2 conflicting poi-ooxml-lite-5.2.5

A bit difficult to spot, but disable one of each and thats working (no need to go back to version 4.1.2 of the poi files)

answered
0

I've been trying for many tens of hours and cannot resolve the conflicts.  My userlib only has the 5.2.2 poi jars.  I've used the userlib-cleaner to remove any duplicates.  I've removed and reinstalled Excel Importer and Exporter.  No joy.

If I debug GeneralExcelDoc then it fails during ExportExcel because it can't find import org.apache.poi.xssf.usermodel.XSSFWorkbook.

The only thing I can see is that vendorlib has the poi jar files with version 5.4.0.  Could they be interfering?

Thanks so much for any advice.

Al

answered