cancel
Showing results for 
Search instead for 
Did you mean: 

xsengine not started not able to restart

slim_trabelsi
Employee
Employee
0 Kudos

Hi,

Since few days I observed that in my HANA system the xsengine service was down.

Even after restarting the whole system the xsengine remains down .. when I wright click on the service as you can see, I don't have the option start.

Any hint ?

Accepted Solutions (1)

Accepted Solutions (1)

former_member182832
Participant
0 Kudos

Hi Slim,

From the command line (OS level) please authenticate with <SID>adm user and try to start the xsenginee manually (execute the command : hdbxsengine). If it fails to start it will show a short error message. Also please share the dump file.

Regards,

Mehdi.

slim_trabelsi
Employee
Employee
0 Kudos

Hi Mehdi,

When I executed the command in adm mode this is the error:

root@mo-0f5ffe310:/usr/sap/SVM/SYS/exe/hdb # ./hdbxsengine

./hdbxsengine: error while loading shared libraries: libxsengine.so: cannot open shared object file: No such file or directory

Thanks

Cheers

Slim

former_member182832
Participant
0 Kudos

Hi Slim

Please setup the SECUDIR environment variable (SECUDIR=/usr/sap/<SID>/HDB00/<hostname folder>/sec)

After you can run the command sapgenpse. It will show you information about your environment and if the variable SECUDIR is correctly configured.

Regards,

Mehdi.

slim_trabelsi
Employee
Employee
0 Kudos

Done:

USER="svmadm"

  Environment variable $SECUDIR is defined:

  "/usr/sap/SVM/HDB00/sec"

knwowing the the sec folder is empty .. on the hana security guide it is written that SECUDIR should contain sapsrv.pse

cheers

Slim

former_member182832
Participant
0 Kudos

The sec folder should be under /usr/sapSVM/HDB/<hostname>/sec (not "/usr/sap/SVM/HDB/sec")

Please can you run the command sapgenpse (with svmadm user) and share the result ?

If you are unable to run properly this command please install  properly your security libraries (Commons cryptolib...). 

Thank you,

Mehdi

slim_trabelsi
Employee
Employee
0 Kudos

tanks you for your patience

  Loaded CommonCryptoLib from sapgenpse folder

  "/usr/sap/SVM/exe/linuxx86_64/HDB_1.00.095.00.1429086950_2037389/libsapcrypto.so"

  Platform:   linux-gcc-4.3-x86-64   (linux-gcc-4.3-x86-64)

  Versions:   SAPGENPSE     8.4.35 (Mar 16 2015)

              FILE-Version  8.4.35.0

              CommonCryptoLib (SAPCRYPTOLIB) Version 8.4.35 pl40 (Mar 16 2015) MT-safe

  USER="svmadm"

  Environment variable $SECUDIR is defined:

  "/usr/sap/SVM/HDB00/mo-0f5ffe310/sec"

former_member182832
Participant
0 Kudos

Great

Now please check if your pse's exist in folder "/usr/sap/SVM/HDB/mo-fff310/sec"

If they exist, please try to Stop/Start hana ("./HDB stop" and  "./HDB start")

If xsengine still not running please go to your hana studio  go to administration screen > Diagnosis files > xsengine_mo-fff310-3007.trc

In the same list of files check if there are dump or alert files (xsengine_alert.trc) and please attach them so we can look directly in traces.

you can also get these trace files from os level under /usr/sap/SVM/HDB/mo-ff310/trace/

Regards,

Mehdi

slim_trabelsi
Employee
Employee
0 Kudos

I had a timeout during the start command:

➜  HDB00 ./HDB start

StartService

Impromptu CCC initialization by 'rscpCInit'.

  See SAP note 1266393.

OK

OK

Starting instance using: /usr/sap/SVM/SYS/exe/hdb/sapcontrol -prot NI_HTTP -nr 00 -function StartWait 2700 2

20.09.2016 12:49:05

Start

OK

20.09.2016 13:34:06

StartWait

FAIL: Timeout

in the log for the xsengine_alert.trc I got this:

[64546]{-1}[-1/-1] 2016-09-20 07:26:25.039774 e Crypto           CommonCryptoLib.cpp(00249) : SECUDIR unknown

now it is no more unknown ..

Ihave to discover why I got the timeout

Answers (1)

Answers (1)

former_member182967
Active Contributor
0 Kudos

Hi Slim,

Please attach the latest error of xsengine trace log for further analysis (you can find this information in tab Diagnostic Files of admin console).

Regards,

Ning

slim_trabelsi
Employee
Employee
0 Kudos

Hi Ning,

Thank you for the reply: here is the last traces in the log related to the xsengine service activity:

[62765]{-1}[-1/-1] 2016-09-19 13:58:40.555057 i RowStorePageAcce AbsolutePageAccessImpl.cpp(01807) : set SuperblockPrefetchCount=227 (max: 32767)

[62765]{-1}[-1/-1] 2016-09-19 13:58:40.555061 i RowStorePageAcce AbsolutePageAccessImpl.cpp(01346) : trigger load of superblocks...

[62765]{-1}[-1/-1] 2016-09-19 13:58:40.825324 i RowStorePageAcce AbsolutePageAccessImpl.cpp(01391) : trigger load of superblocks done after 270msec.

[62763]{-1}[-1/-1] 2016-09-19 13:58:40.830778 i RowStorePageAcce AbsolutePageAccessImpl.cpp(01724) : load process: 50% (1 of 2) : overall 232MB/s.

[62764]{-1}[-1/-1] 2016-09-19 13:58:40.873983 i RowStorePageAcce AbsolutePageAccessImpl.cpp(01724) : load process: 100% (2 of 2) : overall 401MB/s.

[62764]{-1}[-1/-1] 2016-09-19 13:58:40.874013 i RowStorePageAcce AbsolutePageAccessImpl.cpp(01743) : i/o finished: read 2 superblock(s) within 318ms = 401MB/s overall.

[62765]{-1}[-1/-1] 2016-09-19 13:58:40.874054 i RowStorePageAcce AbsolutePageAccessImpl.cpp(01402) : finished loading all 1 segments by reading 2 superblocks after 341msec.

[62765]{-1}[-1/-1] 2016-09-19 13:58:40.875011 i Service_Startup  CheckpointMgr.cc(00643) : 1 RS segments loaded from Persistency in 0.33999999985098839 sec (188.23529420014484MB/s)

[62749]{-1}[-1/-1] 2016-09-19 13:58:40.876283 i Service_Startup  MemSystem.cc(00131) : total memory size (MB) = 31855

[62749]{-1}[-1/-1] 2016-09-19 13:58:40.876471 i Logger           PersistenceManagerImpl.cpp(02625) : Preparing log recovery handler, start position 0x25b7ec40

[62749]{-1}[-1/-1] 2016-09-19 13:58:40.876702 i Logger           LoggerImpl.cpp(00487) : Setting log segment size to 8MB, original value was 1024MB

[62749]{-1}[-1/-1] 2016-09-19 13:58:40.963686 w PersistenceManag PersistenceManagerImpl.cpp(04081) : NOTE: Database runs under special log mode 'overwrite'; state of recoverability from backup unknown

[62749]{-1}[-1/-1] 2016-09-19 13:58:40.963747 i Logger           PersistenceManagerImpl.cpp(04270) : Deactivating REDO logging for log replay

[62749]{-1}[-1/-1] 2016-09-19 13:58:40.963750 i Logger           PersistenceManagerImpl.cpp(04281) : Start termination of rollback(s) open in restart/backup savepoint

[62749]{-1}[-1/-1] 2016-09-19 13:58:40.963956 i Logger           PersistenceManagerImpl.cpp(04289) : Termination of rollback(s) open in restart/backup savepoint finished in 1.6e-05 seconds;

[62749]{-1}[-1/-1] 2016-09-19 13:58:40.963994 i Logger           PersistenceManagerImpl.cpp(04294) : Start garbage collection of history files

[62749]{-1}[-1/-1] 2016-09-19 13:58:40.964250 i Logger           PersistenceManagerImpl.cpp(04305) : Garbage collection of history files finished: 0 cleanup files in 0.000243 seconds;

[62749]{-1}[-1/-1] 2016-09-19 13:58:40.964274 i Logger           PersistenceManagerImpl.cpp(04329) : Executing log replay in legacy mode, no savepoint log record written at 0x25b7ec40 for savepoint 148439

[62749]{-1}[-1/-1] 2016-09-19 13:58:40.964428 i Logger           RecoveryHandlerImpl.cpp(00947) : RecoveryQueueCount used: 64

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.004086 i Logger           PersistenceManagerImpl.cpp(04391) : Starting log replay at position 0x25b7ec40

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.004120 i Logger           RecoveryHandlerImpl.cpp(01493) : Triggering recovery of remaining log

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.004180 i Logger           RecoveryHandlerImpl.cpp(01541) : Finishing log recovery, waiting for in-process and in-load segments

[62834]{-1}[-1/-1] 2016-09-19 13:58:41.004374 i Logger           RecoveryHandlerImpl.cpp(01937) : Log recovery cannot expect any more data at position 0x25b7ec40, load states:

  - LogPartition[/usr/sap/SVM/SYS/global/hdb/log/mnt00001/hdb00002/:0]: #segments 0/0 processed, 0/0 loaded, 0 total

[62834]{-1}[-1/-1] 2016-09-19 13:58:41.005217 i Logger           RecoveryHandlerImpl.cpp(03426) : Signaling finish wait barrier

[62834]{-1}[-1/-1] 2016-09-19 13:58:41.005236 i Logger           RecoveryHandlerImpl.cpp(02202) : Recovery finished at log position 0x25b7ec40

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.007505 i LogReplay        RowStoreTransactionCallback.cc(00353) : starting slave-master DTX consistency check (#1)

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.009135 i Service_Startup  transmgmt.cc(05621) : Establishing initial connection to global transaction coordinator

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.009226 i Service_Startup  transmgmt.cc(05638) : Global transaction coordinator address = mo-0f5ffe310:30003

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.009258 i Service_Startup  transmgmt.cc(05654) : Initial connection request to global transaction coordinator is sending

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.011385 i Service_Startup  transmgmt.cc(05656) : Initial connection request to global transaction coordinator is handled

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.011666 i Service_Startup  transmgmt.cc(05695) : connected to Transaction Coordinator in mo-0f5ffe310:30003

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.011721 i LogReplay        RowStoreTransactionCallback.cc(00407) : finished slave-master DTX consistency check

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.011762 i Logger           LogSegment.cpp(00646) : Closing open log segments after log recovery completed at position 0x25b7ec40

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.015667 i Logger           LoggerImpl.cpp(01203) : Replayed 0B (0MB) of log in 0.051355 seconds; 0MB/s; max known TID=65216805

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.015804 i Logger           LoggerImpl.cpp(00820) : Starting logger with 8 log buffers per partition, 1024KB each, segment size 8MB, log mode overwrite

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.036746 i Logger           RecoveryHandlerImpl.cpp(01788) : Termination of 0 indoubt transactions was executed in 0.011949 seconds;

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.038182 i Logger           PersistenceManagerImpl.cpp(04506) : Activating REDO logging after log replay

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.039715 i LogReplay        RowStoreTransactionCallback.cc(00524) : waiting for master mo-0f5ffe310:30003 DTX consistency check to be done

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.040398 i LogReplay        RowStoreTransactionCallback.cc(00566) : master side DTX consistency check succeed

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.048151 i ContainerDirecto ContainerNameDirectoryImpl.cpp(01182) : Load ContainerNameDirectory...

[62763]{-1}[-1/-1] 2016-09-19 13:58:41.048242 i PersistenceManag VirtualFileStatsProxy.cpp(00132) : Initialize VirtualFile statistics...

[62762]{-1}[-1/-1] 2016-09-19 13:58:41.048242 i PersistenceManag VirtualFileStatsProxy.cpp(00188) : Initialize VirtualFile LOB statistics...

[62762]{-1}[-1/-1] 2016-09-19 13:58:41.048412 i PersistenceManag VirtualFileStatsProxy.cpp(00222) : VirtualFile LOB statistics initialized: 0 CD entries in 145.00 usec

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.057104 i ContainerDirecto ContainerNameDirectoryImpl.cpp(01255) : ContainerNameDirectory loaded 1/1 in 8.93 msec

[62763]{-1}[-1/-1] 2016-09-19 13:58:41.076099 i PersistenceManag VirtualFileStatsProxy.cpp(00167) : VirtualFile statistics initialized: 0/0 CD entries in 27.84 msec

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.076239 i Logger           PersistenceManagerImpl.cpp(04545) : Unload in memory indexes in Attribute Store

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.081457 i LogReplay        RowStoreTransactionCallback.cc(00353) : starting slave-master DTX consistency check (#2)

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.082296 i Service_Startup  transmgmt.cc(05621) : Establishing initial connection to global transaction coordinator

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.082363 i Service_Startup  transmgmt.cc(05638) : Global transaction coordinator address = mo-0f5ffe310:30003

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.082370 i Service_Startup  transmgmt.cc(05695) : connected to Transaction Coordinator in mo-0f5ffe310:30003

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.082380 i LogReplay        RowStoreTransactionCallback.cc(00407) : finished slave-master DTX consistency check

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.096433 i PersistenceManag PersistenceManagerImpl.cpp(02713) : Activating periodic savepoint, frequency 300

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.104854 i Service_Startup  transmgmt.cc(05621) : Establishing initial connection to global transaction coordinator

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.104964 i Service_Startup  transmgmt.cc(05638) : Global transaction coordinator address = mo-0f5ffe310:30003

[62749]{-1}[-1/-1] 2016-09-19 13:58:41.104970 i Service_Startup  transmgmt.cc(05681) : TransactionCoordinator is not yet available ... (waiting for ActiveYes status)

[62749]{-1}[-1/-1] 2016-09-19 13:58:42.105392 i Service_Startup  transmgmt.cc(05695) : connected to Transaction Coordinator in mo-0f5ffe310:30003

[62749]{-1}[-1/-1] 2016-09-19 13:58:42.230668 i Service_Startup  mm_recovery.cc(01497) : Rebuilding page lists.

[62749]{-1}[1/-1] 2016-09-19 13:58:42.251667 i Service_Startup  LoadTableMgr.cc(00370) : SegmentCidTable loading done.

[62749]{-1}[-1/-1] 2016-09-19 13:58:42.295444 i Service_Startup  mm_recovery.cc(01037) : RS: metadata & data are mixed

[62749]{-1}[-1/-1] 2016-09-19 13:58:42.297005 i Service_Startup  ptime_master_start.cc(00576) : Rebuilding system indexes.

[62749]{-1}[-1/-1] 2016-09-19 13:58:42.359956 i Service_Startup  ptime_master_start.cc(00590) : Rebuilding system indexes done.

[62749]{-1}[-1/-1] 2016-09-19 13:58:42.359975 i Service_Startup  ptime_master_start.cc(00592) : Rebuilding indexes.

[62749]{-1}[1/-1] 2016-09-19 13:58:42.361513 i Service_Startup  IndexManager_rebuild.cc(00516) : Rebuilding 378 indexes

[62749]{-1}[2/-1] 2016-09-19 13:58:42.378079 i Service_Startup  IndexManager_rebuild.cc(00859) : Processed 96% (364 out of 378 indexes)

[62749]{-1}[2/-1] 2016-09-19 13:58:42.381832 i Service_Startup  IndexManager_rebuild.cc(00893) : Processed 100% (378 out of 378 indexes)

[62749]{-1}[1/-1] 2016-09-19 13:58:42.392521 i Service_Startup  IndexManager_rebuild.cc(00983) : Number of large indexes: 0

[62749]{-1}[1/-1] 2016-09-19 13:58:42.392536 i Service_Startup  IndexManager_rebuild.cc(00986) : Rebuilding remaining 2 indexes

[62749]{-1}[1/-1] 2016-09-19 13:58:42.420012 i Service_Startup  IndexManager_rebuild.cc(01025) : large index rebuilding finished

[62749]{-1}[1/-1] 2016-09-19 13:58:42.423131 i Service_Startup  IndexManager_rebuild.cc(01049) : Rebuilding remaining indexes done

[62749]{-1}[-1/-1] 2016-09-19 13:58:42.423670 i Service_Startup  ptime_master_start.cc(00598) : Rebuilding indexes done.

[62749]{-1}[-1/-1] 2016-09-19 13:58:42.423687 i Service_Startup  ptime_master_start.cc(00600) : Index rebuilding time: 0.06 seconds

[62749]{-1}[-1/-1] 2016-09-19 13:58:42.560859 i Service_Startup  ptime_master_start.cc(00959) : Session service is ready.

[62749]{-1}[-1/-1] 2016-09-19 13:58:42.576479 i Service_Startup  translog.cc(01448) : Activating private log buffering mode

[62749]{-1}[-1/-1] 2016-09-19 13:58:42.576578 i assign           TREXIndexServer.cpp(01127) : persistence started with volume 2

[62749]{-1}[-1/-1] 2016-09-19 13:58:50.702612 i TraceContext     TraceContext.cpp(00827) : UserName=

[62749]{-1}[-1/-1] 2016-09-19 13:58:50.702596 e Crypto           Configuration.cpp(00222) : Configuration::getProviderType: crypto provider 'commoncrypto' not available

[62749]{-1}[-1/-1] 2016-09-19 13:58:50.703166 e Authentication   SAPLogonManager.cpp(00084) : Invalid SSL configuration: crypto provider 'commoncrypto' not available

[62749]{-1}[-1/-1] 2016-09-19 13:58:50.703193 e Authentication   AcceptorConfiguration.cpp(00109) : Error during SAPLogon initialization!

[62749]{-1}[-1/-1] 2016-09-19 13:58:50.731075 i assign           TREXIndexServer.cpp(01580) : assign to volume 2 finished

[62847]{-1}[6/-1] 2016-09-19 13:58:50.735047 i Crypto           RootKeyStore.cpp(00386) : Empty SSFS cache: reading from SSFS (ID=HDB_SERVER/DPAPI)

[62847]{-1}[6/-1] 2016-09-19 13:58:50.736618 e Crypto           Configuration.cpp(00222) : Configuration::getProviderType: crypto provider 'commoncrypto' not available

[62847]{-1}[6/-1] 2016-09-19 13:58:50.736891 e Crypto           KeyMgmtApi.cpp(00714) : Error during decrypting the key-content with primary root key: Invalid SSL configuration: $ErrorText$ (Invalid SSL configuration: crypto provider 'commoncrypto' not available)

[62847]{-1}[-1/-1] 2016-09-19 13:58:50.738426 e assign           TREXIndexServer.cpp(01658) : post assign failed with ltt exception. stopping service... :

exception  1: no.2530001  (XSEngine/Connectivity/Smtp/SmtpSettingsInternalInlines.h:226)

    error loading SMTP settings

exception throw location:

1: 0x00007f409353287a in xsengine::TSmtpSettingsWithStorage<config::Configuration, Crypto::Services::CredentialStore::CredentialStoreService, ptime::Transaction>::loadSettings()+0x1096 at XSSmtpExceptions.h:21 (libhdbxsapi.so)

2: 0x00007f4093530c16 in xsengine::createSmtpSettings(ltt::allocator&, config::LayeredConfiguration*)+0x92 at SmtpSettingsInternalInlines.h:118 (libhdbxsapi.so)

3: 0x00007f409358f01a in xsengine::XSIni::hookStarted()+0x16 at XSIni.cpp:326 (libhdbxsapi.so)

4: 0x00007f40be02c5ee in XSEngine::hookStarted()+0x3a at XSEngine.cpp:217 (libxsengine.so)

5: 0x00007f40be6c3a93 in TRexAPI::TREXIndexServer::postAssign(NameServer::ServiceStartInfo&)+0x70 at TREXIndexServer.cpp:1624 (hdbxsengine)

6: 0x00007f40be6f79cd in TRexAPI::PostAssignThread::run(void*)+0x29 at TREXIndexServer.cpp:522 (hdbxsengine)

7: 0x00007f40b3a5abfc in TrexThreads::PoolThread::run()+0x968 at PoolThread.cpp:274 (libhdbbasement.so)

8: 0x00007f40b3a5cd40 in TrexThreads::PoolThread::run(void*&)+0x10 at PoolThread.cpp:124 (libhdbbasement.so)

9: 0x00007f40a51750c9 in Execution::Thread::staticMainImp(void**)+0x875 at Thread.cpp:496 (libhdbbasis.so)

10: 0x00007f40a5175d2d in Execution::Thread::staticMain(void*)+0x39 at ThreadMain.cpp:26 (libhdbbasis.so)

exception  2: no.300001  (Crypto/Configuration/Configuration.cpp:223)

    Invalid SSL configuration: crypto provider 'commoncrypto' not available

exception throw location:

1: 0x00007f40a301ba46 in Crypto::Configuration::getProviderType() const+0x62 at Configuration.cpp:223 (libhdbcrypto.so)

2: 0x00007f40a2fe82e9 in Crypto::Provider::Provider::getInstance()+0x15 at Provider.cpp:81 (libhdbcrypto.so)

3: 0x00007f409a06a8f5 in Crypto::Services::AppDataEncryption::CipherAES256CryptoKernelAdapter::getProvider()+0x81 at CipherAES256CryptoKernelAdapter.cpp:58 (libhdbrskernel.so)

4: 0x00007f409a06b78f in Crypto::Services::AppDataEncryption::CipherAES256CryptoKernelAdapter::decrypt(AlgEnc, unsigned char const*, unsigned long, unsigned char const*, unsigned long, unsigned char const*, unsigned long, unsigned char*, unsigned long*)+0x4b at CipherAES256CryptoKernelAdapter.cpp:99 (libhdbrskernel.so)

5: 0x00007f409a0512f2 in dpapi::KeyMgmtApi::decryptApplKeyWithRootKey(unsigned char const*, unsigned long, dpapi::Key const&, dpapi::Key&) const+0x80 at KeyMgmtApi.cpp:789 (libhdbrskernel.so)

6: 0x00007f409a0532f7 in dpapi::KeyMgmtApi::getPlaindataFromCipherdata(dpapi::Key const&, dpapi::Key&) const+0x3a3 at KeyMgmtApi.cpp:699 (libhdbrskernel.so)

7: 0x00007f409a053802 in dpapi::KeyMgmtApi::getKeyContent(void*, ltt::basic_string<char, ltt::char_traits<char> > const&, ltt::basic_string<char, ltt::char_traits<char> > const&, unsigned char const (&) [4], dpapi::Key&) const+0x140 at KeyMgmtApi.cpp:512 (libhdbrskernel.so)

8: 0x00007f409a05a70d in dpapi::DataEncApi::checkAndExtractOuterCipherdata(void*, ltt::basic_string<char, ltt::char_traits<char> > const&, ltt::basic_string<char, ltt::char_traits<char> > const&, unsigned char const*, unsigned long, unsigned char**, unsigned char**, unsigned long&, dpapi::Key&)+0x259 at DataEncApi.cpp:695 (libhdbrskernel.so)

9: 0x00007f409a05b8e9 in dpapi::DataEncApi::decrypt(void*, ltt::basic_string<char, ltt::char_traits<char> > const&, ltt::basic_string<char, ltt::char_traits<char> > const&, unsigned char const*, unsigned long)+0x285 at DataEncApi.cpp:359 (libhdbrskernel.so)

10: 0x00007f409a069709 in Crypto::Services::AppDataEncryption::AppDataEncryptionService::decrypt(Crypto::Services::AppDataEncryption::AppDataEncryptionCaller, ltt::basic_string<char, ltt::char_traits<char> > const&, Crypto::Buffer const&, Crypto::Buffer&, ptime::Transaction&)+0x75 at AppDataEncryptionService.cpp:151 (libhdbrskernel.so)

11: 0x00007f409a063c7f in Crypto::Services::CredentialStore::CredentialStoreService::getCredentialForUser(ptime::Transaction&, Crypto::Buffer&, ltt::basic_string<char, ltt::char_traits<char> > const&, ltt::basic_string<char, ltt::char_traits<char> > const&, ltt::basic_string<char, ltt::char_traits<char> > const&, ltt::basic_string<char, ltt::char_traits<char> > const&)+0x13b at CredentialStoreService.cpp:562 (libhdbrskernel.so)

12: 0x00007f409a066cbc in Crypto::Services::CredentialStore::CredentialStoreService::getCredentialForApplication(ptime::Transaction&, Crypto::Buffer&, ltt::basic_string<char, ltt::char_traits<char> > const&, ltt::basic_string<char, ltt::char_traits<char> > const&, ltt::basic_string<char, ltt::char_traits<char> > const&)+0xc8 at CredentialStoreService.cpp:511 (libhdbrskernel.so)

13: 0x00007f409353155b in xsengine::TSmtpSettingsWithStorage<config::Configuration, Crypto::Services::CredentialStore::CredentialStoreService, ptime::Transaction>::loadSecureSettings()+0xa7 at SmtpSettingsInternalInlines.h:246 (libhdbxsapi.so)

14: 0x00007f40935317f9 in xsengine::TSmtpSettingsWithStorage<config::Configuration, Crypto::Services::CredentialStore::CredentialStoreService, ptime::Transaction>::loadSettings()+0x15 at SmtpSettingsInternalInlines.h:132 (libhdbxsapi.so)

15: 0x00007f4093530c16 in xsengine::createSmtpSettings(ltt::allocator&, config::LayeredConfiguration*)+0x92 at SmtpSettingsInternalInlines.h:118 (libhdbxsapi.so)

16: 0x00007f409358f01a in xsengine::XSIni::hookStarted()+0x16 at XSIni.cpp:326 (libhdbxsapi.so)

17: 0x00007f40be02c5ee in XSEngine::hookStarted()+0x3a at XSEngine.cpp:217 (libxsengine.so)

18: 0x00007f40be6c3a93 in TRexAPI::TREXIndexServer::postAssign(NameServer::ServiceStartInfo&)+0x70 at TREXIndexServer.cpp:1624 (hdbxsengine)

19: 0x00007f40be6f79cd in TRexAPI::PostAssignThread::run(void*)+0x29 at TREXIndexServer.cpp:522 (hdbxsengine)

20: 0x00007f40b3a5abfc in TrexThreads::PoolThread::run()+0x968 at PoolThread.cpp:274 (libhdbbasement.so)

21: 0x00007f40b3a5cd40 in TrexThreads::PoolThread::run(void*&)+0x10 at PoolThread.cpp:124 (libhdbbasement.so)

22: 0x00007f40a51750c9 in Execution::Thread::staticMainImp(void**)+0x875 at Thread.cpp:496 (libhdbbasis.so)

23: 0x00007f40a5175d2d in Execution::Thread::staticMain(void*)+0x39 at ThreadMain.cpp:26 (libhdbbasis.so)

[62734]{-1}[-1/-1] 2016-09-19 13:58:51.045740 i Service_Shutdown TrexService.cpp(00781) : Preparing for shutting service down

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.046548 i assign           TREXIndexServer.cpp(03994) : unassign from volume 2

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.046648 i Service_Shutdown TREXIndexServer.cpp(03997) : Preparing to shutdown

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.053462 i Service_Shutdown TREXIndexServer.cpp(04062) : Stopping LOBGarbageCollectorThread

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.053651 i Service_Shutdown TREXIndexServer.cpp(04083) : Stopping EPM

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.053676 i Service_Shutdown TREXIndexServer.cpp(04087) : Stopping PlanningEngine

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.053687 i Service_Shutdown TREXIndexServer.cpp(04092) : Stopping SQL session service

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.053724 i Service_Shutdown TREXIndexServer.cpp(04096) : Stopping SQL plan cache

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.453513 i Service_Shutdown TREXIndexServer.cpp(04131) : Stopping TRexApiSystem

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.453556 i Service_Shutdown TREXIndexServer.cpp(04135) : Stopping executor

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.453691 i Service_Shutdown TREXIndexServer.cpp(04139) : Stopping DebuggingBackend

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.453903 i Service_Shutdown TREXIndexServer.cpp(04143) : Stopping CalculationEngineManager

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.454066 i Service_Shutdown TREXIndexServer.cpp(04147) : Stopping TaskManager

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.454091 i Service_Shutdown TREXIndexServer.cpp(04151) : Stopping TaskStatisticsManager

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.454105 i Service_Shutdown TREXIndexServer.cpp(04155) : Stopping CacheMgr

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.847620 i Service_Shutdown TREXIndexServer.cpp(04162) : Stopping GraphEngineMgr

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.847696 i Service_Shutdown TREXIndexServer.cpp(04166) : Stopping Invalidator

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.847800 i Service_Shutdown TREXIndexServer.cpp(04170) : Stopping RClient

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.847900 i Service_Shutdown TREXIndexServer.cpp(04174) : Stopping SAMLFactory

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.850150 i Service_Shutdown TREXIndexServer.cpp(04179) : Stopping VSI runtime

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.895551 i Service_Shutdown TREXIndexServer.cpp(04191) : Stopping udivmgr

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.895590 i Service_Shutdown TREXIndexServer.cpp(04197) : Closing trace files

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.895606 i Service_Shutdown TREXIndexServer.cpp(04201) : Stopping persistenceLayer

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.895619 i Service_Shutdown TREXIndexServer.cpp(04220) : Stopping joinengine

[62853]{-1}[-1/-1] 2016-09-19 13:58:51.895636 i Service_Shutdown TREXIndexServer.cpp(04224) : Stopping libxml

[62853]{-1}[-1/-1] 2016-09-19 13:58:53.662182 i Service_Shutdown transmgmt.cc(06027) : Preparing for TransactionManager shutdown

former_member182967
Active Contributor
0 Kudos

Hi Slim,


[62847]{-1}[6/-1] 2016-09-19 13:58:50.736618 e Crypto           Configuration.cpp(00222) : Configuration::getProviderType: crypto provider 'commoncrypto' not available

[62847]{-1}[6/-1] 2016-09-19 13:58:50.736891 e Crypto           KeyMgmtApi.cpp(00714) : Error during decrypting the key-content with primary root key: Invalid SSL configuration: $ErrorText$ (Invalid SSL configuration: crypto provider 'commoncrypto' not available)

[62847]{-1}[-1/-1] 2016-09-19 13:58:50.738426 e assign           TREXIndexServer.cpp(01658) : post assign failed with ltt exception. stopping service... :

exception  1: no.2530001  (XSEngine/Connectivity/Smtp/SmtpSettingsInternalInlines.h:226)

    error loading SMTP settings

Maybe you have seen the above error message, please check if note 2099478 - Backup fails with error message: crypto provider 'commoncrypto' not available helps or not.

Regards,

Ning

slim_trabelsi
Employee
Employee
0 Kudos

Is it linked to the certificate installation ?

Knowing that the server is running since two years now ..

former_member182967
Active Contributor
0 Kudos

Hi Slim,

I think it is related to SAP Cryptographic Library.

Still, can you check the two environment variables DIR_EXECUTABLE and SECUDIR?

Environment variables in my side.

hdb03:/usr/sap/HRD/HDB05> echo $DIR_EXECUTABLE

/usr/sap/HRD/HDB05/exe

hdb03:/usr/sap/HRD/HDB05> echo $SECUDIR

/usr/sap/HRD/HDB05/sap03/sec

Regards,

Ning

slim_trabelsi
Employee
Employee
0 Kudos

Hi Ning,

for me both are empty:

root@mo-0f5ffe310:/usr/sap/SVM/HDB00 # echo $DIR_EXECUTABLE

root@mo-0f5ffe310:/usr/sap/SVM/HDB00 # echo $SECUDIR

former_member182967
Active Contributor
0 Kudos

Hi Slim,

In HANA user <sid>adm, check them again.


Regards,

Ning

slim_trabelsi
Employee
Employee
0 Kudos

I get the same empty answer under <SID>adm

best

Slim

former_member182967
Active Contributor
0 Kudos

Hi Slim,

What is your HANA version?

Try to manually set these two parameters under HANA OS user <sid>adm and start xsengine again.

Regards,

Ning