I'm trying to delete the previous logs and spaces from the pedalada2.outsystemscloud.com environment but an error appears during the execution of the DBCleaner, OneClickCleanup and DBCleanerOnSteroids app. The apps say that there are no logs, but the logs are in the ServiceCenter and can not be deleted, increasing more space in the environment.

The support has not responded lately and the space occupied in the environment is growing more and more, without conditions to carry out the cleaning.



Error executing query. Error in advanced query GetLogTableTypeRecordCount in GetLogTableTypes_RecordCount in OneClickCleanup (with Log_All as ( SELECT * FROM dbo.oslog@LogTableCycle0      UNION      SELECT * FROM dbo.oslog@LogTableCycle1       UNION      SELECT * FROM dbo.oslog@LogTableCycle2       UNION      SELECT * FROM dbo.oslog@LogTableCycle3       UNION      SELECT * FROM dbo.oslog@LogTableCycle4       UNION      SELECT * FROM dbo.oslog@LogTableCycle5       UNION      SELECT * FROM dbo.oslog@LogTableCycle6       UNION      SELECT * FROM dbo.oslog@LogTableCycle7       UNION      SELECT * FROM dbo.oslog@LogTableCycle8       UNION      SELECT * FROM dbo.oslog@LogTableCycle9  )  SELECT @LogTableLabel,      COUNT(*) AS [count],      @LogTableLabel,      '',      @LogTableColor  FROM Log_All with(nolock)      LEFT JOIN {Espace} on {Espace}.[Id] = [Espace_Id]  WHERE {Espace}.[Name] like @SearchKeyword      and [Instant] between @MinDate and @MaxDate  ): Invalid object name 'dbo.oslog_Sms_0'.


Have you tried DB Auto Maintainer?

From the error you posted, it seems that it cannot find the SMS log table(s). 

Perhaps you can edit the SQL query to remove the select for SMS log tables and see if that will resolve your issue?

App Pedalada wrote:

I'm trying to delete the previous logs and spaces from the pedalada2.outsystemscloud.com environment but an error appears during the execution of the DBCleaner, OneClickCleanup and DBCleanerOnSteroids app. The apps say that there are no logs, but the logs are in the ServiceCenter and can not be deleted, increasing more space in the environment.

The support has not responded lately and the space occupied in the environment is growing more and more, without conditions to carry out the cleaning.



Error executing query. Error in advanced query GetLogTableTypeRecordCount in GetLogTableTypes_RecordCount in OneClickCleanup (with Log_All as ( SELECT * FROM dbo.oslog@LogTableCycle0      UNION      SELECT * FROM dbo.oslog@LogTableCycle1       UNION      SELECT * FROM dbo.oslog@LogTableCycle2       UNION      SELECT * FROM dbo.oslog@LogTableCycle3       UNION      SELECT * FROM dbo.oslog@LogTableCycle4       UNION      SELECT * FROM dbo.oslog@LogTableCycle5       UNION      SELECT * FROM dbo.oslog@LogTableCycle6       UNION      SELECT * FROM dbo.oslog@LogTableCycle7       UNION      SELECT * FROM dbo.oslog@LogTableCycle8       UNION      SELECT * FROM dbo.oslog@LogTableCycle9  )  SELECT @LogTableLabel,      COUNT(*) AS [count],      @LogTableLabel,      '',      @LogTableColor  FROM Log_All with(nolock)      LEFT JOIN {Espace} on {Espace}.[Id] = [Espace_Id]  WHERE {Espace}.[Name] like @SearchKeyword      and [Instant] between @MinDate and @MaxDate  ): Invalid object name 'dbo.oslog_Sms_0'.



Seems like the author of DB Cleaner on Steroids has uploaded a new version that could resolve this issue of yours...