M.App Enterprise Discussions

[gmaldera]

Dear all,

I am having issues whit this table. Any suggestonios?

-- Table: public.province_sicilia

-- DROP TABLE public.province_sicilia;

CREATE TABLE public.province_sicilia
(
id integer NOT NULL DEFAULT nextval('province_sicilia_id_seq'::regclass),
geom geometry(MultiPolygon,3857),
cod_pro integer,
provincia character varying,
sigla character varying,
CONSTRAINT province_sicilia_pkey PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
ALTER TABLE public.province_sicilia
OWNER TO postgres;

-- Index: public.sidx_province_sicilia_geom

-- DROP INDEX public.sidx_province_sicilia_geom;

CREATE INDEX sidx_province_sicilia_geom
ON public.province_sicilia
USING gist
(geom);

I have this error:

System.NullReferenceException: Object reference not set to an instance of an object.
   [Details]
   MS_LoggedBy: System.Collections.Generic.List`1[System.Object]
   at MApp.Endpoints.BrowserClientController.<GetMapView>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__3`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.AuthenticationFilterResult.<ExecuteAsync>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()

 Any suggestions?
Thank you 

[tpaul]

So you imported this table as a vector dataset without an issue? Because the stacktrace you posted is already from starting the app... So please fill in some details about what you did?

[gmaldera]

Thank you tpaul for the reply. I canno see the geometries in the Feature Analyzer

[tpaul]

But you can display them in other clients like Desktop or Browser? What type of geometries are we talking about?

[gmaldera]

Thank you,

I can't see in browser (BI). I have not tried in desktop app.
multiypolygon 

I am attaching the shapefile
Thank you very much!!

multipolygon_error.zip ‏1193 KB

[gmaldera · Accepted solution]

I solved the problem deleting manualy the cache files in the Warehouse folder. Deleting and recreating the cache only in Studio did not solve the problem.

Thank you

Regards