Error exporting to Excel - olca 2.0 Beta

Question

Hi,

Running a simple system, exporting to Excel yields an error:

20:11:51	ERROR	org.openlca.io.xls.results.system.ResultExport	Error exporting results
java.lang.ArrayIndexOutOfBoundsException: Index -13020 out of bounds for length 51437     at gnu.trove.map.hash.TIntObjectHashMap.rehash(TIntObjectHashMap.java:165)     at gnu.trove.impl.hash.THash.postInsertHook(THash.java:388)     at gnu.trove.map.hash.TIntObjectHashMap.doPut(TIntObjectHashMap.java:248)     at gnu.trove.map.hash.TIntObjectHashMap.put(TIntObjectHashMap.java:222)     at org.openlca.core.results.providers.FactorizationSolver.totalFlowsOfOne(FactorizationSolver.java:215)     at org.openlca.core.results.providers.ResultProvider.totalFlowOfOne(ResultProvider.java:331)     at org.openlca.core.results.providers.ResultProvider.totalFlowOf(ResultProvider.java:360)     at org.openlca.core.results.LcaResult.lambda$getTotalFlowOf$14(LcaResult.java:231)     at org.openlca.core.results.LcaResult.enviViewOf(LcaResult.java:537)     at org.openlca.core.results.LcaResult.getTotalFlowOf(LcaResult.java:230)     at org.openlca.io.xls.results.system.ProcessFlowUpstreamSheet.getValue(ProcessFlowUpstreamSheet.java:38)     at org.openlca.io.xls.results.system.ProcessFlowUpstreamSheet.getValue(ProcessFlowUpstreamSheet.java:11)     at org.openlca.io.xls.results.system.ContributionSheet.data(ContributionSheet.java:45)     at org.openlca.io.xls.results.system.ProcessFlowUpstreamSheet.write(ProcessFlowUpstreamSheet.java:33)     at org.openlca.io.xls.results.system.ProcessFlowUpstreamSheet.write(ProcessFlowUpstreamSheet.java:19)     at org.openlca.io.xls.results.system.ResultExport.writeUpstreamSheets(ResultExport.java:98)     at org.openlca.io.xls.results.system.ResultExport.run(ResultExport.java:77)     at org.openlca.app.WrappedJob.run(WrappedJob.java:30)     at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

The Out of bounds Exceptions seems to be the culprit, but google didn't help me solve the issue.

Similarily I'd like to just export this to a .csv or something without the bounds of Excel.

Do some of you know a workaround?

Comments

Do anyone experience similar issues using openLCA 2.0 beta? It seems like a quite important flaw at this point. However, considering it is a beta, it might be under development. I am just confused on whether the error stems from my setup, as the beta has been described to be very close to release for almost a year at the time of writing. (I think!)

How to approach this?

---

I could not reproduce this yet. Is it possible to share your database with this error? There is another issue with the Excel export that we need to fix but this is something different.

---

looking further at it. My setup of olca 2.0 beta does not even print to the Report feature... I do not know if these two issues are related.

Can someone using olca 2.0 beta confirm/reject if they can:
1) print a report from a project
2) export to excel from a project.

Would be helpful, thanks

---

msrocka, my appologies, i overlooked your reply.

I would love to share my database with you. How do I do that?

I use ecoinvent 3.7 cutoff unit regionalized 20201005 at this moment, as I do not have funds for newer LCI databases. It's for research.

---

Hi msrocka, how can I share my database with you?