Database cleanup error

Forum|Forum|4 years ago
April 29, 2021
3 replies
1855 views

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?

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

D

DebTr

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

adithyacs86

Level 5

Hi, I have given some inputs at other thread for the same issue, can you check if that helps anyways - https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/error-log-in-database-cleanup-ootb-workflow/qaq-p/403482

Craig_Thonis

Adobe Employee

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