Cannot insert features-Underlying DBMS error

[davidchamberlain2]

Hi all,

I have never had this issue before but recently two new layers that I have been trying to load to a database have thrown this error using Pro. These same layers will load to the same database without any problems using ArcMap.

Can anyone tell me why this is happening?

Thanks

Dave

[CodyPatterson]

Hey @davidchamberlain2 

Do the data types assigned to each field match the database schema you're trying to upload to? If there is a decimal value you're uploading, you may need to check the precision of the field to be sure it's compensating for everything needed past the decimal point.

Otherwise, you may need to attempt to insert a single row, to test if it is a data type issue, or a data value issue within the row itself.

Cody

[Robert_LeClair · Accepted solution]

A couple resources to consider with this error message:
000224: Cannot insert features.—ArcGIS Pro | Documentation
Error 000224: Cannot insert features when importin... - Esri Community
Solved: Append Error 000224, but fields are mapped correct... - Esri Community