CMDBuild Forum

Can't create a new View

Hello, i cant create new Views in my CMDBuild. Even if i use the given cmf_count_active_cards.

 

I always get following Error for creating a new view with sql in administration panel:

INFO  2013-09-18 14:34:45 [jsonrpc ] Calling url /viewmanagement/createsqlview
INFO  2013-09-18 14:34:45 [jsonrpc ] Calling url /viewmanagement/readsqlview
ERROR 2013-09-18 14:34:45 [jsonrpc ] A java.lang.NullPointerException occurred calling method class org.cmdbuild.servlets.json.ViewManagement.readSQLView

in _View-Table theres a new Entry with the used name. But in CMDBuild theres nothing to see.

 

same thing happens for a new view with filter:

INFO  2013-09-18 14:50:18 [jsonrpc ] Calling url /viewmanagement/createfilterview
INFO  2013-09-18 14:50:18 [jsonrpc ] Calling url /viewmanagement/readfilterview
ERROR 2013-09-18 14:50:18 [jsonrpc ] A java.lang.NullPointerException occurred calling method class org.cmdbuild.servlets.json.ViewManagement.readFilterView

 

whats wrong there?

Could you provide us the stacktrace for the NullPonterException?
 
Best regards.
 
-- Davide Pavan
 
Previously Nick wrote:

Hello, i cant create new Views in my CMDBuild. Even if i use the given cmf_count_active_cards.

 

I always get following Error for creating a new view with sql in administration panel:

INFO  2013-09-18 14:34:45 [jsonrpc ] Calling url /viewmanagement/createsqlview
INFO  2013-09-18 14:34:45 [jsonrpc ] Calling url /viewmanagement/readsqlview
ERROR 2013-09-18 14:34:45 [jsonrpc ] A java.lang.NullPointerException occurred calling method class org.cmdbuild.servlets.json.ViewManagement.readSQLView

in _View-Table theres a new Entry with the used name. But in CMDBuild theres nothing to see.

 

same thing happens for a new view with filter:

INFO  2013-09-18 14:50:18 [jsonrpc ] Calling url /viewmanagement/createfilterview
INFO  2013-09-18 14:50:18 [jsonrpc ] Calling url /viewmanagement/readfilterview
ERROR 2013-09-18 14:50:18 [jsonrpc ] A java.lang.NullPointerException occurred calling method class org.cmdbuild.servlets.json.ViewManagement.readFilterView

 

whats wrong there?

 

Yes, but pls tell me how can i create it?

 

Previously Tecnoteca wrote:
Could you provide us the stacktrace for the NullPonterException?
 
Best regards.
 
-- Davide Pavan

 

Dear Nick,
 
you can find it within the "cmdbuild.log" file. Without any modification to the default configuration it can be found in ${CATALINA_BASE}/logs.
 
Best regards.
 
-- Davide Pavan
 
Previously Nick wrote:

Yes, but pls tell me how can i create it?

 

Previously Tecnoteca wrote:
Could you provide us the stacktrace for the NullPonterException?
 
Best regards.
 
-- Davide Pavan

 

 

The logs i posted yesterday are from the cmdbuild.log there is no stacktrace showed.

in cmdbuild i get a error popup while creating a view.

the stacktrace is following:

Call: services/json/viewmanagement/readsqlview?_dc=1379571577190
-----------------------------------------------------------------
Error: java.lang.NullPointerException
	at org.cmdbuild.logic.view.ViewLogic.isActive(ViewLogic.java:43)
	at org.cmdbuild.logic.view.ViewLogic.fetchViewsOfAllTypes(ViewLogic.java:33)
	at org.cmdbuild.logic.view.ViewLogic.read(ViewLogic.java:48)
	at org.cmdbuild.servlets.json.ViewManagement.readByType(ViewManagement.java:106)
	at org.cmdbuild.servlets.json.ViewManagement.readSQLView(ViewManagement.java:45)
	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:621)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	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:142)
	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:33)
	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:39)
	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:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	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)

Previously Tecnoteca wrote:

Dear Nick,
you can find it within the "cmdbuild.log" file. Without any modification to the default configuration it can be found in ${CATALINA_BASE}/logs.
Best regards.
-- Davide Pavan
Previously Nick wrote:

Yes, but pls tell me how can i create it?

Previously Tecnoteca wrote:
Could you provide us the stacktrace for the NullPonterException?
Best regards.
-- Davide Pavan

Dear Nick,
 
we already found and fix this issue. The fix will be available in the upcoming release scheduled for the next two/three weeks.
 
Best regards.
 
-- Davide Pavan
 
Previously Nick wrote:

The logs i posted yesterday are from the cmdbuild.log there is no stacktrace showed.

in cmdbuild i get a error popup while creating a view.

the stacktrace is following:

 

Call: services/json/viewmanagement/readsqlview?_dc=1379571577190
-----------------------------------------------------------------
Error: java.lang.NullPointerException
	at org.cmdbuild.logic.view.ViewLogic.isActive(ViewLogic.java:43)
	at org.cmdbuild.logic.view.ViewLogic.fetchViewsOfAllTypes(ViewLogic.java:33)
	at org.cmdbuild.logic.view.ViewLogic.read(ViewLogic.java:48)
	at org.cmdbuild.servlets.json.ViewManagement.readByType(ViewManagement.java:106)
	at org.cmdbuild.servlets.json.ViewManagement.readSQLView(ViewManagement.java:45)
	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:621)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	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:142)
	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:33)
	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:39)
	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:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	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)

 

 

 

 

 

Previously Tecnoteca wrote:

Dear Nick,
 
you can find it within the "cmdbuild.log" file. Without any modification to the default configuration it can be found in ${CATALINA_BASE}/logs.
 
Best regards.
 
-- Davide Pavan
 
Previously Nick wrote:

Yes, but pls tell me how can i create it?

 

Previously Tecnoteca wrote:
Could you provide us the stacktrace for the NullPonterException?
 
Best regards.
 
-- Davide Pavan

 

 

 

Thats nice!

can you link me the the sourcecode from bitbucket where it is fixed? maybe i can create a workaround for me til the upcoming release?

 

Previously Tecnoteca wrote:
Dear Nick,
 
we already found and fix this issue. The fix will be available in the upcoming release scheduled for the next two/three weeks.
 
Best regards.
 
-- Davide Pavan
 

 

Dear Nick,
 
here is the commit, and as a workaround you must fill the "IdSourceClass" in the table "_View" with the regclass of an active CMDBuild class (any).
 
Best regards.
 
-- Davide Pavan
 
Previously Nick wrote:

Thats nice!

can you link me the the sourcecode from bitbucket where it is fixed? maybe i can create a workaround for me til the upcoming release?

 

Previously Tecnoteca wrote:
Dear Nick,
 
we already found and fix this issue. The fix will be available in the upcoming release scheduled for the next two/three weeks.
 
Best regards.
 
-- Davide Pavan
 

 

 

Thank You!!!

Its working!

 

Previously Tecnoteca wrote:
Dear Nick,
 
here is the commit, and as a workaround you must fill the "IdSourceClass" in the table "_View" with the regclass of an active CMDBuild class (any).
 
Best regards.
 
-- Davide Pavan
 
Previously Nick wrote:

Thats nice!

can you link me the the sourcecode from bitbucket where it is fixed? maybe i can create a workaround for me til the upcoming release?

 

Previously Tecnoteca wrote:
Dear Nick,
 
we already found and fix this issue. The fix will be available in the upcoming release scheduled for the next two/three weeks.
 
Best regards.
 
-- Davide Pavan