Get "No file image" when loading current Mur.

[fec-jli]

When loading curent Mur locally We got some messages: No file image. ex: mur_5047, mur_4852

[lbeaufort]

@fec-jli it looks like these MURs won't load on production - https://www.fec.gov/data/legal/matter-under-review/4852/

Let's check with @PaulClark2 and @AmyKort about prioritizing this issue. I think Salient uploads the images.

[lbeaufort]

I reached out to Srini, who said they are investigating.

Hi Srini,

MUR 4852 is missing document file images, making it so it can't be loaded in production: https://www.fec.gov/data/legal/matter-under-review/4852/

SELECT
         doc.document_id,
         mur.case_no,
         mur.case_type,
         doc.filename,
         doc.fileimage,
         doc.category,
         doc.description,
         doc.ocrtext,
         doc.fileimage,
         length(fileimage) AS length,
         doc.doc_order_id,
         doc.document_date
     FROM fecmur.document doc
     INNER JOIN fecmur.cases_with_parsed_case_serial_numbers_vw mur
         ON mur.case_id = doc.case_id
     WHERE doc.fileimage IS NULL or doc.fileimage = ''
     ORDER BY doc.doc_order_id, doc.document_date desc, doc.document_id DESC;

MUR 6747 is also missing a file image, but it looks like it was last loaded when it had the image so it's not symptomatic on production, but it will be if we reload them.

Can you please take a look? I believe Salient provides those MUR document images.

Thank you!

[PaulClark2]

MUR 4852 has been republished, https://www.fec.gov/data/legal/matter-under-review/4852/. MUR 6747 is still missing an image.

[lbeaufort]

File images no longer blank or NULL and both MURs load

https://www.fec.gov/data/legal/matter-under-review/6747/ https://www.fec.gov/data/legal/matter-under-review/4852/