Unable to save delivery template

[#1]

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

[#2]

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

[#3]

Hi @Shivam_Singh ,

Which file we need to check?

Thanks,

Sachin

[#4]

Linux:

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

On Windows its in the following path:

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

[#5]

Hi @Shivam_Singh ,

Attached web.log file.

Thanks,

Sachin

[#6]

Cant see the attachment

[#7]

Hi Shivam,

Kindly find the attachment.

Thanks,

Sachin 

[#8]

Hi @Shivam_Singh ,

Kindly check now

[#9]

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)

[#10]

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?