# \[IGN-14133\] Error when selecting ‘Show Builder’ in Report Data Sources

**URL:** <https://forum.inductiveautomation.com/t/ign-14133-error-when-selecting-show-builder-in-report-data-sources/110296>\
**Category:** Ignition 8.3 Early Access\
**Tags:** reporting\
**Created:** [August 31, 2025, 9:16am UTC](https://forum.inductiveautomation.com/t/ign-14133-error-when-selecting-show-builder-in-report-data-sources/110296 "2025-08-31T09:16:04Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![mieraf.sh](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mieraf.sh/32/76056_2.png) [@mieraf.sh](https://forum.inductiveautomation.com/u/mieraf.sh)\
**Post date:** [August 31, 2025, 9:16am UTC](https://forum.inductiveautomation.com/t/ign-14133-error-when-selecting-show-builder-in-report-data-sources/110296/1 "2025-08-31T09:16:04Z")

</div>

I am using Ignition 8.3. Could you please assist me with the following error? The error occurs when I select _Show Builder_ in the Data Sources section of Reports

 ![SQL_TABLE](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/e/1ed3aa863bf3d438ed87d0db7f9d114bad855fa9.png)

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [August 31, 2025, 5:57pm UTC](https://forum.inductiveautomation.com/t/ign-14133-error-when-selecting-show-builder-in-report-data-sources/110296/2 "2025-08-31T17:57:43Z")

</div>

Click the details tab of the error and copy and paste the entire details here as preformatted text, see [Wiki - how to post code on this forum](https://forum.inductiveautomation.com/t/wiki-how-to-post-code-on-this-forum/77831).

Also, what happens if you delete the query source and make a new one?

---

<div class="post-metadata">

**Author:** ![mieraf.sh](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mieraf.sh/32/76056_2.png) [@mieraf.sh](https://forum.inductiveautomation.com/u/mieraf.sh)\
**Post date:** [September 1, 2025, 12:01pm UTC](https://forum.inductiveautomation.com/t/ign-14133-error-when-selecting-show-builder-in-report-data-sources/110296/3 "2025-09-01T12:01:08Z")

</div>

NullPointerException: Cannot invoke "java.lang.Integer.intValue()" because "columnSize" is null

```python
Ignition v8.3.0-beta2 (b2025080409)Java: Azul Systems, Inc. 17.0.15

```

---

<div class="post-metadata">

**Author:** ![mieraf.sh](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mieraf.sh/32/76056_2.png) [@mieraf.sh](https://forum.inductiveautomation.com/u/mieraf.sh)\
**Post date:** [September 1, 2025, 12:18pm UTC](https://forum.inductiveautomation.com/t/ign-14133-error-when-selecting-show-builder-in-report-data-sources/110296/4 "2025-09-01T12:18:13Z")

</div>

> [@ryan.white](#):
>
> Also, what happens if you delete the query source and make a new one? the following is the only table I have

 ![mysql_table](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/0/40ccf68c26d8a981f00e925e3c0fd047dff63e03.png)

 ![mysql](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/1/31624934d0ef49abca6b8968b1e30b8322fa94fc.png)

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [September 2, 2025, 2:45pm UTC](https://forum.inductiveautomation.com/t/ign-14133-error-when-selecting-show-builder-in-report-data-sources/110296/5 "2025-09-02T14:45:14Z")

</div>

Can you post the entire stack trace that’s found on the details tab? This will help us solve the problem.

---

<div class="post-metadata">

**Author:** ![mieraf.sh](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mieraf.sh/32/76056_2.png) [@mieraf.sh](https://forum.inductiveautomation.com/u/mieraf.sh)\
**Post date:** [September 2, 2025, 3:28pm UTC](https://forum.inductiveautomation.com/t/ign-14133-error-when-selecting-show-builder-in-report-data-sources/110296/6 "2025-09-02T15:28:04Z")

</div>

```python
java.lang.NullPointerException: Cannot invoke "java.lang.Integer.intValue()" because "columnSize" is null
	at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.DatasourceRpcImpl.listColumns(DatasourceRpcImpl.java:260)
	at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(:0)
	at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(:0)
	at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(:0)
	at java.lang.reflect.Method.invoke(:0)
	at com.inductiveautomation.ignition.gateway.rpc.RpcDelegate$DelegateRpcHandler.handle(RpcDelegate.java:271)
	at com.inductiveautomation.ignition.gateway.rpc.RpcRoutes.lambda$handle$1(RpcRoutes.java:199)
	at com.inductiveautomation.ignition.gateway.rpc.RpcRoutes.safelyHandle(RpcRoutes.java:219)
	at com.inductiveautomation.ignition.gateway.rpc.RpcRoutes.handle(RpcRoutes.java:198)
	at com.inductiveautomation.ignition.gateway.dataroutes.Route.service(Route.java:361)
	at com.inductiveautomation.ignition.gateway.dataroutes.RouteGroupImpl.service(RouteGroupImpl.java:120)
	at com.inductiveautomation.ignition.gateway.dataroutes.RouteGroupCollectionServlet.serviceInternal(RouteGroupCollectionServlet.java:133)
	at com.inductiveautomation.ignition.gateway.dataroutes.AbstractRouteGroupServlet.service(AbstractRouteGroupServlet.java:40)
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
	at org.eclipse.jetty.ee10.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1379)
	at org.eclipse.jetty.ee10.servlet.ServletHolder.handle(ServletHolder.java:736)
	at org.eclipse.jetty.ee10.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1614)
	at com.inductiveautomation.catapult.filters.GatewayFilter.doFilter(GatewayFilter.java:116)
	at jakarta.servlet.http.HttpFilter.doFilter(HttpFilter.java:97)
	at org.eclipse.jetty.ee10.servlet.FilterHolder.doFilter(FilterHolder.java:208)
	at org.eclipse.jetty.ee10.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1586)
	at org.eclipse.jetty.ee10.servlet.ServletHandler$MappedServlet.handle(ServletHandler.java:1547)
	at org.eclipse.jetty.ee10.servlet.ServletChannel.dispatch(ServletChannel.java:819)
	at org.eclipse.jetty.ee10.servlet.ServletChannel.handle(ServletChannel.java:436)
	at org.eclipse.jetty.ee10.servlet.ServletHandler.handle(ServletHandler.java:464)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:575)
	at org.eclipse.jetty.ee10.servlet.SessionHandler.handle(SessionHandler.java:717)
	at org.eclipse.jetty.server.handler.ContextHandler.handle(ContextHandler.java:1060)
	at org.eclipse.jetty.rewrite.handler.RewriteHandler$LastRuleHandler.handle(RewriteHandler.java:159)
	at org.eclipse.jetty.rewrite.handler.Rule$Handler.handle(Rule.java:108)
	at org.eclipse.jetty.rewrite.handler.HeaderPatternRule$1.handle(HeaderPatternRule.java:89)
	at org.eclipse.jetty.rewrite.handler.Rule$Handler.handle(Rule.java:108)
	at org.eclipse.jetty.rewrite.handler.HeaderPatternRule$1.handle(HeaderPatternRule.java:89)
	at org.eclipse.jetty.rewrite.handler.Rule$Handler.handle(Rule.java:108)
	at org.eclipse.jetty.rewrite.handler.HeaderPatternRule$1.handle(HeaderPatternRule.java:89)
	at org.eclipse.jetty.rewrite.handler.Rule$Handler.handle(Rule.java:108)
	at org.eclipse.jetty.rewrite.handler.HeaderPatternRule$1.handle(HeaderPatternRule.java:89)
	at org.eclipse.jetty.rewrite.handler.Rule$Handler.handle(Rule.java:108)
	at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:143)
	at org.eclipse.jetty.server.Handler$Sequence.handle(Handler.java:805)
	at org.eclipse.jetty.server.Handler$Sequence.handle(Handler.java:805)
	at org.eclipse.jetty.server.Server.handle(Server.java:182)
	at org.eclipse.jetty.server.internal.HttpChannelState$HandlerInvoker.run(HttpChannelState.java:662)
	at org.eclipse.jetty.server.internal.HttpConnection.onFillable(HttpConnection.java:418)
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:322)
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:99)
	at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)
	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:478)
	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:441)
	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:293)
	at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run(AdaptiveExecutionStrategy.java:201)
	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:311)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:979)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1209)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1164)
	at java.lang.Thread.run(:0)

Ignition v8.3.0-beta2 (b2025080409)
Java: Azul Systems, Inc. 17.0.15

```

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [September 2, 2025, 4:22pm UTC](https://forum.inductiveautomation.com/t/ign-14133-error-when-selecting-show-builder-in-report-data-sources/110296/7 "2025-09-02T16:22:09Z")

</div>

Thanks, that helps. The problem is that the 'column size' being returned for at least one of the columns in that table is being returned as null, and due to a bug on our side we're not protecting against that.

Can you show what your table data types look like in MySQL Workbench? We can absolutely reproduce it and fix it either way - just as a point of curiosity.

The JDBC specification for the function we're ultimately using says this:

> The COLUMN\_SIZE column specifies the column size for the given column. For numeric data, this is the maximum precision. For character data, this is the length in characters. For datetime datatypes, this is the length in characters of the String representation (assuming the maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, this is the length in bytes. Null is returned for data types where the column size is not applicable.

So I'm interested in which of your columns might be causing us issues.

---

<div class="post-metadata">

**Author:** ![mieraf.sh](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mieraf.sh/32/76056_2.png) [@mieraf.sh](https://forum.inductiveautomation.com/u/mieraf.sh)\
**Post date:** [September 3, 2025, 9:09am UTC](https://forum.inductiveautomation.com/t/ign-14133-error-when-selecting-show-builder-in-report-data-sources/110296/8 "2025-09-03T09:09:52Z")

</div>

![Table_dt](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/7/976b342d651f5bc3bf6d43be76d3252b004a0d2d.png)

 ![dt](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/a/2a1c46f095b81d65e10b8748127b6e0e6c730ec7.png)

---

<div class="post-metadata">

**Author:** ![mieraf.sh](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mieraf.sh/32/76056_2.png) [@mieraf.sh](https://forum.inductiveautomation.com/u/mieraf.sh)\
**Post date:** [September 3, 2025, 9:18am UTC](https://forum.inductiveautomation.com/t/ign-14133-error-when-selecting-show-builder-in-report-data-sources/110296/9 "2025-09-03T09:18:17Z")

</div>

![ex](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/b/1b2afe7ba9087f683b98d65f7264be8a57912125.png)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [September 3, 2025, 3:34pm UTC](https://forum.inductiveautomation.com/t/ign-14133-error-when-selecting-show-builder-in-report-data-sources/110296/10 "2025-09-03T15:34:24Z")

</div>

Thanks - we're working the issue internally and will have it fixed by 8.3.0 final.
