Skip to Content

column store error: search table error: [23017] Index syncpoint mismatch]

Hi Team,

Currently in production when we are running the procedures some times we are facing the below error message:

[2048] (range 3): column store error: search table error: [23017] Index syncpoint mismatch]

Upon re-run of the procedure it is working fine.

Anyone else faced this issue? Any thoughts?

Regards,

Krishna Tangudu

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Nov 10, 2014 at 02:42 PM

    Update:

    We have raised an Support Incident and it is still "WIP". Meanwhile, I disabled Automatic merge on the Table and was doing a Manual merge from the procedure after the loading is done. It has solved the issue. Found the below trace :

    [80414]{1601013}[155/108602087] 2014-11-08 22:00:56.191461 e euclid BwPopAggregateParallel.cpp(01064) : Index syncpoint mismatch;object=SCHEMA_NAME:_SYS_SPLIT_TABLENAME~3en(23017)
    [80250]{237874}[95/108602134] 2014-11-08 22:00:58.114087 i TraceContext TraceContext.cpp(00702) : UserName=USERNAME

    Still waiting for the message from SAP before checking in production.

    Regards,

    Krishna Tangudu

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 25, 2014 at 07:15 PM

    I'm not much help but searching briefly I see several mentions of delta merges when receiving this similar error. Not that it helps you but i'm curious if you see delta merge process running when you receive this error? I'm sure Lars the great will chime in soon.

    -Patrick

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 25, 2014 at 08:17 PM

    Hey Krishna,

    You can try two things.

    I believe those tables has indexes.

    Try to include the drop index and recreate index statements in the procedure and see.

    like

    drop index;

    delete the data

    insert the data

    create index

    the second method is manually stop the delta merge for that table,then insert the data and do the delta merge.

    I believe this is because of delta merge problem.

    Regards,

    Venkat N

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Venkat,

      Agreed it to be a delta merge problem. Will check if the tables have any indexes created manually . On the second one , you wanted me to make the delta merge manual? May not be so feasible even if it works as this is a production case.

      Regards,

      Krishna Tangudu

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.