Hello,
After upgrade from RHEL7.2+Spectrum22.2.6 to RHEL9.5+Spectrum24.3.9, SRM does not invoke.
We can see the message "... SchemaChangeException: SPC-OCA-10067 ..." in catarina.out file.
Please refer the following for details.
https://knowledge.broadcom.com/external/article/131805/srm-has-not-finished-starting-after-upgr.html
SRM has not finished starting after upgrading to version 10.3.2
... SchemaChangeException: SPC-OCA-10067: Error occurred while ...
Q1. Has the defect DE412925, which is described in the above Kb, been fixed in Spectrum24.3.9?
https://knowledge.broadcom.com/external/article?articleNumber=128028
SRM has not finished starting - schema 2014 failed
... SchemaChangeException: SPC-OCA-10067: Error occurred while ...
Q2. Can the resolution in the Kb 128028 solve our issue?
Q3. Is there any other resolution for out issue?
- Product: Spectrum 24.3.9
- OS: RHEL 9.5
- Upgrade flow: RHEL7.2+Spectrum22.2.6 -> upgrade only RHEL to 7.9 -> upgrade RHEL to 8.10, and Spectrum to 24.3.9 after the RHEL upgrade -> upgrade RHEL to 9.5.
- issue:
The error message "SRMが起動していません" (SRM has not been invoked) is displayed after a click to [ReportManager] in OneClick.
- The Log catarina.out
2025-06-16 15:37:19,219 [SRM/Startup/Container] ERROR com.aprisma.spectrum.app.web.db.schemachange.SchemaChangeUpdater - Error occurred while applying schema change
Name: 1025 (Product version: 9.2.0) - Create the reporting_api schema, and maintain the srmapi user.
com.aprisma.spectrum.app.web.db.schemachange.FatalSchemaChangeException: com.aprisma.spectrum.app.web.db.schemachange.SchemaChangeException: SPC-OCA-10067: スキーマ変更スクリプトを実行中にエラーが発生
しました。スクリプト: /usr/Spectrum/Install-Tools/rpmgr/sql/srmdbapi/ddl/create_reporting_api_database.sql
at com.aprisma.spectrum.app.web.db.schemachange.BaseSchemaChange.applySchemaChange(BaseSchemaChange.java:194) ~[websrv.jar:?]
at com.aprisma.spectrum.app.web.db.schemachange.SchemaChangeUpdater.applySchemaChange(SchemaChangeUpdater.java:96) ~[websrv.jar:?]
at com.aprisma.spectrum.app.web.db.schemachange.SchemaChangeUpdater.doApplyChanges(SchemaChangeUpdater.java:202) ~[websrv.jar:?]
at com.aprisma.spectrum.app.web.db.schemachange.SchemaChangeUpdater.applyChanges(SchemaChangeUpdater.java:143) ~[websrv.jar:?]
at com.aprisma.spectrum.app.web.db.schemachange.BaseSchemaChangeManager.runUpdater(BaseSchemaChangeManager.java:195) ~[websrv.jar:?]
at com.aprisma.spectrum.app.web.db.schemachange.BaseSchemaChangeManager.applyChanges(BaseSchemaChangeManager.java:149) ~[websrv.jar:?]
at com.aprisma.spectrum.app.repmgr.dc.db.changes.SRMSchemaChangeRunner.runChanges(SRMSchemaChangeRunner.java:53) ~[rpmgr.jar:?]
at com.aprisma.spectrum.app.repmgr.dc.db.ReportManagerInitializer.init(ReportManagerInitializer.java:74) ~[rpmgr.jar:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
...
screenshot for the SRM error
Regards,
MARUBUN