@timestamp,@message 2021-10-27 22:01:22.479,"22:01:22 INFO SubPublishingService Event published successfully. ID: c88f3a42-63db-4a6c-9680-1860e9c39141, type: ITEM_CHECKED_OUT, payload: {""userId"":""a2679443-89fe-4e88-b4f1-ac423e019a7e"",""loanId"":""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a"",""dueDate"":""2021-10-27T22:06:07.000Z""}" 2021-10-27 22:01:22.489,"22:01:22 INFO SubPublishingService Event published successfully. ID: 1b86b9ac-35c8-4097-81ee-0b58c81c929d, type: LOG_RECORD, payload: {""logEventType"":""CHECK_OUT_EVENT"",""servicePointId"":""a3cbfa53-3e36-4cbc-8213-85848623d73b"",""loanId"":""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a"",""isLoanClosed"":false,""dueDate"":""2021-10-27T22:06:07.000Z"",""userId"":""a2679443-89fe-4e88-b4f1-ac423e019a7e"",""userBarcode"":""8377630"",""itemId"":""3146da1c-5a2c-455d-93a5-51543c39c706"",""itemBarcode"":""10632474"",""itemStatusName"":""Checked out"",""holdingsRecordId"":""5ceb2d5d-cd21-4791-ba81-2dc9cfd11022"",""instanceId"":""0025c6dd-fd8c-4d7e-bddd-a9c2d0d947f4"",""source"":""Doe, Z""}" 2021-10-27 22:01:22.529,"22:01:22 INFO LogHelper POST scheduled patron notice succeeded: ScheduledNotice{id='b9e81902-5621-40d6-a907-9cbb6eb9e1b6', loanId='164a39c7-1d8e-4ba9-8230-7d3b60f72a6a', requestId='null', recipientUserId='a2679443-89fe-4e88-b4f1-ac423e019a7e', feeFineActionId='null', triggeringEvent='Due date', nextRunTime=2021-10-27T22:01:07.000Z, configuration=ScheduledNoticeConfig{timing='Before', recurringPeriod=null, templateId='140a6bc0-7610-4f3a-bd14-9303dcf0f1a0', format='Email', sendInRealTime=true}}" 2021-10-27 22:01:22.536,"22:01:22 INFO LogHelper POST scheduled patron notice succeeded: ScheduledNotice{id='4047a021-2d84-4925-94f7-a8e082b4effb', loanId='164a39c7-1d8e-4ba9-8230-7d3b60f72a6a', requestId='null', recipientUserId='a2679443-89fe-4e88-b4f1-ac423e019a7e', feeFineActionId='null', triggeringEvent='Due date', nextRunTime=2021-10-27T22:07:07.000Z, configuration=ScheduledNoticeConfig{timing='After', recurringPeriod=Period{duration=1, interval='Minutes'}, templateId='565f41c7-5c8d-46b9-9dcb-ac4117349368', format='Email', sendInRealTime=true}}" 2021-10-27 22:01:22.675," ""loanId"" : ""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a""," 2021-10-27 22:01:23.021,22:01:23 [730360/circulation;029855/accounts] [fs09000000] [] [] INFO ProxyContext 730360/circulation;029855/accounts RES 202 1462us mod-authtoken-2.8.0 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-authtoken/accounts?query=loanId%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 2021-10-27 22:01:23.027,"22:01:23 [] [] [] [] INFO CQLWrapper CQL >>> SQL: loanId==(""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a"") >>>WHERE CASE WHEN length(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) END LIMIT 2147483647 OFFSET 0" 2021-10-27 22:01:23.036,22:01:23 [730360/circulation;029855/accounts] [fs09000000] [] [] INFO ProxyContext 730360/circulation;029855/accounts RES 200 15352us mod-feesfines-16.1.1 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-feesfines/accounts?query=loanId%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 2021-10-27 22:01:23.036,22:01:23 [] [] [] [] INFO LogUtil 127.0.0.1:40810 GET /accounts query=loanId%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 HTTP_1_1 200 136 13 tid=fs09000000 OK 2021-10-27 22:01:23.268,"10.23.38.176 - - [27/Oct/2021:22:01:23 +0000] ""GET /mod-authtoken/accounts?query=loanId%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 HTTP/1.1"" 202 5 rt=0.000 uct=""0.000"" uht=""0.000"" urt=""0.000"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""5bd84d84-dc5b-4954-8980-a0fcaf0195c6"" ""730360/circulation;029855/accounts""" 2021-10-27 22:01:23.651,"10.23.36.34 - 10.23.38.176 - - [27/Oct/2021:22:01:23 +0000] ""GET /accounts?query=loanId%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 HTTP/1.1"" 200 147 rt=0.022 uct=""0.000"" uht=""0.020"" urt=""0.020"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""5bd84d84-dc5b-4954-8980-a0fcaf0195c6"" ""730360/circulation""" 2021-10-27 22:01:23.667,"10.23.38.176 - - [27/Oct/2021:22:01:23 +0000] ""GET /mod-feesfines/accounts?query=loanId%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 HTTP/1.1"" 200 147 rt=0.014 uct=""0.000"" uht=""0.012"" urt=""0.012"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""5bd84d84-dc5b-4954-8980-a0fcaf0195c6"" ""730360/circulation;029855/accounts""" 2021-10-27 22:01:41.773,22:01:41 INFO SingleRecordFetcher Fetching loan with ID: 164a39c7-1d8e-4ba9-8230-7d3b60f72a6a 2021-10-27 22:01:41.776,22:01:41 [112312/circulation;129744/loan-storage] [fs09000000] [] [] INFO ProxyContext 112312/circulation;129744/loan-storage REQ 10.23.38.67:61022 fs09000000 GET /loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a mod-authtoken-2.8.0 mod-circulation-storage-13.0.0 2021-10-27 22:01:41.783,22:01:41 [112312/circulation;129744/loan-storage] [fs09000000] [] [] INFO ProxyContext 112312/circulation;129744/loan-storage RES 202 3494us mod-authtoken-2.8.0 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-authtoken/loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a 2021-10-27 22:01:41.795,22:01:41 [] [] [] [] INFO LogUtil 127.0.0.1:47508 GET /loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a null HTTP_1_1 200 1004 9 tid=fs09000000 OK 2021-10-27 22:01:41.796,22:01:41 [112312/circulation;129744/loan-storage] [fs09000000] [] [] INFO ProxyContext 112312/circulation;129744/loan-storage RES 200 12869us mod-circulation-storage-13.0.0 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-circulation-storage/loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a 2021-10-27 22:01:41.946,"10.23.38.67 - - [27/Oct/2021:22:01:41 +0000] ""GET /mod-circulation-storage/loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a HTTP/1.1"" 200 1016 rt=0.010 uct=""0.000"" uht=""0.008"" urt=""0.008"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""-"" ""112312/circulation;129744/loan-storage""" 2021-10-27 22:01:42.259,"22:01:42 INFO SubPublishingService Event published successfully. ID: 639818c5-544b-4f9b-b3b4-b4f97917f488, type: LOG_RECORD, payload: {""logEventType"":""NOTICE"",""payload"":{""userBarcode"":""8377630"",""items"":[{""itemBarcode"":""10632474"",""itemId"":""3146da1c-5a2c-455d-93a5-51543c39c706"",""instanceId"":""0025c6dd-fd8c-4d7e-bddd-a9c2d0d947f4"",""holdingsRecordId"":""5ceb2d5d-cd21-4791-ba81-2dc9cfd11022"",""loanId"":""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a"",""servicePointId"":""a3cbfa53-3e36-4cbc-8213-85848623d73b"",""templateId"":""140a6bc0-7610-4f3a-bd14-9303dcf0f1a0"",""noticePolicyId"":""c083c844-56d6-4326-a2fd-4acf81ca088a"",""triggeringEvent"":""Due date""}],""date"":""2021-10-27T22:01:42.210Z""}}" 2021-10-27 22:01:42.272,"10.23.38.67 - - [27/Oct/2021:22:01:41 +0000] ""GET /mod-authtoken/loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a HTTP/1.1"" 202 5 rt=0.001 uct=""0.000"" uht=""0.000"" urt=""0.000"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""-"" ""112312/circulation;129744/loan-storage""" 2021-10-27 22:01:42.291,"22:01:42 INFO LogHelper DELETE scheduled patron notice succeeded: ScheduledNotice{id='b9e81902-5621-40d6-a907-9cbb6eb9e1b6', loanId='164a39c7-1d8e-4ba9-8230-7d3b60f72a6a', requestId='null', recipientUserId='a2679443-89fe-4e88-b4f1-ac423e019a7e', feeFineActionId='null', triggeringEvent='Due date', nextRunTime=2021-10-27T22:01:07.000Z, configuration=ScheduledNoticeConfig{timing='Before', recurringPeriod=null, templateId='140a6bc0-7610-4f3a-bd14-9303dcf0f1a0', format='Email', sendInRealTime=true}}" 2021-10-27 22:01:42.653,"10.23.36.34 - 10.23.38.67 - - [27/Oct/2021:22:01:41 +0000] ""GET /loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a HTTP/1.1"" 200 1016 rt=0.022 uct=""0.004"" uht=""0.024"" urt=""0.024"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""-"" ""112312/circulation""" 2021-10-27 22:03:47.749,22:03:47 [076958/circulation;885064/loan-storage] [fs09000000] [] [] INFO ProxyContext 076958/circulation;885064/loan-storage RES 202 37658us mod-authtoken-2.8.0 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-authtoken/loan-storage/loans?query=id%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 2021-10-27 22:03:47.758,"22:03:47 [] [] [] [] INFO CQLWrapper CQL >>> SQL: id==(""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a"") >>>WHERE id='164a39c7-1d8e-4ba9-8230-7d3b60f72a6a' LIMIT 2147483647 OFFSET 0" 2021-10-27 22:03:47.765,22:03:47 [] [] [] [] INFO LogUtil 127.0.0.1:47782 GET /loan-storage/loans query=id%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 HTTP_1_1 200 1092 12 tid=fs09000000 OK 2021-10-27 22:03:47.765,22:03:47 [076958/circulation;885064/loan-storage] [fs09000000] [] [] INFO ProxyContext 076958/circulation;885064/loan-storage RES 200 16395us mod-circulation-storage-13.0.0 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-circulation-storage/loan-storage/loans?query=id%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 2021-10-27 22:03:47.977,"10.23.38.67 - - [27/Oct/2021:22:03:47 +0000] ""GET /mod-circulation-storage/loan-storage/loans?query=id%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 HTTP/1.1"" 200 1104 rt=0.013 uct=""0.000"" uht=""0.016"" urt=""0.016"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""9eb67301-6f6e-468f-9b1a-6134dc39a684"" ""076958/circulation;885064/loan-storage""" 2021-10-27 22:03:48.304,"10.23.38.67 - - [27/Oct/2021:22:03:47 +0000] ""GET /mod-authtoken/loan-storage/loans?query=id%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 HTTP/1.1"" 202 5 rt=0.035 uct=""0.000"" uht=""0.036"" urt=""0.036"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""9eb67301-6f6e-468f-9b1a-6134dc39a684"" ""076958/circulation;885064/loan-storage""" 2021-10-27 22:03:48.665,"10.23.36.34 - 10.23.38.176 - - [27/Oct/2021:22:03:47 +0000] ""GET /loan-storage/loans?query=id%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 HTTP/1.1"" 200 1104 rt=0.059 uct=""0.000"" uht=""0.060"" urt=""0.060"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""9eb67301-6f6e-468f-9b1a-6134dc39a684"" ""076958/circulation""" 2021-10-27 22:03:48.840,"22:03:48 INFO SubPublishingService Event published successfully. ID: 12412805-5df2-4c41-954b-21f896cdb809, type: LOG_RECORD, payload: {""logEventType"":""NOTICE"",""payload"":{""userBarcode"":""8377630"",""items"":[{""itemBarcode"":""10632474"",""itemId"":""3146da1c-5a2c-455d-93a5-51543c39c706"",""instanceId"":""0025c6dd-fd8c-4d7e-bddd-a9c2d0d947f4"",""holdingsRecordId"":""5ceb2d5d-cd21-4791-ba81-2dc9cfd11022"",""loanId"":""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a"",""servicePointId"":""a3cbfa53-3e36-4cbc-8213-85848623d73b"",""templateId"":""17440998-3c8c-4115-af27-62c0be7489d3"",""noticePolicyId"":""c083c844-56d6-4326-a2fd-4acf81ca088a"",""triggeringEvent"":""Check out""}],""date"":""2021-10-27T22:03:48.721Z""}}" 2021-10-27 22:08:28.142,22:08:28 [828141/circulation;236420/loan-storage] [fs09000000] [] [] INFO ProxyContext 828141/circulation;236420/loan-storage REQ 10.23.38.67:2458 fs09000000 PUT /loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a mod-authtoken-2.8.0 mod-circulation-storage-13.0.0 2021-10-27 22:08:28.146,22:08:28 [828141/circulation;236420/loan-storage] [fs09000000] [] [] INFO ProxyContext 828141/circulation;236420/loan-storage RES 202 2297us mod-authtoken-2.8.0 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-authtoken/loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a 2021-10-27 22:08:28.173,22:08:28 [828141/circulation;236420/loan-storage] [fs09000000] [] [] INFO ProxyContext 828141/circulation;236420/loan-storage RES 204 26886us mod-circulation-storage-13.0.0 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-circulation-storage/loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a 2021-10-27 22:08:28.173,22:08:28 [] [] [] [] INFO LogUtil 127.0.0.1:48302 PUT /loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a null HTTP_1_1 204 0 23 tid=fs09000000 No Content 2021-10-27 22:08:28.175,22:08:28 INFO SingleRecordFetcher Fetching loan with ID: 164a39c7-1d8e-4ba9-8230-7d3b60f72a6a 2021-10-27 22:08:28.177,22:08:28 [828141/circulation;837525/loan-storage] [fs09000000] [] [] INFO ProxyContext 828141/circulation;837525/loan-storage REQ 10.23.38.176:10972 fs09000000 GET /loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a mod-authtoken-2.8.0 mod-circulation-storage-13.0.0 2021-10-27 22:08:28.181,22:08:28 [828141/circulation;837525/loan-storage] [fs09000000] [] [] INFO ProxyContext 828141/circulation;837525/loan-storage RES 202 1585us mod-authtoken-2.8.0 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-authtoken/loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a 2021-10-27 22:08:28.193,22:08:28 [] [] [] [] INFO LogUtil 127.0.0.1:48306 GET /loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a null HTTP_1_1 200 1173 9 tid=fs09000000 OK 2021-10-27 22:08:28.194,22:08:28 [828141/circulation;837525/loan-storage] [fs09000000] [] [] INFO ProxyContext 828141/circulation;837525/loan-storage RES 200 12719us mod-circulation-storage-13.0.0 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-circulation-storage/loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a 2021-10-27 22:08:28.375,"10.23.38.176 - - [27/Oct/2021:22:08:28 +0000] ""PUT /mod-authtoken/loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a HTTP/1.1"" 202 5 rt=0.001 uct=""0.000"" uht=""0.000"" urt=""0.000"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""5bd84d84-dc5b-4954-8980-a0fcaf0195c6"" ""828141/circulation;236420/loan-storage""" 2021-10-27 22:08:28.375,"10.23.38.176 - - [27/Oct/2021:22:08:28 +0000] ""GET /mod-authtoken/loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a HTTP/1.1"" 202 5 rt=0.000 uct=""0.000"" uht=""0.000"" urt=""0.000"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""5bd84d84-dc5b-4954-8980-a0fcaf0195c6"" ""828141/circulation;837525/loan-storage""" 2021-10-27 22:08:28.522,22:08:28 [828141/circulation;113838/scheduled-notice-storage] [fs09000000] [] [] INFO ProxyContext 828141/circulation;113838/scheduled-notice-storage RES 403 3229us mod-authtoken-2.8.0 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-authtoken/scheduled-notice-storage/scheduled-notices?query=loanId%3D%3D%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20and%20triggeringEvent%3D%3D%22Due%20date%22%20and%20noticeConfig.timing%3D%3D%28%22Upon%20At%22%20or%20%22After%22%29 2021-10-27 22:08:28.524,"22:08:28 ERROR LogHelper DELETE scheduled patron notices by query failed: A CQL query of ""loanId==""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a"" and triggeringEvent==""Due date"" and noticeConfig.timing==(""Upon At"" or ""After"")"". Cause: [403] Access requires permission: scheduled-notice-storage.scheduled-notices.collection.delete" 2021-10-27 22:08:28.554,"22:08:28 ERROR LogHelper POST scheduled patron notice failed: ScheduledNotice{id='c8e9f299-76c6-4737-a030-143ed572e107', loanId='164a39c7-1d8e-4ba9-8230-7d3b60f72a6a', requestId='null', recipientUserId='a2679443-89fe-4e88-b4f1-ac423e019a7e', feeFineActionId='5566cc23-b56f-40c3-a7fe-7c7bcb71b682', triggeringEvent='Overdue fine returned', nextRunTime=2021-10-28T22:08:28.479Z, configuration=ScheduledNoticeConfig{timing='After', recurringPeriod=Period{duration=1, interval='Days'}, templateId='2735655d-7857-48ad-bf5b-4d3b30594844', format='Email', sendInRealTime=true}}. Cause: [403] Access requires permission: scheduled-notice-storage.scheduled-notices.item.post" 2021-10-27 22:08:28.556,"22:08:28 ERROR LogHelper POST scheduled patron notice failed: ScheduledNotice{id='9dfcff43-4be2-48d3-9db5-ea23e469acc4', loanId='164a39c7-1d8e-4ba9-8230-7d3b60f72a6a', requestId='null', recipientUserId='a2679443-89fe-4e88-b4f1-ac423e019a7e', feeFineActionId='5566cc23-b56f-40c3-a7fe-7c7bcb71b682', triggeringEvent='Overdue fine returned', nextRunTime=2021-10-27T22:08:28.479Z, configuration=ScheduledNoticeConfig{timing='Upon At', recurringPeriod=null, templateId='2735655d-7857-48ad-bf5b-4d3b30594844', format='Email', sendInRealTime=true}}. Cause: [403] Access requires permission: scheduled-notice-storage.scheduled-notices.item.post" 2021-10-27 22:08:28.571,"22:08:28 INFO SubPublishingService Event published successfully. ID: 210a587d-b463-4b4b-9d50-bef7cbfc80bc, type: ITEM_CHECKED_IN, payload: {""userId"":""a2679443-89fe-4e88-b4f1-ac423e019a7e"",""loanId"":""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a"",""returnDate"":""2021-10-27T22:08:13.000Z""}" 2021-10-27 22:08:28.584,"22:08:28 INFO SubPublishingService Event published successfully. ID: 21636304-233e-4d97-aedb-98330b8836a8, type: LOG_RECORD, payload: {""logEventType"":""CHECK_IN_EVENT"",""servicePointId"":""a3cbfa53-3e36-4cbc-8213-85848623d73b"",""loanId"":""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a"",""isLoanClosed"":true,""systemReturnDate"":""2021-10-27T22:08:27.604Z"",""returnDate"":""2021-10-27T22:08:13.000Z"",""dueDate"":""2021-10-27T22:06:07.000Z"",""userId"":""a2679443-89fe-4e88-b4f1-ac423e019a7e"",""userBarcode"":""8377630"",""itemId"":""3146da1c-5a2c-455d-93a5-51543c39c706"",""itemBarcode"":""10632474"",""itemStatusName"":""In transit"",""holdingsRecordId"":""5ceb2d5d-cd21-4791-ba81-2dc9cfd11022"",""instanceId"":""0025c6dd-fd8c-4d7e-bddd-a9c2d0d947f4"",""destinationServicePoint"":""Regenstein Circulation, 1st Floor"",""source"":""Doe, Z""}" 2021-10-27 22:08:28.606," ""loanId"" : ""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a""," 2021-10-27 22:08:28.614," ""loanId"" : ""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a""," 2021-10-27 22:08:28.690,"10.23.36.34 - 10.23.38.67 - - [27/Oct/2021:22:08:28 +0000] ""PUT /loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a HTTP/1.1"" 204 0 rt=0.035 uct=""0.000"" uht=""0.036"" urt=""0.036"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""5bd84d84-dc5b-4954-8980-a0fcaf0195c6"" ""828141/circulation""" 2021-10-27 22:08:28.690,"10.23.36.34 - 10.23.38.67 - - [27/Oct/2021:22:08:28 +0000] ""GET /loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a HTTP/1.1"" 200 1185 rt=0.019 uct=""0.000"" uht=""0.020"" urt=""0.020"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""5bd84d84-dc5b-4954-8980-a0fcaf0195c6"" ""828141/circulation""" 2021-10-27 22:08:28.690,"10.23.36.34 - 10.23.38.67 - - [27/Oct/2021:22:08:28 +0000] ""DELETE /scheduled-notice-storage/scheduled-notices?query=loanId%3D%3D%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20and%20triggeringEvent%3D%3D%22Due%20date%22%20and%20noticeConfig.timing%3D%3D%28%22Upon%20At%22%20or%20%22After%22%29 HTTP/1.1"" 403 99 rt=0.010 uct=""0.000"" uht=""0.012"" urt=""0.012"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""5bd84d84-dc5b-4954-8980-a0fcaf0195c6"" ""828141/circulation""" 2021-10-27 22:08:28.690,"140.234.253.9, 10.23.36.34 - 10.23.38.67 - - [27/Oct/2021:22:08:28 +0000] ""OPTIONS /accounts?query=loanId==%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22 HTTP/1.1"" 204 0 rt=0.002 uct=""0.000"" uht=""0.000"" urt=""0.000"" ""Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0"" ""-"" ""-"" ""-""" 2021-10-27 22:08:28.737,22:08:28 [407269/accounts] [fs09000000] [5bd84d84-dc5b-4954-8980-a0fcaf0195c6] [] INFO ProxyContext 407269/accounts RES 202 2211us mod-authtoken-2.8.0 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-authtoken/accounts?query=loanId==%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22 2021-10-27 22:08:28.743,"22:08:28 [] [] [] [] INFO CQLWrapper CQL >>> SQL: loanId==""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a"" >>>WHERE CASE WHEN length(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) END LIMIT 10 OFFSET 0" 2021-10-27 22:08:28.798,22:08:28 [407269/accounts] [fs09000000] [5bd84d84-dc5b-4954-8980-a0fcaf0195c6] [] INFO ProxyContext 407269/accounts RES 200 61268us mod-feesfines-16.1.1 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-feesfines/accounts?query=loanId==%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22 2021-10-27 22:08:28.798,22:08:28 [] [] [] [] INFO LogUtil 127.0.0.1:42046 GET /accounts query=loanId==%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22 HTTP_1_1 200 1487 59 tid=fs09000000 OK 2021-10-27 22:08:28.976,"22:08:28 [] [] [] [] INFO CQLWrapper CQL >>> SQL: (userId==a2679443-89fe-4e88-b4f1-ac423e019a7e and itemId==3146da1c-5a2c-455d-93a5-51543c39c706 and loanId==164a39c7-1d8e-4ba9-8230-7d3b60f72a6a) and status.name==""Open"" >>>WHERE (((CASE WHEN length(lower(f_unaccent('a2679443-89fe-4e88-b4f1-ac423e019a7e'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'userId')),600) LIKE lower(f_unaccent('a2679443-89fe-4e88-b4f1-ac423e019a7e')) ELSE left(lower(f_unaccent(accounts.jsonb->>'userId')),600) LIKE left(lower(f_unaccent('a2679443-89fe-4e88-b4f1-ac423e019a7e')),600) AND lower(f_unaccent(accounts.jsonb->>'userId')) LIKE lower(f_unaccent('a2679443-89fe-4e88-b4f1-ac423e019a7e')) END) AND (lower(f_unaccent(accounts.jsonb->>'itemId')) LIKE lower(f_unaccent('3146da1c-5a2c-455d-93a5-51543c39c706')))) AND (CASE WHEN length(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) END)) AND (lower(f_unaccent(accounts.jsonb->'status'->>'name')) LIKE lower(f_unaccent('Open'))) LIMIT 10 OFFSET 0" 2021-10-27 22:08:29.022,22:08:29 [747705/accounts] [fs09000000] [5bd84d84-dc5b-4954-8980-a0fcaf0195c6] [] INFO ProxyContext 747705/accounts RES 200 53931us mod-feesfines-16.1.1 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-feesfines/accounts?query=%28userId%3D%3Da2679443-89fe-4e88-b4f1-ac423e019a7e%20and%20itemId%3D%3D3146da1c-5a2c-455d-93a5-51543c39c706%20and%20loanId%3D%3D164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%29%20and%20status.name%3D%3D%22Open%22 2021-10-27 22:08:29.022,22:08:29 [] [] [] [] INFO LogUtil 127.0.0.1:42090 GET /accounts query=%28userId%3D%3Da2679443-89fe-4e88-b4f1-ac423e019a7e%20and%20itemId%3D%3D3146da1c-5a2c-455d-93a5-51543c39c706%20and%20loanId%3D%3D164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%29%20and%20status.name%3D%3D%22Open%22 HTTP_1_1 200 1487 51 tid=fs09000000 OK 2021-10-27 22:08:29.029,"140.234.253.9 - 10.23.39.151 - - [27/Oct/2021:22:08:28 +0000] ""OPTIONS /accounts?query=loanId==%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22 HTTP/1.1"" 204 0 rt=0.004 uct=""0.000"" uht=""0.004"" urt=""0.004"" ""Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0"" ""-"" ""-"" ""-""" 2021-10-27 22:08:29.029,"140.234.253.9 - 10.23.39.151 - - [27/Oct/2021:22:08:28 +0000] ""GET /accounts?query=loanId==%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22 HTTP/1.1"" 200 754 rt=0.082 uct=""0.000"" uht=""0.084"" urt=""0.084"" ""Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0"" ""fs09000000"" ""-"" ""-""" 2021-10-27 22:08:29.029,"140.234.253.9 - 10.23.39.151 - - [27/Oct/2021:22:08:28 +0000] ""OPTIONS /accounts?query=%28userId%3D%3Da2679443-89fe-4e88-b4f1-ac423e019a7e%20and%20itemId%3D%3D3146da1c-5a2c-455d-93a5-51543c39c706%20and%20loanId%3D%3D164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%29%20and%20status.name%3D%3D%22Open%22 HTTP/1.1"" 204 0 rt=0.002 uct=""0.000"" uht=""0.000"" urt=""0.000"" ""Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0"" ""-"" ""-"" ""-""" 2021-10-27 22:08:29.029,"140.234.253.9 - 10.23.39.151 - - [27/Oct/2021:22:08:29 +0000] ""GET /accounts?query=%28userId%3D%3Da2679443-89fe-4e88-b4f1-ac423e019a7e%20and%20itemId%3D%3D3146da1c-5a2c-455d-93a5-51543c39c706%20and%20loanId%3D%3D164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%29%20and%20status.name%3D%3D%22Open%22 HTTP/1.1"" 200 754 rt=0.061 uct=""0.000"" uht=""0.064"" urt=""0.064"" ""Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0"" ""fs09000000"" ""-"" ""-""" 2021-10-27 22:08:29.047,"10.23.38.176 - - [27/Oct/2021:22:08:28 +0000] ""PUT /mod-circulation-storage/loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a HTTP/1.1"" 204 0 rt=0.025 uct=""0.000"" uht=""0.024"" urt=""0.024"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""5bd84d84-dc5b-4954-8980-a0fcaf0195c6"" ""828141/circulation;236420/loan-storage""" 2021-10-27 22:08:29.047,"10.23.38.176 - - [27/Oct/2021:22:08:28 +0000] ""GET /mod-circulation-storage/loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a HTTP/1.1"" 200 1185 rt=0.010 uct=""0.000"" uht=""0.008"" urt=""0.008"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""5bd84d84-dc5b-4954-8980-a0fcaf0195c6"" ""828141/circulation;837525/loan-storage""" 2021-10-27 22:08:29.375,"10.23.38.176 - - [27/Oct/2021:22:08:28 +0000] ""DELETE /mod-authtoken/scheduled-notice-storage/scheduled-notices?query=loanId%3D%3D%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20and%20triggeringEvent%3D%3D%22Due%20date%22%20and%20noticeConfig.timing%3D%3D%28%22Upon%20At%22%20or%20%22After%22%29 HTTP/1.1"" 403 88 rt=0.002 uct=""0.000"" uht=""0.000"" urt=""0.000"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""5bd84d84-dc5b-4954-8980-a0fcaf0195c6"" ""828141/circulation;113838/scheduled-notice-storage""" 2021-10-27 22:08:29.376,"10.23.38.176 - - [27/Oct/2021:22:08:28 +0000] ""GET /mod-authtoken/accounts?query=loanId==%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22 HTTP/1.1"" 202 5 rt=0.000 uct=""0.000"" uht=""0.000"" urt=""0.000"" ""Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0"" ""fs09000000"" ""-"" ""407269/accounts""" 2021-10-27 22:08:29.690,"140.234.253.9, 10.23.36.34 - 10.23.38.176 - - [27/Oct/2021:22:08:28 +0000] ""GET /accounts?query=loanId==%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22 HTTP/1.1"" 200 754 rt=0.079 uct=""0.000"" uht=""0.080"" urt=""0.080"" ""Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0"" ""fs09000000"" ""-"" ""-""" 2021-10-27 22:08:29.690,"140.234.253.9, 10.23.36.34 - 10.23.38.67 - - [27/Oct/2021:22:08:28 +0000] ""OPTIONS /accounts?query=%28userId%3D%3Da2679443-89fe-4e88-b4f1-ac423e019a7e%20and%20itemId%3D%3D3146da1c-5a2c-455d-93a5-51543c39c706%20and%20loanId%3D%3D164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%29%20and%20status.name%3D%3D%22Open%22 HTTP/1.1"" 204 0 rt=0.002 uct=""0.000"" uht=""0.000"" urt=""0.000"" ""Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0"" ""-"" ""-"" ""-""" 2021-10-27 22:08:29.690,"140.234.253.9, 10.23.36.34 - 10.23.38.67 - - [27/Oct/2021:22:08:29 +0000] ""GET /accounts?query=%28userId%3D%3Da2679443-89fe-4e88-b4f1-ac423e019a7e%20and%20itemId%3D%3D3146da1c-5a2c-455d-93a5-51543c39c706%20and%20loanId%3D%3D164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%29%20and%20status.name%3D%3D%22Open%22 HTTP/1.1"" 200 754 rt=0.060 uct=""0.000"" uht=""0.060"" urt=""0.060"" ""Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0"" ""fs09000000"" ""-"" ""-""" 2021-10-27 22:08:29.769,"10.23.38.176 - - [27/Oct/2021:22:08:28 +0000] ""GET /mod-feesfines/accounts?query=loanId==%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22 HTTP/1.1"" 200 759 rt=0.059 uct=""0.000"" uht=""0.060"" urt=""0.060"" ""Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0"" ""fs09000000"" ""5bd84d84-dc5b-4954-8980-a0fcaf0195c6"" ""407269/accounts""" 2021-10-27 22:08:29.769,"10.23.38.176 - - [27/Oct/2021:22:08:29 +0000] ""GET /mod-feesfines/accounts?query=%28userId%3D%3Da2679443-89fe-4e88-b4f1-ac423e019a7e%20and%20itemId%3D%3D3146da1c-5a2c-455d-93a5-51543c39c706%20and%20loanId%3D%3D164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%29%20and%20status.name%3D%3D%22Open%22 HTTP/1.1"" 200 759 rt=0.052 uct=""0.000"" uht=""0.048"" urt=""0.048"" ""Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0"" ""fs09000000"" ""5bd84d84-dc5b-4954-8980-a0fcaf0195c6"" ""747705/accounts""" 2021-10-27 22:09:08.235,22:09:08 [756302/circulation;022464/loan-storage] [fs09000000] [] [] INFO ProxyContext 756302/circulation;022464/loan-storage RES 202 1449us mod-authtoken-2.8.0 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-authtoken/loan-storage/loans?query=id%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 2021-10-27 22:09:08.244,"22:09:08 [] [] [] [] INFO CQLWrapper CQL >>> SQL: id==(""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a"") >>>WHERE id='164a39c7-1d8e-4ba9-8230-7d3b60f72a6a' LIMIT 2147483647 OFFSET 0" 2021-10-27 22:09:08.252,22:09:08 [756302/circulation;022464/loan-storage] [fs09000000] [] [] INFO ProxyContext 756302/circulation;022464/loan-storage RES 200 17110us mod-circulation-storage-13.0.0 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-circulation-storage/loan-storage/loans?query=id%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 2021-10-27 22:09:08.252,22:09:08 [] [] [] [] INFO LogUtil 127.0.0.1:48412 GET /loan-storage/loans query=id%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 HTTP_1_1 200 1267 13 tid=fs09000000 OK 2021-10-27 22:09:08.386,"10.23.38.176 - - [27/Oct/2021:22:09:08 +0000] ""GET /mod-authtoken/loan-storage/loans?query=id%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 HTTP/1.1"" 202 5 rt=0.000 uct=""0.000"" uht=""0.000"" urt=""0.000"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""5bd84d84-dc5b-4954-8980-a0fcaf0195c6"" ""756302/circulation;022464/loan-storage""" 2021-10-27 22:09:08.656,"22:09:08 INFO SubPublishingService Event published successfully. ID: a074f6e7-794e-48f8-a7f1-eedaa6d4121e, type: LOG_RECORD, payload: {""logEventType"":""NOTICE"",""payload"":{""userBarcode"":""8377630"",""items"":[{""itemBarcode"":""10632474"",""itemId"":""3146da1c-5a2c-455d-93a5-51543c39c706"",""instanceId"":""0025c6dd-fd8c-4d7e-bddd-a9c2d0d947f4"",""holdingsRecordId"":""5ceb2d5d-cd21-4791-ba81-2dc9cfd11022"",""loanId"":""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a"",""servicePointId"":""a3cbfa53-3e36-4cbc-8213-85848623d73b"",""templateId"":""c13ab604-24bf-47ec-860b-3591e2823220"",""noticePolicyId"":""c083c844-56d6-4326-a2fd-4acf81ca088a"",""triggeringEvent"":""Check in""}],""date"":""2021-10-27T22:09:08.604Z""}}" 2021-10-27 22:09:08.694,"10.23.36.34 - 10.23.38.67 - - [27/Oct/2021:22:09:08 +0000] ""GET /loan-storage/loans?query=id%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 HTTP/1.1"" 200 1279 rt=0.024 uct=""0.004"" uht=""0.024"" urt=""0.024"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""5bd84d84-dc5b-4954-8980-a0fcaf0195c6"" ""756302/circulation""" 2021-10-27 22:09:09.056,"10.23.38.176 - - [27/Oct/2021:22:09:08 +0000] ""GET /mod-circulation-storage/loan-storage/loans?query=id%3D%3D%28%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%29&limit=2147483647 HTTP/1.1"" 200 1279 rt=0.014 uct=""0.000"" uht=""0.016"" urt=""0.016"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""5bd84d84-dc5b-4954-8980-a0fcaf0195c6"" ""756302/circulation;022464/loan-storage""" 2021-10-27 22:11:41.795,22:11:41 INFO SingleRecordFetcher Fetching loan with ID: 164a39c7-1d8e-4ba9-8230-7d3b60f72a6a 2021-10-27 22:11:41.795,22:11:41 [015758/circulation;985524/loan-storage] [fs09000000] [] [] INFO ProxyContext 015758/circulation;985524/loan-storage REQ 10.23.38.176:13756 fs09000000 GET /loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a mod-authtoken-2.8.0 mod-circulation-storage-13.0.0 2021-10-27 22:11:41.799,22:11:41 [015758/circulation;985524/loan-storage] [fs09000000] [] [] INFO ProxyContext 015758/circulation;985524/loan-storage RES 202 2481us mod-authtoken-2.8.0 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-authtoken/loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a 2021-10-27 22:11:41.812,22:11:41 [] [] [] [] INFO LogUtil 127.0.0.1:48690 GET /loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a null HTTP_1_1 200 1173 9 tid=fs09000000 OK 2021-10-27 22:11:41.813,22:11:41 [015758/circulation;985524/loan-storage] [fs09000000] [] [] INFO ProxyContext 015758/circulation;985524/loan-storage RES 200 13322us mod-circulation-storage-13.0.0 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-circulation-storage/loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a 2021-10-27 22:11:42.092,"10.23.38.67 - - [27/Oct/2021:22:11:41 +0000] ""GET /mod-circulation-storage/loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a HTTP/1.1"" 200 1185 rt=0.010 uct=""0.000"" uht=""0.012"" urt=""0.012"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""-"" ""015758/circulation;985524/loan-storage""" 2021-10-27 22:11:42.152,22:11:42 WARN heduledNoticeHandler Due Date notice 4047a021-2d84-4925-94f7-a8e082b4effb for loan 164a39c7-1d8e-4ba9-8230-7d3b60f72a6a is irrelevant: [Loan is closed] 2021-10-27 22:11:42.173,"22:11:42 INFO LogHelper DELETE scheduled patron notice succeeded: ScheduledNotice{id='4047a021-2d84-4925-94f7-a8e082b4effb', loanId='164a39c7-1d8e-4ba9-8230-7d3b60f72a6a', requestId='null', recipientUserId='a2679443-89fe-4e88-b4f1-ac423e019a7e', feeFineActionId='null', triggeringEvent='Due date', nextRunTime=2021-10-27T22:07:07.000Z, configuration=ScheduledNoticeConfig{timing='After', recurringPeriod=Period{duration=1, interval='Minutes'}, templateId='565f41c7-5c8d-46b9-9dcb-ac4117349368', format='Email', sendInRealTime=true}}" 2021-10-27 22:11:42.426,"10.23.38.67 - - [27/Oct/2021:22:11:41 +0000] ""GET /mod-authtoken/loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a HTTP/1.1"" 202 5 rt=0.000 uct=""0.000"" uht=""0.000"" urt=""0.000"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""-"" ""015758/circulation;985524/loan-storage""" 2021-10-27 22:11:42.708,"10.23.36.34 - 10.23.38.67 - - [27/Oct/2021:22:11:41 +0000] ""GET /loan-storage/loans/164a39c7-1d8e-4ba9-8230-7d3b60f72a6a HTTP/1.1"" 200 1185 rt=0.021 uct=""0.000"" uht=""0.020"" urt=""0.020"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""-"" ""015758/circulation""" 2021-10-27 22:13:25.269,"22:13:25 [] [] [] [] INFO CQLWrapper CQL >>> SQL: loanId==(""60602b30-718f-4d84-86f2-f45ff4fd28af"" or ""ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9"" or ""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a"" or ""55b5f6e7-9ddc-444f-840a-a71494331e81"" or ""b1ffa8da-c73e-4151-bc44-e52ef09313b4"" or ""80fd96be-e347-46b8-b565-4e3b7ff6d527"" or ""9fda134a-5beb-4bf9-883d-c84c79561b13"" or ""9add5c91-5dec-4904-8db0-98a61956f618"" or ""b06eae66-f848-48ad-9031-c41c29baa594"" or ""2fb04375-8928-4f6b-a6f7-ac63905e5cc1"" or ""c892bf81-9479-48e0-8600-20e4b06bb018"") >>>WHERE ((((((((((CASE WHEN length(lower(f_unaccent('60602b30-718f-4d84-86f2-f45ff4fd28af'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('60602b30-718f-4d84-86f2-f45ff4fd28af')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('60602b30-718f-4d84-86f2-f45ff4fd28af')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('60602b30-718f-4d84-86f2-f45ff4fd28af')) END) OR (CASE WHEN length(lower(f_unaccent('ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9')) END)) OR (CASE WHEN length(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) END)) OR (CASE WHEN length(lower(f_unaccent('55b5f6e7-9ddc-444f-840a-a71494331e81'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('55b5f6e7-9ddc-444f-840a-a71494331e81')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('55b5f6e7-9ddc-444f-840a-a71494331e81')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('55b5f6e7-9ddc-444f-840a-a71494331e81')) END)) OR (CASE WHEN length(lower(f_unaccent('b1ffa8da-c73e-4151-bc44-e52ef09313b4'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('b1ffa8da-c73e-4151-bc44-e52ef09313b4')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('b1ffa8da-c73e-4151-bc44-e52ef09313b4')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('b1ffa8da-c73e-4151-bc44-e52ef09313b4')) END)) OR (CASE WHEN length(lower(f_unaccent('80fd96be-e347-46b8-b565-4e3b7ff6d527'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('80fd96be-e347-46b8-b565-4e3b7ff6d527')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('80fd96be-e347-46b8-b565-4e3b7ff6d527')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('80fd96be-e347-46b8-b565-4e3b7ff6d527')) END)) OR (CASE WHEN length(lower(f_unaccent('9fda134a-5beb-4bf9-883d-c84c79561b13'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('9fda134a-5beb-4bf9-883d-c84c79561b13')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('9fda134a-5beb-4bf9-883d-c84c79561b13')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('9fda134a-5beb-4bf9-883d-c84c79561b13')) END)) OR (CASE WHEN length(lower(f_unaccent('9add5c91-5dec-4904-8db0-98a61956f618'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('9add5c91-5dec-4904-8db0-98a61956f618')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('9add5c91-5dec-4904-8db0-98a61956f618')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('9add5c91-5dec-4904-8db0-98a61956f618')) END)) OR (CASE WHEN length(lower(f_unaccent('b06eae66-f848-48ad-9031-c41c29baa594'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('b06eae66-f848-48ad-9031-c41c29baa594')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('b06eae66-f848-48ad-9031-c41c29baa594')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('b06eae66-f848-48ad-9031-c41c29baa594')) END)) OR (CASE WHEN length(lower(f_unaccent('2fb04375-8928-4f6b-a6f7-ac63905e5cc1'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('2fb04375-8928-4f6b-a6f7-ac63905e5cc1')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('2fb04375-8928-4f6b-a6f7-ac63905e5cc1')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('2fb04375-8928-4f6b-a6f7-ac63905e5cc1')) END)) OR (CASE WHEN length(lower(f_unaccent('c892bf81-9479-48e0-8600-20e4b06bb018'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('c892bf81-9479-48e0-8600-20e4b06bb018')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('c892bf81-9479-48e0-8600-20e4b06bb018')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('c892bf81-9479-48e0-8600-20e4b06bb018')) END) LIMIT 2147483647 OFFSET 0" 2021-10-27 22:13:25.321,22:13:25 [] [] [] [] INFO LogUtil 127.0.0.1:43096 GET /accounts query=loanId%3D%3D%28%2260602b30-718f-4d84-86f2-f45ff4fd28af%22%20or%20%22ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9%22%20or%20%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20or%20%2255b5f6e7-9ddc-444f-840a-a71494331e81%22%20or%20%22b1ffa8da-c73e-4151-bc44-e52ef09313b4%22%20or%20%2280fd96be-e347-46b8-b565-4e3b7ff6d527%22%20or%20%229fda134a-5beb-4bf9-883d-c84c79561b13%22%20or%20%229add5c91-5dec-4904-8db0-98a61956f618%22%20or%20%22b06eae66-f848-48ad-9031-c41c29baa594%22%20or%20%222fb04375-8928-4f6b-a6f7-ac63905e5cc1%22%20or%20%22c892bf81-9479-48e0-8600-20e4b06bb018%22%29&limit=2147483647 HTTP_1_1 200 15254 56 tid=fs09000000 OK 2021-10-27 22:13:25.327,"22:13:25 [] [] [] [] INFO CQLWrapper CQL >>> SQL: loanId==(""60602b30-718f-4d84-86f2-f45ff4fd28af"" or ""ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9"" or ""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a"" or ""55b5f6e7-9ddc-444f-840a-a71494331e81"" or ""b1ffa8da-c73e-4151-bc44-e52ef09313b4"" or ""80fd96be-e347-46b8-b565-4e3b7ff6d527"" or ""9fda134a-5beb-4bf9-883d-c84c79561b13"" or ""b06eae66-f848-48ad-9031-c41c29baa594"" or ""9add5c91-5dec-4904-8db0-98a61956f618"" or ""2fb04375-8928-4f6b-a6f7-ac63905e5cc1"" or ""c892bf81-9479-48e0-8600-20e4b06bb018"") >>>WHERE ((((((((((CASE WHEN length(lower(f_unaccent('60602b30-718f-4d84-86f2-f45ff4fd28af'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('60602b30-718f-4d84-86f2-f45ff4fd28af')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('60602b30-718f-4d84-86f2-f45ff4fd28af')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('60602b30-718f-4d84-86f2-f45ff4fd28af')) END) OR (CASE WHEN length(lower(f_unaccent('ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9')) END)) OR (CASE WHEN length(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) END)) OR (CASE WHEN length(lower(f_unaccent('55b5f6e7-9ddc-444f-840a-a71494331e81'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('55b5f6e7-9ddc-444f-840a-a71494331e81')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('55b5f6e7-9ddc-444f-840a-a71494331e81')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('55b5f6e7-9ddc-444f-840a-a71494331e81')) END)) OR (CASE WHEN length(lower(f_unaccent('b1ffa8da-c73e-4151-bc44-e52ef09313b4'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('b1ffa8da-c73e-4151-bc44-e52ef09313b4')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('b1ffa8da-c73e-4151-bc44-e52ef09313b4')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('b1ffa8da-c73e-4151-bc44-e52ef09313b4')) END)) OR (CASE WHEN length(lower(f_unaccent('80fd96be-e347-46b8-b565-4e3b7ff6d527'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('80fd96be-e347-46b8-b565-4e3b7ff6d527')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('80fd96be-e347-46b8-b565-4e3b7ff6d527')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('80fd96be-e347-46b8-b565-4e3b7ff6d527')) END)) OR (CASE WHEN length(lower(f_unaccent('9fda134a-5beb-4bf9-883d-c84c79561b13'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('9fda134a-5beb-4bf9-883d-c84c79561b13')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('9fda134a-5beb-4bf9-883d-c84c79561b13')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('9fda134a-5beb-4bf9-883d-c84c79561b13')) END)) OR (CASE WHEN length(lower(f_unaccent('b06eae66-f848-48ad-9031-c41c29baa594'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('b06eae66-f848-48ad-9031-c41c29baa594')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('b06eae66-f848-48ad-9031-c41c29baa594')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('b06eae66-f848-48ad-9031-c41c29baa594')) END)) OR (CASE WHEN length(lower(f_unaccent('9add5c91-5dec-4904-8db0-98a61956f618'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('9add5c91-5dec-4904-8db0-98a61956f618')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('9add5c91-5dec-4904-8db0-98a61956f618')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('9add5c91-5dec-4904-8db0-98a61956f618')) END)) OR (CASE WHEN length(lower(f_unaccent('2fb04375-8928-4f6b-a6f7-ac63905e5cc1'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('2fb04375-8928-4f6b-a6f7-ac63905e5cc1')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('2fb04375-8928-4f6b-a6f7-ac63905e5cc1')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('2fb04375-8928-4f6b-a6f7-ac63905e5cc1')) END)) OR (CASE WHEN length(lower(f_unaccent('c892bf81-9479-48e0-8600-20e4b06bb018'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('c892bf81-9479-48e0-8600-20e4b06bb018')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('c892bf81-9479-48e0-8600-20e4b06bb018')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('c892bf81-9479-48e0-8600-20e4b06bb018')) END) LIMIT 2147483647 OFFSET 0" 2021-10-27 22:13:25.377,22:13:25 [] [] [] [] INFO LogUtil 127.0.0.1:43110 GET /accounts query=loanId%3D%3D%28%2260602b30-718f-4d84-86f2-f45ff4fd28af%22%20or%20%22ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9%22%20or%20%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20or%20%2255b5f6e7-9ddc-444f-840a-a71494331e81%22%20or%20%22b1ffa8da-c73e-4151-bc44-e52ef09313b4%22%20or%20%2280fd96be-e347-46b8-b565-4e3b7ff6d527%22%20or%20%229fda134a-5beb-4bf9-883d-c84c79561b13%22%20or%20%22b06eae66-f848-48ad-9031-c41c29baa594%22%20or%20%229add5c91-5dec-4904-8db0-98a61956f618%22%20or%20%222fb04375-8928-4f6b-a6f7-ac63905e5cc1%22%20or%20%22c892bf81-9479-48e0-8600-20e4b06bb018%22%29&limit=2147483647 HTTP_1_1 200 15254 54 tid=fs09000000 OK 2021-10-27 22:13:25.454,"10.23.38.176 - - [27/Oct/2021:22:13:25 +0000] ""GET /mod-authtoken/accounts?query=loanId%3D%3D%28%2260602b30-718f-4d84-86f2-f45ff4fd28af%22%20or%20%22ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9%22%20or%20%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20or%20%2255b5f6e7-9ddc-444f-840a-a71494331e81%22%20or%20%22b1ffa8da-c73e-4151-bc44-e52ef09313b4%22%20or%20%2280fd96be-e347-46b8-b565-4e3b7ff6d527%22%20or%20%229fda134a-5beb-4bf9-883d-c84c79561b13%22%20or%20%229add5c91-5dec-4904-8db0-98a61956f618%22%20or%20%22b06eae66-f848-48ad-9031-c41c29baa594%22%20or%20%222fb04375-8928-4f6b-a6f7-ac63905e5cc1%22%20or%20%22c892bf81-9479-48e0-8600-20e4b06bb018%22%29&limit=2147483647 HTTP/1.1"" 202 5 rt=0.068 uct=""0.000"" uht=""0.068"" urt=""0.068"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""9eb67301-6f6e-468f-9b1a-6134dc39a684"" ""250578/circulation;961043/accounts""" 2021-10-27 22:13:25.454,"10.23.38.176 - - [27/Oct/2021:22:13:25 +0000] ""GET /mod-authtoken/accounts?query=loanId%3D%3D%28%2260602b30-718f-4d84-86f2-f45ff4fd28af%22%20or%20%22ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9%22%20or%20%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20or%20%2255b5f6e7-9ddc-444f-840a-a71494331e81%22%20or%20%22b1ffa8da-c73e-4151-bc44-e52ef09313b4%22%20or%20%2280fd96be-e347-46b8-b565-4e3b7ff6d527%22%20or%20%229fda134a-5beb-4bf9-883d-c84c79561b13%22%20or%20%22b06eae66-f848-48ad-9031-c41c29baa594%22%20or%20%229add5c91-5dec-4904-8db0-98a61956f618%22%20or%20%222fb04375-8928-4f6b-a6f7-ac63905e5cc1%22%20or%20%22c892bf81-9479-48e0-8600-20e4b06bb018%22%29&limit=2147483647 HTTP/1.1"" 202 5 rt=0.073 uct=""0.000"" uht=""0.072"" urt=""0.072"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""9eb67301-6f6e-468f-9b1a-6134dc39a684"" ""124265/circulation;068998/accounts""" 2021-10-27 22:13:25.717,"10.23.36.34 - 10.23.38.67 - - [27/Oct/2021:22:13:25 +0000] ""GET /accounts?query=loanId%3D%3D%28%2260602b30-718f-4d84-86f2-f45ff4fd28af%22%20or%20%22ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9%22%20or%20%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20or%20%2255b5f6e7-9ddc-444f-840a-a71494331e81%22%20or%20%22b1ffa8da-c73e-4151-bc44-e52ef09313b4%22%20or%20%2280fd96be-e347-46b8-b565-4e3b7ff6d527%22%20or%20%229fda134a-5beb-4bf9-883d-c84c79561b13%22%20or%20%229add5c91-5dec-4904-8db0-98a61956f618%22%20or%20%22b06eae66-f848-48ad-9031-c41c29baa594%22%20or%20%222fb04375-8928-4f6b-a6f7-ac63905e5cc1%22%20or%20%22c892bf81-9479-48e0-8600-20e4b06bb018%22%29&limit=2147483647 HTTP/1.1"" 200 15288 rt=0.134 uct=""0.000"" uht=""0.132"" urt=""0.132"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""9eb67301-6f6e-468f-9b1a-6134dc39a684"" ""250578/circulation""" 2021-10-27 22:13:25.717,"10.23.36.34 - 10.23.38.67 - - [27/Oct/2021:22:13:25 +0000] ""GET /accounts?query=loanId%3D%3D%28%2260602b30-718f-4d84-86f2-f45ff4fd28af%22%20or%20%22ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9%22%20or%20%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20or%20%2255b5f6e7-9ddc-444f-840a-a71494331e81%22%20or%20%22b1ffa8da-c73e-4151-bc44-e52ef09313b4%22%20or%20%2280fd96be-e347-46b8-b565-4e3b7ff6d527%22%20or%20%229fda134a-5beb-4bf9-883d-c84c79561b13%22%20or%20%22b06eae66-f848-48ad-9031-c41c29baa594%22%20or%20%229add5c91-5dec-4904-8db0-98a61956f618%22%20or%20%222fb04375-8928-4f6b-a6f7-ac63905e5cc1%22%20or%20%22c892bf81-9479-48e0-8600-20e4b06bb018%22%29&limit=2147483647 HTTP/1.1"" 200 15281 rt=0.138 uct=""0.004"" uht=""0.140"" urt=""0.140"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""9eb67301-6f6e-468f-9b1a-6134dc39a684"" ""124265/circulation""" 2021-10-27 22:13:25.840,"10.23.38.176 - - [27/Oct/2021:22:13:25 +0000] ""GET /mod-feesfines/accounts?query=loanId%3D%3D%28%2260602b30-718f-4d84-86f2-f45ff4fd28af%22%20or%20%22ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9%22%20or%20%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20or%20%2255b5f6e7-9ddc-444f-840a-a71494331e81%22%20or%20%22b1ffa8da-c73e-4151-bc44-e52ef09313b4%22%20or%20%2280fd96be-e347-46b8-b565-4e3b7ff6d527%22%20or%20%229fda134a-5beb-4bf9-883d-c84c79561b13%22%20or%20%229add5c91-5dec-4904-8db0-98a61956f618%22%20or%20%22b06eae66-f848-48ad-9031-c41c29baa594%22%20or%20%222fb04375-8928-4f6b-a6f7-ac63905e5cc1%22%20or%20%22c892bf81-9479-48e0-8600-20e4b06bb018%22%29&limit=2147483647 HTTP/1.1"" 200 15267 rt=0.056 uct=""0.000"" uht=""0.056"" urt=""0.056"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""9eb67301-6f6e-468f-9b1a-6134dc39a684"" ""250578/circulation;961043/accounts""" 2021-10-27 22:13:25.840,"10.23.38.176 - - [27/Oct/2021:22:13:25 +0000] ""GET /mod-feesfines/accounts?query=loanId%3D%3D%28%2260602b30-718f-4d84-86f2-f45ff4fd28af%22%20or%20%22ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9%22%20or%20%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20or%20%2255b5f6e7-9ddc-444f-840a-a71494331e81%22%20or%20%22b1ffa8da-c73e-4151-bc44-e52ef09313b4%22%20or%20%2280fd96be-e347-46b8-b565-4e3b7ff6d527%22%20or%20%229fda134a-5beb-4bf9-883d-c84c79561b13%22%20or%20%22b06eae66-f848-48ad-9031-c41c29baa594%22%20or%20%229add5c91-5dec-4904-8db0-98a61956f618%22%20or%20%222fb04375-8928-4f6b-a6f7-ac63905e5cc1%22%20or%20%22c892bf81-9479-48e0-8600-20e4b06bb018%22%29&limit=2147483647 HTTP/1.1"" 200 15267 rt=0.055 uct=""0.000"" uht=""0.052"" urt=""0.052"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""9eb67301-6f6e-468f-9b1a-6134dc39a684"" ""124265/circulation;068998/accounts""" 2021-10-27 22:13:26.192,"22:13:26 [] [] [] [] INFO CQLWrapper CQL >>> SQL: loanId==(""60602b30-718f-4d84-86f2-f45ff4fd28af"" or ""ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9"" or ""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a"" or ""55b5f6e7-9ddc-444f-840a-a71494331e81"" or ""b1ffa8da-c73e-4151-bc44-e52ef09313b4"" or ""80fd96be-e347-46b8-b565-4e3b7ff6d527"" or ""9fda134a-5beb-4bf9-883d-c84c79561b13"" or ""b06eae66-f848-48ad-9031-c41c29baa594"" or ""9add5c91-5dec-4904-8db0-98a61956f618"" or ""2fb04375-8928-4f6b-a6f7-ac63905e5cc1"" or ""c892bf81-9479-48e0-8600-20e4b06bb018"") >>>WHERE ((((((((((CASE WHEN length(lower(f_unaccent('60602b30-718f-4d84-86f2-f45ff4fd28af'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('60602b30-718f-4d84-86f2-f45ff4fd28af')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('60602b30-718f-4d84-86f2-f45ff4fd28af')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('60602b30-718f-4d84-86f2-f45ff4fd28af')) END) OR (CASE WHEN length(lower(f_unaccent('ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9')) END)) OR (CASE WHEN length(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) END)) OR (CASE WHEN length(lower(f_unaccent('55b5f6e7-9ddc-444f-840a-a71494331e81'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('55b5f6e7-9ddc-444f-840a-a71494331e81')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('55b5f6e7-9ddc-444f-840a-a71494331e81')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('55b5f6e7-9ddc-444f-840a-a71494331e81')) END)) OR (CASE WHEN length(lower(f_unaccent('b1ffa8da-c73e-4151-bc44-e52ef09313b4'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('b1ffa8da-c73e-4151-bc44-e52ef09313b4')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('b1ffa8da-c73e-4151-bc44-e52ef09313b4')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('b1ffa8da-c73e-4151-bc44-e52ef09313b4')) END)) OR (CASE WHEN length(lower(f_unaccent('80fd96be-e347-46b8-b565-4e3b7ff6d527'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('80fd96be-e347-46b8-b565-4e3b7ff6d527')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('80fd96be-e347-46b8-b565-4e3b7ff6d527')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('80fd96be-e347-46b8-b565-4e3b7ff6d527')) END)) OR (CASE WHEN length(lower(f_unaccent('9fda134a-5beb-4bf9-883d-c84c79561b13'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('9fda134a-5beb-4bf9-883d-c84c79561b13')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('9fda134a-5beb-4bf9-883d-c84c79561b13')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('9fda134a-5beb-4bf9-883d-c84c79561b13')) END)) OR (CASE WHEN length(lower(f_unaccent('b06eae66-f848-48ad-9031-c41c29baa594'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('b06eae66-f848-48ad-9031-c41c29baa594')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('b06eae66-f848-48ad-9031-c41c29baa594')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('b06eae66-f848-48ad-9031-c41c29baa594')) END)) OR (CASE WHEN length(lower(f_unaccent('9add5c91-5dec-4904-8db0-98a61956f618'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('9add5c91-5dec-4904-8db0-98a61956f618')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('9add5c91-5dec-4904-8db0-98a61956f618')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('9add5c91-5dec-4904-8db0-98a61956f618')) END)) OR (CASE WHEN length(lower(f_unaccent('2fb04375-8928-4f6b-a6f7-ac63905e5cc1'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('2fb04375-8928-4f6b-a6f7-ac63905e5cc1')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('2fb04375-8928-4f6b-a6f7-ac63905e5cc1')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('2fb04375-8928-4f6b-a6f7-ac63905e5cc1')) END)) OR (CASE WHEN length(lower(f_unaccent('c892bf81-9479-48e0-8600-20e4b06bb018'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('c892bf81-9479-48e0-8600-20e4b06bb018')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('c892bf81-9479-48e0-8600-20e4b06bb018')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('c892bf81-9479-48e0-8600-20e4b06bb018')) END) LIMIT 2147483647 OFFSET 0" 2021-10-27 22:13:26.241,22:13:26 [] [] [] [] INFO LogUtil 127.0.0.1:43206 GET /accounts query=loanId%3D%3D%28%2260602b30-718f-4d84-86f2-f45ff4fd28af%22%20or%20%22ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9%22%20or%20%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20or%20%2255b5f6e7-9ddc-444f-840a-a71494331e81%22%20or%20%22b1ffa8da-c73e-4151-bc44-e52ef09313b4%22%20or%20%2280fd96be-e347-46b8-b565-4e3b7ff6d527%22%20or%20%229fda134a-5beb-4bf9-883d-c84c79561b13%22%20or%20%22b06eae66-f848-48ad-9031-c41c29baa594%22%20or%20%229add5c91-5dec-4904-8db0-98a61956f618%22%20or%20%222fb04375-8928-4f6b-a6f7-ac63905e5cc1%22%20or%20%22c892bf81-9479-48e0-8600-20e4b06bb018%22%29&limit=2147483647 HTTP_1_1 200 15254 52 tid=fs09000000 OK 2021-10-27 22:13:26.717,"10.23.36.34 - 10.23.38.67 - - [27/Oct/2021:22:13:26 +0000] ""GET /accounts?query=loanId%3D%3D%28%2260602b30-718f-4d84-86f2-f45ff4fd28af%22%20or%20%22ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9%22%20or%20%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20or%20%2255b5f6e7-9ddc-444f-840a-a71494331e81%22%20or%20%22b1ffa8da-c73e-4151-bc44-e52ef09313b4%22%20or%20%2280fd96be-e347-46b8-b565-4e3b7ff6d527%22%20or%20%229fda134a-5beb-4bf9-883d-c84c79561b13%22%20or%20%22b06eae66-f848-48ad-9031-c41c29baa594%22%20or%20%229add5c91-5dec-4904-8db0-98a61956f618%22%20or%20%222fb04375-8928-4f6b-a6f7-ac63905e5cc1%22%20or%20%22c892bf81-9479-48e0-8600-20e4b06bb018%22%29&limit=2147483647 HTTP/1.1"" 200 15282 rt=0.060 uct=""0.000"" uht=""0.056"" urt=""0.056"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""9eb67301-6f6e-468f-9b1a-6134dc39a684"" ""598597/circulation""" 2021-10-27 22:13:26.840,"10.23.38.176 - - [27/Oct/2021:22:13:26 +0000] ""GET /mod-feesfines/accounts?query=loanId%3D%3D%28%2260602b30-718f-4d84-86f2-f45ff4fd28af%22%20or%20%22ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9%22%20or%20%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20or%20%2255b5f6e7-9ddc-444f-840a-a71494331e81%22%20or%20%22b1ffa8da-c73e-4151-bc44-e52ef09313b4%22%20or%20%2280fd96be-e347-46b8-b565-4e3b7ff6d527%22%20or%20%229fda134a-5beb-4bf9-883d-c84c79561b13%22%20or%20%22b06eae66-f848-48ad-9031-c41c29baa594%22%20or%20%229add5c91-5dec-4904-8db0-98a61956f618%22%20or%20%222fb04375-8928-4f6b-a6f7-ac63905e5cc1%22%20or%20%22c892bf81-9479-48e0-8600-20e4b06bb018%22%29&limit=2147483647 HTTP/1.1"" 200 15267 rt=0.053 uct=""0.000"" uht=""0.052"" urt=""0.052"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""9eb67301-6f6e-468f-9b1a-6134dc39a684"" ""598597/circulation;412727/accounts""" 2021-10-27 22:13:31.270,22:13:31 [666273/circulation;436032/accounts] [fs09000000] [] [] INFO ProxyContext 666273/circulation;436032/accounts RES 200 46814us mod-feesfines-16.1.1 http://pvt.lb.jbf3.folio-eis.us-east-1:8051/mod-feesfines/accounts?query=loanId%3D%3D%28%2260602b30-718f-4d84-86f2-f45ff4fd28af%22%20or%20%22ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9%22%20or%20%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20or%20%2255b5f6e7-9ddc-444f-840a-a71494331e81%22%20or%20%22b1ffa8da-c73e-4151-bc44-e52ef09313b4%22%20or%20%2280fd96be-e347-46b8-b565-4e3b7ff6d527%22%20or%20%229fda134a-5beb-4bf9-883d-c84c79561b13%22%20or%20%229add5c91-5dec-4904-8db0-98a61956f618%22%20or%20%22b06eae66-f848-48ad-9031-c41c29baa594%22%20or%20%222fb04375-8928-4f6b-a6f7-ac63905e5cc1%22%20or%20%22c892bf81-9479-48e0-8600-20e4b06bb018%22%29&limit=2147483647 2021-10-27 22:13:31.718,"10.23.36.34 - 10.23.38.67 - - [27/Oct/2021:22:13:31 +0000] ""GET /accounts?query=loanId%3D%3D%28%2260602b30-718f-4d84-86f2-f45ff4fd28af%22%20or%20%22ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9%22%20or%20%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20or%20%2255b5f6e7-9ddc-444f-840a-a71494331e81%22%20or%20%22b1ffa8da-c73e-4151-bc44-e52ef09313b4%22%20or%20%2280fd96be-e347-46b8-b565-4e3b7ff6d527%22%20or%20%229fda134a-5beb-4bf9-883d-c84c79561b13%22%20or%20%229add5c91-5dec-4904-8db0-98a61956f618%22%20or%20%22b06eae66-f848-48ad-9031-c41c29baa594%22%20or%20%222fb04375-8928-4f6b-a6f7-ac63905e5cc1%22%20or%20%22c892bf81-9479-48e0-8600-20e4b06bb018%22%29&limit=2147483647 HTTP/1.1"" 200 15289 rt=0.051 uct=""0.000"" uht=""0.052"" urt=""0.052"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""9eb67301-6f6e-468f-9b1a-6134dc39a684"" ""666273/circulation""" 2021-10-27 22:13:31.842,"10.23.38.176 - - [27/Oct/2021:22:13:31 +0000] ""GET /mod-feesfines/accounts?query=loanId%3D%3D%28%2260602b30-718f-4d84-86f2-f45ff4fd28af%22%20or%20%22ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9%22%20or%20%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20or%20%2255b5f6e7-9ddc-444f-840a-a71494331e81%22%20or%20%22b1ffa8da-c73e-4151-bc44-e52ef09313b4%22%20or%20%2280fd96be-e347-46b8-b565-4e3b7ff6d527%22%20or%20%229fda134a-5beb-4bf9-883d-c84c79561b13%22%20or%20%229add5c91-5dec-4904-8db0-98a61956f618%22%20or%20%22b06eae66-f848-48ad-9031-c41c29baa594%22%20or%20%222fb04375-8928-4f6b-a6f7-ac63905e5cc1%22%20or%20%22c892bf81-9479-48e0-8600-20e4b06bb018%22%29&limit=2147483647 HTTP/1.1"" 200 15267 rt=0.044 uct=""0.000"" uht=""0.044"" urt=""0.044"" ""Vert.x-WebClient/3.9.1"" ""fs09000000"" ""9eb67301-6f6e-468f-9b1a-6134dc39a684"" ""666273/circulation;436032/accounts""" 2021-10-27 22:14:05.983,"22:14:05 [] [] [] [] INFO CQLWrapper CQL >>> SQL: (loanId==164a39c7-1d8e-4ba9-8230-7d3b60f72a6a) >>>WHERE CASE WHEN length(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) END LIMIT 2000 OFFSET 0" 2021-10-27 22:14:06.021,22:14:06 [] [] [] [] INFO LogUtil 127.0.0.1:43448 GET /accounts query=(loanId==164a39c7-1d8e-4ba9-8230-7d3b60f72a6a)&limit=2000 HTTP_1_1 200 1487 38 tid=fs09000000 OK 2021-10-27 22:14:06.300,"22:14:06 [] [] [] [] INFO CQLWrapper CQL >>> SQL: loanId==(""60602b30-718f-4d84-86f2-f45ff4fd28af"" or ""ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9"" or ""164a39c7-1d8e-4ba9-8230-7d3b60f72a6a"" or ""55b5f6e7-9ddc-444f-840a-a71494331e81"" or ""b1ffa8da-c73e-4151-bc44-e52ef09313b4"" or ""80fd96be-e347-46b8-b565-4e3b7ff6d527"" or ""9fda134a-5beb-4bf9-883d-c84c79561b13"" or ""9add5c91-5dec-4904-8db0-98a61956f618"" or ""b06eae66-f848-48ad-9031-c41c29baa594"" or ""2fb04375-8928-4f6b-a6f7-ac63905e5cc1"" or ""c892bf81-9479-48e0-8600-20e4b06bb018"") >>>WHERE ((((((((((CASE WHEN length(lower(f_unaccent('60602b30-718f-4d84-86f2-f45ff4fd28af'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('60602b30-718f-4d84-86f2-f45ff4fd28af')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('60602b30-718f-4d84-86f2-f45ff4fd28af')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('60602b30-718f-4d84-86f2-f45ff4fd28af')) END) OR (CASE WHEN length(lower(f_unaccent('ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9')) END)) OR (CASE WHEN length(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) END)) OR (CASE WHEN length(lower(f_unaccent('55b5f6e7-9ddc-444f-840a-a71494331e81'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('55b5f6e7-9ddc-444f-840a-a71494331e81')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('55b5f6e7-9ddc-444f-840a-a71494331e81')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('55b5f6e7-9ddc-444f-840a-a71494331e81')) END)) OR (CASE WHEN length(lower(f_unaccent('b1ffa8da-c73e-4151-bc44-e52ef09313b4'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('b1ffa8da-c73e-4151-bc44-e52ef09313b4')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('b1ffa8da-c73e-4151-bc44-e52ef09313b4')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('b1ffa8da-c73e-4151-bc44-e52ef09313b4')) END)) OR (CASE WHEN length(lower(f_unaccent('80fd96be-e347-46b8-b565-4e3b7ff6d527'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('80fd96be-e347-46b8-b565-4e3b7ff6d527')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('80fd96be-e347-46b8-b565-4e3b7ff6d527')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('80fd96be-e347-46b8-b565-4e3b7ff6d527')) END)) OR (CASE WHEN length(lower(f_unaccent('9fda134a-5beb-4bf9-883d-c84c79561b13'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('9fda134a-5beb-4bf9-883d-c84c79561b13')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('9fda134a-5beb-4bf9-883d-c84c79561b13')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('9fda134a-5beb-4bf9-883d-c84c79561b13')) END)) OR (CASE WHEN length(lower(f_unaccent('9add5c91-5dec-4904-8db0-98a61956f618'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('9add5c91-5dec-4904-8db0-98a61956f618')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('9add5c91-5dec-4904-8db0-98a61956f618')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('9add5c91-5dec-4904-8db0-98a61956f618')) END)) OR (CASE WHEN length(lower(f_unaccent('b06eae66-f848-48ad-9031-c41c29baa594'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('b06eae66-f848-48ad-9031-c41c29baa594')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('b06eae66-f848-48ad-9031-c41c29baa594')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('b06eae66-f848-48ad-9031-c41c29baa594')) END)) OR (CASE WHEN length(lower(f_unaccent('2fb04375-8928-4f6b-a6f7-ac63905e5cc1'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('2fb04375-8928-4f6b-a6f7-ac63905e5cc1')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('2fb04375-8928-4f6b-a6f7-ac63905e5cc1')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('2fb04375-8928-4f6b-a6f7-ac63905e5cc1')) END)) OR (CASE WHEN length(lower(f_unaccent('c892bf81-9479-48e0-8600-20e4b06bb018'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('c892bf81-9479-48e0-8600-20e4b06bb018')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('c892bf81-9479-48e0-8600-20e4b06bb018')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('c892bf81-9479-48e0-8600-20e4b06bb018')) END) LIMIT 2147483647 OFFSET 0" 2021-10-27 22:14:06.346,22:14:06 [] [] [] [] INFO LogUtil 127.0.0.1:43480 GET /accounts query=loanId%3D%3D%28%2260602b30-718f-4d84-86f2-f45ff4fd28af%22%20or%20%22ade2e4f6-b289-4f3f-ae1b-d2d3a86104c9%22%20or%20%22164a39c7-1d8e-4ba9-8230-7d3b60f72a6a%22%20or%20%2255b5f6e7-9ddc-444f-840a-a71494331e81%22%20or%20%22b1ffa8da-c73e-4151-bc44-e52ef09313b4%22%20or%20%2280fd96be-e347-46b8-b565-4e3b7ff6d527%22%20or%20%229fda134a-5beb-4bf9-883d-c84c79561b13%22%20or%20%229add5c91-5dec-4904-8db0-98a61956f618%22%20or%20%22b06eae66-f848-48ad-9031-c41c29baa594%22%20or%20%222fb04375-8928-4f6b-a6f7-ac63905e5cc1%22%20or%20%22c892bf81-9479-48e0-8600-20e4b06bb018%22%29&limit=2147483647 HTTP_1_1 200 15254 47 tid=fs09000000 OK 2021-10-27 22:14:07.309,"22:14:07 [] [] [] [] INFO CQLWrapper CQL >>> SQL: (loanId==164a39c7-1d8e-4ba9-8230-7d3b60f72a6a) >>>WHERE CASE WHEN length(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a'))) <= 600 THEN left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) ELSE left(lower(f_unaccent(accounts.jsonb->>'loanId')),600) LIKE left(lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')),600) AND lower(f_unaccent(accounts.jsonb->>'loanId')) LIKE lower(f_unaccent('164a39c7-1d8e-4ba9-8230-7d3b60f72a6a')) END LIMIT 2000 OFFSET 0" 2021-10-27 22:14:07.343,22:14:07 [] [] [] [] INFO LogUtil 127.0.0.1:43516 GET /accounts query=(loanId==164a39c7-1d8e-4ba9-8230-7d3b60f72a6a)&limit=2000 HTTP_1_1 200 1487 34 tid=fs09000000 OK 2021-10-27 22:14:08.129,"10.23.38.176 - - [27/Oct/2021:22:14:07 +0000] ""GET /mod-circulation-storage/loan-storage/loan-history?query=(loan.id==164a39c7-1d8e-4ba9-8230-7d3b60f72a6a)&limit=2000 HTTP/1.1"" 200 774 rt=1.210 uct=""0.000"" uht=""1.212"" urt=""1.212"" ""Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0"" ""fs09000000"" ""9eb67301-6f6e-468f-9b1a-6134dc39a684"" ""230443/loan-storage""" 2021-10-27 22:14:08.456,22:14:08 [] [] [] [] INFO LogUtil 127.0.0.1:49046 GET /loan-storage/loan-history query=(loan.id==164a39c7-1d8e-4ba9-8230-7d3b60f72a6a)&limit=2000 HTTP_1_1 200 2716 1149 tid=fs09000000 OK 2021-10-27 22:14:09.129,"10.23.38.176 - - [27/Oct/2021:22:14:08 +0000] ""GET /mod-circulation-storage/loan-storage/loan-history?query=(loan.id==164a39c7-1d8e-4ba9-8230-7d3b60f72a6a)&limit=2000 HTTP/1.1"" 200 774 rt=1.149 uct=""0.000"" uht=""1.148"" urt=""1.148"" ""Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0"" ""fs09000000"" ""9eb67301-6f6e-468f-9b1a-6134dc39a684"" ""306044/loan-storage"""