Skip to Content
avatar image
Terry Hastings

ERROR *** Assertion failed: 100905

Feb 21, 2018 at 12:30 AM | 75 Views

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 ?

SAP SQL Anywhere
Add comment
10|10000 characters needed characters exceeded

  • Chris Keating
    Feb 21, 2018 at 02:40 PM

    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

  • Terry Hastings Chris Keating
    Feb 22, 2018 at 12:05 AM

    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
    avatar image
    Koichi Ogawa
    Feb 21, 2018 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