CMDBuild Forum

Error when adding a new class

Old Versions
#1

I get this error when trying to add a new class… 

 
SQL error: ERROR: query string argument of EXECUTE is null Where: PL/pgSQL function "cm_create_class" line 28 at EXECUTE statement

the detail error is presented like this

org.cmdbuild.exception.ORMException: ORM_ERROR_GENERIC_SQL ERROR: query string argument of EXECUTE is null
  Where: PL/pgSQL function "cm_create_class" line 28 at EXECUTE statement
	at org.cmdbuild.exception.ORMException$ORMExceptionType.createException(ORMException.java:58)
	at org.cmdbuild.dao.backend.postgresql.PGCMBackend$CMSqlException.throwGenericException(PGCMBackend.java:124)
	at org.cmdbuild.dao.backend.postgresql.PGCMBackend$CMSqlException.throwCustomExceptionFrom(PGCMBackend.java:109)
	at org.cmdbuild.dao.backend.postgresql.PGCMBackend$SqlState.throwCustomExceptionFrom(PGCMBackend.java:171)
	at org.cmdbuild.dao.backend.postgresql.PGCMBackend.createTable(PGCMBackend.java:323)
	at org.cmdbuild.elements.TableImpl.save(TableImpl.java:181)
	at org.cmdbuild.elements.proxy.TableForwarder.save(TableForwarder.java:35)
	at org.cmdbuild.elements.proxy.TableProxy.save(TableProxy.java:59)
	at org.cmdbuild.servlets.json.schema.ModClass.saveTable(ModClass.java:305)
	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.doPost(JSONDispatcher.java:55)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:54)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:28)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:37)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)
#2

Did you entered in the field “name” the name of the class you want to create ?
CMDBuild team

#3
Yes.. I entered all the fields available in the class definition screen. 
 
Previously Tecnoteca wrote:
Did you  Entered in the field "name "the name of the class  you want to create ?
CMDBuild team

 

#4
Problem disappear after I upgraded to version 2.1.4
 
Thanks Tecnoteca for making such a great product.
 
Previously AbZahri wrote:
I get this error when trying to add a new class.. 
 
SQL error: ERROR: query string argument of EXECUTE is null Where: PL/pgSQL function "cm_create_class" line 28 at EXECUTE statement

the detail error is presented like this

org.cmdbuild.exception.ORMException: ORM_ERROR_GENERIC_SQL ERROR: query string argument of EXECUTE is null
  Where: PL/pgSQL function "cm_create_class" line 28 at EXECUTE statement
	at org.cmdbuild.exception.ORMException$ORMExceptionType.createException(ORMException.java:58)
	at org.cmdbuild.dao.backend.postgresql.PGCMBackend$CMSqlException.throwGenericException(PGCMBackend.java:124)
	at org.cmdbuild.dao.backend.postgresql.PGCMBackend$CMSqlException.throwCustomExceptionFrom(PGCMBackend.java:109)
	at org.cmdbuild.dao.backend.postgresql.PGCMBackend$SqlState.throwCustomExceptionFrom(PGCMBackend.java:171)
	at org.cmdbuild.dao.backend.postgresql.PGCMBackend.createTable(PGCMBackend.java:323)
	at org.cmdbuild.elements.TableImpl.save(TableImpl.java:181)
	at org.cmdbuild.elements.proxy.TableForwarder.save(TableForwarder.java:35)
	at org.cmdbuild.elements.proxy.TableProxy.save(TableProxy.java:59)
	at org.cmdbuild.servlets.json.schema.ModClass.saveTable(ModClass.java:305)
	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.doPost(JSONDispatcher.java:55)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:54)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:28)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:37)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)