GIS document using WFS (GEOSERVER) does not work in knowage. Works in SpagoBI

Question

We are trying to create a MAP report using GIS document in Knowage.

The document template was initially created to be for SpagoBI and Reports works fine in SpagoBI. 

We are using same json template file(used in SpagoBI), with exact same data source and data set setting in Knowage and pointing to Same GeoServer

When we run the document, it gave us below error

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

Error layer not retrieved

Apache Tomcat/7.0.50 - Error report

HTTP Status 500 - org.json.JSONException: JSONArray[0] not a string.

---

type Exception report

message org.json.JSONException: JSONArray[0] not a string.

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.jboss.resteasy.spi.UnhandledException: org.json.JSONException: JSONArray[0] not a string.
	org.jboss.resteasy.core.ExceptionHandler.handleApplicationException(ExceptionHandler.java:78)
	org.jboss.resteasy.core.ExceptionHandler.handleException(ExceptionHandler.java:222)
	org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:171)
	org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:414)
	org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:205)
	org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)
	org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
	org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

root cause

org.json.JSONException: JSONArray[0] not a string.
	org.json.JSONArray.getString(JSONArray.java:125)
	it.eng.spagobi.mapcatalogue.service.LayerCRUD.getLayerFromList(LayerCRUD.java:570)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
	org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:294)
	org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:248)
	org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:235)
	org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:398)
	org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:205)
	org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)
	org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
	org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.50 logs.

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

Answer 1

Dear,

the SpagoBI template is not compatible, you have to create a new one using knowage designer.

Best regards

Angelo

Comments

Thanks Angelo,

---

Hi Angelo,

I am trying to create template using knowage designer.

While creating template, I am not able to get any drop down value under "Layer Join Column"