Today one of mine colleagues from Helpdesk, asked me why one package hasn't been distributed correctly to some Distribution Points. The <strong>PkgXferMgr.log</strong> said to me that:
There is no existing connection, Win32 error = 67 SMS_PACKAGE_TRANSFER_MANAGER 2013-06-28 02:37:49 9192 (0x23E8)
There is no existing connection, Win32 error = 67 SMS_PACKAGE_TRANSFER_MANAGER 2013-06-28 02:37:49 9192 (0x23E8)
Error during connection to \\DPJAS.DOMAIN.COM\SMS_DP$ (67). SMS_PACKAGE_TRANSFER_MANAGER 2013-06-28 02:37:49 9192 (0x23E8)
Error is considered fatal. SMS_PACKAGE_TRANSFER_MANAGER 2013-06-28 02:37:49 9192 (0x23E8)
Cannot connect to server DPJAS.DOMAIN.COM at remote site DPJAS.DOMAIN.COM, won't try send requests going to site DPJAS.DOMAIN.COM for an hour or until there are no active send requests. SMS_PACKAGE_TRANSFER_MANAGER 2013-06-28 02:37:49 9192 (0x23E8)
Could not establish connection. SMS_PACKAGE_TRANSFER_MANAGER 2013-06-28 02:37:49 9192 (0x23E8)
Attempt to connect failed. SMS_PACKAGE_TRANSFER_MANAGER 2013-06-28 02:37:49 9192 (0x23E8)
Notifying pkgXferJobMgr SMS_PACKAGE_TRANSFER_MANAGER 2013-06-28 02:37:49 9192 (0x23E8)
Sending failed. Failure count = 26, Restart time = 6/28/2013 3:07:49 AM Central European Daylight Time SMS_PACKAGE_TRANSFER_MANAGER 2013-06-28 02:37:49 9192 (0x23E8)
I was astonished because I haven't changed anything, as I logged on DPJAS server it appared that one of my administrator colleague has moved the SMS_DP$ share. Not only moved but moved and forgot to share it again, so it wasn't visible on the network. I turned sharing again, gave proper permissions, and one more time looked in log after redistributing content.
The message I that have received was:
ExecStaticMethod failed (80041013) SMS_DistributionPoint, AddFile SMS_PACKAGE_TRANSFER_MANAGER 2013-07-01 12:19:13 11128 (0x2B78)
CSendFileAction::SendFiles failed; 0x80041013 SMS_PACKAGE_TRANSFER_MANAGER 2013-07-01 12:19:13 11128 (0x2B78)
CSendFileAction::SendFiles failed; 0x80041013 SMS_PACKAGE_TRANSFER_MANAGER 2013-07-01 12:19:13 11128 (0x2B78)
Notifying pkgXferJobMgr SMS_PACKAGE_TRANSFER_MANAGER 2013-07-01 12:19:13 11128 (0x2B78)
Sending failed. Failure count = 1, Restart time = 7/1/2013 12:49:13 PM Central European Daylight Time SMS_PACKAGE_TRANSFER_MANAGER 2013-07-01 12:19:13 11128 (0x2B78)
After about 30 minutes of trying that operation to run on other DPs, I moved that folder to D drive where it was - my colleague moved it to the F drive.
Another redistribution operation, and guess what :) I t was the drive fault! Still do not how could it be as long as the share was visible properly :/
Pokazywanie postów oznaczonych etykietą System Center 2012. Pokaż wszystkie posty
Pokazywanie postów oznaczonych etykietą System Center 2012. Pokaż wszystkie posty
poniedziałek, 1 lipca 2013
niedziela, 7 kwietnia 2013
[SOLVED] – A management group with the same name (xxxx) is already registerted to data warehouse management group “xxxx”
Hi all,
Recently I had a problem. The Data Warehouse server [SCDW] has detached from my Service Manager server [SCSM]. Without any reason :/
I have read in the Internet to unregister it and register again - "Wow, seems to be easy as pie" - I though, I have unregistered it, but trying to register it once again I have received an error:
"A management group with the same name (xxxx) is already registerted to data warehouse management group "xxxx"
Shit, what to do now?! Not many articles were written about it in the Internet, In fact, I have found just one:
http://social.technet.microsoft.com/Forums/en-US/systemcenterservicemanager/thread/4dc5cac4-49c3-4d10-ad0d-6b0bb4a4a2f2
The Unregister-SCDWSource didn't worked for me - because It has been already unregistered. The hope seems to be one powershell command:
Remove-SCDWMgmtGroup...
But it does not persist in System Center 2012, it was in 2012 version.
So the only hope was from one guy that has been dealing with it in test environment, and resolved by removing 3 records from database:
SELECT *
FROM [DWStagingAndConfig].[dbo].[MT_Microsoft$SystemCenter$ResourceAccessLayer$SdkResourceStore]
GO
I have tried that command, saw the records and deleted them, and guess what? The SCDW wizzard has moved!.. BUT! at the last page, where "create" button is, I have received an error:
"Data source is already registered with the datawarehouse"
So the same error that one guy wrote on that froum.
So, still shit. maybe even bigger, so I went back to the snapshot, and tried to fight it without modyfying the database.
I made up final decision to uninstall the SCDW server. But still I wasn't sure it would help, but no risk no fun.
After removing it, I started the installation wizzard.
I was considering to install it with the old database's names, or give new ones. The second choice was better, in fact, if I would left the old names, the field with management group was grayed out, so basically I don't think that would help with "A group is in use..." problem, because I would use the same group during registering, and I wanted to change that group name. The wizzard made it for me - for each database name it added "_1", so I simply accepted it.
From last time I remembered that the SCDW installation process it is easy as pie, so I was very astonished when on "Configure Analysis Services for OLAP cubes" I have received error "A server in unavailable" - "what the hack" - the wizzard has perfectly worked with databases in previous steps - as wrote, it discovered that I have done it before and databases persists - it has added the "_1" sign after each DB name. Why it cannot connect to DB server in this step?!
First thought was to checked the Analysis Service on my SQL server - a good old service restart :) but it didn't helped, so maybe the permissions? I have changed the user on which I was installing the SCDW server (those fields where you give username and password in wizzard), but no luck.
With a help of that post:
http://social.technet.microsoft.com/Forums/en-US/setup/thread/33c307a7-5ad9-430b-939c-bf3931495677/
I have discovered the log file, and guess what was in file?:
Error:GetSqlInstanceList(), Exception Type: Microsoft.AnalysisServices.OperationException, Exception Message: File system error: The following file is corrupted: Physical file: ...\Data\DWASDataBase.0.db\ReviewActivityDim.0.dim\5.ApprovalCondition_ReviewActivityApprovalId.(All).sstore. Logical file.
That would make sence - because as the wizzard changed the databases names in previous steps - adding "_1", it hasn't done it in this step! It was weird because I have checked "create new database" and It didn't find the old one - but what it has common with connecting to the database server?! I mean the file name :/
The same was happening when I have checked "use existing database", so apparently, the wizzard just didn't changed the database name because it couldn't connect to DB server. I have changed the DB name by adding "_1" and clicked "next", and guess what? "A server in unavailable"...
What the hell!!! What is common in connection to server and corrupted OLD!!! database file name.
I have looked at the log file - the error was exactly the same!!! So apparently the SCSM wizzard has a bug, and even having inputed a new name, it tries to install OLAP cubes under one name "DWASDataBase" in the same old folder "DWASDataBase.0.db".
I have logged on the DB server, stopped the Analysis Service, renamed the folder to "DWASDataBase.0.db_BAK", rerun the service, and... guess what :) The wizzard pass the step to the end, the installation was finalized successfully.
I have logged to my SCSM server and tried to register the SCDW server - WORKED LIKE A CHARM!
Recently I had a problem. The Data Warehouse server [SCDW] has detached from my Service Manager server [SCSM]. Without any reason :/
I have read in the Internet to unregister it and register again - "Wow, seems to be easy as pie" - I though, I have unregistered it, but trying to register it once again I have received an error:
"A management group with the same name (xxxx) is already registerted to data warehouse management group "xxxx"
Shit, what to do now?! Not many articles were written about it in the Internet, In fact, I have found just one:
http://social.technet.microsoft.com/Forums/en-US/systemcenterservicemanager/thread/4dc5cac4-49c3-4d10-ad0d-6b0bb4a4a2f2
The Unregister-SCDWSource didn't worked for me - because It has been already unregistered. The hope seems to be one powershell command:
Remove-SCDWMgmtGroup...
But it does not persist in System Center 2012, it was in 2012 version.
So the only hope was from one guy that has been dealing with it in test environment, and resolved by removing 3 records from database:
SELECT *
FROM [DWStagingAndConfig].[dbo].[MT_Microsoft$SystemCenter$ResourceAccessLayer$SdkResourceStore]
GO
I have tried that command, saw the records and deleted them, and guess what? The SCDW wizzard has moved!.. BUT! at the last page, where "create" button is, I have received an error:
"Data source is already registered with the datawarehouse"
So the same error that one guy wrote on that froum.
So, still shit. maybe even bigger, so I went back to the snapshot, and tried to fight it without modyfying the database.
I made up final decision to uninstall the SCDW server. But still I wasn't sure it would help, but no risk no fun.
After removing it, I started the installation wizzard.
I was considering to install it with the old database's names, or give new ones. The second choice was better, in fact, if I would left the old names, the field with management group was grayed out, so basically I don't think that would help with "A group is in use..." problem, because I would use the same group during registering, and I wanted to change that group name. The wizzard made it for me - for each database name it added "_1", so I simply accepted it.
From last time I remembered that the SCDW installation process it is easy as pie, so I was very astonished when on "Configure Analysis Services for OLAP cubes" I have received error "A server in unavailable" - "what the hack" - the wizzard has perfectly worked with databases in previous steps - as wrote, it discovered that I have done it before and databases persists - it has added the "_1" sign after each DB name. Why it cannot connect to DB server in this step?!
First thought was to checked the Analysis Service on my SQL server - a good old service restart :) but it didn't helped, so maybe the permissions? I have changed the user on which I was installing the SCDW server (those fields where you give username and password in wizzard), but no luck.
With a help of that post:
http://social.technet.microsoft.com/Forums/en-US/setup/thread/33c307a7-5ad9-430b-939c-bf3931495677/
I have discovered the log file, and guess what was in file?:
Error:GetSqlInstanceList(), Exception Type: Microsoft.AnalysisServices.OperationException, Exception Message: File system error: The following file is corrupted: Physical file: ...\Data\DWASDataBase.0.db\ReviewActivityDim.0.dim\5.ApprovalCondition_ReviewActivityApprovalId.(All).sstore. Logical file.
That would make sence - because as the wizzard changed the databases names in previous steps - adding "_1", it hasn't done it in this step! It was weird because I have checked "create new database" and It didn't find the old one - but what it has common with connecting to the database server?! I mean the file name :/
The same was happening when I have checked "use existing database", so apparently, the wizzard just didn't changed the database name because it couldn't connect to DB server. I have changed the DB name by adding "_1" and clicked "next", and guess what? "A server in unavailable"...
What the hell!!! What is common in connection to server and corrupted OLD!!! database file name.
I have looked at the log file - the error was exactly the same!!! So apparently the SCSM wizzard has a bug, and even having inputed a new name, it tries to install OLAP cubes under one name "DWASDataBase" in the same old folder "DWASDataBase.0.db".
I have logged on the DB server, stopped the Analysis Service, renamed the folder to "DWASDataBase.0.db_BAK", rerun the service, and... guess what :) The wizzard pass the step to the end, the installation was finalized successfully.
I have logged to my SCSM server and tried to register the SCDW server - WORKED LIKE A CHARM!
Subskrybuj:
Posty (Atom)