漏洞
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".
| 漏洞 ID 编号 | BUG-000106563 |
|---|---|
| 已提交 | July 13, 2017 |
| 上次修改时间 | June 5, 2024 |
| 适用范围 | ArcGIS GIS Server |
| 找到的版本 | 10.4.1 |
| 操作系统 | Oracle Solaris |
| 操作系统版本 | 11 64 Bit |
| 状态 | Will Not Be Addressed |
附加信息
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.解决办法
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.重现步骤
漏洞 ID: BUG-000106563
软件:
- ArcGIS GIS Server
当漏洞状态发生变化时获得通知
发现关于本主题的更多内容
搜索相关信息
查找与此主题相关的培训
探索想法并提供反馈
获取来自 ArcGIS 专家的帮助
下载 Esri 支持应用程序