M.App Enterprise Discussions

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
Technical Evangelist
Posts: 1,276
Registered: ‎09-11-2015

Re: DataSet missing for a tenant

Ok, then you hit it. It's the PL_VacantSites dataset, that has missing vector data information for any strange reason. You can try to delete and re-create this dataset via Studio. But if there appears an error, you might need to work directly in the database...

Jan Neumann
Post Sales Engineer Web Applications
Hexagon Geospatial

Highlighted
Technical Evangelist
Posts: 548
Registered: ‎09-11-2015

Re: DataSet missing for a tenant

I will just add to this topic, that if this happens, the "spoiled" datasets are not listed in the Content > Vector Data, so you must delete them in the database. The following command can fix the problem in an MS SQL tenant database:

 

delete from MAPP_DATASET where ID in (
SELECT md.ID FROM MAPP_DATASET md
LEFT JOIN MAPP_VECTOR mv on md.ID = mv.DATASET_ID
WHERE md.DATASETTYPE = 2 and mv.DATASET_ID IS NULL);

 

Pavel