Expand my Community achievements bar.

Unable to save delivery template

Avatar

Level 3

Hi All,

 

web@default services, when we re-start the memory usage will be 250MB

But after 2 to 3 hours the memory usage will be more than 1gb like 1.5GB and 1.6GB.

In client console we will be uunable to create or save any campaigns or delivery template.

 

Thanks,

Sachin

 

13 Replies

Avatar

Employee

Hi @sachincs1991 ,


Please check the web@default logs of the app server. Higher memory consumption could be due to a repetitive task that the web module is doing. This generally happens post a continuous retry after an error. Still, 1.5GB web memory consumption is not that alarming. We have seen systems working fine with that kind of consumption. 

 

Regards,

Shivam

Avatar

Employee

Linux:

 

/usr/local/neolane/nl6/var/default/log/ > In this directory you will find a file named web.log

 

Shivam_Singh_0-1606913976027.png

On Windows its in the following path:

<Installation Directory>\var\default\log\web.log

Shivam_Singh_1-1606914082569.png

 

 

Avatar

Level 3

Hi Shivam,

 

Kindly find the attachment.

 

Thanks,

Sachin 

Avatar

Level 3

020-12-02 06:31:00.901-05 00004308 00006164 2 warning log ORA-210000 Oracle error: ORA-01013: user requested cancel of current operation
2020-12-02 06:52:24.823-05 00004308 00005500 2 warning log ORA-210000 Oracle error: ORA-01013: user requested cancel of current operation
2020-12-02 06:57:31.307-05 00004308 00007730 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 06:57:31.307-05 00004308 00007730 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 06:57:33.666-05 00004308 00007730 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 06:57:33.666-05 00004308 00007730 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:32:37.198-05 00004308 00006858 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:32:37.198-05 00004308 00006858 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:32:58.932-05 00004308 00006164 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:32:58.932-05 00004308 00006164 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:33:01.932-05 00004308 00006164 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:33:01.932-05 00004308 00006164 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:34:57.744-05 00004308 00005500 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:34:57.744-05 00004308 00005500 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:35:00.682-05 00004308 00007730 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:35:00.682-05 00004308 00007730 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:36:10.666-05 00004308 00006858 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:36:10.666-05 00004308 00006858 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:36:13.541-05 00004308 00003CC4 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:36:13.541-05 00004308 00003CC4 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:37:04.823-05 00004308 00005500 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:37:04.823-05 00004308 00005500 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:37:07.729-05 00004308 00005500 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:37:07.729-05 00004308 00005500 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:40:04.291-05 00004308 00003CC4 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:40:04.291-05 00004308 00003CC4 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:40:07.182-05 00004308 00006164 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:40:07.182-05 00004308 00006164 2 error log XSV-350000 Unable to load document of identifier 'temp:exclusion3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:48:47.885-05 00004308 00006858 2 error log WDB-200001 SQL statement 'SELECT D1.sSchema, D1.sRecipientLink, D0.mData FROM NmsDelivery D0 JOIN NmsDeliveryMapping D1 ON (D1.iDeliveryMappingId = D0.iMappingId) WHERE (D0.iDeliveryId = :1) AND ((D0.iDeleteStatus = :2))' could not be executed.\n Param(0)=373055442\n Param(1)=0 (iRc=-2003)
2020-12-02 07:48:47.885-05 00004308 00006858 2 error log WDB-200011 The requested database record does not exist. (iRc=-2003)
2020-12-02 07:48:47.885-05 00004308 00006858 2 error log Cannot load document of type 'Deliveries (nms:delivery)' satisfying condition '([/@id] = 373055442) AND (([/@deleteStatus] = 0))'. (iRc=-53)
2020-12-02 07:48:49.463-05 00004308 00006164 2 error log WDB-200001 SQL statement 'SELECT D1.sSchema, D1.sRecipientLink, D0.mData FROM NmsDelivery D0 JOIN NmsDeliveryMapping D1 ON (D1.iDeliveryMappingId = D0.iMappingId) WHERE (D0.iDeliveryId = :1) AND ((D0.iDeleteStatus = :2))' could not be executed.\n Param(0)=373053710\n Param(1)=0 (iRc=-2003)
2020-12-02 07:48:49.463-05 00004308 00006164 2 error log WDB-200011 The requested database record does not exist. (iRc=-2003)
2020-12-02 07:48:49.479-05 00004308 00006164 2 error log Cannot load document of type 'Deliveries (nms:delivery)' satisfying condition '([/@id] = 373053710) AND (([/@deleteStatus] = 0))'. (iRc=-53)
2020-12-02 07:49:03.494-05 00004308 00006858 2 error log XSV-350000 Unable to load document of identifier 'temp:fileImport2' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:49:03.494-05 00004308 00006858 2 error log XSV-350000 Unable to load document of identifier 'temp:fileImport2' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:49:05.088-05 00004308 00007730 2 error log XSV-350000 Unable to load document of identifier 'temp:fileImport2' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:49:05.088-05 00004308 00007730 2 error log XSV-350000 Unable to load document of identifier 'temp:fileImport2' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:49:06.666-05 00004308 00006858 2 error log XSV-350000 Unable to load document of identifier 'temp:query4' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:49:06.666-05 00004308 00006858 2 error log XSV-350000 Unable to load document of identifier 'temp:query4' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:49:46.791-05 00004308 00006164 2 error log XSV-350000 Unable to load document of identifier 'temp:enrich' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:49:46.791-05 00004308 00006164 2 error log XSV-350000 Unable to load document of identifier 'temp:enrich' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:49:59.994-05 00004308 00006858 2 error log XSV-350000 Unable to load document of identifier 'temp:changeAxis3-src' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:49:59.994-05 00004308 00006858 2 error log XSV-350000 Unable to load document of identifier 'temp:changeAxis3-src' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:50:01.526-05 00004308 00006164 2 error log XSV-350000 Unable to load document of identifier 'temp:changeAxis3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:50:01.526-05 00004308 00006164 2 error log XSV-350000 Unable to load document of identifier 'temp:changeAxis3' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:50:03.104-05 00004308 00006858 2 error log XSV-350000 Unable to load document of identifier 'temp:changeAxis22-src' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 07:50:03.104-05 00004308 00006858 2 error log XSV-350000 Unable to load document of identifier 'temp:changeAxis22-src' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 08:00:18.073-05 00004308 00005500 2 error log XSV-350000 Unable to load document of identifier 'temp:fileImport2' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 08:00:18.073-05 00004308 00005500 2 error log XSV-350000 Unable to load document of identifier 'temp:fileImport2' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 08:00:19.619-05 00004308 00005500 2 error log XSV-350000 Unable to load document of identifier 'temp:fileImport2' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 08:00:19.619-05 00004308 00005500 2 error log XSV-350000 Unable to load document of identifier 'temp:fileImport2' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 08:00:21.182-05 00004308 00005500 2 error log XSV-350000 Unable to load document of identifier 'temp:query4' and type 'xtk:schema'. (iRc=-2003)
2020-12-02 08:00:21.182-05 00004308 00005500 2 error log XSV-350000 Unable to load document of identifier 'temp:query4' and type 'xtk:schema'. (iRc=-2003)

 

 

 

2020-12-01 16:35:51.748-05 00005ECC 00004C94 2 info log AuditTrail: Command 'Unconditional stop' applied on workflow with id '386171695' by operator 'steinz'.
2020-12-01 16:35:52.873-05 00005ECC 000093CC 2 error log XSV-350000 Unable to load document of identifier 'temp:enrich' and type 'xtk:schema'. (iRc=-2003)

Avatar

Employee

Thanks, @sachincs1991 ,

 

There are few errors in the logs but I don't believe that these errors are the reason for the issue that you are facing.

 

Do you get any error when you try to save the template? Or it just crashes? If you get any error, can you share the error screenshot?

Avatar

Level 3

Hi @Shivam_Singh ,

 

1- It is not happening across ALL workflows but it does appear to be happening in multiple workflows and deliveries. It may be tied to the recurring delivery or a recurring delivery template.
2- The issue was identified this evening
3- Multiple users see the same issue when attempting to save similar deliveries / templates.
4- Not Yet 5- Open the workflow > Add a recurring delivery > Select Delivery Template (External Routing Templates). Attempt to save and it says Operation in progress, please wait > receive error message w/ time out.
 
Thanks,
Sachin

Is your Database cleanup workflow running daily without any issue?

Hi @amritakedia_epsilon ,

 

Yes, its running.

 

But we saw below warnings and errors in the database cleanup workflow.

 

sachincs1991_0-1607342576834.png

 

This is one of the delivery audit log

 

sachincs1991_1-1607342706865.png

 

 

Thanks,

Sachin 

Please ask the DBA to bounce the database if possible and restart the Adobe services. Hope that will help clean this inconsistency . Having errors in Database cleanup logs is not a good thing.