Latest Contributions by JasonTipton

I'm needing to create an Oracle Read Only User in a 10.2 Oracle GDB. I'm reading the documentation for Adding Users To Oracle​. I see that a user must be able to create the Log File tables​. About 1/4 the way down the Log file documentation (under heading "Permissions required for shared log files"), the help suggests that you do the following to create a read-only user: Create "Read Only" User Grant more than just read only Need Create Table, Create Session, Create Sequence, Insert/Update/Delete Have read-only user "make a selection that exceeds the selection threshold" (100 records) The log tables/sequences are created Revoke the extra permissions Create Table, Create Sequence This might be a fine way to "let ArcMap do what it needs to do" and then take back control, but in a large company with source control, change management and DBA environment promotion, my DBA's aren't going to like this approach. They would much rather do everything in a more precise, scriptable (documented) method. This process seems to create 2 tables, 4 indexes, and 1 sequence. Can I not just copy the DDL from these objects in DEV to give to my DBA's to push up to production? This seems to work. If so, I'm not sure why this isn't documented. The new steps would be: Create Read Only User Need to be able to INSERT/UPDATE/DELETE tables in own schema. Need CREATE SESSION, of course Create DB Objects TABLES SDE_LOGFILE_DATA SDE_LOGFILES INDEXES SDE_LOGFILE_DATA_IDX1 SDE_LOGFILE_DATA_IDX2 SDE_LOGFILES_PK SDE_LOGFILES_UK SEQUENCES SDE_LOGFILE_LID_GEN <EDIT> Thanks to Vince Angelo​ Other alternatives to creating the logfile objects via SQL or having a user manually select 101+ features in Arcmap: arcpy.ConfigureGeodatabaseLogFileTables_management​ sdeping​ utility with the -L option New to 10.4 Create Database User​ now creates the log file tables when the tool is ran Haven't tested these methods.  All 3 methods would be scriptable/automated, but they are not as explicit as just creating the objects in SQL and still require the extra permissions to be added/revoked. Message was edited by: Jason Tipton Added some alternatives to SQL creation. Edited Again to add 10.4 update ... View more

I have Windows Services that need to run 24x7 (except for reboots). They use the arcpy package and a Floating License. I have run into issues with the service obtaining a license. For example, the license manager might be down. What I need is to try and import arcpy. If that fails, keep trying every x amount of seconds until it is successful. So, you would think something like this works: arcpy_imported = False while arcpy_imported is False:     try:         import arcpy         arcpy_imported = True     except Exception as ex:         print ex         time.sleep(2) But it does not. You can import arcpy all day long and if it fails the 1st time, it will fail infinitely. I tested this by disconnecting from the network, running "import arcpy" a few times, then connect back to the network and running "import arcpy" a few times. Traceback: import arcpy Traceback (most recent call last):   File "<stdin>", line 1, in <module>   File "C:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\__init__.py", line 21, in <module>     from arcpy.geoprocessing import gp   File "C:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\geoprocessing\__init__.py", line 14, in <module>     from _base import *   File "C:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\geoprocessing\_base.py", line 592, in <module>     env = GPEnvironments(gp)   File "C:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\geoprocessing\_base.py", line 589, in GPEnvironments     return GPEnvironment(geoprocessor)   File "C:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\geoprocessing\_base.py", line 545, in __init__     self._refresh()   File "C:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\geoprocessing\_base.py", line 547, in _refresh     envset = (set(env for env in self._gp.listEnvironments())) RuntimeError: NotInitialized It would never succeed with the same python session open. I could open a separate session, and successfully import arcpy, come back to the failing session, and it continues to fail. This means, that when the LM goes down for whatever reason, no amount of error handling can keep my services running without manually restarting them. Well, OK, I could write something to monitor these services and automatically restart them when this problem arises, but I would rather handle it within the actual service. Any ideas? ... View more