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

Hi,


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,

Henrique

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