Error message "the file is damaged and could not be repaired"


I need your help please.

In my coldfusion code, I have my project to upload any type of documents but for some reason .pdf and .msg gives me an error that says "There was an error opening this document. The file is damaged and could not be repaired"

I am not sure why the project open up .doc or any other files fine but the .pdf and .msg

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Are you saving these files into the database?   If so, perhaps the pdf and msg files are larger than the .doc files and they are getting cut-off.   There is a setting in the /CFIDE/administrator to only fetch a limited string size, perhaps you are exceeding it with these file types.  

The setting is under "Advanced Settings" for your data source definition and is called LONG TEXT BUFFER or BLOG BUFFER

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lulu50Author Commented:

Yes, I am saving the files to the database.

the file size of the .pdf is the same as the .doc file

what is the data source definition?

FileID      int      Unchecked
IssueID      int      Checked
FileName      varchar(255)      Checked
Description      varchar(255)      Checked
UploadedFile      varchar(MAX)      Checked
Status      int      Checked
uploadedasbinary      varbinary(MAX)      Checked
CreatedDate      datetime      Checked
The data source definition is the place in the CFIDE/Administrator where you define the datasource which points to your database.   Click on the datasource and then the advanced options to see this field.   The setting limits the amount of data that will be fetched from the database.    I ran into this problem when opening large data, it literally truncates the data fetched, sounds like that is what is happening to you.
lulu50Author Commented:

Thank you for your help.  That was the problem!!!!!
lulu50Author Commented:
Thank you
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ColdFusion Language

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.