topic Re: SQL Error 63666 Deleting files from GDB in 3.2.1 in ArcGIS Pro Questions

SQL Error 63666 Deleting files from GDB in 3.2.1

JLine4455 — Sun, 24 Dec 2023 17:11:12 GMT

I am deleting multiple Tables from a project GDB in PRO 3.2.1 and I get this repeated error statement for each one: arcpro delete item [error]: invalid sql syntax [near 63666 : syntax error]

Any ideas? My work around is to create a new GDB and copy the files I don't want to delete into it and trash the old GDB.

Re: SQL Error 63666 Deleting files from GDB in 3.2.1

MichaelVolz — Tue, 26 Dec 2023 20:09:01 GMT

Were these tables created in a previous version of Pro, you upgraded Pro and now you just want to delete the tables?

Re: SQL Error 63666 Deleting files from GDB in 3.2.1

JLine4455 — Wed, 27 Dec 2023 15:37:20 GMT

Hello Michael,

The project GDB that was originally created in 3.1 and then upgraded to 3.2 and then to 3.2.1 during the projects lifetime. The Tables to delete were recently created using 3.2.1. I'm getting the feeling that the 3.1 to 3.2 may have lingering locks or something that just isn't connecting 100%. Since I couldn't delete the tables, I created a new GDB and copied the save files into it and deleted the old GDB. It would be nice if the error code 63666 was detailed.