Spectroserver disconnects abruptly

Document ID : KB000095477
Last Modified Date : 11/05/2018
Show Technical Document Details
Issue:
SpectroSERVER would crash occasionally in Spectrum 10.2.x. Every time when it crashed, need to restore SSDB and restart SpectroSERVER. 

STACK_TEXT:
0000006e`5987eb08 00007ff9`a3936e34 : 0000006f`16897838 0000006f`16897820 00000000`00000000 00000000`00000000 : libGlobl!Cs_unpack_ulong+0x18 [d:\spectrum\10.02.03\cm\windows\10.02.03.00.107\globl.a\src\cspack.cc @ 284] 
0000006e`5987eb10 00007ff9`a3945f69 : 0000006e`d1de8a90 00007ff9`a54e859d 0000006e`d1de8a90 0000006f`16017db0 : libVPapi!CsAttrDesc::CsAttrType_e::CsAttrType_e+0x18 [d:\spectrum\10.02.03\cm\windows\10.02.03.00.107\vpapi.a\src\csattrdesc.cc @ 453] 
0000006e`5987eb40 00007ff9`9ca245d4 : 0000006f`16897348 0000006e`d1de8a90 0000006f`16897348 00000000`00000000 : libVPapi!CsAttrValRsp::CsAttrValRsp+0x51 [d:\spectrum\10.02.03\cm\windows\10.02.03.00.107\vpapi.a\src\csavalrsp.cc @ 241] 
0000006e`5987eb80 00007ff9`9cc5965b : 0000006f`1b1b0001 0000006f`16897348 00000000`00000001 0000006e`cdee0340 : libssdbl!CsBaseAlarmIf::get_global_alarm+0x158 [d:\spectrum\10.02.03\cm\windows\10.02.03.00.107\ssdbl.a\baseif\src\csbsalarm.cc @ 392] 
0000006e`5987ebe0 00007ff9`9cc3ebc6 : 0000006e`cdee0340 0000006e`cdee0340 00000000`00012a70 0000006e`5276f7c0 : libgas!CsPersistentAlarmService::update_alarm+0xb7 [d:\spectrum\10.02.03\cm\windows\10.02.03.00.107\gas.a\managers\src\cspstalserv.cc @ 987] 
0000006e`5987ec50 00007ff9`9cc3d9ca : 00000000`00000000 0000006e`cdee0340 0000006e`52973c78 00007ff9`a4696882 : libgas!CsLocalAlarmTable::notify_clients_of_change+0x25a [d:\spectrum\10.02.03\cm\windows\10.02.03.00.107\gas.a\managers\src\cslalarmt.cc @ 666] 
0000006e`5987ed40 00007ff9`9cc4f955 : 0000006e`8d72cb00 00007ff9`a39687bc 0000006e`ee648858 0000006e`166c95e0 : libgas!CsLocalAlarmTable::change+0x2e2 [d:\spectrum\10.02.03\cm\windows\10.02.03.00.107\gas.a\managers\src\cslalarmt.cc @ 458] 
0000006e`5987ed90 00007ff9`9cc40039 : 0000006f`16017c00 00007ff9`a46bdf14 0000006e`8d72cb00 0000006e`a019d018 : libgas!CsModelAlarmService::write_attributes+0x3d [d:\spectrum\10.02.03\cm\windows\10.02.03.00.107\gas.a\managers\src\csmdlalserv.cc @ 5695] 
0000006e`5987edc0 00007ff9`9cc2bfb3 : 0000006f`16017c00 0000006e`ee648858 0000006e`166c95e0 0000006e`00000003 : libgas!CsMASIf::write_attributes+0x15 [d:\spectrum\10.02.03\cm\windows\10.02.03.00.107\gas.a\managers\src\csmasif.cc @ 1010] 
0000006e`5987edf0 00007ff9`9cc2876a : 0000006e`ce045c00 0000006e`f6f042b0 0000006e`5987ef10 0000006e`ee648858 : libgas!AlarmSymptomService::write_list_to_alarm+0xeb
[d:\spectrum\10.02.03\cm\windows\10.02.03.00.107\gas.a\managers\src\alarmsymptomservice.cc @ 2058] 
0000006e`5987ee50 00007ff9`9b0c9d89 : 0000006e`f6f04288 0000006e`5987ef30 00000000`00000000 00007ff9`9cd174fe : libgas!AlarmSymptomService::add_event_symptom+0xae [d:\spectrum\10.02.03\cm\windows\10.02.03.00.107\gas.a\managers\src\alarmsymptomservice.cc @ 1030] 
0000006e`5987eec0 00007ff9`9b0c9e00 : 0000006e`ed535870 00007ff9`a46968b5 0000006e`7646ea50 0000006e`f6f04288 : libEaccsAdv!CsIHCorr::relateAlarms+0x241 [d:\spectrum\10.02.03\cm\windows\10.02.03.00.107\eaccs.a\src\csihcorr.cc @ 7126] 
0000006e`5987ef60 00007ff9`9b0c49ba : 0000006e`3c3cb601 0000006e`5987f0a0 0000006e`ee648858 0000006e`166c9b20 : libEaccsAdv!CsIHCorr::relateAlarmsGraySetup+0x40 [d:\spectrum\10.02.03\cm\windows\10.02.03.00.107\eaccs.a\src\csihcorr.cc @ 7070] 
0000006e`5987efa0 00007ff9`9b0c8dc8 : 0000006e`3c3cb670 0000006e`0f9c07d8 00000000`00000000 0000006e`0f9c07d8 : libEaccsAdv!CsIHCorr::evaluateCausedBy+0x20e [d:\spectrum\10.02.03\cm\windows\10.02.03.00.107\eaccs.a\src\csihcorr.cc @ 6782] 
0000006e`5987f190 00007ff9`9b0c59bf : 00000000`00000000 0000006e`3c3cb670 0000006f`16c44690 00007ff9`00246d78 : libEaccsAdv!CsIHCorr::processSet+0x104 [d:\spectrum\10.02.03\cm\windows\10.02.03.00.107\eaccs.a\src\csihcorr.cc @ 6163] 
0000006e`5987f2a0 00007ff9`9b0c58d1 : 0000006e`7646ea50 0000006e`0f9c07d8 0000006e`3c3cb670 0000006f`16c440a8 : libEaccsAdv!CsIHCorr::formSet+0x2d3 [d:\spectrum\10.02.03\cm\windows\10.02.03.00.107\eaccs.a\src\csihcorr.cc @ 6075] 
0000006e`5987f370 00007ff9`9b0cb1be : 0000006e`7646ea50 0000006e`0f9c07d8 0000006e`3c3cb670 000000
Environment:
Spectrum 10.2.X
Cause:
There are some corruptions in ssAlarm.db.
Resolution:
1. Stop SpectroServer.

2. Run the commands from Command Prompt.
bash -login 
cd /SS 
../SS-Tools/SSdbload.exe -ic legacy.SSdb 
(This will only initialize the catalog that Legacy database has saved right after you Spectrum was upgraded to the latest version.So this means it will lose the customizations on the catalog from the date that Spectrum was upgraded till now. Please do not initialize legacy database from SCP, because that will load the models as well) 

3. Start SpectroServer, and verify it is running fine from OneClick console. Stop SpectroSERVER.

4. Run the commands from Command Prompt.
bash -login 
cd /SS 
../SS-Tools/SSdbload.exe -m <Latest SSDB backup file> 
(This will load all the models only from the latest SSDB) 

5. Start SpectroServer.