Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Is there a max size for a blob?

PB Classic 12.5.1 build 4015

Is there a max size for a blob?  Documentation says "unbounded", but I'm seeing problems.

Before starting, I will mention that I have already sent the email about why we have so much data in a datawindow anyway and there are probably better ways to accomplish what the users want, but I'm still curious.

We use GetFullState/SetFullState to move a report between objects in different threads.  I don't know the exact limit I'm running up against, but the GetFullState command succeeds when the resulting blob is 30Mg and under, but hangs when I estimate the result should be about 150Mg.

A GenerateResultSet succeeds on the same datawindow and I tried to modfiy our system to use that instead, but it doesn't get all the data from nested reports (unless I'm just not using it right).

The machine I'm testing with has 16Gg memory but less than 4Gb used while running this.

replied

You might try running the 4GB batch tool on your PowerBuilder executable (the not IDE, but on the executable you generate from PB).  It turns on the LARGEADDRESSAWARE flag so your 32 bit app can see 4GB on a 64 bit system:

Bruce Armstrong's blog: Nice tool for Increasing memory for 32 bit apps on 64 bit systems

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question