Skip to Content
avatar image
Former Member

statistics server migration to embedded

Hi team,

We have a problem where we get strange alerts related to statistics server migration to embedded.

301 unique constraint violated: TrexUpdate failed on table
'_SYS_STATISTICS:HOST_SERVICE_THREAD_SAMPLES_BASE' with error: unique
constraint violation in self check for table _SYS_STATISTICS:HOST_SERVICE_THREAD_SAMPLES_BASEen

I have checked the video as well for a failed migration there is no option but to restore. But here we have a problem we cannot restore since we would be losing lots of data , just for statistic server sake we cannot restore the entire database.

What are our options ?

[statisticsserver]

active = true

this is the value from nameserver.ini.

Now the problem is that if we set it to false it wont work according to the video.

http://www.saphana.com/docs/DOC-4403

What can we do overcome this problem ?

Message was edited by: Tom Flanagan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 17, 2015 at 08:40 AM

    Yes, that's what I mean. You can't do much damage by trying, so just go ahead. If everything works fine, I would make sure that this information is also updated in the SAP Note.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      As a workaround you can drop the primary index on HOST_SERVICE_THREAD_SAMPLES_BASE as described in SAP Note 2143679. With current Revisions hopefully no duplicates will be inserted, so in the future it should be possible to recreate the primary key again.

  • Oct 28, 2014 at 02:01 PM

    Hi,

    SAP HANA can do a restore and roll forward.

    For a successful recovery you need the backup that you made before you started the statistics server migration and all the backed up log segments in the logbackup location and you can do a full restore.

    - Hay

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Yes, happened the same to me "the document is not released" But I asked it to the SAP support team to give the note to me.

      This is what the note says "

      Select Administration >> Landscape >> right click Xsengine.

      From here stop the Xsengine. Normally the Xsengine will restart automatically.

      The Xsengine restart should solve the error."

      Kind regards

      Diego

  • Jan 28, 2015 at 09:39 AM

    Please refer to Note 2087751

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Martin,

      Do you mean by

      ALTER TABLE "__SYS_STATISTICS.HOST_VOLUME_IO_DETAILED_STATISTICS_BASE" DROP CONSTRAINT '$trexexternalkey$'

      ALTER TABLE "_SYS_STATISTICS.HOST_VOLUME_IO_RETRY_STATISTICS_BASE" DROP CONSTRAINT '$trexexternalkey$'

      ALTER TABLE "__SYS_STATISTICS.HOST_VOLUME_IO_RETRY_STATISTICS_BASE" DROP CONSTRAINT '$trexexternalkey$'

      like those mention in note 2127297 - HANA error 301 unique constraint violation in self check for table _SYS_STATISTICS:HOST_SERVICE_THREAD_SAMPLES_BASE ?

      From above note, it mention only dropping constraint key for HOST_SERVICE_THREAD_SAMPLES_BASE AND DISABLE collector for ID 5015, 5016 and 5017 which are the 3 threads above.

      Earlier, i've created a ticket to SAP and asked can we manually delete the contrainst key for above 3 thread, but they said no and wait for the fixes in SP10 which is quite unacceptable for me.

      Hope to hear from you.

      Thanks,

      Nicholas Chang