I have successfully installed ST_Raster Library in SQL Server machine following this tutorial http://desktop.arcgis.com/en/arcmap/10.4/manage-data/using-sql-with-gdbs/install-st-raster-oracle.htm
I have used ArcGIS 10.4 Configuration wizard for import and export of configurations
After installation i have also run this query
After installation i have also run this query.
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 success 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.