Endpoint Protection

 View Only
Expand all | Collapse all

Cannot determine the SEPM database schema

Migration User

Migration UserDec 11, 2013 03:34 PM

Migration User

Migration UserDec 11, 2013 03:37 PM

ℬrίαη

ℬrίαηDec 11, 2013 03:38 PM

Migration User

Migration UserDec 12, 2013 11:12 AM

  • 1.  Cannot determine the SEPM database schema

    Posted Dec 11, 2013 03:16 PM

    I am running SEPM 12.1.4 on a Windows Server 2008 R2 machine. I had to do a disaster recovery and reinstall the SEPM. I followed the directions for preparing for disaster recovery. I backed up the database and the disaster recovery file. The SEPM installs fine but I am receiving an error during the Management Server Configuration. In Step Two: Existing Database Parameters I input the Dtatabase name, user name and password. When I click Next I receive the error below.

    12-11-2013 2-11-05 PM.png

     

    Any idea why I would be receiving this error?

     

    Thank you.

     



  • 2.  RE: Cannot determine the SEPM database schema

    Posted Dec 11, 2013 03:32 PM

    Was the previous SEPM install on an older version or was it 12.1.4?

    This new one needs to be on the same version of the one you created the backup from.

     



  • 3.  RE: Cannot determine the SEPM database schema

    Posted Dec 11, 2013 03:34 PM

    The previous SEPM was running 12.1.4.



  • 4.  RE: Cannot determine the SEPM database schema

    Posted Dec 11, 2013 03:37 PM

    Can you try with previous backup once?



  • 5.  RE: Cannot determine the SEPM database schema

    Posted Dec 11, 2013 03:38 PM

    Do you have another backup you can try?



  • 6.  RE: Cannot determine the SEPM database schema

    Posted Dec 11, 2013 03:54 PM

    I've tried with a previous backup and receive the same error. 

    When the Management Server Configuration Wizard runs I am choosing Install an additional management server to an existing site. I should have mentioned before I have two management servers running. The server I had to do disaster recovery on was the primary SEPM. I can choose Install my first site and use an existing Microsoft SQL Server databse but I receive the message The specified database contains user data. Installing a new site will clear all existing data. I do not want to do this because I do not want to clear all existing data.



  • 7.  RE: Cannot determine the SEPM database schema

    Posted Dec 11, 2013 04:20 PM

    You have to chose  Install my first site option only. Since you freshly installed it and the current database do not have any data, you can safely click ok to the message "The specified database contains user data. Installing a new site will clear all existing data".



  • 8.  RE: Cannot determine the SEPM database schema

    Posted Dec 11, 2013 04:29 PM

    If I choose Install my first site won't this clear all data from the database? There was data in the database from when I first install SEPM 12.1. I just want to make sure I won't loose any of the policies and group structure I had setup in the SEPM.



  • 9.  RE: Cannot determine the SEPM database schema

    Posted Dec 11, 2013 04:46 PM

    As far as I understand your the scenario is this.

    You have backup of your primary SEPM.

    You have reinstalled SEPM software. So currently there is no data present in the server.

     

    If above is your scenario you can select option to clear all your previous data because

    When you install and configure SEPM, it will create a database. This will have the only information what all you provided during the installation. But your backup will have all data from the fist installation to the backup date. Once you select the option to overwrite, all data which is present in the backup will be restored to the server. So you will not lose any data which is really needed.



  • 10.  RE: Cannot determine the SEPM database schema

    Posted Dec 11, 2013 11:02 PM

    Hi

    Can you check whether there are any remaining instances of previous database

    Regards

     



  • 11.  RE: Cannot determine the SEPM database schema

    Broadcom Employee
    Posted Dec 11, 2013 11:13 PM

    have you restored the DB? how did you do that?



  • 12.  RE: Cannot determine the SEPM database schema

    Posted Dec 12, 2013 10:52 AM

    I cleared all previous data. Now when I do a restore of the database I receive the error below.

    12-12-2013 9-50-51 AM.png

    I have tried different backup files from the Server Private Key Backup folder.



  • 13.  RE: Cannot determine the SEPM database schema

    Posted Dec 12, 2013 11:11 AM

    Hello,

    did you backup the DB by using the SEPM DB backup wizard?



  • 14.  RE: Cannot determine the SEPM database schema

    Posted Dec 12, 2013 11:12 AM

    they were 2 SEPMs and 1 SQL DB, correct?



  • 15.  RE: Cannot determine the SEPM database schema

    Posted Dec 12, 2013 11:13 AM

    Yes. I followed the Preparing for disaster recovery steps.



  • 16.  RE: Cannot determine the SEPM database schema

    Posted Dec 12, 2013 11:20 AM

    Yes, that is correct. I have two SEPMs, one primary, one secondary, no replication. They are connected to one database.



  • 17.  RE: Cannot determine the SEPM database schema
    Best Answer

    Posted Dec 13, 2013 05:53 AM

    I agree with you that it was enough to "add a SEPM to an existing site", no need to reset the DB and then restore it again when the issue were isolated to a single SEPM (was the other SEPM still working, right?).

    Just one minor note about the terminology you use here, in such architecture there's no primary or secondary SEPM, you may call them in such way for your convenience and based on how you use them but it is not technically relevant.

    Coming back to your issue, at this point you should contact the Technical Support to get more advanced troubleshooting.



  • 18.  RE: Cannot determine the SEPM database schema

    Posted Dec 13, 2013 09:41 AM

    I am unable to log into the other SEPM. When I try to log into the other SEPM I receive the error Failed to connect to the server. I can log into SEPM I reinstalled but all the policies, grouping structure and settings I configured before are all gone. When I go to Admin > Servers I only see one SEPM listed, which is the one I reinstalled SEPM on. I do not see an option to add the other SEPM. 



  • 19.  RE: Cannot determine the SEPM database schema

    Posted Dec 13, 2013 02:11 PM

    Hello, 

    Have you tried repairing option of not please do a repair and keep posted.

    Regards

    Ajin

     



  • 20.  RE: Cannot determine the SEPM database schema

    Posted Dec 16, 2013 06:31 AM

    Hello,

     

    sorry for the delay, I was not connected.

    The option to add another SEPM is offered during the installation o a new SEPM.

    I am sorry you lost your data, you should be able to restore them from the DB backup.

    If you are still in troubles, please, submit a ticket to our support service.