Select to view content in your preferred language

SQL Error 63666 Deleting files from GDB in 3.2.1

405
2
12-24-2023 09:11 AM
Labels (2)
JLine4455
Emerging Contributor

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.

 

0 Kudos
2 Replies
MichaelVolz
Esteemed Contributor

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

0 Kudos
JLine4455
Emerging Contributor

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. 

0 Kudos