Error
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".
| Número de ID del error | BUG-000106563 |
|---|---|
| Enviado | July 13, 2017 |
| Última modificación | June 5, 2024 |
| Relacionado con | ArcGIS GIS Server |
| Versión encontrada | 10.4.1 |
| Sistema operativo | Oracle Solaris |
| Versión de sistema operativo | 11 64 Bit |
| Estado | Will Not Be Addressed |
Información adicional
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.Solución alternativa
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.Pasos para reproducir
ID del error: BUG-000106563
Software:
- ArcGIS GIS Server
Recibir notificaciones cuando cambie el estado de un error
Descubrir más sobre este tema
Buscar información relacionada
Encontrar formación relacionada con este tema
Explorar ideas y aportar opiniones
Obtener ayuda de expertos en ArcGIS
Descargar la aplicación de soporte de Esri