Hi, since it's the first time we encontred this problem we need to reproduce it (it seems that this problem won't show only in some db) and fix-it.
Could you please tell us if this problem is general (for all the classes) or class specific?
Thanks.
seaman ha scritto:
I Encountered a serious problem after upgrade CMDBuild from version 1.5 to 2.0.1When I logined CMDBuild as a common user, and clicked "relation" or "history" tab on the cards details UI, it showed me a error dialog: "An error has occurred Show details".The error details as below:java.lang.NullPointerExceptionat org.cmdbuild.dao.driver.postgres.query.ColumnMapper$AliasAttributes.getSqlTypeString(ColumnMapper.java:83)at org.cmdbuild.dao.driver.postgres.query.ColumnMapper$AliasAttributes.addAttribute(ColumnMapper.java:63)at org.cmdbuild.dao.driver.postgres.query.ColumnMapper.addAttribute(ColumnMapper.java:182)at org.cmdbuild.dao.driver.postgres.query.ColumnMapper.addUserSelectAttribute(ColumnMapper.java:223)at org.cmdbuild.dao.driver.postgres.query.QueryCreator.addUserSelectAttributes(QueryCreator.java:46)at org.cmdbuild.dao.driver.postgres.query.QueryCreator.quoteAttributes(QueryCreator.java:39)at org.cmdbuild.dao.driver.postgres.query.QueryCreator.appendSelect(QueryCreator.java:35)at org.cmdbuild.dao.driver.postgres.query.QueryCreator.buildQuery(QueryCreator.java:28)at org.cmdbuild.dao.driver.postgres.query.QueryCreator.(QueryCreator.java:24)at org.cmdbuild.dao.driver.postgres.EntryQueryCommand.run(EntryQueryCommand.java:40)at org.cmdbuild.dao.driver.postgres.PostgresDriver.query(PostgresDriver.java:94)at org.cmdbuild.dao.view.DBDataView.executeNonEmptyQuery(DBDataView.java:100)at org.cmdbuild.dao.view.user.UserDataView.executeNonEmptyQuery(UserDataView.java:139)at org.cmdbuild.dao.view.QueryExecutorDataView.executeQuery(QueryExecutorDataView.java:20)at org.cmdbuild.dao.query.QuerySpecsBuilder.run(QuerySpecsBuilder.java:218)at org.cmdbuild.logic.commands.GetRelationList.exec(GetRelationList.java:29)at org.cmdbuild.logic.DataAccessLogic.getRelationList(DataAccessLogic.java:28)at org.cmdbuild.servlets.json.management.ModCard.getRelationList(ModCard.java:729)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)at java.lang.reflect.Method.invoke(Unknown Source)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:54)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:28)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:37)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:293)at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594)at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)at java.lang.Thread.run(Unknown Source)The strange thing is, when I login CMDBuild as "Admin" account, every thing is ok.Is this a bug in CMDBuild 2.0? How to fix it?
Hi, since it's the first time we encontred this problem we need to reproduce it (it seems that this problem won't show only in some db) and fix-it.
Could you please tell us if this problem is general (for all the classes) or class specific?
Thanks.
seaman ha scritto:
I Encountered a serious problem after upgrade CMDBuild from version 1.5 to 2.0.1When I logined CMDBuild as a common user, and clicked "relation" or "history" tab on the cards details UI, it showed me a error dialog: "An error has occurred Show details".The error details as below:java.lang.NullPointerExceptionat org.cmdbuild.dao.driver.postgres.query.ColumnMapper$AliasAttributes.getSqlTypeString(ColumnMapper.java:83)at org.cmdbuild.dao.driver.postgres.query.ColumnMapper$AliasAttributes.addAttribute(ColumnMapper.java:63)at org.cmdbuild.dao.driver.postgres.query.ColumnMapper.addAttribute(ColumnMapper.java:182)at org.cmdbuild.dao.driver.postgres.query.ColumnMapper.addUserSelectAttribute(ColumnMapper.java:223)at org.cmdbuild.dao.driver.postgres.query.QueryCreator.addUserSelectAttributes(QueryCreator.java:46)at org.cmdbuild.dao.driver.postgres.query.QueryCreator.quoteAttributes(QueryCreator.java:39)at org.cmdbuild.dao.driver.postgres.query.QueryCreator.appendSelect(QueryCreator.java:35)at org.cmdbuild.dao.driver.postgres.query.QueryCreator.buildQuery(QueryCreator.java:28)at org.cmdbuild.dao.driver.postgres.query.QueryCreator.(QueryCreator.java:24)at org.cmdbuild.dao.driver.postgres.EntryQueryCommand.run(EntryQueryCommand.java:40)at org.cmdbuild.dao.driver.postgres.PostgresDriver.query(PostgresDriver.java:94)at org.cmdbuild.dao.view.DBDataView.executeNonEmptyQuery(DBDataView.java:100)at org.cmdbuild.dao.view.user.UserDataView.executeNonEmptyQuery(UserDataView.java:139)at org.cmdbuild.dao.view.QueryExecutorDataView.executeQuery(QueryExecutorDataView.java:20)at org.cmdbuild.dao.query.QuerySpecsBuilder.run(QuerySpecsBuilder.java:218)at org.cmdbuild.logic.commands.GetRelationList.exec(GetRelationList.java:29)at org.cmdbuild.logic.DataAccessLogic.getRelationList(DataAccessLogic.java:28)at org.cmdbuild.servlets.json.management.ModCard.getRelationList(ModCard.java:729)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)at java.lang.reflect.Method.invoke(Unknown Source)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:54)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:28)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:37)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:293)at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594)at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)at java.lang.Thread.run(Unknown Source)The strange thing is, when I login CMDBuild as "Admin" account, every thing is ok.Is this a bug in CMDBuild 2.0? How to fix it?
Hi, I found the way about how to reproduce this bug, here are the steps:1, create a class named "A" as parent class.2, create a class named "A1" as "A"'s sub-class3, create a class nameed "B" as parent class.4, create a class named "B2" as "B"'s sub-class5, create a "1:N" Domain from "A" to "B"6, login as non-admin account and create an "A1" object.7, click "history" or "relations" tab of "A1" object you just created, you can see the error dialog with NPE.8, login as admin account, "history" and "relations" tabs works well.Tecnoteca ha scritto:Hi, since it's the first time we encontred this problem we need to reproduce it (it seems that this problem won't show only in some db) and fix-it.
Could you please tell us if this problem is general (for all the classes) or class specific?
Thanks.
seaman ha scritto:
I Encountered a serious problem after upgrade CMDBuild from version 1.5 to 2.0.1When I logined CMDBuild as a common user, and clicked "relation" or "history" tab on the cards details UI, it showed me a error dialog: "An error has occurred Show details".The error details as below:java.lang.NullPointerExceptionat org.cmdbuild.dao.driver.postgres.query.ColumnMapper$AliasAttributes.getSqlTypeString(ColumnMapper.java:83)at org.cmdbuild.dao.driver.postgres.query.ColumnMapper$AliasAttributes.addAttribute(ColumnMapper.java:63)at org.cmdbuild.dao.driver.postgres.query.ColumnMapper.addAttribute(ColumnMapper.java:182)at org.cmdbuild.dao.driver.postgres.query.ColumnMapper.addUserSelectAttribute(ColumnMapper.java:223)at org.cmdbuild.dao.driver.postgres.query.QueryCreator.addUserSelectAttributes(QueryCreator.java:46)at org.cmdbuild.dao.driver.postgres.query.QueryCreator.quoteAttributes(QueryCreator.java:39)at org.cmdbuild.dao.driver.postgres.query.QueryCreator.appendSelect(QueryCreator.java:35)at org.cmdbuild.dao.driver.postgres.query.QueryCreator.buildQuery(QueryCreator.java:28)at org.cmdbuild.dao.driver.postgres.query.QueryCreator.(QueryCreator.java:24)at org.cmdbuild.dao.driver.postgres.EntryQueryCommand.run(EntryQueryCommand.java:40)at org.cmdbuild.dao.driver.postgres.PostgresDriver.query(PostgresDriver.java:94)at org.cmdbuild.dao.view.DBDataView.executeNonEmptyQuery(DBDataView.java:100)at org.cmdbuild.dao.view.user.UserDataView.executeNonEmptyQuery(UserDataView.java:139)at org.cmdbuild.dao.view.QueryExecutorDataView.executeQuery(QueryExecutorDataView.java:20)at org.cmdbuild.dao.query.QuerySpecsBuilder.run(QuerySpecsBuilder.java:218)at org.cmdbuild.logic.commands.GetRelationList.exec(GetRelationList.java:29)at org.cmdbuild.logic.DataAccessLogic.getRelationList(DataAccessLogic.java:28)at org.cmdbuild.servlets.json.management.ModCard.getRelationList(ModCard.java:729)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)at java.lang.reflect.Method.invoke(Unknown Source)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:54)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:28)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:37)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:293)at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594)at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)at java.lang.Thread.run(Unknown Source)The strange thing is, when I login CMDBuild as "Admin" account, every thing is ok.Is this a bug in CMDBuild 2.0? How to fix it?
Hi,
itwas a problem related to the comment of attribute Code, that occurs on a new classes, if Code had never been changed since the creation of the class.
It's fixed in the new CMDBuild version available on bitbucket:
https://bitbucket.org/tecnoteca/cmdbuild/downloads
Lu ha scritto:
Is any update?We also encountered this issue.
Hi
Unfortunately I can't compile cmdbuild from source code (there are many problems with unaccessible maven repository). Could you say how can I resolve this problem without compiling cmdbuild from sources?
Previously Tecnoteca wrote:
Hi,
itwas a problem related to the comment of attribute Code, that occurs on a new classes, if Code had never been changed since the creation of the class.
It's fixed in the new CMDBuild version available on bitbucket:
https://bitbucket.org/tecnoteca/cmdbuild/downloads
Lu ha scritto:
Is any update?We also encountered this issue.