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
Highlighted
Frequent Contributor
Posts: 159
Registered: ‎01-14-2018

"no such table" error in mobile

[ Edited ]

Dears,

 

I am building a mobile app for drawing & editing a polygon features.

Here is its schema in Postgres:

CREATE TABLE public.matboul_green_heyaza
(
  "رقم_القطعة" integer,
  "أسم_الحائز" character varying(255),
  "المحصول" character varying(50),
  geometry bytea,
  id2 integer NOT NULL DEFAULT nextval('matboul_green_heyaza_id2_seq'::regclass),
  geometry_spa geometry(GeometryZ,32636),
  hayez_id_type integer,
  hayez_id character varying,
  owner character varying,
  CONSTRAINT matboul_green_heyaza_pkey PRIMARY KEY (id2)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE public.matboul_green_heyaza
  OWNER TO postgres;

and I created the xaml files as in the attached zip file, 

but I get an error message in the mobile as follows: 

no such table: matboul_green_heyaza

Also as you see I have some column names are in arabic, is it supported in MAE mobile?

 

Best regards

Khaled

Frequent Contributor
Posts: 159
Registered: ‎01-14-2018

Re: "no such table" error in mobile

Hello, any updates? or something to check?

Staff
Posts: 1,036
Registered: ‎10-18-2015

Re: "no such table" error in mobile

[ Edited ]

hi Khaled,

 

please avoid using double quotes in identifiers. If you use double quotes on the name of a table, column, index, or other object when you create it, and if there is even one capital letter in that identifier, you will need to use double quotes every single time you use it. We cannot support this behavior since the query definition may vary depending on the specific workflow.

 

Also id2 is an integer and it is not supported as primary key, we have no ways to manage it in offline mode.

 

Arey you using postgres user in your connectionstring?

 

Stefano

Stefano Turcato
Presale Engineer
Hexagon Geospatial
Frequent Contributor
Posts: 159
Registered: ‎01-14-2018

Re: "no such table" error in mobile

Thanks Stefano,

 

I use the default postgres user for the connection, I have not made another user.

 

Khaled

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.