The report manager initialization is hung at Truncated table spmtest

book

Article ID: 7342

calendar_today

Updated On:

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>

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:

<Please see attached file for image>

terminate.png

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

 

<Please see attached file for image>

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:

<Please see attached file for image>

truncate.png

  • Now, restart the Report Manager initialization process:

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

<Please see attached file for image>

last.png

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

Attachments

1558691523685000007342_sktwi1f5rjvs16gn6.png get_app
1558691522038000007342_sktwi1f5rjvs16gn5.png get_app
1558691520343000007342_sktwi1f5rjvs16gn4.jpeg get_app
1558691518649000007342_sktwi1f5rjvs16gn3.png get_app
1558691515824000007342_sktwi1f5rjvs16gn2.png get_app