Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Database Cleanup Issue

Avatar

Avatar
Validate 1
Level 1
ukender
Level 1

Likes

0 likes

Total Posts

33 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Give Back
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 1
ukender
Level 1

Likes

0 likes

Total Posts

33 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Give Back
Applaud 5
Affirm 1
View profile
ukender
Level 1

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
Contributor
MVP
wodnicki
MVP

Likes

932 likes

Total Posts

1,061 posts

Correct Reply

495 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

932 likes

Total Posts

1,061 posts

Correct Reply

495 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
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)