CMDBuild Forum

2.2.0 - Error occourred while loading/saving data

Old Versions
#1 
<style type="text/css">p { margin-bottom: 0.25cm; line-height: 120%; }</style>

I use CentOS 6.5, jdk1.8.0_05 (also tried jdk1.7.0_21), tomcat 7.0.54 (also tried tomcat 6.0.41), but in all cases this error occurs.


I am having problem trying to install last cmdbuild v. 2.2.0 on a server. I deploy the war file. I connect to the web interface and enter the information concerning database, user, etc... I choose an empty database.


But I click the finish button, I'm getting the following error :


Error occourred while loading/saving data


When I click show details links, I get this trace :


Call: services/json/configure/apply

------------------------------------

Error: org.cmdbuild.exception.ORMException: ORM_GENERIC_ERROR

at org.cmdbuild.exception.ORMException$ORMExceptionType.createException(ORMException.java:59)

at org.cmdbuild.services.database.DatabaseConfigurator.configure(DatabaseConfigurator.java:169)

at org.cmdbuild.services.database.DatabaseConfigurator.configureAndSaveSettings(DatabaseConfigurator.java:147)

at org.cmdbuild.servlets.json.Configure.apply(Configure.java:164)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:601)

at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:97)

at org.cmdbuild.servlets.JSONDispatcher.doPost(JSONDispatcher.java:57)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)

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:158)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

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:48)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

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:52)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

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:722)




Please, tell me what went wrong

#2
Hi Leonid,
CMDBuild requires JDK 1.6 Sun / Oracle. Can you give it a try? 
 
Best regards
Anna Pascoletti
 
Previously Leonid wrote:

I use CentOS 6.5, jdk1.8.0_05 (also tried jdk1.7.0_21), tomcat 7.0.54 (also tried tomcat 6.0.41), but in all cases this error occurs.

 

I am having problem trying to install last cmdbuild v. 2.2.0 on a server. I deploy the war file. I connect to the web interface and enter the information concerning database, user, etc... I choose an empty database.

 

But I click the finish button, I'm getting the following error :

 

Error occourred while loading/saving data

 

When I click show details links, I get this trace :

 

Call: services/json/configure/apply

------------------------------------

Error: org.cmdbuild.exception.ORMException: ORM_GENERIC_ERROR

at org.cmdbuild.exception.ORMException$ORMExceptionType.createException(ORMException.java:59)

at org.cmdbuild.services.database.DatabaseConfigurator.configure(DatabaseConfigurator.java:169)

at org.cmdbuild.services.database.DatabaseConfigurator.configureAndSaveSettings(DatabaseConfigurator.java:147)

at org.cmdbuild.servlets.json.Configure.apply(Configure.java:164)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:601)

at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:97)

at org.cmdbuild.servlets.JSONDispatcher.doPost(JSONDispatcher.java:57)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)

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:158)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

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:48)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

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:52)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

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:722)

 

 

 

Please, tell me what went wrong

 

#3
Hi Pascoletti,
 
Removed OpenJDK 1.7 and Tried with Oracle JDK 1.7, but still same problem.
 
Regards,
K Soma Sundara Pandian.
 
Previously Tecnoteca wrote:
Hi Leonid,
CMDBuild requires JDK 1.6 Sun / Oracle. Can you give it a try? 
 
Best regards
Anna Pascoletti
 
Previously Leonid wrote:

I use CentOS 6.5, jdk1.8.0_05 (also tried jdk1.7.0_21), tomcat 7.0.54 (also tried tomcat 6.0.41), but in all cases this error occurs.

 

I am having problem trying to install last cmdbuild v. 2.2.0 on a server. I deploy the war file. I connect to the web interface and enter the information concerning database, user, etc... I choose an empty database.

 

But I click the finish button, I'm getting the following error :

 

Error occourred while loading/saving data

 

When I click show details links, I get this trace :

 

Call: services/json/configure/apply

------------------------------------

Error: org.cmdbuild.exception.ORMException: ORM_GENERIC_ERROR

at org.cmdbuild.exception.ORMException$ORMExceptionType.createException(ORMException.java:59)

at org.cmdbuild.services.database.DatabaseConfigurator.configure(DatabaseConfigurator.java:169)

at org.cmdbuild.services.database.DatabaseConfigurator.configureAndSaveSettings(DatabaseConfigurator.java:147)

at org.cmdbuild.servlets.json.Configure.apply(Configure.java:164)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:601)

at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:97)

at org.cmdbuild.servlets.JSONDispatcher.doPost(JSONDispatcher.java:57)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)

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:158)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

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:48)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

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:52)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

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:722)

 

 

 

Please, tell me what went wrong

 

 

#4

You have to use Oracle JDK 1.6, not Oracle JDK 1.7

CMDBuild Team

#5
The problem I ran into was that none of the schemas install the plpgsql language (this on RHEL6). I had to add the line:
  CREATE LANGUAGE plpgsql;
to cmdbuild/WEB-INF/sql/sample_schemas/demo_schema.sql and cmdbuild/WEB-INF/sql/base_schema/01_system_functions_base.sql, and the system installed just fine.
 
Previously K Soma Sundara Pandian wrote:
Hi Pascoletti,
 
Removed OpenJDK 1.7 and Tried with Oracle JDK 1.7, but still same problem.
 
Regards,
K Soma Sundara Pandian.
 
Previously Tecnoteca wrote:
Hi Leonid,
CMDBuild requires JDK 1.6 Sun / Oracle. Can you give it a try? 
 
Best regards
Anna Pascoletti
 
Previously Leonid wrote:

I use CentOS 6.5, jdk1.8.0_05 (also tried jdk1.7.0_21), tomcat 7.0.54 (also tried tomcat 6.0.41), but in all cases this error occurs.

 

I am having problem trying to install last cmdbuild v. 2.2.0 on a server. I deploy the war file. I connect to the web interface and enter the information concerning database, user, etc... I choose an empty database.

 

But I click the finish button, I'm getting the following error :

 

Error occourred while loading/saving data

 

When I click show details links, I get this trace :

 

Call: services/json/configure/apply

------------------------------------

Error: org.cmdbuild.exception.ORMException: ORM_GENERIC_ERROR

at org.cmdbuild.exception.ORMException$ORMExceptionType.createException(ORMException.java:59)

at org.cmdbuild.services.database.DatabaseConfigurator.configure(DatabaseConfigurator.java:169)

at org.cmdbuild.services.database.DatabaseConfigurator.configureAndSaveSettings(DatabaseConfigurator.java:147)

at org.cmdbuild.servlets.json.Configure.apply(Configure.java:164)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:601)

at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:97)

at org.cmdbuild.servlets.JSONDispatcher.doPost(JSONDispatcher.java:57)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)

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:158)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

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:48)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

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:52)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

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:722)

 

 

 

Please, tell me what went wrong

 

 

 

#6

FYI I’m using Centos 6.5, JDK 1.7.0_51-b13, tomcat 7.0.52 and Postgres 9.3.5 and it works fine. I didn’t want to use an outdated JDK

or tomcat.

 

JDK 1.6 was EOL as of Feb 2013 from what I can tell.