Hexagon Geospatial
MENU

M.App Enterprise

Discuss topics with other M.App Enterprise Product pioneers and experts to get the most out of it.
Showing results for 
Search instead for 
Do you mean 
Reply
Valued Contributor
Posts: 555
Registered: ‎10-27-2015
Accepted Solution

M.App Enterprise Browser/FeatureAnalyzer and data type

Dear all,

I have some difficulties in loading this table in BI MAP and Feature Analyzer. In the BI MAP as key it only suggests mes "Codice".

Why? Where is the problem? Thank you very much

 

 

-- Table: public.demo_example

-- DROP TABLE public.demo_example;

CREATE TABLE public.demo_example
(
geom geometry(MultiPolygon,3857),
"Codice" text,
"Toponimo" text,
"NomeEsteso" character varying,
"Gestore" character varying,
"Green__" numeric,
"Orange__" numeric,
"Yellow__" numeric,
"Red__" numeric,
"Categoria" character varying,
"Cat_Num" integer,
id integer NOT NULL DEFAULT nextval('demo_example_id_seq'::regclass),
CONSTRAINT demo_example_pkey PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
ALTER TABLE public.demo_example
OWNER TO postgres;

-- Index: public.sidx_demo_example_geom

-- DROP INDEX public.sidx_demo_example_geom;

CREATE INDEX sidx_demo_example_geom
ON public.demo_example
USING gist
(geom);

Valued Contributor
Posts: 555
Registered: ‎10-27-2015

Re: M.App Enterprise Browser/FeatureAnalyzer and data type

Npgsql.PostgresException: 42703: la colonna "toponimo" non esiste
   [Details]
   Severity: ERRORE
   SqlState: 42703
   Code: 42703
   MessageText: la colonna "toponimo" non esiste
   Hint: Forse intendevi referenziare la colonna "protezione_civile_sicilia_01.Toponimo".
   Position: 12
   File: parse_relation.c
   Line: 3183
   Routine: errorMissingColumn
   MS_LoggedBy: System.Collections.Generic.List`1[System.Object]
   at Npgsql.NpgsqlConnector.<DoReadMessageAsync>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 Npgsql.NpgsqlConnector.<ReadMessageWithPrependedAsync>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 Npgsql.NpgsqlConnector.<ReadExpectingAsync>d__9`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
Valued Contributor
Posts: 555
Registered: ‎10-27-2015

Re: M.App Enterprise Browser/FeatureAnalyzer and data type

I solved, the "double quotes" created the problem.

Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Development Ticket through our Development Ticket Portal.