Latest Contributions by SherrieKubis

SQL Server 2016  SDE 10.5  Our SDE prototype to migrate from Oracle is ramping up.   We have experience with SDE in Oracle, but not in SQL Server.  Because this pilot will continue for the next year, we are going with the latest and greatest versions.  I'm looking for best practices, suggestions, tips on using SDE in MS SQL.   In Oracle, we have a master geodatabase and user-schema geodatabases in the same Oracle database.  We do versioned editing in the user-schema gdbs.   Can anyone share their experience?  I'm just starting, getting the terminology down and a staging SQL instance and database up and running.  There is a lot to learn.  Sherrie ... View more

We are starting a prototype to migrate ArcSDE data from Oracle to SQL Server.  Since we are planning for the future I want to do the latest versions of SDE and SQL Server.  In the http://desktop.arcgis.com/en/system-requirements/latest/database-requirements-sqlserver.htm install guide I see that SQL 2016 is listed.  Anyone have any recommendations or experiences to share?   ... View more

Oracle RDBMS 12.1.0.2  SDE 10.2.2 In Oracle I am auditing as 'audit create session by access whenever not successful;' I frequently see these come back from ArcMAP sessions ORA-29904 Error in executing OCIINdexClose routine. The SDE Admins see no errors, I've had no other complaints.   Any suggestions on how to dig into this deeper and find the root cause?  Sherrie  ... View more

Oracle RDBMS 12.1.0.2  SDE 10.2.2 We have many nightly update jobs that use arcpy, others use FME.  Sporadically, some of the arcpy jobs fail.  Since they run in batch mode, the developer is having trouble seeing what the returned error is.  Sometimes the jobs all work without issue, other times maybe 5 to 10 of them fail.   To determine the failures I created a login trigger for the data owner between the hours of the nightly updates.  I found  enq:  TX - row lock contention on GDB_TABLES_LAST_MODIFIED.  It was previously suggested to me to increase initrans from 4 to 8, but that made no difference.  In the development environment, I increased it to 50 and it still made no difference, so I set it back to 4.  Has anyone had similar issues?   The failures happen with arcpy jobs, but not with FME jobs, both from the same Windows server as the client to the database.   Sherrie ... View more

I'm just beginning research into PostgreSQL, with more questions that answers at the moment.  Our history is that we are a long-term ESRI product user, and have been using SDE since version 3.2, always in Oracle.  My direction now is to investigate migrating spatial data to PostgreSQL.  I'd like to do this on Linux. For those who have gone before me: - how big is the market share of GIS users in PostgreSQL for production use?  - What flavor of Linux is most commonly used?   I see that RedHat and SUSE are supported. - I see this latest version of PostgreSQL  noted: PostgreSQL 9.3.5 (64 bit)  with PostGIS 2.1 But I also see may flavors of PostgreSQL advertised, Advanced Server from EnterpriseDB, PostgreSQL Plus. What flavor do you use?  What has been your experience? Where have you trained?  PostGIS - is this required?  Any insights or comments are appreciated, I apologize in advance for the "newbie-ness" of the question.   ... View more

Oracle RDBMS 12.1.0.5 Oracle Enterprise Linux 6.6 SDE 10.2.2 Patch 290200 We have some feature classes with srid 2882, and I've found some with srid 300002.  I understand that the srid's should match to participate in an ST_ overlay function when EXTPROC kicks in.  However, these must be supported transformations because for the most part, it works, just slower. However, there are times that this error returns instead of the in-place transformation happening: ERROR: ORA-28579: network error during callback from external procedure agent ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 100 ORA-06512: at "SDE.ST_RELATION_OPERATORS", line 340 It's quite inconsistent, where sometimes it works, sometimes it doesn't.  In troubleshooting other EXTPROC issues, I've created a nightly 'health check' programs, that does an ST_INTERSECT with feature classes that meet a certain criteria and another static multi polygon fc.  It runs at night, no errors found.  If I run the mixed srid interactively, it errors.  I've been looking at this for a long time and tested may scenarios, but I'm stumped.  My answer going forward is to only overlay those fc's with matching srid's.  I'd like to understand what's going on here though.  At one point we opened a ticket with ESRI support and the answer was that it's our data.  Yes, it was, and i now know it was because the srid's were different.  When two input geometries have different spatial references (different SRID values), the ST overlay operator transforms the shape geometry to the same spatial reference prior to performing the relational comparison.  This results in extra time spent in memory while the transformation happens, but it should still work and not error.  Sometimes it does, sometimes it doesn't.  Any insights are appreciated. Sherrie ... View more

Oracle RDBMS 12.1.0.5 Oracle Enterprise Linux 6.6 SDE 10.2.2 Patch 290200 We use ST_GEOEMTRY and ST functions, mostly ST_INTERSECTS.  EXTPROC is configured and works well -- most of the time.  We have this weird problem, when for no reason that I can find (ANYWHERE!), a feature class that participates in an overlay function, returns an error.  They are always reference layers, meaning they are static and don't change.  To avoid a production issue, I've created a health check program that creates a dynamic SQL that does an ST_INTERSECT with two layers; I then interrogate the log file and send an email when an error happens.  The error: ORA-28579: network error during callback from external procedure agent ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 100 ORA-06512: at "SDE.ST_RELATION_OPERATORS", line 340 The fix is to recreate the feature class from ArcCatalog, and then insert rows from the bad feature class, and generate statistics.  I've asked the SDE Administrators to keep the erroring feature class so that I can use it for testing, looking for differences.  Last night the health check ran without an issue. Today, I have two feature classes to work with:  COUNTIES and COUNTIES_OLD.   I know that COUNTIES is the current, valid FC, and COUNTIES_OLD was one that returned an error on 1/11/2016.  My first test showed that the reverse is true.  While COUNTIES was fine at 3am, it now returns an error.  While COUNTIES_OLD returned an error on 1/11/2016 it returns fine today.  Oddly enough, I see two different errors returning from COUNTIES, depending on an embedded literal: select ' fc: COUNTIES' , a.owner, a.numwells from asr a left outer join COUNTIES c ON sde.st_intersects (c.shape, a.shape) = 1; select ' fc: COUNTIES' , a.owner, a.numwells * ERROR at line 1: 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 Removing the literal, with the same SQL (and this is the error I usually get, even with the literal): select a.owner, a.numwells from asr a left outer join COUNTIES c ON sde.st_intersects (c.shape, a.shape) = 1; select a.owner, a.numwells * ERROR at line 1: ORA-28579: network error during callback from external procedure agent ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 100 ORA-06512: at "SDE.ST_RELATION_OPERATORS", line 340 This was odd enough behavior, not this makes it weirder.  We had an open ticket with ESRI support, who asked for our data.  After much back and forth, the answer was 'something in your data - recreate'.  I also have an open SR with Oracle support.  They've been very thorough and helpful, looking at traces, statistics, but their ultimate answer was to go back to the vendor.  Maybe someone has an idea or has experienced similar issues.  Any insights are appreciates.  ... View more

In Oracle 12c we allow the nightly system stats gathering to collect statistics for us. We have one feature class that causes a timeout.  In reproducing this manually, I find that it's the domain index, with this SQL running.   This FC is dropped and recreated nightly, so the possibility of gathering and then lock stats isn't there.   Also, I have yet to get it to finish. I tried to put a degree on the index, but running the stats doesn't pick that up. BEGIN    SYS.DBMS_STATS.GATHER_TABLE_STATS (       OwnName           => 'SDECREATOR'      ,TabName           => 'SITES_EDIT_WCPFLG1'      ,Estimate_Percent  => dbms_stats.auto_sample_size      ,Method_Opt        => 'FOR ALL COLUMNS SIZE AUTO '      ,Degree            => dbms_stats.default_degree      ,Cascade           => FALSE      ,No_Invalidate  => FALSE); END; / BEGIN    SYS.DBMS_STATS.GATHER_INDEX_STATS (       OwnName           => 'SDECREATOR'      ,IndName           => 'A1245_IX1'      ,Estimate_Percent  => NULL      ,Degree            => dbms_stats.default_degree      ,No_Invalidate  => FALSE); END; / SELECT /*+ no_parallel(b) no_parallel_index(b) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */         DBMS_ROWID.rowid_block_number (b.ROWID)     FROM (SELECT s.sp_id,                  s.gx,                  s.gy,                  ROW_NUMBER () OVER (PARTITION BY s.sp_id ORDER BY s.gx, s.gy) rncol             FROM SDECREATOR.S1375_IDX$ s) sp,          SDECREATOR.SITES_EDIT_WCPFLG1 b    WHERE rncol = 1 AND b.ROWID = sp.sp_id ORDER BY sp.gx, sp.gy, sp.sp_id; ... View more