Advertisement
Guest User

Untitled

a guest
May 11th, 2018
231
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 155.03 KB | None | 0 0
  1. ffab901de7342a61449a74e31fea12&fileSize=3232&destinationPath=%2Fshare%2Fsummary_report_report_1526063301046.xlsx&allowOverwrite=true&resume=false,{Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  2. 2018-05-11 21:28:22,402 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Received getUploadUrl response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"url":"https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e0c5eab99d6ffab901de7342a61449a74e31fea12&destinationPath=%2Fshare%2Fsummary_report_report_1526063301046.xlsx&fileSize=3232&allowOverwrite=1&resume=0","offset":0}),{Date=[Fri, 11 May 2018 18:28:22 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Cache-Control=[s-maxage=10], Content-Length=[272], Keep-Alive=[timeout=5, max=99], Connection=[Keep-Alive], Content-Type=[application/json]}>
  3. 2018-05-11 21:28:22,402 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Sending fileUpload request to Exavault API: <POST https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e0c5eab99d6ffab901de7342a61449a74e31fea12&destinationPath=%2Fshare%2Fsummary_report_report_1526063301046.xlsx&fileSize=3232&allowOverwrite=1&resume=0,[B@45c1cda0,{Accept=[*/*], Content-Length=[3232], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  4. 2018-05-11 21:28:27,630 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Received fileUpload response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results=true),{Server=[nginx], Date=[Fri, 11 May 2018 18:28:27 GMT], Content-Type=[application/json], Content-Length=[41], X-Powered-By=[PHP/7.1.17], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Strict-Transport-Security=[max-age=31536000; includeSubDomains; preload;]}>
  5. 2018-05-11 21:28:27,630 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Sending createShare request to Exavault API: <POST https://api.exavault.com/v1/createShare,CreateShareRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  6. 2018-05-11 21:28:29,897 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Received createShare response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"id":707835,"name":"Cubenix :: c44d5ab4-6978-4eec-98e7-b93c280f0d89","hasPassword":false,"public":true,"accessMode":"download","accessDescription":"Download only","embed":false,"hash":"ghsu-1k5ed14","ownerHash":"ghsu-1k5ed14-4qr37vjg","expiration":"2018-05-25 11:28:28","trackingStatus":"pending","expired":false,"resent":null,"owner":78413,"ownerUsername":"cubenix","type":"send","requireEmail":false,"fileDropCreateFolders":false,"paths":["/summary_report_report_1526063301046.xlsx"],"assets":[],"recipients":[{"id":763429,"shareId":707835,"type":"direct","hash":"8tif7fty","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:28:28"}],"recipientsWithOwner":[{"id":763429,"shareId":707835,"type":"direct","hash":"8tif7fty","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:28:28"},null],"messages":[],"inherited":null,"status":1,"hasNotification":false,"notification":null,"created":"2018-05-11 11:28:28","modified":null}),{Date=[Fri, 11 May 2018 18:28:28 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[1031], Keep-Alive=[timeout=5, max=100], Connection=[Keep-Alive], Content-Type=[application/json]}>
  7. 2018-05-11 21:29:24,875 [CubenixPool-1] INFO c.c.s.data.postgres.ReportRepository - ---> select provider_name as "provider_name", provider_mmis_no as "provider_mmis_no", manufacturer as "manufacturer", manufacturer_catalog_no as "manufacturer_catalog_no", catalog_item_description as "catalog_item_description", factor as "factor", ansi_uom as "ansi_uom", packaging_string as "packaging_string", last_cost_to_ea as "last_cost_to_ea", avg(benchmark_75p) as "benchmark_75p", avg(benchmark_90p) as "benchmark_90p", avg(benchmark_average) as "benchmark_average", avg(benchmark_high) as "benchmark_high", sum(quantity_to_ea) as "total_quantity", sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "opportunity", sum(benchmark_savings_90p) as "opportunity_90p", unspsc_code as "unspsc_code", unspsc_description as "unspsc_description", cur_contract_number as "cur_contract_number", cur_contract_description as "cur_contract_description", cur_ansi_uom as "cur_ansi_uom", cur_uom_factor as "cur_uom_factor" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PERIOPERATIVE SERVICES' and category_department_l1 = 'IMPLANTS, LARGE JOINT' and provider_name is not null and provider_mmis_no is not null and manufacturer is not null and manufacturer_catalog_no is not null and catalog_item_description is not null and factor is not null and ansi_uom is not null and packaging_string is not null and last_cost_to_ea is not null and unspsc_code is not null and unspsc_description is not null and cur_contract_number is not null and cur_contract_description is not null and cur_ansi_uom is not null and cur_uom_factor is not null and provider_id = 82031899) group by provider_name, provider_mmis_no, manufacturer, manufacturer_catalog_no, catalog_item_description, factor, ansi_uom, packaging_string, last_cost_to_ea, unspsc_code, unspsc_description, cur_contract_number, cur_contract_description, cur_ansi_uom, cur_uom_factor order by total_spend desc
  8. 2018-05-11 21:29:25,332 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Sending login request to Exavault API: <POST https://api.exavault.com/v1/authenticateUser,AuthenticationRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  9. 2018-05-11 21:29:26,691 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Received login response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"username":"cubenix","accessToken":"5af5e1068b1e4292df4e33c4629307a6619d03967c027","mode":0,"clientIp":"172.16.2.234"}),{Date=[Fri, 11 May 2018 18:29:26 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[156], Keep-Alive=[timeout=5, max=100], Connection=[Keep-Alive], Content-Type=[application/json]}>
  10. 2018-05-11 21:29:26,692 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Sending getUploadUrl request to Exavault API: <GET https://api.exavault.com/v1/getUploadFileUrl?access_token=5af5e1068b1e4292df4e33c4629307a6619d03967c027&fileSize=3233&destinationPath=%2Fshare%2Fsummary_report_report_1526063364866.xlsx&allowOverwrite=true&resume=false,{Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  11. 2018-05-11 21:29:27,018 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Received getUploadUrl response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"url":"https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e1068b1e4292df4e33c4629307a6619d03967c027&destinationPath=%2Fshare%2Fsummary_report_report_1526063364866.xlsx&fileSize=3233&allowOverwrite=1&resume=0","offset":0}),{Date=[Fri, 11 May 2018 18:29:26 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Cache-Control=[s-maxage=10], Content-Length=[272], Keep-Alive=[timeout=5, max=99], Connection=[Keep-Alive], Content-Type=[application/json]}>
  12. 2018-05-11 21:29:27,019 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Sending fileUpload request to Exavault API: <POST https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e1068b1e4292df4e33c4629307a6619d03967c027&destinationPath=%2Fshare%2Fsummary_report_report_1526063364866.xlsx&fileSize=3233&allowOverwrite=1&resume=0,[B@61523b94,{Accept=[*/*], Content-Length=[3233], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  13. 2018-05-11 21:29:28,245 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Received fileUpload response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results=true),{Server=[nginx], Date=[Fri, 11 May 2018 18:29:28 GMT], Content-Type=[application/json], Content-Length=[41], X-Powered-By=[PHP/7.1.17], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Strict-Transport-Security=[max-age=31536000; includeSubDomains; preload;]}>
  14. 2018-05-11 21:29:28,247 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Sending createShare request to Exavault API: <POST https://api.exavault.com/v1/createShare,CreateShareRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  15. 2018-05-11 21:29:29,178 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Received createShare response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"id":707837,"name":"Cubenix :: 68dfffb2-f93b-4153-99ae-be2879734608","hasPassword":false,"public":true,"accessMode":"download","accessDescription":"Download only","embed":false,"hash":"ghsw-cv9ive3s","ownerHash":"ghsw-cv9ive3s-ell5lmvc","expiration":"2018-05-25 11:29:28","trackingStatus":"pending","expired":false,"resent":null,"owner":78413,"ownerUsername":"cubenix","type":"send","requireEmail":false,"fileDropCreateFolders":false,"paths":["/summary_report_report_1526063364866.xlsx"],"assets":[],"recipients":[{"id":763431,"shareId":707837,"type":"direct","hash":"2y7739k8","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:29:28"}],"recipientsWithOwner":[{"id":763431,"shareId":707837,"type":"direct","hash":"2y7739k8","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:29:28"},null],"messages":[],"inherited":null,"status":1,"hasNotification":false,"notification":null,"created":"2018-05-11 11:29:28","modified":null}),{Date=[Fri, 11 May 2018 18:29:28 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[1033], Keep-Alive=[timeout=5, max=98], Connection=[Keep-Alive], Content-Type=[application/json]}>
  16. 2018-05-11 21:30:05,202 [CubenixPool-4] INFO c.c.s.data.postgres.ReportRepository - ---> select provider_name as "provider_name", provider_mmis_no as "provider_mmis_no", manufacturer as "manufacturer", manufacturer_catalog_no as "manufacturer_catalog_no", catalog_item_description as "catalog_item_description", factor as "factor", ansi_uom as "ansi_uom", packaging_string as "packaging_string", last_cost_to_ea as "last_cost_to_ea", avg(benchmark_75p) as "benchmark_75p", avg(benchmark_90p) as "benchmark_90p", avg(benchmark_average) as "benchmark_average", avg(benchmark_high) as "benchmark_high", sum(quantity_to_ea) as "total_quantity", sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "opportunity", sum(benchmark_savings_90p) as "opportunity_90p", unspsc_code as "unspsc_code", unspsc_description as "unspsc_description", cur_contract_number as "cur_contract_number", cur_contract_description as "cur_contract_description", cur_ansi_uom as "cur_ansi_uom", cur_uom_factor as "cur_uom_factor" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PERIOPERATIVE SERVICES' and category_department_l1 = 'IMPLANTS, LARGE JOINT' and provider_name is not null and provider_mmis_no is not null and manufacturer is not null and manufacturer_catalog_no is not null and catalog_item_description is not null and factor is not null and ansi_uom is not null and packaging_string is not null and last_cost_to_ea is not null and unspsc_code is not null and unspsc_description is not null and cur_contract_number is not null and cur_contract_description is not null and cur_ansi_uom is not null and cur_uom_factor is not null and provider_id = 82031899) group by provider_name, provider_mmis_no, manufacturer, manufacturer_catalog_no, catalog_item_description, factor, ansi_uom, packaging_string, last_cost_to_ea, unspsc_code, unspsc_description, cur_contract_number, cur_contract_description, cur_ansi_uom, cur_uom_factor order by total_spend desc
  17. 2018-05-11 21:30:05,647 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Sending login request to Exavault API: <POST https://api.exavault.com/v1/authenticateUser,AuthenticationRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  18. 2018-05-11 21:30:06,934 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Received login response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"username":"cubenix","accessToken":"5af5e12ebd17a60f9e8d6a85de07d3bf56df6cdec1c58","mode":0,"clientIp":"172.16.2.234"}),{Date=[Fri, 11 May 2018 18:30:06 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[156], Keep-Alive=[timeout=5, max=100], Connection=[Keep-Alive], Content-Type=[application/json]}>
  19. 2018-05-11 21:30:06,942 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Sending getUploadUrl request to Exavault API: <GET https://api.exavault.com/v1/getUploadFileUrl?access_token=5af5e12ebd17a60f9e8d6a85de07d3bf56df6cdec1c58&fileSize=3233&destinationPath=%2Fshare%2Fsummary_report_report_1526063405200.xlsx&allowOverwrite=true&resume=false,{Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  20. 2018-05-11 21:30:07,364 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Received getUploadUrl response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"url":"https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e12ebd17a60f9e8d6a85de07d3bf56df6cdec1c58&destinationPath=%2Fshare%2Fsummary_report_report_1526063405200.xlsx&fileSize=3233&allowOverwrite=1&resume=0","offset":0}),{Date=[Fri, 11 May 2018 18:30:07 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Cache-Control=[s-maxage=10], Content-Length=[272], Keep-Alive=[timeout=5, max=99], Connection=[Keep-Alive], Content-Type=[application/json]}>
  21. 2018-05-11 21:30:07,364 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Sending fileUpload request to Exavault API: <POST https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e12ebd17a60f9e8d6a85de07d3bf56df6cdec1c58&destinationPath=%2Fshare%2Fsummary_report_report_1526063405200.xlsx&fileSize=3233&allowOverwrite=1&resume=0,[B@30a5c310,{Accept=[*/*], Content-Length=[3233], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  22. 2018-05-11 21:30:08,898 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Received fileUpload response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results=true),{Server=[nginx], Date=[Fri, 11 May 2018 18:30:08 GMT], Content-Type=[application/json], Content-Length=[41], X-Powered-By=[PHP/7.1.17], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Strict-Transport-Security=[max-age=31536000; includeSubDomains; preload;]}>
  23. 2018-05-11 21:30:08,898 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Sending createShare request to Exavault API: <POST https://api.exavault.com/v1/createShare,CreateShareRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  24. 2018-05-11 21:30:09,617 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Received createShare response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"id":707839,"name":"Cubenix :: bf2621f2-c051-4736-83f2-2494c8a53abc","hasPassword":false,"public":true,"accessMode":"download","accessDescription":"Download only","embed":false,"hash":"ghsy-bp7x9ko8","ownerHash":"ghsy-bp7x9ko8-dmy7fl61","expiration":"2018-05-25 11:30:09","trackingStatus":"pending","expired":false,"resent":null,"owner":78413,"ownerUsername":"cubenix","type":"send","requireEmail":false,"fileDropCreateFolders":false,"paths":["/summary_report_report_1526063405200.xlsx"],"assets":[],"recipients":[{"id":763433,"shareId":707839,"type":"direct","hash":"2br8mwna","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:30:09"}],"recipientsWithOwner":[{"id":763433,"shareId":707839,"type":"direct","hash":"2br8mwna","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:30:09"},null],"messages":[],"inherited":null,"status":1,"hasNotification":false,"notification":null,"created":"2018-05-11 11:30:09","modified":null}),{Date=[Fri, 11 May 2018 18:30:09 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[1033], Keep-Alive=[timeout=5, max=98], Connection=[Keep-Alive], Content-Type=[application/json]}>
  25. 2018-05-11 21:30:34,687 [cube-core-dispatcher-57] INFO c.c.s.d.i.TransactionalItemService - Auto archived 0 items.
  26. 2018-05-11 21:30:42,607 [CubenixPool-3] INFO c.c.s.data.postgres.ReportRepository - ---> select provider_name as "provider_name", provider_mmis_no as "provider_mmis_no", manufacturer as "manufacturer", manufacturer_catalog_no as "manufacturer_catalog_no", catalog_item_description as "catalog_item_description", factor as "factor", ansi_uom as "ansi_uom", packaging_string as "packaging_string", last_cost_to_ea as "last_cost_to_ea", avg(benchmark_75p) as "benchmark_75p", avg(benchmark_90p) as "benchmark_90p", avg(benchmark_average) as "benchmark_average", avg(benchmark_high) as "benchmark_high", sum(quantity_to_ea) as "total_quantity", sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "opportunity", sum(benchmark_savings_90p) as "opportunity_90p", unspsc_code as "unspsc_code", unspsc_description as "unspsc_description", cur_contract_number as "cur_contract_number", cur_contract_description as "cur_contract_description", cur_ansi_uom as "cur_ansi_uom", cur_uom_factor as "cur_uom_factor" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PERIOPERATIVE SERVICES' and category_department_l1 = 'IMPLANTS, SPINAL' and provider_name is not null and provider_mmis_no is not null and manufacturer is not null and manufacturer_catalog_no is not null and catalog_item_description is not null and factor is not null and ansi_uom is not null and packaging_string is not null and last_cost_to_ea is not null and unspsc_code is not null and unspsc_description is not null and cur_contract_number is not null and cur_contract_description is not null and cur_ansi_uom is not null and cur_uom_factor is not null and provider_id = 82031899) group by provider_name, provider_mmis_no, manufacturer, manufacturer_catalog_no, catalog_item_description, factor, ansi_uom, packaging_string, last_cost_to_ea, unspsc_code, unspsc_description, cur_contract_number, cur_contract_description, cur_ansi_uom, cur_uom_factor order by total_spend desc
  27. 2018-05-11 21:30:42,848 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Sending login request to Exavault API: <POST https://api.exavault.com/v1/authenticateUser,AuthenticationRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  28. 2018-05-11 21:30:44,132 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Received login response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"username":"cubenix","accessToken":"5af5e153ed0f3373b688351ee33a9c5edff6f40233297","mode":0,"clientIp":"172.16.2.234"}),{Date=[Fri, 11 May 2018 18:30:43 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[156], Keep-Alive=[timeout=5, max=100], Connection=[Keep-Alive], Content-Type=[application/json]}>
  29. 2018-05-11 21:30:44,133 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Sending getUploadUrl request to Exavault API: <GET https://api.exavault.com/v1/getUploadFileUrl?access_token=5af5e153ed0f3373b688351ee33a9c5edff6f40233297&fileSize=3233&destinationPath=%2Fshare%2Fsummary_report_report_1526063442602.xlsx&allowOverwrite=true&resume=false,{Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  30. 2018-05-11 21:30:44,442 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Received getUploadUrl response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"url":"https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e153ed0f3373b688351ee33a9c5edff6f40233297&destinationPath=%2Fshare%2Fsummary_report_report_1526063442602.xlsx&fileSize=3233&allowOverwrite=1&resume=0","offset":0}),{Date=[Fri, 11 May 2018 18:30:44 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Cache-Control=[s-maxage=10], Content-Length=[272], Keep-Alive=[timeout=5, max=99], Connection=[Keep-Alive], Content-Type=[application/json]}>
  31. 2018-05-11 21:30:44,442 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Sending fileUpload request to Exavault API: <POST https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e153ed0f3373b688351ee33a9c5edff6f40233297&destinationPath=%2Fshare%2Fsummary_report_report_1526063442602.xlsx&fileSize=3233&allowOverwrite=1&resume=0,[B@7dd280a8,{Accept=[*/*], Content-Length=[3233], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  32. 2018-05-11 21:30:45,053 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Received fileUpload response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results=true),{Server=[nginx], Date=[Fri, 11 May 2018 18:30:44 GMT], Content-Type=[application/json], Content-Length=[41], X-Powered-By=[PHP/7.1.17], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Strict-Transport-Security=[max-age=31536000; includeSubDomains; preload;]}>
  33. 2018-05-11 21:30:45,054 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Sending createShare request to Exavault API: <POST https://api.exavault.com/v1/createShare,CreateShareRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  34. 2018-05-11 21:30:46,588 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Received createShare response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"id":707841,"name":"Cubenix :: c238e41e-f337-4e29-b1b4-b77e0674dfb2","hasPassword":false,"public":true,"accessMode":"download","accessDescription":"Download only","embed":false,"hash":"ght1-3n4r4uoj","ownerHash":"ght1-3n4r4uoj-3ml4w6gy","expiration":"2018-05-25 11:30:45","trackingStatus":"pending","expired":false,"resent":null,"owner":78413,"ownerUsername":"cubenix","type":"send","requireEmail":false,"fileDropCreateFolders":false,"paths":["/summary_report_report_1526063442602.xlsx"],"assets":[],"recipients":[{"id":763445,"shareId":707841,"type":"direct","hash":"7v7bv5th","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:30:45"}],"recipientsWithOwner":[{"id":763445,"shareId":707841,"type":"direct","hash":"7v7bv5th","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:30:45"},null],"messages":[],"inherited":null,"status":1,"hasNotification":false,"notification":null,"created":"2018-05-11 11:30:45","modified":null}),{Date=[Fri, 11 May 2018 18:30:45 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[1033], Keep-Alive=[timeout=5, max=98], Connection=[Keep-Alive], Content-Type=[application/json]}>
  35. 2018-05-11 21:31:47,877 [CubenixPool-2] INFO c.c.s.data.postgres.ReportRepository - ---> select provider_name as "provider_name", provider_mmis_no as "provider_mmis_no", manufacturer as "manufacturer", manufacturer_catalog_no as "manufacturer_catalog_no", catalog_item_description as "catalog_item_description", factor as "factor", ansi_uom as "ansi_uom", packaging_string as "packaging_string", last_cost_to_ea as "last_cost_to_ea", avg(benchmark_75p) as "benchmark_75p", avg(benchmark_90p) as "benchmark_90p", avg(benchmark_average) as "benchmark_average", avg(benchmark_high) as "benchmark_high", sum(quantity_to_ea) as "total_quantity", sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "opportunity", sum(benchmark_savings_90p) as "opportunity_90p", unspsc_code as "unspsc_code", unspsc_description as "unspsc_description", cur_contract_number as "cur_contract_number", cur_contract_description as "cur_contract_description", cur_ansi_uom as "cur_ansi_uom", cur_uom_factor as "cur_uom_factor" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PERIOPERATIVE SERVICES' and category_department_l1 = 'IMPLANTS, LARGE JOINT' and provider_name is not null and provider_mmis_no is not null and manufacturer is not null and manufacturer_catalog_no is not null and catalog_item_description is not null and factor is not null and ansi_uom is not null and packaging_string is not null and last_cost_to_ea is not null and unspsc_code is not null and unspsc_description is not null and cur_contract_number is not null and cur_contract_description is not null and cur_ansi_uom is not null and cur_uom_factor is not null and provider_id = 82031899) group by provider_name, provider_mmis_no, manufacturer, manufacturer_catalog_no, catalog_item_description, factor, ansi_uom, packaging_string, last_cost_to_ea, unspsc_code, unspsc_description, cur_contract_number, cur_contract_description, cur_ansi_uom, cur_uom_factor order by total_spend desc
  36. 2018-05-11 21:31:48,222 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Sending login request to Exavault API: <POST https://api.exavault.com/v1/authenticateUser,AuthenticationRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  37. 2018-05-11 21:31:49,792 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Received login response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"username":"cubenix","accessToken":"5af5e1956a1d1eaeebc7bc634e82075eb7fabb4ce07f1","mode":0,"clientIp":"172.16.2.234"}),{Date=[Fri, 11 May 2018 18:31:49 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[156], Keep-Alive=[timeout=5, max=100], Connection=[Keep-Alive], Content-Type=[application/json]}>
  38. 2018-05-11 21:31:49,795 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Sending getUploadUrl request to Exavault API: <GET https://api.exavault.com/v1/getUploadFileUrl?access_token=5af5e1956a1d1eaeebc7bc634e82075eb7fabb4ce07f1&fileSize=3233&destinationPath=%2Fshare%2Fsummary_report_report_1526063507868.xlsx&allowOverwrite=true&resume=false,{Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  39. 2018-05-11 21:31:50,090 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Received getUploadUrl response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"url":"https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e1956a1d1eaeebc7bc634e82075eb7fabb4ce07f1&destinationPath=%2Fshare%2Fsummary_report_report_1526063507868.xlsx&fileSize=3233&allowOverwrite=1&resume=0","offset":0}),{Date=[Fri, 11 May 2018 18:31:49 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Cache-Control=[s-maxage=10], Content-Length=[272], Keep-Alive=[timeout=5, max=99], Connection=[Keep-Alive], Content-Type=[application/json]}>
  40. 2018-05-11 21:31:50,091 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Sending fileUpload request to Exavault API: <POST https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e1956a1d1eaeebc7bc634e82075eb7fabb4ce07f1&destinationPath=%2Fshare%2Fsummary_report_report_1526063507868.xlsx&fileSize=3233&allowOverwrite=1&resume=0,[B@245235a6,{Accept=[*/*], Content-Length=[3233], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  41. 2018-05-11 21:31:53,834 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Received fileUpload response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results=true),{Server=[nginx], Date=[Fri, 11 May 2018 18:31:53 GMT], Content-Type=[application/json], Content-Length=[41], X-Powered-By=[PHP/7.1.17], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Strict-Transport-Security=[max-age=31536000; includeSubDomains; preload;]}>
  42. 2018-05-11 21:31:53,834 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Sending createShare request to Exavault API: <POST https://api.exavault.com/v1/createShare,CreateShareRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  43. 2018-05-11 21:31:55,918 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Received createShare response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"id":707843,"name":"Cubenix :: 50c792f2-dc39-47bc-8972-3a25062a5bde","hasPassword":false,"public":true,"accessMode":"download","accessDescription":"Download only","embed":false,"hash":"ght3-4x0pylwq","ownerHash":"ght3-4x0pylwq-eucpvfpi","expiration":"2018-05-25 11:31:54","trackingStatus":"pending","expired":false,"resent":null,"owner":78413,"ownerUsername":"cubenix","type":"send","requireEmail":false,"fileDropCreateFolders":false,"paths":["/summary_report_report_1526063507868.xlsx"],"assets":[],"recipients":[{"id":763447,"shareId":707843,"type":"direct","hash":"ctxowaia","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:31:54"}],"recipientsWithOwner":[{"id":763447,"shareId":707843,"type":"direct","hash":"ctxowaia","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:31:54"},null],"messages":[],"inherited":null,"status":1,"hasNotification":false,"notification":null,"created":"2018-05-11 11:31:54","modified":null}),{Date=[Fri, 11 May 2018 18:31:53 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[1033], Keep-Alive=[timeout=5, max=98], Connection=[Keep-Alive], Content-Type=[application/json]}>
  44. 2018-05-11 21:33:08,427 [http-nio-8080-exec-2] WARN c.c.s.e.GlobalControllerExceptionHandler - Exception, message: java.io.IOException: Broken pipe
  45. 2018-05-11 21:33:08,435 [http-nio-8080-exec-2] WARN o.s.w.s.m.m.a.ExceptionHandlerExceptionResolver - Failed to invoke @ExceptionHandler method: public org.springframework.http.ResponseEntity com.cube.server.exception.GlobalControllerExceptionHandler.handleException(java.lang.Exception)
  46. org.apache.catalina.connector.ClientAbortException: java.io.IOException: Broken pipe
  47. at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:356)
  48. at org.apache.catalina.connector.OutputBuffer.flushByteBuffer(OutputBuffer.java:815)
  49. at org.apache.catalina.connector.OutputBuffer.append(OutputBuffer.java:720)
  50. at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:391)
  51. at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:369)
  52. at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:96)
  53. at sun.nio.cs.StreamEncoder.writeBytes(StreamEncoder.java:221)
  54. at sun.nio.cs.StreamEncoder.implFlushBuffer(StreamEncoder.java:291)
  55. at sun.nio.cs.StreamEncoder.implFlush(StreamEncoder.java:295)
  56. at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:141)
  57. at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:229)
  58. at org.springframework.util.StreamUtils.copy(StreamUtils.java:119)
  59. at org.springframework.http.converter.StringHttpMessageConverter.writeInternal(StringHttpMessageConverter.java:106)
  60. at org.springframework.http.converter.StringHttpMessageConverter.writeInternal(StringHttpMessageConverter.java:41)
  61. at org.springframework.http.converter.AbstractHttpMessageConverter.write(AbstractHttpMessageConverter.java:227)
  62. at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters(AbstractMessageConverterMethodProcessor.java:247)
  63. at org.springframework.web.servlet.mvc.method.annotation.HttpEntityMethodProcessor.handleReturnValue(HttpEntityMethodProcessor.java:203)
  64. at org.springframework.web.method.support.HandlerMethodReturnValueHandlerComposite.handleReturnValue(HandlerMethodReturnValueHandlerComposite.java:81)
  65. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:113)
  66. at org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver.doResolveHandlerMethodException(ExceptionHandlerExceptionResolver.java:380)
  67. at org.springframework.web.servlet.handler.AbstractHandlerMethodExceptionResolver.doResolveException(AbstractHandlerMethodExceptionResolver.java:59)
  68. at org.springframework.web.servlet.handler.AbstractHandlerExceptionResolver.resolveException(AbstractHandlerExceptionResolver.java:136)
  69. at org.springframework.web.servlet.handler.HandlerExceptionResolverComposite.resolveException(HandlerExceptionResolverComposite.java:76)
  70. at org.springframework.web.servlet.DispatcherServlet.processHandlerException(DispatcherServlet.java:1222)
  71. at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1034)
  72. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:984)
  73. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  74. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  75. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
  76. at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
  77. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  78. at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  79. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  80. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  81. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  82. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  83. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  84. at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.doFilterInternal(ApplicationContextHeaderFilter.java:55)
  85. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  86. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  87. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  88. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)
  89. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  90. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  91. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)
  92. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  93. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  94. at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:110)
  95. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  96. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  97. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  98. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
  99. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  100. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  101. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  102. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
  103. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  104. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  105. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  106. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
  107. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  108. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
  109. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  110. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  111. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  112. at com.cube.server.security.JwtAuthenticationTokenFilter.doFilterInternal(JwtAuthenticationTokenFilter.java:45)
  113. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  114. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  115. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
  116. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  117. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
  118. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  119. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  120. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
  121. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  122. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  123. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  124. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  125. at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
  126. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  127. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  128. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
  129. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
  130. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347)
  131. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263)
  132. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  133. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  134. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
  135. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  136. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  137. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  138. at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:108)
  139. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  140. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  141. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  142. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
  143. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  144. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  145. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  146. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
  147. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  148. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  149. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  150. at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106)
  151. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  152. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  153. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  154. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
  155. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  156. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
  157. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  158. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
  159. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  160. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  161. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
  162. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  163. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
  164. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
  165. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  166. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  167. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  168. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  169. at java.lang.Thread.run(Thread.java:748)
  170. Caused by: java.io.IOException: Broken pipe
  171. at sun.nio.ch.FileDispatcherImpl.write0(Native Method)
  172. at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47)
  173. at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:93)
  174. at sun.nio.ch.IOUtil.write(IOUtil.java:65)
  175. at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:471)
  176. at org.apache.tomcat.util.net.NioChannel.write(NioChannel.java:134)
  177. at org.apache.tomcat.util.net.NioBlockingSelector.write(NioBlockingSelector.java:101)
  178. at org.apache.tomcat.util.net.NioSelectorPool.write(NioSelectorPool.java:157)
  179. at org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper.doWrite(NioEndpoint.java:1267)
  180. at org.apache.tomcat.util.net.SocketWrapperBase.doWrite(SocketWrapperBase.java:670)
  181. at org.apache.tomcat.util.net.SocketWrapperBase.writeBlocking(SocketWrapperBase.java:450)
  182. at org.apache.tomcat.util.net.SocketWrapperBase.write(SocketWrapperBase.java:388)
  183. at org.apache.coyote.http11.Http11OutputBuffer$SocketOutputBuffer.doWrite(Http11OutputBuffer.java:644)
  184. at org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:121)
  185. at org.apache.coyote.http11.Http11OutputBuffer.doWrite(Http11OutputBuffer.java:235)
  186. at org.apache.coyote.Response.doWrite(Response.java:541)
  187. at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:351)
  188. ... 122 common frames omitted
  189. 2018-05-11 21:33:08,664 [http-nio-8080-exec-5] WARN c.c.s.e.GlobalControllerExceptionHandler - Exception, message: java.io.IOException: Broken pipe
  190. 2018-05-11 21:33:08,665 [http-nio-8080-exec-5] WARN o.s.w.s.m.m.a.ExceptionHandlerExceptionResolver - Failed to invoke @ExceptionHandler method: public org.springframework.http.ResponseEntity com.cube.server.exception.GlobalControllerExceptionHandler.handleException(java.lang.Exception)
  191. org.apache.catalina.connector.ClientAbortException: java.io.IOException: Broken pipe
  192. at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:356)
  193. at org.apache.catalina.connector.OutputBuffer.flushByteBuffer(OutputBuffer.java:815)
  194. at org.apache.catalina.connector.OutputBuffer.append(OutputBuffer.java:720)
  195. at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:391)
  196. at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:369)
  197. at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:96)
  198. at sun.nio.cs.StreamEncoder.writeBytes(StreamEncoder.java:221)
  199. at sun.nio.cs.StreamEncoder.implFlushBuffer(StreamEncoder.java:291)
  200. at sun.nio.cs.StreamEncoder.implFlush(StreamEncoder.java:295)
  201. at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:141)
  202. at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:229)
  203. at org.springframework.util.StreamUtils.copy(StreamUtils.java:119)
  204. at org.springframework.http.converter.StringHttpMessageConverter.writeInternal(StringHttpMessageConverter.java:106)
  205. at org.springframework.http.converter.StringHttpMessageConverter.writeInternal(StringHttpMessageConverter.java:41)
  206. at org.springframework.http.converter.AbstractHttpMessageConverter.write(AbstractHttpMessageConverter.java:227)
  207. at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters(AbstractMessageConverterMethodProcessor.java:247)
  208. at org.springframework.web.servlet.mvc.method.annotation.HttpEntityMethodProcessor.handleReturnValue(HttpEntityMethodProcessor.java:203)
  209. at org.springframework.web.method.support.HandlerMethodReturnValueHandlerComposite.handleReturnValue(HandlerMethodReturnValueHandlerComposite.java:81)
  210. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:113)
  211. at org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver.doResolveHandlerMethodException(ExceptionHandlerExceptionResolver.java:380)
  212. at org.springframework.web.servlet.handler.AbstractHandlerMethodExceptionResolver.doResolveException(AbstractHandlerMethodExceptionResolver.java:59)
  213. at org.springframework.web.servlet.handler.AbstractHandlerExceptionResolver.resolveException(AbstractHandlerExceptionResolver.java:136)
  214. at org.springframework.web.servlet.handler.HandlerExceptionResolverComposite.resolveException(HandlerExceptionResolverComposite.java:76)
  215. at org.springframework.web.servlet.DispatcherServlet.processHandlerException(DispatcherServlet.java:1222)
  216. at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1034)
  217. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:984)
  218. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  219. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  220. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
  221. at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
  222. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  223. at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  224. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  225. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  226. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  227. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  228. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  229. at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.doFilterInternal(ApplicationContextHeaderFilter.java:55)
  230. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  231. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  232. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  233. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)
  234. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  235. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  236. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)
  237. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  238. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  239. at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:110)
  240. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  241. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  242. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  243. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
  244. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  245. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  246. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  247. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
  248. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  249. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  250. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  251. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
  252. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  253. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
  254. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  255. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  256. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  257. at com.cube.server.security.JwtAuthenticationTokenFilter.doFilterInternal(JwtAuthenticationTokenFilter.java:45)
  258. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  259. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  260. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
  261. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  262. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
  263. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  264. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  265. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
  266. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  267. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  268. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  269. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  270. at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
  271. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  272. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  273. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
  274. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
  275. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347)
  276. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263)
  277. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  278. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  279. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
  280. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  281. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  282. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  283. at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:108)
  284. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  285. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  286. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  287. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
  288. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  289. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  290. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  291. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
  292. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  293. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  294. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  295. at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106)
  296. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  297. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  298. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  299. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
  300. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  301. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
  302. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  303. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
  304. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  305. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  306. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
  307. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  308. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
  309. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
  310. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  311. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  312. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  313. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  314. at java.lang.Thread.run(Thread.java:748)
  315. Caused by: java.io.IOException: Broken pipe
  316. at sun.nio.ch.FileDispatcherImpl.write0(Native Method)
  317. at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47)
  318. at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:93)
  319. at sun.nio.ch.IOUtil.write(IOUtil.java:65)
  320. at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:471)
  321. at org.apache.tomcat.util.net.NioChannel.write(NioChannel.java:134)
  322. at org.apache.tomcat.util.net.NioBlockingSelector.write(NioBlockingSelector.java:101)
  323. at org.apache.tomcat.util.net.NioSelectorPool.write(NioSelectorPool.java:157)
  324. at org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper.doWrite(NioEndpoint.java:1267)
  325. at org.apache.tomcat.util.net.SocketWrapperBase.doWrite(SocketWrapperBase.java:670)
  326. at org.apache.tomcat.util.net.SocketWrapperBase.writeBlocking(SocketWrapperBase.java:450)
  327. at org.apache.tomcat.util.net.SocketWrapperBase.write(SocketWrapperBase.java:388)
  328. at org.apache.coyote.http11.Http11OutputBuffer$SocketOutputBuffer.doWrite(Http11OutputBuffer.java:644)
  329. at org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:121)
  330. at org.apache.coyote.http11.Http11OutputBuffer.doWrite(Http11OutputBuffer.java:235)
  331. at org.apache.coyote.Response.doWrite(Response.java:541)
  332. at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:351)
  333. ... 122 common frames omitted
  334. 2018-05-11 21:33:23,479 [CubenixPool-1] INFO c.c.s.data.postgres.ReportRepository - ---> select provider_name as "provider_name", provider_mmis_no as "provider_mmis_no", manufacturer as "manufacturer", manufacturer_catalog_no as "manufacturer_catalog_no", catalog_item_description as "catalog_item_description", factor as "factor", ansi_uom as "ansi_uom", packaging_string as "packaging_string", last_cost_to_ea as "last_cost_to_ea", avg(benchmark_75p) as "benchmark_75p", avg(benchmark_90p) as "benchmark_90p", avg(benchmark_average) as "benchmark_average", avg(benchmark_high) as "benchmark_high", sum(quantity_to_ea) as "total_quantity", sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "opportunity", sum(benchmark_savings_90p) as "opportunity_90p", unspsc_code as "unspsc_code", unspsc_description as "unspsc_description", cur_contract_number as "cur_contract_number", cur_contract_description as "cur_contract_description", cur_ansi_uom as "cur_ansi_uom", cur_uom_factor as "cur_uom_factor" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PERIOPERATIVE SERVICES' and category_department_l1 = 'IMPLANTS, LARGE JOINT' and provider_name is not null and provider_mmis_no is not null and manufacturer is not null and manufacturer_catalog_no is not null and catalog_item_description is not null and factor is not null and ansi_uom is not null and packaging_string is not null and last_cost_to_ea is not null and unspsc_code is not null and unspsc_description is not null and cur_contract_number is not null and cur_contract_description is not null and cur_ansi_uom is not null and cur_uom_factor is not null and provider_id = 82031899) group by provider_name, provider_mmis_no, manufacturer, manufacturer_catalog_no, catalog_item_description, factor, ansi_uom, packaging_string, last_cost_to_ea, unspsc_code, unspsc_description, cur_contract_number, cur_contract_description, cur_ansi_uom, cur_uom_factor order by total_spend desc
  335. 2018-05-11 21:33:23,949 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Sending login request to Exavault API: <POST https://api.exavault.com/v1/authenticateUser,AuthenticationRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  336. 2018-05-11 21:33:24,800 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Received login response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"username":"cubenix","accessToken":"5af5e1f4a1d55bc8ef79fdededd52ab8d3e3fa9a6ada2","mode":0,"clientIp":"172.16.2.234"}),{Date=[Fri, 11 May 2018 18:33:24 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[156], Keep-Alive=[timeout=5, max=100], Connection=[Keep-Alive], Content-Type=[application/json]}>
  337. 2018-05-11 21:33:24,802 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Sending getUploadUrl request to Exavault API: <GET https://api.exavault.com/v1/getUploadFileUrl?access_token=5af5e1f4a1d55bc8ef79fdededd52ab8d3e3fa9a6ada2&fileSize=3232&destinationPath=%2Fshare%2Fsummary_report_report_1526063603469.xlsx&allowOverwrite=true&resume=false,{Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  338. 2018-05-11 21:33:25,106 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Received getUploadUrl response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"url":"https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e1f4a1d55bc8ef79fdededd52ab8d3e3fa9a6ada2&destinationPath=%2Fshare%2Fsummary_report_report_1526063603469.xlsx&fileSize=3232&allowOverwrite=1&resume=0","offset":0}),{Date=[Fri, 11 May 2018 18:33:24 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Cache-Control=[s-maxage=10], Content-Length=[272], Keep-Alive=[timeout=5, max=99], Connection=[Keep-Alive], Content-Type=[application/json]}>
  339. 2018-05-11 21:33:25,106 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Sending fileUpload request to Exavault API: <POST https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e1f4a1d55bc8ef79fdededd52ab8d3e3fa9a6ada2&destinationPath=%2Fshare%2Fsummary_report_report_1526063603469.xlsx&fileSize=3232&allowOverwrite=1&resume=0,[B@56b754cc,{Accept=[*/*], Content-Length=[3232], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  340. 2018-05-11 21:33:27,467 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Received fileUpload response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results=true),{Server=[nginx], Date=[Fri, 11 May 2018 18:33:27 GMT], Content-Type=[application/json], Content-Length=[41], X-Powered-By=[PHP/7.1.17], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Strict-Transport-Security=[max-age=31536000; includeSubDomains; preload;]}>
  341. 2018-05-11 21:33:27,468 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Sending createShare request to Exavault API: <POST https://api.exavault.com/v1/createShare,CreateShareRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  342. 2018-05-11 21:33:28,282 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Received createShare response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"id":707847,"name":"Cubenix :: e8ad5bb4-6736-408b-ad2a-ef3986f3c132","hasPassword":false,"public":true,"accessMode":"download","accessDescription":"Download only","embed":false,"hash":"ght7-9q27dhfd","ownerHash":"ght7-9q27dhfd-43ewf27","expiration":"2018-05-25 11:33:28","trackingStatus":"pending","expired":false,"resent":null,"owner":78413,"ownerUsername":"cubenix","type":"send","requireEmail":false,"fileDropCreateFolders":false,"paths":["/summary_report_report_1526063603469.xlsx"],"assets":[],"recipients":[{"id":763449,"shareId":707847,"type":"direct","hash":"e48ryx2l","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:33:28"}],"recipientsWithOwner":[{"id":763449,"shareId":707847,"type":"direct","hash":"e48ryx2l","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:33:28"},null],"messages":[],"inherited":null,"status":1,"hasNotification":false,"notification":null,"created":"2018-05-11 11:33:28","modified":null}),{Date=[Fri, 11 May 2018 18:33:27 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[1032], Keep-Alive=[timeout=5, max=98], Connection=[Keep-Alive], Content-Type=[application/json]}>
  343. 2018-05-11 21:34:39,413 [CubenixPool-4] INFO c.c.s.data.postgres.ReportRepository - ---> select provider_name as "provider_name", provider_mmis_no as "provider_mmis_no", manufacturer as "manufacturer", manufacturer_catalog_no as "manufacturer_catalog_no", catalog_item_description as "catalog_item_description", factor as "factor", ansi_uom as "ansi_uom", packaging_string as "packaging_string", last_cost_to_ea as "last_cost_to_ea", avg(benchmark_75p) as "benchmark_75p", avg(benchmark_90p) as "benchmark_90p", avg(benchmark_average) as "benchmark_average", avg(benchmark_high) as "benchmark_high", sum(quantity_to_ea) as "total_quantity", sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "opportunity", sum(benchmark_savings_90p) as "opportunity_90p", unspsc_code as "unspsc_code", unspsc_description as "unspsc_description", cur_contract_number as "cur_contract_number", cur_contract_description as "cur_contract_description", cur_ansi_uom as "cur_ansi_uom", cur_uom_factor as "cur_uom_factor" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PERIOPERATIVE SERVICES' and category_department_l1 = 'IMPLANTS, LARGE JOINT' and provider_name is not null and provider_mmis_no is not null and manufacturer is not null and manufacturer_catalog_no is not null and catalog_item_description is not null and factor is not null and ansi_uom is not null and packaging_string is not null and last_cost_to_ea is not null and unspsc_code is not null and unspsc_description is not null and cur_contract_number is not null and cur_contract_description is not null and cur_ansi_uom is not null and cur_uom_factor is not null and provider_id = 82031899) group by provider_name, provider_mmis_no, manufacturer, manufacturer_catalog_no, catalog_item_description, factor, ansi_uom, packaging_string, last_cost_to_ea, unspsc_code, unspsc_description, cur_contract_number, cur_contract_description, cur_ansi_uom, cur_uom_factor order by total_spend desc
  344. 2018-05-11 21:34:39,835 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Sending login request to Exavault API: <POST https://api.exavault.com/v1/authenticateUser,AuthenticationRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  345. 2018-05-11 21:34:41,063 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Received login response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"username":"cubenix","accessToken":"5af5e240e58b79317ddd8e347f9bddfbf03ece54fe209","mode":0,"clientIp":"172.16.2.234"}),{Date=[Fri, 11 May 2018 18:34:40 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[156], Keep-Alive=[timeout=5, max=100], Connection=[Keep-Alive], Content-Type=[application/json]}>
  346. 2018-05-11 21:34:41,064 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Sending getUploadUrl request to Exavault API: <GET https://api.exavault.com/v1/getUploadFileUrl?access_token=5af5e240e58b79317ddd8e347f9bddfbf03ece54fe209&fileSize=3233&destinationPath=%2Fshare%2Fsummary_report_report_1526063679405.xlsx&allowOverwrite=true&resume=false,{Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  347. 2018-05-11 21:34:41,343 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Received getUploadUrl response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"url":"https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e240e58b79317ddd8e347f9bddfbf03ece54fe209&destinationPath=%2Fshare%2Fsummary_report_report_1526063679405.xlsx&fileSize=3233&allowOverwrite=1&resume=0","offset":0}),{Date=[Fri, 11 May 2018 18:34:41 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Cache-Control=[s-maxage=10], Content-Length=[272], Keep-Alive=[timeout=5, max=99], Connection=[Keep-Alive], Content-Type=[application/json]}>
  348. 2018-05-11 21:34:41,344 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Sending fileUpload request to Exavault API: <POST https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e240e58b79317ddd8e347f9bddfbf03ece54fe209&destinationPath=%2Fshare%2Fsummary_report_report_1526063679405.xlsx&fileSize=3233&allowOverwrite=1&resume=0,[B@5a815637,{Accept=[*/*], Content-Length=[3233], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  349. 2018-05-11 21:34:42,011 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Received fileUpload response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results=true),{Server=[nginx], Date=[Fri, 11 May 2018 18:34:41 GMT], Content-Type=[application/json], Content-Length=[41], X-Powered-By=[PHP/7.1.17], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Strict-Transport-Security=[max-age=31536000; includeSubDomains; preload;]}>
  350. 2018-05-11 21:34:42,012 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Sending createShare request to Exavault API: <POST https://api.exavault.com/v1/createShare,CreateShareRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  351. 2018-05-11 21:34:42,932 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Received createShare response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"id":707851,"name":"Cubenix :: 95b85820-0f6b-4091-a14e-10ba20008609","hasPassword":false,"public":true,"accessMode":"download","accessDescription":"Download only","embed":false,"hash":"ghtb-au26bdv4","ownerHash":"ghtb-au26bdv4-dnqy2ik3","expiration":"2018-05-25 11:34:42","trackingStatus":"pending","expired":false,"resent":null,"owner":78413,"ownerUsername":"cubenix","type":"send","requireEmail":false,"fileDropCreateFolders":false,"paths":["/summary_report_report_1526063679405.xlsx"],"assets":[],"recipients":[{"id":763451,"shareId":707851,"type":"direct","hash":"7ovguc9m","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:34:42"}],"recipientsWithOwner":[{"id":763451,"shareId":707851,"type":"direct","hash":"7ovguc9m","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:34:42"},null],"messages":[],"inherited":null,"status":1,"hasNotification":false,"notification":null,"created":"2018-05-11 11:34:42","modified":null}),{Date=[Fri, 11 May 2018 18:34:42 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[1033], Keep-Alive=[timeout=5, max=98], Connection=[Keep-Alive], Content-Type=[application/json]}>
  352. 2018-05-11 21:36:21,204 [CubenixPool-3] INFO c.c.s.data.postgres.ReportRepository - ---> select provider_name as "provider_name", provider_mmis_no as "provider_mmis_no", manufacturer as "manufacturer", manufacturer_catalog_no as "manufacturer_catalog_no", catalog_item_description as "catalog_item_description", factor as "factor", ansi_uom as "ansi_uom", packaging_string as "packaging_string", last_cost_to_ea as "last_cost_to_ea", avg(benchmark_75p) as "benchmark_75p", avg(benchmark_90p) as "benchmark_90p", avg(benchmark_average) as "benchmark_average", avg(benchmark_high) as "benchmark_high", sum(quantity_to_ea) as "total_quantity", sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "opportunity", sum(benchmark_savings_90p) as "opportunity_90p", unspsc_code as "unspsc_code", unspsc_description as "unspsc_description", cur_contract_number as "cur_contract_number", cur_contract_description as "cur_contract_description", cur_ansi_uom as "cur_ansi_uom", cur_uom_factor as "cur_uom_factor" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PERIOPERATIVE SERVICES' and category_department_l1 = 'IMPLANTS, LARGE JOINT' and provider_name is not null and provider_mmis_no is not null and manufacturer is not null and manufacturer_catalog_no is not null and catalog_item_description is not null and factor is not null and ansi_uom is not null and packaging_string is not null and last_cost_to_ea is not null and unspsc_code is not null and unspsc_description is not null and cur_contract_number is not null and cur_contract_description is not null and cur_ansi_uom is not null and cur_uom_factor is not null and provider_id = 82031899) group by provider_name, provider_mmis_no, manufacturer, manufacturer_catalog_no, catalog_item_description, factor, ansi_uom, packaging_string, last_cost_to_ea, unspsc_code, unspsc_description, cur_contract_number, cur_contract_description, cur_ansi_uom, cur_uom_factor order by total_spend desc
  353. 2018-05-11 21:36:21,629 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Sending login request to Exavault API: <POST https://api.exavault.com/v1/authenticateUser,AuthenticationRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  354. 2018-05-11 21:36:22,443 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Received login response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"username":"cubenix","accessToken":"5af5e2a64dc6ab4a4d62ad40a3e35d14a648b981f8ab4","mode":0,"clientIp":"172.16.2.234"}),{Date=[Fri, 11 May 2018 18:36:22 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[156], Keep-Alive=[timeout=5, max=100], Connection=[Keep-Alive], Content-Type=[application/json]}>
  355. 2018-05-11 21:36:22,443 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Sending getUploadUrl request to Exavault API: <GET https://api.exavault.com/v1/getUploadFileUrl?access_token=5af5e2a64dc6ab4a4d62ad40a3e35d14a648b981f8ab4&fileSize=3233&destinationPath=%2Fshare%2Fsummary_report_report_1526063781197.xlsx&allowOverwrite=true&resume=false,{Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  356. 2018-05-11 21:36:22,772 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Received getUploadUrl response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"url":"https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e2a64dc6ab4a4d62ad40a3e35d14a648b981f8ab4&destinationPath=%2Fshare%2Fsummary_report_report_1526063781197.xlsx&fileSize=3233&allowOverwrite=1&resume=0","offset":0}),{Date=[Fri, 11 May 2018 18:36:22 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Cache-Control=[s-maxage=10], Content-Length=[272], Keep-Alive=[timeout=5, max=99], Connection=[Keep-Alive], Content-Type=[application/json]}>
  357. 2018-05-11 21:36:22,773 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Sending fileUpload request to Exavault API: <POST https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e2a64dc6ab4a4d62ad40a3e35d14a648b981f8ab4&destinationPath=%2Fshare%2Fsummary_report_report_1526063781197.xlsx&fileSize=3233&allowOverwrite=1&resume=0,[B@1cc0a329,{Accept=[*/*], Content-Length=[3233], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  358. 2018-05-11 21:36:23,152 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Received fileUpload response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results=true),{Server=[nginx], Date=[Fri, 11 May 2018 18:36:23 GMT], Content-Type=[application/json], Content-Length=[41], X-Powered-By=[PHP/7.1.17], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Strict-Transport-Security=[max-age=31536000; includeSubDomains; preload;]}>
  359. 2018-05-11 21:36:23,152 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Sending createShare request to Exavault API: <POST https://api.exavault.com/v1/createShare,CreateShareRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  360. 2018-05-11 21:36:23,899 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Received createShare response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"id":707855,"name":"Cubenix :: b1b9c23d-d551-4064-8022-d40f816c99ea","hasPassword":false,"public":true,"accessMode":"download","accessDescription":"Download only","embed":false,"hash":"ghtf-687bldxt","ownerHash":"ghtf-687bldxt-4q2ps1ci","expiration":"2018-05-25 11:36:23","trackingStatus":"pending","expired":false,"resent":null,"owner":78413,"ownerUsername":"cubenix","type":"send","requireEmail":false,"fileDropCreateFolders":false,"paths":["/summary_report_report_1526063781197.xlsx"],"assets":[],"recipients":[{"id":763453,"shareId":707855,"type":"direct","hash":"cq8nkl8e","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:36:23"}],"recipientsWithOwner":[{"id":763453,"shareId":707855,"type":"direct","hash":"cq8nkl8e","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:36:23"},null],"messages":[],"inherited":null,"status":1,"hasNotification":false,"notification":null,"created":"2018-05-11 11:36:23","modified":null}),{Date=[Fri, 11 May 2018 18:36:23 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[1033], Keep-Alive=[timeout=5, max=98], Connection=[Keep-Alive], Content-Type=[application/json]}>
  361. 2018-05-11 21:37:33,722 [CubenixPool-2] INFO c.c.s.data.postgres.ReportRepository - ---> select provider_name as "provider_name", provider_mmis_no as "provider_mmis_no", manufacturer as "manufacturer", manufacturer_catalog_no as "manufacturer_catalog_no", catalog_item_description as "catalog_item_description", factor as "factor", ansi_uom as "ansi_uom", packaging_string as "packaging_string", last_cost_to_ea as "last_cost_to_ea", avg(benchmark_75p) as "benchmark_75p", avg(benchmark_90p) as "benchmark_90p", avg(benchmark_average) as "benchmark_average", avg(benchmark_high) as "benchmark_high", sum(quantity_to_ea) as "total_quantity", sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "opportunity", sum(benchmark_savings_90p) as "opportunity_90p", unspsc_code as "unspsc_code", unspsc_description as "unspsc_description", cur_contract_number as "cur_contract_number", cur_contract_description as "cur_contract_description", cur_ansi_uom as "cur_ansi_uom", cur_uom_factor as "cur_uom_factor" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PERIOPERATIVE SERVICES' and category_department_l1 = 'IMPLANTS, LARGE JOINT' and provider_name is not null and provider_mmis_no is not null and manufacturer is not null and manufacturer_catalog_no is not null and catalog_item_description is not null and factor is not null and ansi_uom is not null and packaging_string is not null and last_cost_to_ea is not null and unspsc_code is not null and unspsc_description is not null and cur_contract_number is not null and cur_contract_description is not null and cur_ansi_uom is not null and cur_uom_factor is not null and provider_id = 82031899) group by provider_name, provider_mmis_no, manufacturer, manufacturer_catalog_no, catalog_item_description, factor, ansi_uom, packaging_string, last_cost_to_ea, unspsc_code, unspsc_description, cur_contract_number, cur_contract_description, cur_ansi_uom, cur_uom_factor order by total_spend desc
  362. 2018-05-11 21:37:34,037 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Sending login request to Exavault API: <POST https://api.exavault.com/v1/authenticateUser,AuthenticationRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  363. 2018-05-11 21:37:34,854 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Received login response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"username":"cubenix","accessToken":"5af5e2eeab4418aabd709ecf303e3f7f662fe68d99b7c","mode":0,"clientIp":"172.16.2.234"}),{Date=[Fri, 11 May 2018 18:37:34 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[156], Keep-Alive=[timeout=5, max=100], Connection=[Keep-Alive], Content-Type=[application/json]}>
  364. 2018-05-11 21:37:34,862 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Sending getUploadUrl request to Exavault API: <GET https://api.exavault.com/v1/getUploadFileUrl?access_token=5af5e2eeab4418aabd709ecf303e3f7f662fe68d99b7c&fileSize=3233&destinationPath=%2Fshare%2Fsummary_report_report_1526063853714.xlsx&allowOverwrite=true&resume=false,{Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  365. 2018-05-11 21:37:35,171 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Received getUploadUrl response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"url":"https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e2eeab4418aabd709ecf303e3f7f662fe68d99b7c&destinationPath=%2Fshare%2Fsummary_report_report_1526063853714.xlsx&fileSize=3233&allowOverwrite=1&resume=0","offset":0}),{Date=[Fri, 11 May 2018 18:37:34 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Cache-Control=[s-maxage=10], Content-Length=[272], Keep-Alive=[timeout=5, max=99], Connection=[Keep-Alive], Content-Type=[application/json]}>
  366. 2018-05-11 21:37:35,178 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Sending fileUpload request to Exavault API: <POST https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e2eeab4418aabd709ecf303e3f7f662fe68d99b7c&destinationPath=%2Fshare%2Fsummary_report_report_1526063853714.xlsx&fileSize=3233&allowOverwrite=1&resume=0,[B@6a9466fe,{Accept=[*/*], Content-Length=[3233], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  367. 2018-05-11 21:37:35,539 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Received fileUpload response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results=true),{Server=[nginx], Date=[Fri, 11 May 2018 18:37:35 GMT], Content-Type=[application/json], Content-Length=[41], X-Powered-By=[PHP/7.1.17], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Strict-Transport-Security=[max-age=31536000; includeSubDomains; preload;]}>
  368. 2018-05-11 21:37:35,539 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Sending createShare request to Exavault API: <POST https://api.exavault.com/v1/createShare,CreateShareRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  369. 2018-05-11 21:37:36,306 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Received createShare response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"id":707859,"name":"Cubenix :: c7d0f2b3-eba0-4ace-b14d-3fa41cf5cfff","hasPassword":false,"public":true,"accessMode":"download","accessDescription":"Download only","embed":false,"hash":"ghtj-ej0r17ln","ownerHash":"ghtj-ej0r17ln-d21vmun","expiration":"2018-05-25 11:37:36","trackingStatus":"pending","expired":false,"resent":null,"owner":78413,"ownerUsername":"cubenix","type":"send","requireEmail":false,"fileDropCreateFolders":false,"paths":["/summary_report_report_1526063853714.xlsx"],"assets":[],"recipients":[{"id":763455,"shareId":707859,"type":"direct","hash":"920qflo6","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:37:36"}],"recipientsWithOwner":[{"id":763455,"shareId":707859,"type":"direct","hash":"920qflo6","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:37:36"},null],"messages":[],"inherited":null,"status":1,"hasNotification":false,"notification":null,"created":"2018-05-11 11:37:36","modified":null}),{Date=[Fri, 11 May 2018 18:37:35 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[1032], Keep-Alive=[timeout=5, max=98], Connection=[Keep-Alive], Content-Type=[application/json]}>
  370. 2018-05-11 21:38:11,215 [http-nio-8080-exec-4] WARN c.c.s.e.GlobalControllerExceptionHandler - Exception, message: java.io.IOException: Broken pipe
  371. 2018-05-11 21:38:11,217 [http-nio-8080-exec-4] WARN o.s.w.s.m.m.a.ExceptionHandlerExceptionResolver - Failed to invoke @ExceptionHandler method: public org.springframework.http.ResponseEntity com.cube.server.exception.GlobalControllerExceptionHandler.handleException(java.lang.Exception)
  372. org.apache.catalina.connector.ClientAbortException: java.io.IOException: Broken pipe
  373. at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:356)
  374. at org.apache.catalina.connector.OutputBuffer.flushByteBuffer(OutputBuffer.java:815)
  375. at org.apache.catalina.connector.OutputBuffer.append(OutputBuffer.java:720)
  376. at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:391)
  377. at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:369)
  378. at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:96)
  379. at sun.nio.cs.StreamEncoder.writeBytes(StreamEncoder.java:221)
  380. at sun.nio.cs.StreamEncoder.implFlushBuffer(StreamEncoder.java:291)
  381. at sun.nio.cs.StreamEncoder.implFlush(StreamEncoder.java:295)
  382. at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:141)
  383. at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:229)
  384. at org.springframework.util.StreamUtils.copy(StreamUtils.java:119)
  385. at org.springframework.http.converter.StringHttpMessageConverter.writeInternal(StringHttpMessageConverter.java:106)
  386. at org.springframework.http.converter.StringHttpMessageConverter.writeInternal(StringHttpMessageConverter.java:41)
  387. at org.springframework.http.converter.AbstractHttpMessageConverter.write(AbstractHttpMessageConverter.java:227)
  388. at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters(AbstractMessageConverterMethodProcessor.java:247)
  389. at org.springframework.web.servlet.mvc.method.annotation.HttpEntityMethodProcessor.handleReturnValue(HttpEntityMethodProcessor.java:203)
  390. at org.springframework.web.method.support.HandlerMethodReturnValueHandlerComposite.handleReturnValue(HandlerMethodReturnValueHandlerComposite.java:81)
  391. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:113)
  392. at org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver.doResolveHandlerMethodException(ExceptionHandlerExceptionResolver.java:380)
  393. at org.springframework.web.servlet.handler.AbstractHandlerMethodExceptionResolver.doResolveException(AbstractHandlerMethodExceptionResolver.java:59)
  394. at org.springframework.web.servlet.handler.AbstractHandlerExceptionResolver.resolveException(AbstractHandlerExceptionResolver.java:136)
  395. at org.springframework.web.servlet.handler.HandlerExceptionResolverComposite.resolveException(HandlerExceptionResolverComposite.java:76)
  396. at org.springframework.web.servlet.DispatcherServlet.processHandlerException(DispatcherServlet.java:1222)
  397. at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1034)
  398. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:984)
  399. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
  400. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
  401. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
  402. at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
  403. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
  404. at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  405. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  406. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  407. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  408. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  409. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  410. at org.springframework.boot.web.filter.ApplicationContextHeaderFilter.doFilterInternal(ApplicationContextHeaderFilter.java:55)
  411. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  412. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  413. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  414. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)
  415. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  416. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  417. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)
  418. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  419. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  420. at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:110)
  421. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  422. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  423. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  424. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
  425. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  426. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  427. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  428. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
  429. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  430. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  431. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  432. at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
  433. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  434. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
  435. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  436. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  437. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  438. at com.cube.server.security.JwtAuthenticationTokenFilter.doFilterInternal(JwtAuthenticationTokenFilter.java:45)
  439. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  440. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  441. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
  442. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  443. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
  444. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  445. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  446. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
  447. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  448. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  449. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  450. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  451. at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
  452. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  453. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  454. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
  455. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
  456. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347)
  457. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263)
  458. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  459. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  460. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
  461. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  462. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  463. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  464. at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:108)
  465. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  466. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  467. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  468. at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
  469. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  470. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  471. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  472. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
  473. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  474. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  475. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  476. at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:106)
  477. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  478. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  479. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  480. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
  481. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  482. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
  483. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  484. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
  485. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  486. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  487. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
  488. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  489. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
  490. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
  491. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  492. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  493. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  494. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  495. at java.lang.Thread.run(Thread.java:748)
  496. Caused by: java.io.IOException: Broken pipe
  497. at sun.nio.ch.FileDispatcherImpl.write0(Native Method)
  498. at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47)
  499. at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:93)
  500. at sun.nio.ch.IOUtil.write(IOUtil.java:65)
  501. at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:471)
  502. at org.apache.tomcat.util.net.NioChannel.write(NioChannel.java:134)
  503. at org.apache.tomcat.util.net.NioBlockingSelector.write(NioBlockingSelector.java:101)
  504. at org.apache.tomcat.util.net.NioSelectorPool.write(NioSelectorPool.java:157)
  505. at org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper.doWrite(NioEndpoint.java:1267)
  506. at org.apache.tomcat.util.net.SocketWrapperBase.doWrite(SocketWrapperBase.java:670)
  507. at org.apache.tomcat.util.net.SocketWrapperBase.writeBlocking(SocketWrapperBase.java:450)
  508. at org.apache.tomcat.util.net.SocketWrapperBase.write(SocketWrapperBase.java:388)
  509. at org.apache.coyote.http11.Http11OutputBuffer$SocketOutputBuffer.doWrite(Http11OutputBuffer.java:644)
  510. at org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:121)
  511. at org.apache.coyote.http11.Http11OutputBuffer.doWrite(Http11OutputBuffer.java:235)
  512. at org.apache.coyote.Response.doWrite(Response.java:541)
  513. at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:351)
  514. ... 122 common frames omitted
  515. 2018-05-11 21:38:24,293 [CubenixPool-1] INFO c.c.s.data.postgres.ReportRepository - ---> select provider_name as "provider_name", provider_mmis_no as "provider_mmis_no", manufacturer as "manufacturer", manufacturer_catalog_no as "manufacturer_catalog_no", catalog_item_description as "catalog_item_description", factor as "factor", ansi_uom as "ansi_uom", packaging_string as "packaging_string", last_cost_to_ea as "last_cost_to_ea", avg(benchmark_75p) as "benchmark_75p", avg(benchmark_90p) as "benchmark_90p", avg(benchmark_average) as "benchmark_average", avg(benchmark_high) as "benchmark_high", sum(quantity_to_ea) as "total_quantity", sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "opportunity", sum(benchmark_savings_90p) as "opportunity_90p", unspsc_code as "unspsc_code", unspsc_description as "unspsc_description", cur_contract_number as "cur_contract_number", cur_contract_description as "cur_contract_description", cur_ansi_uom as "cur_ansi_uom", cur_uom_factor as "cur_uom_factor" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PERIOPERATIVE SERVICES' and category_department_l1 = 'IMPLANTS, LARGE JOINT' and provider_name is not null and provider_mmis_no is not null and manufacturer is not null and manufacturer_catalog_no is not null and catalog_item_description is not null and factor is not null and ansi_uom is not null and packaging_string is not null and last_cost_to_ea is not null and unspsc_code is not null and unspsc_description is not null and cur_contract_number is not null and cur_contract_description is not null and cur_ansi_uom is not null and cur_uom_factor is not null and provider_id = 82031899) group by provider_name, provider_mmis_no, manufacturer, manufacturer_catalog_no, catalog_item_description, factor, ansi_uom, packaging_string, last_cost_to_ea, unspsc_code, unspsc_description, cur_contract_number, cur_contract_description, cur_ansi_uom, cur_uom_factor order by total_spend desc
  516. 2018-05-11 21:38:24,741 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Sending login request to Exavault API: <POST https://api.exavault.com/v1/authenticateUser,AuthenticationRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  517. 2018-05-11 21:38:25,469 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Received login response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"username":"cubenix","accessToken":"5af5e32154e1f1bfa29ab740130e59efee7fe63ec9a0e","mode":0,"clientIp":"172.16.2.234"}),{Date=[Fri, 11 May 2018 18:38:25 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[156], Keep-Alive=[timeout=5, max=100], Connection=[Keep-Alive], Content-Type=[application/json]}>
  518. 2018-05-11 21:38:25,470 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Sending getUploadUrl request to Exavault API: <GET https://api.exavault.com/v1/getUploadFileUrl?access_token=5af5e32154e1f1bfa29ab740130e59efee7fe63ec9a0e&fileSize=3233&destinationPath=%2Fshare%2Fsummary_report_report_1526063904290.xlsx&allowOverwrite=true&resume=false,{Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  519. 2018-05-11 21:38:25,754 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Received getUploadUrl response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"url":"https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e32154e1f1bfa29ab740130e59efee7fe63ec9a0e&destinationPath=%2Fshare%2Fsummary_report_report_1526063904290.xlsx&fileSize=3233&allowOverwrite=1&resume=0","offset":0}),{Date=[Fri, 11 May 2018 18:38:25 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Cache-Control=[s-maxage=10], Content-Length=[272], Keep-Alive=[timeout=5, max=99], Connection=[Keep-Alive], Content-Type=[application/json]}>
  520. 2018-05-11 21:38:25,755 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Sending fileUpload request to Exavault API: <POST https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e32154e1f1bfa29ab740130e59efee7fe63ec9a0e&destinationPath=%2Fshare%2Fsummary_report_report_1526063904290.xlsx&fileSize=3233&allowOverwrite=1&resume=0,[B@52645818,{Accept=[*/*], Content-Length=[3233], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  521. 2018-05-11 21:38:26,536 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Received fileUpload response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results=true),{Server=[nginx], Date=[Fri, 11 May 2018 18:38:26 GMT], Content-Type=[application/json], Content-Length=[41], X-Powered-By=[PHP/7.1.17], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Strict-Transport-Security=[max-age=31536000; includeSubDomains; preload;]}>
  522. 2018-05-11 21:38:26,536 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Sending createShare request to Exavault API: <POST https://api.exavault.com/v1/createShare,CreateShareRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  523. 2018-05-11 21:38:27,291 [CubenixPool-1] INFO c.c.r.exavault.ExavaultShareClient - Received createShare response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"id":707861,"name":"Cubenix :: 30261b5b-6256-4b59-994f-a37978d0e701","hasPassword":false,"public":true,"accessMode":"download","accessDescription":"Download only","embed":false,"hash":"ghtl-eprs8bed","ownerHash":"ghtl-eprs8bed-1tup7w32","expiration":"2018-05-25 11:38:27","trackingStatus":"pending","expired":false,"resent":null,"owner":78413,"ownerUsername":"cubenix","type":"send","requireEmail":false,"fileDropCreateFolders":false,"paths":["/summary_report_report_1526063904290.xlsx"],"assets":[],"recipients":[{"id":763457,"shareId":707861,"type":"direct","hash":"1vdae0dc","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:38:27"}],"recipientsWithOwner":[{"id":763457,"shareId":707861,"type":"direct","hash":"1vdae0dc","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:38:27"},null],"messages":[],"inherited":null,"status":1,"hasNotification":false,"notification":null,"created":"2018-05-11 11:38:27","modified":null}),{Date=[Fri, 11 May 2018 18:38:26 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[1033], Keep-Alive=[timeout=5, max=98], Connection=[Keep-Alive], Content-Type=[application/json]}>
  524. 2018-05-11 21:39:05,808 [CubenixPool-4] INFO c.c.s.data.postgres.ReportRepository - ---> select provider_name as "provider_name", provider_mmis_no as "provider_mmis_no", manufacturer as "manufacturer", manufacturer_catalog_no as "manufacturer_catalog_no", catalog_item_description as "catalog_item_description", factor as "factor", ansi_uom as "ansi_uom", packaging_string as "packaging_string", last_cost_to_ea as "last_cost_to_ea", avg(benchmark_75p) as "benchmark_75p", avg(benchmark_90p) as "benchmark_90p", avg(benchmark_average) as "benchmark_average", avg(benchmark_high) as "benchmark_high", sum(quantity_to_ea) as "total_quantity", sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "opportunity", sum(benchmark_savings_90p) as "opportunity_90p", unspsc_code as "unspsc_code", unspsc_description as "unspsc_description", cur_contract_number as "cur_contract_number", cur_contract_description as "cur_contract_description", cur_ansi_uom as "cur_ansi_uom", cur_uom_factor as "cur_uom_factor" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PERIOPERATIVE SERVICES' and category_department_l1 = 'IMPLANTS, LARGE JOINT' and provider_name is not null and provider_mmis_no is not null and manufacturer is not null and manufacturer_catalog_no is not null and catalog_item_description is not null and factor is not null and ansi_uom is not null and packaging_string is not null and last_cost_to_ea is not null and unspsc_code is not null and unspsc_description is not null and cur_contract_number is not null and cur_contract_description is not null and cur_ansi_uom is not null and cur_uom_factor is not null and provider_id = 82031899) group by provider_name, provider_mmis_no, manufacturer, manufacturer_catalog_no, catalog_item_description, factor, ansi_uom, packaging_string, last_cost_to_ea, unspsc_code, unspsc_description, cur_contract_number, cur_contract_description, cur_ansi_uom, cur_uom_factor order by total_spend desc
  525. 2018-05-11 21:39:06,317 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Sending login request to Exavault API: <POST https://api.exavault.com/v1/authenticateUser,AuthenticationRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  526. 2018-05-11 21:39:07,136 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Received login response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"username":"cubenix","accessToken":"5af5e34af3717a97f2525666caba95b0d20e6fc5154ac","mode":0,"clientIp":"172.16.2.234"}),{Date=[Fri, 11 May 2018 18:39:06 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[156], Keep-Alive=[timeout=5, max=100], Connection=[Keep-Alive], Content-Type=[application/json]}>
  527. 2018-05-11 21:39:07,138 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Sending getUploadUrl request to Exavault API: <GET https://api.exavault.com/v1/getUploadFileUrl?access_token=5af5e34af3717a97f2525666caba95b0d20e6fc5154ac&fileSize=3233&destinationPath=%2Fshare%2Fsummary_report_report_1526063945798.xlsx&allowOverwrite=true&resume=false,{Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  528. 2018-05-11 21:39:07,444 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Received getUploadUrl response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"url":"https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e34af3717a97f2525666caba95b0d20e6fc5154ac&destinationPath=%2Fshare%2Fsummary_report_report_1526063945798.xlsx&fileSize=3233&allowOverwrite=1&resume=0","offset":0}),{Date=[Fri, 11 May 2018 18:39:07 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Cache-Control=[s-maxage=10], Content-Length=[272], Keep-Alive=[timeout=5, max=99], Connection=[Keep-Alive], Content-Type=[application/json]}>
  529. 2018-05-11 21:39:07,445 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Sending fileUpload request to Exavault API: <POST https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e34af3717a97f2525666caba95b0d20e6fc5154ac&destinationPath=%2Fshare%2Fsummary_report_report_1526063945798.xlsx&fileSize=3233&allowOverwrite=1&resume=0,[B@23f5720,{Accept=[*/*], Content-Length=[3233], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  530. 2018-05-11 21:39:08,046 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Received fileUpload response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results=true),{Server=[nginx], Date=[Fri, 11 May 2018 18:39:07 GMT], Content-Type=[application/json], Content-Length=[41], X-Powered-By=[PHP/7.1.17], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Strict-Transport-Security=[max-age=31536000; includeSubDomains; preload;]}>
  531. 2018-05-11 21:39:08,047 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Sending createShare request to Exavault API: <POST https://api.exavault.com/v1/createShare,CreateShareRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  532. 2018-05-11 21:39:08,764 [CubenixPool-4] INFO c.c.r.exavault.ExavaultShareClient - Received createShare response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"id":707863,"name":"Cubenix :: ee8e860a-2c43-4fa8-ba13-4e5d5b6c26d4","hasPassword":false,"public":true,"accessMode":"download","accessDescription":"Download only","embed":false,"hash":"ghtn-cp39ghqh","ownerHash":"ghtn-cp39ghqh-42xv4rfu","expiration":"2018-05-25 11:39:08","trackingStatus":"pending","expired":false,"resent":null,"owner":78413,"ownerUsername":"cubenix","type":"send","requireEmail":false,"fileDropCreateFolders":false,"paths":["/summary_report_report_1526063945798.xlsx"],"assets":[],"recipients":[{"id":763459,"shareId":707863,"type":"direct","hash":"gs2k5r74","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:39:08"}],"recipientsWithOwner":[{"id":763459,"shareId":707863,"type":"direct","hash":"gs2k5r74","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:39:08"},null],"messages":[],"inherited":null,"status":1,"hasNotification":false,"notification":null,"created":"2018-05-11 11:39:08","modified":null}),{Date=[Fri, 11 May 2018 18:39:08 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[1033], Keep-Alive=[timeout=5, max=98], Connection=[Keep-Alive], Content-Type=[application/json]}>
  533. 2018-05-11 21:39:15,992 [cube-request-dispatcher-77] INFO c.c.s.data.postgres.ReportRepository - ---> select manufacturer as "manufacturer", manufacturer_catalog_no as "department", catalog_item_description as "catalog_item_description", factor as "factor", ansi_uom as "ansi_uom", packaging_string as "packaging_string", last_cost_to_ea as "last_cost_to_ea", benchmark_75p as "benchmark_75p", benchmark_90p as "benchmark_90p", sum(quantity_to_ea) as "total_quantity", sum(total_spend) as "total_spend", sum(benchmark_savings_low) as "opportunity", sum(benchmark_savings_90p) as "opportunity_90p" from raw_data where (purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and category_department = 'PERIOPERATIVE SERVICES' and category_department_l1 = 'IMPLANTS, LARGE JOINT' and manufacturer is not null and manufacturer_catalog_no is not null and catalog_item_description is not null and factor is not null and ansi_uom is not null and packaging_string is not null and last_cost_to_ea is not null and benchmark_75p is not null and benchmark_90p is not null and provider_id = 82031899) group by manufacturer, manufacturer_catalog_no, catalog_item_description, factor, ansi_uom, packaging_string, last_cost_to_ea, benchmark_75p, benchmark_90p order by opportunity desc limit 15
  534. 2018-05-11 21:39:16,191 [cube-request-dispatcher-86] INFO c.c.s.data.postgres.ReportRepository - ---> select manufacturer as "manufacturer", manufacturer_catalog_no as "manufacturer_catalog_no", catalog_item_description as "catalog_item_description", factor as "factor", ansi_uom as "ansi_uom", packaging_string as "packaging_string", last_cost_to_ea as "last_cost_to_ea", benchmark_75p as "benchmark_75p", benchmark_90p as "benchmark_90p", sum(quantity_to_ea) as "total_quantity", sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "opportunity", sum(benchmark_savings_90p) as "opportunity_90p" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p <= 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PERIOPERATIVE SERVICES' and category_department_l1 = 'IMPLANTS, LARGE JOINT' and manufacturer is not null and manufacturer_catalog_no is not null and catalog_item_description is not null and factor is not null and ansi_uom is not null and packaging_string is not null and last_cost_to_ea is not null and benchmark_75p is not null and benchmark_90p is not null and provider_id = 82031899) group by manufacturer, manufacturer_catalog_no, catalog_item_description, factor, ansi_uom, packaging_string, last_cost_to_ea, benchmark_75p, benchmark_90p order by opportunity desc limit 15
  535. 2018-05-11 21:39:16,552 [cube-request-dispatcher-77] INFO c.c.s.data.postgres.ReportRepository - ---> select count(*) from (select manufacturer as "manufacturer", manufacturer_catalog_no as "manufacturer_catalog_no", catalog_item_description as "catalog_item_description", factor as "factor", ansi_uom as "ansi_uom", packaging_string as "packaging_string", last_cost_to_ea as "last_cost_to_ea", benchmark_75p as "benchmark_75p", benchmark_90p as "benchmark_90p", sum(quantity_to_ea) as "total_quantity", sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "opportunity", sum(benchmark_savings_90p) as "opportunity_90p" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p <= 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PERIOPERATIVE SERVICES' and category_department_l1 = 'IMPLANTS, LARGE JOINT' and manufacturer is not null and manufacturer_catalog_no is not null and catalog_item_description is not null and factor is not null and ansi_uom is not null and packaging_string is not null and last_cost_to_ea is not null and benchmark_75p is not null and benchmark_90p is not null and provider_id = 82031899) group by manufacturer, manufacturer_catalog_no, catalog_item_description, factor, ansi_uom, packaging_string, last_cost_to_ea, benchmark_75p, benchmark_90p order by opportunity desc limit 2147483647) as "alias_54787580"
  536. 2018-05-11 21:39:24,969 [http-nio-8080-exec-9] INFO c.c.s.data.postgres.ReportRepository - ---> select provider_name as "provider_name", provider_mmis_no as "provider_mmis_no", manufacturer as "manufacturer", manufacturer_catalog_no as "manufacturer_catalog_no", catalog_item_description as "catalog_item_description", factor as "factor", ansi_uom as "ansi_uom", packaging_string as "packaging_string", last_cost_to_ea as "last_cost_to_ea", avg(benchmark_75p) as "benchmark_75p", avg(benchmark_90p) as "benchmark_90p", avg(benchmark_average) as "benchmark_average", avg(benchmark_high) as "benchmark_high", sum(quantity_to_ea) as "total_quantity", sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "opportunity", sum(benchmark_savings_90p) as "opportunity_90p", unspsc_code as "unspsc_code", unspsc_description as "unspsc_description", cur_contract_number as "cur_contract_number", cur_contract_description as "cur_contract_description", cur_ansi_uom as "cur_ansi_uom", cur_uom_factor as "cur_uom_factor" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PERIOPERATIVE SERVICES' and category_department_l1 = 'IMPLANTS, LARGE JOINT' and provider_name is not null and provider_mmis_no is not null and manufacturer is not null and manufacturer_catalog_no is not null and catalog_item_description is not null and factor is not null and ansi_uom is not null and packaging_string is not null and last_cost_to_ea is not null and unspsc_code is not null and unspsc_description is not null and cur_contract_number is not null and cur_contract_description is not null and cur_ansi_uom is not null and cur_uom_factor is not null and provider_id = 82031899) group by provider_name, provider_mmis_no, manufacturer, manufacturer_catalog_no, catalog_item_description, factor, ansi_uom, packaging_string, last_cost_to_ea, unspsc_code, unspsc_description, cur_contract_number, cur_contract_description, cur_ansi_uom, cur_uom_factor order by total_spend desc
  537. 2018-05-11 21:52:31,864 [cube-request-dispatcher-86] INFO c.c.s.data.postgres.ReportRepository - ---> select sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "total_opportunity" from raw_data where (purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and provider_id = 82031899)
  538. 2018-05-11 21:52:31,884 [cube-request-dispatcher-89] INFO c.c.s.data.postgres.ReportRepository - ---> select category_department as "category_department", sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "opportunity", ((100.0 * sum(benchmark_savings_75p)) / sum(total_spend)) as "pct" from raw_data where (purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and category_department is not null and provider_id = 82031899) group by category_department order by opportunity desc limit 15
  539. 2018-05-11 21:52:33,231 [cube-request-dispatcher-86] INFO c.cube.server.flow.step.ExecuteStep - Init ExecuteStep with arguments [execute, base]
  540. 2018-05-11 21:52:33,231 [cube-request-dispatcher-86] INFO c.c.s.flow.step.ExecuteForEachStep - Init ExecuteStep with arguments [executeForEach, $base.department, manufactures_by_category]
  541. 2018-05-11 21:52:33,232 [cube-request-dispatcher-86] INFO c.c.server.flow.step.GroupByKeyStep - Init ExecuteStep with arguments [groupByKey, department]
  542. 2018-05-11 21:52:33,235 [cube-request-dispatcher-86] INFO c.c.server.flow.step.SqlRequestStep - ---> select category_department as "department", sum(total_spend) as "total_spend", avg(cost_percentile_min) filter (where cost_percentile_min <> 0) as "cost_percentile_min", sum(benchmark_savings_75p) as "opportunity", ((100.0 * sum(benchmark_savings_75p)) / sum(total_spend)) as "pct" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department is not null and provider_id = 82031899) group by category_department order by opportunity desc limit 15
  543. 2018-05-11 21:52:33,260 [cube-request-dispatcher-89] INFO c.c.s.flow.step.TotalCountForStep - Init ExecuteStep with arguments [totalCountFor, base]
  544. 2018-05-11 21:52:33,262 [cube-request-dispatcher-89] INFO c.c.s.data.postgres.ReportRepository - ---> select count(*) from (select category_department as "department", sum(total_spend) as "total_spend", avg(cost_percentile_min) filter (where cost_percentile_min <> 0) as "cost_percentile_min", sum(benchmark_savings_75p) as "opportunity", ((100.0 * sum(benchmark_savings_75p)) / sum(total_spend)) as "pct" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department is not null and provider_id = 82031899) group by category_department order by opportunity desc limit 2147483647) as "alias_19584947"
  545. 2018-05-11 21:52:34,412 [cube-request-dispatcher-86] INFO c.c.s.flow.step.ExecuteForEachStep - ---> ForEachStep PERIOPERATIVE SERVICES
  546. 2018-05-11 21:52:34,413 [cube-request-dispatcher-86] INFO c.c.s.flow.step.ExecuteForEachStep - ---> ForEachStep UNCATEGORIZED
  547. 2018-05-11 21:52:34,413 [cube-request-dispatcher-86] INFO c.c.s.flow.step.ExecuteForEachStep - ---> ForEachStep CARDIOVASCULAR
  548. 2018-05-11 21:52:34,413 [cube-request-dispatcher-86] INFO c.c.s.flow.step.ExecuteForEachStep - ---> ForEachStep LABORATORY
  549. 2018-05-11 21:52:34,413 [cube-request-dispatcher-86] INFO c.c.s.flow.step.ExecuteForEachStep - ---> ForEachStep NURSING
  550. 2018-05-11 21:52:34,414 [CubenixPool-3] INFO c.c.server.flow.step.SqlRequestStep - ---> select category_department as "department", manufacturer as "manufacturer", sum(total_spend) as "total_spend" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PERIOPERATIVE SERVICES' and manufacturer is not null and category_department is not null and provider_id = 82031899) group by manufacturer, category_department order by total_spend desc limit 2
  551. 2018-05-11 21:52:34,414 [cube-request-dispatcher-86] INFO c.c.s.flow.step.ExecuteForEachStep - ---> ForEachStep PURCHASED SERVICES
  552. 2018-05-11 21:52:34,415 [CubenixPool-2] INFO c.c.server.flow.step.SqlRequestStep - ---> select category_department as "department", manufacturer as "manufacturer", sum(total_spend) as "total_spend" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'UNCATEGORIZED' and manufacturer is not null and category_department is not null and provider_id = 82031899) group by manufacturer, category_department order by total_spend desc limit 2
  553. 2018-05-11 21:52:34,415 [CubenixPool-1] INFO c.c.server.flow.step.SqlRequestStep - ---> select category_department as "department", manufacturer as "manufacturer", sum(total_spend) as "total_spend" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'CARDIOVASCULAR' and manufacturer is not null and category_department is not null and provider_id = 82031899) group by manufacturer, category_department order by total_spend desc limit 2
  554. 2018-05-11 21:52:34,416 [CubenixPool-4] INFO c.c.server.flow.step.SqlRequestStep - ---> select category_department as "department", manufacturer as "manufacturer", sum(total_spend) as "total_spend" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'LABORATORY' and manufacturer is not null and category_department is not null and provider_id = 82031899) group by manufacturer, category_department order by total_spend desc limit 2
  555. 2018-05-11 21:52:34,417 [cube-request-dispatcher-86] INFO c.c.s.flow.step.ExecuteForEachStep - ---> ForEachStep RADIOLOGY
  556. 2018-05-11 21:52:34,420 [cube-request-dispatcher-86] INFO c.c.s.flow.step.ExecuteForEachStep - ---> ForEachStep PHARMACY
  557. 2018-05-11 21:52:34,420 [cube-request-dispatcher-86] INFO c.c.s.flow.step.ExecuteForEachStep - ---> ForEachStep MATERIEL MANAGEMENT
  558. 2018-05-11 21:52:34,420 [cube-request-dispatcher-86] INFO c.c.s.flow.step.ExecuteForEachStep - ---> ForEachStep RESPIRATORY
  559. 2018-05-11 21:52:34,420 [cube-request-dispatcher-86] INFO c.c.s.flow.step.ExecuteForEachStep - ---> ForEachStep REHAB
  560. 2018-05-11 21:52:34,420 [cube-request-dispatcher-86] INFO c.c.s.flow.step.ExecuteForEachStep - ---> ForEachStep VASCULAR PROCEDURES
  561. 2018-05-11 21:52:34,422 [cube-request-dispatcher-86] INFO c.c.s.flow.step.ExecuteForEachStep - ---> ForEachStep ENGINEERING
  562. 2018-05-11 21:52:34,423 [cube-request-dispatcher-86] INFO c.c.s.flow.step.ExecuteForEachStep - ---> ForEachStep HOUSEKEEPING
  563. 2018-05-11 21:52:34,423 [cube-request-dispatcher-86] INFO c.c.s.flow.step.ExecuteForEachStep - ---> ForEachStep FOOD SERVICES
  564. 2018-05-11 21:52:34,785 [CubenixPool-2] INFO c.c.server.flow.step.SqlRequestStep - ---> select category_department as "department", manufacturer as "manufacturer", sum(total_spend) as "total_spend" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'NURSING' and manufacturer is not null and category_department is not null and provider_id = 82031899) group by manufacturer, category_department order by total_spend desc limit 2
  565. 2018-05-11 21:52:34,798 [CubenixPool-4] INFO c.c.server.flow.step.SqlRequestStep - ---> select category_department as "department", manufacturer as "manufacturer", sum(total_spend) as "total_spend" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PURCHASED SERVICES' and manufacturer is not null and category_department is not null and provider_id = 82031899) group by manufacturer, category_department order by total_spend desc limit 2
  566. 2018-05-11 21:52:34,810 [CubenixPool-1] INFO c.c.server.flow.step.SqlRequestStep - ---> select category_department as "department", manufacturer as "manufacturer", sum(total_spend) as "total_spend" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'RADIOLOGY' and manufacturer is not null and category_department is not null and provider_id = 82031899) group by manufacturer, category_department order by total_spend desc limit 2
  567. 2018-05-11 21:52:34,960 [CubenixPool-4] INFO c.c.server.flow.step.SqlRequestStep - ---> select category_department as "department", manufacturer as "manufacturer", sum(total_spend) as "total_spend" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PHARMACY' and manufacturer is not null and category_department is not null and provider_id = 82031899) group by manufacturer, category_department order by total_spend desc limit 2
  568. 2018-05-11 21:52:34,976 [CubenixPool-1] INFO c.c.server.flow.step.SqlRequestStep - ---> select category_department as "department", manufacturer as "manufacturer", sum(total_spend) as "total_spend" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'MATERIEL MANAGEMENT' and manufacturer is not null and category_department is not null and provider_id = 82031899) group by manufacturer, category_department order by total_spend desc limit 2
  569. 2018-05-11 21:52:34,999 [CubenixPool-3] INFO c.c.server.flow.step.SqlRequestStep - ---> select category_department as "department", manufacturer as "manufacturer", sum(total_spend) as "total_spend" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'RESPIRATORY' and manufacturer is not null and category_department is not null and provider_id = 82031899) group by manufacturer, category_department order by total_spend desc limit 2
  570. 2018-05-11 21:52:35,132 [CubenixPool-4] INFO c.c.server.flow.step.SqlRequestStep - ---> select category_department as "department", manufacturer as "manufacturer", sum(total_spend) as "total_spend" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'REHAB' and manufacturer is not null and category_department is not null and provider_id = 82031899) group by manufacturer, category_department order by total_spend desc limit 2
  571. 2018-05-11 21:52:35,170 [CubenixPool-1] INFO c.c.server.flow.step.SqlRequestStep - ---> select category_department as "department", manufacturer as "manufacturer", sum(total_spend) as "total_spend" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'VASCULAR PROCEDURES' and manufacturer is not null and category_department is not null and provider_id = 82031899) group by manufacturer, category_department order by total_spend desc limit 2
  572. 2018-05-11 21:52:35,227 [CubenixPool-3] INFO c.c.server.flow.step.SqlRequestStep - ---> select category_department as "department", manufacturer as "manufacturer", sum(total_spend) as "total_spend" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'ENGINEERING' and manufacturer is not null and category_department is not null and provider_id = 82031899) group by manufacturer, category_department order by total_spend desc limit 2
  573. 2018-05-11 21:52:35,308 [CubenixPool-4] INFO c.c.server.flow.step.SqlRequestStep - ---> select category_department as "department", manufacturer as "manufacturer", sum(total_spend) as "total_spend" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'HOUSEKEEPING' and manufacturer is not null and category_department is not null and provider_id = 82031899) group by manufacturer, category_department order by total_spend desc limit 2
  574. 2018-05-11 21:52:35,328 [CubenixPool-1] INFO c.c.server.flow.step.SqlRequestStep - ---> select category_department as "department", manufacturer as "manufacturer", sum(total_spend) as "total_spend" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'FOOD SERVICES' and manufacturer is not null and category_department is not null and provider_id = 82031899) group by manufacturer, category_department order by total_spend desc limit 2
  575. 2018-05-11 21:53:08,006 [CubenixPool-3] INFO c.c.s.data.postgres.ReportRepository - ---> select provider_name as "provider_name", provider_mmis_no as "provider_mmis_no", manufacturer as "manufacturer", manufacturer_catalog_no as "manufacturer_catalog_no", catalog_item_description as "catalog_item_description", factor as "factor", ansi_uom as "ansi_uom", packaging_string as "packaging_string", last_cost_to_ea as "last_cost_to_ea", avg(benchmark_75p) as "benchmark_75p", avg(benchmark_90p) as "benchmark_90p", avg(benchmark_average) as "benchmark_average", avg(benchmark_high) as "benchmark_high", sum(quantity_to_ea) as "total_quantity", sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "opportunity", sum(benchmark_savings_90p) as "opportunity_90p", unspsc_code as "unspsc_code", unspsc_description as "unspsc_description", cur_contract_number as "cur_contract_number", cur_contract_description as "cur_contract_description", cur_ansi_uom as "cur_ansi_uom", cur_uom_factor as "cur_uom_factor" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PERIOPERATIVE SERVICES' and provider_name is not null and provider_mmis_no is not null and manufacturer is not null and manufacturer_catalog_no is not null and catalog_item_description is not null and factor is not null and ansi_uom is not null and packaging_string is not null and last_cost_to_ea is not null and unspsc_code is not null and unspsc_description is not null and cur_contract_number is not null and cur_contract_description is not null and cur_ansi_uom is not null and cur_uom_factor is not null and provider_id = 82031899) group by provider_name, provider_mmis_no, manufacturer, manufacturer_catalog_no, catalog_item_description, factor, ansi_uom, packaging_string, last_cost_to_ea, unspsc_code, unspsc_description, cur_contract_number, cur_contract_description, cur_ansi_uom, cur_uom_factor order by total_spend desc
  576. 2018-05-11 21:53:08,528 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Sending login request to Exavault API: <POST https://api.exavault.com/v1/authenticateUser,AuthenticationRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  577. 2018-05-11 21:53:09,555 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Received login response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"username":"cubenix","accessToken":"5af5e69569b00d3e262de8412f68f963c574e1d219227","mode":0,"clientIp":"172.16.2.234"}),{Date=[Fri, 11 May 2018 18:53:09 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[156], Keep-Alive=[timeout=5, max=100], Connection=[Keep-Alive], Content-Type=[application/json]}>
  578. 2018-05-11 21:53:09,556 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Sending getUploadUrl request to Exavault API: <GET https://api.exavault.com/v1/getUploadFileUrl?access_token=5af5e69569b00d3e262de8412f68f963c574e1d219227&fileSize=3233&destinationPath=%2Fshare%2Fsummary_report_report_1526064787989.xlsx&allowOverwrite=true&resume=false,{Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  579. 2018-05-11 21:53:09,842 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Received getUploadUrl response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"url":"https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e69569b00d3e262de8412f68f963c574e1d219227&destinationPath=%2Fshare%2Fsummary_report_report_1526064787989.xlsx&fileSize=3233&allowOverwrite=1&resume=0","offset":0}),{Date=[Fri, 11 May 2018 18:53:09 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Cache-Control=[s-maxage=10], Content-Length=[272], Keep-Alive=[timeout=5, max=99], Connection=[Keep-Alive], Content-Type=[application/json]}>
  580. 2018-05-11 21:53:09,842 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Sending fileUpload request to Exavault API: <POST https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e69569b00d3e262de8412f68f963c574e1d219227&destinationPath=%2Fshare%2Fsummary_report_report_1526064787989.xlsx&fileSize=3233&allowOverwrite=1&resume=0,[B@42783cbf,{Accept=[*/*], Content-Length=[3233], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  581. 2018-05-11 21:53:10,214 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Received fileUpload response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results=true),{Server=[nginx], Date=[Fri, 11 May 2018 18:53:10 GMT], Content-Type=[application/json], Content-Length=[41], X-Powered-By=[PHP/7.1.17], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Strict-Transport-Security=[max-age=31536000; includeSubDomains; preload;]}>
  582. 2018-05-11 21:53:10,215 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Sending createShare request to Exavault API: <POST https://api.exavault.com/v1/createShare,CreateShareRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  583. 2018-05-11 21:53:10,916 [CubenixPool-3] INFO c.c.r.exavault.ExavaultShareClient - Received createShare response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"id":707875,"name":"Cubenix :: e0684250-f8b5-4f30-975d-8af0b3f677e8","hasPassword":false,"public":true,"accessMode":"download","accessDescription":"Download only","embed":false,"hash":"ghu0-4blyld3d","ownerHash":"ghu0-4blyld3d-1rqcpnfn","expiration":"2018-05-25 11:53:10","trackingStatus":"pending","expired":false,"resent":null,"owner":78413,"ownerUsername":"cubenix","type":"send","requireEmail":false,"fileDropCreateFolders":false,"paths":["/summary_report_report_1526064787989.xlsx"],"assets":[],"recipients":[{"id":763461,"shareId":707875,"type":"direct","hash":"acth7uyf","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:53:10"}],"recipientsWithOwner":[{"id":763461,"shareId":707875,"type":"direct","hash":"acth7uyf","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:53:10"},null],"messages":[],"inherited":null,"status":1,"hasNotification":false,"notification":null,"created":"2018-05-11 11:53:10","modified":null}),{Date=[Fri, 11 May 2018 18:53:10 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[1033], Keep-Alive=[timeout=5, max=98], Connection=[Keep-Alive], Content-Type=[application/json]}>
  584. 2018-05-11 21:54:45,559 [CubenixPool-2] INFO c.c.s.data.postgres.ReportRepository - ---> select provider_name as "provider_name", provider_mmis_no as "provider_mmis_no", manufacturer as "manufacturer", manufacturer_catalog_no as "manufacturer_catalog_no", catalog_item_description as "catalog_item_description", factor as "factor", ansi_uom as "ansi_uom", packaging_string as "packaging_string", last_cost_to_ea as "last_cost_to_ea", avg(benchmark_75p) as "benchmark_75p", avg(benchmark_90p) as "benchmark_90p", avg(benchmark_average) as "benchmark_average", avg(benchmark_high) as "benchmark_high", sum(quantity_to_ea) as "total_quantity", sum(total_spend) as "total_spend", sum(benchmark_savings_75p) as "opportunity", sum(benchmark_savings_90p) as "opportunity_90p", unspsc_code as "unspsc_code", unspsc_description as "unspsc_description", cur_contract_number as "cur_contract_number", cur_contract_description as "cur_contract_description", cur_ansi_uom as "cur_ansi_uom", cur_uom_factor as "cur_uom_factor" from raw_data where (catalog_id <> '-1' and benchmark_ratio_75p > 0.5 and benchmark_ratio_75p < 2 and purchase_date >= date '2016-05-11' and purchase_date < date '2018-05-11' and category_department = 'PERIOPERATIVE SERVICES' and category_department = 'PERIOPERATIVE SERVICES' and provider_name is not null and provider_mmis_no is not null and manufacturer is not null and manufacturer_catalog_no is not null and catalog_item_description is not null and factor is not null and ansi_uom is not null and packaging_string is not null and last_cost_to_ea is not null and unspsc_code is not null and unspsc_description is not null and cur_contract_number is not null and cur_contract_description is not null and cur_ansi_uom is not null and cur_uom_factor is not null and provider_id = 82031899) group by provider_name, provider_mmis_no, manufacturer, manufacturer_catalog_no, catalog_item_description, factor, ansi_uom, packaging_string, last_cost_to_ea, unspsc_code, unspsc_description, cur_contract_number, cur_contract_description, cur_ansi_uom, cur_uom_factor order by total_spend desc
  585. 2018-05-11 21:54:45,936 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Sending login request to Exavault API: <POST https://api.exavault.com/v1/authenticateUser,AuthenticationRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  586. 2018-05-11 21:54:46,648 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Received login response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"username":"cubenix","accessToken":"5af5e6f68076b9ff3157fb4e0b6dab89442e91076af61","mode":0,"clientIp":"172.16.2.234"}),{Date=[Fri, 11 May 2018 18:54:46 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[156], Keep-Alive=[timeout=5, max=100], Connection=[Keep-Alive], Content-Type=[application/json]}>
  587. 2018-05-11 21:54:46,652 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Sending getUploadUrl request to Exavault API: <GET https://api.exavault.com/v1/getUploadFileUrl?access_token=5af5e6f68076b9ff3157fb4e0b6dab89442e91076af61&fileSize=3234&destinationPath=%2Fshare%2Fsummary_report_report_1526064885551.xlsx&allowOverwrite=true&resume=false,{Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  588. 2018-05-11 21:54:46,927 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Received getUploadUrl response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"url":"https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e6f68076b9ff3157fb4e0b6dab89442e91076af61&destinationPath=%2Fshare%2Fsummary_report_report_1526064885551.xlsx&fileSize=3234&allowOverwrite=1&resume=0","offset":0}),{Date=[Fri, 11 May 2018 18:54:46 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Cache-Control=[s-maxage=10], Content-Length=[272], Keep-Alive=[timeout=5, max=99], Connection=[Keep-Alive], Content-Type=[application/json]}>
  589. 2018-05-11 21:54:46,928 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Sending fileUpload request to Exavault API: <POST https://pod-sjc1-api.exavault.com/v1/upload?access_token=5af5e6f68076b9ff3157fb4e0b6dab89442e91076af61&destinationPath=%2Fshare%2Fsummary_report_report_1526064885551.xlsx&fileSize=3234&allowOverwrite=1&resume=0,[B@4e04a8e3,{Accept=[*/*], Content-Length=[3234], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  590. 2018-05-11 21:54:47,267 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Received fileUpload response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results=true),{Server=[nginx], Date=[Fri, 11 May 2018 18:54:47 GMT], Content-Type=[application/json], Content-Length=[41], X-Powered-By=[PHP/7.1.17], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Strict-Transport-Security=[max-age=31536000; includeSubDomains; preload;]}>
  591. 2018-05-11 21:54:47,267 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Sending createShare request to Exavault API: <POST https://api.exavault.com/v1/createShare,CreateShareRequest(),{Content-Type=[application/x-www-form-urlencoded], Accept=[application/json], api_key=[cubenix-U12hToLu42Yh4F7H04K3M]}>
  592. 2018-05-11 21:54:47,964 [CubenixPool-2] INFO c.c.r.exavault.ExavaultShareClient - Received createShare response from Exavault API: <200 OK,ResponseWrapper(success=1, error=null, results={"id":707879,"name":"Cubenix :: 6957384f-f6e5-4b9b-bdf6-7e4d1201d7a0","hasPassword":false,"public":true,"accessMode":"download","accessDescription":"Download only","embed":false,"hash":"ghu4-2uh8ka1v","ownerHash":"ghu4-2uh8ka1v-5cily01p","expiration":"2018-05-25 11:54:47","trackingStatus":"pending","expired":false,"resent":null,"owner":78413,"ownerUsername":"cubenix","type":"send","requireEmail":false,"fileDropCreateFolders":false,"paths":["/summary_report_report_1526064885551.xlsx"],"assets":[],"recipients":[{"id":763463,"shareId":707879,"type":"direct","hash":"dxhcx2mi","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:54:47"}],"recipientsWithOwner":[{"id":763463,"shareId":707879,"type":"direct","hash":"dxhcx2mi","email":"khanenko86@gmail.com","sent":false,"received":false,"created":"2018-05-11 11:54:47"},null],"messages":[],"inherited":null,"status":1,"hasNotification":false,"notification":null,"created":"2018-05-11 11:54:47","modified":null}),{Date=[Fri, 11 May 2018 18:54:47 GMT], Server=[Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.30 mod_perl/2.0.10 Perl/v5.16.3], X-Powered-By=[PHP/5.6.30], Access-Control-Allow-Origin=[*], Access-Control-Allow-Headers=[api_key, Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With], Access-Control-Allow-Methods=[GET,POST,PUT,DELETE,OPTIONS], Content-Length=[1033], Keep-Alive=[timeout=5, max=98], Connection=[Keep-Alive], Content-Type=[application/json]}>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement