Excel Import or Export is not working

0
Hi All, When i try to either import the data or export the data , Data is not getting exported. So when i debugged this it is going till Generate Excel document java activity and after this it is niether going in a true path nor in the error handling part. It is not even throwing error, in some places it is just throwing an error as "An error occured Contact your system administrator". but if i see logs there is no any log messages i see. As any one faced same issue earlier if yes please let me know what i should do for this.My Menidx Version is 10.18.9 and i am using Export Moudule of version V8.0.0
asked
2 answers
0

This looks less like an issue in your microflow logic and more like a problem with the Excel module version or one of its dependencies.


You are on Mendix 10.18.9 and using Excel Exporter 8.0.0. The first thing I would check is whether that module version is fully compatible with your Mendix version. If the module is older or not aligned with your runtime version, it can fail inside the Java action without giving a very clear business error.


I would also check the Console and Runtime log levels more closely. Set the relevant log nodes, especially for the Excel module and Connector, to Trace or Debug and run it again. If execution stops around Generate Excel document, the real exception is often only visible in detailed runtime logs.


Another thing to verify is whether all required dependencies are present and up to date in userlib. If there are missing, duplicated, or incompatible .jar files, Java actions can fail silently or behave unexpectedly. This is especially worth checking if the issue started after a module upgrade or project merge.


It is also a good idea to re-download the Excel Importer/Exporter module from the Marketplace and replace the existing one cleanly. Sometimes the module itself is fine, but the local project has outdated files or broken dependencies left over from an earlier version.


So I would start with three checks: confirm module compatibility with Mendix 10.18.9, increase runtime logging, and verify the userlib dependencies. In many cases, one of these turns out to be the root cause.


If this resolves your issue, please mark it as accepted.

answered
0

Dear Prajwal Bharadwaj A


While executing the Generate Excel Document Java action, the microflow appears to be failing. This could be due to the following reasons:


  1. Ensure that the FileDocument object is committed before generating the Excel file.
  2. Verify that all configurations in the Excel Export setup are correctly defined.


To identify the exact issue, add an error handler to the Generate Excel Document Java action. This will help capture the actual error and make troubleshooting easier.



If you find this answer helpful, kindly consider marking it as accepted.


answered