|
POST
|
Supriya, when running that query I get 1000 without any error. I was wondering if the cause of trouble may be the fact that I'm a sysadmin at sql server level but not at os level and, as a result, something went wrong in the installation . I assumed that the requirement was being a sysadmin at sql server level. What do you think ? I'll check that. Alberto
... View more
09-11-2017
01:06 AM
|
0
|
4
|
2062
|
|
POST
|
Also, the cache settings into layer properties dialog does not seem to apply to a sde layer. I think that this is something missing in ArcGIS Pro. Am I correct ? If so it would be nice to have it in the future especially because....ArcGIS Desktop has it and it really helps when working against DBMSs Alberto
... View more
09-08-2017
02:05 AM
|
0
|
0
|
1642
|
|
POST
|
Hi everybody. More details on this issue here Alberto
... View more
09-08-2017
01:40 AM
|
0
|
0
|
1588
|
|
POST
|
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
09-08-2017
01:33 AM
|
0
|
6
|
2374
|
|
POST
|
Jayanta, I already explored that.... It's supposed to work with feature services. When using a SDE feature class it's disabled. Alberto
... View more
09-06-2017
03:27 AM
|
0
|
0
|
1642
|
|
POST
|
Hi everybody. How about feature cache in ArcGIS Pro 2 ? Is there a way to cache features from a geodatabase in a DBMS the same way I do in ArcMap ? Thanks Alberto
... View more
09-06-2017
01:15 AM
|
4
|
5
|
2160
|
|
POST
|
Using Query Layer in ArcGIS/ArcGIS Pro should solve the problem. I imagine you have table valued functions with parameters.....just enter the sql as you would write it in SSMS and it should work even if your function does not appear in the object list. For example, in my case i have a table valued function called fnCatchDownStream that takes an input parameter called HydroID. I use it this way in SSMS as well as in Query layer.... SELECT * FROM fnCatchDownStream(356987) Alberto
... View more
08-29-2017
06:33 AM
|
0
|
1
|
851
|
|
POST
|
Hi guys. I have a similar problem here. Basically I'm doing some testing with ST_Raster in SQL server 2016. Installation was fine and 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) Alberto
... View more
08-29-2017
06:09 AM
|
0
|
0
|
1089
|
|
POST
|
Rex, more or less I did a similar test. I imagine that the issue will be fixed at next release (10.6)... Ciao Alberto
... View more
07-17-2017
12:57 AM
|
0
|
1
|
2863
|
|
POST
|
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
07-14-2017
07:20 AM
|
3
|
11
|
6099
|
|
POST
|
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
01-27-2017
06:59 AM
|
0
|
2
|
1267
|
|
POST
|
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
03-16-2016
09:57 AM
|
0
|
1
|
3121
|
|
POST
|
Jayanta, my target scenario is: Disable anonymous user access to the portal in order to allow portal navigation to named users only Publicly share some items to everyone (without requiring login on the item) While I can easily make it in ArcGIS Online (when sharing a webmap this way the form provides a public url to distribute for access) I cannot do the same in Portal for ArcGIS. I suspect that it is a configuration thing because when I use the option to embed in a web site the html snipet works properly and does not require to login. If my portal is webadaptor/arcgis the url of a public webmap comes out as webadaptor/arcgis/home/webmap/viewer.html?webmap=123dd20e72d644acb8b452254871e832. The HTML snipet coming out from the "embed in a website" option contains a URL (I removed parameters) like "http://webadaptor/arcgis/apps/Embed/index.html?webmap=123dd20e72d644acb8b452254871e832" (and this one works properly without requiring authentication) Alberto
... View more
03-02-2016
12:44 AM
|
0
|
0
|
758
|
|
POST
|
Hi everybody: I'm checking differences between sharing a webmap in ArcGIS Online versus Portal for ArcGIS. ArcGIS Online. If "Allow anonymous access to your organization's website" is unchecked (meaning that anonymous user cannot access the ArcGIS Online of the organization) a publicly shared webmap can be accessed with the link provided in the share form without authentication Portal for ArcGIS. in this case what described for ArcGIS Online does not work. If "Allow anonymous access to your portal" is unchecked opening the map using the link provided in the share form requires user login in any case. Is this the correct behavior or am I missing something ? Alberto
... View more
03-01-2016
06:44 AM
|
0
|
2
|
3223
|
|
POST
|
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
11-25-2014
07:08 AM
|
0
|
2
|
5011
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 08-21-2019 05:51 AM | |
| 4 | 09-06-2017 01:15 AM | |
| 1 | 09-12-2017 01:47 AM | |
| 1 | 05-03-2018 07:33 AM | |
| 3 | 07-14-2017 07:20 AM |
| Online Status |
Offline
|
| Date Last Visited |
07-24-2025
04:49 AM
|