Support Forum

[mikolg]

Добрый день,

При переносе задач в дереве (cut\paste) большинство задач переносится нормально, но некоторые падают с ошибкой (см. ниже).
Как это можно исправить?

Используем версию TrackStudio 5.0.7.20160822

HTTP Status 500 - org.apache.jasper.JasperException: An exception occurred processing JSP page /jsp/Error.jsp at line 114
type Exception report
message org.apache.jasper.JasperException: An exception occurred processing JSP page /jsp/Error.jsp at line 114
description The server encountered an internal error that prevented it from fulfilling this request.
exception

javax.servlet.ServletException: org.apache.jasper.JasperException: An exception occurred processing JSP page /jsp/Error.jsp at line 114

111: "License Type: " + Config.getInstance().getProperty("trackstudio.license.type") + "\n"+
112: "Database Information:\n"+
113: "Database: " + Config.getInstance().getDatabaseMetadata().getDatabaseProductName() + "\n" +
114: "Database version:" + Config.getInstance().getDatabaseMetadata().getDatabaseProductVersion() + "\n"+
115: "Database major version:" + Config.getInstance().getDatabaseMetadata().getDatabaseMajorVersion() + "\n"+
116: "Database minor version:" + Config.getInstance().getDatabaseMetadata().getDatabaseMinorVersion() + "\n"+
117: "Database driver name:" + Config.getInstance().getDatabaseMetadata().getDriverName() + "\n"+


Stacktrace:
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:286)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
com.trackstudio.action.TSStrutsServlet.doGet(TSStrutsServlet.java:36)
com.trackstudio.action.TSStrutsServlet.doPost(TSStrutsServlet.java:44)
javax.servlet.http.HttpServlet.service(Unknown Source)
javax.servlet.http.HttpServlet.service(Unknown Source)
org.apache.tomcat.websocket.server.WsFilter.doFilter(Unknown Source)
jcifs.http.NtlmHttpFilter.doFilter(NtlmHttpFilter.java:130)
com.trackstudio.filters.CompressResponseFilter.doFilter(CompressResponseFilter.java:64)

root cause

org.apache.jasper.JasperException: An exception occurred processing JSP page /jsp/Error.jsp at line 114

111: "License Type: " + Config.getInstance().getProperty("trackstudio.license.type") + "\n"+
112: "Database Information:\n"+
113: "Database: " + Config.getInstance().getDatabaseMetadata().getDatabaseProductName() + "\n" +
114: "Database version:" + Config.getInstance().getDatabaseMetadata().getDatabaseProductVersion() + "\n"+
115: "Database major version:" + Config.getInstance().getDatabaseMetadata().getDatabaseMajorVersion() + "\n"+
116: "Database minor version:" + Config.getInstance().getDatabaseMetadata().getDatabaseMinorVersion() + "\n"+
117: "Database driver name:" + Config.getInstance().getDatabaseMetadata().getDriverName() + "\n"+


Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(Unknown Source)
org.apache.jasper.servlet.JspServletWrapper.service(Unknown Source)
org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source)
org.apache.jasper.servlet.JspServlet.service(Unknown Source)
javax.servlet.http.HttpServlet.service(Unknown Source)
org.apache.tomcat.websocket.server.WsFilter.doFilter(Unknown Source)
org.apache.struts.chain.commands.servlet.PerformForward.handleAsForward(PerformForward.java:113)
org.apache.struts.chain.commands.servlet.PerformForward.perform(PerformForward.java:96)
org.apache.struts.chain.commands.AbstractPerformForward.execute(AbstractPerformForward.java:54)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
com.trackstudio.action.TSStrutsServlet.doGet(TSStrutsServlet.java:36)
com.trackstudio.action.TSStrutsServlet.doPost(TSStrutsServlet.java:44)
javax.servlet.http.HttpServlet.service(Unknown Source)
javax.servlet.http.HttpServlet.service(Unknown Source)
org.apache.tomcat.websocket.server.WsFilter.doFilter(Unknown Source)
jcifs.http.NtlmHttpFilter.doFilter(NtlmHttpFilter.java:130)
com.trackstudio.filters.CompressResponseFilter.doFilter(CompressResponseFilter.java:64)

root cause

javax.servlet.ServletException: java.sql.SQLException: You can't operate on a closed DatabaseMetaData!!!
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(Unknown Source)
org.apache.jasper.runtime.PageContextImpl.handlePageException(Unknown Source)
org.apache.jsp.jsp.Error_jsp._jspService(Error_jsp.java:306)
org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
javax.servlet.http.HttpServlet.service(Unknown Source)
org.apache.jasper.servlet.JspServletWrapper.service(Unknown Source)
org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source)
org.apache.jasper.servlet.JspServlet.service(Unknown Source)
javax.servlet.http.HttpServlet.service(Unknown Source)
org.apache.tomcat.websocket.server.WsFilter.doFilter(Unknown Source)
org.apache.struts.chain.commands.servlet.PerformForward.handleAsForward(PerformForward.java:113)
org.apache.struts.chain.commands.servlet.PerformForward.perform(PerformForward.java:96)
org.apache.struts.chain.commands.AbstractPerformForward.execute(AbstractPerformForward.java:54)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
com.trackstudio.action.TSStrutsServlet.doGet(TSStrutsServlet.java:36)
com.trackstudio.action.TSStrutsServlet.doPost(TSStrutsServlet.java:44)
javax.servlet.http.HttpServlet.service(Unknown Source)
javax.servlet.http.HttpServlet.service(Unknown Source)
org.apache.tomcat.websocket.server.WsFilter.doFilter(Unknown Source)
jcifs.http.NtlmHttpFilter.doFilter(NtlmHttpFilter.java:130)
com.trackstudio.filters.CompressResponseFilter.doFilter(CompressResponseFilter.java:64)

root cause

java.sql.SQLException: You can't operate on a closed DatabaseMetaData!!!
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getDatabaseProductVersion(NewProxyDatabaseMetaData.java:228)
org.apache.jsp.jsp.Error_jsp._jspService(Error_jsp.java:231)
org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
javax.servlet.http.HttpServlet.service(Unknown Source)
org.apache.jasper.servlet.JspServletWrapper.service(Unknown Source)
org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source)
org.apache.jasper.servlet.JspServlet.service(Unknown Source)
javax.servlet.http.HttpServlet.service(Unknown Source)
org.apache.tomcat.websocket.server.WsFilter.doFilter(Unknown Source)
org.apache.struts.chain.commands.servlet.PerformForward.handleAsForward(PerformForward.java:113)
org.apache.struts.chain.commands.servlet.PerformForward.perform(PerformForward.java:96)
org.apache.struts.chain.commands.AbstractPerformForward.execute(AbstractPerformForward.java:54)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
com.trackstudio.action.TSStrutsServlet.doGet(TSStrutsServlet.java:36)
com.trackstudio.action.TSStrutsServlet.doPost(TSStrutsServlet.java:44)
javax.servlet.http.HttpServlet.service(Unknown Source)
javax.servlet.http.HttpServlet.service(Unknown Source)
org.apache.tomcat.websocket.server.WsFilter.doFilter(Unknown Source)
jcifs.http.NtlmHttpFilter.doFilter(NtlmHttpFilter.java:130)
com.trackstudio.filters.CompressResponseFilter.doFilter(CompressResponseFilter.java:64)

root cause

java.lang.NullPointerException
com.mysql.jdbc.ConnectionImpl.getServerVersion(ConnectionImpl.java:3339)
com.mysql.jdbc.DatabaseMetaData.getDatabaseProductVersion(DatabaseMetaData.java:3195)
com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getDatabaseProductVersion(NewProxyDatabaseMetaData.java:222)
org.apache.jsp.jsp.Error_jsp._jspService(Error_jsp.java:231)
org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
javax.servlet.http.HttpServlet.service(Unknown Source)
org.apache.jasper.servlet.JspServletWrapper.service(Unknown Source)
org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source)
org.apache.jasper.servlet.JspServlet.service(Unknown Source)
javax.servlet.http.HttpServlet.service(Unknown Source)
org.apache.tomcat.websocket.server.WsFilter.doFilter(Unknown Source)
org.apache.struts.chain.commands.servlet.PerformForward.handleAsForward(PerformForward.java:113)
org.apache.struts.chain.commands.servlet.PerformForward.perform(PerformForward.java:96)
org.apache.struts.chain.commands.AbstractPerformForward.execute(AbstractPerformForward.java:54)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
com.trackstudio.action.TSStrutsServlet.doGet(TSStrutsServlet.java:36)
com.trackstudio.action.TSStrutsServlet.doPost(TSStrutsServlet.java:44)
javax.servlet.http.HttpServlet.service(Unknown Source)
javax.servlet.http.HttpServlet.service(Unknown Source)
org.apache.tomcat.websocket.server.WsFilter.doFilter(Unknown Source)
jcifs.http.NtlmHttpFilter.doFilter(NtlmHttpFilter.java:130)
com.trackstudio.filters.CompressResponseFilter.doFilter(CompressResponseFilter.java:64)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.68-gentoo logs.

[admin]

Причина ошибки вот в этом

java.lang.NullPointerException
com.mysql.jdbc.ConnectionImpl.getServerVersion(ConnectionImpl.java:3339)
com.mysql.jdbc.DatabaseMetaData.getDatabaseProductVersion(DatabaseMetaData.java:3195)
com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getDatabaseProductVersion(NewProxyDatabaseMetaData.java:222)

Т.е. валится jdbc-драйвер mysql при попытке получить версию сервера. Попробуйте обновить jdbc-драйвера mysql и положить новую версию в webapps/TrackStudio/WEB-INF/lib

[mikolg]

Т.е. валится jdbc-драйвер mysql при попытке получить версию сервера.

Мы попробуем конечно, но очень смущает, что на данный момент нам известно всего 3 задачи, которые мы не можем перенести.
Все остальные задачи переносятся из папки в папку без проблем.

Не похоже на проблему в jdbc драйвере ))

[mikolg]

Подложил mysql-connector-java-5.1.44-bin.jar
теперь при переносе этой задачи возникает другая ошибка.

И я понял в чём проблема. У нас есть служебный пользователь с именем "@test". И этот пользователь был вписан в UDF поле в этой задаче.
Вы позволяете таких пользователей создавать, а работать с ними похоже не всегда получается.

Сможете поправить?

HTTP Status 500 - Cannot find object class com.trackstudio.model.User with ID test .
type Exception report
message Cannot find object class com.trackstudio.model.User with ID test .
description The server encountered an internal error that prevented it from fulfilling this request.

exception

com.trackstudio.exception.CantFindObjectException: Cannot find object class com.trackstudio.model.User with ID test .
com.trackstudio.kernel.manager.FindManager.findUser(FindManager.java:524)
com.trackstudio.securedkernel.SecuredUDFAdapterManager.convertValue(SecuredUDFAdapterManager.java:1358)
com.trackstudio.securedkernel.SecuredUDFAdapterManager.setUdfValue(SecuredUDFAdapterManager.java:1220)
com.trackstudio.securedkernel.SecuredUDFAdapterManager.setTaskUDFValueSimple(SecuredUDFAdapterManager.java:1171)
com.trackstudio.secured.SecuredTaskTriggerBean.update(SecuredTaskTriggerBean.java:274)
com.trackstudio.app.TriggerManager.moveTask(TriggerManager.java:344)
com.trackstudio.securedkernel.SecuredTaskAdapterManager.moveTask(SecuredTaskAdapterManager.java:711)
com.trackstudio.securedkernel.SecuredTaskAdapterManager.pasteTasks(SecuredTaskAdapterManager.java:681)
com.trackstudio.action.task.SubtaskAction.paste(SubtaskAction.java:809)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:606)
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
com.trackstudio.action.TSDispatchAction.execute(TSDispatchAction.java:75)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
com.trackstudio.action.TSStrutsServlet.doGet(TSStrutsServlet.java:36)
com.trackstudio.action.TSStrutsServlet.doPost(TSStrutsServlet.java:44)
javax.servlet.http.HttpServlet.service(Unknown Source)
javax.servlet.http.HttpServlet.service(Unknown Source)
org.apache.tomcat.websocket.server.WsFilter.doFilter(Unknown Source)
jcifs.http.NtlmHttpFilter.doFilter(NtlmHttpFilter.java:130)
com.trackstudio.filters.CompressResponseFilter.doFilter(CompressResponseFilter.java:64)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.68-gentoo logs.