EBMS Tickets

Issue Number 814
Summary [Import] Unable to import file for one specific IACT summary topic
Created 2024-02-27 11:52:35
Issue Type Bug
Submitted By Boggess, Cynthia (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2024-03-07 09:46:15
Resolution Fixed
Path /home/bkline/backups/jira/oceebms/issue.392907
Description

While importing March 2024 citations this morning, I tried multiple times to import a file of 21 citations for "Aromatherapy with Essential Oils" and got a please try again later error message each time. However, 5 citations for this topic with March review cycle are retrievable in the database with 4 appearing in the queue. There is no import report for any of my attempts. Import attempts for this topic started at about 9:38am. Attempts were made with the original file and a recreated file to make sure the file was not the issue. I am attaching both files.

Comment entered 2024-02-27 15:00:09 by Kline, Bob (NIH/NCI) [C]

Which options were selected for the import?

Comment entered 2024-02-27 15:23:28 by Boggess, Cynthia (NIH/NCI) [C]

IACT = board

Aromatherapy with Essential Oils = summary topic

March 2024 review cycle

Comment entered 2024-02-27 17:06:08 by Kline, Bob (NIH/NCI) [C]

I was referring to these options:

Comment entered 2024-02-27 17:14:09 by Kline, Bob (NIH/NCI) [C]

Rats! JIRA swallowed another comment. 🙁

It seems that NLM's idea of what "brief journal title" doesn't match ours. Our journal refresh script is blowing up when it tries to insert "Ethical Philos Issues Med Imaging Multimodal Learn Fusion Across Scales Clin Decis Support Topol Data Anal Biomed Imaging (2022)" into the brief_title column of the ebms_journal table. Still trying to figure out if that's the cause of the failures you ran into, but there's a distinct possibility that because the refresh script fails the import script is stumbling when it tries to determine whether a journal it doesn't know about is a core journal.

Comment entered 2024-02-27 17:45:57 by Kline, Bob (NIH/NCI) [C]

Please try the import job again.

Comment entered 2024-02-28 09:25:43 by Boggess, Cynthia (NIH/NCI) [C]

none selected

Comment entered 2024-02-28 09:32:26 by Boggess, Cynthia (NIH/NCI) [C]

It worked! all 21 imported and I can see an import report. Thanks Bob!

Comment entered 2024-02-28 09:33:31 by Boggess, Cynthia (NIH/NCI) [C]

Wow that is an unusual title that I have not seen before.

Comment entered 2024-03-07 09:46:15 by Kline, Bob (NIH/NCI) [C]

Update hook created to increase the size of the brief_title column.

Comment entered 2024-04-18 10:06:27 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD. Thanks!

Attachments
File Name Posted User
aroma_21_a.txt 2024-02-27 11:51:19 Boggess, Cynthia (NIH/NCI) [C]
aroma_21.txt 2024-02-27 11:51:19 Boggess, Cynthia (NIH/NCI) [C]
image-2024-02-27-17-06-03-321.png 2024-02-27 17:06:04 Kline, Bob (NIH/NCI) [C]

Elapsed: 0:00:00.000599