Latest Contributions 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 ... View more

Hi guys. I'm experiencing something weird when connecting  a fresh ArcGIS 10.5.1 installation to a geodatabase in sql server. Basically, the  geodatabase does not retain previously set privileges on database objects according to the following scenario: A user (data viewer or data creator with his own schema), able to access geodb objects owned by other users from ArcGIS 10.4/ ArcGIS 10.5, cannot access them any more despite permissions at sql server level are ok (the user can access them through SSMS). A user with SELECT privilege at schema level (let's say for dbo) cannot view item in ArcGIS 10.5.1 that were previously consumed from ArcGIS 10.4/ ArcGIS 10.5 Further details as follows: It does not apply to dbo Enforcing SELECT privilege at ArcGIS level (in ArcCatalog) works fine and makes the object available to the user This behavior does not depend on geodatabase schema version but only on ArcGIS client version (10.5.1) ArcGIS Pro 2 behaves the same way while ArcGIS Pro 1.4 was working fine I'm using ArcGIS 10.5.1 /ArcGIS Pro 2 against sql  server 2014 thanks Alberto ... View more

Hi guys, just to be sure... It is ok to delete features/rows in a non versioned feature class/table using SQL DELETE, right ? Alberto  ... View more

Hi guys: I successfully configured Portal for ArcGIS federation with an ArcGIS for  Server instance (setting up a hosting server  as well configuring a managed geodatabase for the arc server). When I try to create  hosted services in the Portal everything is working fine and I see that data are ending up correctly in the managed geodatabase. However, when I try to run an analysis tool I get  the message: “Unable to create service ‘layername’. The servers managed database is not an ArcGIS Data Store” I was under the impression that configuring  a managed geodatabase in a DBMS was equivalent (or better) to using the ArcGIS Data Store, a solution that you can use when you do not have a DBMS at your disposal. I tried several times with different options of creating the feature services (hosted uploading a shape, through arcgis server, hosted uploading a file geodb, hosted through ArcMap) with no success. The question is: In order to use Analysis tools in portal for ArcGIS 10.4 am I supposed to exclusively use ArcGIS Data Store instead of a DBMS managed geodatabase ? Thank you Alberto ... View more

Hi everybody. What if I wanted to change the alias of my ArcGIS Online for Organization ? What is the correct procedure ? Creating a new empty one and moving credits ? How about the stuff to move ? Should it be moved manually or the support guys can make it automatic in one shot ? Thanks Alberto ... View more