Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Database Cleanup Issue

Avatar

Level 3

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.

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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