AnsweredAssumed Answered

ST_Raster Trouble - SQL SERVER

Question asked by albertoaloe on Sep 8, 2017
Latest reply on Sep 12, 2017 by albertoaloe

Hi guys.

I'm doing some testing with ST_Raster in SQL server 2016. 

Installation was fine. I follow the exact procedure described in the help document (including checking system requirements for the server) and, as a result,  I was able to load a raster from arcgis  into the geodatabase after altering the configuration file (RASTER_STORAGE).

In SSMS I see the table with the ST_Raster column and I'm able to make some querying. However, when I try to create a table (or a variable ) with ST_PixelData I get an error.

 

If I run...

 

CREATE TABLE pixels (pdata dbo.ST_PixelData, row_id int);

INSERT INTO pixels(pdata , row_id) SELECT RASTER.getPixelData('level=1') , 1 FROM [dbo].[MEAN2008]

 

I get the following error....

 

Msg 6522, Level 16, State 1, Line 10
A .NET Framework error occurred during execution of user-defined routine or aggregate "ST_Raster": 
System.DllNotFoundException: Unable to load DLL 'pe.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
System.DllNotFoundException: 
at ESRI_ArcSDE.STRasterUtil.SdeRasterAPI.pe_coordsys_from_string(String __unnamed000)
at ESRI_ArcSDE.STRasterUtil.ST_Raster_IO.getCoordSys(Int32 rastercolumnID)
at ST_RasterCommon.exportCommon(ST_RasterCommon* , SubsetParam* __unnamed000, SByte* compression)
at ST_RasterSS.getPixelData(ST_RasterSS* , Byte* A_0, Byte* A_1)
at ESRI_ArcSDE.STRasterType.ST_Raster.getPixelData(SqlString param)

 

... implying that there is something missing.

 

I double checked all the requirements and everything seems fine including .NET version in the server. I got the libst_raster_sql.dll from the ArcGIS 10.5.1 installation.

 

I'd appreciate if somebody had a hint.

 

Thanks

 

Alberto

Outcomes