|
POST
|
As is is already state in the post: "In the script above, the line 1 is just a wrapper to the arcpy function to create a sde connection file. " but for the sake of clarity, the implementation of the method is: def create_connectionfile(self, logger, out_folder_path, out_name, instance, account_authentication=None, username=None, password=None, save_user_pass=None,
database=None, schema=None, version_type=None, version=None, date=None):
try:
conn_file = "{0}.sde".format(os.path.join(out_folder_path, out_name))
logger.add("Starting process to create connectionfile {0}".format(conn_file))
if os.path.exists(conn_file):
os.remove(conn_file)
logger.add("Existing connectionfile {0} is removed".format(conn_file))
arcpy.CreateDatabaseConnection_management(out_folder_path=out_folder_path,
out_name=out_name,
database_platform="SQL_Server",
instance=instance,
account_authentication=account_authentication,
username=username,
password=password,
save_user_pass=save_user_pass,
database=database,
schema=schema,
version_type=version_type,
version=version,
date=date)
logger.add("Connection file {0} is created".format(conn_file))
return conn_file
except Exception as e:
logger.add("Create_connection file has failed: {0}".format(e), "ERROR")
... View more
06-01-2022
11:09 PM
|
0
|
0
|
1816
|
|
POST
|
I have several scripts that are run against a geodatabase, each script creates a sde file with the credentials, then proceeds to read a value from a table using a search cursor database = gp.create_connectionfile(log, base_dir, user_do, instance_sde, "DATABASE_AUTH",
username=user_do, password=password_do, save_user_pass="SAVE_USERNAME",
database=database_name)
arcpy.env.workspace = database
# Retrieve and strip current version
source_version = None
with arcpy.da.SearchCursor("{0}.RAC_ADD_IN".format(user_do), "VERSION") as cursor:
for row in cursor:
if row[0]:
source_version = StrictVersion(row[0].rsplit(".", 1)[0])
break When the set of scripts run, sometimes all scripts run without issue, sometimes one script fails, the issue is that the failing script is not always the same. the error presented is: ERROR cannot open 'DataOwner.RAC_ADD_IN'
ERROR ['Traceback (most recent call last):\n', ' File "C:\\01_Script.py", line 134, in <module>\n main(argv[1:])\n', ' File "C:\\01_Script.py", line 86, in main\n with arcpy.da.SearchCursor("{0}.RAC_ADD_IN".format(user_do), "VERSION") as cursor:\n', "RuntimeError: cannot open 'DataOwner.RAC_ADD_IN'\n"] Facts: The credential are always the same The table is always the same In the script above, the line 1 is just a wrapper to the arcpy function to create a sde connection file. This behavior has been appearing since ArcGIS Pro 2.8, currently this is running in 2.9.1 How this can be managed?
... View more
05-31-2022
11:56 PM
|
0
|
5
|
1885
|
|
POST
|
There is a Python script that make modifications to a Geodatabase (Creation of tables, domains, relationships, views). The amount of changes is quite substantial. In some point of the execution of the script, the process is stopped, and the window "ArcGIs Application has stopped working" appears. checking the dump file that is going to be attached to the report, I have found that there is an exception in sdemssqlsrvr.dll (Attached file) this is a bit of info from that file: ERROR_CODE: (NTSTATUS) 0xc0000005 - The instruction at 0x%p referenced memory at 0x%p. The memory could not be %s. EXCEPTION_CODE_STR: c0000005 EXCEPTION_PARAMETER1: 0000000000000000 EXCEPTION_PARAMETER2: 0000000000000138 STACK_TEXT: 00000076`fc7193b0 00007ff9`00b45d66 : 00000076`fc71ad10 00000076`fc719f20 00000076`fc7215f4 00000076`fc719820 : sdemssqlsrvr!DB_table_calculate_stats_by_logfile+0x1ba4 00000076`fc7193e0 00007ff9`00b5363a : 00000076`fc721570 00000076`fc71a302 00000076`fc721570 00007ff9`00000000 : sdemssqlsrvr!DB_raster_get_max_id+0x7dc6 00000076`fc719e20 00007ff9`013c5037 : 00000076`00000000 0000025a`f6730d60 00000076`00000000 00000000`00000001 : sdemssqlsrvr!DB_registered_column_metadata_alter+0xcaa 00000076`fc71f130 00007ff9`013a911b : 0000025a`fbd0c050 00000076`fc725710 00000076`fc724eb0 0000025a`fbd0c050 : gsrvrmssql!S_gsrvr_main+0x84a7 00000076`fc722540 00007ff9`0138a1f5 : 00000000`00000000 0000025a`fbd0c050 0000025a`fbd0c050 0000025a`fbd0c050 : gsrvrmssql+0x3911b 00000076`fc724e90 00007ff9`013c0a3a : 00007ff9`ad75f4e8 0000025a`fbd0c050 0000025a`f68fb040 0000025a`fbd0c050 : gsrvrmssql+0x1a1f5 00000076`fc725900 00007ff9`ad691bb2 : 0000025a`f6953430 0000025a`f6953430 00000000`00000000 00000000`00000000 : gsrvrmssql!S_gsrvr_main+0x3eaa 00000076`fc72f900 00007ff9`afc37034 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : ucrtbase!thread_start<unsigned int (__cdecl*)(void *),1>+0x42 00000076`fc72f930 00007ff9`aff42651 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : kernel32!BaseThreadInitThunk+0x14 00000076`fc72f960 00000000`00000000 : 00000000`00000000 00000000`00000000 00000000`00000000 00000000`00000000 : ntdll!RtlUserThreadStart+0x21 Walkaround: As the script has been created to idempotent, if I run the script again, it will check the state of modifications and continue in the broken point. (I am able to finish the objective running the script twice) In other computer, it happens, but I have to run the script three time to successfully end the script. EDIT 1: Reading more carefully the dump, I found this: EXCEPTION_RECORD: (.exr -1)
ExceptionAddress: 00007ff90f4101b4 (sdemssqlsrvr!DB_table_calculate_stats_by_logfile+0x0000000000001ba4)
ExceptionCode: c0000005 (Access violation)
ExceptionFlags: 00000000
NumberParameters: 2
Parameter[0]: 0000000000000000
Parameter[1]: 0000000000000138
Attempt to read from address 0000000000000138 something similar happend here: https://community.esri.com/t5/developers-questions/10-2-2-java-api-crash-in-sdeora11gsrvr102-dll/td-p/696142 Is there any way to surpass this behavior?
... View more
05-27-2022
05:06 AM
|
0
|
0
|
1382
|
|
POST
|
I understand that now your GP tool work....How, if the the implementation and the tool are the same, the syntax breaks that, moreover, when the errors shows, that something was executed, therefore it was not something related with python syntax.
... View more
05-27-2022
02:32 AM
|
0
|
1
|
2753
|
|
POST
|
It does not make sense, because the example in the same documentation states: # Process: Create the coded value domain
arcpy.CreateDomain_management("montgomery.gdb", domName, "Valid pipe materials", "TEXT", "CODED")
#Store all the domain values in a dictionary with the domain code as the "key" and the
#domain description as the "value" (domDict[code])
domDict = {"CI":"Cast iron", "DI": "Ductile iron", "PVC": "PVC", \
"ACP": "Asbestos concrete", "COP": "Copper"}
# Process: Add valid material types to the domain
#use a for loop to cycle through all the domain codes in the dictionary
for code in domDict:
arcpy.AddCodedValueToDomain_management(gdb, domName, code, domDict[code])
# Process: Constrain the material value of distribution mains
arcpy.AssignDomainToField_management(inFeatures, inField, domName) are those, two different syntaxes for the same implementation? or are two different implementations?
... View more
05-25-2022
06:45 AM
|
0
|
3
|
2766
|
|
BLOG
|
Hello!!!!! again..... I just download the version 2.1 of the Gas and Pipeline Referencing Utility Network Foundation. I started reviewing the Data dictionary and I want to be sure to have the latest, proper version of it. Inside the project downloaded there is a link to the data dictionary, I start checking and found this: Is this the latest version (of the data dictionary)? Also found this discrepancy between the included data dictionary, and the online version: I am trying to browse in the online version of the data dictionary, to me, the fact that not having the list sorted, make a little difficult to browse, and find objects (Yes, I know there is a "Search" option). Thanks a lot for your support.
... View more
12-03-2021
02:04 AM
|
0
|
0
|
10267
|
|
POST
|
After digging in the behavior of the computer, and with the latest error messages I think, the issue is related to the thread management implemented underneath by arcpy library. I split the script in several parts, and call every part from a new python process, in this way the number of threads does not exceed the allowed amount of threads. Example: python.exe script_part1.py
python.exe script_part2.py
python.exe script_part3.py
python.exe script_part4.py
... View more
10-19-2021
11:15 PM
|
0
|
0
|
2192
|
|
POST
|
UPDATE: After digging a little bit in the behavior of the memory in the computer while the script run, then I implemented the use of the garbage collector at the end of the functions, this does not remove the error. I decided to split the execution in several parts, each part called independently. The script is still failing, but now, the error is : CPLGetTLSList(): TlsAlloc() failed!
CPLGetTLSList(): TlsAlloc() failed!
CPLGetTLSList(): TlsAlloc() failed!
CPLGetTLSList(): TlsAlloc() failed!
CPLGetTLSList(): TlsAlloc() failed!
CPLGetTLSList(): TlsAlloc() failed!
CPLGetTLSList(): TlsAlloc() failed!
CPLGetTLSList(): TlsAlloc() failed!
CPLGetTLSList(): TlsAlloc() failed!
CPLGetTLSList(): TlsAlloc() failed!
CPLGetTLSList(): TlsAlloc() failed!
CPLGetTLSList(): TlsAlloc() failed!
According t this GDAL github page the error now is generated in that point, but the reason is still unknown.
... View more
10-13-2021
03:39 AM
|
0
|
0
|
2232
|
|
POST
|
Update: After making some changes in the code to introduce the python garbage collector, the erro is still present but now it is triggered by the call to: arcpy.AddCodedValueToDomain_management I noticed that the consumption of memory is a little bit less, but either way, the error is still present. Is there a way to manage the memory used by the arcpy library?
... View more
10-13-2021
12:04 AM
|
0
|
0
|
2238
|
|
POST
|
There is a Python script intended to create a UPDM geodatabase, it receives several parameters, among them, database admin user, database dataowner user, and their passwords. The script runs using the ArcGIS Pro 2.8 Python, it starts its process, creates the database, as well as connection files (.sde). In some point of the script, it has been created different structures: tables, relationships, domains, etc. but then it failswhile calling: arcpy.da.ListDomains(self.database) The error is quite weird (at least for me): ERROR 1: Can't load requested DLL: C:\ArcGISPro\bin\gdalplugins\gdal_MG4Lidar.dll
1114: A dynamic link library (DLL) initialization routine failed.
ERROR 1: Can't load requested DLL: C:\ArcGISPro\bin\gdalplugins\gdal_MG4Lidar.dll
1114: A dynamic link library (DLL) initialization routine failed.
ERROR 1: Can't load requested DLL: C:\ArcGISPro\bin\gdalplugins\gdal_MG4Lidar.dll
1114: A dynamic link library (DLL) initialization routine failed.
ERROR 1: Can't load requested DLL: C:\ArcGISPro\bin\gdalplugins\gdal_MG4Lidar.dll
1114: A dynamic link library (DLL) initialization routine failed.
ERROR 1: Can't load requested DLL: C:\ArcGISPro\bin\gdalplugins\gdal_MG4Lidar.dll
1114: A dynamic link library (DLL) initialization routine failed.
11:51.29.583441 ERROR C:\temp\Installation\Data\DataOwner.sde
11:51.29.589433 ERROR ['Traceback (most recent call last):\n', ' File ".\\Arcpy\\InstallDataModel.py", line 95, in main\n', ' File "C:\\temp\\Installation\\Arcpy\\Classes\\JSONGeoDataModelClass.py", line 598, in create_domains\n existing_domains = arcpy.da.ListDomains(self.database)\n', 'OSError: C:\\temp\\Installation\\Data\\DataOwner.sde\n'] Furthermore, the ArcGIS Pro Crash Window appear 4 times (probably one time for each crash in the request of the gdal_MG4Lidar.dll). In this point of the execution, this line has been called several times, the script has been using the sde connection file for several actions, inside the script there is no direct call to GDAL libraries (I assume it is an internal call from the ArcGIS Pro libraries/modules) and despite the message, I can verify the existence of the sde file and even use it in a new ArcGIS Pro instance. What could be the reason behind this error? There is a way to surpass it?
... View more
10-11-2021
03:19 AM
|
0
|
3
|
2283
|
|
BLOG
|
@JSchroeder thanks for the info, As I mentioned, my geodatabase does not have the UN enable. According to the data dictionary the PipelineDevice FC is required to store the information of Valves, therefore I would like to use it. "Last, if you wish to use the Utility Network Feature Classes like Pipeline Device or Pipeline Junction, there is a tool to update the Measure and Route ID on these features, which is documented here." This sounds good, the issue is, I do not have features/rows in that feature class (because the error already mentioned), therefore It can not update measure and/or routes ID. @TomDeWitte thanks a lot for your comment. I will contact you.
... View more
09-09-2021
10:14 PM
|
0
|
0
|
11965
|
|
BLOG
|
I try to understand the Data Model: I started using the "Gas and Pipeline Data Management for ArcGIS Enterprise", I made the deployment of the version 1.2 (it includes a UPDM deployment solution for the version 2020). Following the instructions provided in here I tried to prototype a single user environment with WGS 1984 as Geographical Coordinates Reference system. Then I enabled APR (no UN), and add some centerlines to the model, create the routes in the Engineering Network, then update the Continuous Network.....so far..so good. I wanted to upload some events to the PipelineDevice Feature Class. therefore, I added the feature class to the LRS, prepare a table with the data to upload (name, route, engm, route id, etc. except the geometry). I am using the Append Events tool, then I receive the error message: Append Events
=====================
Parameters
Input Event PipelineDevice_FeaturesToUploadEvents_CopyFeatures
Target Event PipelineDevice
Field Map ASSETGROUP "Asset group" true false true 4 Long 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,ASSETGROUP,-1,-1;ASSETTYPE "Asset type" true false true 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,ASSETTYPE,-1,-1;TERMINALCONFIGURATION "Terminal Path" true false true 128 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,TERMINALCONFIGURATION,0,128;adddetails "adddetails: Additional Details, Clockwise to Close" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,adddetails,-1,-1;devicestatus "Device Status" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,devicestatus,-1,-1;regulatorytype "Regulatory Type" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,regulatorytype,-1,-1;designtype "Type" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,designtype,-1,-1;accessible "Accessible" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,accessible,-1,-1;yesno "yesno: Drain Valve Indicator, Internal Meter, SCADA Indicator" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,yesno,-1,-1;turnstoclose "Turns to Close" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,turnstoclose,-1,-1;normalposition "Normal Position" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,normalposition,-1,-1;installdate "Install Date" true true false 8 Date 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,installdate,-1,-1;inservicedate "In-Service Date" true true false 8 Date 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,inservicedate,-1,-1;assetid "Asset ID" true true false 64 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,assetid,0,64;serialnumber "Serial Number" true true false 20 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,serialnumber,0,20;ownedby "Owned By" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,ownedby,-1,-1;maintby "Maintained By" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,maintby,-1,-1;lifecyclestatus "Lifecycle Status" true false false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,lifecyclestatus,-1,-1;maopdesign "MAOP Design" true false false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,maopdesign,-1,-1;maoptest "MAOP Test" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,maoptest,-1,-1;maoprecord "MAOP Record" true false false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,maoprecord,-1,-1;depth "Depth" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,depth,-1,-1;depthtonut "Depth to Nut" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,depthtonut,-1,-1;measuredlength "Length" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,measuredlength,-1,-1;diameter "Diameter" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,diameter,-1,-1;maxinletpressure "Max Inlet Pressure" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,maxinletpressure,-1,-1;maxoutletpressure "Max Outlet Pressure" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,maxoutletpressure,-1,-1;setpressureentered "Set Pressure Entered" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,setpressureentered,-1,-1;setpressurestandard "Set Pressure Standard" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,setpressurestandard,-1,-1;symbolrotation "Symbol Rotation" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,symbolrotation,-1,-1;barcode "Barcode" true true false 16 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,barcode,0,16;manufacturer "Manufacturer" true true false 2 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,manufacturer,0,2;manufacturerlotno "Manufacturer Lot #" true true false 4 Long 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,manufacturerlotno,-1,-1;manufacturedate "Manufacture Date" true true false 8 Date 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,manufacturedate,-1,-1;manufacturecomponent "Manufacture Component" true true false 2 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,manufacturecomponent,0,2;material "Material" true true false 2 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,material,0,2;casingmaterial "Casing Material" true true false 20 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,casingmaterial,0,20;devicename "Name" true true false 20 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,devicename,0,20;quantity "Quantity" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,quantity,-1,-1;weight "Weight" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,weight,-1,-1;amperage "Amperage" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,amperage,-1,-1;usage "Usage" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,usage,-1,-1;duration "Duration" true true false 4 Long 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,duration,-1,-1;height "Height" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,height,-1,-1;notes "Notes" true true false 2000 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,notes,0,2000;iscritical "Critical Valve" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,iscritical,-1,-1;flowcapacity "Flow Capacity" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,flowcapacity,-1,-1;permanentindicator "Permanent Indicator" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,permanentindicator,-1,-1;spatialaccuracy "Spatial Accuracy" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,spatialaccuracy,-1,-1;depthunits "Depth Units" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,depthunits,-1,-1;diameterunits "Diameter Units" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,diameterunits,-1,-1;flowcapacityunits "Flow Capacity Units" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,flowcapacityunits,-1,-1;heightunits "Height Units" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,heightunits,-1,-1;lengthunits "Length Units" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,lengthunits,-1,-1;pressureunits "Set Pressure Units" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,pressureunits,-1,-1;maopunits "MAOP Unit of Measure" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,maopunits,-1,-1;usageunits "Usage Units" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,usageunits,-1,-1;usagerateunits "Usage Rate Units" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,usagerateunits,-1,-1;recordingmethod "Recording Method" true true false 25 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,recordingmethod,0,25;regulatorbodytype "Regulator Body Type" true true false 20 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,regulatorbodytype,0,20;outletdiameter "Outlet Diameter" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,outletdiameter,-1,-1;diaphragmdiameter "Diaphragm Diameter" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,diaphragmdiameter,-1,-1;premise "Premise" true true false 10 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,premise,0,10;indoormeter "Indoor Meter" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,indoormeter,-1,-1;operatingclassification "Operating Classification" true true false 40 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,operatingclassification,0,40;maxdifferentialpressure "Max Differential Pressure" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,maxdifferentialpressure,-1,-1;companypaidtelephone "Company Paid Telephone" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,companypaidtelephone,-1,-1;telephonenumber "Telephone Number" true true false 15 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,telephonenumber,0,15;usagerate "Usage Rate" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,usagerate,-1,-1;gpsx "GPS X" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,gpsx,-1,-1;gpsy "GPS Y" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,gpsy,-1,-1;gpsz "GPS Z" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,gpsz,-1,-1;legacyid "Legacy ID" true true false 38 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,legacyid,0,38;workorderid "Work Order ID" true true false 38 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,workorderid,0,38;projectnumber "Project Number" true true false 38 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,projectnumber,0,38;servicesummaryid "Service Summary ID" true true false 38 Guid 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,servicesummaryid,-1,-1;assetunitcode "Asset Unit Code" true true false 38 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,assetunitcode,0,38;eventid "Event ID" true true false 38 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,eventid,0,38;fromdate "From Date" true true false 8 Date 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,fromdate,-1,-1;todate "To Date" true true false 8 Date 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,todate,-1,-1;engrouteid "Engineering Route ID" true true false 38 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,engrouteid,0,38;engroutename "Engineering Route Name" true true false 100 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,engroutename,0,100;engm "Engineering Measure" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,engm,-1,-1;continrouteid "Continuous Route ID" true true false 38 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,continrouteid,0,38;continroutename "Continuous Route Name" true true false 100 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,continroutename,0,100;continm "Continuous Measure" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,continm,-1,-1;refmethod "Reference Method" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,refmethod,-1,-1;reflocation "Reference Location" true true false 50 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,reflocation,0,50;refoffset "Reference Offset" true true false 50 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,refoffset,0,50;bondedinsulated "Bonded/Insulated" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,bondedinsulated,-1,-1;cptraceability "Cathodic Protection Traceability" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,cptraceability,-1,-1;cpoverride "CP Override" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,cpoverride,-1,-1;locationdescription "Location Description" true true false 255 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,locationdescription,0,255;wallthickness "Wall Thickness" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,wallthickness,-1,-1;wallthickness2 "Wall Thickness 2" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,wallthickness2,-1,-1;diameter2 "Diameter 2" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,diameter2,-1,-1;temprating "Temp Rating" true true false 20 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,temprating,0,20;coolingmethod "Cooling Method" true true false 20 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,coolingmethod,0,20;rating "Rating" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,rating,-1,-1;specification "Specification" true true false 30 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,specification,0,30;remoteoperation "Remote Operation" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,remoteoperation,-1,-1;valvekeysize "Valve Key Size" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,valvekeysize,-1,-1;modelnumber "Model Number" true true false 20 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,modelnumber,0,20;deviceactuatortype "Device Actuator Type" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,deviceactuatortype,-1,-1;operatortype "Operator Type" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,operatortype,-1,-1;remotedevicefailtype "Remote Device Fail Type" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,remotedevicefailtype,-1,-1
Load Type ADD
Generate Event ID GUIDs for loaded events NO_GENERATE_EVENT_IDS
Generate Shapes GENERATE_SHAPES
Output Target Event PipelineDevice
Output Results File U:\Documents\ArcGIS\Projects\Prototype_APR\GP_A9C43.txt
=====================
Messages
Start Time: 24 August 2021 07:36:39
The target field SHAPE does not allow NULL values, but is not mapped
Failed to execute (AppendEvents).
Failed at 24 August 2021 07:36:40 (Elapsed Time: 1.29 seconds) I am not able to change the definition of the Pipeline Device, and the tool does not allow me to map the SHAPE field (Let's say I create the geometry, and add it to my table of data)...so.... How that should be done???
... View more
08-29-2021
11:54 PM
|
0
|
0
|
12214
|
|
POST
|
As @JSchroeder one BIG mistake I made was to modify the LRS. What can be concluded: If I am going to use UPDM + UN +APR, the centerlines must be created in the PipelineLine Feature Class. To use UPDM+APR, there is a lack in the documentation/tasks in "Gas and Pipeline Data Management for ArcGIS Enterprise". In order to use UPDM+APR, It is required to apply the asset package, remove the UN, then create the LRS using an existing dataset. I keep thinking that the "Create Route" tool either has a bug or a lack of feedback for the user.
... View more
08-10-2021
05:26 AM
|
0
|
0
|
4188
|
|
POST
|
Hello @JSchroeder , thanks for your answer. I have to point some details: The error message points that please take note that in the image, the chosen centerlines tool, do not read properly the shapeLength, That could be an indication of a bug in ArcGIS Pro. As I mentioned, I created an empty file geodatabase, then I created an LRS from Scratch (using arcpy.locref.CreateLRS ) the centerline table is created with only 4 fields, and the selection process works ok (see following image) I also checked in this example (the one in the image above), the properties of the Centerline (from a LRS created from Scratch), and the properties match, i.e. m values are no enabled: So, as you can see the issue is not about missing Fields in the P_Centerline (from UPDM), or missing the m value.
... View more
08-10-2021
03:21 AM
|
0
|
0
|
4190
|
|
POST
|
Hello @AyanPalit , thanks for your answer. I had already stumble with the information that you are providing me. But maybe, you can helpe me to understand the issue here: I followed the tasks in the Gas and Pipeline Datamanagement v1.2 to create a File Geodatabase with Schema . Is that File Geodatabase one with APR only or APR with Utility Network? If I have the File Geodatabase, How should I start populating the data for the creation of centerlines and routes having into account the procedure that I describe above or in my other post?
... View more
08-08-2021
10:20 PM
|
0
|
0
|
2505
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 06-11-2021 02:41 AM | |
| 2 | 12-01-2023 02:45 AM | |
| 1 | 07-19-2021 11:25 PM | |
| 1 | 07-21-2023 04:44 AM | |
| 1 | 07-07-2023 05:15 AM |
| Online Status |
Offline
|
| Date Last Visited |
08-02-2024
12:42 AM
|