Endpoint Protection

 View Only

  • 1.  Issues by updating the Databas shema from 12.1.1 to RU2 now

    Posted Nov 16, 2012 03:46 AM

    Hello Team,

    I am running serveral SEPM Version 12.1.1000.157.

    I just have started to upgrade the Testcenter server and an error occurs at the first server with an external DB:

    2012-11-16 09:31:25.920 THREAD 28 SEVERE: SQL Exception:
    2012-11-16 09:31:25.920 THREAD 28 SEVERE: SQL Command:   IF NOT EXISTS [..]--> shortened
    2012-11-16 09:31:25.920 THREAD 28 SEVERE: SQLState:  S1000
    2012-11-16 09:31:25.920 THREAD 28 SEVERE: Message:  Invalid filegroup 'FG_INDEX' specified.
    2012-11-16 09:31:25.920 THREAD 28 SEVERE: Vendor:  1921
    2012-11-16 09:31:25.920 THREAD 28 SEVERE: java.sql.SQLException: Invalid filegroup 'FG_INDEX' specified.

     

    Has anybody the same issue??

    (



  • 2.  RE: Issues by updating the Databas shema from 12.1.1 to RU2 now

    Broadcom Employee
    Posted Nov 16, 2012 03:55 AM

    can you pass on upgrade.log?



  • 3.  RE: Issues by updating the Databas shema from 12.1.1 to RU2 now

    Broadcom Employee


  • 4.  RE: Issues by updating the Databas shema from 12.1.1 to RU2 now

    Posted Nov 16, 2012 04:21 AM

    nonono!!

     

    I am not going to delete my database!!!

    Crazy idea!

    It happened during the upgrate from SEp12.1 to 12.1.2 RU2. So of corse a DB called SEM5 exists.

    Any other idea? Is it possible that I have insufficient rights at the external DB? It is hosted by the db team. but usually they do not touch the given rights from useres.

     

    Thank you!



  • 5.  RE: Issues by updating the Databas shema from 12.1.1 to RU2 now

    Posted Nov 16, 2012 04:28 AM
      |   view attached

    Here you are (see attachment)

     

     

    Attachment(s)

    zip
    Upgrade-0.zip   2 KB 1 version


  • 6.  RE: Issues by updating the Databas shema from 12.1.1 to RU2 now

    Posted Nov 16, 2012 07:23 AM

    More info:

     

    It seems that during the upgrade a table called "SE_COMPLIANCE_CRITIERIA_2" will be set up, but the filegroup "FG_INDEX" is not existing. We just have "PRIMARY" as filegroup.

     

    Hm. I do not know what to do....



  • 7.  RE: Issues by updating the Databas shema from 12.1.1 to RU2 now

    Posted Nov 19, 2012 04:38 AM

    Hello to all.

    Does anyone have an idea what to do now? Currently I have a non working upgraded SEP Manager and an old SEP manager that is able to use the old database. 

     

    But now I am sure not to try the upgrade in the production area.

    Sorry.



  • 8.  RE: Issues by updating the Databas shema from 12.1.1 to RU2 now

    Posted Nov 19, 2012 07:13 AM

    Have you followed the link provided by Pete ?

     

    It will help you....

     

    Regards

     



  • 9.  RE: Issues by updating the Databas shema from 12.1.1 to RU2 now

    Posted Nov 20, 2012 10:19 AM

    Hi,

     

    Finally I was able to fix this issue!!!
    It seems that our database admins changed the file groups. I do not know why but they did it. This lead to one single database file and one log file.

    Now we have installed a clean SEPM and added the filegroups and files manually to the database server.

    But my admins told me that of corse they never changed anything.. :-)

     

    Thanks to everyone!



  • 10.  RE: Issues by updating the Databas shema from 12.1.1 to RU2 now

    Posted Nov 21, 2012 12:29 AM

    filegroups ?

    What do you mean by that ?