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 error

felixsongfei
Level 3
Level 3

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

 

6 Replies
Deb007
Level 5
Level 5

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

felixsongfei
Level 3
Level 3
The deliveries are still there in the instance, and the status is already "Stopped(85)". I don't know why the cleanup workflow still want to update the status to 85
craigthonis
Employee
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

Sukrity_Wadhwa
Employee
Employee

Hi @felixsongfei,

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

Thanks!