Latest Contributions by MichaelNigbor1

‎11-13-2020

For me, this was the correct answer.

‎09-22-2020

That was the trick! I used the feature service, instead of the map service. Now my Event Editor is working. Is there any way you can bold the "map service" or add a caution note on the Authoring a web map for Event Viewer page? Whenever there is editing, I automatically assume feature services should be used. Using the map service for an editing application seems counter-intuitive. Thanks Ayan Palit for the quick and accurate answer.

‎09-22-2020

I recycled the application pool, which should clear the cache and reload the web application and will do this whenever I make a change to config.json going forward. Unfortunately, that didn't change anything. I'm still getting the same error. Does the Event Editor write a log file anywhere? If so, maybe it will hold some clues I appreciate the quick response. Thanks.

‎09-22-2020

Do you need to restart the Event Editor when you make changes to config.json?

‎09-22-2020

Confirmed. It's enabled.

‎09-22-2020

I'm unable to build a working Event Editor application. After logging in, I'm getting the following error: I'm attempting to follow the sparse and possibly outdated instructions here. Clearly, I've missed something important in the configuration and I'm looking for ideas. The error seems to be saying that the app was unable to find an LRS network to work with. I've confirmed that the service it's configured to use has an LRS network that I can manipulate with ArcGIS Pro. I've created and published a map that includes the LRS Engineering Network along with it's related features, including Redline. I confirmed that M and Z are disabled in the Redline. Feature editing is enabled. Fortunately, the server I'm using had a pre-installed Event Editor application because I was unable to find the download using the instructions Event Editor Deployment Guide. I could not find an Event Editor listed in My Organization -> Downloads. I'm attaching the config.json file. Here's how I filled in the values mentioned in the config guide: webmap: Set to the ID of the map web map created and published for event editing, obtained from the Portal portalAppID: Set the the ID for the Event Server application registered with the Portal portalURL: Set to the ArcGIS portal on the same server geometryServiceUrl: Set to a local geometry server allowReconcileAndPost: true allowChangeVersions: true allowCreateVersions: true allowDeleteVersions: true The login works file, which I think means the portalAppID and portalURL are OK. I think the issue must be with the services in the published webmap. I've checked repeatedly, the map has an LRS network: I'm attaching the config.json file, in case someone can see the mistake.

‎09-17-2020

I'm working with the ESRI-supplied Naperville data, so I don't have actual survey data. To simulate this, I manually From and To values based the feature's calculated length. Now, I'm able to create routes. Marking as correct answer. Thanks.

‎09-15-2020

I'm attempting to build a UPDM utility network with APR using the Gas and Pipeline Enterprise Management Solution. I've completed the solution's task list, which included enabling APR and creating an engineering network. When I open maps, I can see the Location Referencing tab, which seems like a good sign. Engineering Network feature class is empty, which I presume is normal at this stage. I want to create new a route and line. I've created a map in ArcGIS Pro that includes the published feature services and the Engineering Network. After clicking on the "Create Route" button in the Location Referencing ribbon, I selected a single pipeline line object (a Transmission Pipe segment) which I want to be my first route. I entered a start date, assigned line and route names then pressed the Run button. Instead of a route, I got an error that says: "Chosen centerlines do not contain From or To Measures." as shown in this screenshot I checked, the Pipeline Line feature class has From and To Measure fields defined, as shown below: There isn't any data in these fields, they'll all null at the moment. I searched GeoNet and Google, but came up empty. What is this message trying to say? How do I fix this? Any help would be appreciated.

‎09-03-2020

With some wonderful help from ESRI support, I've got Apply Asset Package working on Oracle 12.2.0.1 and can answer my own question: Yes, it works but only on 12.2 or greater. A known issue with "Apply Asset Package" means Oracle 12.1 can't be used to host Gas and Pipeline Enterprise Data Management network at this time. Oracle 12.2 and up support object names longer than 30 characters, which is needed by the package. If "Apply Asset Package" fails, it can be tricky to figure out what went wrong. In my case, problems getting it to work in 12.2 were due to an Oracle spatial index that was not in a "VALID" state. This prevented the Append function from adding data to the PipelineDevice feature class. My best guess as to why the index wasn't valid is that the it was still under construction when the Append function started running (A race condition, of sorts). Changing the number of processes (in the Environment tab) to 1 seems to have forced steps to run in series and fixed the problem. TIP: If you want to know what exactly is going on with anything in untools, do this before running the tool: Open a Python window Run these two lines of code: import untools untools.logger.setLevel('DEBUG') Then run the tool. This will add lots of valuable information to the Messages section of the output.

‎09-03-2020

After updating untools, I re-ran Apply Asset Package with debugging on. I checked the Load Data and Calculate Spatial Index checkboxes. The run failed in Append (18/26). It processed PipelineJunction but failed in PipelineDevice. This time there was an underlying Oracle error: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE Here is the bottom of the Messages log (let me know if you want the whole thing): 2020-09-03 10:15:17 Append (18/26) 2020-09-03 10:15:17 Starting 3 processes for Append 2020-09-03 10:16:02 Starting PipelineJunction... 2020-09-03 10:16:02 Finished PipelineJunction (0:00:37)... 2020-09-03 10:16:08 Starting PipelineDevice... 2020-09-03 10:16:08 Start Time: Thursday, September 3, 2020 10:15:28 AM ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds. Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Column index not found Underlying DBMS error [ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE] [UPDM.PipelineDevice] Failed to execute (Append). Failed at Thursday, September 3, 2020 10:15:57 AM (Elapsed Time: 29.86 seconds) 2020-09-03 10:16:11 Starting PipelineLine... 2020-09-03 10:16:11 Finished PipelineLine (0:00:46)... 2020-09-03 10:16:11 Cleaning up workspace locks... Failed to execute (AssetPackageToUtilityNetwork). Failed at Thursday, September 3, 2020 10:16:11 AM (Elapsed Time: 42 minutes 37 seconds)

‎09-02-2020

This is helpful. I'm going to update untools and repeat the experiment on Oracle 12.2 with fresh schemas. I'll update the post when I know more.

‎09-02-2020

I'm running untools 2.6.0 and it doesn't show in the "Update Packages" list. Doesn't that mean I already have latest?

‎09-02-2020

Here is the end of the last run I made on 12.2. It seems to be cleaning up, but the usual Success message is missing. # Started: 2020-09-01 16:37:31.700183 arcpy.un.SetSubnetworkDefinition(in_utility_network='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\NapervilleGas', domain_network='Pipeline', tier_name='Isolation', support_disjoint_subnetwork=True, valid_devices=['Excess Flow Valve/Unknown', 'Excess Flow Valve/Automatic Reset', 'Excess Flow Valve/Manual Reset', 'Meter/Unknown', 'Meter/Custody Transfer', 'Meter/Customer', 'Meter/Utility', 'Pressure Monitoring Device/Unknown', 'Pressure Monitoring Device/Pressure Monitoring Device', 'Lamp/Unknown', 'Lamp/Lamp', 'Compressor/Unknown', 'Compressor/Electric Motor', 'Compressor/Reciprocating Engine', 'Compressor/Turbine', 'Wellhead Source Flange/Unknown', 'Wellhead Source Flange/Flange', 'Controllable Tee/Unknown', 'Controllable Tee/Controllable Tee', 'Controllable Valve/Unknown', 'Controllable Valve/Bypass', 'Controllable Valve/System', 'Controllable Valve/Emergency', 'Controllable Valve/Meter', 'Regulator/Unknown', 'Regulator/Regulator', 'Regulator/Customer Regulator', 'Scrubber/Unknown', 'Scrubber/Scrubber', 'Pump/Unknown', 'Pump/Booster', 'Pump/Primary', 'Relief Valve/Unknown', 'Relief Valve/Blow Off', 'Short Stop/Unknown', 'Short Stop/Short Stop', 'Strainer/Unknown', 'Strainer/Strainer', 'Flow Valve/Unknown', 'Flow Valve/Check', 'Flow Valve/Slam-shut', 'Anode/Unknown', 'Anode/ICCP', 'Anode/Galvanic', 'Rectifier/Unknown', 'Rectifier/Rectifier', 'Test Point/Unknown', 'Test Point/Above Ground', 'Test Point/Buried', 'Test Point/On Post', 'Test Point/Pipeline Marker', 'Test Point/Service Line'], valid_subnetwork_controller=['Controllable Valve/Emergency'], valid_lines=['Service Pipe/Unknown', 'Service Pipe/Bare Steel', 'Service Pipe/Cast Iron', 'Service Pipe/Coated Steel', 'Service Pipe/Composite', 'Service Pipe/Copper', 'Service Pipe/Ductile Iron', 'Service Pipe/Plastic ABS', 'Service Pipe/Plastic Other', 'Service Pipe/Plastic PE', 'Service Pipe/Plastic PVC', 'Service Pipe/Reconditioned Cast Iron', 'Service Pipe/Wrought Iron', 'Distribution Pipe/Unknown', 'Distribution Pipe/Bare Steel', 'Distribution Pipe/Cast Iron', 'Distribution Pipe/Coated Steel', 'Distribution Pipe/Composite', 'Distribution Pipe/Copper', 'Distribution Pipe/Ductile Iron', 'Distribution Pipe/Plastic ABS', 'Distribution Pipe/Plastic Other', 'Distribution Pipe/Plastic PE', 'Distribution Pipe/Plastic PVC', 'Distribution Pipe/Reconditioned Cast Iron', 'Distribution Pipe/Wrought Iron', 'Transmission Pipe/Unknown', 'Transmission Pipe/Bare Steel', 'Transmission Pipe/Cast Iron', 'Transmission Pipe/Coated Steel', 'Transmission Pipe/Composite', 'Transmission Pipe/Ductile Iron', 'Transmission Pipe/Reconditioned Cast Iron', 'Transmission Pipe/Wrought Iron', 'Gathering Pipe/Unknown', 'Gathering Pipe/Bare Steel', 'Gathering Pipe/Cast Iron', 'Gathering Pipe/Coated Steel', 'Gathering Pipe/Composite', 'Gathering Pipe/Ductile Iron', 'Gathering Pipe/Plastic ABS', 'Gathering Pipe/Plastic Other', 'Gathering Pipe/Plastic PE', 'Gathering Pipe/Plastic PVC', 'Gathering Pipe/Reconditioned Cast Iron', 'Gathering Pipe/Wrought Iron', 'Station Pipe/Unknown', 'Station Pipe/Bare Steel', 'Station Pipe/Cast Iron', 'Station Pipe/Coated Steel', 'Station Pipe/Composite', 'Station Pipe/Ductile Iron', 'Station Pipe/Reconditioned Cast Iron', 'Station Pipe/Wrought Iron', 'Customer Pipe/Unknown', 'Customer Pipe/Bare Steel', 'Customer Pipe/Cast Iron', 'Customer Pipe/Coated Steel', 'Customer Pipe/Composite', 'Customer Pipe/Ductile Iron', 'Customer Pipe/Plastic ABS', 'Customer Pipe/Plastic Other', 'Customer Pipe/Plastic PE', 'Customer Pipe/Plastic PVC', 'Customer Pipe/Reconditioned Cast Iron', 'Customer Pipe/Wrought Iron', 'Riser Pipe/Unknown', 'Riser Pipe/Bare Steel', 'Riser Pipe/Cast Iron', 'Riser Pipe/Coated Steel', 'Riser Pipe/Composite', 'Riser Pipe/Ductile Iron', 'Riser Pipe/Reconditioned Cast Iron', 'Riser Pipe/Wrought Iron', 'Pressure Sensor Pipe/Unknown', 'Pressure Sensor Pipe/Bare Steel', 'Pressure Sensor Pipe/Cast Iron', 'Pressure Sensor Pipe/Coated Steel', 'Pressure Sensor Pipe/Ductile Iron', 'Pressure Sensor Pipe/Wrought Iron', 'Test Lead Wire/Unknown', 'Test Lead Wire/Aqua', 'Test Lead Wire/Blue', 'Test Lead Wire/Forest', 'Test Lead Wire/Green', 'Test Lead Wire/Lavender', 'Test Lead Wire/Orange', 'Test Lead Wire/Pink', 'Test Lead Wire/Red', 'Test Lead Wire/Yellow', 'Test Lead Wire/Purple', 'Bonding Line/Unknown', 'Bonding Line/Wire', 'Bonding Line/Strap', 'Rectifier Cable/Unknown', 'Rectifier Cable/Rectifier Cable'], aggregated_line=['Distribution Pipe/Bare Steel', 'Distribution Pipe/Cast Iron', 'Distribution Pipe/Coated Steel', 'Distribution Pipe/Composite', 'Distribution Pipe/Copper', 'Distribution Pipe/Ductile Iron', 'Distribution Pipe/Plastic ABS', 'Distribution Pipe/Plastic Other', 'Distribution Pipe/Plastic PE', 'Distribution Pipe/Plastic PVC', 'Distribution Pipe/Reconditioned Cast Iron', 'Distribution Pipe/Wrought Iron'], diagram_template=None, summaries="ADD 'Measured Length' # # # # totalmeasurelength;ADD 'P:Pipe Surface Area' # # # # totalsurfacearea;ADD 'P:Pipe Volume' # # # # totalpipevolume;ADD 'Shape length' # # # # totallength;COUNT 'Device Asset Group' 'Device Asset Group' IS_EQUAL_TO SPECIFIC_VALUE 2 numbermeters;COUNT 'Device Asset Group' 'Device Asset Group' IS_EQUAL_TO SPECIFIC_VALUE 3 numbervalves;MIN 'P:MAOP Design' # # # # maopdesign;MIN 'P:MAOP Record' # # # # maoprecord;MIN 'P:MAOP Test' # # # # maoptest", condition_barriers=[['P:Device Status', 'IS_EQUAL_TO', 'SPECIFIC_VALUE', '0', 'OR'], ['Lifecycle Status', 'DOES_NOT_INCLUDE_ANY', 'SPECIFIC_VALUE', '24', 'OR'], ['Category', 'IS_EQUAL_TO', 'SPECIFIC_VALUE', 'CP Only', 'AND']], function_barriers=None, include_barriers=True, traversability_scope='BOTH_JUNCTIONS_AND_EDGES', propagators=None, update_structure_features=True, update_container_features=True, edit_mode_for_default_version='WITHOUT_EVENTING', edit_mode_for_named_version='WITHOUT_EVENTING', valid_junctions=['Coupling/Unknown', 'Coupling/Metal Coupling', 'Coupling/Plastic Coupling', 'Elbow/Unknown', 'Elbow/Metal Elbow', 'Elbow/Plastic Elbow', 'End Cap/Unknown', 'End Cap/Metal End Cap', 'End Cap/Plastic End Cap', 'Expansion Joint/Unknown', 'Expansion Joint/Expansion Joint', 'Flange/Unknown', 'Flange/Metal Flange', 'Reducer/Unknown', 'Reducer/Metal Reducer', 'Reducer/Plastic Reducer', 'Tee/Unknown', 'Tee/Metal 3-Way', 'Tee/Metal 4-Way', 'Tee/Plastic 3-Way', 'Tee/Plastic 4-Way', 'Transition/Unknown', 'Transition/Transition', 'Weld/Unknown', 'Weld/Weld', 'Screw/Unknown', 'Screw/Screw', 'Electro Stop/Unknown', 'Electro Stop/Electro Stop', 'Plastic Fusion/Unknown', 'Plastic Fusion/Plastic Fusion', 'Saddle/Unknown', 'Saddle/Metal Saddle', 'Saddle/Plastic Saddle', 'Tank/Unknown', 'Tank/Tank', 'Line Heater/Unknown', 'Line Heater/Line Heater', 'Cooling System/Unknown', 'Cooling System/Cooling System', 'Odorizer/Unknown', 'Odorizer/Absorption Bypass', 'Odorizer/Injection Pump', 'Odorizer/Pulse', 'Odorizer/Rural Tap Odorizer', 'Odorizer/Wick', 'Coupon/Unknown', 'Coupon/Coupon', 'Dehydration Equipment/Unknown', 'Dehydration Equipment/Glycol Dehydration', 'Dehydration Equipment/Methanol Dehydration', 'Dehydration Equipment/Solid Absorption', 'Drip/Unknown', 'Drip/Drip', 'Connection Point/Unknown', 'Connection Point/Connection Point', 'Union/Unknown', 'Union/Metal Union', 'Plug/Unknown', 'Plug/Test Plug', 'Wire Junction/Unknown', 'Wire Junction/Bond Junction', 'Wire Junction/Test Lead', 'Insulation Junction/Unknown', 'Insulation Junction/Flange Insert', 'Pipe Bend/Unknown', 'Pipe Bend/Pipe Bend'], valid_junction_objects=[], valid_junction_object_subnetwork_controller=[], valid_edge_objects=[]) # result time: 0:00:09.360000 # actual time: 0:00:21.028616 # Started: 2020-09-01 16:37:52.730422 arcpy.un.ImportRules(in_utility_network='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\NapervilleGas', rule_type='ALL', csv_file='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\Databases\\AP_workspace\\csv\\Rules.csv') # result time: 0:00:23.210000 # actual time: 0:00:35.024711 # Started: 2020-09-01 16:38:27.776279 arcpy.management.DisableEditorTracking(in_dataset='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\PipelineDevice', creator=True, creation_date=True, last_editor=True, last_edit_date=True) # result time: 0:00:13.170000 # actual time: 0:00:23.514027 # Started: 2020-09-01 16:38:51.291021 arcpy.management.DisableEditorTracking(in_dataset='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\PipelineLine', creator=True, creation_date=True, last_editor=True, last_edit_date=True) # result time: 0:00:12.930000 # actual time: 0:00:23.410266 # Started: 2020-09-01 16:39:14.701941 arcpy.management.DisableEditorTracking(in_dataset='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\PipelineJunction', creator=True, creation_date=True, last_editor=True, last_edit_date=True) # result time: 0:00:12.530000 # actual time: 0:00:22.750298 # Started: 2020-09-01 16:39:37.452092 arcpy.management.DisableEditorTracking(in_dataset='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\PipelineAssembly', creator=True, creation_date=True, last_editor=True, last_edit_date=True) # result time: 0:00:11.800000 # actual time: 0:00:21.908772 # Started: 2020-09-01 16:39:59.361709 arcpy.management.DisableEditorTracking(in_dataset='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\StructureJunction', creator=True, creation_date=True, last_editor=True, last_edit_date=True) # result time: 0:00:11.670000 # actual time: 0:00:21.778992 # Started: 2020-09-01 16:41:51.322326 arcpy.un.ImportAssociations(in_utility_network='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\NapervilleGas', association_type='ALL', csv_file='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\Databases\\AP_workspace\\csv\\Associations.csv') # result time: 0:00:10.020000 # actual time: 0:00:20.714754 # Started: 2020-09-01 16:42:12.038170 arcpy.un.ImportSubnetworkControllers(in_utility_network='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\NapervilleGas', csv_file='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\Databases\\AP_workspace\\csv\\Subnetwork_Controllers.csv') # result time: 0:00:02.730000 # actual time: 0:00:13.902588 # Started: 2020-09-01 16:42:25.943359 arcpy.management.EnableEditorTracking(in_dataset='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\PipelineDevice', creator_field='CREATOR', creation_date_field='CREATIONDATE', last_editor_field='UPDATEDBY', last_edit_date_field='LASTUPDATE', add_fields=True, record_dates_in='UTC') # result time: 0:00:24.350000 # actual time: 0:00:36.847809 # Started: 2020-09-01 16:43:02.791034 arcpy.management.EnableEditorTracking(in_dataset='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\PipelineLine', creator_field='CREATOR', creation_date_field='CREATIONDATE', last_editor_field='UPDATEDBY', last_edit_date_field='LASTUPDATE', add_fields=True, record_dates_in='UTC') # result time: 0:00:24.260000 # actual time: 0:00:34.357583 # Started: 2020-09-01 16:43:37.149755 arcpy.management.EnableEditorTracking(in_dataset='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\PipelineJunction', creator_field='CREATOR', creation_date_field='CREATIONDATE', last_editor_field='UPDATEDBY', last_edit_date_field='LASTUPDATE', add_fields=True, record_dates_in='UTC') # result time: 0:00:24.360000 # actual time: 0:00:34.617830 # Started: 2020-09-01 16:44:11.768063 arcpy.management.EnableEditorTracking(in_dataset='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\PipelineAssembly', creator_field='CREATOR', creation_date_field='CREATIONDATE', last_editor_field='UPDATEDBY', last_edit_date_field='LASTUPDATE', add_fields=True, record_dates_in='UTC') # result time: 0:00:23.070000 # actual time: 0:00:33.347018 # Started: 2020-09-01 16:44:45.115555 arcpy.management.EnableEditorTracking(in_dataset='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\StructureJunction', creator_field='CREATOR', creation_date_field='CREATIONDATE', last_editor_field='UPDATEDBY', last_edit_date_field='LASTUPDATE', add_fields=True, record_dates_in='UTC') # result time: 0:00:22.990000 # actual time: 0:00:33.344393 # Started: 2020-09-01 16:45:18.460668 arcpy.gp.UpdateSchema('C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\PipelineAssembly', 'C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\Databases\\AP_workspace\\xml\\PipelineAssembly2.xml') # result time: 0:00:11.390000 # actual time: 0:00:22.241803 # Started: 2020-09-01 16:45:40.703083 arcpy.gp.UpdateSchema('C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\PipelineDevice', 'C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\Databases\\AP_workspace\\xml\\PipelineDevice2.xml') # result time: 0:00:12.440000 # actual time: 0:00:23.578871 # Started: 2020-09-01 16:46:04.281986 arcpy.gp.UpdateSchema('C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\PipelineJunction', 'C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\Databases\\AP_workspace\\xml\\PipelineJunction2.xml') # result time: 0:00:12.570000 # actual time: 0:00:23.559350 # Started: 2020-09-01 16:46:27.842293 arcpy.gp.UpdateSchema('C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\PipelineLine', 'C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\Databases\\AP_workspace\\xml\\PipelineLine2.xml') # result time: 0:00:13.050000 # actual time: 0:00:23.916383 # Started: 2020-09-01 16:46:51.759260 arcpy.gp.UpdateSchema('C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]\\UtilityNetwork\\StructureJunction', 'C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\Databases\\AP_workspace\\xml\\StructureJunction2.xml') # result time: 0:00:11.400000 # actual time: 0:00:22.314851 # Started: 2020-09-01 16:47:14.074709 arcpy.management.Delete(in_data='ESRI_apply_asset_package_ESRI', data_type=None) # result time: 0:00:00.030000 # actual time: 0:00:08.131752 # Started: 2020-09-01 16:47:22.206755 arcpy.management.ClearWorkspaceCache(in_data='C:\\Users\\serveradmin\\Documents\\ArcGIS\\Projects\\Gas and Pipeline Enterprise Data Management\\[email protected]') # result time: 0:00:00.010000 # actual time: 0:00:00.122341

‎09-02-2020

Here is a screenshot from Apply Asset Package to an Oracle 12.1 GDB. This has the FutureWarning in it. I'll post the end of log file next.

‎09-02-2020

For the past couple of weeks, I have been trying, without success, to get the recently-released Gas and Pipeline Enterprise Data Management solution to work with in either Oracle 12.1 or 12.2. The "Apply Asset Package" tool seems to be the problem. From the debug logs, I've learned: In 12.1, it fails in CreateDatabaseSequence, returning an ERROR: 999999, which says to contact ESRI. An underlying ORA-29855 (object identifier too long) is also reported. It also returns a Python FutureWarning, which I think is a red herring. (It's about use of obsolete syntax that won't work in a future version of Python) In 12.2, the process runs a lot longer (maybe even nearly completes), but eventually reports failure. The error message section has only the same Python FutureWarning encountered in 12.1. I doubt the warning killed the process, but because there are no errors returned, I don't know what did. In the 12.2 geodatabase, the Utility Network was successfully created but in an incomplete state. Data appears to have been loaded. Versioning is not turned on and, as a result, everything in the UN is marked "Dirty." Attempting to manually fix this by enabling versioning scares me because I don't know what else the tool may have failed to do. I have a case open with ESRI, but thought I'd ask the broader community: Has anyone managed to get this working in Oracle 12? If so, how did you get it working?

Online Status	Offline
Date Last Visited	‎11-10-2021 04:33 PM

My Ideas

Latest Contributions by MichaelNigbor1

Re: 000582 : Error while adding Global IDs

Re: Event Editor: No linear referencing service error

Re: Event Editor: No linear referencing service error

Re: Event Editor: No linear referencing service error

Re: Event Editor: No linear referencing service error

Event Editor: No linear referencing service error

Re: Create Route - Chosen centerlines do not contain From or To Measures

Create Route - Chosen centerlines do not contain From or To Measures

Re: Does Gas and Pipeline Enterprise Data Management solution work in Oracle 12.x?

Re: Does Gas and Pipeline Enterprise Data Management solution work in Oracle 12.x?

Re: Does Gas and Pipeline Enterprise Data Management solution work in Oracle 12.x?

Re: Does Gas and Pipeline Enterprise Data Management solution work in Oracle 12.x?

Re: Does Gas and Pipeline Enterprise Data Management solution work in Oracle 12.x?

Re: Does Gas and Pipeline Enterprise Data Management solution work in Oracle 12.x?

Does Gas and Pipeline Enterprise Data Management solution work in Oracle 12.x?