Excel Export not Working

1
Hi, currently my Excel export does not work in 9.18.2   It used to work fine, however, the error does not indicate to me what specifically is wrong except that Expected response body to be JSON. Instead received: ""   ActionManager: Error in execution of monitored action 'RegularClientAction' (execution id: 1673342058746-69, execution type: CLIENT)   M2EE: An unhandled error occurred in the MxRuntime.   Client: An error occurred while executing an action of Finance.Tax_Overview.actionButton8: Expected response body to be JSON. Instead received: "" Error: An error occurred while executing an action of Finance.Tax_Overview.actionButton8: Expected response body to be JSON. Instead received: ""     at http://localhost:8080/mxclientsystem/mxui/mxui.js?638089458880920050:68:147886     at we (http://localhost:8080/mxclientsystem/mxui/mxui.js?638089458880920050:24:6501)     at i (http://localhost:8080/mxclientsystem/mxui/mxui.js?638089458880920050:24:6402)     at x (http://localhost:8080/mxclientsystem/mxui/mxui.js?638089458880920050:66:5472)
asked
2 answers
2

The actual error turned out to be a java.lang.NoSuchMethodError: org.apache.commons.io.IOUtils.byteArray(I)[B] error. 

 

Such an error is related to conflicting Java libraries (between org.apache.commons.io-2.3.0.jar and commons-io.commons-io-2.11.0.jar). Removing the former resolved the issue.

 

Likely, this caused an action to fail, and therefore, no JSON was generated from the export, causing the error Morne mentioned. 

answered
-1

Might be an issue with the security in your app. You need to debug the flow creating the excel export to see if the data is present. If it is present in the microflow then you’ll need to debug the java code to see what is going wrong. See https://docs.mendix.com/howto/monitoring-troubleshooting/debug-java-actions/

Another option could be to create a second export for a simple record that you are sure the user has access to the data. This way you can verify that it is not an issue with the java code itself but rather with the data.

answered