Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Cannot fetch a row from OLE DB provider "DBAmp.DBAmp" for linked server "Salesforce"

I have a query that I am using to pull information from ContentDocument. After doing some digging in this forum and reading through the documentation, I see that the maximum amount you can pull back from a Base64 Salesforce field is 20,000,000 bytes. So I have that set in the DBAmp configuration area, and I've set up my org to not allow documents larger than that maximum. But when I run my queries I get this error:

Cannot fetch a row from OLE DB provider "DBAmp.DBAmp" for linked server "Salesforce"

I was able to track it down to documents that are over 1,400,000 bytes. So I'm wondering if I have some other configuration wrong in DBAmp or my SQL instance.

SQL Server 2016 64 bit
DBAmp Version: 3.3.4.0.

Thanks.
1 person has
this problem
+1
Reply
  • What is the exact command you are running that is throwing the error? Can you post the complete and exact message output showing the error? Also, can I see the Registry Settings page of the DBAmp Configuration Program?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • SELECT * FROM
    OPENQUERY(Salesforce, 'SELECT ContentDocumentId, LinkedEntityId, LinkedEntity.Name, ContentDocument.LatestPublishedVersion.Title,
    ContentDocument.LatestPublishedVersion.ContentSize, ContentDocument.LatestPublishedVersion.VersionData, ContentDocument.LatestPublishedVersion.CreatedDate
    FROM ContentDocumentLink WHERE ContentDocument.FileType != ''SNOTE'' AND ContentDocument.LatestPublishedVersion.CreatedDate > 2018-09-24T00:00:00Z AND LinkedEntityId IN (SELECT ID FROM Account)');

    This is the query that is failing with the following error:

    Msg 7399, Level 16, State 1, Line 1
    The OLE DB provider "DBAmp.DBAmp" for linked server "Salesforce" reported an error. The provider ran out of memory.
    Msg 7330, Level 16, State 2, Line 1
    Cannot fetch a row from OLE DB provider "DBAmp.DBAmp" for linked server "Salesforce".

    If I add "AND ContentDocument.LatestPublishedVersion.ContentSize < 1400000" to the WHERE clause, it works just fine.

    Attached is a screen shot of the DBAmp settings.

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Can you send an email to support at forceamp.com and we can pickup the thread off the forum?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned