SAP Knowledge Base Article - Preview

2036630 - statisticsserver migration fails with 'error installing' / 'SQL error 129'


The migration to the new statisticsserver implementation is performed following the procedure outlined in SAP note 1917938. During the startup of the database, the following errors are reported in the HANA trace files:

nameserver trace:

STATS_CTRL       NameServerControllerThread.cpp(00347) : old StatisticsServer: hanahost:30005, volume: 4
STATS_CTRL       NameServerControllerThread.cpp(00403) : waiting for start of old StatisticsServer hanahost:30005, volume: 4...
STATS_CTRL       NameServerControllerThread.cpp(00426) : waiting for old StatisticsServer hanahost:30005, volume: 4 to stop all operations...
STATS_CTRL       NameServerControllerThread.cpp(00428) : old StatisticsServer hanahost:30005, volume: 4 has stopped all operations
STATS_CTRL       NameServerControllerThread.cpp(00431) : old StatisticsServer is ready. starting...
STATS_CTRL       CallInterfaceProxy.cpp(00041) : sending install request
STATS_CTRL       CallInterfaceProxy.cpp(00045) : response to install request: ERR:
STATS_CTRL       CallInterfaceProxy.cpp(00049) : error during install: ERR:
STATS_CTRL       NameServerControllerThread.cpp(00251) : error installing: exception  1: no.9002004  (StatisticsServerAsSQLScript/global/CallInterfaceProxy.cpp:50)
    Error during installation: ERR: .
exception throw location:
 1: 0x00007fd0cf959736 in StatisticsService::CallInterfaceProxy::install()+0x3c2 at CallInterfaceProxy.cpp:50 (
 2: 0x00007fd0cf965893 in StatisticsService::NameServerControllerThread::run(void*)+0x290 at NameServerControllerThread.cpp:232 (
 3: 0x00007fd0ce1f19e3 in TrexThreads::PoolThread::run()+0x980 at PoolThread.cpp:278 (
 4: 0x00007fd0ce1f3798 in TrexThreads::PoolThread::run(void*&)+0x14 at PoolThread.cpp:124 (
 5: 0x00007fd0cc8a664b in Execution::Thread::staticMainImp(void**)+0x627 at Thread.cpp:475 (
 6: 0x00007fd0cc8a67ed in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:543 (
Service_Shutdown TREXNameServer.cpp(03822) : setStopping(statisticsserver@hanahost:30005)

indexserver trace:

STATS_WORKER     TrexNetCommandHandler.cpp(00101) : error handling request Install: exception  1: no.9002004  (StatisticsServerAsSQLScript/global/CallInterfaceDirect.cpp:211)
    Error during installation: exception 9002001: SQL error 129: transaction rolled back by an internal error:  [129] "_SYS_STATISTICS"."STARTUPMIGRATIONSTEPIMPLEMENTOR": line 10 col 339 (at pos 2799): [129] (range 3): transaction rolled back by an internal error: invalid number: 'N' at function __typecast__() at ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/
exception throw location:
 1: 0x00007fe6479b18be in StatisticsService::CallInterfaceDirect::install()+0x4da at CallInterfaceDirect.cpp:211 (
 2: 0x00007fe6479ceed4 in StatisticsService::TrexNetCommandHandler::handle(TrexNet::Request&)+0x3a0 at TrexNetCommandHandler.cpp:69 (
 3: 0x000000000046b377 in TRexAPI::TREXIndexServer::handle(TrexNet::Request&, TrexService::HandlerContext&)+0x23d3 at TREXIndexServer.cpp:3153 (hdbindexserver)
 4: 0x00000000004b384e in WorkerThread::run(void*)+0x9aa at TrexService.cpp:1427 (hdbindexserver)
 5: 0x00007fe63f3309e3 in TrexThreads::PoolThread::run()+0x980 at PoolThread.cpp:278 (
 6: 0x00007fe63f332798 in TrexThreads::PoolThread::run(void*&)+0x14 at PoolThread.cpp:124 (
 7: 0x00007fe6333fc64b in Execution::Thread::staticMainImp(void**)+0x627 at Thread.cpp:475 (
 8: 0x00007fe6333fc7ed in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:543 (



SAP HANA Database 1.0


SAP HANA 1.0, platform edition


Initiate statisticsserver migration; statisticsserver configuration; parameter changes; statisticsserver.ini; , 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 ONE Support launchpad (Login required).

Search for additional results

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