New report import issue "Commit failed. Object Type - SecuritySubFunction, Key-"

New report import issue "Commit failed. Object Type - SecuritySubFunction, Key-"

Environment:

iVend 6.6

Problem Statement:

Customer Facing Error "Commit failed. Object Type - SecuritySubFunction, Key -" While trying to import New Report.


Proposed Solution:

Suggested the customer to check the "Max Text replication Size" value following below steps on SQL server:

Open SQL Server Management studio >> Right click on the server name >> Properties >>  Advanced  and check "Max Text replication Size".


It was found that "Max Text replication Size" value was 65536 and after updating the value as '1000000' for Max Text replication Size, the issue is resolved.
Screenshot attached for reference: