CMDBuild Forum

Problem since upgrade to 2.1.5 with history tab

Old Versions
#1

I recently upgraded from version 2.1.4 to 2.1.5 and since then I'm getting a problem reading the 'history' tab for some existing classes as well as any newly created ones.

The following exception gets raised as soon as i click the 'history' tab.

Thanks in advance for any replies and/or comments

regards

 

Call: services/json/management/modcard/getcardhistory?_dc=1384340710882
------------------------------------------------------------------------
Error: java.lang.NullPointerException
	at org.cmdbuild.dao.view.user.UserDataView.whereClauseForUser(UserDataView.java:232)
	at org.cmdbuild.dao.view.user.UserDataView.executeQuery(UserDataView.java:212)
	at org.cmdbuild.dao.view.user.UserDataView.executeQuery(UserDataView.java:59)
	at org.cmdbuild.dao.view.ForwardingDataView.executeQuery(ForwardingDataView.java:157)
	at org.cmdbuild.dao.query.QuerySpecsBuilder.run(QuerySpecsBuilder.java:492)
	at org.cmdbuild.logic.commands.GetRelationHistory.exec(GetRelationHistory.java:28)
	at org.cmdbuild.logic.data.access.DefaultDataAccessLogic.getRelationHistory(DefaultDataAccessLogic.java:148)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
	at com.sun.proxy.$Proxy102.getRelationHistory(Unknown Source)
	at org.cmdbuild.servlets.json.management.ModCard.getCardHistory(ModCard.java:442)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:94)
	at org.cmdbuild.servlets.JSONDispatcher.doGet(JSONDispatcher.java:60)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:144)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:33)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:39)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	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:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:662)

#2
Dear Mario,
 
we are not aware of such issue. Would you provide us your database and some more detail in how to reproduce the error?
 
For example:
* does it happen for all classes or some specific ones?
* did you perform some manual operations on the database or using UI only?
* ...
 
Best regards.
 
-- Davide Pavan
 
Previously Mario wrote:

I recently upgraded from version 2.1.4 to 2.1.5 and since then I'm getting a problem reading the 'history' tab for some existing classes as well as any newly created ones.

The following exception gets raised as soon as i click the 'history' tab.

Thanks in advance for any replies and/or comments

regards

 

Call: services/json/management/modcard/getcardhistory?_dc=1384340710882
------------------------------------------------------------------------
Error: java.lang.NullPointerException
	at org.cmdbuild.dao.view.user.UserDataView.whereClauseForUser(UserDataView.java:232)
	at org.cmdbuild.dao.view.user.UserDataView.executeQuery(UserDataView.java:212)
	at org.cmdbuild.dao.view.user.UserDataView.executeQuery(UserDataView.java:59)
	at org.cmdbuild.dao.view.ForwardingDataView.executeQuery(ForwardingDataView.java:157)
	at org.cmdbuild.dao.query.QuerySpecsBuilder.run(QuerySpecsBuilder.java:492)
	at org.cmdbuild.logic.commands.GetRelationHistory.exec(GetRelationHistory.java:28)
	at org.cmdbuild.logic.data.access.DefaultDataAccessLogic.getRelationHistory(DefaultDataAccessLogic.java:148)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
	at com.sun.proxy.$Proxy102.getRelationHistory(Unknown Source)
	at org.cmdbuild.servlets.json.management.ModCard.getCardHistory(ModCard.java:442)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:94)
	at org.cmdbuild.servlets.JSONDispatcher.doGet(JSONDispatcher.java:60)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:144)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:33)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:39)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	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:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:662)

 

 

#3
Hi Davide,
 
Surely can, can you let me know, where I can drop a copy of my database, I will include instructions on how to reproduce the problem within a text file once I deliver the db dump.
 
Thanks & regards
Mario
 
Previously Tecnoteca wrote:
Dear Mario,
 
we are not aware of such issue. Would you provide us your database and some more detail in how to reproduce the error?
 
For example:
* does it happen for all classes or some specific ones?
* did you perform some manual operations on the database or using UI only?
* ...
 
Best regards.
 
-- Davide Pavan
 
Previously Mario wrote:

I recently upgraded from version 2.1.4 to 2.1.5 and since then I'm getting a problem reading the 'history' tab for some existing classes as well as any newly created ones.

The following exception gets raised as soon as i click the 'history' tab.

Thanks in advance for any replies and/or comments

regards

 

Call: services/json/management/modcard/getcardhistory?_dc=1384340710882
------------------------------------------------------------------------
Error: java.lang.NullPointerException
	at org.cmdbuild.dao.view.user.UserDataView.whereClauseForUser(UserDataView.java:232)
	at org.cmdbuild.dao.view.user.UserDataView.executeQuery(UserDataView.java:212)
	at org.cmdbuild.dao.view.user.UserDataView.executeQuery(UserDataView.java:59)
	at org.cmdbuild.dao.view.ForwardingDataView.executeQuery(ForwardingDataView.java:157)
	at org.cmdbuild.dao.query.QuerySpecsBuilder.run(QuerySpecsBuilder.java:492)
	at org.cmdbuild.logic.commands.GetRelationHistory.exec(GetRelationHistory.java:28)
	at org.cmdbuild.logic.data.access.DefaultDataAccessLogic.getRelationHistory(DefaultDataAccessLogic.java:148)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
	at com.sun.proxy.$Proxy102.getRelationHistory(Unknown Source)
	at org.cmdbuild.servlets.json.management.ModCard.getCardHistory(ModCard.java:442)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:94)
	at org.cmdbuild.servlets.JSONDispatcher.doGet(JSONDispatcher.java:60)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:144)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:33)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:39)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	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:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:662)

 

 

 

#4

I confirm this error. I have created a class called “test” in CMDBuild Demo site. Insert two cards “test” and “test1”. Open history tab. and there it is the error. Moving from card “test” and “test1” also give the error. Then I edit card “test1” adding word “edited” it is now “test1 edited” the info succesfully change but there is no history.

 
All of my old classed are working fine. It only affected new classes created after the upgrade to 2.1.5.
 
Here is the screen capture.
 
http://farm4.staticflickr.com/3746/11231317876_ae89c69f5a_o.jpg
#5

This is a known bug and occurs if the class has no domains.
It will be fixed in next releases.
In the meantime, as a workaround, you can create a fake domain on your class and this avoids the error.
CMDBuild Team

#6
Thanks.
 
Previously Tecnoteca wrote:
This is a known bug and occurs if the class has no domains.
It will be fixed in next releases.
In the meantime, as a workaround, you can create a fake domain on your class and this avoids the error.
CMDBuild Team