Not sure why this came up but for some reason I am still tracking historical tag trends, although I cant see my SQL tags.
And refreshing the Tag Browser doesnt resolve this?
no
What error is this bringing up? Is there something in the ignition gateway console that could tell us more about this error? You can also select Help from within the designer, then Diagnostics, the console in there should show an error. Copy and paste them here so we can see what they are saying.
INFO [main-Designer-Startup] Downloading… [+0]
INFO [main-Designer-Startup] Cleanup… [+50]
INFO [main-Designer-Startup] Initializing UI… [+50]
INFO [DatasourceTagManager-Designer-Startup] Starting up polling tag manager, polling rate: 250ms
INFO [ScriptManager-Designer-Startup] Creating Script Library at ‘C:\Users\AJ\AppData\LocalLow\Sun\Java\Deployment\cache\FPMI\script_lib2’.
INFO [ScriptManager-Designer-Startup] Created Script Library at ‘C:\Users\AJ\AppData\LocalLow\Sun\Java\Deployment\cache\FPMI\script_lib2’.
INFO [main-Designer-Startup] Starting module: Vision [+1733]
INFO [DatasourceTagManager-SQLTags-TreeLoader-thread-1] Starting SQLTags polling.
ERROR [TagProviderNode-SQLTags-TreeLoader-thread-1] Error loading tags underneath
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:265)
at com.inductiveautomation.ignition.designer.sqltags.tree.TagProviderNode.loadTagChildren(TagProviderNode.java:75)
at com.inductiveautomation.ignition.designer.sqltags.tree.TagProviderNode.loadChildren(TagProviderNode.java:63)
at com.inductiveautomation.ignition.designer.sqltags.tree.AbstractTagPathTreeNode$Loader.run(AbstractTagPathTreeNode.java:79)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Error executing gateway function.
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:312)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:286)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:243)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.invoke(GatewayInterface.java:783)
at com.inductiveautomation.ignition.client.sqltags.impl.db.DatasourceTagManager.browse(DatasourceTagManager.java:488)
… 11 more
Caused by: java.lang.NullPointerException
at com.inductiveautomation.ignition.gateway.sqltags.providers.AbstractStoreBasedTagProvider.wrapTagsToDef(AbstractStoreBasedTagProvider.java:1187)
at com.inductiveautomation.ignition.gateway.sqltags.providers.AbstractStoreBasedTagProvider.browse(AbstractStoreBasedTagProvider.java:1142)
at com.inductiveautomation.ignition.gateway.sqltags.providers.RedundantProviderWrapper.browse(RedundantProviderWrapper.java:123)
at com.inductiveautomation.ignition.gateway.sqltags.SQLTagsManagerImpl.browse(SQLTagsManagerImpl.java:405)
at com.inductiveautomation.ignition.gateway.project.ProjectSettingsCache$ProjectDefaultTagManagerFacade.browse(ProjectSettingsCache.java:495)
at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.SQLTags.browse(SQLTags.java:124)
at sun.reflect.GeneratedMethodAccessor39.invoke(null)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(null)
at java.lang.reflect.Method.invoke(null)
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)
at java.lang.Thread.run(null)
INFO [main-Designer-Startup] Starting module: SQL Bridge [+21971]
INFO [main-Designer-Startup] Starting module: Mobile [+22380]
INFO [main-Designer-Startup] Starting module: Reporting [+22381]
INFO [ReportingDesignerHook-Designer-Startup] Starting up Reporting Module. Mode: Trial
Initializing ReportMill (Build Date: May-27-05, Version 9.0, JVM 23.0-b21, User AJ)
INFO [main-Designer-Startup] Starting module: Symbol Factory [+23210]
INFO [main-Designer-Startup] Initializing Scripting… [+23475]
INFO [main-Designer-Startup] Starting Tag System… [+23475]
INFO [main-Designer-Startup] Initializing UI… [+23478]
Can you check the Default SQLTags provider for the project you opened? It should say something like “default” and you can find it under Configuration -> Projects in the Ignition Gateway.
localhost:8088/main/web/config/conf.projects
So, the problem is purely in the browsing function, which is why everything is still working. There’s 2 things that can be done to fix this: 1) we can track down the problem on our side and/or 2) We can try to figure out what’s leading to the error, and perhaps tweak your internal database so that it avoids it.
However, I just had a thought: did this start after you tried to move/delete some tags? If so, simply restarting the gateway might solve the problem. If restarting doesn’t help, the quickest way for us to fix it is for you to send us a gateway backup. That way, we can just load it up and see what it’s trying to browse that it doesn’t like.
Let me know if you’ve already tried restarting the gateway. If so, also let me know the exact version you’re currently using.
Regards,
[quote=“Colby.Clegg”]So, the problem is purely in the browsing function, which is why everything is still working. There’s 2 things that can be done to fix this: 1) we can track down the problem on our side and/or 2) We can try to figure out what’s leading to the error, and perhaps tweak your internal database so that it avoids it.
However, I just had a thought: did this start after you tried to move/delete some tags? If so, simply restarting the gateway might solve the problem. If restarting doesn’t help, the quickest way for us to fix it is for you to send us a gateway backup. That way, we can just load it up and see what it’s trying to browse that it doesn’t like.
Let me know if you’ve already tried restarting the gateway. If so, also let me know the exact version you’re currently using.
Regards,[/quote]
restarting the gateway worked. thanks