Re: Lead Service Line Inventory - DLT

412
1
Jump to solution
02-02-2023 09:09 AM
CharlesRemmers
New Contributor II

Using the path to Feature Service layers just errors out.  Text below

Create Data Loading Workspace
=====================
Parameters

Source to Target Mapping https://services3.arcgis.com/iQAkxbE5rgLj88rC/arcgis/rest/services/ServiceLine_8faf8e2669884865966cf... https://services3.arcgis.com/iQAkxbE5rgLj88rC/arcgis/rest/services/ServiceLine_2a04662c01d2456faa95e...
Output Folder C:\Temp\LSL
Calculate Feature Count Statistics true
Data Loading Workspace
Predictive Field Matching Options MATCH_FIELDS
Predefined Mapping in_memory\main.dlt_template
Create Matches by Subtype true
=====================
Messages

Start Time: Thursday, February 2, 2023 11:01:55 AM
ArcGIS Pro 3.0.3.36057
dltsolutions 3.0.2
A python error occurred.
EXCEPTION
Traceback (most recent call last):
File "C:\Users\cremmers\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone-2\Lib\site-packages\dltsolutions\esri\gptools.py", line 125, in wrapper
return func(*args, **kwargs)
File "C:\Users\cremmers\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone-2\Lib\site-packages\dltsolutions\esri\gptools.py", line 370, in run
gen.main()
File "C:\Users\cremmers\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone-2\Lib\site-packages\dltsolutions\logic\workbook.py", line 952, in main
self.book.save(output_file)
File "C:\Users\cremmers\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone-2\Lib\site-packages\openpyxl\workbook\workbook.py", line 407, in save
save_workbook(self, filename)
File "C:\Users\cremmers\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone-2\Lib\site-packages\openpyxl\writer\excel.py", line 291, in save_workbook
archive = ZipFile(filename, 'w', ZIP_DEFLATED, allowZip64=True)
File "C:\Users\cremmers\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone-2\Lib\zipfile.py", line 1246, in __init__
self.fp = io.open(file, filemode)
OSError: [Errno 22] Invalid argument: 'C:\\Temp\\LSL\\DataLoadingWorkspace\\DataMapping\\Points\\Utility Side | Customer Side-ServiceLine.xlsx'
Failed to execute (CreateDataLoadingWorkspace).
Failed at Thursday, February 2, 2023 11:01:57 AM (Elapsed Time: 2.17 seconds)

0 Kudos
1 Solution

Accepted Solutions
TedHoward2
Esri Contributor

Interesting you have an illegal character in your source layer name "Utility Side | Customer Side". If you can remove the vertical bar than tool should work fine. 

https://doc.arcgis.com/en/arcgis-online/manage-data/manage-hosted-feature-layers.htm#ESRI_SECTION1_C...

I've logged an issue to address this in a future release.

View solution in original post

0 Kudos
1 Reply
TedHoward2
Esri Contributor

Interesting you have an illegal character in your source layer name "Utility Side | Customer Side". If you can remove the vertical bar than tool should work fine. 

https://doc.arcgis.com/en/arcgis-online/manage-data/manage-hosted-feature-layers.htm#ESRI_SECTION1_C...

I've logged an issue to address this in a future release.

0 Kudos