Database Cleanup Issue | Community
Skip to main content
ukender
ukender
Level 3
February 10, 2021
Solved

Database Cleanup Issue

  • February 10, 2021
  • 1 reply
  • 1586 views

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.

 

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

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

1 reply

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
February 16, 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

    ukender
    ukenderAuthor
    Level 3
    February 24, 2021
    @jonathon_wodnicki Thank you so much!
    Terms & ConditionsAccessibility statement

    Loading footer...