DataLoadingTool (2.7.1) in ArcgisPro 2.9.0 - The field is not nullable
Hello,
I have problems using DataLoadingTool(2.7.1) in ArcgisPro 2.9.0 with UtilityNetwork (schema version 2.71, model version 4).
It returns an error that it cannot append the source table.
2022-05-04 09:31:03.691 | WARNING | unmt_utils.Common.PropagateHandler:emit:7 - EXCEPTION
EXCEPTION
Traceback (most recent call last):
File "C:\arcgispro-py3-clone\lib\site-packages\dltsolutions\esri\gptools.py", line 116, in wrapper
return func(*args, **kwargs)
File "C:\arcgispro-py3-clone\lib\site-packages\dltsolutions\esri\gptools.py", line 465, in run
etl.main()
File "C:\arcgispro-py3-clone\lib\site-packages\dltsolutions\logic\etl.py", line 387, in main
self.load(self.transform(self.extract()))
File "C:\arcgispro-py3-clone\lib\site-packages\dltsolutions\logic\etl.py", line 360, in load
self._call_append(source=fc, target=self.target, field_mapping=fms)
File "C:\arcgispro-py3-clone\lib\site-packages\dltsolutions\logic\etl.py", line 332, in _call_append
raise e
File "C:\arcgispro-py3-clone\lib\site-packages\dltsolutions\logic\etl.py", line 313, in _call_append
arcpy.Append_management(**kwargs)
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 6706, in Append
raise e
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 6703, in Append
retval = convertArcObjectToPythonObject(gp.Append_management(*gp_fixargs((inputs, target, schema_type, field_mapping, subtype, expression), True)))
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 512, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteWarning: WARNING 000595: C:\Users\USER\AppData\Local\Temp\fc_95d486edcad1469d8bcde14bb242c36b0.fid contains the full list of records not able to be processed.
WARNING 000594: Input feature 1: The field is not nullable..
WARNING 000594: Input feature 2: The field is not nullable..
WARNING 000594: Input feature 3: The field is not nullable..
WARNING 000594: Input feature 4: The field is not nullable..
WARNING 000594: Input feature 5: The field is not nullable..
WARNING 000594: Input feature 6: The field is not nullable..
WARNING 000594: Input feature 7: The field is not nullable..
WARNING 000594: Input feature 8: The field is not nullable..
WARNING 000594: Input feature 9: The field is not nullable..
WARNING 000594: Input feature 10: The field is not nullable..2022-05-04 09:31:05.285 | ERROR | __main__:main:29 - An error has been caught in function 'main', process 'MainProcess' (8032), thread 'MainThread' (10028):
Source feature class fields:
Target feature class fields:
it seems that the problem is in the assetgroup field, it has no null evaluators.
