Latest Contributions by VinceAngelo

Please start using the title field as a title field.  Long lists of comma delimited words and verbose chatter in the title are driving away folks who might answer your questions.  If you want your questions answered, I recommend you work harder towards framing a complete question, with a description of the software in use, and a complete description of your inputs and desired outputs.  Only after the question is complete (and it should have a question mark to indicate the issue, framed as a question) should you go back and design a title which reflects the core issue.  A good title will attract the interest of folks who have the knowledge you seek.  In this case, maybe "Statistical error determination across three datasets". ... View more

"Query Layers in SDE" is a bit of a non-sequitur, because Query Layers exist outside of enterprise geodatabases, and SDE no longer exists (repeat after me: There is no more SDE.  There is no more SDE...).  The tables of an enterprise geodatabase are visible as Query Layers, but because they are Query Layers, the rowid column is prompted, and none of the geodatabase behavior is available (including geodatabase locking). The main drawback to replacing all your feature classes with Query Layers is that, since the geodatabase envelope property is not available, ArcGIS can't tell when a full table scan query would be more efficient than a spatial extent query, so, if you have feature classes rendered at the top scale levels, they will be slower to execute than an equivalent enterprise geodatabase feature class at the same scale. - V ... View more

Multi-threading is so easy in Java, kicking off a thread to "touch" the GP job folder at 5 minute intervals is trivial (once the job folder is identified, the thread just has a sleep(300000) and a File.setLastModified(now)).  Porting that to Python would hang on multithreading, but if your main loop runs in a fraction of the refresh interval, you can just add a loop element to invoke os.utime with the current time on the job folder. It's hard to understand how updating a mosaic dataset footprint could take hours to run. - V ... View more

Optimizers are a law unto themselves.  By changing between 9.3.1/Oracle and 10.3.1/SQL-Server there really is nothing in common for comparison.  The main issue for query plan selection is the database's determination as to whether the spatial index statistics are "fresh enough" to be trusted.  "Freshness" can include both the number and relative volume of edits in a table, and a raw "time since last update" component. You haven't given any indication of the edit frequency and editing volume on the tables.  In an ideal world, indexes would be rebuilt on a regular basis.  Actually, in an ideal ideal world, a table with frequent edits would be spatially defragmented on regular basis, then the spatial index rebuilt, and the index statistics updated.  In the real world, you might have to settle for updating index statistics at half the interval where you're noticing performance degradation, then scheduling an outage when the table is badly spatially fragmented. - V ... View more

How long is "ages"?  The usual unit of database activity measurement is milliseconds.  Once warm, I can connect to a SQL-Server 2012 database in under 50 milliseconds, and export queries usually proceed at 30,000 features per second.  If your connect time exceeds 3000ms, there may be something wrong with your network configuration, though I have seen long Desktop connection times (5000-7000ms) with hundreds of thousands of tables and tens of thousands of feature classes. The terminal release of ArcGIS 10.2.x was 10.2.2.  All 10.2 users are strongly advised to install 10.2.2 and all the relevant security and functionality patches. - V ... View more

You must be the table owner to register a table. Have you tried using the delete or truncate tools?  You might need to be owner to truncate, or it might just be a required GRANT. DELETE is always inefficient, because it's a logged transaction. - V ... View more

Any table can be registered with the geodatabase via right-click "Register with geodatabase", provided you're willing to have an SDE-set registered rowid column. Any table with a unique not-NULL integer column can be registered with a USER-set rowid column via sdetable -o register- (actually, any table can be registered without a rowid, but ArcGIS might be expecting a rowid column) ... View more

"DELETE * FROM table" is a SQL syntax error.  You should not use DELETE when TRUNCATE is appropriate, though the difference only really manifests in large tables (over 100k rows) There are two geoprocessing tools available for delete and truncate, though they may require that the table be registered with ArcSDE before they will function. - V ... View more

There are many possible issues here. First off, there's the way the service has been configured.  On the Pooling page, there's a value for "The maximum time a client can use a service" (default is 600 sec -- 10 minutes).  On the Processes page, there's a "Recycle this configuration every" property, which defaults to 24 hours.  What values do you have on these parameters? Even when these properties are set to values which would permit the job to continue, there's another aspect -- If the job directory remains unchanged for the service use duration, even when the job is running successfully, then the job will be terminated and the job folder removed.  I've successfully used a Thread in my ArcObjects Java GP job to update the job folder to prevent preemptive termination. Finally, you may just need to restructure your service to run in smaller processing units, so that no job exceeds 10-15 minutes of execution, with a "state set" (JSON or ASCII file or table) to track where the last processing step left off, so that execution can seamlessly continue.  A servlet would be ideally situated to follow progress and resubmit work units as necessary, though you might be able to just let each job request a new job to continue its work.  The sexy part of this option is that you might be able to use multiprocessing to solve the job fragments in parallel, reducing overall runtime. - V ... View more

And yet the error asserts otherwise.  View registration is a point-in-time validation process.  There's no way to be sure the view wasn't updated or the data in the viewed table wasn't changed to violate rowid integrity. ... View more

It appears that a a duplicate row is the issue.  How is the TAX_FLAT_OWNERS_VIEW view structured?  Does it violate the rowid uniqueness constraint? ... View more

MIcrosoft documentation or forums might be a better place to research the proper use of Microsoft SQL Server native functions.  The basic process is the same as with the Esri-written ST_Intersects and ST_Area functions used in non-Microsoft databases, but the SQL-Server syntax has it's own quirks (including case sensitivity), so it's best to get your information from the capability provider. - V ... View more

You're soliciting a legal opinion on the Internet, which is worth exactly what you pay for it, but there's a decent answer over on gis.stackexchange.com. If you understood more about what the JS API is, then some of the answers to your questions would be obvious.  It's important to understand that the JavaScript API isn't ArcGIS Online.  The JS API is a framework for writing browser-based applications.  JS API applications can consume map data from a number of sources, including local ArcGIS Server services (which are licensed separately).  They can also consume  ArcGIS Online services.  AGOL services may require additional cost,  depending how they are used -- This is the part where you really need to speak with an Esri representative (note that this is an AGOL use issue not JS API). Esri is a large organization.  Perhaps you didn't contact the right department.  I know there are folks who explain licensing terms to individuals all day long, but there are other folks (the majority of us, really) who don't deal with license issues regularly, and would be understandably reluctant to provide incomplete or incorrect information, no matter how hard-pressed for a response. - V ... View more