SAP Knowledge Base Article - Preview

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
if :mynewrow.key = 'internal.sizing.profile'
if :mynewrow.value != :myoldrow.value
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/
exception 1: no.71000446 (ptime/query/checker/ TID: <ThreadID>
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/
exception 1: no.71000301 (RowEngine/Operator/Impl/ 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 (
2: 0x00007fa30a782ffe in StatisticsService::NameServerControllerThread::run(void*)+0x30a at NameServerControllerThread.cpp:508 (
3: 0x00007fa2ea22f89f in TrexThreads::PoolThread::run()+0x78b at PoolThread.cpp:462 (
4: 0x00007fa2ea2323b0 in TrexThreads::PoolThread::run(void*&)+0x10 at PoolThread.cpp:143 (
5: 0x00007fa2e53310ef in Execution::Thread::staticMainImp(Execution::Thread*)+0x54b at Thread.cpp:528 (
6: 0x00007fa2e5320368 in Execution::pthreadFunctionWrapper(Execution::Thread*)+0x164 at ThreadInterposition.cpp:633 (
7: 0x00007fa2e4ad4724 in start_thread+0xc0 (
8: 0x00007fa2e335fe8d in __clone+0x69 (
[<ThreadID>]{-1}[-1/-1] <Timestamp> e STATS_CTRL NameServerControllerThread.cpp(00543) : disable Embedded Statistics Server



HANA Platform 2.0


SAP HANA, platform edition 2.0


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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.