Bug
The ST_Raster.getValue can only be run by the owner of the raster dataset in the Oracle geodatabase. Users such as the SDE user and those with read-only access to the dataset gets the error: "ORA-29400: data cartridge error SdeCursor::execute(); ORA-00942: table or view does not exist". This issue is also seen in PostreSQL geodatabase, "ERROR: relation "sde_blk_5" does not exist".
| Bug-ID-Nummer | BUG-000106563 |
|---|---|
| Eingereicht | July 13, 2017 |
| Zuletzt geändert | June 5, 2024 |
| Gilt für | ArcGIS GIS Server |
| Gefunden in Version | 10.4.1 |
| Betriebssystem | Oracle Solaris |
| Betriebssystemversion | 11 64 Bit |
| Status | Will Not Be Addressed |
Zusätzliche Informationen
We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.Workaround
Create a private synonym for the SDE_BLK table associated with the raster dataset for each user, which allows them to perform the ST_Raster.getValue function successfully.Sample SQL Statement:CREATE SYNONYM sde.SDE_BLK_1 for GISOWNER.SDE_BLK_1;Now the user is able to get the pixel value from the raster dataset using the ST_Raster.getValue function.Alter the search path string to include the data owner schema in the search path of each user.Sample SQL Statement:SET search_path TO "$user", gisowner, public, sde;Now the user is able to get the pixel value from the raster dataset using the ST_Raster.getValue function.Schritte zur Reproduzierung
Bug-ID: BUG-000106563
Software:
- ArcGIS GIS Server
Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert
Weitere Informationen zu diesem Thema erkunden
Nach zugehörigen Informationen suchen
Nach Schulungen zu diesem Thema suchen
Ideen erkunden und Feedback geben
Unterstützung durch ArcGIS-Experten anfordern
Esri Support App herunterladen