What is the best way to store a whole JSON Object body in a table?

Currently we are storing the JSON Object Body in a column which is [UsrJsonBody]  nvarchar](MAX) of a custom table. But sometime the whole JSON is not properly storing. That means for quite big JSONs the later part is getting missed. Can I know is there any issue with this approach. Please check the below code snippets. Thank you.

//Custom table creation
CREATE TABLE Edbo].]XXPOCreateHist](
	>ID] ]int] IDENTITY(1,1),
	>CompanyID] ]int] NOT NULL,
	>IntegrateDate] ]datetime],
	>PONumber] ]nvarchar](50),
	>IntegrateStatus] ]nvarchar](2),
     ErrorDesc] ]nvarchar](256) ,
	>IntegrationType] ]nvarchar](50),
	>UsrJsonBody] ]nvarchar](MAX) ,....


//JSON Storing approach in the Graph file
var options = new JsonSerializerOptions { WriteIndented = true };
          var json=JsonSerializer.Serialize(obj,options);

          PXTrace.WriteInformation(json);
....

XXPOCreateHist toBeInserted = new XXPOCreateHist();

            toBeInserted.PONumber=order.OrderNbr;
            toBeInserted.IntegrateDate=DateTime.Now;
            toBeInserted.UsrJsonBody = json;

            XXPOCreateHistData.Insert(toBeInserted);
            XXPOCreateHistData.Cache.Persist(PXDBOperation.Update);