# Simulation Aids where and orderBy expressions through IllegalArgumentException

**URL:** <https://forum.inductiveautomation.com/t/simulation-aids-where-and-orderby-expressions-through-illegalargumentexception/77231>\
**Category:** 3rd Party Modules\
**Tags:** ignition81, vision, perspective\
**Created:** [August 1, 2023, 3:50pm UTC](https://forum.inductiveautomation.com/t/simulation-aids-where-and-orderby-expressions-through-illegalargumentexception/77231 "2023-08-01T15:50:30Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [August 1, 2023, 3:50pm UTC](https://forum.inductiveautomation.com/t/simulation-aids-where-and-orderby-expressions-through-illegalargumentexception/77231/1 "2023-08-01T15:50:30Z")

</div>

@pturmel

I have the following expression:

```auto
unionAll(
	flatten(
		asList(
			asList(asList('Occurrence','str')),
			forEach(
				groupBy({this.custom.rawData},it()['path']),
				forEach(
					it()[1],
					asList(
						left(dateFormat(it()['timestamp'],'_hha'),4),
						"I"
					)
				)
			)[0]
		)
	),
	forEach(
		forEach(
			groupBy({this.custom.rawData},it()['path']),
			it()
		),
		flatten(
			asList(
				asList(
					case(
						split(it()[0],'_',2)[0],
						'productlevel','No Product',
						'cap','No Caps',
						'downstream','Packaging',
						'No Bottles'
					)
				),	
				forEach(it()[1],it()['value'])
			)
		)
	)
)

```

This seems to produce a valid dataset although in vision if I run this in the designer I do get a ClassCastException: BasicDataset cannot be cast to class java.util.ArrayList.

The topic of this post is however, if I wrap this expression in either a where or an orderBy expression:

```auto
orderBy({expression above},descending(it()['Occurrence']))

```

```auto
where({expression above),it()['Occurrence'] = 'No Bottles')

```

I get an IllegalArgumentException: Wrong number of values for a row. Expected 25.

The same error is present for both Vision and perspective.

What am I doing wrong?

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [August 1, 2023, 3:51pm UTC](https://forum.inductiveautomation.com/t/simulation-aids-where-and-orderby-expressions-through-illegalargumentexception/77231/2 "2023-08-01T15:51:32Z")

</div>

Additional information:

> **Sample Data**
>
> "#NAMES"  
> "path","value","quality","timestamp"  
> "#TYPES"  
> "str","L","I","date"  
> "#ROWS","120"  
> "productlevel\_at\_sp","0","192","2023-07-31 12:00:00.000"  
> "cap\_supply","1","192","2023-07-31 12:00:00.000"  
> "downstream\_stop\_request","8","192","2023-07-31 12:00:00.000"  
> "empty\_bottles\_present","7","192","2023-07-31 12:00:00.000"  
> "empty\_bottles\_primied","5","192","2023-07-31 12:00:00.000"  
> "productlevel\_at\_sp","0","192","2023-07-31 13:00:00.000"  
> "cap\_supply","2","192","2023-07-31 13:00:00.000"  
> "downstream\_stop\_request","5","192","2023-07-31 13:00:00.000"  
> "empty\_bottles\_present","3","192","2023-07-31 13:00:00.000"  
> "empty\_bottles\_primied","4","192","2023-07-31 13:00:00.000"  
> "productlevel\_at\_sp","5","192","2023-07-31 14:00:00.000"  
> "cap\_supply","0","192","2023-07-31 14:00:00.000"  
> "downstream\_stop\_request","0","192","2023-07-31 14:00:00.000"  
> "empty\_bottles\_present","0","192","2023-07-31 14:00:00.000"  
> "empty\_bottles\_primied","1","192","2023-07-31 14:00:00.000"  
> "productlevel\_at\_sp","2","200","2023-07-31 15:00:00.000"  
> "cap\_supply","0","192","2023-07-31 15:00:00.000"  
> "downstream\_stop\_request","1","192","2023-07-31 15:00:00.000"  
> "empty\_bottles\_present","0","192","2023-07-31 15:00:00.000"  
> "empty\_bottles\_primied","0","192","2023-07-31 15:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-07-31 16:00:00.000"  
> "cap\_supply","2","192","2023-07-31 16:00:00.000"  
> "downstream\_stop\_request","2","192","2023-07-31 16:00:00.000"  
> "empty\_bottles\_present","0","192","2023-07-31 16:00:00.000"  
> "empty\_bottles\_primied","0","192","2023-07-31 16:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-07-31 17:00:00.000"  
> "cap\_supply","3","192","2023-07-31 17:00:00.000"  
> "downstream\_stop\_request","13","192","2023-07-31 17:00:00.000"  
> "empty\_bottles\_present","0","192","2023-07-31 17:00:00.000"  
> "empty\_bottles\_primied","1","192","2023-07-31 17:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-07-31 18:00:00.000"  
> "cap\_supply","3","192","2023-07-31 18:00:00.000"  
> "downstream\_stop\_request","11","192","2023-07-31 18:00:00.000"  
> "empty\_bottles\_present","0","192","2023-07-31 18:00:00.000"  
> "empty\_bottles\_primied","0","192","2023-07-31 18:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-07-31 19:00:00.000"  
> "cap\_supply","5","192","2023-07-31 19:00:00.000"  
> "downstream\_stop\_request","7","192","2023-07-31 19:00:00.000"  
> "empty\_bottles\_present","4","192","2023-07-31 19:00:00.000"  
> "empty\_bottles\_primied","6","192","2023-07-31 19:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-07-31 20:00:00.000"  
> "cap\_supply","5","192","2023-07-31 20:00:00.000"  
> "downstream\_stop\_request","1","192","2023-07-31 20:00:00.000"  
> "empty\_bottles\_present","5","192","2023-07-31 20:00:00.000"  
> "empty\_bottles\_primied","4","192","2023-07-31 20:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-07-31 21:00:00.000"  
> "cap\_supply","2","192","2023-07-31 21:00:00.000"  
> "downstream\_stop\_request","0","192","2023-07-31 21:00:00.000"  
> "empty\_bottles\_present","0","192","2023-07-31 21:00:00.000"  
> "empty\_bottles\_primied","3","192","2023-07-31 21:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-07-31 22:00:00.000"  
> "cap\_supply","2","192","2023-07-31 22:00:00.000"  
> "downstream\_stop\_request","1","192","2023-07-31 22:00:00.000"  
> "empty\_bottles\_present","1","192","2023-07-31 22:00:00.000"  
> "empty\_bottles\_primied","2","192","2023-07-31 22:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-07-31 23:00:00.000"  
> "cap\_supply","4","192","2023-07-31 23:00:00.000"  
> "downstream\_stop\_request","5","192","2023-07-31 23:00:00.000"  
> "empty\_bottles\_present","2","192","2023-07-31 23:00:00.000"  
> "empty\_bottles\_primied","3","192","2023-07-31 23:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-08-01 00:00:00.000"  
> "cap\_supply","5","192","2023-08-01 00:00:00.000"  
> "downstream\_stop\_request","5","192","2023-08-01 00:00:00.000"  
> "empty\_bottles\_present","0","192","2023-08-01 00:00:00.000"  
> "empty\_bottles\_primied","3","192","2023-08-01 00:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-08-01 01:00:00.000"  
> "cap\_supply","6","192","2023-08-01 01:00:00.000"  
> "downstream\_stop\_request","2","192","2023-08-01 01:00:00.000"  
> "empty\_bottles\_present","0","192","2023-08-01 01:00:00.000"  
> "empty\_bottles\_primied","2","192","2023-08-01 01:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-08-01 02:00:00.000"  
> "cap\_supply","8","192","2023-08-01 02:00:00.000"  
> "downstream\_stop\_request","1","192","2023-08-01 02:00:00.000"  
> "empty\_bottles\_present","2","192","2023-08-01 02:00:00.000"  
> "empty\_bottles\_primied","3","192","2023-08-01 02:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-08-01 03:00:00.000"  
> "cap\_supply","10","192","2023-08-01 03:00:00.000"  
> "downstream\_stop\_request","6","192","2023-08-01 03:00:00.000"  
> "empty\_bottles\_present","1","192","2023-08-01 03:00:00.000"  
> "empty\_bottles\_primied","3","192","2023-08-01 03:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-08-01 04:00:00.000"  
> "cap\_supply","7","192","2023-08-01 04:00:00.000"  
> "downstream\_stop\_request","1","192","2023-08-01 04:00:00.000"  
> "empty\_bottles\_present","1","192","2023-08-01 04:00:00.000"  
> "empty\_bottles\_primied","3","192","2023-08-01 04:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-08-01 05:00:00.000"  
> "cap\_supply","4","192","2023-08-01 05:00:00.000"  
> "downstream\_stop\_request","3","192","2023-08-01 05:00:00.000"  
> "empty\_bottles\_present","1","192","2023-08-01 05:00:00.000"  
> "empty\_bottles\_primied","3","192","2023-08-01 05:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-08-01 06:00:00.000"  
> "cap\_supply","3","192","2023-08-01 06:00:00.000"  
> "downstream\_stop\_request","2","192","2023-08-01 06:00:00.000"  
> "empty\_bottles\_present","3","192","2023-08-01 06:00:00.000"  
> "empty\_bottles\_primied","6","192","2023-08-01 06:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-08-01 07:00:00.000"  
> "cap\_supply","4","192","2023-08-01 07:00:00.000"  
> "downstream\_stop\_request","1","192","2023-08-01 07:00:00.000"  
> "empty\_bottles\_present","1","192","2023-08-01 07:00:00.000"  
> "empty\_bottles\_primied","1","192","2023-08-01 07:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-08-01 08:00:00.000"  
> "cap\_supply","13","192","2023-08-01 08:00:00.000"  
> "downstream\_stop\_request","1","192","2023-08-01 08:00:00.000"  
> "empty\_bottles\_present","1","192","2023-08-01 08:00:00.000"  
> "empty\_bottles\_primied","1","192","2023-08-01 08:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-08-01 09:00:00.000"  
> "cap\_supply","11","192","2023-08-01 09:00:00.000"  
> "downstream\_stop\_request","0","192","2023-08-01 09:00:00.000"  
> "empty\_bottles\_present","0","192","2023-08-01 09:00:00.000"  
> "empty\_bottles\_primied","2","192","2023-08-01 09:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-08-01 10:00:00.000"  
> "cap\_supply","8","200","2023-08-01 10:00:00.000"  
> "downstream\_stop\_request","1","200","2023-08-01 10:00:00.000"  
> "empty\_bottles\_present","1","200","2023-08-01 10:00:00.000"  
> "empty\_bottles\_primied","6","200","2023-08-01 10:00:00.000"  
> "productlevel\_at\_sp","0","200","2023-08-01 11:00:00.000"  
> "cap\_supply","0","200","2023-08-01 11:00:00.000"  
> "downstream\_stop\_request","0","200","2023-08-01 11:00:00.000"  
> "empty\_bottles\_present","0","200","2023-08-01 11:00:00.000"  
> "empty\_bottles\_primied","0","200","2023-08-01 11:00:00.000"

[consoleOutput\_from\_traceMe.txt](https://forum.inductiveautomation.com/uploads/short-url/80b6UIIF12uqKdwXFUGV2tpHwaP.txt) (78.0 KB)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 1, 2023, 4:00pm UTC](https://forum.inductiveautomation.com/t/simulation-aids-where-and-orderby-expressions-through-illegalargumentexception/77231/3 "2023-08-01T16:00:24Z")

</div>

Will have to study later (can't wait for me to implement pivot(), hmm?).

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [August 1, 2023, 4:37pm UTC](https://forum.inductiveautomation.com/t/simulation-aids-where-and-orderby-expressions-through-illegalargumentexception/77231/4 "2023-08-01T16:37:05Z")

</div>

pivot() will be well worth the wait!

Doing my best to eliminate unnecessary script calls.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 4, 2023, 8:33pm UTC](https://forum.inductiveautomation.com/t/simulation-aids-where-and-orderby-expressions-through-illegalargumentexception/77231/5 "2023-08-04T20:33:33Z")

</div>

> [@lrose](#):
>
> I get an IllegalArgumentException: Wrong number of values for a row. Expected 25.

Straight-up bug, looks like. If you take the inner expression's resulting dataset as a constant to feed them, they break the same way. Will fix.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 4, 2023, 8:53pm UTC](https://forum.inductiveautomation.com/t/simulation-aids-where-and-orderby-expressions-through-illegalargumentexception/77231/6 "2023-08-04T20:53:27Z")

</div>

And fixed. For Ignition v8.1+ as usual: [v2.0.8.232162051](https://www.automation-pros.com/ignition/Simulation%20Aids-2.0.8.232162051-v81.modl)

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [August 11, 2023, 4:12pm UTC](https://forum.inductiveautomation.com/t/simulation-aids-where-and-orderby-expressions-through-illegalargumentexception/77231/7 "2023-08-11T16:12:36Z")

</div>

I'm back.

Here is a clip of what I am seeing, this is also somewhat present in the client, but to a lesser extent.

![designer](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/8/d8ad0e5c795bd9fc823dbb1ded19b0f951a4bc61.gif)

> **Error Stack Traces**
>
> > **NPE on Power Table.data**
> >
> > ```auto
> > java.lang.Exception: Error executing expression binding on
> > Stop Occurances_New.Root Container.Group 1.Power Table 1.data
> > at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:92)
> > at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter$1.run(ExpressionPropertyAdapter.java:59)
> > at com.inductiveautomation.ignition.client.util.EDTUtil$ProcessQueue.run(EDTUtil.java:126)
> > at java.desktop/java.awt.event.InvocationEvent.dispatch(Unknown Source)
> > at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
> > at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
> > at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
> > at java.base/java.security.AccessController.doPrivileged(Native Method)
> > at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
> > at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)
> > Caused by: java.lang.RuntimeException: Unable to handle rowSource #2
> > at com.automation_pros.simaids.expressions.UnionAll.execute(UnionAll.java:111)
> > at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> > at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> > at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> > at com.inductiveautomation.ignition.common.expressions.DefaultFunctionFactory$ColumnRearrangeFunction.execute(DefaultFunctionFactory.java:1837)
> > at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> > at com.inductiveautomation.ignition.common.expressions.functions.BaseFunction.executeAll(BaseFunction.java:64)
> > at com.automation_pros.simaids.expressions.SimpleIterator.execute(SimpleIterator.java:177)
> > at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> > at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> > at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> > at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:83)
> > ... 15 more
> > Caused by: java.lang.NullPointerException
> > at com.automation_pros.simaids.expressions.UnionAll.buildWith(UnionAll.java:188)
> > at com.automation_pros.simaids.expressions.UnionAll.execute(UnionAll.java:107)
> > ... 26 more
> > 
> > Ignition v8.1.24 (b2023011208)
> > Java: Azul Systems, Inc. 11.0.16.1
> > 
> > ```
> 
> > **ClassCastException on summedData binding**
> >
> > ```auto
> > java.lang.Exception: Error executing expression binding on
> > Stop Occurances_New.Root Container.Group 1.Power Table 1.summedData
> > at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:92)
> > at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter$1.run(ExpressionPropertyAdapter.java:59)
> > at com.inductiveautomation.ignition.client.util.EDTUtil$ProcessQueue.run(EDTUtil.java:126)
> > at java.desktop/java.awt.event.InvocationEvent.dispatch(Unknown Source)
> > at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
> > at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
> > at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
> > at java.base/java.security.AccessController.doPrivileged(Native Method)
> > at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
> > at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)
> > Caused by: java.lang.ClassCastException
> > 
> > Ignition v8.1.24 (b2023011208)
> > Java: Azul Systems, Inc. 11.0.16.1
> > 
> > ```
> 
> > **ClassCastException on pivotedData**
> >
> > java.lang.Exception: Error executing expression binding on  
> > Stop Occurances\_New.Root Container.Group 1.Power Table 1.pivotedData  
> > at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:92)  
> > at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter$1.run(ExpressionPropertyAdapter.java:59)  
> > at com.inductiveautomation.ignition.client.util.EDTUtil$ProcessQueue.run(EDTUtil.java:126)  
> > at java.desktop/java.awt.event.InvocationEvent.dispatch(Unknown Source)  
> > at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)  
> > at java.desktop/java.awt.EventQueue$4.run(Unknown Source)  
> > at java.desktop/java.awt.EventQueue$4.run(Unknown Source)  
> > at java.base/java.security.AccessController.doPrivileged(Native Method)  
> > at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)  
> > at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)  
> > at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)  
> > at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)  
> > at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)  
> > at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)  
> > at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)  
> > at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)  
> > Caused by: java.lang.ClassCastException
> > 
> > Ignition v8.1.24 (b2023011208)  
> > Java: Azul Systems, Inc. 11.0.16.1
> 
> > **NPE on Power Table 2.data**
> >
> > ```auto
> > java.lang.Exception: Error executing expression binding on
> > Stop Occurances_New.Root Container.Power Table 2.data
> > at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:92)
> > at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter$1.run(ExpressionPropertyAdapter.java:59)
> > at com.inductiveautomation.ignition.client.util.EDTUtil$ProcessQueue.run(EDTUtil.java:126)
> > at java.desktop/java.awt.event.InvocationEvent.dispatch(Unknown Source)
> > at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
> > at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
> > at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
> > at java.base/java.security.AccessController.doPrivileged(Native Method)
> > at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
> > at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)
> > Caused by: java.lang.NullPointerException
> > at com.automation_pros.simaids.expressions.Flatten.execute(Flatten.java:55)
> > at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> > at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> > at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> > at com.inductiveautomation.ignition.common.expressions.functions.BaseFunction.executeAll(BaseFunction.java:64)
> > at com.automation_pros.simaids.expressions.AsMap.execute(AsMap.java:41)
> > at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> > at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> > at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> > at com.inductiveautomation.ignition.common.expressions.functions.BaseFunction.executeAll(BaseFunction.java:64)
> > at com.automation_pros.simaids.expressions.UnionAll.execute(UnionAll.java:52)
> > at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> > at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> > at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> > at com.inductiveautomation.ignition.common.expressions.DefaultFunctionFactory$ColumnRearrangeFunction.execute(DefaultFunctionFactory.java:1837)
> > at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> > at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:83)
> > ... 15 more
> > 
> > Ignition v8.1.24 (b2023011208)
> > Java: Azul Systems, Inc. 11.0.16.1
> > 
> > ```
> 
> > **Summary**
> >
> > ```auto
> > java.lang.Exception: Error executing expression binding on
> > Stop Occurances_New.Root Container.Power Table 2.effByHour
> > at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:92)
> > at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter$1.run(ExpressionPropertyAdapter.java:59)
> > at com.inductiveautomation.ignition.client.util.EDTUtil$ProcessQueue.run(EDTUtil.java:126)
> > at java.desktop/java.awt.event.InvocationEvent.dispatch(Unknown Source)
> > at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
> > at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
> > at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
> > at java.base/java.security.AccessController.doPrivileged(Native Method)
> > at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
> > at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> > at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)
> > Caused by: java.lang.ClassCastException
> > 
> > Ignition v8.1.24 (b2023011208)
> > Java: Azul Systems, Inc. 11.0.16.1
> > 
> > ```

These errors also happen if I add/remove a custom property to/from one of the tables. Sometimes it seems to matter which order I refresh the bindings in. For instance if I refresh summed data prior to pivoted data, it will continue to show `<No Data>` until I have refreshed the pivoted data.

> **Sample Data**
>
> ```auto
> "#NAMES"
> "path","value","quality","timestamp"
> "#TYPES"
> "str","L","I","date"
> "#ROWS","120"
> "Labeler","77","192","2023-08-10 13:00:00.000"
> "Laber","0","192","2023-08-10 13:00:00.000"
> "Caser","173","192","2023-08-10 13:00:00.000"
> "Stacker","0","192","2023-08-10 13:00:00.000"
> "Dynac","35","192","2023-08-10 13:00:00.000"
> "Labeler","0","192","2023-08-10 14:00:00.000"
> "Laber","107","192","2023-08-10 14:00:00.000"
> "Caser","155","192","2023-08-10 14:00:00.000"
> "Stacker","77","192","2023-08-10 14:00:00.000"
> "Dynac","0","192","2023-08-10 14:00:00.000"
> "Labeler","226","192","2023-08-10 15:00:00.000"
> "Laber","0","192","2023-08-10 15:00:00.000"
> "Caser","205","192","2023-08-10 15:00:00.000"
> "Stacker","131","192","2023-08-10 15:00:00.000"
> "Dynac","0","192","2023-08-10 15:00:00.000"
> "Labeler","0","192","2023-08-10 16:00:00.000"
> "Laber","0","192","2023-08-10 16:00:00.000"
> "Caser","72","192","2023-08-10 16:00:00.000"
> "Stacker","0","192","2023-08-10 16:00:00.000"
> "Dynac","18","192","2023-08-10 16:00:00.000"
> "Labeler","0","192","2023-08-10 17:00:00.000"
> "Laber","0","192","2023-08-10 17:00:00.000"
> "Caser","877","192","2023-08-10 17:00:00.000"
> "Stacker","134","192","2023-08-10 17:00:00.000"
> "Dynac","14","192","2023-08-10 17:00:00.000"
> "Labeler","0","192","2023-08-10 18:00:00.000"
> "Laber","0","192","2023-08-10 18:00:00.000"
> "Caser","0","192","2023-08-10 18:00:00.000"
> "Stacker","35","192","2023-08-10 18:00:00.000"
> "Dynac","0","192","2023-08-10 18:00:00.000"
> "Labeler","3","192","2023-08-10 19:00:00.000"
> "Laber","29","192","2023-08-10 19:00:00.000"
> "Caser","312","192","2023-08-10 19:00:00.000"
> "Stacker","0","192","2023-08-10 19:00:00.000"
> "Dynac","14","192","2023-08-10 19:00:00.000"
> "Labeler","0","192","2023-08-10 20:00:00.000"
> "Laber","35","192","2023-08-10 20:00:00.000"
> "Caser","121","192","2023-08-10 20:00:00.000"
> "Stacker","0","192","2023-08-10 20:00:00.000"
> "Dynac","0","192","2023-08-10 20:00:00.000"
> "Labeler","0","192","2023-08-10 21:00:00.000"
> "Laber","178","192","2023-08-10 21:00:00.000"
> "Caser","47","192","2023-08-10 21:00:00.000"
> "Stacker","0","192","2023-08-10 21:00:00.000"
> "Dynac","0","192","2023-08-10 21:00:00.000"
> "Labeler","0","192","2023-08-10 22:00:00.000"
> "Laber","0","192","2023-08-10 22:00:00.000"
> "Caser","116","192","2023-08-10 22:00:00.000"
> "Stacker","0","192","2023-08-10 22:00:00.000"
> "Dynac","0","192","2023-08-10 22:00:00.000"
> "Labeler","68","192","2023-08-10 23:00:00.000"
> "Laber","0","192","2023-08-10 23:00:00.000"
> "Caser","17","192","2023-08-10 23:00:00.000"
> "Stacker","0","192","2023-08-10 23:00:00.000"
> "Dynac","0","192","2023-08-10 23:00:00.000"
> "Labeler","0","192","2023-08-11 00:00:00.000"
> "Laber","0","192","2023-08-11 00:00:00.000"
> "Caser","29","192","2023-08-11 00:00:00.000"
> "Stacker","0","192","2023-08-11 00:00:00.000"
> "Dynac","25","192","2023-08-11 00:00:00.000"
> "Labeler","0","192","2023-08-11 01:00:00.000"
> "Laber","36","192","2023-08-11 01:00:00.000"
> "Caser","106","192","2023-08-11 01:00:00.000"
> "Stacker","0","192","2023-08-11 01:00:00.000"
> "Dynac","0","192","2023-08-11 01:00:00.000"
> "Labeler","0","192","2023-08-11 02:00:00.000"
> "Laber","0","192","2023-08-11 02:00:00.000"
> "Caser","24","192","2023-08-11 02:00:00.000"
> "Stacker","0","192","2023-08-11 02:00:00.000"
> "Dynac","18","192","2023-08-11 02:00:00.000"
> "Labeler","113","192","2023-08-11 03:00:00.000"
> "Laber","0","192","2023-08-11 03:00:00.000"
> "Caser","131","192","2023-08-11 03:00:00.000"
> "Stacker","0","192","2023-08-11 03:00:00.000"
> "Dynac","67","192","2023-08-11 03:00:00.000"
> "Labeler","0","192","2023-08-11 04:00:00.000"
> "Laber","0","192","2023-08-11 04:00:00.000"
> "Caser","137","192","2023-08-11 04:00:00.000"
> "Stacker","0","192","2023-08-11 04:00:00.000"
> "Dynac","0","192","2023-08-11 04:00:00.000"
> "Labeler","102","192","2023-08-11 05:00:00.000"
> "Laber","90","192","2023-08-11 05:00:00.000"
> "Caser","38","192","2023-08-11 05:00:00.000"
> "Stacker","0","192","2023-08-11 05:00:00.000"
> "Dynac","34","192","2023-08-11 05:00:00.000"
> "Labeler","25","192","2023-08-11 06:00:00.000"
> "Laber","0","192","2023-08-11 06:00:00.000"
> "Caser","588","192","2023-08-11 06:00:00.000"
> "Stacker","0","192","2023-08-11 06:00:00.000"
> "Dynac","0","192","2023-08-11 06:00:00.000"
> "Labeler","0","192","2023-08-11 07:00:00.000"
> "Laber","0","192","2023-08-11 07:00:00.000"
> "Caser","157","192","2023-08-11 07:00:00.000"
> "Stacker","0","192","2023-08-11 07:00:00.000"
> "Dynac","0","192","2023-08-11 07:00:00.000"
> "Labeler","317","192","2023-08-11 08:00:00.000"
> "Laber","50","192","2023-08-11 08:00:00.000"
> "Caser","793","192","2023-08-11 08:00:00.000"
> "Stacker","0","192","2023-08-11 08:00:00.000"
> "Dynac","0","192","2023-08-11 08:00:00.000"
> "Labeler","111","192","2023-08-11 09:00:00.000"
> "Laber","0","192","2023-08-11 09:00:00.000"
> "Caser","811","192","2023-08-11 09:00:00.000"
> "Stacker","18","200","2023-08-11 09:00:00.000"
> "Dynac","0","192","2023-08-11 09:00:00.000"
> "Labeler","174","192","2023-08-11 10:00:00.000"
> "Laber","229","192","2023-08-11 10:00:00.000"
> "Caser","549","192","2023-08-11 10:00:00.000"
> "Stacker","0","200","2023-08-11 10:00:00.000"
> "Dynac","0","192","2023-08-11 10:00:00.000"
> "Labeler","162","200","2023-08-11 11:00:00.000"
> "Laber","231","200","2023-08-11 11:00:00.000"
> "Caser","534","192","2023-08-11 11:00:00.000"
> "Stacker","0","200","2023-08-11 11:00:00.000"
> "Dynac","0","200","2023-08-11 11:00:00.000"
> "Labeler","0","200","2023-08-11 12:00:00.000"
> "Laber","0","200","2023-08-11 12:00:00.000"
> "Caser","0","192","2023-08-11 12:00:00.000"
> "Stacker","0","200","2023-08-11 12:00:00.000"
> "Dynac","0","200","2023-08-11 12:00:00.000"
> 
> ```

> **Pivoted Data Expression**
>
> ```auto
> columnRearrange(
> unionAll(
> flatten(
> asList(
> asList(asList('Occurrence','str')),
> forEach(
> groupBy({Root Container.Group 1.Power Table 1.historicalData},it()['path']),
> forEach(
> it()[1],
> asList(
> left(dateFormat(it()['timestamp'],'_ha'),if(len(dateFormat(it()['timestamp'],'_ha')) = 4,3,4)),
> "F"
> )
> )
> )[0]
> )
> ),
> forEach(
> forEach(
> groupBy(
> {Root Container.Group 1.Power Table 1.historicalData},
> it()['path']
> ),
> it()
> ),
> flatten(
> asList(
> asList(it()[0]),
> forEach(it()[1],round(it()['value'] / 60.0,1))
> )
> )
> )
> ),
> 'Occurrence',
> '_7A',
> '_8A',
> '_9A',
> '_10A',
> '_11A',
> '_12P',
> '_1P',
> '_2P',
> '_3P',
> '_4P',
> '_5P',
> '_6P',
> '_7P',
> '_8P',
> '_9P',
> '_10P',
> '_11P',
> '_12A',
> '_1A',
> '_2A',
> '_3A',
> '_4A',
> '_5A',
> '_6A'
> )
> 
> ```

> **Summed Data Expression**
>
> ```auto
> selectStar(
> {Root Container.Group 1.Power Table 1.pivotedData},
> asMap(	
> forEach(
> groupBy(
> {Root Container.Group 1.Power Table 1.last8HistoricalData},
> it()['path']
> ),
> asList(
> it()[0],
> round(sum(it()[1],'value')/60.0,1)
> )
> )
> )[it()['Occurrence']],
> 'Last 8',
> 'F',
> asMap(
> forEach(
> groupBy(
> {Root Container.Group 1.Power Table 1.historicalData},
> it()['path']
> ),
> asList(
> it()[0],
> round(sum(it()[1],'value') / 60.0,1)
> )
> )
> )[it()['Occurrence']],
> 'Last 24',
> 'F'
> )
> 
> ```

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 11, 2023, 6:34pm UTC](https://forum.inductiveautomation.com/t/simulation-aids-where-and-orderby-expressions-through-illegalargumentexception/77231/8 "2023-08-11T18:34:30Z")

</div>

So, null pointer exceptions are always a bug. This update prevents those two, and provide more helpful information where available:

For Ignition v8.1+: [v2.0.9.232231702](https://www.automation-pros.com/ignition/Simulation%20Aids-2.0.9.232231702-v81.modl)

For the class cast exceptions, you will need to configure your designer launcher to include this extra JVM option:

```auto
-XX:-OmitStackTraceInFastThrow

```

That will cause a more complete stack track to be reported.

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [August 11, 2023, 9:34pm UTC](https://forum.inductiveautomation.com/t/simulation-aids-where-and-orderby-expressions-through-illegalargumentexception/77231/9 "2023-08-11T21:34:06Z")

</div>

Updated to 2.0.9, included JVM option.

> **NPE**
>
> java.lang.Exception: Error executing expression binding on  
> Stop Occurances\_New.Root Container.Group.Power Table.data  
> at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:92)  
> at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.startup(ExpressionPropertyAdapter.java:113)  
> at com.inductiveautomation.factorypmi.application.binding.DefaultInteractionController.startupBindings(DefaultInteractionController.java:355)  
> at com.inductiveautomation.factorypmi.application.binding.DefaultInteractionController.startupAdapters(DefaultInteractionController.java:360)  
> at com.inductiveautomation.factorypmi.application.FPMIWindow.startup(FPMIWindow.java:346)  
> at com.inductiveautomation.factorypmi.designer.workspace.WindowWorkspace$DesigntimeWindowOpener.openWindow(WindowWorkspace.java:3791)  
> at com.inductiveautomation.factorypmi.designer.workspace.WindowWorkspace.openWindow(WindowWorkspace.java:1520)  
> at com.inductiveautomation.factorypmi.designer.workspace.WindowWorkspace$4.lambda$createPanels$2(WindowWorkspace.java:628)  
> at com.inductiveautomation.ignition.designer.workspacewelcome.RecentlyModifiedTilePanel$Tile.lambda$new$1(RecentlyModifiedTilePanel.java:206)  
> at com.inductiveautomation.ignition.client.util.gui.Listen$1.mousePressed(Listen.java:52)  
> at java.desktop/java.awt.AWTEventMulticaster.mousePressed(Unknown Source)  
> at java.desktop/java.awt.Component.processMouseEvent(Unknown Source)  
> at java.desktop/javax.swing.JComponent.processMouseEvent(Unknown Source)  
> at java.desktop/java.awt.Component.processEvent(Unknown Source)  
> at java.desktop/java.awt.Container.processEvent(Unknown Source)  
> at java.desktop/java.awt.Component.dispatchEventImpl(Unknown Source)  
> at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)  
> at java.desktop/java.awt.Component.dispatchEvent(Unknown Source)  
> at com.jidesoft.docking.DockingUtils.a(Unknown Source)  
> at com.jidesoft.docking.DefaultDockingManager.handleEvent(Unknown Source)  
> at com.jidesoft.docking.DefaultDockingManager$a3.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$SelectiveAWTEventListener.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Unknown Source)  
> at java.desktop/java.awt.Toolkit.notifyAWTEventListeners(Unknown Source)  
> at java.desktop/java.awt.Component.dispatchEventImpl(Unknown Source)  
> at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)  
> at java.desktop/java.awt.Component.dispatchEvent(Unknown Source)  
> at java.desktop/java.awt.KeyboardFocusManager.redispatchEvent(Unknown Source)  
> at java.desktop/java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(Unknown Source)  
> at java.desktop/java.awt.DefaultKeyboardFocusManager.dispatchEvent(Unknown Source)  
> at java.desktop/java.awt.Component.dispatchEventImpl(Unknown Source)  
> at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)  
> at java.desktop/java.awt.Component.dispatchEvent(Unknown Source)  
> at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)  
> at java.desktop/java.awt.EventQueue$4.run(Unknown Source)  
> at java.desktop/java.awt.EventQueue$4.run(Unknown Source)  
> at java.base/java.security.AccessController.doPrivileged(Native Method)  
> at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)  
> at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)  
> at java.desktop/java.awt.EventQueue$5.run(Unknown Source)  
> at java.desktop/java.awt.EventQueue$5.run(Unknown Source)  
> at java.base/java.security.AccessController.doPrivileged(Native Method)  
> at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)  
> at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)  
> at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)  
> at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)  
> at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)  
> at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)  
> at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)  
> at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)  
> Caused by: java.lang.NullPointerException  
> at com.automation\_pros.simaids.expressions.ColumnsOf.execute(ColumnsOf.java:30)  
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)  
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)  
> at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)  
> at com.inductiveautomation.ignition.common.expressions.functions.BaseFunction.executeAll(BaseFunction.java:64)  
> at com.automation\_pros.simaids.expressions.UnionAll.execute(UnionAll.java:52)  
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)  
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)  
> at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)  
> at com.inductiveautomation.ignition.common.expressions.DefaultFunctionFactory$ColumnRearrangeFunction.execute(DefaultFunctionFactory.java:1837)  
> at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)  
> at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:83)  
> ... 70 more
> 
> Ignition v8.1.24 (b2023011208)  
> Java: Azul Systems, Inc. 11.0.16.1

> **Class Cast Exception on summedData**
>
> ```auto
> java.lang.Exception: Error executing expression binding on
> Stop Occurances_New.Root Container.Group 1.Power Table 1.summedData
> at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:92)
> at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter$1.run(ExpressionPropertyAdapter.java:59)
> at com.inductiveautomation.ignition.client.util.EDTUtil$ProcessQueue.run(EDTUtil.java:126)
> at java.desktop/java.awt.event.InvocationEvent.dispatch(Unknown Source)
> at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
> at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
> at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
> at java.base/java.security.AccessController.doPrivileged(Native Method)
> at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
> at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)
> Caused by: java.lang.ClassCastException: class com.inductiveautomation.ignition.common.BasicDataset cannot be cast to class java.util.ArrayList (com.inductiveautomation.ignition.common.BasicDataset is in unnamed module of loader java.net.URLClassLoader @1529fea1; java.util.ArrayList is in module java.base of loader 'bootstrap')
> at com.automation_pros.simaids.expressions.GroupBy.accumulateOutput(GroupBy.java:106)
> at com.automation_pros.simaids.expressions.SimpleIterator.execute(SimpleIterator.java:212)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> at com.inductiveautomation.ignition.common.expressions.functions.BaseFunction.executeAll(BaseFunction.java:64)
> at com.automation_pros.simaids.expressions.SimpleIterator.execute(SimpleIterator.java:177)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> at com.inductiveautomation.ignition.common.expressions.functions.BaseFunction.executeAll(BaseFunction.java:64)
> at com.automation_pros.simaids.expressions.AsMap.execute(AsMap.java:41)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> at com.automation_pros.simaids.expressions.IterationHelper.condSubstExpression(IterationHelper.java:249)
> at com.automation_pros.simaids.expressions.IterationHelper.preExecuteAll(IterationHelper.java:165)
> at com.automation_pros.simaids.expressions.IterationHelper.condSubstExpression(IterationHelper.java:205)
> at com.automation_pros.simaids.expressions.IterationHelper.preExecuteAll(IterationHelper.java:165)
> at com.automation_pros.simaids.expressions.SimpleIterator.execute(SimpleIterator.java:206)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:83)
> ... 15 more
> 
> Ignition v8.1.24 (b2023011208)
> Java: Azul Systems, Inc. 11.0.16.1
> 
> ```

> **Class Cast Exception on effByHour**
>
> ```auto
> java.lang.Exception: Error executing expression binding on
> Stop Occurances_New.Root Container.Power Table 2.effByHour
> at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:92)
> at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter$1.run(ExpressionPropertyAdapter.java:59)
> at com.inductiveautomation.ignition.client.util.EDTUtil$ProcessQueue.run(EDTUtil.java:126)
> at java.desktop/java.awt.event.InvocationEvent.dispatch(Unknown Source)
> at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
> at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
> at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
> at java.base/java.security.AccessController.doPrivileged(Native Method)
> at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
> at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)
> Caused by: java.lang.ClassCastException: class com.inductiveautomation.ignition.common.BasicDataset cannot be cast to class java.util.ArrayList (com.inductiveautomation.ignition.common.BasicDataset is in unnamed module of loader java.net.URLClassLoader @1529fea1; java.util.ArrayList is in module java.base of loader 'bootstrap')
> at com.automation_pros.simaids.expressions.GroupBy.accumulateOutput(GroupBy.java:106)
> at com.automation_pros.simaids.expressions.InnerJoin.execute(InnerJoin.java:140)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> at com.inductiveautomation.ignition.common.expressions.functions.BaseFunction.executeAll(BaseFunction.java:64)
> at com.automation_pros.simaids.expressions.SimpleIterator.execute(SimpleIterator.java:177)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> at com.inductiveautomation.ignition.common.expressions.functions.BaseFunction.executeAll(BaseFunction.java:64)
> at com.automation_pros.simaids.expressions.UnionAll.execute(UnionAll.java:52)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:83)
> ... 15 more
> 
> Ignition v8.1.24 (b2023011208)
> Java: Azul Systems, Inc. 11.0.16.1
> 
> ```

> **Class Cast Exception on pivotedData**
>
> ```auto
> java.lang.Exception: Error executing expression binding on
> Stop Occurances_New.Root Container.Group.Power Table.pivotedData
> at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:92)
> at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter$1.run(ExpressionPropertyAdapter.java:59)
> at com.inductiveautomation.ignition.client.util.EDTUtil$ProcessQueue.run(EDTUtil.java:126)
> at java.desktop/java.awt.event.InvocationEvent.dispatch(Unknown Source)
> at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
> at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
> at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
> at java.base/java.security.AccessController.doPrivileged(Native Method)
> at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
> at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
> at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)
> Caused by: java.lang.ClassCastException: class com.inductiveautomation.ignition.common.BasicDataset cannot be cast to class java.util.ArrayList (com.inductiveautomation.ignition.common.BasicDataset is in unnamed module of loader java.net.URLClassLoader @1529fea1; java.util.ArrayList is in module java.base of loader 'bootstrap')
> at com.automation_pros.simaids.expressions.GroupBy.accumulateOutput(GroupBy.java:106)
> at com.automation_pros.simaids.expressions.SimpleIterator.execute(SimpleIterator.java:212)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> at com.inductiveautomation.ignition.common.expressions.functions.BaseFunction.executeAll(BaseFunction.java:64)
> at com.automation_pros.simaids.expressions.SimpleIterator.execute(SimpleIterator.java:177)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> at com.inductiveautomation.ignition.common.expressions.SubscriptExpression.execute(SubscriptExpression.java:50)
> at com.inductiveautomation.ignition.common.expressions.functions.BaseFunction.executeAll(BaseFunction.java:64)
> at com.automation_pros.simaids.expressions.AsList.execute(AsList.java:39)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> at com.inductiveautomation.ignition.common.expressions.functions.BaseFunction.executeAll(BaseFunction.java:64)
> at com.automation_pros.simaids.expressions.Flatten.execute(Flatten.java:37)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> at com.inductiveautomation.ignition.common.expressions.functions.BaseFunction.executeAll(BaseFunction.java:64)
> at com.automation_pros.simaids.expressions.UnionAll.execute(UnionAll.java:52)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.client.expressions.ClientDynamicDispatchFunction.execute(ClientDynamicDispatchFunction.java:43)
> at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> at com.inductiveautomation.ignition.common.expressions.DefaultFunctionFactory$ColumnRearrangeFunction.execute(DefaultFunctionFactory.java:1837)
> at com.inductiveautomation.ignition.common.expressions.FunctionExpression.execute(FunctionExpression.java:69)
> at com.inductiveautomation.factorypmi.application.binding.ExpressionPropertyAdapter.runExpression(ExpressionPropertyAdapter.java:83)
> ... 15 more
> 
> Ignition v8.1.24 (b2023011208)
> Java: Azul Systems, Inc. 11.0.16.1
> 
> ```

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 13, 2023, 1:40pm UTC](https://forum.inductiveautomation.com/t/simulation-aids-where-and-orderby-expressions-through-illegalargumentexception/77231/10 "2023-08-13T13:40:55Z")

</div>

Thanks for the detailed report. Found and fixed a stale data bug in `groupBy()`. Also fixed the NPE in `columnsOf()`. (The null source was the failures in `groupBy`, as far as I can tell.)

> [@Automation Professionals' Integration Toolkit Module](https://forum.inductiveautomation.com/t/automation-professionals-simulation-aids-v2/74934/60):
>
> Another NPE cleanup and a fix in groupBy() which was the root cause: For Ignition v8.1+: v2.0.10.232251331 { Cleaned out old links and removed buggy files from my server. }