Can't create a new class

[juanlop...@gmail.com]

Hello,

I'm getting this error whenever I try to create a new class:

2023-04-28 12:20:18,686 ERROR [OperationController] edu.cornell.mannlib.vedit.controller.OperationController encountered exception performing edit action
2023-04-28 12:20:18,686 ERROR [OperationController] org.apache.jena.sdb.sql.SDBExceptionSQL: SQLException in executing SQL statement
org.apache.jena.sdb.sql.SDBExceptionSQL: SQLException in executing SQL statement
at org.apache.jena.sdb.compiler.SDB_QC.exec(SDB_QC.java:82)
at org.apache.jena.sdb.compiler.OpSQL.exec(OpSQL.java:64)
at org.apache.jena.sdb.engine.QueryEngineSDB.eval(QueryEngineSDB.java:158)
at org.apache.jena.sparql.engine.QueryEngineBase.evaluate(QueryEngineBase.java:176)
at org.apache.jena.sparql.engine.QueryEngineBase.createPlan(QueryEngineBase.java:132)
at org.apache.jena.sparql.engine.QueryEngineBase.getPlan(QueryEngineBase.java:113)
at org.apache.jena.sdb.engine.QueryEngineSDB$QueryEngineFactorySDB.create(QueryEngineSDB.java:185)
at org.apache.jena.sparql.engine.QueryExecutionBase.getPlan(QueryExecutionBase.java:601)
at org.apache.jena.sparql.engine.QueryExecutionBase.startQueryIterator(QueryExecutionBase.java:548)
at org.apache.jena.sparql.engine.QueryExecutionBase.execResultSet(QueryExecutionBase.java:591)
at org.apache.jena.sparql.engine.QueryExecutionBase.execSelect(QueryExecutionBase.java:200)
at edu.cornell.mannlib.vitro.webapp.rdfservice.impl.jena.RDFServiceJena.sparqlSelectQuery(RDFServiceJena.java:506)
at edu.cornell.mannlib.vitro.webapp.rdfservice.impl.logging.LoggingRDFService.sparqlSelectQuery(LoggingRDFService.java:80)
at edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.execSelect(RDFServiceGraph.java:561)
at edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.contains(RDFServiceGraph.java:238)
at edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.find(RDFServiceGraph.java:327)
at edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.find(RDFServiceGraph.java:264)
at org.apache.jena.graph.compose.MultiUnion.singleGraphFind(MultiUnion.java:157)
at org.apache.jena.graph.compose.MultiUnion.graphBaseFind(MultiUnion.java:148)
at org.apache.jena.graph.impl.GraphBase.find(GraphBase.java:244)
at edu.cornell.mannlib.vitro.webapp.rdfservice.adapters.AbstractGraphDecorator.find(AbstractGraphDecorator.java:78)
at edu.cornell.mannlib.vitro.webapp.rdfservice.filter.LanguageFilteringGraph.find(LanguageFilteringGraph.java:39)
at org.apache.jena.graph.compose.MultiUnion.singleGraphFind(MultiUnion.java:157)
at org.apache.jena.graph.compose.MultiUnion.graphBaseFind(MultiUnion.java:148)
at org.apache.jena.graph.impl.GraphBase.find(GraphBase.java:244)
at org.apache.jena.graph.impl.GraphBase.graphBaseFind(GraphBase.java:261)
at org.apache.jena.graph.impl.GraphBase.find(GraphBase.java:258)
at org.apache.jena.rdf.model.impl.ModelCom.listStatements(ModelCom.java:498)
at org.apache.jena.rdf.model.impl.ModelCom.listStatements(ModelCom.java:503)
at edu.cornell.mannlib.vitro.webapp.utils.jena.URIUtils.anyStatements(URIUtils.java:60)
at edu.cornell.mannlib.vitro.webapp.utils.jena.URIUtils.hasEditableEntity(URIUtils.java:40)
at edu.cornell.mannlib.vitro.webapp.dao.jena.WebappDaoFactoryJena.hasEditableEntity(WebappDaoFactoryJena.java:239)
at edu.cornell.mannlib.vitro.webapp.dao.jena.WebappDaoFactoryJena.checkURIForEditableEntity(WebappDaoFactoryJena.java:202)
at edu.cornell.mannlib.vitro.webapp.dao.jena.VClassDaoJena.insertNewVClass(VClassDaoJena.java:936)
at edu.cornell.mannlib.vitro.webapp.dao.jena.VClassDaoJena.insertNewVClass(VClassDaoJena.java:712)
at edu.cornell.mannlib.vitro.webapp.dao.filtering.VClassDaoFiltering.insertNewVClass(VClassDaoFiltering.java:156)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at edu.cornell.mannlib.vedit.controller.OperationController.performEdit(OperationController.java:460)
at edu.cornell.mannlib.vedit.controller.OperationController.doPost(OperationController.java:120)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at edu.cornell.mannlib.vitro.webapp.controller.VitroHttpServlet.service(VitroHttpServlet.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.filters.ExpiresFilter.doFilter(ExpiresFilter.java:1230)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at edu.cornell.mannlib.vitro.webapp.filters.PageRoutingFilter.doNonDisplayPage(PageRoutingFilter.java:112)
at edu.cornell.mannlib.vitro.webapp.filters.PageRoutingFilter.doFilter(PageRoutingFilter.java:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at edu.cornell.mannlib.vitro.webapp.filters.ClickjackFilter.doFilter(ClickjackFilter.java:34)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at edu.cornell.mannlib.vitro.webapp.filters.RequestModelsPrep.doFilter(RequestModelsPrep.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at edu.cornell.mannlib.vitro.webapp.filters.URLRewriterFilter.doFilter(URLRewriterFilter.java:40)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at edu.cornell.mannlib.vitro.webapp.filters.JSessionStripFilter.doFilter(JSessionStripFilter.java:63)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at edu.cornell.mannlib.vitro.webapp.filters.CachingResponseFilter.produceBasicResponse(CachingResponseFilter.java:321)
at edu.cornell.mannlib.vitro.webapp.filters.CachingResponseFilter.doFilter(CachingResponseFilter.java:120)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at edu.cornell.mannlib.vitro.webapp.i18n.selection.LocaleSelectionFilter.doFilter(LocaleSelectionFilter.java:64)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at edu.cornell.mannlib.vitro.webapp.filters.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:36)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at edu.cornell.mannlib.vitro.webapp.filters.SessionTimeoutLimitingFilter.doFilter(SessionTimeoutLimitingFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at edu.cornell.mannlib.vitro.webapp.filters.StartupStatusDisplayFilter.doFilter(StartupStatusDisplayFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:394)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1385)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Connection is null.
at org.apache.commons.dbcp2.DelegatingConnection.checkOpen(DelegatingConnection.java:612)
at org.apache.commons.dbcp2.DelegatingConnection.createStatement(DelegatingConnection.java:275)
at org.apache.jena.sdb.sql.SDBConnection.execQuery(SDBConnection.java:118)
at org.apache.jena.sdb.compiler.SDB_QC.exec(SDB_QC.java:70)
... 101 more

I can edit classes that already exists, but cannot create a new one.

I gave all privileges to the user that connects to the database but the error persists.

Does anyone knows what could be happening?

Best regards,

Juan.

[Dragan Ivanovic]

Hello Juan,

Thanks for your two emails and apologies for a slow response. Is this email related to the same VIVO instance as the previous one (about login error)? The error log in the previous email looks like you are using TDB, and this error log looks as you are using SDB? Can you provide more details about your configuration (applicationSetup.n3 and runtime.properties) and environment (SDB vs TDB, RDBMS, VIVO version, etc.)? I think it might be easier to discuss this further by using the VIVO Slack. I have noticed that you are already registered for the Slack, can you please try to login there to continue discussion? Thanks!

Regards,

Dragan

--
You received this message because you are subscribed to the Google Groups "VIVO Tech" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vivo-tech+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/vivo-tech/f4303377-c26b-4639-9188-6304e6fc02a9n%40googlegroups.com.

[juanlop...@gmail.com]

Hello Dragan,

I'll follow this discussion via Slack.

Thanks for the reply!