[DB Cleaner on Steroids] Error in some delete statements (Oracle database)
Web icon
Forge component by Miguel Antunes
Application Type
Traditional Web


We're getting an "Error executing query. Error in advanced query DeleteSiteProperties in CascadeDelete_eSpace in DBCleanerOnSteroids (DELETE {Site_Property}  FROM {Site_Property} JOIN       {Site_Property_Definition} ON {Site_Property}.[Site_Property_Definition_Id] = {Site_Property_Definition}.[Id]  WHERE {Site_Property_Definition}.[Espace_Id] = @EspaceId): ORA-00933: SQL command not properly ended" that is identified in some other comments, here.

I believe it's due to the use of a "join" in the delete statement (Oracle's picky); it probably affects "DeleteCyclicJobs", "DeleteAssemblyDependencies", etc (all the "deletes" with a join, after the one that raises the first error).

Best regards,


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.