Cold fusion 2021 sometimes image breaks while creating pdf file

Question

Recently we moved from cfusion11 to 2021. While generating pdf file sometimes image breaks. Please suggest us solution if anybody face same issue and came out from that.

Faizan278243197lsr · Accepted Answer

I think the following description is a clue: "Image we are retrieving through the database which contains in BLOB form".

The process of retrieving the image may be too slow, or even interrupted. Possible reasons for this include slow or interrupted movement of image bytes down the wire or a slow or interrupted database connection.

Suggestion: cache the query that retrieves the blob. You could, for example, cache the query for 1 day as follows:

<!--- Using cachedWithin attribute to cache query for 1 day --->
<cfquery cachedWithin="#createTimeSpan(1,0,0,0)#" name="xxx" datasource="yourDSN">
...
</cfquery>

Now retrieving image from DB and saving into temp folder at server and after that the image fetching into PDF. So this is working fine now.

Charlie Arehart · Answer

You haven't clarified how you're creating the PDF. Are you using CFDOCUMENT or CFHTMLTOPDF (introduced in CF11)? Since you don't clarify, I'll assume it's the older cfdocument.

And as a first quick possible solution (knowing nothing more), try adding localurl="true" to the cfdocument tag. Does that work? If it does, we can explain why later. If it does not, take it out.

When you say it "sometimes breaks", do you mean the same image (in the same PDF generated with the same CFML page) sometimes breaks and sometimes works? If it's the same image, that would be odd (but let us know, either way).

Next, what's the URL of an image that is always "breaking"? Is it specified as a full or relative URL in the img src tag within the cfdocument (or cfhtmltopdf)? If it's relative, does it "work" if you make it full (domain and path as well as file name)?

Finally, if you created a test page that did a cfhttp of the full url (holding the image), does that work? Does a dump of the cfhttp scope after it show that it has binary image file data?

I know you want the "solution", but until we know for sure what your problem is, we have to guess at things and suggest such diagnostics to get us closer to it. Or maybe someone else will offer "the solution" without any further clarification from you.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.