topic Re: Execute Data Load - "No rows to process" message in Data Loading Tools Questions

Execute Data Load - "No rows to process" message

EApolinar — Thu, 27 Jun 2024 09:33:52 GMT

Hello, everyone!

I've been following the Load data into the ArcGIS utility network tutorial and after some days, I've encountered this issue that doesn't allow me to complete the final step.

The Execute Data Load tool does not fail but finishes very quickly displaying the message "No rows to process".

I have already upgraded the ArcGIS Pro to the 3.1 version used in the tutorial, I've checked the Excel worksheets to make sure all data sources are correct, but no matter what I do I still get the same result.

Has anyone seen this behavior before?

It shouldn't matter but I'm using Parallels on a M1 MacBook and I've also tried Mac and Widows paths to the data sources with similar results:

\\Mac\**unspecified**\Documents\ArcGIS\Packages\Water Data Loading Lesson_70892e\p20\water_source.gdb

C:\Proyectos\p20\water_source.gdb

On a further step I'd like to try this on ArcGIS Pro 3.2 or later since the DLT tools are included, but I'm not sure if the tutorial's older Excel workbooks will work on a newer version.

Thank you!!

Re: Execute Data Load - "No rows to process" message

shamenw — Sat, 29 Jun 2024 09:14:39 GMT

This is most common error. The best practice if you do not want to get an error is to use a List of your sObject type for assignment even if you are expecting 1 record. And then after a empty and null check get the record from zeroth index of the list https://tutuapp.uno/ .

Re: Execute Data Load - "No rows to process" message

MikeMillerGIS — Thu, 27 Jun 2024 14:28:14 GMT

Can you share a view of your data loading workbook? The tutorial is still valid for 3.2+, but the names of the tools have changed and the workbook schemas are slightly different.

Re: Execute Data Load - "No rows to process" message

EApolinar — Fri, 28 Jun 2024 12:09:06 GMT

Thank you, @shamenw and @MikeMillerGIS for your quick answers.

After further revision of the Blank and Complete mapping DataReference workbooks I noticed that I needed to leave the Enabled columns as "VERDADERO" in Spanish, instead of "True", since this is the language I was following the tutorial in.

It is weird since all data is actually in English and so are the drop-down options for data validation in the DataReference workbook:

Everything is working now as expected, Thank you!