Why did the CA Spectrum model the device twice?

Document ID : KB000115155
Last Modified Date : 19/09/2018
Show Technical Document Details
Question:
Why did the CA Spectrum model the device twice?

In the events, the device was created twice.

21/08/2018 16h8min59s BRT 
A model has been created. The model is XXXXXX of type Pingable created by spectrum@oneclick. 

23/08/2018 17h39min25s BRT 
A model has been created. The model is XXXXXX of type Pingable created by servicedesk@oneclick. 
 
Environment:
CA Spectrum
Answer:
After the XXXXXX Pingable was modeled in Spectrum SSdb, a restore was performed and the db_20180820_2100.SSdb copy was restored. Then when the XXXXXX was modeled again, Spectrum used the same model handle. That is the reason we see inconsistent entries in the event table.

https://docops.ca.com/ca-spectrum/10-2-3/en/administrating/database-management/ddm-database-maintenance/database-backup 

Note: The DDM and SpectroSERVER databases can fall out of synchronization when you restore one without restoring the other. For example, you back up both databases on Sunday. You create a model on Monday, then experience a system crash and restore your SS database with the Sunday save file. The restored SS database no longer includes the model that you created, but historical records for that model are in the DDM database. Moreover, if you recreate the model, you cannot then reconcile the DDM records from the original model with the new records that were generated for the recreated model. Avoid this kind of conflict by always restoring the DDM database whenever you restore the SpectroSERVER database.