2911708 - ERROR [SQL-301] unique constraint violated: Table(STATISTICS_PROPERTIES)

Statisticsserver is disabled immediately after re-activating it. You can see similar error message from indexserver trace.

[<ThreadID>]{-1}[-1/-1] <Timestamp> i STATS_WORKER SQLInterfaceEAPI.cpp(00297) : createObject: <create trigger _SYS_STATISTICS.statistics_switch_profile
after update on _SYS_STATISTICS.statistics_properties
referencing new row mynewrow, old row myoldrow
begin
if :mynewrow.key = 'internal.sizing.profile'
then
if :mynewrow.value != :myoldrow.value
then
call _SYS_STATISTICS.shared_copy_profiles (:myoldrow.value, :mynewrow.value);
end if;
end if;
end> ERROR [SQL-446] cannot use duplicate trigger name: STATISTICS_SWITCH_PROFILE: line 1 col 32 (at pos 31) at ptime/query/checker/check_id.cc:226
exception 1: no.71000446 (ptime/query/checker/check_id.cc:226) TID: <ThreadID>
STATISTICS_SWITCH_PROFILE
NO exception throw location recorded. Stack generation suppressed.
[<ThreadID>]{-1}[-1/-1] <Timestamp> i TraceContext TraceContext.cpp(01218) : UserName=
[<ThreadID>]{-1}[-1/-1] <Timestamp> i STATS_WORKER SQLInterfaceEAPI.cpp(00297) : createObject: <insert into _SYS_STATISTICS.statistics_properties (key, value) values ('internal.sizing.profile', '')> ERROR [SQL-301] unique constraint violated: Table(STATISTICS_PROPERTIES), Index(_SYS_TREE_RS_#146168_#0_#P0) at RowEngine/Operator/Impl/TreeIndexOperator.cc:208
exception 1: no.71000301 (RowEngine/Operator/Impl/TreeIndexOperator.cc:208) TID: <ThreadID>
Table(STATISTICS_PROPERTIES), Index(_SYS_TREE_RS_#146168_#0_#P0)
NO exception throw location recorded. Stack generation suppressed.
[<ThreadID>]{-1}[-1/-1] <Timestamp> i TraceContext TraceContext.cpp(01218) : UserName=
[<ThreadID>]{-1}[-1/-1] <Timestamp> e STATS_CTRL NameServerControllerThread.cpp(00539) : error installing: exception 1: no.9002004 (StatisticsServerAsSQLScript/global/CallInterfaceDirect.cpp:265) TID: <ThreadID>
Error during installation: SQL error $code$: $text$..
exception throw location:
1: 0x00007fa30b9ac3d2 in StatisticsService::CallInterfaceDirect::install()+0x400 at CallInterfaceDirect.cpp:265 (libstatisticsserver2.so)
2: 0x00007fa30a782ffe in StatisticsService::NameServerControllerThread::run(void*)+0x30a at NameServerControllerThread.cpp:508 (libhdbns.so)
3: 0x00007fa2ea22f89f in TrexThreads::PoolThread::run()+0x78b at PoolThread.cpp:462 (libhdbbasement.so)
4: 0x00007fa2ea2323b0 in TrexThreads::PoolThread::run(void*&)+0x10 at PoolThread.cpp:143 (libhdbbasement.so)
5: 0x00007fa2e53310ef in Execution::Thread::staticMainImp(Execution::Thread*)+0x54b at Thread.cpp:528 (libhdbbasis.so)
6: 0x00007fa2e5320368 in Execution::pthreadFunctionWrapper(Execution::Thread*)+0x164 at ThreadInterposition.cpp:633 (libhdbbasis.so)
7: 0x00007fa2e4ad4724 in start_thread+0xc0 (libpthread.so.0)
8: 0x00007fa2e335fe8d in __clone+0x69 (libc.so.6)
[<ThreadID>]{-1}[-1/-1] <Timestamp> e STATS_CTRL NameServerControllerThread.cpp(00543) : disable Embedded Statistics Server

HANA Platform 2.0

ESS, STATISTICS_PROPERTIES, drop, de-activate, duplication, unique violation , KBA , HAN-DB-MON , SAP HANA Monitoring , Problem