Hello! I have a geodatabase with one feature class per township in a county. I need to create a subset table for each township in a second geodatabase. This seems like it should be easy to script in my python notebook, by simply iterating through townships. However, the geoprocessing tool works for a number of the townships and then throws Error 000210: Cannot Create Output.
I've looked at some of the many other questions about this error code and none seem applicable: the geodatabase should be in a location with write access, the file name has no forbidden characters, and there are no weird things with the field names, etc. The destination and schema are the same for all townships, so I am really at a loss for why it might successfully execute the first 11 and then fail on the 12th. Furthermore, if I run the cell again, it may fail on a different township than the previous attempt. And lastly I will note that if I try running the geoprocessing tool outside of the notebook (by clicking run on the failed tool in my geoprocessing history), it will succeed with the township that previously failed.
I have tried both `arcpy.conversion.ExportTable` and `arcpy.analysis.TableSelect` in the code block below.
workspace = f"S:\\Projects\\LandUseInventory\\LUI_{inv_year}\\workspace"
qc_gdb = f"{workspace}\\qc\\qc_complete.gdb"
fail_gdb = f"{workspace}\\throughQC\\qcfailtest.gdb"
fail_tbl_list = []
for twp in twp_list: # ['01', '02', '03', ...]
print(f"Generating fail table for {cty_case} {twp}")
fail_tbl = f'{fail_gdb}\\{cty_case}_fail{twp}' # eg \Lake_fail01
fail_tbl_list.append(fail_tbl)
arcpy.conversion.ExportTable(f'{qc_gdb}\\{cty_case}_{twp}', fail_tbl, "QC_STATUS IN ('X', 'Z')")
I hope someone can help, thank you!
