Latest Contributions by DiegoLlamas

Hi, I am trying to modify my source of users and roles that I will be use for ArcGIS Server Security. First I selected Users from an existing enterprise system and roles from arcgis server's built-in store. [ATTACH=CONFIG]31458[/ATTACH] and doing this I generate 3 roles and from my domain i got 140 users (that I can not delete or add new user. So I want to change to  Users and roles from ArcGIS's built-in Store [ATTACH=CONFIG]31459[/ATTACH] after I click finish in review configuration it give me a message "please wait..." [ATTACH=CONFIG]31462[/ATTACH]but it has been like 4 hours and I cancel it and start again and the second time I clicked finish, it been long time again and it do not finish. Do this should take that much time? am I doing something wrong? Hope any one can help! Thanks Diego Llamas ... View more

Hi, I am experimenting some performance problems and error executions when I use ST_GEOMETRY functions in SQL and I wanted to know how many features from my parcel layer intersect a required municipality. The parcel feature class is versioned and there are several versions created in our database. Using sql I wrote the following statement... SELECT count(*) FROM GISADMIN.parcelario08 p,GISADMIN.municipios m WHERE sde.st_intersects (p.shape,m.shape) = 1 AND m.municipios='VILLALBA' order by p.num_catastro; this returns 7434 records in about just a few seconds. Using �??select by location�?� in ArcMap, the application returned 7436 selected features. Both queries were done relatively at the same time. I ran "exec sde.version_util.set_current_version('SDE.DEFAULT');" just in case in my latest tries, but still the same results. I figured out I was referencing the business table and not the corresponding versioned view so I modified the query to�?� SELECT count(*) FROM GISADMIN.parcelario08_evw p,GISADMIN.municipios m WHERE sde.st_intersects (p.shape,m.shape) = 1 AND m.municipios='VILLALBA' order by p.num_catastro; Problem is I�??m not able to confirm the results because querying the versioned view takes a lot of time and after several minutes I receive the error message�?� �??Error starting at line 3 in command: SELECT count(*) FROM GISADMIN.parcelario08_evw p,GISADMIN.municipios m WHERE sde.st_intersects (p.shape,m.shape) = 1 AND m.municipios='VILLALBA' order by p.num_catastro Error report: SQL Error: ORA-20011: Error generating shape. (SHAPE1) ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 100 ORA-06512: at "SDE.ST_RELATION_OPERATORS", line 340�?� Another test was ran using another layer (non versioned) instead of the parcels fc and the performance is very bad (at the time this document is being edited, the oracle session is going for 30 minutes indicating the wait event �??External Procedure call�?�). I like using sql functionality to generate reports quickly and used to copy data to Postgis (no ESRI software) just to have this ability. In postgis the latter statement took just 2 seconds.  The gdb is compress and maintain daily.  After about 2 hours, I received the following errors�?� �??ORA-29903: error in executing ODCIIndexFetch() routine ORA-28576: lost RPC connection to external procedure agent ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 933 ORA-06512: at "SDE.SPX_UTIL", line 3954 ORA-06512: at "SDE.SPX_UTIL", line 3832 ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 882 29903. 00000 -  "error in executing ODCIIndexFetch() routine" *Cause:    The execution of ODCIIndexFetch routine caused an error. *Action:   Examine the error messages produced by the indextype code and            take appropriate action.�?� I found some bugs but in my oracle version are solve http://support.esri.com/zh-cn/knowledgebase/techarticles/detail/38823 http://support.esri.com/en/knowledgebase/techarticles/detail/32187 http://www.palladiumconsulting.com/blog/sebastian/2008/05/sde-92s-stgeometry-part-zero.html Any one has any idea why is it? some recommendations? Thanks for your help! Diego Llamas ... View more

Hi, We have two images in raster in a SDE geodatabase, we upgrade our geodatabase from 9.2 to 10.2 but before that we remove the raster data backing up this data in a file geodatabase. we delete the raster, upgrade the database. we upload the raster data to SDE after the upgrade using import from Filegeodatabase to geodatabase. After importing the data we got a weird info where suppose to be the number of bands [ATTACH=CONFIG]31189[/ATTACH] we got just some letters [ATTACH=CONFIG]31188[/ATTACH]  any idea what could be wrong? it is necessary to import the rasters again? Thanks for your help! Diego ... View more

Hi, I was wondering if it is possible to see Latitude and Longitude format instead of the one that is showed when I add a behaviour in Silverlight viewer 3.0? if it is how can I change the format? [ATTACH=CONFIG]29852[/ATTACH] Thanks for all your help Diego Llamas ... View more

Hi, I am trying to add my own base map with cache. On the first step where I add the basemap I select ArcGIS Server using http://localhost:6080/arcgis/rest/services/mapas I select the service with cache and include it to selected basemaps. [ATTACH=CONFIG]28687[/ATTACH] but for some reason, when I use this basemap I can't see it [ATTACH=CONFIG]28688[/ATTACH] I just see a grey rectangle. The service is working perfectly when I add it on ArcMap. [ATTACH=CONFIG]28689[/ATTACH] Am I doing something wrong? Hope you can help! Regards, Diego Llamas ... View more

Hi, In my laptop I have installed ArcMap 10.1. I had to re install windows and after that I am not able to connect to a enterprise database. I got the error "Connection was attempted with an older version of SQL Server client communications software that is not compatible with the SQL Server database server" [ATTACH=CONFIG]26761[/ATTACH] I found this: http://support.esri.com/en/knowledgebase/techarticles/detail/37287 But I'm not sure if I need to download The SQL Server 2008 Native Client  (or the version of my SQL) and install it on my laptop. It has to be installed on the laptop, right? that is the main problem am I correct? Thanks for your help! Best regards, Diego Llamas ... View more

Hi, I have a question, hope anyone can help. I create an enterprise Geodatabase when I was using a temporarily license. I Authorize Server with the permanent license but I need to Authorize my enterprise geodatabase with my permanent license. I haven't found how to do that. What I found, according to this blog (http://blogs.esri.com/esri/supportcenter/2013/06/04/updating-the-license-for-enterprise-geodatabases-at-10-1/), I need to wait until my temporarily license expire and then update my enterprise geodatabase license and It is currently not possible to run the Update ArcGIS Server License tool if the license for the geodatabase is still valid. My temporarily license is valid until summer next year and I can't wait until then to do my update. How can I do that? is there a way to update my geodatabase license? Appreciate your help! Best regards, Diego Llamas ... View more

Hi, I have a Geoprocessing model where a feature class exist. the model calculates some columns based in other columns. Then I calculate X and Y and as a last step I need to recalculate the spatial index of this feature class. I know that exist a tool Add Spatial index but I haven't found one that just update or recalculate my spatial index. Is there one? is there a script for this? Hope anyone can help! Best Regards, Diego Llamas ... View more

Hi, We are trying to migrate from ArcSDE 9.2 and JTX 3.0.1 to ArcSDE 10.1 and Workflow manager 10.1. For this reason, we created atesting computer to migrate there as a test and see the best methodology to migration. Production environment! HP-UX 11.11i PARISC 13 GB RAM Oracle 9.2.0.8 ArcSDE 9.2 SP6 Windows Test environment! XP Professional SP3 4 GB RAM Oracle 9.2.0.8 ArcSDE 9.2 To recreate the database in the test enviroment I did the following steps: 1. Export a full dump file from the production database. 2. Import the dump file as required to recreate the desired schemas. 3. Installed ArcSDE 9.2 SP6 and configured the service using port 6161 After this we run a sdegdbrepair syntax to diagnose the database. so we can see if there is any orphan file or record. this run with no problem and did not find any problem with the database, however: 1) I noticed there are some entries in the sde system tables that are not supposed to be there. I have the following entries in the sde.layers and sde.table_registry tables: Owner: gisadmin Table_name: parcelas_14092011 We run ArcSDE 9.2 SP6 in Oracle 9.2.0.8 in HP-UX 11.11. When I try to create a feature class with the name mentioned above, an invalid name dialogue appears stating �??The specified name already exists. Please enter a different name.�?� 2) Also, I see there are some entries in the table sde.gdb_usermetadata that reference feature classes that do not exist any more in our geodatabase. If this normal for this table or is it a problem? If so, how to fix it??? What we are trying to do is to migrate the database as clean as possible, with no orphan records Please advise�?� Best Regards, Diego Llamas ... View more