Latest Contributions by RexRobichaux2

Hi Anthony,   I have followed through this article with two different test tables and I was able to successfully publish the table out with feature access enabled, and pull the service back into ArcMap (or web apps) for querying/editing with both tests. This was done at 10.5.1 Desktop and 10.5 ArcGIS Server so admittedly I haven't tested this out at 10.3.x release. However- here are the steps I took on the most recent table create within SQLplus and publishing: It's worth noting that for testing I used the sde user (gdb admin user in my case within my Oracle 12c database) although I don't think that should matter if the following steps are taken. This database IS geodatabase enabled, however at no point was the table registered with the geodatabase.  Connect to my Oracle 12c database using the sde user in SQLplus In SQLplus: create table testtab2 (id number(38) not null, data varchar2(10), geom sdo_geometry); insert into user_sdo_geom_metadata values ('testtab2', 'geom', SDO_DIM_ARRAY(SDO_DIM_ELEMENT('', -180, 180,0.005), SDO_DIM_ELEMENT('',-90, 90, 0.005)), 4326); insert into testtab2 values (1,'test',sdo_geometry(2001, 4326, sdo_point_type(10,10,null), null, null)); create index testtab2_indx on testtab2(geom) indextype is mdsys.spatial_index; commit; desc testtab2; CREATE UNIQUE INDEX SDE.TESTTABINDX2 ON SDE.TESTTAB2 ( "ID" ); ALTER TABLE TESTTAB2 ADD UNIQUE (ID); COMMENT ON COLUMN "SDE"."TESTTAB2"."ID" IS 'ESRI auto-incrementing'; select object_id from all_objects where owner = 'SDE' and object_name = 'TESTTAB2'; Returned: 102380 CREATE SEQUENCE SDE.SEQ_102380 MINVALUE 1 MAXVALUE 2147483647 INCREMENT BY 1 START WITH 7 NOCACHE NOORDER NOCYCLE ; CREATE OR REPLACE TRIGGER SDE.BIFER_102380 BEFORE INSERT ON SDE.TESTTAB2 FOR EACH ROW DECLARE BEGIN IF :NEW.ID IS NULL THEN :NEW.ID := SDE.SEQ_102380.NEXTVAL; END IF; EXCEPTION WHEN OTHERS THEN RAISE; END; / grant select on seq_102380 to sde; grant select,insert,update,delete on testtab2 to sde; I then refreshed my sde user connection to the oracle database in ArcMap, added the new table Share As < Service Named / attributed the service accordingly < chose Feature Access Published the table out / viewed it successfully through server manager / and was able to pull the service down into ArcMap. Can you try these steps above and see if you are able to publish the table after another try? It might be just a matter of one step not running successfully, a different user used to publish the data, grant permissions, etc. I hope this helps! Best, Rex R ... View more

Hi Abdul,   From my experience, there are quite a few potential culprits to the connection issue / error you are experiencing. Do you have 10.1 (or newer) ArcGIS Desktop to test out a direct connection to that database? Can you connect through SQLplus using sde / sde as credentials as noted in the above example? I'd say we first need to verify that connection to that Oracle database is possible and then we can begin to isolate where the point of failure is. Possible points of failure include but aren't limited to: Network issues / lack of connectivity to the database server Credentials (sde/sde) ArcSDE application server / service (if applicable) -is the service running, etc. Oracle client files (instant / admin client) 32 bit and 64 bit? What version oracle client is present? For example, I believe Oracle 12c clients aren't compatible with Command Line tools. In this circumstance, I'd recommend reinstalling the Oracle 11g client and trying again.  tnsnames.ora located on this client machine, and referencing the proper Oracle SID info? Listener up and running on the server machine? Accepting connections?   These are just a few areas that come to mind. If you could verify the ability to connect outside of command line to this database that would be helpful in narrowing down the cause. I hope this helps! Best, Rex R ... View more

Hi Justin- if this is primarily to keep a record of users who perform edits / inspections on data within the geodatabase- have you considered editor tracking instead of using domains? Editor tracking should allow you to see which user created the record, last edited the record, along with associated dates of feature creation and last edit: Enabling and managing editor tracking—Help | ArcGIS for Desktop  It would seem that something like this might be a more user-friendly / management friendly solution to using coded value domains for tracking users and record edits. Alternatively, the Attribute Assistant add-in might be helpful although I haven't personally used it. Attribute Assistant | ArcGIS Solutions  Hope this helps! -Rex ... View more

Hi Gert,   Could you provide a little additional info on the type of SQL geodatabase this data resides in? Is this a SQL personal / Desktop database or something along the lines of SQLite? I only ask because you (in theory) might be getting such an error if this data resides in a 2008R2 SQL database as 10.5 is unable / unsupported for connection to any SQL database prior to SQL Server 2012 SP3: Microsoft SQL Server database requirements for ArcGIS 10.5—System Requirements | ArcGIS Desktop  It's odd that the datetime type works but the datetime2 seems to cause the error. I have quickly tested a similar workflow and was able to repoint data from a 10.2 .mxd in 10.5 without issue containing a field with datatime2 type.   ... View more

Hi Ruben,   Sorry to hear of the recent issues with edit loss. Can you describe in a bit more detail the current versioning structure of the database- IE is this a flat version tree with a single edit/transaction version off of the Default version, or do you have other edit versions in existence as well? Any intermediate (QA/QC versions) between the edit versions and default? Are there any other long-standing edit versions that were created long ago that still exist? Any additional information you can provide about the versioning structure and workflow of the reconcile / post process (were conflicts detected by object or by attribute?) would be helpful to theorize how edits may have disappeared.  Best, Rex  ... View more

Hi William-   I just wanted to confirm what you said in the first post and that it is the Oracle instant client installed vs the admin client?  Also, you mention system in a couple of places- are these different windows users on the same machine trying to open ArcMap 10.2.1 and connect to that Oracle database or are these users on different machines?  If this is all one one machine, could you try (while logged in as you / the successful user) try opening ArcMap as one of the other users who is having issues (shift + right click < run as different user) and test. Also, depending upon the results of this- log onto the machine as one of the problematic users- and run ArcMap as yourself and re-test. Sorry- just trying to get a little better understanding of the configuration. Can you provide a screenshot of the database connection properties of the connection as well? Thanks! ... View more

That's great to hear Michael. I can verify that regrettably, this issue will still be persistent at Oracle 12c at this time. ... View more

Hello Evelyn,   It would at first glance appear that you are running into a resource limitation within your SQL Server environment. Essentially you have four core resources which could potentially lead to performance problems / failures: 1) Memory 2) Disk I/O 3) CPU 4) Network   I would suggest looking into the first three as possible culprits for this issue via performance monitor on the SQL Server machine hosting the instance. Check the SQL Server logs within Management Studio < Management < SQL Server Logs folder- see if any mentions of available space / or insufficient memory (or memory pressure) arise. If you are running into memory pressure- try to diagnose and resolve the cause and / or add additional RAM if possible.    Also view the error log file for SQL Server which should be stored here or in a similar location on the SQL Server machine: C:\Program Files\Microsoft SQL Server\MSSQL##.MSSQLSERVER\MSSQL\Log.   I'm thinking you are either running out of memory or disk space and these are the symptoms you are experiencing. I hope this is helpful!    ... View more

Hi Michael, the issues you are experiencing certainly sound like they could be associated with the noted defect in the other thread:  BUG-000104457 - Error: “Opening feature class. Insufficient permissions” is encountered while adding data to ArcMap 10.5 session using Data Owner.   I would definitely recommend reaching out to Esri Support Services to confirm this is the same 10.5 / Oracle role permissions issue you are running into. If you have any questions please feel free to let me know! ... View more

Sure thing Joe. Unfortunately, I believe there is no way to quickly see all edits currently contained within or referenced by a version because when versioned edits are made in ArcGIS- they are made in and stored to corresponding feature class delta tables until the (database is compressed) and the queried through a series of versioning-related tables.  I believe you will have to create queries such as the two provided above for every feature class that undergoes versioned editing and therefore could potentially have versioned edits residing within their corresponding Adds and Deletes tables that are referenced by the default version. This can be found from SDE_table_registry table by finding the registration_id value for each versioned, edited feature class. Perhaps Vince could confirm this but that is the only way I could foresee you obtaining all edits currently referenced by the Default version. Hope this helps! ... View more

This might be possible through python- but it should certainly be achievable through a DBMS client (for example SQL Server Management Studio or SQL Developer for Oracle) of a feature class by feature class level. Try the following workflow and query (this was done within a SQL Server geodatabase for testing). In ArcCatalog create a new point, line or polygon feature class in your enterprise gdb. I created a test polygon FC named "Defaulttest" Register the new FC as versioned (without the option to move edits to base) Open SQL Server Management Studio and navigate to the SDE_table_registry table < Open the table and order by table_name column Find the newly created Defaulttest feature class and its corresponding registration_id value in the column. This will correspond with the delta (adds and deletes) tables for that feature class For me it was (182- update the below query with your values) Then run the following query (ensuring it's against the geodatabase containing the edits): SELECT 'Updated Features' as delta, COUNT(*) as cnt FROM sde.A182 WHERE SDE_STATE_ID IN (SELECT STATE_ID FROM SDE.sde_STATES WHERE LINEAGE_NAME IN (SELECT LINEAGE_NAME FROM SDE.sde_STATES WHERE STATE_ID = (SELECT STATE_ID FROM SDE.sde_VERSIONS WHERE NAME ='DEFAULT' ) ) ) Likewise, the following query should return how many deletes are currently stored in the associated delete table:  SELECT 'Updated Features' as delta, COUNT(*) as cnt FROM sde.d182 WHERE SDE_STATE_ID IN (SELECT STATE_ID FROM SDE.sde_STATES WHERE LINEAGE_NAME IN (SELECT LINEAGE_NAME FROM SDE.sde_STATES WHERE STATE_ID = (SELECT STATE_ID FROM SDE.sde_VERSIONS WHERE NAME ='DEFAULT' ) ) ) There might be a way to obtain total amounts of edits (cumulatively)- but this is the only easy method I know in SQL to determine updated feature numbers on a feature class by feature class basis. I hope this is helpful! Best, Rex R ... View more

To follow up with George's reply above- custom triggers are not recommended or supported on versioned data due to the chance of data corruption. Also, as George mentioned, any edits not performed through an ArcGIS client will need to be made through the versioned view of the feature class. More on using SQL to edit versioned data in Oracle can be found here: Edit versioned data in Oracle using SQL—Help | ArcGIS Desktop  One other option that is worth mentioning (depending on what version of ArcGIS Desktop you are at) would be to utilize the Attribute Assistant Add-in application which can perform automatic updates on related or specified data: Attribute Assistant | ArcGIS Solutions  local-government-desktop-addins/Attribute Assistant Add In/AttributeAssistantAddIn at master · Esri/local-government-des…  I hope this is helpful for you! Best, Rex R ... View more

Hello Jipcik,    I would recommend you (and anyone else experiencing this issue) to reach out to Esri Support Services (Geodata support team) and see if they can offer some additional assistance regarding this issue. I believe a recent defect may be relevant to what you are experiencing- however, further troubleshooting would be needed to confirm the relevance.  BUG-000102962: The "invalid geometry" error occurs when using pg_restore method to move data to a new PostgreSQL instance version. The current suggested workaround which you can try is to:  Create a new, empty geodatabase on a 9.5 PostgreSQL instance Connect to the original 10.3.1 geodatabase on the 9.3 PG instance, and then the new 10.5 (or version equivalent) geodatabase on the 9.5 instance from the same ArcCatalog session. Copy and paste the data from the old instance into the new instance. If any geometry errors are identified int he process they can be addressed by repairing the geometry.  I hope this is helpful for you in analyzing the pg_restore issues you are experiencing- Best, Rex R  ... View more

Hello Ryan-  Thank you for providing some in-depth information and background on this issue. I would encourage you to reach out to Esri Technical Support (Geodata) if possible regarding this matter for further analysis.  ... View more

Hi Tom,      It sounds as though at some point an orphaned record referencing the city_2 feature class has been created / remains in the GDB_ITEMS table within your SQL Server database. A quick way to test would be to connect to the database through your admin connection within SQL Server Management Studio and navigate to the GDB_ITEMS table and either query the table or preview the table and order by Name or PhysicalName fields.    Scroll through the table and see if you can find a record for the city_2 feature class and if necessary / desired you can remove this record and see if the feature class is removed upon refresh in ArcCatalog. As always, it is recommended to either perform this in a test environment (if possible) or at least have a fresh, full database backup created and on hand in the event of a mishap.    I hope this is helpful to you! Kind regards, Rex ... View more