EBMS Tickets

Issue Number 584
Summary Unable to upload .doc files after PHP upgrade
Created 2020-12-03 20:27:41
Issue Type Bug
Submitted By Juthe, Robin (NIH/NCI) [E]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2020-12-04 10:20:32
Resolution Fixed
Path /home/bkline/backups/jira/oceebms/issue.279934
Description

Crystal noticed that we're unable to upload .doc files since last night's PHP upgrade. I've pasted some email correspondence below.

 

 

From: Juthe, Robin (NIH/NCI) [E]
Sent: Thursday, December 3, 2020 8:23 PM
To: Bob Kline <bkline@rksystems.com>; Sershen, Crystal (NIH/NCI) [C] <crystal.sershen@nih.gov>
Subject: RE: .doc files

 

Interesting! I just successfully uploaded the two summaries Crystal had sent on DEV, so it appears to be working as expected. I think this can be moved up the tiers. (I’m adding a JIRA ticket now!)

 

Thank you!

Robin

 

From: Bob Kline <bkline@rksystems.com>
Sent: Thursday, December 3, 2020 5:20 PM
To: Sershen, Crystal (NIH/NCI) [C] <crystal.sershen@nih.gov>
Cc: Juthe, Robin (NIH/NCI) [E] <robin.juthe@nih.gov>
Subject: Re: .doc files

 

Thanks. It appears that the new version of PHP returns a different MIME type for word-processing documents using the old Microsoft proprietary format. They are now referred to as application/CDFV2 (where "CDFV2" stands for Composite Document File V2). I installed a workaround on DEV. If testing finds no problem with it, I'll push it up the tiers and see if I can get CBIIT to accept a patch.

 

Bob

 

On Thu, Dec 3, 2020 at 4:05 PM Sershen, Crystal (NIH/NCI) [C] <crystal.sershen@nih.gov> wrote:

Hi Bob,

 

I have attached three of the documents. The 2020 Comprehensive Review schedule worked when it was uploaded without a tag.

 

Crystal

 

From: Bob Kline <bkline@rksystems.com>
Sent: Thursday, December 3, 2020 3:54 PM
To: Sershen, Crystal (NIH/NCI) [C] <crystal.sershen@nih.gov>
Cc: Juthe, Robin (NIH/NCI) [E] <robin.juthe@nih.gov>
Subject: Re: .doc files

 

Hi, Crystal. Can you attach the original .doc files which failed?

 

Thanks,

Bob

 

On Thu, Dec 3, 2020 at 3:50 PM Sershen, Crystal (NIH/NCI) [C] <crystal.sershen@nih.gov> wrote:

Hi Robin and Bob,

 

I tried to upload Ch NHL and Neuroblastoma this morning and received a similar message for both,  “Ch Non-Hodgkin Lymphoma HP 12_3_20 for Lit Surv.doc is not of type application/msword.”.  I had created both documents this morning before attempting to upload them. I just tried to upload a file that I put in the EBMS yesterday and it rejected it with the message above, however, I was able to upload a .doc file into the pediatric treatment folder without a tag. I hope this information helps.

 

Crystal

 

From: Juthe, Robin (NIH/NCI) [E] <robin.juthe@nih.gov>
Sent: Thursday, December 3, 2020 3:34 PM
To: Kline, Robert (NCI) <bkline@rksystems.com>; Sershen, Crystal (NIH/NCI) [C] <crystal.sershen@nih.gov>
Subject: RE: .doc files

 

Thanks for looking into this, Bob! I’ve added Crystal to the email.

 

Crystal, Bob is investigating the issue you had with uploading a .doc file in the EBMS and he was able to upload a .doc file on a lower tier. Please see his questions below and send along the file you had problems uploading if possible. Have you tried uploading any other .doc files? If not, he thought it could have been an issue with the one file rather than the extension. Thank you!

 

Robin

 

From: Bob Kline <bkline@rksystems.com>
Sent: Thursday, December 3, 2020 3:20 PM
To: Juthe, Robin (NIH/NCI) [E] <robin.juthe@nih.gov>
Subject: .doc files

 

Hi, Robin. I was able to upload a .doc file and link to it from an agenda on DEV. Some questions:

  1. Can you pass along the .doc file which failed?

  2. Can you provide the steps for reproducing the failure on another tier?

  3. Has another document been tried on PROD?

Thanks!

 

--

Bob Kline

https://www.rksystems.com

mailto:[bkline@rksystems.com|mailto:bkline@rksystems.com]

Comment entered 2020-12-04 10:20:32 by Kline, Bob (NIH/NCI) [C]

Ready for testing on QA.

Comment entered 2020-12-04 10:47:46 by Juthe, Robin (NIH/NCI) [E]

Thanks, Bob. I uploaded the same two files on QA without a problem.

Comment entered 2020-12-04 11:32:37 by Kline, Bob (NIH/NCI) [C]

Ticket submitted to have CBIIT deploy the patch to STAGE. 

NCI-RITM0267896

Comment entered 2020-12-23 11:08:37 by Kline, Bob (NIH/NCI) [C]

The patch has been deployed to production. Please verify (and close ticket if appropriate).

Comment entered 2021-01-19 08:21:01 by Kline, Bob (NIH/NCI) [C]

 - Can you check with Crystal to confirm that this is working again, and if so close this ticket, please? Thanks!

Comment entered 2021-01-19 08:46:03 by Shields, Victoria (NIH/NCI) [E]

Crystal is off today, but I was able to download them last week after you notified us, so this is fixed. Thanks!

Comment entered 2021-01-19 08:59:45 by Kline, Bob (NIH/NCI) [C]

Super, thanks!

Elapsed: 0:00:00.000730