That is bug of intra-mart AccelPlatfrom.
We apologize for any inconvenience.
This event happens only following versions.
・intra-mart AccelPlatfrom 2014 Spring(Granada)
・intra-mart AccelPlatfrom 2014 Summer(Honoka)
The patch that solves this event is provided, so please apply it.
----------------
□ Requirement[4787] many existence check SQL of im_schema_update table are executed
https://issue.intra-mart.jp/issues/4787
----------------
[Symptom]
Many existence check SQL of im_schema_update table are executed
[Cause]
This event happens only following versions.
・intra-mart AccelPlatfrom 2014 Spring(Granada)
・intra-mart AccelPlatfrom 2014 Summer(Honoka)
When authorization inquiries are received, we will confirm whether there is im_schema_update table or not before confirming tenant environmental set up already finished or not.
Set up state is a specification for caching but this implementation has a bug and there are some cases that is not cached.
There are two ways for function that inquiries set up state.
1. Check if set up for “all module” are completed
-> Use for set up screen of system management.
2. Check if set up for “specific module” and all module which it depends are completed
-> Use for access context or API for each function.
For intra-mart AccelPlatfrom 2014 Spring (Granada) and 2014 Summer (Honoka), set up state was not cached correctly for second inquiry above.
Also, because each function check set up with almost second inquiry above the SQL above issued and performance deterioration might have happened.
[Handling contents]
We modified set up status to cache correctly.
[Target patch]
・ im_import_export-8.0.7-PATCH001
・ im_import_export-8.0.8-PATCH001
-- Target ------------------------------------------------------------------------
iAP/Accel Platform/2014 Spring(Granada)
iAP/Accel Platform/2014 Summer(Honoka)
--------------------------------------------------------------------------------
FAQID:474
Many existence check SQL of im_schema_update table are executed and performance deteriorates.
