Latest Contributions by JasonTipton

‎10-22-2015

Not that I know of. Probably would have to write something to automatically update the map every day with the dates changed.

‎10-19-2015

Have you added Global IDs? Prepare data for offline use—Documentation (10.3 and 10.3.1) | ArcGIS for Server

‎10-01-2015

Sometimes, you just can't delete a feature class from ArcCatalog. Maybe something got messed up in the database, or the feature class was incorrectly created. For whatever reason, ArcCatalog won't allow you to delete the feature class. This is probably not the right way, but it's how I have had to do it (in Oracle): set serveroutput on; DECLARE v_tbl varchar(50) := 'RPT_REGION'; -- SET THIS TABLE v_schema varchar(50); BEGIN select sys_context('userenv','current_schema') into v_schema from dual; DBMS_OUTPUT.PUT_LINE(v_schema || '.' || v_tbl); DBMS_OUTPUT.PUT_LINE('DELETING FROM table_registry'); DELETE FROM table_registry WHERE table_name = v_tbl; DBMS_OUTPUT.PUT_LINE('DELETING FROM column_registry'); DELETE FROM column_registry WHERE table_name = v_tbl; DBMS_OUTPUT.PUT_LINE('DELETING FROM layers'); DELETE FROM layers WHERE table_name = v_tbl; DBMS_OUTPUT.PUT_LINE('DELETING FROM geometry_columns'); DELETE FROM geometry_columns WHERE f_table_name = v_tbl; DBMS_OUTPUT.PUT_LINE('DELETING FROM gdb_items'); DELETE FROM gdb_items WHERE physicalname = v_schema || '.' || v_tbl; commit; END; Then Drop your table, and you can re-import it. Branch of Re: ArcGIS Server 10.3 Question about deleting SDE feature class

‎09-15-2015

I was going to say the same thing. Network Storage. What kind of network storage did you have? Was it dedicated or shared, and how many people were sharing it? Was it new or old hardware? I've seen HUGE differences between our config files sitting on the same network storage as 1,000's of people sharing vs local. But, moving to another controller that was faster, newer, and had less traffic, I did not see the degradation. If you have some sort of NAS device dedicated to applications, you shouldn't really see much of a problem using shared storage.

‎09-15-2015

Thanks Daniel Urbach! We were moving some VMs and had to drop a large drive that was mostly empty except for the config files. I didn't think that it would be that big of a deal as we were going to have to rebuild the site anyway. Now we know. This could definitely happen though in the wild if you had a server failure that was hosting the config files. You might think that you are doing fine by backing up config files and directories, but not necessarily thinking that when it comes to restore, you will have to delete these files as well. Editing my original post to include the file information.

‎09-15-2015

When you delete the config files from an ArcServer, usually it gives you the "Create New Site" Wizard, but if you delete a network share, the service will fail at startup. You can try uninstalling the software and re-installing it, but it doesn't work. There's a reference left behind to that network share. To remedy this situation, you will need to Re-create the same exact network share. It's fine that it is empty. Re-start the ArcServer Service (on all machines in the site) It looks like at this exact moment, you can delete the network share as it has erased the pointer to the config files 3. Create a new site (doesn't have to use the same network share) Why am I using a network share to put my config files? The network share is local to one of the servers and it is a multi-machine site. Multi-machine sties require a network share and you cannot use references like \\server\d$\storage What should the software do? At minimum, it should clean up on re-install. It should also either, throw the ArcGIS Setup Wizard OR, a new page, that says: "Hey, we noticed that the network share '//server/share' is unavailabe. You may want to make sure that server is running and that the network share is being currently shared. Or, if you would rather, let's create a new site!" Then, if the server was down, when you boot it back up, it would go on about being ArcServer. It should definitely not just crash and burn like it does. Just put a check for missing network shares.... What happens if I'm not in a virtual environment and one of my servers crashed and I can't just spawn a new one real quick? How do I get my site back up?!?! Hopefully ESRI will tell you where that pointer is so that you can delete it. According to Daniel Urbach, delete the files, not folders in <installation path>/server/framework/etc. This will delete the references to the config store. More specifically, from my experience now, you can delete the <installation path>/server/framework/etc/config-store-connection.xml file. This file actually contains the reference to the config store and if it is not present, ArcServer will present you with the "New Site" wizard.

‎09-03-2015

If all you are needing to do is to increase the size of a field, don't worry about all this**. Follow these steps. Make the change in SQL Done. ESRI manages the COLUMN_REGISTRY table by itself. It will eventually (the next time ESRI accesses it) figure out that you increased the length of the base table. Thanks ESRI! If you are adding/removing columns from a registered view, according to Vince Angelo: Make a copy of your SQL view definition Delete the registered view using ArcCatalog (or arcpy) -- Your view is now dropped Make any changes to the base table in SQL Re-create your view with the changes Re-register your view with ESRI ** This applies to non-versioned data only. It does work for archive enabled content

‎09-02-2015

Which is exactly why I attempted to use Desktop to make this change. So, If I "delete" the view, what exactly is it going to delete? Will it drop the view from the database and I will need to re-create the view and then re-register it? Surely, it won't drop the table as well? Unfortunately none of this seems to be documented in the docs

‎09-02-2015

Right, that's how to change it in the database... But how do I get the ESRI metadata tables (specifically COLUMN_REGISTRY) to recognize the change? That's why I thought if I did it via arcpy, it would update the correct metadata tables. It did not, so I might as well have made the change directly with SQL. This data is not versioned or archived. It is only registered with the Geodatabase. That's why I'm thinking un-register/ reregister would refresh the metadata. I would really just as well like to update the column sizes directly via sql. I can't imagine it would hurt, and that's all arcpy would do anyway.

‎09-02-2015

I have tables that have multiple geometries (extent, centroid, boundary,... ) so they have multiple registered views on top of them. If I need to make changes to the fields, how should I do this? For example, I need to change the size of a text field from 32 to 60. In SQL, I would just make the change and go about my way.... In arcpy, I would: Rename the Field Add the field back with the new length Transfer the data Remove the renamed field I'm not able to do this on the views, so I tried on the base table. Arcpy ran through and succeeded, but when I look at the COLUMN_REGISTERY table, the COLUMN_SIZE is still 32. I guess I expected with all of ArcMap's overhead, that it would figure out that it needed to update these values, but I guess it doesn't store the link from view to table, so how could it....I'm really tempted to just update those values. I'm kind of assuming here that anytime I make a change to the base table or need to add/remove a field, I will have to: Unregister the View Make the change on the table [OPTIONAL] Make any changes on the view if necessary Re-register the view

‎09-02-2015

Web Adaptor = Reverse Proxy + Load Balancer That's it. The biggest use of it is for the Reverse Proxy, so they are just about interchangeable terms. It also acts as a load balancer if you have a multi-machine site. The Web Adaptor will add a small amount of overhead, because you have to process every request, and then forward them on to ArcServer whether they are on the same machine or on different machines. If traffic just went straight to ArcServer, it would be cutting out the middleman. If all you are using this for is a reverse proxy and your company has a corporate reverse proxy, you could actually just use that and not use the web adaptor. You don't need 2 reverse proxies, and the corporate one is probably done at the hardware level on devices specifically designed for proxying. It may also include the ability to load balance as well. The trade off of this is giving up control from the GIS Dept to the Network guys and having to rely on them to make any future changes. Also, you will probably need a seperate subdomain for ArcGIS Server and any maps that use the data instead of having them both on 1 subdomain, especially if using https. This one shouldn't be too big of a deal.

‎06-30-2015

This is what I was going to reply with, but I tried it in just WGS84 and it didn't change like I expected. I guess it has to be projected.

‎06-29-2015

Totally "unsupported", but you just delete all the rows from the SDE/GDB tables that reference the table and its columns. I had a table that wouldn't delete after adding a dummy table back in. I ended up just reading the ESRI docs on SDE databases, finding all the tables and deleted all references out. Works perfectly, but I do spend a lot of time on the backend so I feel pretty comfortable under the hood.

‎05-21-2015

Put an r in front of that string and you won't have to escape all of the slashes. r'C:\some\path'

‎05-07-2015

Have no idea. All I'm told is that it is network storage. I have found that having your publishing tools running in any cluster other than "default" will cause this issue. In fact, anything I tried while using multiple clusters generally ended in an error at some point. (ArcServer 10.2.2)

Online Status	Offline
Date Last Visited	‎12-05-2023 02:29 PM

My Ideas

Latest Contributions by JasonTipton

Re: AGOL - Dynamic Date Filter

Re: Update feature class MS SQL Server

Delete a feature class that ArcCatalog is unable to delete (Oracle)

Re: 10.1 Server manager - it takes 5 minutes to delete a service

Re: PSA: ArcGIS Server 10.2.2 Service crashes at startup even after re-install-- Network Share

PSA: ArcGIS Server 10.2.2 Service crashes at startup even after re-install-- Network Share

Re: How to update fields in a registered view

Re: How to update fields in a registered view

Re: How to update fields in a registered view

How to update fields in a registered view

Re: Web adaptor as reverse proxy?

Re: Need to create world map without dateline problem

Re: ArcGIS Server 10.3 Question about deleting SDE feature class

Re: make all of the data in fields uppercase

Re: Map Service publishing problem

Re: How to update fields in a registered view

Re: SDE DB Tune

Re: Is there a tool to Recalculate Feature Extents

Re: Is there a place to send comments on the ArcGI...

Re: Is there a tool to Recalculate Feature Extents