Error log in Database cleanup OOTB workflow. | Community
Skip to main content
G
Greeshma_Sampath1
Level 4
April 12, 2021
Solved

Error log in Database cleanup OOTB workflow.

  • April 12, 2021
  • 5 replies
  • 2677 views

Hi Team,

 

The OOTB workflow database cleanup is showing the below shown error/warning in logs.

Could someone kindly help me understand what the issue is and what can be done to resolve this issue?

 

Thanks,

Greeshma

 

 

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

Hi Greeshma, 

 

Not sure if I am correct here, but I think clean up workflow is trying to cancel this delivery as may be the deliveries are expired. 

Please refer to the document :- 

https://experienceleague.adobe.com/docs/campaign-classic/using/monitoring-campaign-classic/data-processing/database-cleanup-workflow.html?lang=en#cleanup-of-expired-deliveries

 

per the update statement it is trying to stop or cancel the delivery (85). 

 

Please check if these deliveries are still valid. 

 

Thanks,
Adithya

5 replies

adithyacs86
adithyacs86
Level 5
April 12, 2021

Hi Greeshma, 

 

At the first glance I assume the deliveries have got deleted (may be manually) where there are few entries of the same delivery id in the broad / tracking logs. 

Please check the tables for any entires of the shown deliveries. 

 

Thanks,
Adithya

G
Greeshma_Sampath1Author
Level 4
April 12, 2021

Hi @adityacs86,

 

As i checked the deliveries in All deliveries folder, all are stopped deliveries. Can that be the issue? and the deliveries are there in deliveries schema also.

 

Thanks,

Greeshma

adithyacs86
adithyacs86
Level 5
April 12, 2021
Hi Greeshma, Dont think so if the deliveries exists.. Can you share the sql code that is populating in the audit log.
G
Greeshma_Sampath1Author
Level 4
April 12, 2021

Hi @adithyacs86,

 

04/10/2021 4:05:23 AM nlmodule ORA-210000 Oracle error: ORA-00933: SQL command not properly ended
04/10/2021 4:05:23 AM nlmodule WDB-200002 SQL statement 'UPDATE NmsDelivery SET iState = :1 tsLastModified = cast(SYSTIMESTAMP as TIMESTAMP WITH TIME ZONE) WHERE iDeliveryId = :2' could not be executed (error in position 35: 'tsLastModified'). Param(0)=85 Param(1)=382320612
04/10/2021 4:05:23 AM nlmodule Failed to update external cancel-pending delivery 382320612.

 

This code is repeated for all other deliveries.

The deliveries are present in nms:delivery schema.

 

Thanks,

Greeshma

adithyacs86
adithyacs86Accepted solution
Level 5
April 12, 2021

Hi Greeshma, 

 

Not sure if I am correct here, but I think clean up workflow is trying to cancel this delivery as may be the deliveries are expired. 

Please refer to the document :- 

https://experienceleague.adobe.com/docs/campaign-classic/using/monitoring-campaign-classic/data-processing/database-cleanup-workflow.html?lang=en#cleanup-of-expired-deliveries

 

per the update statement it is trying to stop or cancel the delivery (85). 

 

Please check if these deliveries are still valid. 

 

Thanks,
Adithya

G
Greeshma_Sampath1Author
Level 4
April 12, 2021

Hi @adithyacs86,

 

Could you please let me know what can be done to stop this issue in future?

 

Thanks,

Greeshma

Terms & ConditionsAccessibility statement

Loading footer...