Hi, I tried the TopBraid insight tutorial (http://topquadrant.com/docs/tbi/tutorial/) on my TBCME 4.4.0 with a MySQL database. After having created a database, punched in the TBI configuration parameters and gotten the connection going (prompted for password in tbc -> tables are created by TBC) I get an exception trace.
I provide details below. Anyone has had this or a similar problem? I do realize I'm probably doing something stupid, so any hint would be welcome. :-) Morten F. -------------------------------------------------------DETAILS------------------------------------------------ Step in tutorial where it fails: Pressing Submit right at the beginning of step 3. Stack trace: -------------------- An unexpected error has occured. If you believe this is due to an issue with TopBraid Composer, then please consider to report the problem to [email protected] and ideally include an export of the Error Log View (Window > Show View > Error Log). On: May 20, 2014 11:57:28 AM Reason: java.io.IOException: Failed to execute SWP engine at org.topbraid.spin.swp.engine.XMLEngine.run(XMLEngine.java:109) at org.topbraid.spin.swp.servlet.SWPServletUtil.runUncached(SWPServletUtil.java:744) at org.topbraid.spin.swp.servlet.SWPServletUtil.run(SWPServletUtil.java:501) at org.topbraidlive.swp.servlet.SWPServlet.run(SWPServlet.java:169) at org.topbraidlive.swp.servlet.SWPServlet.run(SWPServlet.java:150) at org.topbraidlive.swp.servlet.SWPServlet.run(SWPServlet.java:132) at org.topbraidlive.swp.servlet.SWPServlet.doGet(SWPServlet.java:61) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at org.topbraid.auth.servlet.TBAuthEnabledServlet.service(TBAuthEnabledServlet.java:37) at org.topbraid.eclipsex.servlet.TBHttpServlet.service(TBHttpServlet.java:125) at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180) at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:317) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:586) Caused by: java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at org.topbraid.spin.util.ExceptionUtil.throwUnchecked(ExceptionUtil.java:47) at org.topbraidlive.tbi.elements.CreateWorkspaceCallable.create(CreateWorkspaceCallable.java:86) at org.topbraidlive.tbi.elements.CreateWorkspaceControlElement.run(CreateWorkspaceControlElement.java:24) at org.topbraid.spin.swp.engine.SWPEngine.createNodes(SWPEngine.java:532) at org.topbraid.spin.swp.engine.SWPEngine.createNodesFromPrototype(SWPEngine.java:613) at org.topbraid.spin.swp.engine.SWPEngine.createNodes(SWPEngine.java:527) at org.topbraid.spin.swp.engine.SWPEngine.createNodes(SWPEngine.java:491) at org.topbraid.spin.swp.engine.SWPEngine.run(SWPEngine.java:1113) at org.topbraid.spin.swp.engine.XMLEngine.run(XMLEngine.java:103) ... 28 more Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:192) at org.topbraidlive.tbi.elements.CreateWorkspaceCallable.create(CreateWorkspaceCallable.java:82) ... 35 more Caused by: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at org.topbraid.spin.util.ExceptionUtil.throwUnchecked(ExceptionUtil.java:47) at org.topbraidlive.tbi.elements.CreateWorkspaceCallable.create(CreateWorkspaceCallable.java:155) at org.topbraidlive.tbi.elements.CreateWorkspaceCallable.call(CreateWorkspaceCallable.java:123) at org.topbraidlive.tbi.elements.CreateWorkspaceCallable.call(CreateWorkspaceCallable.java:1) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.reflect.InvocationTargetException at org.topbraid.sdb.graph.SDBUtil.performFinish(SDBUtil.java:64) at org.topbraidlive.tbi.elements.CreateWorkspaceCallable.writeSDB(CreateWorkspaceCallable.java:260) at org.topbraidlive.tbi.elements.CreateWorkspaceCallable.create(CreateWorkspaceCallable.java:152) ... 8 more Caused by: org.topbraid.spin.sparqlmotion.modules.SMException: Problem creating new tables at org.topbraid.sdb.graph.ExportToSDBModule.execute(ExportToSDBModule.java:61) at org.topbraid.spin.sparqlmotion.engine.impl.ExecutionEngineImpl.execute(ExecutionEngineImpl.java:204) at org.topbraid.spin.sparqlmotion.engine.impl.ExecutionEngineImpl.executeModule(ExecutionEngineImpl.java:170) at org.topbraid.spin.sparqlmotion.engine.impl.ExecutionEngineImpl.execute(ExecutionEngineImpl.java:120) at org.topbraid.sdb.graph.SDBUtil.performFinish(SDBUtil.java:59) ... 10 more Caused by: com.hp.hpl.jena.sdb.sql.SDBExceptionSQL: SQLException indexing table 'Triples' at com.hp.hpl.jena.sdb.layout2.FmtLayout2.addIndexesTableTriples(FmtLayout2.java:88) at com.hp.hpl.jena.sdb.layout2.FmtLayout2.addIndexes(FmtLayout2.java:55) at com.hp.hpl.jena.sdb.store.StoreFormatterBase.create(StoreFormatterBase.java:39) at org.topbraid.sdb.graph.ExportToSDBModule.execute(ExportToSDBModule.java:55) ... 14 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate key name 'PredObj' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:408) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2812) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2761) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at com.hp.hpl.jena.sdb.sql.SDBConnection.exec(SDBConnection.java:183) at com.hp.hpl.jena.sdb.layout2.FmtLayout2.addIndexesTableTriples(FmtLayout2.java:86) ... 17 more Platform: -------------- Linux Mint 64-bit $ mysql --version mysql Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (x86_64) using readline 6.2 /local/tbcme $ ls -R | grep mysql mysql-connector-java-5.1.26-bin.jar Database: -------------- mysql> show tables; +--------------------------------+ | Tables_in_tbl_insight_tutorial | +--------------------------------+ | Nodes | | Prefixes | | Quads | | Triples | +--------------------------------+ 4 rows in set (0.00 sec) tbi configuration: ------------------------- TBI root project: TBIData SDB URL: jdbc:mysql://localhost:3306/tbl_insight_tutorial SDB database type: MySQL SDB user name: evn2 -- -- 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] To unsubscribe from this group, send email to [email protected] 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]. For more options, visit https://groups.google.com/d/optout.
