Test status: COMPLETED WITH ERRORS

Table of Contents
Overview IN PROGRESS

Regression testing of Fiscal Year Rollover (FYR) on Eureka based environment in quesnelia release.
- The testing triggered from UI for the ledger with generated amount of defined data set (Data quantity**: 50000 orders with Open status and 50000 orders with Pending status).
Testing include two different phases of the fiscal year transition process:
- #1 phase: Test Fiscal Year Rollover - is a risk free simulation pre-step to #2 phase which includes only Finance part of the data (to preview how the rollover settings will affect funds, budgets, and encumbrances).
- #2 phase: Fiscal Year Rollover - perform a permanent changes. It is the actual process which move financial data, budgets, and encumbrances into the new fiscal year. It includes not only Finance but Orders parts of the data too.
The purpose of testing is to define duration time of those 2 phases, to do comparison between current and previous results of each phase, to find any trends for resource utilization. To recommend improvements how to make it work better if any confirmed.
- Previous successful testing for #2 phase took 29 hours
Jiras/ links:
- The previous results reports:
  - [Poppy] Fiscal year rollover testing
  - [Orchid] Fiscal year rollover testing
- The current ticket:
  Jira Legacy
  server System Jira
  serverId 01505d01-b853-3c2e-90f1-ee9b165564fc
  key PERF-1016

Summary

Running FYR on eureka completed with errors. Tests failed multiple times on overall order rollover with 504 Gateway Time-out issue.
The problem confirmed on okapi based environment. In scope of investigation of the problem the Time-out was solved changing parameter max_locks_per_transaction in DB configuration from 64 to 1024.
Eureka based environment (after changes were applied):
- #1 Phase Test FYR took 3 hours 35 minutes, completed successfully.
- #2 Phase actual FYR took 8 hours and completed with errors* (Order rollover Error).
Okapi based environment (after changes were applied):
- #1 Phase Test FYR took 3 hours 20 minutes. Completed successfully.
- #2 Phase actual FYR took 9 hours 7 minutes. Completed successfully.
Service CPU utilization for pre-strop to Fiscal Year Rollover (FYR) - Test FYR was less than 5% for all the modules, except a spike at the beginning of test rollover (mod-invoice reached 10%, mod-invoice-storage - 8%). Some modules were steady - mod-inventory - 11%, mod-pubsub - 8%.
DB CPU usage was on level of 9% during the test rollover and there was growing trend from 9% to 15% during the rollover itself.
No memory leaks were found.

Recommendations

Set max_locks_per_transaction parameter in DB cluster and instance configurations from default 64 to 1024 to avoid problems with ordersRollover.
Investigation of issues on Eureka based environment
Jira Legacy
server System Jira
serverId 01505d01-b853-3c2e-90f1-ee9b165564fc
key MODFISTO-495
- Time out issue
Jira Legacy
server System Jira
serverId 01505d01-b853-3c2e-90f1-ee9b165564fc
key EUREKA-518
- UI pending issue

Errors

127.0.0.1:43264 POST /finance/ledger-rollovers null HTTP_1_1 500 265 400027 tid=[tenant] Internal Server Error. This error happens when we try FYR with more than 10k open orders. The last attempt to run FYR with 50k open orders after changed recommended parameter max_locks_per_transaction failed. A new observation here is that budgets became unavailable with this amount of data. Probably it may cause fail of FYR.
* Error message: io.vertx.core.impl.NoStackTraceThrowable: Response status code 401 is not between 200 and 299,qelc2/mod-finance-storage/9044d47f773b48a99cc6c8420864b724 which indicate possible RTR issue.
WARN [org.fol.sid.ser.rou.RequestMatchingService] (vert.x-eventloop-thread-4) Egress routing entry was not found for the request's path. Forwarding request to the Gateway:moduleId = sc-mod-finance-storage, path = /orders/rollover, destination = https://kong-qelc2.int.aws.folio.org, x-okapi-module-id = null",qelc2/sidecar-mod-finance-storage/9044d47f773b48a99cc6c8420864b724,054267740449:qelc2-folio-eis
ERROR edgerRolloverService handleOrderRolloverError:: Orders rollover failed for ledger f38a29f5-feaa-4363-98a1-1eba79557c9c

Test Runs and Results

Data size: 100K orders (50K orders in open status, 50K - pending), 200K order lines, 400K transactions.

...

Test #

...

Scenario

...

Fiscal year rollover duration Orchid*

...

Fiscal year rollover duration

Poppy*

...

FYR duration

Quesnelia (Eureka)

...

FYR duration

Quesnelia (non-Eureka)

...

-

...

3.5 hours

...

6 days (failed with 504 error)

...

29 hours

8 hours, failed due to 500(server error)

...

On eureka Rollover competed with error.

On non-eureka Rollover completed successfully.

*Results are taken from the previous test report. Details can be found at the link: [Orchid] Fiscal year rollover testing

*Results are taken from the previous test report. Details can be found at the link: [Poppy] Fiscal year rollover testing

**Data structure can be found at the link: Fiscal year rollover testing

Instance CPU Utilization

Test FY rollover

There's no affect on

FY rollover

no graph

Service CPU Utilization

Test FY rollover

Image Removed

Maximum CPU utilization by modules:

mod-finance storage - 16% (spike at the beginning)

mod-inventory - 10%

mod-orders, mod-orders-storage - 1,5%, 3%

mod-finance - under 1%

FY rollover

Image Removed

Maximum CPU utilization by modules:

mod-inventory - 11%

mod-orders - 1.5%

mod-orders-storage - 3%

mod-finance - 0.15%

mod-finance storage - 1.2%

Memory Utilization

Test FY rollover

Image Removed

Memory usage by modules:

mod-finance-storage - 85%

mod-finance - 41%

mod-orders - 57%

mod-orders-storage - 46%

FY rollover

Image Removed

Memory usage by modules:

mod-finance-storage - 85%

mod-finance - 42%

mod-orders - 58%

mod-orders-storage - 46%

DB CPU Utilization

Test FY rollover (qelc2)

Image Removed

Maximum DB CPU usage - 9 - 20%

Test FY rollover (qcon)

Image Removed

FY rollover (qelc2)

Image Removed

Maximum DB CPU usage - 99%

FY rollover (qcon)

Spikes are connected to fqm manager queries (as example - REFRESH MATERIALIZED VIEW CONCURRENTLY cs00000int_0001_mod_fqm_manager.drv_langu...). Do not affect duration of FYR.

Image Removed

DB Connections

Test FY rollover (qelc2)

Image Removed

Test FY rollover (qcon)

Image Removed

FY rollover (qelc2)

Image Removed

FY rollover (qcon)

mod-serials was not paused for the test (because of that we see such connection number increase)

Image Removed

DB Load

Test FY rollover (qcon)

Image Removed

FY rollover (qcon)

Image Removed

Top SQL

Test FY rollover (qcon)

Image Removed

FY rollover (qcon)

Image Removed

Appendix

Infrastructure

PTF -environment qelc2

...

1 database instance, writer

...

db.r6g.4xlarge

...

4 m5.2xlarge brokers in 2 zones
Apache Kafka version 3.7.x
EBS storage volume per broker 300 GiB
auto.create.topics.enable=true
log.retention.minutes=480
default.replication.factor=3

PTF -environment qcon

...

1 database instance, writer

...

db.r6g.xlarge

...

title	Module QELC2

Cluster Resources - qelc2-pvt (Wed Nov 06 11:34:51 UTC 2024)

...

Test status: COMPLETED WITH ERRORS

Table of Contents
Overview

Regression testing of Fiscal Year Rollover (FYR) on Eureka based environment in quesnelia release.
- The testing triggered from UI for the ledger with generated amount of defined data set (Data quantity**: 50000 orders with Open status and 50000 orders with Pending status).
Testing include two different phases of the fiscal year transition process:
- #1 phase: Test Fiscal Year Rollover - is a risk free simulation pre-step to #2 phase which includes only Finance part of the data (to preview how the rollover settings will affect funds, budgets, and encumbrances).
- #2 phase: Fiscal Year Rollover - perform a permanent changes. It is the actual process which move financial data, budgets, and encumbrances into the new fiscal year. It includes not only Finance but Orders parts of the data too.
The purpose of testing is to define duration time of those 2 phases, to do comparison between current and previous results of each phase, to find any trends for resource utilization. To recommend improvements how to make it work better if any confirmed.
- Previous successful testing for #2 phase took 29 hours
Jiras/ links:
- The previous results reports:
  - [Poppy] Fiscal year rollover testing
  - [Orchid] Fiscal year rollover testing
- The current ticket:
  Jira Legacy
  server System Jira
  serverId 01505d01-b853-3c2e-90f1-ee9b165564fc
  key PERF-1016

Summary

Running FYR on eureka completed with errors. Tests failed multiple times on overall order rollover with 504 Gateway Time-out issue.
The problem confirmed on okapi based environment. In scope of investigation of the problem the Time-out was solved changing parameter max_locks_per_transaction in DB configuration from 64 to 1024.
Eureka based environment (after changes were applied):
- #1 Phase Test FYR took 3 hours 35 minutes, completed successfully.
- #2 Phase actual FYR took 8 hours and completed with errors* (Order rollover Error).
Okapi based environment (after changes were applied, testing is carried out in scope of investigation to check functionality of FYR):
- #1 Phase Test FYR took 3 hours 20 minutes. Completed successfully.
- #2 Phase actual FYR took 9 hours 7 minutes. Completed successfully.
Service CPU utilization for both phases was under 5% on eureka environment except a spike at the beginning of test rollover (mod-finance-storage - 16%, mod-invoice - 10%). Module mod-inventory - 11% during whole test.
DB CPU usage was on level of 9% during #1 Phase and there was growing trend from 9% to 15% during the rollover itself on Eureka environment with 4xlarge database. On xlarge database - 39% without growth.
No memory leaks were found.

Recommendations & Jiras

Set max_locks_per_transaction parameter in DB cluster and instance configurations from default 64 to 1024 to avoid Time-out issue during actual rollover (#2 Phase).
Investigation of issues on Eureka based environment
Jira Legacy
server System Jira
serverId 01505d01-b853-3c2e-90f1-ee9b165564fc
key MODFISTO-495
- Time out issue.

Errors

127.0.0.1:43264 POST /finance/ledger-rollovers null HTTP_1_1 500 265 400027 tid=[tenant] Internal Server Error. This error happens when we try FYR with more than 10k open orders. The last attempt to run FYR with 50k open orders after changed recommended parameter max_locks_per_transaction failed. A new observation here is that budgets became unavailable with open orders >= 42000 after max_locks_per_transaction parameter was changed from 64 to 1024. Probably it may cause fail of FYR.
* Error message: io.vertx.core.impl.NoStackTraceThrowable: Response status code 401 is not between 200 and 299,qelc2/mod-finance-storage/9044d47f773b48a99cc6c8420864b724 which indicate possible RTR issue.
WARN [org.fol.sid.ser.rou.RequestMatchingService] (vert.x-eventloop-thread-4) Egress routing entry was not found for the request's path. Forwarding request to the Gateway:moduleId = sc-mod-finance-storage, path = /orders/rollover, destination = https://kong-qelc2.int.aws.folio.org, x-okapi-module-id = null",qelc2/sidecar-mod-finance-storage/9044d47f773b48a99cc6c8420864b724,054267740449:qelc2-folio-eis
ERROR edgerRolloverService handleOrderRolloverError:: Orders rollover failed for ledger f38a29f5-feaa-4363-98a1-1eba79557c9c

Test Runs and Results

Data size: 100K orders (50K orders in open status, 50K - pending), 200K order lines, 400K transactions.

Test #

Scenario

Load level

Fiscal year rollover duration Orchid*

Fiscal year rollover duration

Poppy*

FYR duration

Quesnelia (Eureka)

FYR duration

Quesnelia (non-Eureka)

Comments

1

Test Fiscal year rollover

1 rollover at a time

-

3.5 hours

3 hours 20 minutes

Test rollover finished successfully.

2

Fiscal year rollover

1 rollover at a time

6 days (failed with 504 error)

29 hours

8 hours, failed due to 500(server error)

9 hours 7 minutes

On eureka Rollover competed with error.

On non-eureka Rollover completed successfully.

*Results are taken from the previous test report. Details can be found at the link: [Orchid] Fiscal year rollover testing

*Results are taken from the previous test report. Details can be found at the link: [Poppy] Fiscal year rollover testing

**Data structure can be found at the link: Fiscal year rollover testing

Service CPU Utilization

Note: Instance level CPU screenshots is not included in this report. Taking into account that Fiscal Year Rollover process is mostly happening on DB side - it's barely visible on service CPU, so it's invisible on instance CPU.

Test FYR (Eureka)

Low CPU usage during FYR reflects that it can handle large fiscal year transitions efficiently. As the process runs mostly on database level.

Image Added

Maximum CPU utilization by modules:

mod-finance storage - 16% (spike at the beginning)

mod-inventory - 10%

mod-orders, mod-orders-storage - 1,5%, 3%

mod-finance - under 1%

FYR (Eureka)

Image Added

Maximum CPU utilization by modules on eureka:

mod-inventory - 11%

mod-orders - 1.5%

mod-orders-storage - 3%

mod-finance - 0.15%

mod-finance storage - 1.2%

Memory Utilization

Test FYR (Eureka)

This graph shows memory usage during #1 phase of FYR. No signs of memory leaks trends.

Image Added

Memory usage by modules:

mod-finance-storage - 85%

mod-finance - 41%

mod-orders - 57%

mod-orders-storage - 46%

FYR (Eureka)

This graph shows memory usage during #2 phase of FYR. No signs of memory leaks trends too. Consumption is on the same level as #1 phase.

Image Added

Memory usage by modules:

mod-finance-storage - 85%

mod-finance - 42%

mod-orders - 58%

mod-orders-storage - 46%

DB CPU Utilization

Test FYR (Eureka)

DB CPU usage range: 9% - 20%. Utilization was stable during #1 phase except of spikes to 20%. It competed successfully so it didn't affect the test.

Image Added

Test FYR (non-Eureka)

The #1 phase of FYR was carried out on xlarge DB instance. That's the reason why we see 34% of DB CPU utilization. The utilization was stable - 34%. This phase completed successfully.

Image Added

FYR (Eureka)

Image Added

Maximum DB CPU usage - 99%

FYR (non-Eureka)

Spikes are connected to fqm manager queries (as example - REFRESH MATERIALIZED VIEW CONCURRENTLY [tenant]_0001_mod_fqm_manager.drv_langu...). Do not affect duration of FYR.

The #2 phase completed successfully in non-eureka. It utilized 35% which is almost the same as in #1 phase.

Image Added

DB Connections

DB connections stay on the same level during all phases of FYR. Connections in Eureka - 690 and non-Eureka 1380.. The difference can be explained by enabled mod-serials-management module on qcon environment.

Test FYR (Eureka)

Image Added

Test FYR (non-Eureka)

Image Added

FYR (Eureka)

Image Added

FYR (non-Eureka)

On qcon module mod-serials spiking affect DB connections growth from 700 to 1400.

Image Added

DB Load

Test FY rollover (non-Eureka)

On this graphs sql statement responsible for budget encumbrances rollover consume most of CPU.

Image Added

FY rollover

Image Added

Top SQL

Test FY rollover (non-Eureka)

On this graphs sql statement responsible for budget encumbrances rollover consume most of CPU.

Image Added

FY rollover

Image Added

Appendix

Infrastructure

PTF -environment qelc2

10 m6i.2xlarge EC2 instances located in US East (N. Virginia)us-east-1
1 database instance, writer.
Name Memory GIB vCPUs max_connections
db.r6g.4xlarge
128 GiB 16 vCPUs 4000
db.r6g.xlarge 32 GB 4vCPUs 2000
database cluster and instance parameters max_locks_per_transaction - 64, changed to 1024
MSK fse-tenant
- 4 kafka.m7g.xlarge brokers in 2 zones (2 brokers per zone)
- Apache Kafka version 3.7.x, metadata mode - KRaft
- EBS storage volume per broker 300 GiB
- auto.create.topics.enable=true
- log.retention.minutes=480
- default.replication.factor=2

PTF -environment qcon

10 m6i.2xlarge EC2 instances located in US East (N. Virginia)us-east-1
1 database instance, writer
Name Memory GIB vCPUs max_connections
db.r6g.xlarge
32 GiB 4 vCPUs 2000
database cluster and instance parameters max_locks_per_transaction - 64, changed to 1024

Expand

title	Module QELC2

Cluster Resources - qelc2-pvt (Wed Nov 06 11:34:51 UTC 2024)

Module	Task Definition Revision	Module Version	Task Count	Mem Hard Limit	Mem Soft Limit	CPU Units	Xmx	Metaspace Size	Max Metaspace Size
mod-remote-storage	22	mod-remote-storage:3.2.0	0	4920	4472	1024	3960	512	512
mod-remote-storage - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-datafinance-importstorage	2124	mod-datafinance-importstorage:38.16.1	0	20481024	1844896	2561024	1292700	38488	512128
mod-datafinance-import storage - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
edgemod-dematicncip	923	edgemod-dematicncip:21.214.35	0	1024	896	0	768	88	128
mod-consortia-keycloak	20	mod-consortia-keycloak:1.4.2	0	5136	4776	1024	4416	384	512	mod-consortia-keycloak - -ncip - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-agreements	22	mod-agreements:7.0.6	0	1592	1488	0	0	0	0
mod-agreements - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-tagsebsconet	21	mod-tagsebsconet:2.2.0	0	1248	1024	896128	0700	768128	88	128256
mod-tags ebsconet - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
edge-coursessip2	96	edge-coursessip2:13.42.25	0	1024	896	0	768	88	128
mod-inventory-updateorganizations	2223	mod-inventory-updateorganizations:31.39.12	0	1024	896	0	768	88	128
mod-inventory-update organizations - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-notifysettings	21	mod-notifysettings:31.20.03	0	1024	896	0200	768	88	128
mod-notify settings - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-serials-configurationmanagement	2322	mod-serials-configurationmanagement:51.100.03	0	10242480	8962312	0	7681792	88384	128512
mod-configuration serials-management - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-orders-storagesearch	3621	mod-orders-storagesearch:133.72.46	0	10242592	8962480	5122048	7001440	88512	1281024
mod-orders-storage search - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
foliomod-data-keycloakimport	1621	foliomod-data-keycloakimport:253.01.1.150	0	16842048	15361844	0256	20481292	0384	0	edge-caiasoft512
mod-data-import - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
edge-dematic	9	edge-caiasoftdematic:2.2.43	0	1024	896	0	768	88	128
mod-passwordconsortia-validatorkeycloak	2120	mod-passwordconsortia-validatorkeycloak:31.4.2.1	0	14405136	12984776	01024	7684416	384	512
mod-passwordconsortia-validator keycloak - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-gobitags	2321	mod-gobitags:2.82.10	0	1024	896	0	768	88	128
mod-gobi tags - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
modedge-licensescourses	219	modedge-licensescourses:61.04.32	0	24801024	2312896	5120	1792768	384	512	mod-licenses 88	128
mod-inventory-update	22	mod-inventory-update:3.3.1	0	1024	896	0	768	88	128
mod-inventory-update - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-bulk-operationsnotify	1721	mod-bulk-operationsnotify:3.2.0.2	0	30721024	2600896	0	1536768	38488	512128
mod-bulknotify - operations - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-fqm-managerconfiguration	2423	mod-fqm-manager:2configuration:5.10.0.5	0	1024	896	0	768	88	128
mod-fqm-manager configuration - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-orders-graphqlstorage	2136	mod-orders-graphqlstorage:113.127.14	0	1024	896	0512	768700	88	128
mod-orders-graphql storage - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
modfolio-financekeycloak	2616	modfolio-financekeycloak:425.0.91.0150	0	10241684	8961536	0	7682048	880	1280
mod-finance - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-roles-keycloak	29	mod-roles-keycloak:1.4.4	0	1024	896	0	512	88	256
mod-roles-keycloak edge-caiasoft	9	edge-caiasoft:2.2.4	0	1024	896	0	768	88	128
mod-password-validator	21	mod-password-validator:3.2.1	0	1440	1298	0	768	384	512
mod-password-validator - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-batch-printgobi	1823	mod-batch-print:1gobi:2.8.1.0	0	1024	896	0	768	88	128
mod-batch-print gobi - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-copycatlicenses	21	mod-copycatlicenses:1.6.0.3	0	10242480	8962312	0512	7681792	88384	128512
mod-copycat licenses - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-listsbulk-operations	2317	mod-bulk-listsoperations:2.0.62	0	10243072	8962600	0	7681536	88384	128512
mod-lists bulk-operations - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-permissionsfqm-manager	3824	mod-fqm-permissionsmanager:62.0.5.0	0	16841024	1544896	5120	1024768	38488	512128
mod-permissions fqm-manager - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-entities-linksgraphql	21	mod-entities-linksgraphql:31.012.21	0	25921024	2480896	4000	1440768	088	1024128
mod-entities-links graphql - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
pubmod-edgefinance	226	pubmod-edgefinance:20234.069.140	0	1024	896	0	768	0880	128
mod-orders	26	mod-orders:12.8.8	0	2048	1740	1024	1024	384	512	mod-orders - finance - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0	kong	14	kong:3.7.1.83	0	6144	6144	2048	768	88	128	edge-patron	9	edge-patron:5.1.2	0	1024	896	256
768	88	128	mod-usersroles-keycloak	3229	mod-usersroles-keycloak:1.54.34	0	1024	896	0	512	88	256
mod-usersroles-keycloak - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
edgemod-ncipbatch-print	918	edgemod-batch-ncipprint:1.101.10	0	1024	896	0	768	88	128	mgr-applications	10
mgr-applicationsmod-batch-print - Sidecar 1	N/A	folio-module-sidecar:1.30.30.312	1024N/A	896665	512	0	512128	880	2560
mod-users-blcopycat	1821	mod-users-blcopycat:71.86.0	0	14401024	1152896	5120	922768	88	128
mod-userscopycat - bl - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mgrmod-tenantslists	1023	mgrmod-tenantslists:12.30.36	0	1024	896	5120512	768	88	256128
mod-invoice	29	mod-invoice:5.8.2	0	1440	1152	512	922	88	128	mod-invoice - Sidecar 1	N/A	folio-module-sidecar:lists - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-inventory-storagepermissions	2438	mod-inventory-storagepermissions:276.15.40	0	40961684	36901544	2048512	30761024	384	512
mod-inventory-storage permissions - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-userentities-importlinks	21	mod-userentities-importlinks:3.80.02	0	10242592	8962480	0400	7681440	880	1281024
mod-userentities-import links - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
modpub-senderedge	222	modpub-senderedge:12023.1206.014	0	1024	896	0	768	880	1280
mod-sender orders	26	mod-orders:12.8.8	0	2048	1740	1024	1024	384	512
mod-orders - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
edge-oai-pmh	9	edge-oai-pmh:2.9.2kong	14	kong:3.7.1.83	0	15126144	13606144	10242048	1440768	38488	512128
mgredge-tenant-entitlementspatron	109	mgredge-tenant-entitlementspatron:5.1.2.4	0	1024	896	512256512	768	88	256128
mod-loginusers-keycloak	3132	mod-loginusers-keycloak:1.45.3	0	1024	896	0	512	88	256
mod-loginusers-keycloak - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-data-export-worker	21	mod-data-export-worker:3.2.4	0	3072	2800	1024	2048	384	512
mod-data-export-worker - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-rtac	21	mod-rtac:3.6.0	0	1024	896	0	768edge-ncip	9	edge-ncip:1.10.1	0	1024	896	0	768	88	128
mgr-applications	10	mgr-applications:1.3.3	0	1024	896	512	512	88	256
mod-users-bl	18	mod-users-bl:7.8.0	0	1440	1152	512	922	88	128
mod-users-rtac bl - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
modmgr-circulation-storagetenants	3110	modmgr-circulation-storagetenants:171.23.3	0	28801024	2592896	1536512	1814512	38488	512256
mod-circulation-storage invoice	29	mod-invoice:5.8.2	0	1440	1152	512	922	88	128
mod-invoice - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-inventory-schedulerstorage	2224	mod-schedulerinventory-storage:27.1.2.34	0	10244096	8963690	02048	5123076	88384	256512
mod-inventory-scheduler storage - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-user-calendarimport	21	mod-calendaruser-import:3.18.0	0	1024	896	0	768	88	128
mod-calendar user-import - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-source-record-storage26sender	22	mod-source-record-storage:5.8.6sender:1.12.0	0	56001024	5000896	20480	3500768	38488	512128
mod-source-recordsender - storage - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
modedge-eventoai-configpmh	219	modedge-eventoai-configpmh:2.79.12	0	10241512	8961360	01024	7681440	88384	128512
modmgr-event-config - Sidecar 1	N/A	folio-module-sidecartenant-entitlements	10	mgr-tenant-entitlements:1.02.4	0.312	N/A1024	665896	512	0512	12888	0256	0
mod-login-courseskeycloak	2031	mod-courseslogin-keycloak:1.4.103	0	1024	896	0	768512	88	128256
mod-courses login-keycloak - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-data-export-inventoryworker	2421	mod-inventory:20data-export-worker:3.2.74	0	28803072	25922800	1024	18142048	384	512
mod-data-inventory export- Sidecar worker - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-emailrtac	21	mod-emailrtac:13.176.0	0	28001024	2550896	5120	1800768	38488	512128
mod-email rtac - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-di-convertercirculation-storage	2331	mod-di-convertercirculation-storage:217.2.23	0	10242880	8962592	01536	7681814	88384	128512
mod-di-convertercirculation-storage - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-circulationscheduler	2822	mod-circulationscheduler:241.2.53	0	28801024	2592896	15360	1814512	38488	512256
mod-circulation scheduler - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-pubsubcalendar	2321	mod-pubsubcalendar:23.141.0	0	15361024	1440896	10240	922768	38488	512128
mod-pubsub calendar - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
edge-orders	11	edge-orders:3.0.3	0	1024	896	0	768	88	128
edge-rtac	9	edge-rtac:2.7.3	0	1024	896	0	768	88	128
mod-users	23	mod-users:19.3mod-source-record-storage	26	mod-source-record-storage:5.8.6	0	5600	5000	2048	3500	384	512
mod-source-record-storage - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-event-config	21	mod-event-config:2.7.1	0	1024	896	0	768	88	128
mod-event-users config - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-template-enginecourses	2120	mod-template-enginecourses:1.204.010	0	1024	896	0	768	88	128
mod-templatecourses - engine - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-patron-blocksinventory	1824	mod-patron-blocksinventory:120.102.07	0	10242880	8962592	1024	7681814	88384	128512
mod-patroninventory - blocks - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-auditemail	2221	mod-auditemail:21.917.0	0	10242800	8962550	0512	7681800	88384	128512
mod-audit email - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
edge-fqm	9	edge-fqmmod-di-converter-storage	23	mod-di-converter-storage:2.02.2	0	1024	896	0	768	88	128
mod-sourcedi-record-manager	22	mod-source-record-manager:3.8.6	0	5600	5000	2048	3500	384	512	mod-source-record-manager - converter-storage - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
nginxmod-edgecirculation	228	nginxmod-edgecirculation:202324.06.14	0	1024	896	0	0	0	0	mod-quick-marc	21	mod-quick-marc:5.1.12.5	0	22882880	21762592	01536	16641814	384	512
mod-quick-marc circulation - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-feesfinespubsub	2123	mod-feesfinespubsub:192.114.0	0	10241536	8961440	01024	768922	88384	128512
mod-feesfines pubsub - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
modedge-invoice-storageorders	2511	modedge-invoice-storageorders:53.80.13	0	18721024	1536896	102401024	768	38488	512128
mod-invoice-storage - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-service-interaction	22	mod-service-interaction:4.0.2	0	2048	1844	256	1290	384	512
mod-service-interaction edge-rtac	9	edge-rtac:2.7.3	0	1024	896	0	768	88	128
mod-users	23	mod-users:19.3.1	0	1024	896	0	768	88	128
mod-users - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-datatemplate-exportengine	2021	mod-datatemplate-exportengine:51.20.0.4	0	25921024	2480896	10240	1440768	88	1024128
mod-datatemplate-export engine - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-patron-blocks	2518	mod-patron-blocks:61.110.0	0	1024	896	01024	768	88	128
mod-patron-blocks - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-oai-pmhaudit	22	mod-oai-pmh:3.13.2audit:2.9.0	0	40961024	3690896	20480	3076768	38488	512128
mod-oai-pmh audit - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
edge-connexionfqm	69	edge-connexionfqm:12.30.12	0	1024	896	0	768	88	128
mod-kbsource-ebscorecord-javamanager	2122	mod-kbsource-ebscorecord-javamanager:43.08.06	0	10245600	8965000	02048	7683500	88384	128512
mod-kbsource-ebscorecord-java manager - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
modnginx-notesedge	222	modnginx-notesedge:52023.206.014	0	1024	896	0	9520	3840	5120
mod-notes quick- Sidecar 1	N/A	folio-module-sidecar:1.0marc	21	mod-quick-marc:5.1.1	0	2288	2176	0	1664	384	512
mod-quick-marc - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-data-export-spring20feesfines	21	mod-data-export-spring:3.3feesfines:19.1.0	0	20481024	1844896	2560	1536768	38488	512128
mod-data-exportfeesfines - spring - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-organizationsinvoice-storage	2325	mod-organizationsinvoice-storage:45.78.01	0	10241872	8961536	01024	7681024	88384	128512
mod-organizationsinvoice-storage - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
edgemod-service-erminteraction	622	edgemod-service-erminteraction:14.0.2.1	0	10242048	8961844	0256	7681290	88384	128

Expand

title	Module QCON

Cluster Resources - qcon-pvt (Wed Nov 06 11:28:29 UTC 2024)

Module	Task Definition Revision	Module Version	Task Count	Mem Hard Limit	Mem Soft Limit	CPU Units	Xmx	Metaspace Size	Max Metaspace Size
mod-remote-storage	1	mod-remote-storage:3.2.0	2	4920	4472	1024	3960	512	512
mod-finance-storage	1	mod-finance-storage:8.6.0	2	1024	896	1024	700	88	128
mod-ncip	1	mod-ncip:1.14.4	2	1024	896	128512
mod-service-interaction - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-data-export	20	mod-data-export:5.0.4	0	2592	2480	1024	1440	88	1024
mod-data-export - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-patron	25	mod-patron:6.1.0	0	1024	896	0	768	88	128
mod-agreements	1	mod-agreements:7patron - Sidecar 1	N/A	folio-module-sidecar:1.0.0	2	1592	1488.312	N/A	665	512	0	128	0	0	0
mod-oai-ebsconetpmh	122	mod-oai-ebsconetpmh:23.13.2.	0	24096	12483690	10242048	1283076	700384	128512	256
mod-consortia	1	mod-consortiaoai-pmh - Sidecar 1	N/A	folio-module-sidecar:1.10.0	2	3072	2048.312	N/A	665	512	0	128	20480	5120	1024
modedge-organizationsconnexion	16	modedge-organizationsconnexion:1.93.1	02	1024	896	1280	700768	88	128
mod-kb-serialsebsco-managementjava	121	mod-serialskb-ebsco-managementjava:14.0.0	20	24801024	2312896	1280	1792768	38488	512128
mod-settings	2	mod-settings-kb-ebsco-java - Sidecar 1	N/A	folio-module-sidecar:1.0.3	2	1024	896	200	768	88	1280.312	N/A	665	512	0	128	0	0
mod-searchnotes	922	mod-searchnotes:35.32.0	0-SNAPSHOT.224	21024	2592896	24800	2048952	1440384	512	1024	edge-dematic	1	edge-dematic:2.2.0	1	1024	896	128	768	88
128mod-notes - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-data-importexport-spring	120	mod-data-importexport-spring:3.13.01	0	2048	1844	256	12921536	384	512
mod-tags	1	mod-tags:2.2.0	2	1024	896	128	768	88	128
mod-authtoken	6	mod-authtoken:2.15.1	2	1440	1152	512	922	88	128
edge-courses	1	edge-courses:1.4.0	2	1024	896	128	768	88	128
mod-inventory-update	1	mod-inventory-update:3.3.0	2	1024	896	128-data-export-spring - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
mod-organizations-storage	23	mod-organizations-storage:4.7.0	0	1024	896	0	768	88	128
mod-organizations-storage - Sidecar 1	N/A	folio-module-sidecar:1.0.0.312	N/A	665	512	0	128	0	0
edge-erm	6	edge-erm:1.2.1	0	1024	896	0	768	88	128mod-notify

mod-configuration:5.10

Expand

1

mod-notify:3.2.0

2

1024

896

128

768

88

128

mod-configuration

1

title	Module QCON

Cluster Resources - qcon-pvt (Wed Nov 06 11:28:29 UTC 2024)

Module	Task Definition Revision	Module Version	Task Count	Mem Hard Limit	Mem Soft Limit	CPU Units	Xmx	Metaspace Size	Max Metaspace Size
mod-remote-storage	1	mod-remote-storage:3.2.0	2	10244920	8964472	1281024	7683960	88512	128512
mod-ordersfinance-storage	31	mod-ordersfinance-storage:138.76.40	2	1024	896	5121024	700	88	128
edgemod-caiasoftncip	1	edgemod-caiasoftncip:21.214.04	2	1024	896	128	768	88	128
mod-login-samlagreements	1	mod-login-samlagreements:27.80.0	2	10241592	8961488	128	7680	880	1280
mod-erm-usage-harvesterebsconet	1	mod-erm-usage-harvester:4.5.0	2	1024	896	128	768	88	128	mod-password-validator	1	mod-password-validator:3ebsconet:2.2.0	2	14401248	12981024	128	768700	384128	512256
mod-licensesconsortia	1	mod-licensesconsortia:61.01.0	2	24803072	23122048	128	17922048	384512512	1024
mod-gobiorganizations	1	mod-gobiorganizations:21.89.0	2	1024	896	128	700	88	128
mod-bulkserials-operationsmanagement	1	mod-bulkserials-operationsmanagement:21.0.0	2	30722480	26002312	1024128	15361792	384	512
mod-fqm-manager1settings	2	mod-fqm-managersettings:21.0.13	2	30001024	2600896	128200	2048768	38488	512128
edgemod-dcbsearch	19	edgemod-dcbsearch:13.13.0-SNAPSHOT.224	2	10242592	8962480	1282048	7681440	88512	1281024
modedge-graphqldematic	1mod	edge-graphqldematic:12.122.0	1	2	1024	896	128	768	88	128
mod-financedata-import	1	mod-data-financeimport:43.91.0	21	10242048	8961844	128256	7001292	88384	128512
mod-erm-usagetags	1	mod-erm-usagetags:42.72.0	2	1024	896	128	768	88	128
mod-batch-printauthtoken	16	mod-batch-print:1authtoken:2.15.1.0	2	10241440	8961152	128512	768922	88	128
modedge-copycatcourses	1	modedge-copycatcourses:1.64.0	2	1024	512896	128	768	88	128
mod-inventory-listsupdate	1	mod-inventory-listsupdate:23.03.0	2	30001024	2600896	128	2048768	38488	512128
mod-entities-linksnotify	1	mod-entities-linksnotify:3.02.0	2	25921024	2480896	400128	1440768	088	1024128
mod-permissionsconfiguration	41	mod-permissionsconfiguration:65.610.0-SNAPSHOT.379	2	16841024	1544896	512128	1024768	38488	512128
pubmod-orders-edgestorage	13	pubmod-orders-edgestorage:202313.067.144	2	1024	896	128512	768700	0880	128
modedge-orderscaiasoft	31	modedge-orderscaiasoft:122.82.80	2	20481024	1740896	10241281024	768	38488	512128
edgemod-login-patronsaml	1edge	mod-login-patronsaml:52.18.0	2	1024	896	256128	768	88	128edge
-ncipmod-erm-usage-harvester	1edge-	ncip:1.9.2mod-erm-usage-harvester:4.5.0	2	1024	896	128	768	88	128
mod-userspassword-blvalidator	1	mod-userspassword-blvalidator:73.72.0	2	1440	11521298	512128	922768	88384	128512
mod-invoicelicenses	51	mod-invoicelicenses:56.80.20	2	2880	2304	2	20482480	2312	128	1792	384	512
mod-gobi	1	mod-gobi:2.8.0	2	1024	896	128	700	88	128
mod-inventorybulk-storageoperations	21	mod-inventorybulk-storageoperations:27.2.0-SNAPSHOT.7380	2	40963072	36902600	20481024	30761536	384	512
mod-userfqm-importmanager	1	mod-userfqm-importmanager:32.80.01	2	10243000	8962600	128	7682048	88384	128512
modedge-senderdcb	1	modedge-senderdcb:1.121.0	2	1024	896	128	768	88	128
edgemod-oai-pmhgraphql	1	edgemod-oai-pmhgraphql:21.912.01	2	15121024	1360896	1024128	1440768	38488	512128
mod-data-export-workerfinance	1	mod-data-export-worker:3.2.1finance:4.9.0	2	30721024	2048896	1024128	2048700	38488	512128
mod-erm-rtacusage	1	mod-erm-rtacusage:34.67.0	2	1024	896	128	768	88	128
mod-circulationbatch-storageprint	1	mod-circulationbatch-storageprint:171.21.0	2	28801024	2592896	1536128	1814768	38488	512128
mod-source-record-storagecopycat	1	mod-source-record-storage:5.8copycat:1.6.0	2	56001024	5000512	2048128	3500768	38488	512128
mod-calendarlists	1	mod-calendarlists:32.10.0	2	10243000	8962600	128	7682048	88384	128512
mod-evententities-configlinks	1	mod-evententities-configlinks:23.70.0	2	10242592	8962480	128400	7681440	880	1281024
mod-coursespermissions	14	mod-coursespermissions:1.4.106.6.0-SNAPSHOT.379	2	10241684	8961544	128512	7681024	88384	128512
modpub-circulation-itemedge	1mod	pub-circulation-itemedge:12023.006.014	2	1024	896	128	0768	0	0
mod-inventoryorders	3	mod-inventoryorders:2012.28.08	2	28802048	25921740	1024	18141024	384	512
modedge-emailpatron	1	modedge-emailpatron:5.1.17.0	2	1024	896	128256	768	88	128
modedge-circulationncip	21mod	edge-circulationncip:241.9.2.1	2	28801024	2592896	1536128	1814768	38488	512128
mod-pubsubusers-bl	1	mod-pubsubusers-bl:27.137.0	2	153614401440	1152	1024512	922	38488	512128
mod-di-converter-storage2invoice	5	mod-di-converter-storage:2.2invoice:5.8.2	2	10242880	8962304	1282	7682048	88	128
edgemod-inventory-ordersstorage	12	edgemod-inventory-ordersstorage:327.2.0-SNAPSHOT.0738	2	10244096	8963690	1282048	7683076	88384	128512
edgemod-user-rtacimport	1edge	mod-user-rtacimport:23.78.10	2	1024	896	128	768	88	128
mod-userssender	31	mod-userssender:191.312.10	2	20481024	1792896	128	1024768	88	256128
modedge-templateoai-enginepmh	1	modedge-templateoai-enginepmh:12.209.0	2	10241512	8961360	1281024	7681440	88384	128512
mod-patrondata-export-blocksworker	1	mod-data-patronexport-blocksworker:13.102.01	2	10243072	8962048	1024	7682048	88384	128512
mod-auditrtac	1	mod-auditrtac:23.96.0	2	1024	896	128	768	88	128
edgemod-circulation-fqmstorage	1	edgemod-circulation-fqmstorage:17.2.0.0	2	10242880	8962592	1281536	7681814	88384	128512
mod-source-record-managerstorage	41	mod-source-record-managerstorage:35.8.0	2	5600	5000	2048	3500	384	512
nginxmod-edgecalendar	1	nginxmod-edgecalendar:20233.061.140	2	1024	896	128	07680	88	0128
mod-quickevent-marcconfig	21	mod-quickevent-marcconfig:52.17.0	2	1024	896	128	768	88	128
mod-courses	1	mod-courses:1	2288	2176.4.10	2	1024	896	128	1664768	38488	512128
nginxmod-circulation-okapiitem	1	nginxmod-circulation-okapiitem:20231.060.140	2	1024	896	128	0	0	0
okapi-b	1	okapi:5.3.0	3	1684	1440	1024	922	384	512
mod-feesfines	1	mod-feesfines:19.1.0	2	1024	896	128	768	88	128
mod-invoice-storage	3	mod-invoice-storage:5.8.1	2	1872	1536	2	1024	384	512
mod-reading-room	7	mod-reading-room:1.0.0-SNAPSHOT.11	2	1024	896	128	768	88	128
mod-service-interaction	1	mod-service-interaction:4.0.1	2	2048	1844	256	1290	384	512
mod-dcb	1	mod-dcb:1.1.0	2	1024	896	128	768	88	128
mod-patron	1	mod-patron:6.1.0	2	1024	896	128	768	88	128
mod-data-export	1	mod-data-export:5.0.0	1	2048	1524	1024	0	0	0
mod-oai-pmh	1	mod-oai-pmh:3.13.0	2	4096	3690	2048	3076	384	512
edge-connexion	1	edge-connexion:1.2.0	2	1024	896	128	768	88	128
mod-notes	1	mod-notes:5.2.0	2	1024	896	128	952	384	512
mod-kb-ebsco-java	1	mod-kb-ebsco-java:4.0.0	2	1024	896	128	768	88	128
mod-login	2	mod-login:7.11.0	2	2048	1792	1024	1024	88	256
mod-organizations-storage	1	mod-organizations-storage:4.7.0	2	1024	896	128	700	88	128
mod-data-export-spring	1	mod-data-export-spring:3.2.0	1	2048	1844	256	1536	384	512
pub-okapi	1	pub-okapi:2023.06.14	2	1024	896	128	768	0	0
mod-eusage-reports	1	mod-eusage-reports:2.1.1	2	1024	896	128	768	88	128

Methodology/Approach

Files

View file
name PERF_865_FYR_results.xlsx
height 250

...

mod-inventory	3	mod-inventory:20.2.0	2	2880	2592	1024	1814	384	512
mod-email	1	mod-email:1.17.0	2	1024	896	128	768	88	128
mod-circulation	2	mod-circulation:24.2.1	2	2880	2592	1536	1814	384	512
mod-pubsub	1	mod-pubsub:2.13.0	2	1536	1440	1024	922	384	512
mod-di-converter-storage	2	mod-di-converter-storage:2.2.2	2	1024	896	128	768	88	128
edge-orders	1	edge-orders:3.0.0	2	1024	896	128	768	88	128
edge-rtac	1	edge-rtac:2.7.1	2	1024	896	128	768	88	128
mod-users	3	mod-users:19.3.1	2	2048	1792	128	1024	88	256
mod-template-engine	1	mod-template-engine:1.20.0	2	1024	896	128	768	88	128
mod-patron-blocks	1	mod-patron-blocks:1.10.0	2	1024	896	1024	768	88	128
mod-audit	1	mod-audit:2.9.0	2	1024	896	128	768	88	128
edge-fqm	1	edge-fqm:2.0.0	2	1024	896	128	768	88	128
mod-source-record-manager	4	mod-source-record-manager:3.8.0	2	5600	5000	2048	3500	384	512
nginx-edge	1	nginx-edge:2023.06.14	2	1024	896	128	0	0	0
mod-quick-marc	2	mod-quick-marc:5.1.0	1	2288	2176	128	1664	384	512
nginx-okapi	1	nginx-okapi:2023.06.14	2	1024	896	128	0	0	0
okapi-b	1	okapi:5.3.0	3	1684	1440	1024	922	384	512
mod-feesfines	1	mod-feesfines:19.1.0	2	1024	896	128	768	88	128
mod-invoice-storage	3	mod-invoice-storage:5.8.1	2	1872	1536	2	1024	384	512
mod-reading-room	7	mod-reading-room:1.0.0-SNAPSHOT.11	2	1024	896	128	768	88	128
mod-service-interaction	1	mod-service-interaction:4.0.1	2	2048	1844	256	1290	384	512
mod-dcb	1	mod-dcb:1.1.0	2	1024	896	128	768	88	128
mod-patron	1	mod-patron:6.1.0	2	1024	896	128	768	88	128
mod-data-export	1	mod-data-export:5.0.0	1	2048	1524	1024	0	0	0
mod-oai-pmh	1	mod-oai-pmh:3.13.0	2	4096	3690	2048	3076	384	512
edge-connexion	1	edge-connexion:1.2.0	2	1024	896	128	768	88	128
mod-notes	1	mod-notes:5.2.0	2	1024	896	128	952	384	512
mod-kb-ebsco-java	1	mod-kb-ebsco-java:4.0.0	2	1024	896	128	768	88	128
mod-login	2	mod-login:7.11.0	2	2048	1792	1024	1024	88	256
mod-organizations-storage	1	mod-organizations-storage:4.7.0	2	1024	896	128	700	88	128
mod-data-export-spring	1	mod-data-export-spring:3.2.0	1	2048	1844	256	1536	384	512
pub-okapi	1	pub-okapi:2023.06.14	2	1024	896	128	768	0	0
mod-eusage-reports	1	mod-eusage-reports:2.1.1	2	1024	896	128	768	88	128

Methodology/Approach

In order to run FYR:

truncate tables with query

Code Block

language	sql
title	Truncate

truncate table [tenant]_mod_organizations_storage.organizations cascade;
truncate table [tenant]_mod_orders_storage.purchase_order cascade;
truncate table [tenant]_mod_invoice_storage.invoices cascade;

Create organization (Vendor) to reuse its id as access provider in the next query which generates needed data set.

Replace FYR id, access provider, fund id, fund name in accordance with FYR ledger info. Also check all instance related fields which should be replaced with actual data. The script prepared to generate needed amount of organizations, orders, po lines, invoices.

Expand

title	Queries to generate data

Code Block

language	sql
title	Generate

CREATE OR REPLACE FUNCTION public.generate_0062_data_for_edifact_export(
scenario_prefix TEXT,
organizations_amount INTEGER,
orders_per_vendor INTEGER,
polines_per_order INTEGER,
pieces_per_order INTEGER
) RETURNS VOID AS
$$
DECLARE
orgName TEXT DEFAULT 'perf_test_vendor';
orgCodePrefix TEXT DEFAULT 'PERF_TEST_ORG';
vendor_id TEXT;
BEGIN
FOR org_counter IN 1..organizations_amount
LOOP
INSERT INTO [tenant]_mod_organizations_storage.organizations (id, jsonb)
VALUES (
public.uuid_generate_v4(),
jsonb_build_object(
'code', concat(orgCodePrefix, '_', scenario_prefix, '_', org_counter),
'erpCode', '12345',
'isVendor', true,
'name', concat(orgCodePrefix, '_', scenario_prefix, '_', org_counter),
'status', 'Active',
'metadata', jsonb_build_object(
'createdDate', '2023-02-08T00:00:00.000+0000',
'createdByUserId', '9f9d1c46-52e1-4bb7-9c6c-56e6bb945c42',
'updatedDate', '2023-02-08T00:00:00.000+0000',
'updatedByUserId', '9f9d1c46-52e1-4bb7-9c6c-56e6bb945c42'
)
)
)
RETURNING id INTO vendor_id;

PERFORM public.generate_0062_orders(orders_per_vendor, polines_per_order, pieces_per_order, vendor_id,1,2);
END LOOP;
END
$$ LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION public.generate_0062_orders(
orders_per_vendor INTEGER,
polines_per_order INTEGER,
pieces_per_order INTEGER,
vendor_id TEXT,
invoices_per_organization INTEGER,
invoicelines_per_invoice INTEGER
) RETURNS VOID AS
$$
DECLARE
order_id TEXT;
poline_id TEXT;
newPoNumber INTEGER;
BEGIN
FOR order_counter IN 1..orders_per_vendor
LOOP
SELECT nextval('[tenant]_mod_orders_storage.po_number') INTO newPoNumber;

INSERT INTO [tenant]_mod_orders_storage.purchase_order (id, jsonb)
VALUES (
public.uuid_generate_v4(),
jsonb_build_object(
'id', public.uuid_generate_v4(),
'notes', jsonb_build_array(),
'acqUnitIds', jsonb_build_array(),
'approved', true,
'reEncumber', true,
'nextPolNumber', 2,
'workflowStatus', 'Pending',
'poNumber', newPoNumber,
'vendor', vendor_id,
'orderType', 'One-Time',
'metadata', jsonb_build_object(
'createdDate', '2024-10-06T00:00:00.000+0000',
'createdByUserId', '9f9d1c46-52e1-4bb7-9c6c-56e6bb945c42',
'updatedDate', '2024-10-06T00:00:00.000+0000',
'updatedByUserId', '9f9d1c46-52e1-4bb7-9c6c-56e6bb945c42'
)
)
)
RETURNING id INTO order_id;

PERFORM public.generate_0062_polines(order_id, polines_per_order, pieces_per_order, newPoNumber, vendor_id);
PERFORM public.generate_0062_invoices(invoices_per_organization, invoicelines_per_invoice, vendor_id, poline_id);
END LOOP;
END
$$ LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION public.generate_0062_polines(
order_id TEXT,
polines_per_order INTEGER,
pieces_per_order INTEGER,
ponumber INTEGER,
vendor_id TEXT
) RETURNS VOID AS
$$
DECLARE
polineNumber TEXT;
holding_id UUID;
currPoNumber INTEGER;
iteration_counter INT := 1;

BEGIN
SELECT id INTO holding_id
FROM [tenant]_mod_inventory_storage.holdings_record 
WHERE permanentlocationid = '9ffb23a9-0e83-4d8e-a70d-ddf44ab67c84' 
AND instanceid = 'b94d2138-bdfc-5dea-bab9-ac99e21b7970'
LIMIT 1;

FOR line_counter IN 1..polines_per_order
LOOP
SELECT currval('[tenant]_mod_orders_storage.po_number') INTO currPoNumber;

INSERT INTO [tenant]_mod_orders_storage.po_line (id, jsonb)
VALUES (
public.uuid_generate_v4(),
jsonb_build_object(
'id', public.uuid_generate_v4(),
'cost', jsonb_build_object(
'currency', 'USD',
'discountType', 'percentage',
'quantityElectronic', 2,
'poLineEstimatedPrice', 4,
'listUnitPriceElectronic', 2
),
'rush', false,
'alerts', jsonb_build_array(),
'claims', jsonb_build_array(),
'source', 'User',
'details', jsonb_build_object(
'productIds', jsonb_build_array(
jsonb_build_object(
'productId', '73121721',
'productIdType', 'c858e4f2-2b6b-4385-842b-60732ee14abb'
)
),
'isAcknowledged', false
),
'edition', '',
'metadata', jsonb_build_object(
'createdDate', '2024-10-06T11:09:59.181Z',
'updatedDate', '2024-10-06T11:10:48.652Z',
'createdByUserId', '9f9d1c46-52e1-4bb7-9c6c-56e6bb945c42',
'updatedByUserId', '9f9d1c46-52e1-4bb7-9c6c-56e6bb945c42'
),
'eresource', jsonb_build_object(
'trial', false,
'activated', false,
'accessProvider', 'c88742c3-dc2f-4589-a7cf-a90694c2a296',
'createInventory', 'Instance, Holding'
),
'isPackage', false,
'locations', jsonb_build_array(
jsonb_build_object(
'quantity', 2,
'locationId', '9ffb23a9-0e83-4d8e-a70d-ddf44ab67c84',
'quantityElectronic', 2
)
),
'publisher', 'Praeger Publishers',
'collection', false,
'instanceId', 'b94d2138-bdfc-5dea-bab9-ac99e21b7970',
'orderFormat', 'Electronic Resource',
'checkinItems', false,
'contributors', jsonb_build_array(
jsonb_build_object(
'contributor', 'Yurchenco, Henrietta',
'contributorNameTypeId', '2b94c631-fca9-4892-a730-03ee529ffe2a'
)
),
'poLineNumber', currPoNumber || '-' || iteration_counter,
'vendorDetail', jsonb_build_object(
'instructions', '',
'vendorAccount', '',
'referenceNumbers', jsonb_build_array()
),
'paymentStatus', 'Pending',
'receiptStatus', 'Pending',
'claimingActive', false,
'reportingCodes', jsonb_build_array(),
'titleOrPackage', '!Hablamos! Puerto Ricans speak / Photos. by Julia Singer.',
'automaticExport', false,
'publicationDate', '[1971]',
'purchaseOrderId', order_id,
'fundDistribution', jsonb_build_array(
jsonb_build_object(
'code', 'FYND',
'value', 100,
'fundId', '8003d427-34a3-4ad4-97cd-c1aae19f2bfc',
'distributionType', 'percentage'
)
),
'acquisitionMethod', '796596c4-62b5-4b64-a2ce-524c747afaa2',
'searchLocationIds', jsonb_build_array(
'9ffb23a9-0e83-4d8e-a70d-ddf44ab67c84'
),
'donorOrganizationIds', jsonb_build_array(),
'checkinItems', true
)
)
RETURNING id INTO polineNumber;
iteration_counter := iteration_counter + 1;

-- Call the function to generate data for titles table
PERFORM public.generate_0062_titles_data(polineNumber, concat(ponumber, '-', line_counter), pieces_per_order);
END LOOP;
END;
$$ LANGUAGE plpgsql;



CREATE OR REPLACE FUNCTION public.generate_0062_titles_data(
po_line_id TEXT,
po_line_number TEXT,
pieces_per_order INTEGER
) RETURNS VOID AS
$$
DECLARE
title_id UUID;
BEGIN
-- Insert data into titles table
INSERT INTO [tenant]_mod_orders_storage.titles (id, jsonb, creation_date, created_by, polineid)
VALUES (
public.uuid_generate_v4(),
jsonb_build_object(
'id', '4945c26f-6cf7-4050-93c1-0a8a25a2f4d7',
'title', '!Hablamos! Puerto Ricans speak / Photos. by Julia Singer.',
'edition', '',
'metadata', jsonb_build_object(
'createdDate', '2024-10-06T11:09:59.247Z',
'updatedDate', '2024-10-06T11:09:59.247Z',
'createdByUserId', '9f9d1c46-52e1-4bb7-9c6c-56e6bb945c42',
'updatedByUserId', '9f9d1c46-52e1-4bb7-9c6c-56e6bb945c42'
),
'poLineId', po_line_id,
'publisher', 'Praeger Publishers',
'acqUnitIds', jsonb_build_array(),
'instanceId', 'b94d2138-bdfc-5dea-bab9-ac99e21b7970',
'productIds', jsonb_build_array(
jsonb_build_object(
'productId', '73121721',
'productIdType', 'c858e4f2-2b6b-4385-842b-60732ee14abb'
)
),
'contributors', jsonb_build_array(
jsonb_build_object(
'contributor', 'Yurchenco, Henrietta',
'contributorNameTypeId', '2b94c631-fca9-4892-a730-03ee529ffe2a'
)
),
'poLineNumber', po_line_number,
'publishedDate', '[1971]',
'claimingActive', false,
'isAcknowledged', false
),
current_timestamp, -- Assuming creation date is the current timestamp
'created_by_user_id', -- Replace with the actual user ID
po_line_id::uuid
)
RETURNING id INTO title_id;

-- Call the function to generate data for pieces table
PERFORM public.generate_0062_pieces_data(title_id, po_line_id, pieces_per_order);
END
$$ LANGUAGE plpgsql;


CREATE OR REPLACE FUNCTION public.generate_0062_pieces_data(
title_id UUID,
polineNumber TEXT,
pieces_per_order INTEGER
) RETURNS VOID AS
$$
DECLARE
piece_counter INTEGER;
holding_id UUID;
BEGIN
SELECT id INTO holding_id
FROM [tenant]_mod_inventory_storage.holdings_record 
WHERE permanentlocationid = '9ffb23a9-0e83-4d8e-a70d-ddf44ab67c84' 
AND instanceid = 'b94d2138-bdfc-5dea-bab9-ac99e21b7970'
LIMIT 1;

FOR piece_counter IN 1..pieces_per_order
LOOP
-- Replace the following line with your actual poLineId
INSERT INTO [tenant]_mod_orders_storage.pieces VALUES (
public.uuid_generate_v4(),
jsonb_build_object(
'id', public.uuid_generate_v4(),
'format', 'Electronic',
'titleId', title_id,
'metadata', jsonb_build_object(
'createdDate', '2024-10-06T11:43:04.384Z',
'updatedDate', '2024-10-06T11:43:04.384Z',
'createdByUserId', '9f9d1c46-52e1-4bb7-9c6c-56e6bb945c42',
'updatedByUserId', '9f9d1c46-52e1-4bb7-9c6c-56e6bb945c42'
),
'poLineId', polineNumber,
'holdingId', 'aefd322b-9a32-4cd9-80e0-a5a3f882f2b1',
'copyNumber', piece_counter,
'supplement', true,
'displaySummary', piece_counter,
'receivingStatus', 'Expected',
'displayOnHolding', false,
'discoverySuppress', false,
'statusUpdatedDate', '2024-06-05T11:43:04.385+00:00'
),
NULL,
NULL,
'eb79cb72-0fb5-4773-a580-b1428fa724e9'::UUID, -- Replace with the actual poLineId
title_id
);
END LOOP;
END
$$ LANGUAGE plpgsql;






CREATE OR REPLACE FUNCTION public.generate_0062_invoices(
invoices_per_organization INTEGER,
invoicelines_per_invoice INTEGER,
vendor_id TEXT,
order_id TEXT
) RETURNS VOID AS
$$
DECLARE
invoice_id TEXT;
newInvoiceNumber INTEGER;
BEGIN
FOR invoice_counter IN 1..invoices_per_organization
LOOP
SELECT nextval('[tenant]_mod_invoice_storage.invoice_number') INTO newInvoiceNumber;

INSERT INTO [tenant]_mod_invoice_storage.invoices (id, jsonb)
VALUES (
public.uuid_generate_v4(),
jsonb_build_object(
'id', public.uuid_generate_v4(),
'total', 0.0,
'source', 'User',
'status', 'Approved',
'currency', 'USD',
'metadata', jsonb_build_object(
'createdDate', '2024-10-06T09:07:45.366Z',
'updatedDate', '2024-10-06T09:08:47.954Z',
'createdByUserId', '9f9d1c46-52e1-4bb7-9c6c-56e6bb945c42',
'updatedByUserId', '9f9d1c46-52e1-4bb7-9c6c-56e6bb945c42'
),
'subTotal', 0.0,
'vendorId', vendor_id,
'poNumbers', ARRAY[newInvoiceNumber]::TEXT[],
'acqUnitIds', ARRAY[]::UUID[],
'adjustments', ARRAY[]::JSONB[],
'invoiceDate', '2024-02-27T00:00:00.000+00:00',
'batchGroupId', '2a2cb998-1437-41d1-88ad-01930aaeadd5',
'fiscalYearId', '562bf586-11e9-4c36-98d7-3341042c856c',
'paymentMethod', 'Cash',
'accountingCode', '12345',
'folioInvoiceNo', newInvoiceNumber::TEXT,
'enclosureNeeded', false,
'vendorInvoiceNo', invoice_counter::TEXT,
'adjustmentsTotal', 0.0,
'exportToAccounting', false,
'nextInvoiceLineNumber', 2,
'chkSubscriptionOverlap', true
)
) RETURNING id INTO invoice_id;

PERFORM public.generate_0062_invoicelines(
invoicelines_per_invoice,
invoice_id,
newInvoiceNumber,
vendor_id,
order_id
);
END LOOP;
END
$$ LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION public.generate_0062_invoicelines(
invoicelines_per_invoice INTEGER,
invoice_id TEXT,
newInvoiceNumber INTEGER,
vendor_id TEXT,
order_id TEXT
) RETURNS VOID AS
$$
DECLARE
invoiceline_id TEXT;
BEGIN
FOR invoiceline_counter IN 1..invoicelines_per_invoice
LOOP
INSERT INTO [tenant]_mod_invoice_storage.invoice_lines (id, jsonb)
VALUES (
public.uuid_generate_v4(),
jsonb_build_object(
'id', public.uuid_generate_v4(),
'total', 0.0,
'metadata', jsonb_build_object(
'createdDate', '2024-10-06T09:08:47.393Z',
'updatedDate', '2024-10-06T09:08:47.393Z',
'createdByUserId', '9f9d1c46-52e1-4bb7-9c6c-56e6bb945c42',
'updatedByUserId', '9f9d1c46-52e1-4bb7-9c6c-56e6bb945c42'
),
'poLineId', order_id,
'quantity', 2,
'subTotal', 0.0,
'invoiceId', invoice_id,
'adjustments', ARRAY[]::JSONB[],
'description', 'Its awesome if its working',
'accountNumber', 'libraryorders@library.tam',
'accountingCode', '12345',
'adjustmentsTotal', 0.0,
'referenceNumbers', ARRAY[]::JSONB[],
'fundDistributions', jsonb_build_array(
jsonb_build_object(
'code', 'FYND',
'value', 100.0,
'fundId', '8003d427-34a3-4ad4-97cd-c1aae19f2bfc',
'distributionType', 'percentage'
)
),
'invoiceLineNumber', invoiceline_counter,
'invoiceLineStatus', 'Approved',
'releaseEncumbrance', false
)
) RETURNING id INTO invoiceline_id;

-- You can perform additional actions if needed
END LOOP;
END
$$ LANGUAGE plpgsql;


-- CREATE sample data
-- 1 - amount of organizations to be created
-- 2 - amount of orders per organization
-- 3 - amount of polines per order
-- 4 - amount of pieces per order

SELECT public.generate_0062_data_for_edifact_export('FYNG',1,1,1,1);



-- CLEANUP

To create encumbrances linked to the current budget orders should be with open status. To change the status from pending to open select needed data for the jmeter script. Save to use in the PUT request orders/composite-orders/${po_id}. Run needed number of requests to prepare open orders.

Code Block

title	Data preparation to Open Orders

SELECT id as po_id, jsonb->>'vendor' as vendor_id, jsonb->>'poNumber' as po_number
select count(id)
FROM cs00000int_mod_orders_storage.purchase_order
where jsonb->>'workflowStatus'='Pending'

Code Block

title	BODY DATA

{"id":"${po_id}","approved":true,"notes":[],"poNumber":"${po_number}","orderType":"One-Time","reEncumber":true,"vendor":"${vendor_id}","workflowStatus":"Open","acqUnitIds":[],"needReEncumber":false}

Legacy approach about data preparation instructions can be found at the link: Steps for testing process#Fiscalyearrollover Use this link to get exact number of organizations, orders, POLined, invoices

Set max_locks_per_transaction parameter in DB cluster and instance configurations from default 64 to 1024 to avoid problems with ordersRollover.
Consider using prepared scripts and queries Additional info for testing (scripts, queries) saved in S3 bucket - Buckets/fse-ptf/FYR/
...
- - envs_data_gen_scripts - txt files with sql which populate DB with data
  - qelc2 and qcon jmeter scripts to change status from pending to open

Version	Old Version 12	New Version Current
Changes made by	Roman_Fedynyshyn	Leonid Kolesnykov
Saved on	Nov 14, 2024	Nov 26, 2024

Name	Memory GIB	vCPUs	max_connections
db.r6g.4xlarge	128 GiB	16 vCPUs	4000
db.r6g.xlarge	32 GB	4vCPUs	2000

Page Comparison

Versions Compared

Key

Table of ContentsOverview IN PROGRESS

Summary

Recommendations

Errors

Test Runs and Results

Instance CPU Utilization

Test FY rollover

FY rollover

Service CPU Utilization

Test FY rollover

FY rollover

Memory Utilization

Test FY rollover

FY rollover

DB CPU Utilization

Test FY rollover (qelc2)

Test FY rollover (qcon)

FY rollover (qelc2)

FY rollover (qcon)

DB Connections

Test FY rollover (qelc2)

Test FY rollover (qcon)

FY rollover (qelc2)

FY rollover (qcon)

DB Load

Test FY rollover (qcon)

FY rollover (qcon)

Top SQL

Test FY rollover (qcon)

FY rollover (qcon)

Appendix

Infrastructure

Table of ContentsOverview

Summary

Recommendations & Jiras

Errors

Test Runs and Results

Service CPU Utilization

Test FYR (Eureka)

FYR (Eureka)

Memory Utilization

Test FYR (Eureka)

FYR (Eureka)

DB CPU Utilization

Test FYR (Eureka)

Test FYR (non-Eureka)

FYR (Eureka)

FYR (non-Eureka)

DB Connections

Test FYR (Eureka)

Test FYR (non-Eureka)

FYR (Eureka)

FYR (non-Eureka)

DB Load

Test FY rollover (non-Eureka)

FY rollover

Top SQL

Test FY rollover (non-Eureka)

FY rollover

Appendix

Infrastructure

Methodology/Approach

Methodology/Approach

Table of Contents
Overview IN PROGRESS

Table of Contents
Overview