Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2003
    Posts
    76

    Unanswered: problem on msmerge_genhistory

    anyone that could help me resolve this problem?

    Our replication failed when it was rebooted during replication. (by Helpdesk people).
    Here are some details I have found on the problem.
    ran DBCC CHECKTABLE ('msmerge_genhistory') gave following with these error msg.

    Server: Msg 8927, Level 16, State 1, Line 2
    Object ID 408440579, index ID 0: The ghosted record count (1) in the header does not match the number of ghosted records (0) found on page (1:4344).
    Server: Msg 8928, Level 16, State 1, Line 2
    Object ID 408440579, index ID 0: Page (1:4346) could not be processed. See other errors for details.
    Server: Msg 8944, Level 16, State 1, Line 2
    Table Corrupt: Object ID 408440579, index ID 0, page (1:4346), row 74. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 68 and 0.
    Server: Msg 8928, Level 16, State 1, Line 2
    Object ID 408440579, index ID 0: Page (1:92534) could not be processed. See other errors for details.
    Server: Msg 8939, Level 16, State 1, Line 2
    Table Corrupt: Object ID 408440579, index ID 0, page (1:92534). Test (m_freeCnt == freeCnt) failed. Values are 4967 and 4970.
    Server: Msg 8928, Level 16, State 1, Line 2
    Object ID 408440579, index ID 4: Page (1:11748) could not be processed. See other errors for details.
    Server: Msg 8944, Level 16, State 1, Line 2
    Table Corrupt: Object ID 408440579, index ID 4, page (1:11748), row 83. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 33 and 0.
    DBCC results for 'MSmerge_genhistory'.
    There are 14755 rows in 349 pages for object 'MSmerge_genhistory'.
    CHECKTABLE found 0 allocation errors and 7 consistency errors in table 'MSmerge_genhistory' (object ID 408440579).

    select name from sysobjects where id = 408440579 returns MSmerge_genhistory

    Tried dbcc with repair_allow_data_loss option and still corrupt table.

    Any help is thankfull.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Can you do a select from the table?

    Whats the primary key?

    Can you select a subset?

    Can you select all of them (probably not)

    Do you have a clean backup?

    If you have 1 error, you might have many more...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2003
    Posts
    76
    I could select from the user tables just the merging job is not going through at all.
    it is a system table

    Structure:

    guidsrc uniqueidentifier
    guidlocal uniqueidentifier
    pubid uniqueidentifier Nullable
    generation int
    art_nick int
    nicknames varbinary
    coldate datetime.

    The data inside do have duplicate even tho they are unique.
    I can't run count on identifier columns.
    SELECT DISTINCT *
    FROM original_table
    GROUP BY key_value
    HAVING COUNT(key_value) > 1
    Reason Cannot run count or aggrigate on uniqueidentifier.
    Hope this helps.

    Edit:
    There are no good back up. I just started a month ago here. It is very badly structured environment.
    Last edited by sivaroo; 11-14-03 at 14:53.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    They set up replication but didn't worry about backups?

    Is the subscriber or the publisher hosed?

    Or both?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Nov 2003
    Posts
    76
    here is sample data.

    guidsrc: {C831F2CB-A997-485E-A5A4-000B1752CFD8}
    guidlocal: {ACDD4DD8-998D-41B5-A138-44AAAA4F093B}
    pubid: {FB7BFC63-7310-4F07-997C-01379C9346A9}generation 649835
    art_nick: 6980021
    nicknames: <Binary>
    coldate:11/10/2003 5:05:32 PM

    guidsrc: {D0D2EF6E-41DB-4F47-920B-00222B86D637}
    guidlocal: {D0D2EF6E-41DB-4F47-920B-00222B86D637}
    pubid: <NULL>
    generation 631726
    art_nick: 6980025
    nicknames: <Binary>
    coldate: 11/2/2003 3:00:22 PM

    guidsrc: {B175F50B-3057-4867-9AD6-0026360EF2D6}
    guidlocal: {E2D260C9-E9C5-4D48-BD27-8E99ABA8DEAF}
    pubid: {FB7BFC63-7310-4F07-997C-01379C9346A9}
    generation 634705
    art_nick: 6980014
    nicknames: <Binary>
    coldate: 11/3/2003 8:00:44 PM

    As you can see pubid duplicates and there are over 100 records with same pubid.

    subscriber is the one with problem.
    Thought about droping replication and recreating after fixing so we won't run into more problem. but MIS director is an accountant and not comfortable in doing this.
    Last edited by sivaroo; 11-14-03 at 15:07.

  6. #6
    Join Date
    Nov 2003
    Posts
    76
    Here is the environment.
    Around 160 locations setup with merge to 15 regions. (Understandable since remote locations)

    The rest all resides in HQ
    15 regions setup to 7 collection regions.
    15 regions merge with main publisher.
    7 Collection regions merge with collection server.
    Collection server merge with main publisher.

    Is this crazy enough or what.
    Edit: Forgot about account server that is merging with collection server.
    State dedicated servers replicating in same manner to a seperate server. then that seperate server replicate to the main publisher in state dedicated db.
    Last edited by sivaroo; 11-14-03 at 15:42.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •