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

The provider ran out of memory

Hi Team,

I am getting a strange error when downloading blob data.

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

This occurs when the file size exceeds 1MB. I even set "Base64 Maximum" option on the registry setting to its max.

DBamp Version:
SQL Version : Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64)
SQL Architecture : x64
SQL CLR: Enabled
Query: Select * From openquery(SF, 'SELECT ContentDocumentId,Title,VersionNumber,ContentSize,VersionData FROM ContentVersion WHERE ContentDocumentId IN(''ID')')
Other Linked Servers: 2 other linked server connecting to Salesforce. But they are not operated as these is a devlopment environment.

Looking forward to your reply.

1 person has
this problem