Accedi
 
HomeLibraryRisorseFormazioneDownloadSupportoCommunityForumBlog
Risorse per professionisti IT >
> 
> 
event 31552 on RMS every ten minutes

Answered event 31552 on RMS every ten minutes

  • mercoledì 14 marzo 2012 23:18
     
     
    Registrati per votare
    0
     

    I am getting a constant every ten minute error on the rms01. This is not the timeout issue that is all over the web and forum so please don't paste a bunch of links to that. This alert seems to indicate that the stored procedure “ManagementPackInstall’ is returning a -38 which is not going into a tinyint field.

    Event Type:   Error

    Event Source:            Health Service Modules

    Event Category:        Data Warehouse

    Event ID:       31552

    Date:              3/14/2012

    Time:              3:32:39 PM

    User:               N/A

    Computer:      FMOMDEVLRMS01

    Description:

    Failed to store data in the Data Warehouse.

    Exception 'SqlException': Sql execution failed. Error 220, Level 16, State 2, Procedure ManagementPackInstall, Line 153, Message: Arithmetic overflow error for data type tinyint, value = -38.

    One or more workflows were affected by this. 

    Workflow name: Microsoft.SystemCenter.DataWarehouse.Synchronization.Configuration

    Instance name: fmomdevlrms01.amr.corp.intel.com

    Instance ID: {E526268A-2B97-D364-F7A5-06B5441CA3B6}

    Management group: OpsMgr_DevLab

     

Tutte le risposte

  • giovedì 15 marzo 2012 07:37
     
     
    Registrati per votare
    0

    Hi,

    Take a look at http://blogs.technet.com/b/sudheesn/archive/2009/07/28/getting-31552-exception-sqlexception-timeout-expired-very-frequently-in-scom-server.aspx

    Hope it helps

    Roelkn

    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.

     
  • giovedì 15 marzo 2012 14:31
     
     
    Registrati per votare
    0
     

    I hate to rant on someone but this is ridiculous! You obviously didn’t read my request or you would have seen the line “This is not the timeout issue that is all over the web and forum so please don't paste a bunch of links to that”. If all you want to do is get points go somewhere else.

     
  • giovedì 15 marzo 2012 20:47
     
     
    Registrati per votare
    0

    Hi

    Did you restored SCOM OPS DB/Data warehouse or both.

    I had worked on something similar in past so if you can throw some light on any recent things you guys did, would be great

    ~Cheers, Rohit Kochher

     
  • giovedì 15 marzo 2012 21:09
     
     
    Registrati per votare
    0
     

    It’s my understanding, I wasn't involved, that the DW house was rebuilt. I don't know if they restored it or not. The data warehouse is hosting two management groups and there are two report servers using it also.

    The reports folder and reports were not showing up in the SCOM console so I uninstalled the SCOM report server, ran the ResetSSR.exe program and reinstalled the SCOM report server. The report folder showed up but still no reports. I started checking all of the event logs and found the 31552 on the RMS. As you can see it specifically refers to the stored Procedure "ManagementPackInstall". this procedure appears to be trying to write management pack information to the Data warehouse and failing with "Arithmetic overflow error for data type tinyint, value = -38".

    I would like to know what is happening and if it is possible to fix it without doing a full rebuild.

     
  • giovedì 15 marzo 2012 21:22
     
     
    Registrati per votare
    0

    Hello,

    What is the recent management pack installed? do you have something changed in terms of rules created, MP impoerted, do you have enough space on the DW database?

    Get-Managementpack | Select DisplayName, Version, TimeCreated | Sort TimeCreated

    Regards,

    Mazen



     
  • giovedì 15 marzo 2012 21:29
     
     
    Registrati per votare
    0
    Do you see the error I have called out? It has nothing to do with space, or rules, or MP imported.
     
  • venerdì 16 marzo 2012 13:01
     
     
    Registrati per votare
    0

    Hi,

    As Mazen pointed out, this is an observed issue while you import the Dell MP thats the reason for asking any recent MP's

    These guys are helping, so firstly you cant rant !!!!

    Also this could be an issue with your Run as Accounts

    go to Administration - >Under run as accounts - simple authentication you have 2 accounts

    Data Warehouse SQL server authentication account

    Reporting SDK SQL server authentication account

    The user name and password for these are by default are a "space"

    Try doing this and restart your Configuration service.

    IF this does not resolve,

    There are a few more checks you need to do,

    check if there is data being populated in your DW database.

    If the seconds counter is too high then there is a serious issue. See if there are other error events. Post it here.   

    Regards, Dhanraj

     
  • venerdì 16 marzo 2012 14:39
     
     
    Registrati per votare
    0

    well the problem that we had at our end was that someone restored OPS DB from old backup and not DW.

    Management;s pack imported when OPS DB back up was taken (which we restored) and DW's current had some MP's version different.

    Query your Management packs in DB and DW and see if you find some different in version's or etc.

    Also as Mazen mentioned this could happen with new MP import as well.

    ~Cheers, Rohit Kochher

     
  • lunedì 19 marzo 2012 17:39
     
     Con risposta
    Registrati per votare
    0

    this is a dev environment so the management packs are always changing, but no the dell pack has not been imported.

    The RunAs accounts are also fine. I checked and reset them long before I found the error on the RMS, the one that no one seems to want to address. I have opened a ticket with MS. Thank you to those that really read my request.


     
  • martedì 3 aprile 2012 04:00
    Moderatore
     
     
    Registrati per votare
    0

    Hi,

    Is there any solution on this issue?

    As this thread has been quiet for a while, we assume that the issue has been resolved. At this time, we will mark it as "Answered" as the previous steps should be helpful for many similar scenarios.

    In addition, we’d love to hear your feedback about the solution. By sharing your experience you can help other community members facing similar problems.

    Thanks,

    Yog Li

    TechNet Community Support

     
  • giovedì 5 aprile 2012 17:05
     
     
    Registrati per votare
    0

    This issue was caused by CU5 SQL update for the opsmgr database not running correctly. While it did import the new Microsoft.SystemCenter.Library and change the version number the code was corrupted.

    Using an sql query we pulled the mp code from the OperationsManager db:

    "Select convert(xml,mpxml) from managementpack where mpname='Microsoft.SystemCenter.Library'"

    This query will return a link that when clicked will produce the code for the MP listed.

    Using two different management groups one working and one not and then doing a compare of the code showed the corruption.

    The next step was to import the correct code, since the version number had already been updated we couldn't just do a standard import from the console, and running the script again had no affect either. Even changing the version checking in the script didn't solve the problem. So...

    Changed the version:

    DECLARE @ver nvarchar(25)

    DECLARE @compare int

    SET @ver = (SELECT Mpversion From ManagementPack WHERE MPName = 'Microsoft.SystemCenter.Library')

    --Update Microsoft.SystemCenter.Library MP directly via SQL

    Set @Compare = dbo.fn_versionCompare (@ver, '6.1.7221.50')

    If(@compare = -1)

    EXEC [dbo].[p_MPImportXML]

    @ManagementPackXML = N'

    (Management pack xml)

    ', @MPKeyToken=N'31bf3856ad364e35' 

    GO