Offer Notification Workflow Fails

[#1]

Hi,

The Offer notification (offerMgt) technical workflow fails with the below error, though no changes have been done since the past 2 weeks. It was working fine until 2 days ago.

02/08/2018 11:11:37 js SCR-160012 JavaScript: error while evaluating script 'offerMgt/js'.

02/08/2018 11:11:37 js Failed deployment of the folder of identifier '41056'. The error is '-2006'

02/08/2018 11:11:36 js SOP-330011 Error while executing the method 'Write' of service 'xtk:persist|xtk:session'.

02/08/2018 11:11:36 js XSV-350023 Unable to save document of type 'Folders (xtk:folder)'.

02/08/2018 11:11:35 js WDB-200001 SQL statement 'UPDATE XtkFolder SET iChildcount=iChildcount+1 WHERE sFullName=?' could not be executed.   Param(0)=/Offers - live/Environment - membership_comm_category_dest/

02/08/2018 11:11:34 js ODB-240000 ODBC error: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The statement has been terminated. SQLState: 01000

02/08/2018 11:11:34 js ODB-240000 ODBC error: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Arithmetic overflow error for data type smallint, value = 32768. SQLState: 22003

02/08/2018 11:11:33 js Installation of packages successful.

02/08/2018 11:11:32 js WDB-200001 SQL statement 'UPDATE XtkFolder SET iChildcount=iChildcount+1 WHERE sFullName=?' could not be executed.   Param(0)=/Offers - live/Environment - membership_comm_category_dest/

02/08/2018 11:11:32 js ODB-240000 ODBC error: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The statement has been terminated. SQLState: 01000

02/08/2018 11:11:31 js ODB-240000 ODBC error: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Arithmetic overflow error for data type smallint, value = 32768. SQLState: 22003

Can anyone help me debug this please?

Regards,

Sadaf

[#2 · Accepted solution]

Hi Sadaf,

Thanks for confirming over support ticket that issue is resolved after updating the value of child node of live folder to be the same as design folder. The value was 2 for design folder while for live it was 32767 which usually should not be the case.

[#3]

Thanks Vipul Raghav​

I have already raised a support ticket for the same and was looking for alternatives myself by the time I get the response from the support team.

Regards,

Sadaf

[#4]

Hi Sadaf,

I'm aware of the customer instance which you are working on and hence will suggest you contact support for further troubleshooting.

We will have to do a screenshare and understand what is going wrong.

Regards,
vipul

[#5]

Hi Vipul Raghav​,

Thanks for your prompt response.

But I am unable to understand, what do you mean by child folders as I have created none. There is only one Offer Catelog folder in it.

Regards,

Sadaf

[#6]

Hi sadafali,

The error message is self explanatory. Inside the folder /Offers - live/Environment - membership_comm_category_dest/.  it seems you have created more than 32767 child folders.

Now you are trying to create one more which the sytem will allow you to but then the column childcount on parent folder has to be updated with the count. This column is of type="short" which can hold a max value of 32767 only.

1. 32767 child folders is a lot of folders. Do you need so many. If not, please perform a cleanup immediately.

2. Still if you wish to keep on growing, extend xtk:folder schema and change the type to long

Test it on ower instance before applying to production.

Regards,
Vipul