Latest Contributions by AndrewCox

This would be really useful, I would love a Version Changes python command. ... View more

This would be really useful, I would love a Version Changes python command. ... View more

Bernd, Did you have the pre-release installed on the machine before you tried to install the final release? The only reason I ask is I've just installed the final release on a new machine and the site creation worked fine. I think the only difference between them was I had previously installed the pre-release on the machine where the site creation failed. Thanks Andy ... View more

Bernd, I am getting exactly the same error. Did you manage to find a solution to this? Regards Andy ... View more

Gabriel, Did you ever find a solution to this issue with any of the replica types e.g. one-way, two-way. It looks like this is still true even @ version 10.1 Thanks Andy ... View more

Hello, I am having a similar issue in that I have installed the Web Adapter with IIS and have changed the ArcGIS Server authentication to be the Web Tier via Windows Domain accounts. I have then set a new map service with the ArcGIS service security accessible to my domain account. However, when I browse to the services directory via the web adapter I don't see anything even though I am authenticated e.g. http://localhost/arcgis/rest/services Any ideas? Thanks Andy ... View more

Hello, I am having an issue with the Web Adapter as described here - http://forums.arcgis.com/threads/54652-ArcGIS-Server-10.1-Web-Adaptor-Configuration Please can anyone help? Thanks Andy ... View more

Tongki, I am having the same problem, did you ever find a solution to this problem? Thanks Andy ... View more

I think I have inadvertently fixed this issue. I had another user that had an unrelated exception being thrown when trying to do selections e.g. AutomationException: Unable to create logfile system tables. User perhaps lacks permissions or resources to create tables [ORA-01031: insufficient privileges I fixed this AutomationException with the following ArcSDE command sdeconfig -o alter �??v LOGFILEPOOLSIZE=10 Therefore, it appears that by creating the following within the SDE schema it has also resolved my DBMS error e.g. [Error executing stored procedure <schema>.logfile_util.logfile_pool_get_id::ORA-01403: no data found] issue: SDE_LOGPOOL_1 SDE_LOGPOOL_2 SDE_LOGPOOL_3 SDE_LOGPOOL_4 SDE_LOGPOOL_5 SDE_LOGPOOL_6 SDE_LOGPOOL_7 SDE_LOGPOOL_8 SDE_LOGPOOL_9 SDE_LOGPOOL_10 My question would be: Why would a reconcile operation on IVersionEdit4.reconcile have any relationship to logfiles stored in the SDE schema when the owner of the version is an user called GISEDITOR? Is there something else that needs setting in my dbtune file? ... View more

Hello, I've managed to narrow down the cause of this to be the actual reconcile method on IVersionEdit4. The scenario that causes this is as follows: 1. Create new version V1. 2. Add a new feature to version V1. 3. Create new version V2. 4. Add a new feature to version V2. 5. Publish version V2. 6. Publish version V1. Essentially I think it's because a reconcile has been done on V2 between creating V1 and then publishing it. For example the following does work: 1. Create new version V1. 2. Add a new feature to version V1. 3. Publish version V1. 4. Create new version V2. 5. Add a new feature to version V2. 6. Publish version V2. Please can anyone help? Thanks Andy ... View more

Hello All, We are getting a similar error "AutomationException: Underlying DBMS error [Error executing stored procedure <schema>.logfile_util.logfile_pool_get_id::ORA-01403: no data found]" when trying to publish a version to DEFAULT. However, I have checked our SERVER_CONFIG table and it's already set to -1. Is the issue more likely to be related to using session-based logfiles? Thanks Andy ... View more

 The ability of only label selected features would be very useful. ... View more

Vince, Ok thanks. I may have to do it the other way round as I'm not sure I'll have an existing entry in the SPATIAL_REFERENCES table which I can use. Therefore, I'll have to update the SRTEXT etc to reflect the params I want for my new layers. Just as an aside, I don't suppose you know where the "Spatial Reference: 4326" comes from that gets reported against a layer through the REST API e.g. http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Specialty/ESRI_StateCityHighway_USA/MapServer/1/. Is this derived from the MXD or from the entries in the SDE tables. For example, for my layer the REST API reports: "Spatial Reference: PROJCS["OSGB 1936 / British National Grid",GEOGCS["OSGB 1936",DATUM["OSGB 1936 (EPSG ID 6277)",SPHEROID["Airy 1830 (EPSG ID 7001)",6377563.396,299.3249646]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",400000.0],PARAMETER["False_Northing",-100000.0],PARAMETER["Central_Meridian",-2.0],PARAMETER["Scale_Factor",0.9996012717],PARAMETER["Latitude_Of_Origin",49.0],UNIT["Meter",1.0]]" and I want it to read 27700? Thanks Andy ... View more

Vince, Sorry another quick question. How does ArcGIS know that two layers have the same spatial reference when determining whether to re-project data? Does it compare two layers SRID keys from the SPATIAL_REFERENCES table or does it do some kind of comparison on the SRTEXT entry? Thanks Andy ... View more

Vince, Thanks very much for the reply. Please can I just confirm that the process I need to follow would be something like: 1. Load the data into Oracle using the SRID 81989. 2. Use sdelayer -o register with the correct params e.g. -x etc. 3. Use the sdelayer -o describe_long to find the SRID key that the layer was registered with SDE. 4. Open the SPATIAL_REFERENCES table in the SDE schema and change the SRTEXT entry to match watch it should be for 27700 e.g. PROJCS["British_National_Grid",GEOGCS["GCS_OSGB_1936",DATUM["D_OSGB_1936",SPHEROID["Airy_1830",6377563.396,299.3249646]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",400000.0],PARAMETER["False_Northing",-100000.0],PARAMETER["Central_Meridian",-2.0],PARAMETER["Scale_Factor",0.9996012717],PARAMETER["Latitude_Of_Origin",49.0],UNIT["Meter",1.0]] As an alternative I presume I could also add a new entry into the SPATIAL_REFERENCES table first and then use the -R <SRID> option on sdelayer -o register specifying the key to the record I just added to the SPATIAL_REFERENCES table e.g. sdelayer -o register -l <table,column> -e <entity_mask> -t <storage_type> {[-C <row_id_column>[,{SDE|USER}[,<min_ID>]]]} [Spatial_Index] [-E <{empty | xmin,ymin,xmax,ymax}>] [{-R <SRID> | [Spatial_Ref_Opts]}] [-S <layer_description_str>] [-k <config_keyword>] [-i <service> | <port#> | <direct connection>] [-s <server_name>] [-D <database_name>] -u <DB_user_name> [-p <DB_user_password>] [-q] Cheers Andy ... View more