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

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

MichaelNigbor1 — Wed, 02 Sep 2020 17:20:45 GMT

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?

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

MikeMillerGIS — Wed, 02 Sep 2020 17:27:20 GMT

Could you post screen shots errors and warnings. I believe we have resolved the future warning, but I want to make sure. Also, if you look in the AP_Workspace folder that is in the same location as the asset package, open the gp log file and post the last few calls, we can see if it finished. On Enterprise, you will have to register as version and enable topology yourself, so your 12.2 may have completed successfully.

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

MichaelNigbor1 — Wed, 02 Sep 2020 17:44:03 GMT

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.

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

MichaelNigbor1 — Wed, 02 Sep 2020 17:46:56 GMT

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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde\\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\\updm@updm.sde')
# result time: 0:00:00.010000
# actual time: 0:00:00.122341

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

MikeMillerGIS — Wed, 02 Sep 2020 17:53:24 GMT

That future warning is resolved in a new build of the untools. Reinstalling them will resolve that. The log file looks good. I feel is applied correctly.

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

MichaelNigbor1 — Wed, 02 Sep 2020 18:01:45 GMT

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?

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

MikeMillerGIS — Wed, 02 Sep 2020 18:17:25 GMT

Issues with 12.1. We have traced the issue to the sequences. We have database sequences greater than 32 characters, each sequence is a table in the target database. With 12.1, the max table name length is 31 characters. With 12.2, it was increased, details here:

ORACLE-BASE - Long Identifiers in Oracle Database 12c Release 2 (12.2)

To get the new build, you actually have to uninstall the untools and reinstall it. We only incremented the build of untools as there was no code change, just a requirement for a version of pandas.

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

MichaelNigbor1 — Wed, 02 Sep 2020 20:25:05 GMT

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.

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

MichaelNigbor1 — Thu, 03 Sep 2020 16:29:37 GMT

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)

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

MichaelNigbor1 — Thu, 03 Sep 2020 20:42:27 GMT

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.