Offer Notification Workflow Fails

sadafali

01-08-2018

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

View Entire Topic

shrawans3153003

Employee

07-08-2018

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.