OPC-DA Handler

Martin Schmid
Posts: 34
Joined: Fri Aug 15, 2014 5:22 pm

Re: OPC-DA Handler

Post by Martin Schmid » Fri Aug 22, 2014 8:07 am

Verified that putting

Code: Select all

["\\.\PVR-WRS-1\'I_DC_1.1'", 'FLOAT']
does not work.

Stack trace
(after clicking on show data)

Code: Select all

32369 ERROR StandardExecutor  - Could not add query 'SELECT * FROM System.renamed_output;' - de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQuery(StandardExecutor.java:637) 
de.uniol.inf.is.odysseus.core.server.planmanagement.QueryParseException: de.uniol.inf.is.odysseus.core.sdf.schema.SDFExpressionParseException: de.uniol.inf.is.odysseus.mep.impl.TokenMgrError: Lexical error at line 1, column 16.  Encountered: "\\" (92), after : ""
	at de.uniol.inf.is.odysseus.parser.cql.CQLParser.visit(CQLParser.java:359)
	at de.uniol.inf.is.odysseus.parser.cql.parser.ASTSelectStatement.jjtAccept(ASTSelectStatement.java:36)
	at de.uniol.inf.is.odysseus.parser.cql.CQLParser.visit(CQLParser.java:213)
	at de.uniol.inf.is.odysseus.parser.cql.parser.ASTComplexSelectStatement.jjtAccept(ASTComplexSelectStatement.java:35)
	at de.uniol.inf.is.odysseus.parser.cql.CQLParser.visit(CQLParser.java:189)
	at de.uniol.inf.is.odysseus.parser.cql.parser.ASTPriorizedStatement.jjtAccept(ASTPriorizedStatement.java:36)
	at de.uniol.inf.is.odysseus.parser.cql.parser.SimpleNode.childrenAccept(SimpleNode.java:88)
	at de.uniol.inf.is.odysseus.parser.cql.CQLParser.visit(CQLParser.java:180)
	at de.uniol.inf.is.odysseus.parser.cql.CQLParser.parse(CQLParser.java:162)
	at de.uniol.inf.is.odysseus.parser.cql.CQLParser.parse(CQLParser.java:143)
	at de.uniol.inf.is.odysseus.planmanagement.compiler.standardcompiler.StandardCompiler.translateQuery(StandardCompiler.java:252)
	at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.createQueries(StandardExecutor.java:247)
	at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQuery(StandardExecutor.java:614)
	at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQuery(StandardExecutor.java:607)
	at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQuery(StandardExecutor.java:591)
	at de.uniol.inf.is.odysseus.rcp.viewer.stream.table.commands.SelectAllFromSource.createQueryToSelectAllDataFromSource(SelectAllFromSource.java:60)
	at de.uniol.inf.is.odysseus.rcp.viewer.stream.table.commands.SelectAllFromSource.execute(SelectAllFromSource.java:50)
	at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:293)
	at org.eclipse.core.commands.Command.executeWithChecks(Command.java:476)
	at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508)
	at org.eclipse.ui.internal.handlers.HandlerService.executeCommand(HandlerService.java:169)
	at org.eclipse.ui.internal.handlers.SlaveHandlerService.executeCommand(SlaveHandlerService.java:241)
	at org.eclipse.ui.internal.handlers.SlaveHandlerService.executeCommand(SlaveHandlerService.java:241)
	at org.eclipse.ui.menus.CommandContributionItem.handleWidgetSelection(CommandContributionItem.java:829)
	at org.eclipse.ui.menus.CommandContributionItem.access$19(CommandContributionItem.java:815)
	at org.eclipse.ui.menus.CommandContributionItem$5.handleEvent(CommandContributionItem.java:805)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3588)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3209)
	at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2701)
	at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2665)
	at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2499)
	at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:679)
	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
	at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:668)
	at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
	at de.uniol.inf.is.odysseus.product.studio.starter.OdysseusStudioApplication.start(OdysseusStudioApplication.java:68)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1410)
	at org.eclipse.equinox.launcher.Main.main(Main.java:1386)
Caused by: de.uniol.inf.is.odysseus.core.sdf.schema.SDFExpressionParseException: de.uniol.inf.is.odysseus.mep.impl.TokenMgrError: Lexical error at line 1, column 16.  Encountered: "\\" (92), after : ""
	at de.uniol.inf.is.odysseus.core.sdf.schema.SDFExpression.init(SDFExpression.java:214)
	at de.uniol.inf.is.odysseus.core.sdf.schema.SDFExpression.<init>(SDFExpression.java:85)
	at de.uniol.inf.is.odysseus.parser.cql.parser.transformation.CreateProjectionVisitor.visit(CreateProjectionVisitor.java:150)
	at de.uniol.inf.is.odysseus.parser.cql.parser.ASTSelectAll.jjtAccept(ASTSelectAll.java:36)
	at de.uniol.inf.is.odysseus.parser.cql.parser.transformation.CreateProjectionVisitor.visit(CreateProjectionVisitor.java:159)
	at de.uniol.inf.is.odysseus.parser.cql.parser.ASTRenamedExpression.jjtAccept(ASTRenamedExpression.java:36)
	at de.uniol.inf.is.odysseus.parser.cql.parser.SimpleNode.childrenAccept(SimpleNode.java:88)
	at de.uniol.inf.is.odysseus.parser.cql.parser.transformation.CreateProjectionVisitor.visit(CreateProjectionVisitor.java:87)
	at de.uniol.inf.is.odysseus.parser.cql.CQLParser.visit(CQLParser.java:311)
	... 50 more
Caused by: de.uniol.inf.is.odysseus.mep.impl.TokenMgrError: Lexical error at line 1, column 16.  Encountered: "\\" (92), after : ""
	at de.uniol.inf.is.odysseus.mep.impl.MEPImplTokenManager.getNextToken(MEPImplTokenManager.java:589)
	at de.uniol.inf.is.odysseus.mep.impl.MEPImpl.jj_scan_token(MEPImpl.java:1056)
	at de.uniol.inf.is.odysseus.mep.impl.MEPImpl.jj_3_1(MEPImpl.java:796)
	at de.uniol.inf.is.odysseus.mep.impl.MEPImpl.jj_2_1(MEPImpl.java:706)
	at de.uniol.inf.is.odysseus.mep.impl.MEPImpl.UnaryExpression(MEPImpl.java:57)
	at de.uniol.inf.is.odysseus.mep.impl.MEPImpl.PowExpression(MEPImpl.java:161)
	at de.uniol.inf.is.odysseus.mep.impl.MEPImpl.MultiplicativeExpression(MEPImpl.java:191)
	at de.uniol.inf.is.odysseus.mep.impl.MEPImpl.AdditiveExpression(MEPImpl.java:236)
	at de.uniol.inf.is.odysseus.mep.impl.MEPImpl.ComparisonExpression(MEPImpl.java:291)
	at de.uniol.inf.is.odysseus.mep.impl.MEPImpl.EqualityComparison(MEPImpl.java:341)
	at de.uniol.inf.is.odysseus.mep.impl.MEPImpl.AndExpression(MEPImpl.java:384)
	at de.uniol.inf.is.odysseus.mep.impl.MEPImpl.OrExpression(MEPImpl.java:425)
	at de.uniol.inf.is.odysseus.mep.impl.MEPImpl.Expression(MEPImpl.java:30)
	at de.uniol.inf.is.odysseus.mep.MEP.parse(MEP.java:217)
	at de.uniol.inf.is.odysseus.core.sdf.schema.SDFExpression.init(SDFExpression.java:209)
	... 58 more
de.uniol.inf.is.odysseus.core.sdf.schema.SDFExpressionParseException: de.uniol.inf.is.odysseus.mep.impl.TokenMgrError: Lexical error at line 1, column 16. Encountered: "\\" (92), after : "" is probably the relevant error.

Also tested the original script (where we access the tag without the single quotation marks (') ) and it runs flawlessly.

Thank you for your time,

MS

User avatar
Marco Grawunder
Posts: 272
Joined: Tue Jul 29, 2014 10:29 am
Location: Oldenburg, Germany
Contact:

Re: OPC-DA Handler

Post by Marco Grawunder » Fri Aug 22, 2014 8:33 am

We will change the handler and separate the output schema from the pathes to the values.

Martin Schmid
Posts: 34
Joined: Fri Aug 15, 2014 5:22 pm

Re: OPC-DA Handler

Post by Martin Schmid » Fri Aug 22, 2014 8:41 am

@Mr Kuka
....
In that case, Odysseus (or the transport handler) will push a new tuple into the processing graph each time an item referenced in the schema definition is changed in the OPC server. But be aware that the tuple will include the updated item value and the values of the other items that do not have changed. Thus, doing an aggregation like SUM or AVG might produce unexpected results.
Thanks for the input. However, in our case the problem is different, I'm not sure I made myself clear enough.

Each OPC Tag (e.g. ["\\.\PVR-WRS-1\'I_DC_1.1'", 'FLOAT']) should provide not a single value (which is afaik the case right now) but also should provide a timestamp and additional string values.

Reference:

http://support.ge-ip.com/support/index? ... cd06007d9c

Take a look at pic 2.

So in summary we do not only need the value from a tag, but also the timestamp and the level, status and validity, and thus far I don't see how we can access that data.

Any input will be most welcome.

MS

User avatar
ckuka
Posts: 35
Joined: Tue Jul 29, 2014 10:55 am
Location: Shanghai, P.R. China/中国上海
Contact:

Re: OPC-DA Handler

Post by ckuka » Fri Aug 22, 2014 8:56 am

Ok, I see. Right now this is not supported. However, it should not be that difficult. Give me 5 minutes.
kind regards / 祝好
Christian Kuka

User avatar
Marco Grawunder
Posts: 272
Joined: Tue Jul 29, 2014 10:29 am
Location: Oldenburg, Germany
Contact:

Re: OPC-DA Handler

Post by Marco Grawunder » Fri Aug 22, 2014 9:15 am

Attention. I changed the parameters of the handler! A new paramter path states the variable-pathes that should be read from the opc source and the schema defines the names and types of the attributes internal used in Odysseus and for further processing.

Code: Select all

#PARSER PQL
#RUNQUERY
output := ACCESS({
              source='OPC:Demo',
              wrapper='GenericPush',
              transport='opc-da',
              protocol='none',
              datahandler='Tuple',
              options=[
                ['host', 'x.x.x.x'],
                ['domain', 'none'],
                ['username', 'administrator'],
                ['password', 'xxxx'],
                ['progId','National Instruments.Variable Engine.1'],
                ['clsId','7EFA5AA7-3A85-4693-8561-4AC60CA09909'],
                ['path',"\\.\PVR-WRS-1\'I_DC_1.1';\\.\PVR-WRS-1\'I_DC_2.1';some other path"]
              ],
              schema=[
                ['attribute1', 'FLOAT'],
                ['attribute2', 'FLOAT'],
                ['attribute3', 'FLOAT']
              ]                                                                                
            }                                                                  
          )
To make it more easy to use, I created another operator:

Code: Select all

#ADDQUERY
output2 := OPCDASOURCE({
                progid = 'National Instruments.Variable Engine.1',
                paths = ["\\.\PVR-WRS-1\'I_DC_1.1'",
                             "\\.\PVR-WRS-1\'I_DC_2.1'",
                             "some other path"],
                clsid = '7EFA5AA7-3A85-4693-8561-4AC60CA09909',
                host = 'x.x.x.x',
                source = 'OPC:Demo2',
                username = 'administrator',
                password = 'xxx',
                domain = 'none',
                schema=[
                  ['attribute1', 'FLOAT'],
                  ['attribute2', 'FLOAT'],
                  ['attribute3', 'FLOAT']
                ]                             
              }                        
            )
I could not test it because of a missing OPC server. Would be great if you could and give me feedback :-)

Martin Schmid
Posts: 34
Joined: Fri Aug 15, 2014 5:22 pm

Re: OPC-DA Handler

Post by Martin Schmid » Fri Aug 22, 2014 11:06 am

Dear Dr. Grawunder,


so far I actually can't get this to work. Here's the script I'm using

Code: Select all

#PARSER PQL
#ADDQUERY
output2 := OPCDASOURCE({
                progid = 'National Instruments.Variable Engine.1',
                paths = ["\\.\PVR-WRS-1\'I_DC_1.1'",
                             "\\.\PVR-WRS-1\'I_DC_2.1'"],
                clsid = '7EFA5AA7-3A85-4693-8561-4AC60CA09909',
                host = 'x.x.x.x',
                source = 'OPC:Demo2',
                username = 'administrator',
                password = 'x',
                domain = 'none',
                schema=[
	                ['attribute1', 'FLOAT'],
	                ['attribute2', 'FLOAT']
                ]                             
              }                       
            )
and here's my stack trace:

Code: Select all

de.uniol.inf.is.odysseus.core.server.planmanagement.optimization.exception.QueryOptimizationException: de.uniol.inf.is.odysseus.core.server.planmanagement.optimization.exception.QueryOptimizationException: Exeception while initialize query.
Additional info:
transformation failed ; Error during transformation of Top@1362757648 OwnerIDs: 5
	at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQueries(StandardExecutor.java:464)
	at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQuery(StandardExecutor.java:618)
	at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQuery(StandardExecutor.java:607)
	at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQuery(StandardExecutor.java:591)
	at de.uniol.inf.is.odysseus.rcp.viewer.stream.table.commands.SelectAllFromSource.createQueryToSelectAllDataFromSource(SelectAllFromSource.java:70)
	at de.uniol.inf.is.odysseus.rcp.viewer.stream.table.commands.SelectAllFromSource.execute(SelectAllFromSource.java:53)
	at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:293)
	at org.eclipse.core.commands.Command.executeWithChecks(Command.java:476)
	at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508)
	at org.eclipse.ui.internal.handlers.HandlerService.executeCommand(HandlerService.java:169)
	at org.eclipse.ui.internal.handlers.SlaveHandlerService.executeCommand(SlaveHandlerService.java:241)
	at org.eclipse.ui.internal.handlers.SlaveHandlerService.executeCommand(SlaveHandlerService.java:241)
	at org.eclipse.ui.menus.CommandContributionItem.handleWidgetSelection(CommandContributionItem.java:829)
	at org.eclipse.ui.menus.CommandContributionItem.access$19(CommandContributionItem.java:815)
	at org.eclipse.ui.menus.CommandContributionItem$5.handleEvent(CommandContributionItem.java:805)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3588)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3209)
	at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2701)
	at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2665)
	at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2499)
	at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:679)
	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
	at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:668)
	at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
	at de.uniol.inf.is.odysseus.product.studio.starter.OdysseusStudioApplication.start(OdysseusStudioApplication.java:68)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1410)
	at org.eclipse.equinox.launcher.Main.main(Main.java:1386)
Caused by: de.uniol.inf.is.odysseus.core.server.planmanagement.optimization.exception.QueryOptimizationException: Exeception while initialize query.
Additional info:
transformation failed ; Error during transformation of Top@1362757648 OwnerIDs: 5
	at de.uniol.inf.is.odysseus.planmanagement.optimization.query.standardqueryoptimizer.StandardQueryOptimizer.optimizeQuery(StandardQueryOptimizer.java:167)
	at de.uniol.inf.is.odysseus.planmanagement.optimization.standardoptimizer.StandardOptimizer.optimize(StandardOptimizer.java:58)
	at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQueries(StandardExecutor.java:436)
	... 39 more
Caused by: de.uniol.inf.is.odysseus.core.server.planmanagement.TransformationException: transformation failed ; Error during transformation of Top@1362757648 OwnerIDs: 5
	at de.uniol.inf.is.odysseus.transform.engine.TransformationExecutor.transform(TransformationExecutor.java:90)
	at de.uniol.inf.is.odysseus.planmanagement.compiler.standardcompiler.StandardCompiler.transform(StandardCompiler.java:312)
	at de.uniol.inf.is.odysseus.planmanagement.optimization.query.standardqueryoptimizer.StandardQueryOptimizer.optimizeQuery(StandardQueryOptimizer.java:158)
	... 41 more
Is there an error in the syntax of the script?

Regards,

MS
Last edited by Martin Schmid on Mon Sep 29, 2014 11:49 am, edited 1 time in total.

User avatar
Marco Grawunder
Posts: 272
Joined: Tue Jul 29, 2014 10:29 am
Location: Oldenburg, Germany
Contact:

Re: OPC-DA Handler

Post by Marco Grawunder » Fri Aug 22, 2014 11:11 am

Which version of Odysseus do you use? If you use the downloaded version you must make an update.

This error states, that the operator (OPCDASource) could not be found.

Important: We made another change. The types of the schema must be OPCValue. OPCValue has function
value(attribute), timestamp(attribute), quality(attribute), error(attribute)

Currently, only double as type is supported but we will provider further types in the future.

Martin Schmid
Posts: 34
Joined: Fri Aug 15, 2014 5:22 pm

Re: OPC-DA Handler

Post by Martin Schmid » Fri Aug 22, 2014 11:51 am

There seems to be some problem with the update site atm.
Seems to be up and down, so I can't actually test the most recent version.

Will keep you informed ;)

User avatar
Marco Grawunder
Posts: 272
Joined: Tue Jul 29, 2014 10:29 am
Location: Oldenburg, Germany
Contact:

Re: OPC-DA Handler

Post by Marco Grawunder » Fri Aug 22, 2014 11:55 am

Yes ... I removed the autobuild function for the update site on any change again. So it should be less often not available :-)

Martin Schmid
Posts: 34
Joined: Fri Aug 15, 2014 5:22 pm

Re: OPC-DA Handler

Post by Martin Schmid » Fri Aug 22, 2014 11:59 am

Alright.

Definitely got the most recent version installed now.

Script:

Code: Select all

#PARSER PQL
#ADDQUERY
output2 := OPCDASOURCE({
                progid = 'National Instruments.Variable Engine.1',
                paths = ["\\.\PVR-WRS-1\'I_DC_1.1'",
                             "\\.\PVR-WRS-1\'I_DC_2.1'"],
                clsid = '7EFA5AA7-3A85-4693-8561-4AC60CA09909',
                host = 'x',
                source = 'OPC:Demo2',
                username = 'administrator',
                password = 'x',
                domain = 'none',
                schema=[
	                ['attribute1', 'OPCValue'],
	                ['attribute2', 'OPCValue']
                ]                             
              }                       
            )
However, I'm still getting "Unhandled event loop exception":

Code: Select all

null
Error
Fri Aug 22 11:56:02 CEST 2014
Unhandled event loop exception

de.uniol.inf.is.odysseus.core.server.planmanagement.optimization.exception.QueryOptimizationException: de.uniol.inf.is.odysseus.core.server.planmanagement.optimization.exception.QueryOptimizationException: Exeception while initialize query.
Additional info:
transformation failed ; Error during transformation of Top@1080894171 OwnerIDs: 1
	at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQueries(StandardExecutor.java:464)
	at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQuery(StandardExecutor.java:618)
	at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQuery(StandardExecutor.java:607)
	at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQuery(StandardExecutor.java:591)
	at de.uniol.inf.is.odysseus.rcp.viewer.stream.table.commands.SelectAllFromSource.createQueryToSelectAllDataFromSource(SelectAllFromSource.java:70)
	at de.uniol.inf.is.odysseus.rcp.viewer.stream.table.commands.SelectAllFromSource.execute(SelectAllFromSource.java:53)
	at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:293)
	at org.eclipse.core.commands.Command.executeWithChecks(Command.java:476)
	at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508)
	at org.eclipse.ui.internal.handlers.HandlerService.executeCommand(HandlerService.java:169)
	at org.eclipse.ui.internal.handlers.SlaveHandlerService.executeCommand(SlaveHandlerService.java:241)
	at org.eclipse.ui.internal.handlers.SlaveHandlerService.executeCommand(SlaveHandlerService.java:241)
	at org.eclipse.ui.menus.CommandContributionItem.handleWidgetSelection(CommandContributionItem.java:829)
	at org.eclipse.ui.menus.CommandContributionItem.access$19(CommandContributionItem.java:815)
	at org.eclipse.ui.menus.CommandContributionItem$5.handleEvent(CommandContributionItem.java:805)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3588)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3209)
	at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2701)
	at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2665)
	at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2499)
	at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:679)
	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
	at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:668)
	at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
	at de.uniol.inf.is.odysseus.product.studio.starter.OdysseusStudioApplication.start(OdysseusStudioApplication.java:68)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1410)
	at org.eclipse.equinox.launcher.Main.main(Main.java:1386)
Caused by: de.uniol.inf.is.odysseus.core.server.planmanagement.optimization.exception.QueryOptimizationException: Exeception while initialize query.
Additional info:
transformation failed ; Error during transformation of Top@1080894171 OwnerIDs: 1
	at de.uniol.inf.is.odysseus.planmanagement.optimization.query.standardqueryoptimizer.StandardQueryOptimizer.optimizeQuery(StandardQueryOptimizer.java:167)
	at de.uniol.inf.is.odysseus.planmanagement.optimization.standardoptimizer.StandardOptimizer.optimize(StandardOptimizer.java:58)
	at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQueries(StandardExecutor.java:436)
	... 39 more
Caused by: de.uniol.inf.is.odysseus.core.server.planmanagement.TransformationException: transformation failed ; Error during transformation of Top@1080894171 OwnerIDs: 1
	at de.uniol.inf.is.odysseus.transform.engine.TransformationExecutor.transform(TransformationExecutor.java:94)
	at de.uniol.inf.is.odysseus.planmanagement.compiler.standardcompiler.StandardCompiler.transform(StandardCompiler.java:312)
	at de.uniol.inf.is.odysseus.planmanagement.optimization.query.standardqueryoptimizer.StandardQueryOptimizer.optimizeQuery(StandardQueryOptimizer.java:158)
	... 41 more
I double checked, OPC-DA Feature is definitely installed. Perhaps an error occured within your build.

On another note, your support so far has been absolutely fantastic ;)
Last edited by Martin Schmid on Mon Sep 29, 2014 11:49 am, edited 1 time in total.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest