Latest Contributions by JoshuaDalton

Trick still works in 11.3.  Kill the OpenJDK with -Dprofile=portal in the command line after saving changed catalina properties file. ... View more

NOTE: steps below are for sde 10.8.1, adjustments may be needed for other versions. Realizing this is an old post, but for those migrating database servers without doing full export/import of db... this can be caused by importing sde schema objects in incorrect sequence, and also lack of st_spatial_index object.  In Oracle I did the following to repair it: 1: run this command on your working SDE instance to get the statement to recreate the ST_SPATIALINDEX type on the broken instance: SELECT DBMS_METADATA.GET_DDL('INDEXTYPE', 'ST_SPATIAL_INDEX', 'SDE') FROM DUAL; Run the SQL output it gives you on the broken instance to remake the ST_SPATIAL_INDEX type. 2: In my case I also had to fix the following: regrant all sde schema grants to public, some were missing.  I used the following script to export the commands to dbms_output to regrant them all: SET SERVEROUTPUT ON SIZE UNLIMITED; BEGIN FOR r IN ( SELECT owner, table_name, privilege FROM dba_tab_privs WHERE grantee = 'PUBLIC' AND grantor = 'SDE' ) LOOP DBMS_OUTPUT.PUT_LINE('GRANT ' || r.privilege || ' ON ' || r.owner || '.' || r.table_name || ' TO PUBLIC;'); END LOOP; END; /   3: Then I also had to copy the gdb_items table over because it had issues importing originally: This was best done using sql insert statements because of the CLOB and ST_GEOMETRY datatype columns involved.  Use this to generate them: select 'insert into sde.gdb_items(OBJECTID, UUID, TYPE, NAME, PHYSICALNAME, PATH, URL, PROPERTIES, DEFAULTS, DATASETSUBTYPE1, DATASETSUBTYPE2, DATASETINFO1, DATASETINFO2, CONTINGENTVALUES, DEFINITION, DOCUMENTATION, ITEMINFO, SHAPE) values(''' || OBJECTID || ''',''' || UUID || ''',''' || TYPE || ''',''' || NAME || ''',''' || PHYSICALNAME || ''',''' || PATH || ''',''' || URL || ''',''' || PROPERTIES || ''',' || case when DEFAULTS is null then 'NULL' else ''''||to_char(DEFAULTS) || '''' end ||',''' || DATASETSUBTYPE1 || ''',''' || DATASETSUBTYPE2 || ''',''' || DATASETINFO1 || ''',''' || DATASETINFO2 || ''',' || case when CONTINGENTVALUES is null then 'NULL' else ''''||to_char(CONTINGENTVALUES) || '''' end || ',''' || DEFINITION || ''',''' || DOCUMENTATION || ''',''' || ITEMINFO || ''',' || case when shape is null then 'NULL);' else ' sde.st_geomfromtext(''' || to_char(sde.st_astext(shape)) || '''));' end from sde.gdb_items;   After doing those things, I compared rows counts between the old and new sde schemas and they matched again, so that seems to have resolved the issues.  I can now connect again and create feature classes.  You may not need to complete all of these steps as your symptoms may vary. ... View more

And back to this error again on yet another machine on 11.1.  In addition to changing %p to pg_wal/%f, we added double-quotes around the path for the dbcli command, added the .bat extension (probably unnecessary), and since quoted, we removed the ^ from the Program Files sections (both places), which changed the archive_command from this: archive_command = 'D:/Program^ Files/ArcGIS/DataStore/framework/etc/scripts/dbcli put-transaction-log "D:/arcgisdatastore/pgdata/%p" "%f" "D:/Program^ Files/ArcGIS/DataStore/"' to this: archive_command = '"D:/Program Files/ArcGIS/DataStore/framework/etc/scripts/dbcli.bat" put-transaction-log "D:/arcgisdatastore/pgdata/pg_wal/%f" "%f" "D:/Program Files/ArcGIS/DataStore/"' This was the entry in the logs before applying the changes: 2025-03-25 00:02:55 EDT: [12304]: [105467-1] LOG:  archive command failed with exit code 1 2025-03-25 00:02:55 EDT: [12304]: [105468-1] DETAIL:  The failed archive command was: D:/Program^ Files/ArcGIS/DataStore/framework/etc/scripts/dbcli put-transaction-log "D:/arcgisdatastore/pgdata/pg_wal\000000010000000000000002" "000000010000000000000002" "D:/Program^ Files/ArcGIS/DataStore/" I can confirm that the dbcli.bat file was not launching before our change, as we watched for it in ProcessMonitor.  So this time it seems less like a source/target folder permission, and more like permission to launch the dbcli command in the way it is being passed to the windows command line shell by postgres. We did try using D:\Progra~1\... instead of D:\Program^ Files\... but that did not work without the quotes.  Leaving the ^ in with quotes also still gave the error.  Possible the ~1 may work with quotes. Long story short, probably best not to install to folders with spaces in them, and correcting the %p with pg_wal/%f is still also a good idea.  Quoting the dbcli command and removing the ^ escape characters seems to correct the issue when a space exists in the path. ... View more

I was also getting the "Something went wrong Edits could not be saved: Unable to complete operation." error. Install Telerik's FIDDLER and watch your browser's web traffic, you should see a failed request come through when you hit Create or Update.  Click on that and you'll see a way more useful error message.  It would be nice if they put the failed rule name in that generic error message. You'll see something like this in the response content: Internal error during object insert. Failed to evaluate Arcade expression. [ Rule name: IU_LastEditUserID, Triggering event: Insert, Class name: AREAS_POLYGONS, GlobalID: {A12345EA-1F12-12E1-1B12-0123456789D1}, Arcade error: Unexpected null, Script line: 2]   Also, debugging method aside, you can probably fix your error by changing the Arcade expression to use HasItem first, then make sure the value is not null too before using it.  Sometimes more like this function that gets the right user id from both ArcGIS Pro and Portal (because it may return a value or have certain attributes in one but not the other): var username=""; var userinfo = GetUser(); if(userinfo==null) { username=""; } else if(HasValue(userinfo, "email")) { var array = Split(userinfo.email,"@",1); username = array[0]; } else if(HasValue(userinfo, "username")) { username=userinfo.username; } return username; In short, make sure you always check your arcade function call results to be sure they didn't return a null before using the attributes inside them. ... View more

An old topic, but I'm having similar issues with an ArcGIS Datastore 11.3.  Oddly we had determined that pgdata\pg_wal would fill with the files if ArcGIS Datastore was running as a domain account with administrator access and Full Control on the whole drive and all subfolders, and you would get the error messages: 2024-10-19 00:02:17 EDT: [2844]: [2495-1] LOG:  archive command failed with exit code 1 2024-10-19 00:02:17 EDT: [2844]: [2496-1] DETAIL:  The failed archive command was: E:/Apps/ArcGIS/DataStore/framework/etc/scripts/dbcli put-transaction-log "E:/arcgisdatastore/pgdata/pg_wal\000000010000000000000002" "000000010000000000000002" "E:/Apps/ArcGIS/DataStore/" Access is denied.  But... it would archive the files out over time if you stopped the service and made it run as Local System. I'm not sure how that reflects on the fix I made though.  To fix it, I noticed the single \ in the archive command used.  This is coming from using %p in pgdata\postgres.conf under the archive_command setting.  Since some older postgres issues were documented elsewhere on the web with regard to it interpreting special characters in the archive_command, I changed the command setting from this:  archive_command = 'E:/Apps/ArcGIS/DataStore/framework/etc/scripts/dbcli put-transaction-log "E:/arcgisdatastore/pgdata/%p" "%f" "E:/Apps/ArcGIS/DataStore/"' to this: archive_command = 'E:/Apps/ArcGIS/DataStore/framework/etc/scripts/dbcli put-transaction-log "E:/arcgisdatastore/pgdata/pg_wal/%f" "%f" "E:/Apps/ArcGIS/DataStore/"' Now it seems to be archiving.  I'm not sure if other folders may try to also use this command, but it definitely got it to stop leaving 16mb files in the pg_wal folder every 5 minutes.  I'll watch logs and see if anything else fails as a result of the change. ... View more

See it, we will be there once food line moves ... View more

Sorry, to be clear, I resolved the issue using the commands I posted.  There were some additional objects left behind by the failed first run of the Enable Enterprise Geodatabase tool.  I really ran it 3 times to encounter the problem. Try #1: Oracle TEXT package was missing.  I installed Oracle Text package by following steps as the oracle OS userid:   at shell: sqlplus -nolog in sqlplus: connect / as sysdba in sqlplus: @$ORACLE_HOME/ctx/admin/catctx.sql temp1password SYSAUX TEMP NOLOCK; in sqlplus: alter user ctxsys identified by better2password; in sqlplus: connect CTXSYS/better2password in sqlplus: @$ORACLE_HOME/ctx/admin/defaults/drdefus.sql;     Try #2: Failed because one of the CTXSYS packages didn't compile correctly during TEXT install.  ORA-06508: PL/SQL: could not find program unit being called: "CTXSYS.DRVDML"  Fixed using following:   in os shell: sqlplus -nolog in sqlplus: connect / as sysdba in sqlplus: GRANT EXECUTE ON UTL_HTTP TO CTXSYS; in sqlplus: ALTER PACKAGE CTXSYS.DRVDML COMPILE BODY;     Try #3 and beyond started failing because the Enable Enterprise Geodatabase left some objects behind after failing on try #2.  For me these objects were the LAST_EDIT_ID_GENERATOR sequencer, some ST_GEOMETRY operators, types, and type bodies.  I resolved this issue by dropping the objects that still existed for SDE.  note TYPE BODYs and OPERATORs must be dropped before dropping the ST_GEOMETRY type itself.  So, I ran these commands in SQL using the SDE login:    DROP SEQUENCE LAST_EDIT_ID_GENERATOR; DROP OPERATOR ST_DWITHIN; DROP TYPE BODY ST_GEOMETRY; DROP TYPE ST_GEOMETRY;     You can get a list of commands to run to drop remnants left by failed runs of the Enable Enterprise Geodatabase tool using this command:   select 'DROP '||object_type||' SDE.'||object_name||';' from dba_objects where owner='SDE' and object_type<>'LIBRARY' order by decode(object_type, 'PACKAGE BODY',1, 'PACKAGE',2, 'FUNCTION',3, 'SEQUENCE',4, 'TRIGGER',5, 'VIEW',6, 'LOB',7, 'INDEX',8, 'TABLE',9, 'INDEXTYPE',10, 'OPERATOR',11, 'TYPE BODY',12, 'TYPE',13, 14);   For anyone dealing with this issue, it may be simpler to do this than drop the whole SDE user and remake it with needed permissions, quotas, and roles granted, but that would work too. Since this tool enables Geodatabase function on an existing database, which in this case had a ton of data already present in other user schemas, dropping the SID and starting all over would be significant overkill. The above SELECT command gets you a list of all things left behind that are preventing installation that need to be dropped so the tool will run to completion. ... View more

I've just encountered the same thing after a failed install for Oracle TEXT, then fixing Oracle TEXT, and getting a CTXSYS error about OIDCINDEXCREATE ,EXT_Error = 29855 ,EXT_ERROR1 = ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: Oracle Text error: DRG-50857: oracle error in drepopen ORA-04063: package body "CTXSYS.DRVDML" has errors ORA-06508: PL/SQL: could not find program unit being called: "CTXSYS.DRVDML" So then running GRANT EXECUTE ON UTL_HTTP TO CTXSYS; ALTER PACKAGE CTXSYS.DRVDML COMPILE BODY; left me with this error: [01:15:19.841] MULTIBRANCH_TABLES table being created... [01:15:19.946] MULTIBRANCH_TABLES table created... [01:15:19.995] TABLES_LAST_EDIT_TIME table being created... [01:15:20.074] ERROR in creating TABLES_LAST_EDIT_TIME table. Error: -901 [01:15:20.074] DBMS error code: 955 ORA-00955: name is already used by an existing object [01:15:20.074] SDE schema object install not completed. [01:15:20.129] ERROR installing/upgrading ArcSDE, Error = -1 This statement below should resolve the issue.  This is probably reportable as a bug in the post-failure cleanup for the Enable Enterprise Geodatabase tool, as the sequence isn't being deleted after a failure. DROP SEQUENCE LAST_EDIT_ID_GENERATOR; Also the following may linger after a failure to create or enable a geodatabase: [01:32:19.068] ERROR setting up st_geometry type. [01:32:19.068] Failed to create the ST_Geometry metadata tables during install. [01:32:19.068] DBMS error code: 955 ORA-00955: name is already used by an existing object Do the following to resolve: DROP SEQUENCE LAST_EDIT_ID_GENERATOR; drop operator st_dwithin; drop type body st_geometry; drop type st_geometry; ... View more

Additional notes for linux installs.  1: stop server, unset http_proxy, https_proxy, and no_proxy environment variables, then restart server.  create site. 2: if that doesn't work, look into hostname.properties file as an option if machine has multiple NIC cards. ... View more

You are my hero.  Thank you.  I've been fighting with this for days.  As an addendum, the arcgis\portaladmin page will give you Error response of "Unable to import certificate Code: 500" and the Catalina logs under ArcGIS\portal\framework\runtime\tomcat\logs will show following errors: 09-Dec-2020 14:29:07.682 SEVERE [https-jsse-nio-7443-exec-4] com.esri.commons.web.rest.resources.BaseResource.buildErrorResponse Unable to import certificate com.esri.commons.web.rest.HttpException: Unable to import certificate at com.esri.commons.web.rest.resources.BaseResource.buildErrorResponse(BaseResource.java:236) at com.esri.arcgis.portal.admin.rest.security.SSLResource.importExistingServerCert(SSLResource.java:487) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) at com.sun.jersey.spi.container.servlet.ServletContainer.doFilter(ServletContainer.java:910) at com.sun.jersey.spi.container.servlet.ServletContainer.doFilter(ServletContainer.java:858) at com.sun.jersey.spi.container.servlet.ServletContainer.doFilter(ServletContainer.java:812) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.esri.commons.web.AppFilter.doFilter(AppFilter.java:274) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.esri.arcgis.portal.admin.rest.filters.AdminFilter.doFilter(AdminFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at com.esri.arcgis.portal.util.TomcatValve.invoke(TomcatValve.java:43) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Unknown Source) Caused by: java.lang.Exception: Unable to import certificate at com.esri.arcgis.portal.admin.core.security.SSLManager.importKeyStore(SSLManager.java:277) at com.esri.arcgis.portal.admin.core.security.SSLManager.importExistingServerCertificate(SSLManager.java:258) at com.esri.arcgis.portal.admin.rest.security.SSLResource.importExistingServerCert(SSLResource.java:479) ... 50 more Caused by: java.lang.Exception: Unable to import existing certificate. at com.esri.arcgis.portal.util.KeyTool.importKeyStore(KeyTool.java:633) at com.esri.arcgis.portal.admin.core.security.SSLManager.importKeyStore(SSLManager.java:273) ... 52 more Caused by: java.lang.Exception: No certificates found. at com.esri.arcgis.portal.util.KeyTool.importKeyStore(KeyTool.java:618) ... 53 more     ... View more

Also check your source data account if connecting to sde, and if oracle and 10.2 crashes, but 10.3+ works, it may be because you never added select_catalog_role to your sde user accounts. Additional tricks: export all layers using a newer version using this python and try dragging them into a new mxd file to see which layer is bad. import arcpy mxd = arcpy.mapping.MapDocument("CURRENT") for lyr in arcpy.mapping.ListLayers(mxd):    lyr.saveACopy("layers\"+lyr.name+".lyr","10.1") Or, disconnect network cord, and open your mxd, then when all layers have dead connections, fix their sources to corrected sde account and layer. ... View more

We were getting same error when trying to re-register a machine with site after it went bad, and had been rebuilt.  We got the JSONObject error "'A JSONObject text must begin with '{' at character 0 of '".  The machine was not listed in the admin endpoint for the live main site, but it still had files left over in the config-store\machines folder.  Once I removed those files, the site was able to register with the server once again. Thanks for the fix! ... View more

Addendum... so, I had to do it for ArcGIS 10.3.1... and encountered issue after issue, and could not decipher the problem, until I tried a java app called sslpoke which makes sure your root certificates are set up right and you can get to the target host given... and I learned that ArcGIS 10.3.1 runs on java 1.7.0_76, found in <install folder>\ArcGIS\server\framework\runtime\jre, which does not support TLSv1.1 or TLSv1.2.  It only supports TLSv1.  This is obsolete, and not allowed to connect to newer ldap versions, or other server types, so it causes a big problem if your it department decides to upgrade the LDAP servers to disallow TLSv1, which honestly, they should really do.  So, what's the fix?  You need to go find at LEAST java se 1.7.0_131, which is the first one to include TLS1.1 / 1.2 support, which requires an oracle support contract to download.  Trust me that this is the first one that works, I tested connecting to LDAP with every 1.7.0_X version out there that is lower than 1.7.0_131.  Anything higher than 1.7.0_131 should work also, I tested for TLS1.2 sslpoke success up to the current developer-only build 1.7.0_241 from the oracle patching support site, but I didn't try placing them into the ArcGIS folder yet, so back up your config_store. Once you have that, you can save your cacerts file, or just reimport your root certs to it, then stop arcgis server, and replace the server's jre folder under <install root>\ArcGIS\server\framework\runtime\jre folder with the 1.7.0_131 (or higher) jre folder you obtained. Make sure you add your root certificates back into the new jre\lib\security\cacerts file as detailed above in original post. One thing I haven't checked, but might be a nice side effect, tls1.2 ArcGIS online connectivity.  Maybe someone can advise if this resolves that. This may also work for ArcGIS Portal 10.3.1, but I haven't tried it yet. ... View more