Focal Point
[CLOSED] Problem with how to about PDF and blob

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7017099196

November 14, 2019, 04:12 AM
dr.herojos
[CLOSED] Problem with how to about PDF and blob
Hi,

I try to implement this how to, Displaying PDF BLOB Data From Within a WebFOCUS Web Application but I receive an error when I run the fex that get the BLOB from database.

I have debugged the fex and I discover that the problem in related to this snippet of code

TABLE FILE PERFAPP
PRINT PERFAPPPDF
WHERE PERFAPPID EQ &PERFAPPID
ON TABLE HOLD AS HLDBLOB
END
-RUN

The error is (FOC1426) DATA ELEMENT VALUE TOO BIG FOR SEGMENT/FIELD : PERFAPP/PERFAPPPDF

I run the same snippet on my datamigrator server and it works fine.

My production environment is WebFOCUS 82 Server Release 8203M gen 1337

Do you know if there are some setting to using blob in reporting server?

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.2 Relase 8203 Build Gen 43
DataMigrator 8203M Gen Number 1337
Windows, All Outputs
November 14, 2019, 11:17 AM
FP Mod Chuck
dr.herojos

I found this technique and it does not mention any special settings but I would suggest you check the master file being used in both environments to insure the field ACTUAL and USAGE are BLOB

https://www.informationbuilder...ocus-web-application


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats