Hi, I have an issue that is similar to the posted issue but I believe that the root cause is different, I use TopBraid Composer version 5.1.0 This issue didn't appear before I upload 62MB rdf data file, EVN starts to cache the data takes a long time causing disk performance in device manager screen to be 100% by heavily accessing the mysql database.
After taking long time (more than 40 minutes) the issue with the below stack trace appear: --------------------------------------------------------------------------------------- !ENTRY org.topbraidlive.swp 2 0 2016-03-08 09:46:39.459 !MESSAGE Exception in SWP Engine: java.lang.NullPointerException Pseudo-code of surrounding call stack: <ui:loadable id="tabs-FormSearchHomePageTab" ui:loadOnDemand=true> <ui:if ui:condition=true> <ui:setContext ui:varName="swaTabKey"^^xsd:string ui:varValue="FormSearchHomePageTab"> <ui:setContext ui:varName="swaTabStorageKey"^^xsd:string ui:varValue="evn-home-tab"^^xsd:string> <ui:dynamicView ui:class=<http://topbraid.org/teamwork#FormSearchHomePageTab>> <ui:setContext ui:class=<http://topbraid.org/teamwork#FormSearchHomePageTab>> <ui:setContext ui:queryGraph=<urn:x-union:urn%3Ax-evn-union%3AAdministrator:http%3A%2F%2Ftopbraid.org%2Fmetadata:http%3A%2F%2Ftopbraid.org%2Fteamwork>> !STACK 0 java.lang.NullPointerException at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1134) at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5733) at org.apache.commons.dbcp2.DelegatingResultSet.getString(DelegatingResultSet.java:267) at org.apache.commons.dbcp2.DelegatingResultSet.getString(DelegatingResultSet.java:267) at com.hp.hpl.jena.sdb.layout2.SQLBridge2.assembleBinding(SQLBridge2.java:211) at com.hp.hpl.jena.sdb.store.SQLBridgeBase$QueryIterSQL.moveToNextBinding(SQLBridgeBase.java:198) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.nextBinding(QueryIteratorBase.java:154) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorWrapper.moveToNextBinding(QueryIteratorWrapper.java:43) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.nextBinding(QueryIteratorBase.java:154) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorWrapper.moveToNextBinding(QueryIteratorWrapper.java:43) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.nextBinding(QueryIteratorBase.java:154) at com.hp.hpl.jena.sdb.graph.GraphSDB.graphBaseFind(GraphSDB.java:184) at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:268) at org.topbraid.core.graph.concurrent.ThreadSafeGraph.threadSafeFind(ThreadSafeGraph.java:250) at org.topbraid.core.graph.concurrent.ThreadSafeGraph.find(ThreadSafeGraph.java:240) at org.topbraid.core.graph.concurrent.ThreadSafeGraph.find(ThreadSafeGraph.java:300) at org.topbraid.core.graph.CachingAllGraph.cacheAll(CachingAllGraph.java:39) at org.topbraid.core.graph.CachingAllGraph.<init>(CachingAllGraph.java:30) at org.topbraidcomposer.editors.utils.AbstractTBCPersonality.createCachingGraph(AbstractTBCPersonality.java:123) at org.topbraid.sparqlmotion.database.DatabaseRegistry$1.create(DatabaseRegistry.java:26) at org.topbraid.sparqlmotion.database.DatabaseRegistry$1.create(DatabaseRegistry.java:1) at org.topbraid.javax.util.ConcurrentCreateWeakValueMapEx.getOrCreate(ConcurrentCreateWeakValueMapEx.java:71) at org.topbraid.sparqlmotion.database.DatabaseGraphStore.getGraph(DatabaseGraphStore.java:85) And another related, subsequent stack traces: java.io.IOException: Failed to execute SWP engine for view 6496edcb:1535508923c:-7bc7 of type http://uispin.org/ui#loadable at org.topbraid.spin.swp.engine.XMLEngine.run(XMLEngine.java:118) at org.topbraid.spin.swp.servlet.SWPServletUtil.runUncached(SWPServletUtil.java:814) at org.topbraid.spin.swp.servlet.SWPServletUtil.run(SWPServletUtil.java:538) at org.topbraidlive.swp.servlet.SWPServlet.run(SWPServlet.java:159) at org.topbraidlive.swp.servlet.SWPServlet.run(SWPServlet.java:136) at org.topbraidlive.swp.servlet.SWPServlet.run(SWPServlet.java:115) at org.topbraidlive.swp.servlet.SWPServlet.doGet(SWPServlet.java:68) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at org.topbraid.auth.servlet.TBAuthEnabledServlet.service(TBAuthEnabledServlet.java:41) at org.topbraid.eclipsex.servlet.TBHttpServlet.service(TBHttpServlet.java:155) at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180) at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl$LegacyServlet.service(HttpServiceRuntimeImpl.java:1232) at org.eclipse.equinox.http.servlet.internal.registration.EndpointRegistration.service(EndpointRegistration.java:153) at org.eclipse.equinox.http.servlet.internal.servlet.ResponseStateHandler.processRequest(ResponseStateHandler.java:63) at org.eclipse.equinox.http.servlet.internal.context.DispatchTargets.doDispatch(DispatchTargets.java:98) at org.eclipse.equinox.http.servlet.internal.HttpServiceRuntimeImpl.doDispatch(HttpServiceRuntimeImpl.java:372) at org.eclipse.equinox.http.servlet.internal.servlet.ProxyServlet.service(ProxyServlet.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:357) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221) . . . at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.NullPointerException at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1134) at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5733) at org.apache.commons.dbcp2.DelegatingResultSet.getString(DelegatingResultSet.java:267) at org.apache.commons.dbcp2.DelegatingResultSet.getString(DelegatingResultSet.java:267) at com.hp.hpl.jena.sdb.layout2.SQLBridge2.assembleBinding(SQLBridge2.java:211) at com.hp.hpl.jena.sdb.store.SQLBridgeBase$QueryIterSQL.moveToNextBinding(SQLBridgeBase.java:198) Sorry for posting stack trace like this Your support is so much appreciated. On Wednesday, May 21, 2014 at 3:19:08 PM UTC+2, Mark Graham wrote: > > Hi Morten, > > Thanks for the update. Glad this is working now. And thanks for the > documentation input. Very helpful and will see if we can add that. > > Mark > > Thanks, > Mark > > > Mark Graham > TopQuadrant Support > > *PRODUCT SUPPORT:* > > [email protected] <javascript:> > http://www.topquadrant.com/products/support.html > > > > > On Wed, May 21, 2014 at 3:55 AM, morten forfang <[email protected] > <javascript:>> wrote: > >> Hi, >> >> Thanks for the quick response. >> >> This reply will be a good one for you and a bad and possibly embarrassing >> one for me; >> >> On a rebooted host I did the exercise again this morning and it seems to >> work now. I had saved all the steps I did (as I always do when I do this >> kind of work), and I just reran them on a clean database, and it worked. No >> errors. No nothing. So, for the purposes of this thread, I thank you for >> your willingness to help and we might close this issue. >> >> -- >> >> On a sidenote however, as far as I can find, the tutorial ( >> http://topquadrant.com/docs/tbi/tutorial) presupposes a database setup >> before you can complete step 2 in the tutorial, but supplies no concrete >> information on how to do that (turorial-style if you'd like). So, I include >> the steps I did below, for TQ's reference and my suggestion would be that >> perhaps the tutorial could feature a step 0 or an appendix that deals with >> the database setup? >> >> Thanks again and sorry for the trouble. >> >> M. >> >> -----------------------------------------------------------my mysql >> database setup steps-------------------------------------------- >> >> mysql> create database tbl_insight_tutorial; >> Query OK, 1 row affected (0.00 sec) >> mysql> use tbl_insight_tutorial; >> Database changed >> mysql> grant usage on *.* to evn2@localhost identified by 'xxx'; >> Query OK, 0 rows affected (0.00 sec) >> mysql> GRANT ALL PRIVILEGES ON *.* TO 'evn2'@'localhost' WITH GRANT OPTION; >> Query OK, 0 rows affected (0.00 sec) >> >> >> >> -- >> -- You received this message because you are subscribed to the Google >> Group "TopBraid Suite Users", the topics of which include Enterprise >> Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid >> Insight, SPARQLMotion, SPARQL Web Pages and SPIN. >> To post to this group, send email to >> [email protected] <javascript:> >> To unsubscribe from this group, send email to >> [email protected] <javascript:> >> For more options, visit this group at >> http://groups.google.com/group/topbraid-users?hl=en >> --- >> You received this message because you are subscribed to the Google Groups >> "TopBraid Suite Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), Reference Data Manager (RDM), TopBraid Composer, TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to [email protected] --- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
