After upgrading to Spectrum 10.0 errors are seen during the Spectrum Report Manager (SRM) table conversions to InnoDB.
The error halts the conversions and prevents SRM from starting up.
Error seen when trying to access SRM could be "SRM has not finished starting."
This is caused by large inserts from one table to another.
CA's process to perform the conversion includes creating a temporary table and insert from the older table into the newer temporary table.
During this process, a large INSERT is performed causing this 1206 error.
The fix for this issue is to adjust the settings in my $SPECROOT/MySQL/my-spectrum.cnf file to allow more memory usage.
This may need to be adjusted a couple of times before we can get past this error.
Default value is 256MB. However, since Spectrum is generally installed on a dedicated server with plenty of resources this setting could be set much higher.
According to Oracle, this could be set to 80% of the total physical memory on that system.
Please keep performance in mind if this server also has a SpectroSERVER installed on it. If SpectroSERVER is installed, we do not suggest 80% of physical memory.
If adjusting this setting to a higher value does not help, please contact CA Support.