I have successfully installed ST_Raster Library in SQL Server machine following this tutorial
I have used ArcGIS 10.4 Configuration wizard for import and export of configurations After installation i have also run this query.
SELECT sde.st_raster_util_getVersion();
After installation i have also run this query.
SELECT sde.st_raster_util_getVersion();
This query successfully returned the "1000" that means i have successfully installed the ST_raster, i am also able to create a table in SQL Server and from design of the table i can see the type is set ot ST_Raster.
CREATE TABLE sde.urban_area_sde (raster sde.ST_Raster, name varchar(255));
When initializing the document as tutorial say i used below query to initialize the raster column
EXEC sde.ST_Raster_Util_Initialize 'AgriAhDB','sde','urban_area_sde','raster',4326,NULL,'DEFAULTS'
It was returned as error.
Msg 6522, Level 16, State 1, Procedure st_raster_util_initialize, Line 0 [Batch Start Line 6] A .NET Framework error occurred during execution of user-defined routine or aggregate "st_raster_util_initialize": 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_factory_coordsys(Int32 projectionID) at ESRI_ArcSDE.STRasterUtil.StoredProcedures.getCoordSysFromPID(SqlInt32 projectionID, String& srtext) at ESRI_ArcSDE.STRasterUtil.StoredProcedures.getCoordSys(SqlInt32 projectionID, SqlString projectionFile, String& srtext) at ESRI_ArcSDE.STRasterUtil.StoredProcedures.createRasterColumn(SqlString database, SqlString owner, SqlString tableName, SqlString columnName, SqlInt32 projectionID, SqlString projectionFile, SqlString keyword, SqlInt32& rastercolumnID, SqlInt32& regID) at ESRI_ArcSDE.STRasterUtil.StoredProcedures.st_raster_util_initialize(SqlString database, SqlString owner, SqlString tableName, SqlString columnName, SqlInt32 projectionID, SqlString projectionFile, SqlString keyword) .
I have restarted the SQL Server service, but it was unsuccessful in resolving the error. How can I resolve this error,? Is there any specified library that I need to place to use the ST_Raster procedure?