The report manager initialization is hung at Truncated table spmtest

Products

• CA Spectrum

Issue/Introduction

While initializing the Report Manager database, the output hangs at Truncated table spmtest as below:

 

<Please see attached file for image>

Environment

Spectrum running on all supported platforms

Resolution

• Exit the initialization process with the key combinations Ctrl and C, in other words, type the keys Ctrl C together
• Type y and hit the Enter key when prompted Terminate batch job (Y/N)? as below:

<Please see attached file for image>

• From services.msc, restart SPECTRUM MYSQL Database Server service as below:

 

<Please see attached file for image>

• From Command Prompt, run the below:

cd %SPECROOT%/mysql/bin
mysql.exe -uroot -proot reporting
TRUNCATE TABLE event;

• Type exit to logout as below:

<Please see attached file for image>

• Now, restart the Report Manager initialization process:

cd %SPECROOT%/bin 
RpmgrInitializeLandscape.bat root root –initHist 45 –all

<Please see attached file for image>

Additional Information

Reference knowledge document KB000022484 "How to initialize the Spectrum Report Manager (SRM) database." located at https://comm.support.ca.com/kb/How-to-initialize-the-Spectrum-Report-Manager-SRM-database/KB000022484