The report manager initialization is hung at Truncated table spmtest

Document ID : KB000007342
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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

 

Rpmgr.png

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:

terminate.png

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

 Capture.JPG

  • From Command Prompt, run the below:

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

  • Type exit to logout as below:

truncate.png

  • Now, restart the Report Manager initialization process:

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

last.png

Additional Information:

How to initialize the Spectrum Report Manager (SRM) database:

https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC538223.html