JSON ERROR EXPORTING PROCESS AND FLOWS

[platypus40]

Error description

I tried to export JSON files but openLCA threw an error.

Steps to reproduce

1. Open database
2. Export JSON-LD
3. Choose respective processes, flows, and give a name to exported file.

Attached files

• example database 3.11 ecoinvent
• screen shots

• ...

openLCA error message

Failed to export data sets

Installation details

• openLCA version: 2.5.0
• operating system: Windows 11
• os architecture: amd64
• os version: 10.0
• native libraries loaded: false
• with sparse matrix support: false

Full error stack trace

java.lang.reflect.InvocationTargetException
	at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:395)
	at org.eclipse.jface.wizard.WizardDialog.run(WizardDialog.java:1035)
	at org.openlca.app.wizards.io.JsonExportWizard.performFinish(JsonExportWizard.java:70)
	at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:837)
	at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:474)
	at org.eclipse.jface.dialogs.Dialog.lambda$0(Dialog.java:615)
	at org.eclipse.swt.events.SelectionListener$1.widgetSelected(SelectionListener.java:83)
	at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:286)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:91)
	at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4338)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1214)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4136)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3724)
	at org.eclipse.jface.window.Window.runEventLoop(Window.java:823)
	at org.eclipse.jface.window.Window.open(Window.java:799)
	at org.eclipse.ui.internal.handlers.WizardHandler$Export.executeHandler(WizardHandler.java:104)
	at org.eclipse.ui.internal.handlers.WizardHandler.execute(WizardHandler.java:279)
	at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:277)
	at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:98)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:56)
	at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:299)
	at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:233)
	at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:174)
	at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:165)
	at org.eclipse.core.commands.Command.executeWithChecks(Command.java:488)
	at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:485)
	at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:204)
	at org.eclipse.ui.internal.handlers.LegacyHandlerService.executeCommand(LegacyHandlerService.java:385)
	at org.eclipse.ui.internal.handlers.LegacyHandlerService.executeCommand(LegacyHandlerService.java:362)
	at org.openlca.app.navigation.actions.ExportAction.run(ExportAction.java:51)
	at org.eclipse.jface.action.Action.runWithEvent(Action.java:474)
	at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:581)
	at org.eclipse.jface.action.ActionContributionItem.lambda$4(ActionContributionItem.java:415)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:91)
	at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4338)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1214)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4136)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3724)
	at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1151)
	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:339)
	at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1042)
	at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:153)
	at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:678)
	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:339)
	at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:583)
	at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:173)
	at org.openlca.app.rcp.RcpApplication.start(RcpApplication.java:13)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:219)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:149)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:115)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:467)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:298)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:627)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:575)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1431)
Caused by: org.openlca.expressions.TokenMgrError: Lexical error at line 1, column 11.  Encountered: "\'" (39), after : ""
	at org.openlca.expressions.FormulaParserTokenManager.getNextToken(FormulaParserTokenManager.java:611)
	at org.openlca.expressions.FormulaParser.jj_ntk(FormulaParser.java:598)
	at org.openlca.expressions.FormulaParser.unary(FormulaParser.java:279)
	at org.openlca.expressions.FormulaParser.power(FormulaParser.java:259)
	at org.openlca.expressions.FormulaParser.term(FormulaParser.java:211)
	at org.openlca.expressions.FormulaParser.realsum(FormulaParser.java:175)
	at org.openlca.expressions.FormulaParser.compare(FormulaParser.java:152)
	at org.openlca.expressions.FormulaParser.logicalAnd(FormulaParser.java:92)
	at org.openlca.expressions.FormulaParser.logicalXor(FormulaParser.java:72)
	at org.openlca.expressions.FormulaParser.logicalOr(FormulaParser.java:52)
	at org.openlca.expressions.FormulaParser.expand(FormulaParser.java:46)
	at org.openlca.expressions.FormulaParser.function(FormulaParser.java:374)
	at org.openlca.expressions.FormulaParser.element(FormulaParser.java:337)
	at org.openlca.expressions.FormulaParser.unary(FormulaParser.java:307)
	at org.openlca.expressions.FormulaParser.power(FormulaParser.java:259)
	at org.openlca.expressions.FormulaParser.term(FormulaParser.java:211)
	at org.openlca.expressions.FormulaParser.realsum(FormulaParser.java:175)
	at org.openlca.expressions.FormulaParser.compare(FormulaParser.java:112)
	at org.openlca.expressions.FormulaParser.logicalAnd(FormulaParser.java:92)
	at org.openlca.expressions.FormulaParser.logicalXor(FormulaParser.java:72)
	at org.openlca.expressions.FormulaParser.logicalOr(FormulaParser.java:52)
	at org.openlca.expressions.FormulaParser.expand(FormulaParser.java:46)
	at org.openlca.expressions.FormulaParser.parse(FormulaParser.java:41)
	at org.openlca.util.Formula.getVariables(Formula.java:24)
	at org.openlca.jsonld.output.GlobalParameters.sync(GlobalParameters.java:74)
	at org.openlca.jsonld.output.ProcessWriter.write(ProcessWriter.java:38)
	at org.openlca.jsonld.output.ProcessWriter.write(ProcessWriter.java:15)
	at org.openlca.jsonld.output.JsonExport.writeNext(JsonExport.java:256)
	at org.openlca.jsonld.output.JsonExport.write(JsonExport.java:211)
	at org.openlca.app.wizards.io.JsonExportWizard$Export.doExport(JsonExportWizard.java:146)
	at org.openlca.app.wizards.io.JsonExportWizard$Export.doExport(JsonExportWizard.java:113)
	at org.openlca.app.wizards.io.JsonExportWizard$Export.run(JsonExportWizard.java:95)
	at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:123)

[msrocka]

Thank you for reporting this. I think it is related to this issue: #146

You have an error in a formula. When you run a database validation you should find in which one.