Skip to Content

ERROR *** Assertion failed: 100905

With following message on the next line down

"Articles on the table use do not match those on the table definition"

I cant seem to find what this message means. Can someone please explain ?

Add comment
10|10000 characters needed characters exceeded

  • Assertions generally indicate an unexpected state that can have negative consequences such as database corruption. This assertion was added to catch potential issues when logging DML for tables which are contained in a publication which could result in damage to the transaction log.

    Are you able to reproduce? If so, I think you will want to work with support to determine root cause.

    -chris

  • Thanks Chris, this is on a test server that Ill be advancing to the latest version ASAP. Ill check if there are any publications on it today

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 21 at 07:59 AM

    Probably it is a known issue.
    It has been fixed in the EBF.

    Assertion failed 100905 was written in version 12 EBF Readme as follows.
    ================(Build #3261 - Engineering Case #650690)================
    The server would have returned assertion failed 100905 "Articles on
    the table use do not match those on the table definition", if a table
    had publications and a simple INSERT with multiple row value constructors
    was executed. For example: insert into tab1 values (1,'a'),(2,'b'). This
    has been fixed.
    =========================================================================

    The same issue seems to have been reported in version 10,11,12.

    Add comment
    10|10000 characters needed characters exceeded