the feature of the view doesn't show on a map

[solidsnake]

Hello evryone,

i have created a spatial views in Enterprise geodatabade and registred the view succsesufly.

but when i open the view in the map the polygon doesn't show, the table is not empty and when i select a feature in the table i can zoom to it but it doesn't show on the map

the sql code is:

SELECT pat_entite_z1.SHAPE, pat_patrimoine.code_pat, pat_patrimoine.nature_juridique, pat_patrimoine.ligne, pat_patrimoine.conservation, pat_patrimoine.superficie_depot, pat_patrimoine.etat_immatriculation, 'R' || pat_patrimoine.numero_requisition || '/' || pat_patrimoine.index_requisition AS req, 'T' || pat_patrimoine.num_tf || '/' || pat_patrimoine.index_tf AS tf, pat_patrimoine.statut_pat, pat_patrimoine.superficie_defintive, pat_patrimoine.sortie, pat_patrimoine.nature_sortie, pat_patrimoine.obs, pat_patrimoine.ged, pat_patrimoine.depose_par, pat_patrimoine.immatricule_par, pat_patrimoine.verification
FROM pat_patrimoine INNER JOIN pat_entite_z1 ON pat_patrimoine.code_pat = pat_entite_z1.code_pat;

i have also published the view in portal but i have the same problem.

can you help me

thanks

[MarceloMarques]

Please open a ticket with esri technical support to investigate this further, it can be an invalid geometry or the spatial index needs to be rebuilt among other known issues with view, e.g. the view must have only one column named "shape".

[MarceloMarques]

Query does not have an ObjectID column with unique values.

SELECT
pat_entite_z1.SHAPE,
pat_patrimoine.code_pat,
pat_patrimoine.nature_juridique,
pat_patrimoine.ligne,
pat_patrimoine.conservation,
pat_patrimoine.superficie_depot,
pat_patrimoine.etat_immatriculation,
'R' || pat_patrimoine.numero_requisition || '/' || pat_patrimoine.index_requisition AS req,
'T' || pat_patrimoine.num_tf || '/' || pat_patrimoine.index_tf AS tf,
pat_patrimoine.statut_pat,
pat_patrimoine.superficie_defintive,
pat_patrimoine.sortie,
pat_patrimoine.nature_sortie,
pat_patrimoine.obs,
pat_patrimoine.ged,
pat_patrimoine.depose_par,
pat_patrimoine.immatricule_par,
pat_patrimoine.verification
FROM pat_patrimoine
INNER JOIN pat_entite_z1
ON pat_patrimoine.code_pat = pat_entite_z1.code_pat;

Views in an enterprise geodatabase—ArcGIS Pro | Documentation - read here to learn all the view requirements.

Create Database View (Data Management)—ArcGIS Pro | Documentation

I hope this helps.

[VinceAngelo]

(I moved your post to Data Management/Geodatabase Questions, where folks who deal with this will see it.)

Please add the following details:

• What is the registered rowid column of table  pat_patrimoine?
• What is the cardinality of the relationship between pat_patrimoine and pat_entite_z1?
• What column did you register as the rowid for the view?
• What do the following two SQL queries return?

  SELECT count(*) FROM {viewname};
  SELECT count(*) FROM {viewname} GROUP BY {registered_rowid_column};

- V

[MarlonAmaya]

Hi @solidsnake 

Along with the previous suggestions.

1. Did you create the view using ArcGIS Pro? If not, go ahead and create the view using Pro and see if you get a different behavior.

Marlon