topic Re: Cannot insert features-Underlying DBMS error in ArcGIS Pro Questions

Cannot insert features-Underlying DBMS error

davidchamberlain2 — Thu, 24 Oct 2024 10:51:56 GMT

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

Re: Cannot insert features-Underlying DBMS error

CodyPatterson — Thu, 24 Oct 2024 11:40:02 GMT

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

Re: Cannot insert features-Underlying DBMS error

Robert_LeClair — Thu, 24 Oct 2024 20:23:21 GMT

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