[SalesForce] System.DmlException: Insert failed. STRING_TOO_LONG, Body: data value too large

I have a string which has a length of 89308 which represents a PDF document.

I want to store this data into a ContentVersion like this:

ContentVersion contentVersion = new ContentVersion(
    versionData = Blob.valueOf(label),
    title = 'PDF Label',
    pathOnClient = '/Label-' + DateTime.now().getTime() + '.pdf',
    FirstPublishLocationId = relatedID);

insert contentVersion;

But when I insert the ContentVersion record I get this error:

System.DmlException: Insert failed. First exception on row 2; first error: STRING_TOO_LONG, Body: data value too large: … (max length=32768): [Body__c]

But if I look at the SOAP API reference for ContentVersion it says:

The maximum file size you can upload via the SOAP API is 50 MB.

Which means I can store a lot more than 89308 characters.

And the Field Reference for ContentVersion does not state a limit.

Questions

How can I get around this DML insert limitation such that I can store the content?

Best Answer

@DavidReed made the key break through - by noticing that the error related to Body__c.

After storing the data into the ContentVersion I was logging the REST request into another object which had a field Body__c which had a max length of 32768, and this was throwing the exception.

Because the content being stored into the ContentVersion and the Log was identical, I did not realise.

mea culpa.

Related Solutions

[SalesForce] failure message system.dmlexception insert failed

Looks like your trigger code is retrieving a custom setting value.

Which API version is your test class written in? Because current versions default to seealldata=false which means that there won't be any data in the custom settings during the test execution.

[SalesForce] System.DmlException: Insert failed

Several suggestions:

1). If you are trying to use existing data in your unit test class, add @istest(seealldata=true) in the top of the test class (may be you already have this in your code).

@istest(seealldata=true)
public class your_testclass{
   // your code
}

2). Try to assign your query results into List instead of to a single instance.

List<User> users = [select AccountId, ContactId from User where id=:UserId];

and then work with that list,

if(users != null && users.size() > 0){
  List<Account> accounts = [select building__c,LHR__c, ABZ__c, SOU__c, GLA__c, STN__c, EDI__c,OwnerId from account where id=:user[0].AccountId];
}

3). If you much sure that there is one record and need to assign into single instance, try

User user = [select AccountId, ContactId from User where id=:UserId][0];
Account account = [select building__c,LHR__c, ABZ__c, SOU__c, GLA__c, STN__c, EDI__c,OwnerId from account where id=:user.AccountId][0];

(but I don't like this method since it intend to throw exceptions).

Best Answer

Related Solutions

[SalesForce] failure message system.dmlexception insert failed

[SalesForce] System.DmlException: Insert failed

Related Topic