Skip to Content (Press Enter)
UserImage.jpg
Henrique Matos
46Views
3Comments
[DB Cleaner on Steroids] Error in some delete statements (Oracle database)
Question
Forge
Traditional Web
db-cleaner-on-steroids
Web icon
DB Cleaner on Steroids (O11)
Forge asset 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

0
0
27 Sep 2022
Copy Link
2016-09-06 07-28-05
Paolo Palmisano

Hi, we have exactly the same problem ...

Maybe the queries are designed for Microsoft SQL Server ? Are there any plans to update the syntax to be compatible with Oracle DB ?

Thanks !

0
0
09 May 2024
Copy Link
2023-03-30 10-13-40
Miguel Antunes

Hi, just to let you know that I've uploaded version 1.1.2 that tries to solve this issue.

0
0
15 May 2024
Copy Link
UserImage.jpg
Henrique Matos

Hi.

Thanks for the upgrade. Unfortunately, we can still find some of problems with Oracle's SQL syntax. So far, I've identified problems with "PruneApplications" and "DeleteEmails".

We use the app on an Oracle database and usually update it to solve this minor issues. If it's of any interest to you, I can share the updated version, as soon as we review it.

0
0
22 May 2024
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.