Load Holdings: Add support for old statuses date format

Description

Issue:
Date format was changed in this PR: MODKBEKBJ-440. ("2020-07-25 19:12:29.029Z" -> "2022-03-09T01:33:41.726323Z")
But because some of the clients still have old statuses saved in data base with the old date format. New module can't parse it.

Approach

  • Add support for old date format
    OR

  • Create script to reparse fields with old date format to new one

Logs:

85381314,17:16:21 [367938/eholdings] [fs00000002] [] [mod_kb_ebsco_java] INFO  RestRouting          invoking postEholdingsLoadingKbCredentials 1664385381315,17:16:21 [367938/eholdings] [fs00000002] [] [mod_kb_ebsco_java] INFO  LoadHoldingsImpl     Received signal to start scheduled loading of holdings 1664385381324,17:16:21 [367938/eholdings] [fs00000002] [] [mod_kb_ebsco_java] ERROR ErrorHandler         Internal Server Error 1664385381324,java.time.format.DateTimeParseException: Text '2020-07-25 19:12:29.029Z' could not be parsed at index 10 1664385381324,    at java.time.format.DateTimeFormatter.parseResolved0(DateTimeFormatter.java:2046) ~[?:?] 1664385381324,    at java.time.format.DateTimeFormatter.parse(DateTimeFormatter.java:1948) ~[?:?] 1664385381324,    at java.time.OffsetDateTime.parse(OffsetDateTime.java:402) ~[?:?] 1664385381324,    at org.folio.service.holdings.HoldingsServiceImpl.getZonedDateTime(HoldingsServiceImpl.java:495) ~[ms.jar:?] 1664385381324,    at org.folio.service.holdings.HoldingsServiceImpl.isHangedLoading(HoldingsServiceImpl.java:336) ~[ms.jar:?] 1664385381324,    at org.folio.service.holdings.HoldingsServiceImpl.canChangeStatus(HoldingsServiceImpl.java:332) ~[ms.jar:?] 1664385381324,    at java.util.stream.MatchOps$1MatchSink.accept(MatchOps.java:90) ~[?:?] 1664385381325,17:16:21 [367938/eholdings] [fs00000002] [] [mod_kb_ebsco_java] INFO  LogUtil              127.0.0.1:56904 POST /eholdings/loading/kb-credentials null HTTP_1_1 500 107 10 tid=fs00000002 Internal Server Error  1664385381390,17:16:21 [513971/eholdings] [fs00001022] [] [mod_kb_ebsco_java] INFO  RestRouting          invoking postEholdingsLoadingKbCredentials 1664385381390,17:16:21 [513971/eholdings] [fs00001022] [] [mod_kb_ebsco_java] INFO  LoadHoldingsImpl     Received signal to start scheduled loading of holdings 1664385381395,17:16:21 [513971/eholdings] [fs00001022] [] [mod_kb_ebsco_java] ERROR ErrorHandler         Internal Server Error

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Checklist

hide

TestRail: Results

Activity

Show:
Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Spitfire

Fix versions

Release

Morning Glory (R2 2022) Hot Fix #1

RCA Group

Institution specific (Unexpected usage scenario)

CSP Approved

Yes

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created October 3, 2022 at 11:05 AM
Updated November 30, 2022 at 4:45 PM
Resolved October 26, 2022 at 3:20 PM
TestRail: Cases
TestRail: Runs

Flag notifications