Database cleanup error

Avatar

Avatar
Give Back
Level 2
felixsongfei
Level 2

Likes

11 likes

Total Posts

34 posts

Correct reply

2 solutions
Top badges earned
Give Back
Ignite 3
Ignite 1
Validate 10
Validate 1
View profile

Avatar
Give Back
Level 2
felixsongfei
Level 2

Likes

11 likes

Total Posts

34 posts

Correct reply

2 solutions
Top badges earned
Give Back
Ignite 3
Ignite 1
Validate 10
Validate 1
View profile
felixsongfei
Level 2

29-04-2021

The Database cleanup workflow has the error when update the deliveries. 

It looks like the error SQL command is "update nmsdelivery set istate=85 tsLastModified=GetDate()", the comma "," missing between the "85" and the "tsLastModified".

 

This is a system generated SQL, does anyone know how to make the SQL correct when the system workflow "database cleanup" running?

 

felixsongfei_0-1619690259835.png

 

Accepted Solutions (0)

Answers (3)

Answers (3)

Avatar

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

179 likes

Total Posts

273 posts

Correct reply

160 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

179 likes

Total Posts

273 posts

Correct reply

160 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile
craigthonis
Employee

30-04-2021

Hi Felix,

 

Can you confirm the Campaign version that you are using? There is an issue found in 9032 GS6 where the comma was missing but has since been corrected in later builds.

 

So upgrading would likely be your best bet.


Regards,

Craig

Avatar

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

170 likes

Total Posts

931 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

170 likes

Total Posts

931 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile
Sukrity_Wadhwa
Employee

17-05-2021

Hi @felixsongfei,

Were you able to resolve this query or do you still need more help here? Do let us know.

Thanks!

Avatar

Avatar
Affirm 25
Level 4
Deb007
Level 4

Likes

50 likes

Total Posts

86 posts

Correct reply

25 solutions
Top badges earned
Affirm 25
Boost 25
Applaud 5
Give Back 5
Validate 1
View profile

Avatar
Affirm 25
Level 4
Deb007
Level 4

Likes

50 likes

Total Posts

86 posts

Correct reply

25 solutions
Top badges earned
Affirm 25
Boost 25
Applaud 5
Give Back 5
Validate 1
View profile
Deb007
Level 4

29-04-2021

Hi,

The SQL is generated by OOTB and you can't change it that easily.

Do you see the delivery with ID mentioned in the screenshot still exists in you instance?

Might some issue with the delivery.

 

Thanks,

Deb