SSdbload: The -load flag may not be used with -catalog or -models.

[sudheerreddy524]

Hi,

 

Getting below options while running below command. what i need to do? 

is below command is correct?

 

[geetika@IXXXXP SS]$ ../SS-Tools/SSdbload -il -m ../SS-DB-Backup/db_20171211_1501.SSdb
SSdbload: The -load flag may not be used with -catalog or -models.

Usage: SSdbload [-quiet] [-initialize] [-developer <DEV_INFO_FILE>]
[-load] [-models] [-catalog] [-replace <PRECEDENCE>]
[-add <PRECEDENCE>] [-port <PORT_NO>] [-showmap]
[-version] [-extension] [-new_primary <HOST_NAME>]
[-UpgradeFrom <ENCODING_NAME>] [-TestEncoding]
[<SAVE_FILE>]

Options/Arguments:

-quiet disable interactive mode
-initialize initialize the database
-developer <DEV_INFO_FILE> load specified developer info
file
-load load all objects from SAVE_FILE
-models load models from SAVE_FILE
-catalog load modeling catalog
-replace <PRECEDENCE> replace landscape map entry
-add <PRECEDENCE> add landscape map entry
-port <PORT_NO> port number for landscape map
entry
-showmap print landscape map info
-version print database version
-extension disable file extension enforcing
-new_primary <HOST_NAME> set local landscape model name
-UpgradeFrom <ENCODING_NAME> Name of the Encoding used to
store non-UTF8 data in
SpectroServer DB
-TestEncoding Check if there are attribute
values that are not in UTF-8
encoding
<SAVE_FILE> file from which to load

[Silvio Okamoto]

Hello,

 

You cannot supply "-l" (-load) with "-m" (models) options/arguments.

Because the -l (-load) will load all objects (models and catalog) from SAVE_FILE. And -m (-models) will load only models from SAVE_FILE.

 

-load (load all objects from SAVE_FILE)

-models (load models from SAVE_FILE)

-catalog (load modeling catalog)

 

Here same examples of SSdbload:

run: ../SS-Tools/SSdbload -c db_<date>_<time>.SSdb (to load only catalog)
run: ../SS-Tools/SSdbload -c legacy.SSdb (to load the legacy database)
run: ../SS-Tools/SSdbload -i -c legacy.SSdb (to load the legacy database)
run: ../SS-Tools/SSdbload -i (initialize the SSdb database)

run: ../SS-Tools/SSdbload -il -r 20 dbsave

run: ../SS-Tools/SSdbload -m db_<date>_<time>.SSdb (to load only models)

run: ../SS-Tools/SSdbload -cm db_<date>_<time>.SSdb (to load both catalog and models)

 

Thanks,

Silvio

[sudheerreddy524]

HI,

 

My SSDB is crashed so Spectrum in not getting started. 

 

for this we  initialize the database to the legacy:

../SS-Tools/SSdbload -il legacy.SSdb (sucessfully)

 

After this try to load the last good know SSDB backup. For this i tried below command getting error

[geetika@IXXXXXP SS]$ ../SS-Tools/SSdbload -il ../usr/Spectrum/SS-DB-Backup/db_20171211_1501.SSdb
SPC-DBS-20081: Error: Unable to open specified save file: ../usr/Spectrum/SS-DB-Backup/db_20171211_1501.SSdb

 

please give me complete command for my SSDB below is the file name 

db_20171211_1501.SSdb

[Silvio Okamoto]

Here are the examples you have requested:

 

To initialize and load all objects (models and catalog) from the db_20171211_1501.SSdb file:

[geetika@IXXXXP SS]$ ../SS-Tools/SSdbload -il ../SS-DB-Backup/db_20171211_1501.SSdb

 

To load only models from the db_20171211_1501.SSdb file:

[geetika@IXXXXP SS]$ ../SS-Tools/SSdbload -m ../SS-DB-Backup/db_20171211_1501.SSdb

 

To load only catalog from the db_20171211_1501.SSdb file:

[geetika@IXXXXP SS]$ ../SS-Tools/SSdbload -c ../SS-DB-Backup/db_20171211_1501.SSdb

 

Take a look at the CA Spectrum Database Maintenance guide:

SpectroSERVER Database Maintenance - CA Spectrum - 10.2 to 10.2.2 - CA Technologies Documentation 

 

Thanks,

Silvio

[sudheerreddy524]

HI,

 

My SSDB is crashed so Spectrum in not getting started. 

 

for this we  initialize the database to the legacy:

../SS-Tools/SSdbload -il legacy.SSdb (sucessfully)

 

After this try to load the last good know SSDB backup. For this i tried below command getting error

[geetika@IXXXXXP SS]$ ../SS-Tools/SSdbload -il ../usr/Spectrum/SS-DB-Backup/db_20171211_1501.SSdb
SPC-DBS-20081: Error: Unable to open specified save file: ../usr/Spectrum/SS-DB-Backup/db_20171211_1501.SSdb

 

getting this error.

[Silvio Okamoto]

Why are you using this syntax? 

[geetika@IXXXXXP SS]$ ../SS-Tools/SSdbload -il ../usr/Spectrum/SS-DB-Backup/db_20171211_1501.SSdb

 

What I have suggested was:

[geetika@IXXXXXP SS]$ ../SS-Tools/SSdbload -il ../SS-DB-Backup/db_20171211_1501.SSdb

 

Is the "geetika" account the CA Spectrum Install Owner Account? You can check in the $SPECROOT/.installrc file.

Does the "geetika" account have the privilege/permission to open the /usr/Spectrum/SS-DB-Backup/db_20171211_1501.SSdb file? 

What happens if you copy the /usr/Spectrum/SS-DB-Backup/db_20171211_1501.SSdb file to /usr/Spectrum/SS folder and the run this syntax? ../SS-Tools/SSdbload -il db_20171211_1501.SSdb

 

Thanks,

Silvio

 

[sudheerreddy524]

Hi,

First We need to copy SSDB file to usr/Spectrum/SS folder? After copying this file we need to run that syntax ?

After copying 

[geetika@IXXXXP SS]$ ../SS-Tools/SSdbload -il db_20171211_1501.SSdb
SPC-DBS-23007: This save file cannot be loaded by version 10.2.0.000 of Spectrum.
It was saved as version loaded landscape address {0} .

 

[geetika@IXXXXP SS]$ ../SS-Tools/SSdbload -il ../SS-DB-Backup/db_20171211_1501.SSdb
SPC-DBS-23007: This save file cannot be loaded by version 10.2.0.000 of Spectrum.
It was saved as version loaded landscape address {0} .

 

Is the "geetika" account the CA Spectrum Install Owner Account? You can check in the $SPECROOT/.installrc file.

yes.

Does the "geetika" account have the privilege/permission to open the /usr/Spectrum/SS-DB-Backup/db_20171211_1501.SSdb file? 

yes.

[Silvio Okamoto]

Now the error message is much clear.

SPC-DBS-23007: This save file cannot be loaded by version 10.2.0.000 of Spectrum.
It was saved as version loaded landscape address {0} .

 

The db_20171211_1501.SSdb backup file can only be restored in CA Spectrum 10.2.0 release.

You can check the CA Spectrum release in $SPECROOT/Install-Tools/.history file.

 

Do you know in which CA Spectrum release the db_20171211_1501.SSdb backup file was generated?

 

Have you performed a CA Spectrum upgrade or downgrade recently?

 

Maybe the db_20171211_1501.SSdb backup file is corrupted. Have you tried loading from a previous backup file?

 

Please read this community thread, it may help:

Spectrum previously-saved good database not present 

 

Thanks,

Silvio

[sudheerreddy524]

Version we are having 10.2.0.0.245 10/13/2017 17:20

 done this successfully. Next what we need to do? by manually we need to rediscover the devices again, recreate watch, etc.?

./SS-Tools/SSdbload -il legacy.SSdb   

The specified save file: legacy.SSdb ,
was created with the following options:
-c (catalog)

***Warning***

You have chosen the '-i' option. This option is used to initialize
the database. This means ALL data in the database will be deleted. If
you choose to continue with this option, you must be prepared to load
your modeling catalog (model types and relations), before starting the
SpectroSERVER.

Do you really want to initialize the database? (Y or N): Y

Initializing database...

Reading new catalog from legacy.SSdb ...
Number of model types read : 6,278
Number of relations read : 250

Validating new catalog...

Writing new catalog to the database.
Please be patient...

 

SSdbload completed successfully.

[Silvio Okamoto]

Hello,

 

If you are not able to restore the SSdb from any backup file located in the SS-DB-Backup directory, and this CA Spectrum is not an upgraded from a previous release, you will have to initialize to legacy and then rediscover all models and recreate the watches.