Paste Failed in ArcGIS SDE Database

Discussion created by sueyan4 on Aug 25, 2016
Latest reply on Aug 26, 2016 by bnayak-esristaff



I've connected one of my company's databases from Database Connections in ArcCatalog and I can read and update the existing tables (like append, delete data in feature classes).


However, I can't copy and paste any tables (either from other database to this database or within this database) and it always gives the error message like the below screenshot. Is there anyone who can tell me the reason and help me to fix it? Thank you so much!

Underlying DBMS error [[Microsoft][ODBC Driver 11 for SQL Server]Invalid cursor state[]arcgis_geo.SWA_ARCGIS.Locations], DBMS table not found


The error message is :

Failed to paste mytablename

Underlying DBMS error [[Microsoft][ODBC Driver 11 for SQL Server]Invalid cursor state][mytablename]

DBMS table not found