Erro
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 do Erro | BUG-000106563 |
|---|---|
| Enviado | July 13, 2017 |
| Última Modificação | June 5, 2024 |
| Aplica-se à | ArcGIS GIS Server |
| Versão encontrada | 10.4.1 |
| Sistema Operacional | Oracle Solaris |
| Versão do Sistema Operacional | 11 64 Bit |
| Status | Will Not Be Addressed |
Informações Adicionais
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.Solução Provisória
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.Etapas para Reproduzir
ID do Erro: BUG-000106563
Software:
- ArcGIS GIS Server
Seja notificado quando o status de um erro mudar
Descubra mais sobre este tema
Procurar por informações relacionadas
Encontre treinamento relacionado a este tópico
Explore idéias e forneça comentários
Obtenha ajuda de especialistas do ArcGIS
Baixe o Aplicativo de Suporte da Esri