Skip to main content
ukender
Level 3
Feb 24, 2021 8:32 AM UTC
Question

DB Cleanup Issue

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!

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.