CMDBuild Forum

java.lang.NullPointerException

Old Versions
#1

I use 2.1.2 version  "import CVS file"  function to batch import assets. When I finished and browse the asset. I page down, it appears the below error:

Call: services/json/management/modcard/getcardlist?_dc=1370671086694 --------------------------------------------------------------------- Error: java.lang.NullPointerException at org.cmdbuild.logic.data.access.resolver.ReferenceAndLookupSerializer.visit(ReferenceAndLookupSerializer.java:27) at org.cmdbuild.dao.entrytype.attributetype.LookupAttributeType.accept(LookupAttributeType.java:24) at org.cmdbuild.logic.data.access.resolver.ForeignReferenceResolver$1.apply(ForeignReferenceResolver.java:152) at org.cmdbuild.logic.data.access.resolver.ForeignReferenceResolver$1.apply(ForeignReferenceResolver.java:127) at com.google.common.collect.Iterators$9.transform(Iterators.java:893) at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48) at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48) at org.cmdbuild.servlets.json.serializers.CardSerializer.toClient(CardSerializer.java:70) at org.cmdbuild.servlets.json.serializers.CardSerializer.toClient(CardSerializer.java:59) at org.cmdbuild.servlets.json.management.ModCard.getCardList(ModCard.java:187) at org.cmdbuild.servlets.json.management.ModCard.getCardList(ModCard.java:96) 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:717) 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:133) 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:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662)

 

Then, I suspect it may some items of assets cause the error, I login psql and modify some items, unluckily, it totally down.  Now I can't browse the certain  classes's items , but other's ok.

#2
It seems that the database has some inconsistencies. Look at the table corresponding to the class that you are querying and then check if Lookups and References (probably Lookups) corresponds to a valid value. For example a Lookup attribute could be setted to a valid Id but that Id could not be the Id of a Lookup.  Did you di some operations manually on the database or did you imported some data from CSV?
 
If you could provide us the database that you are using we could do some checks.
 
Best regards.
 
-- Davide Pavan
 
Previously jaseywang wrote:

I use 2.1.2 version  "import CVS file"  function to batch import assets. When I finished and browse the asset. I page down, it appears the below error:

Call: services/json/management/modcard/getcardlist?_dc=1370671086694 --------------------------------------------------------------------- Error: java.lang.NullPointerException at org.cmdbuild.logic.data.access.resolver.ReferenceAndLookupSerializer.visit(ReferenceAndLookupSerializer.java:27) at org.cmdbuild.dao.entrytype.attributetype.LookupAttributeType.accept(LookupAttributeType.java:24) at org.cmdbuild.logic.data.access.resolver.ForeignReferenceResolver$1.apply(ForeignReferenceResolver.java:152) at org.cmdbuild.logic.data.access.resolver.ForeignReferenceResolver$1.apply(ForeignReferenceResolver.java:127) at com.google.common.collect.Iterators$9.transform(Iterators.java:893) at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48) at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48) at org.cmdbuild.servlets.json.serializers.CardSerializer.toClient(CardSerializer.java:70) at org.cmdbuild.servlets.json.serializers.CardSerializer.toClient(CardSerializer.java:59) at org.cmdbuild.servlets.json.management.ModCard.getCardList(ModCard.java:187) at org.cmdbuild.servlets.json.management.ModCard.getCardList(ModCard.java:96) 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:717) 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:133) 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:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662)

 

Then, I suspect it may some items of assets cause the error, I login psql and modify some items, unluckily, it totally down.  Now I can't browse the certain  classes's items , but other's ok.