# Sqltags browser corrupted

**URL:** <https://forum.inductiveautomation.com/t/sqltags-browser-corrupted/6392>\
**Category:** Ignition\
**Created:** [May 7, 2013, 3:55am UTC](https://forum.inductiveautomation.com/t/sqltags-browser-corrupted/6392 "2013-05-07T03:55:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gekkoman](https://avatars.discourse-cdn.com/v4/letter/g/c89c15/32.png) [@gekkoman](https://forum.inductiveautomation.com/u/gekkoman)\
**Post date:** [May 7, 2013, 3:55am UTC](https://forum.inductiveautomation.com/t/sqltags-browser-corrupted/6392/1 "2013-05-07T03:55:03Z")

</div>

Ignition 7.5.6 (b1317) trial

Have a UDT “PAC3200” with folder structure and OPC tags to communicate with Siemens PAC3200 power monitor.

Created duplicate tagname in UDT, to that added manually in an instance of a PAC3200 UDT. This appears to have been cause of problem.

Image attached.

Windows using the PAC3200 instances remain running so it appears to be a browsing bug.

Have tried to remove the duplicate tag in UDT but problem persists.

Console shows

ERROR [TagTreeNode-AWT-EventQueue-0] Error loading children of node: Power\_Meter  
java.lang.RuntimeException: com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: Error executing gateway function.  
at com.inductiveautomation.ignition.client.sqltags.impl.db.DatasourceTagManager.browse(DatasourceTagManager.java:491)  
at com.inductiveautomation.ignition.client.sqltags.impl.db.DatasourceTagManager.browse(DatasourceTagManager.java:473)  
at com.inductiveautomation.ignition.client.sqltags.impl.ClientTagManagerImpl.browse(ClientTagManagerImpl.java:277)  
at com.inductiveautomation.ignition.designer.sqltags.tree.TagTreeNode.loadChildren(TagTreeNode.java:227)  
at com.inductiveautomation.ignition.designer.sqltags.tree.AbstractTagPathTreeNode$Loader.run(AbstractTagPathTreeNode.java:79)  
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)  
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)  
at java.util.concurrent.FutureTask.run(FutureTask.java:166)  
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)  
at java.lang.Thread.run(Thread.java:722)  
Caused by: com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: Error executing gateway function.  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.newGatewayException(GatewayInterface.java:313)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.sendMessage(GatewayInterface.java:287)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.sendMessage(GatewayInterface.java:244)  
at com.inductiveautomation.ignition.client.gateway\_interface.GatewayInterface.invoke(GatewayInterface.java:797)  
at com.inductiveautomation.ignition.client.sqltags.impl.db.DatasourceTagManager.browse(DatasourceTagManager.java:488)  
… 10 more  
Caused by: java.lang.NullPointerException  
at com.inductiveautomation.ignition.common.sqltags.TagDefinition.(TagDefinition.java:128)  
at com.inductiveautomation.ignition.common.sqltags.TagDefinition.(TagDefinition.java:119)  
at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.SQLTags.wrap(SQLTags.java:256)  
at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.SQLTags.browse(SQLTags.java:134)  
at sun.reflect.GeneratedMethodAccessor35.invoke(null)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:601)  
at com.inductiveautomation.ignition.gateway.servlets.gateway.AbstractGatewayFunction.invoke(AbstractGatewayFunction.java:176)  
at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:398)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)  
at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:85)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)  
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)  
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)  
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)  
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)  
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)  
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)  
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)  
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)  
… 1 more  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/690d2ec18b73ea07d41d241bc5f4eb510054f332.jpg)

---

<div class="post-metadata">

**Author:** ![gekkoman](https://avatars.discourse-cdn.com/v4/letter/g/c89c15/32.png) [@gekkoman](https://forum.inductiveautomation.com/u/gekkoman)\
**Post date:** [May 7, 2013, 4:07am UTC](https://forum.inductiveautomation.com/t/sqltags-browser-corrupted/6392/2 "2013-05-07T04:07:11Z")

</div>

Really odd.

Restarted Gateway and the PAC3200 Instances replaced by folders in SQLTags Browser with the same name as PAC3200 instances.

Could not delete/rename folders.

Restarted Gateway again and these folders are now gone.

Recreated PAC3200 instances and everything working again.