search

NSLS-II / lsdc

LSDC - Life Sciences Data Collection
https://nsls-ii.github.io/lsdc
BSD 3-Clause "New" or "Revised" License
3 stars 14 forks source link

proposal number issues #117

Closed JunAishima closed 3 years ago

JunAishima commented 3 years ago

Wuxian uploaded a spreadsheet on FMX at 17:37 yesterday (2021-09-07) and parseSheet shows the proposal number of 305000.

However, when she actually sets up a collection and tries to add it to the queue with Add Requests to Queue, the proposal number seems to get set back to 999999.

Note that during the day, data has gotten collected into 999999-1234, and jpegs are getting collected into mx999999-???? with several variants. the files are written into a directory path that includes L/xf17id2/FMX-999999_07Sep2021, which looks like it's parsing the full directory.

The latter may be due to the fact that the "current" proposal number (305000) is not in the full path - so testing with FMX-305000_07Sep2021 might have worked. lots to check anyways

Complicating factor: GUI logs show that there are issues with the database-side things - Session_has_Person constraint. need to verify who is authorized to be on 305000. This may be preventing the new visit from being used.

JunAishima commented 3 years ago

some of the major issues with not being able to have Session_has_Person connections was solved by mysql-connector-python conda package being regressed from 8.0.25 to 8.0.18 (same as previous LSDC envs). testing will tell us whether that solved the entire issue

JunAishima commented 3 years ago

As shown in my earlier comment, https://github.com/NSLS-II/conda-pack-template/pull/39/commits/a9c494e28a4f75b0be6d28d8b44646d6f6430088 fixes this issue.