DataWarehouse access denied?
Hi, I have just recently started working with scom 2012. We had a single server instalation of SCOM 2007 R2 and SQL 2008. Recently I did an upgrade of SQL to 2008 R2 and reporting services. Everything seems ok but I keep getting the following errors: This didn't happen before. I am sure the account has the required priviledges as I checked in SQL mgmt studio and is a local Administrator on the Scom machine. I have read all kinds of documentation articles and followed the upgrade step by step guide. I would also like to recreate the sql dw database somehow or configure a new one if this issue proves to be to much of a pain. What else should I check?...
October 16th, 2012 3:52am
Hi, inf from Kevin Holman The most common issues causing the 31552 events seen are: A sudden flood (or excessive sustained amounts) of data to the warehouse that is causing aggregations to fail moving forward.The Exchange 2010 MP is imported into an environment with lots of statechanges happening.Excessively large ManagedEntityProperty tables causing maintenance to fail because it cannot be parsed quickly enough in the time allotted.Too many tables joined in a view or query (>256 tables) when using SQL 2005 as the DB EngineSQL performance issues (typically disk I/O)Using SQL standard edition, you might see these randomly at night, during maintenance as online indexing is not supported using SQL standard edition.Messed up SQL permissionsToo much data in the warehouse staging tables which was not processed due to an issue and is now too much to be processed at one time.Random 31552s caused my DBA maintenance, backup operations, etc.. If you think you are impacted with this, and have an excessively large ManagedEntityProperty table the best bet is to open a support case. This requires careful diagnosis and involves manually deleting data from the database which is only supported when directed by a Microsoft Support Professional. Also Check his SQL query http://blogs.technet.com/b/kevinholman/archive/2007/10/18/useful-operations-manager-2007-sql-queries.aspx to find out statechanges.
October 16th, 2012 5:00am
Hi, Check this blog: EventID 31552: Failed to store data in the Data Warehouse. Exception 'SqlException': A network-related or instance-specific error occurred while establishing a connection to SQL Server http://thoughtsonopsmgr.blogspot.dk/2011/03/eventid-31552-failed-to-store-data-in.html Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
October 16th, 2012 5:04am