Skip to main content
ukender
ukender
Level 3
Feb 10, 2021 3:27 PM UTC
Solved

Database Cleanup Issue

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.
Jonathon_wodnicki
Jonathon_wodnickiAccepted solution
Community Advisor
Feb 16, 2021 7:52 AM UTC

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 in thread

2 replies

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
Feb 16, 2021 7:52 AM UTC

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

Translate
    ukender
    ukenderAuthor
    Level 3
    Feb 24, 2021 11:25 PM UTC
    @jonathon_wodnicki Thank you so much!
    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...