Skip to main content
C
cinthara
Inspiring
November 23, 2011
Answered

Problem with BLOB image retrieval

  • November 23, 2011
  • 1 reply
  • 2034 views

We are on Coldfusion 9,0,1,274733. I checked on "Enable binary large object retrieval (BLOB)" on the database but the image is still cut off (3/4 partly grey). On our dev server it works perfectly, our production server just gives off the partly grey images. I checked the CF database settings between dev and production and they are exactly the same. We restarted the server but still the same problem. It is like Coldfusion doesn't see the setting changes. Anyone else has this problem?

This topic has been closed for replies.
Correct answer cinthara

We found the solution. Our production servers are in a clustered environment. You have to enable "Enable binary large object retrieval (BLOB)" at the instance cluster level. You will have to do this change on all the instances in the cluster. I was only enabling it at the "local" level on each server in the cluster (which didn't work).

In CF Admin:

Enterprise Manager > Instance Manager > select the instance and enable BLOB

1 reply

I
insuractive
Inspiring
November 23, 2011

Have you verified that the length of the data in the production database matches the length of the data in your dev database (i.e. that the problem is with CF and not the database itself)?

C
cintharaAuthor
Inspiring
November 23, 2011

Yes, the length of the data is exactly the same on both dev and production. If the image is really small like 20KB, it will render. It is so strange that it just doesn't see the setting change.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices