0 votes
1 view

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.

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

Environment Knowage 6.0, 6.1.0,6.1.1
asked Jan 2, 2018 in Location Intelligence by mazam (150 points) | 1 view

1 Answer

0 votes
Best answer
Dear,

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

Best regards

Angelo
answered Jan 2, 2018 by abernabei (20,700 points)
selected Jan 8, 2018 by aportosa
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"

1,553 questions
1,017 answers
2,037 comments
2,568 users