Spectrum Report Manager not working after update to 23.3.10

Products

• DX NetOps
• CA Spectrum

Issue/Introduction

After upgrade to 23.3.10 SRM does not work any more.

stdout.log shows following error:

2024-10-10 11:22:16,486 [SRM/Startup/Container] WARN  org.springframework.web.context.support.XmlWebApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'SRM/Quartz-TimerFactory' defined in ServletContext resource [/WEB-INF/repmgr/config/container/scheduling.xml]: Cannot resolve reference to bean 'ssVersionCheckTaskTrigger' while setting bean property 'triggers' with key [15]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ssVersionCheckTaskTrigger' defined in ServletContext resource [/WEB-INF/repmgr/config/container/scheduling.xml]: Cannot resolve reference to bean 'ssVersionCheckTask' while setting bean property 'jobDetail'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ssVersionCheckTask' defined in ServletContext resource [/WEB-INF/repmgr/config/container/scheduling.xml]: Cannot resolve reference to bean 'domainListener' while setting bean property 'targetObject'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'domainListener': Unsatisfied dependency expressed through field 'entityResolver'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityResolver': Invocation of init method failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT im.landscape_h, im.model_key, im.model_name, im.MAC, im.IP, im.create_time FROM modelclass mc, interfacemodel im LEFT OUTER JOIN entitymodel em ON im.model_key=em.model_key WHERE im.destroy_time is null AND em.entity_id is null AND im.model_class=mc.model_class ORDER BY im.model_name]; SQL state [HY000]; error code [2]; Error reading file 'd:\oneclick\mysql\tmp\MYbzmaxg0q9q1zy8m6' (OS errno 12 - Not enough space); nested exception is java.sql.SQLException: Error reading file 'd:\oneclick\mysql\tmp\MYbzmaxg0q9q1zy8m6' (OS errno 12 - Not enough space)

Environment

SRM 23.3.10 running on Windows and most probably others but not seen at this point

Cause

Memory related problems.

Resolution

Check and adjust OneClickService.conf file and 

jvm_opt=-Xms
jvm_opt=-Xmx

values.