ahsan_02

SQL Server ArcSDE ST_Raster Installation and Configuration Error “.dll”

Discussion created by ahsan_02 on Feb 23, 2017
Latest reply on Aug 29, 2017 by albertoaloe

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

 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 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.

Outcomes