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 Number | BUG-000106563 |
|---|---|
| Submitted | July 13, 2017 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS GIS Server |
| Version found | 10.4.1 |
| Operating System | Oracle Solaris |
| Operating System Version | 11 64 Bit |
| Status | Will Not Be Addressed |
Additional Information
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.Steps to Reproduce
Bug ID: BUG-000106563
Software:
- ArcGIS GIS Server
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App