Error 31557
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Event ID: 31557
Is Not Allowed To Access Data Warehouse Under Login
error on RMS opsmgr event viewer. System Center - Operations Manager management group with id is not allowed to access data warehouse under login > Operations Manager - General Question 0 Sign in to vote Hi Every one hour we are getting ten event id:31557 errors in RMS OPSMGR log.While loading the report its taking long time to load the reports Event Type: Error Event Source: Health Service Modules Event Category: Data Warehouse Event ID: 31557 Date: 8/10/2011 Time: 6:27:14 AM User: N/A Computer: IND-AP142 Description: Failed to obtain synchronization process state information from Data Warehouse database. The operation will be retried. Exception 'SqlException': Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.Synchronization.Configuration Instance name: IND-AP142.com Instance ID: {024F88C7-F71B-9221-D650-8D988DB4901B} Management group: MG_RUSSELL For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Help us to resolve this issue. Regards Donald D'souza Wednesday, August 10, 2011 2:31 PM Reply | Quote Answers 0 Sign in to vote Hi, take a look at theselinks they can help to resolve this problem: http://support.microsoft.com/kb/2288515 http://www.networksteve.com/enterprise/topic.php?TopicId=30025 Oussama Oueslati | System Engineer | vNext Consulting Marked as answer by Nicholas LiModerator Wednesday, August 17, 2011 5:53 AM Wednesday, August 10, 2011 3:04 PM Reply | Quote 0 Sign in to vote Hi, May I know if there were any changes before the issue occurred? Based on my research, I would like to suggest the following: 1. Please try clearing the HealthService queue on the server: a) Stop System Center Management service. b) Go to C:\Program Files\System Center Opera
until a certain moment. I would like to blog about this behavior it might help somebody to get the same or similar problem solved. As I mentioned before this new and perfectly setup SCOM 2012 infrastructure started to log an event id 31557 saying that the management server action account does not have permission to access the Data Warehouse. MVP Marcel Zehner (http://blog.scsmfaq.ch) provided me with this delicate case, thanks Marcel! In the event log it looked like this: 1) The first check was to verify that all permissions for the management server action account are set correctly. A check of the SQL Server logs did not show any wrong login attempts https://social.technet.microsoft.com/Forums/en-US/82016c01-42aa-456f-bbf0-f22085a4ebb0/event-id-31557-error-on-rms-opsmgr-event-viewer?forum=operationsmanagergeneral at all either. 2) Next we will check the data writer account configured in the Data Warehouse. To find this information you could run the following query against the OperationsManagerDW database: Use OperationsManagerDW GO Select * from ManagementGroup As we can see another account is configured for the data writer account, which is correct. If another account is being used as configured in the WriterLoginName in the query result above, the management server https://stefanroth.net/2012/12/30/scom-2012-event-id-31557-health-service-modules/ will block the transaction first before sending the request to the SQL Server database. 3) If we look more closely at the error in the event it says svc-scom-action account is used to access the Data Warehouse which is the management server action account. Therefore, we are going to check the management server and its Run As accounts. 4) Go to Administration/Run As Configuration/Accounts and click each of the two accounts Data Warehouse Action Account and Data Warehouse Report Deployment Account. By checking these accounts Data Warehouse Action Account and Data Warehouse Report Deployment Account both seem configured properly, as you can see here… 5) Next we are going to check the Run As profiles. Go to Administration/Run As Configuration/Profiles and again we are looking at the Data Warehouse Account and Data Warehouse Report Deployment Account profiles. By checking these two profiles we found the problem. Data Warehouse Account profile list was empty… …and also the Data Warehouse Report Deployment Account profile list was empty… This means no Run As account was associated anymore with each of its corresponding Run As profile. Therefore, the default action account had been used and this was in my case svc-scom-action. Lessons learned - never ever assume anything. Check always your settings twice! Share this:TwitterLike this:Like Loading... Related 24 Comments I ran i
has the below sql server exception Failed to store data in the Data Warehouse. The operation will be http://www.networksteve.com/enterprise/topic.php/SCOM_data_warehouse_Database_error's/?TopicId=60742&Posts=5 retried. Exception 'SqlException': Error 777970008, severity 16, state 1 was http://www.solvusoft.com/es/errors/errores-tiempo-de-ejecuci%C3%B3n/microsoft-corporation/microsoft-access/31557-microsoft-office-access-cannot-update-dependency-information-because-one-or-more-objects-are-open/ raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage. Appreciate your help on this July 10th, 2012 12:28pm Hi Can you let us is not know: - SCOM version: 2007 r2 or 2012 - SQL Version Have you applied any cumulative updates. If so, have you run the SQL scripts against the correct database when applying the update? Has anything changed in the last 3 days? Hot fixes \ patches? Cheers GrahamRegards Graham New System Center 2012 is not allowed Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/ Free Windows Admin Tool Kit Click here and download it now July 10th, 2012 2:02pm Hi Graham, We have SCOM 2007 r2 cu4 and moved the SCOM databases to sql 2008 last week Many thanks David July 10th, 2012 2:06pm Sounds like this: http://blogs.technet.com/b/mgoedtel/archive/2007/08/06/update-to-moving-operationsmanager-database-steps.aspx Have you also enabled CLR as mentioned here: *** Note there is a footnote added by a user in the guide to enable CLR. This is REQUIRED it is missing from the core guide. http://blogs.technet.com/b/kevinholman/archive/2010/08/26/moving-the-operations-database-my-experience.aspx Cheers GrahamRegards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/ Free Windows Admin Tool Kit Click here and download it now July 10th, 2012 2:21pm I had enabled CLR and the script which mention on the below link. One of my colleague changed the scom passwords. After that below event is continuously logged on the sql server a
WinThruster DriverDoc WinSweeper SupersonicPC FileViewPro Acerca de Soporte Contacto Errores de la resolución de problemas › Errores en tiempo de ejecución › Microsoft Corporation › Microsoft Access › Error 31557 Cómo reparar error 31557 de Microsoft Access Número del error: Error 31557 Nombre del error:Microsoft Office Access cannot update dependency information because one or more objects are open Descripción del error: Microsoft Office Access cannot update dependency information because one or more objects are open.@Close all objects and try again.@@1@@@3. Desarrollador:Microsoft Corporation Software:Microsoft Access Aplica a:Windows XP, Vista, 7, 8 Descargar ahoraWinThruster 2015 - Analice su computadora en busca de errores de PC. Compatible con Windows 2000, XP, Vista, 7, 8 y 10 Síntomas del error 31557 El "error 31557” aparece y bloquea la ventana del programa activo. Su PC se bloquea con frecuencia con el Error 31557 cuando ejecuta el mismo programa. Se muestra “Microsoft Office Access cannot update dependency information because one or more objects are open”. Windows se ejecuta y responde lentamente ante el mouse o entrada del teclado. Su computadora periódicamente se "congela" durante unos pocos segundos cada vez. Estos mensajes de error de 31557 pueden aparecer durante la instalación de un programa, mientras que programas Microsoft Corporation relacionados al software (por ejemplo: Microsoft Access) se estén ejecutando durante el inicio o el apagado de Windows, o incluso durante la instalación del sistema operativo de Windows. Realizar un seguimiento de cuándo y dónde se produce el error de 31557 es una información crítica en la resolución del problema. Causas del error 31557 Descarga dañada o instalación incompleta del software Microsoft Access. Se registra un daño en el registro de Microsoft Access debido a un cambio de software reciente relacionado con Microsoft Access (instalación o desinstalación). Infección de malware o virus que ha dañado el archivo Windows o archivos de programas relacionados a Microsoft Access. Otro programa borró los archivos relacionados a Microsoft Access de forma errónea o malintencionada. Errores en tiempo de ejec