SAP HANA – rename system, part 1/2
SAP HANA system can be renamed by changing the system identifiers, like host names, SID and instance number. Below You find information how to do this…
Read MoreSAP HANA – sapstartsrv service not started
The HANA system shows yellow status in the Systems View of the SAP HANA Studio with error ‘sapstartsrv’ service not started. This indicates that sapstartsrv cannot be reached.
SAP HANA – Prefetch timed out error
When You run a replication task or an activity of large tables in HANA Smart Data Integration sometimes You receive below error:
[119944]{352621}[136/-1] 2021-XX-09 09:55:04.182041 e MonitorView DPAdapterLocationsMonitor.cc(00196) : Request for adapters' configuration for agent : 'AGENT_NAME' failed with error :
[115205]{350872}[146/-1] 2021-XX-09 09:57:05.163932 i TraceContext TraceContext.cpp(01269) : UserName=USERNAME, ApplicationUserName=USERNAME, ApplicationName=sap.hana.im.dp.monitor.jobs::scheduleTask, ApplicationSource=sap.hana.im.dp.monitor.jobs:ScheduleObject.xsjs::doScheduleObject, StatementHash=b04ef094eb43b5643057befc019e3123, StatementExecutionID=844438624279623
[115205]{350872}[146/-1] 2021-XX-09 09:57:05.163917 e DPAdapterManager AdapterManager.cpp(04668) : ::sendMessage: Prefetch timed out.
[115205]{350872}[146/-1] 2021-XX-09 09:57:05.164020 e FedTrace DPAdapterAccess.cpp(02401) : DPAdapterAccess::ExecuteQuery: failed with error: Prefetch timed out.
Read More
SAP HANA – a data backup cannot be created because another data backup is running
You are trying to run a HANA backup but receive error: “A data backup cannot be created because another data backup is running or a storage snapshot has been prepared” like on below screen:
Read MoreSAP HANA – Replicated table with LOB columns is much bigger than in source system
In last time I observed in HANA system worrying growth a table replicated by SDI which size is now above 100GB. The table at source system is only 2.8GB. It’s worth noting:
- DB source is MSSQL;
- three of the columns are NCLOB datatype;
- We reduced the size of the table by implementing note: 2950474 but the size is growing again.