Issues by updating the Databas shema from 12.1.1 to RU2 now
Created: 16 Nov 2012 | 9 comments
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??
(
Discussion Filed Under:
Comments 9 Comments • Jump to latest comment
can you pass on upgrade.log?
Cheers!
Pete
Help Link: http://www.symantec.com/business/support/overview.jsp?pid=54619
Here you are (see attachment)
check if this helps
https://www.symantec.com/business/support/index?page=content&pmv=print&impressions=&viewlocale=&id=TECH132660
Cheers!
Pete
Help Link: http://www.symantec.com/business/support/overview.jsp?pid=54619
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!
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....
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.
Have you followed the link provided by Pete ?
It will help you....
Regards
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!
filegroups ?
What do you mean by that ?
Dushan Gomez
IT Manager
VCP 4 and 5 | MCITP Exchange Server | MCTS SharePoint Server | MCP Windows XP
Would you like to reply?
Login or Register to post your comment.