02-28-2018 03:41 AM
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
Solved! Go to Solution.
03-02-2018 12:39 AM
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?
03-02-2018 02:36 AM
Thank you tpaul for the reply. I canno see the geometries in the Feature Analyzer
03-02-2018 04:19 AM
But you can display them in other clients like Desktop or Browser? What type of geometries are we talking about?
03-02-2018 06:12 AM
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!!
03-05-2018 12:30 AM
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