buda-base / drs-deposit

Harvard DRS Deposit base
1 stars 0 forks source link

GetReadyWorks invalid output #119

Closed jimk-bdrc closed 5 months ago

jimk-bdrc commented 11 months ago

In DRSQA, trying to retrieve the next set of ready works includes SQLExceptions in the output.

getReadyWorks.py:157         return rl

rl=[
[{'HOLLIS': '14253172', 'OutlineUrn': 91856, 'PrintMasterUrn': None, 'Queued': b'\x00', 'Volume': 'W00CHZ0103335-I00CHZ0103337', 'WorkName': 'W00CHZ0103335'}], 
[{'SQLException in loop': 'SQLException in loop'}], 
[ ]
]

First, there's an issue with getReadyWorks that is throwing an exception in a loop (could be a data issue due to QA), second, that exception should not be appearing in the output. If there is an exception anywhere, it should be passed from the sproc.