Expand my Community achievements bar.

DB Cleanup Issue

Avatar

Level 3

Dear Team

 

We are facing an weird issue while executing DB cleanup WF.

It keeps failing with an table doesn't execute issue. if we recreate the table - the issue moves to other table.

 

As per analysis, it is fetching the data from sysobjects WHERE type = 'U'. 

 

Could you help me how to resolve this issue.

 

Log:

 

02/24/2021 9:12:23 AM nlmodule WDB-200001 SQL statement 'up_updatestats' could not be executed.
02/24/2021 9:12:22 AM nlmodule ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Table 'wkf324403375_1020_1' does not exist. SQLState: S0002
02/24/2021 9:12:21 AM nlmodule ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Updating EMEA\sa-ceteris.wkf324403375_1020_1 SQLState: 01000

 

 

Thank you!

 

 

0 Replies