Database Cleanup Issue

Avatar

Avatar

ukender

Avatar

ukender

ukender

10-02-2021

Hi All

 

We're facing the below error while executing the Database Cleanup WF, Could you pl. help.

Thank you!

 

Error Log:

-------------------------------------------------------------------------------------------------------------------------

02/10/2021 4:22:12 PM nlmodule WDB-200001 SQL statement 'DropTableIfExists 'wkf235202504_2_1'' could not be executed.
02/10/2021 4:22:12 PM nlmodule WDB-200001 SQL statement 'DropTableIfExists 'wkf232235642_216_1'' could not be executed.
02/10/2021 4:22:12 PM nlmodule ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'DropTableIfExists'. SQLState: 37000
02/10/2021 4:22:12 PM nlmodule ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'DropTableIfExists'. SQLState: 37000
02/10/2021 4:22:12 PM nlmodule ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'DropTableIfExists'. SQLState: 37000
02/10/2021 4:22:12 PM nlmodule WDB-200001 SQL statement 'DropTableIfExists 'wkf232235642_215_1'' could not be executed.
02/10/2021 4:22:12 PM nlmodule ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'DropTableIfExists'. SQLState: 37000
02/10/2021 4:22:12 PM nlmodule WDB-200001 SQL statement 'DropTableIfExists 'wkf226443265_401_1'' could not be executed.
02/10/2021 4:22:12 PM nlmodule WDB-200001 SQL statement 'DropTableIfExists 'wkf226443265_400_1'' could not be executed.

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

15-02-2021

Hi,

 

Looks like Campaign's db functions got lost somehow.

Easy way to reinstall them is to add your db as an external account and use the FDA conf to deploy (snapshot db before doing this):

 

Thanks,

-Jon

Answers (0)