SAP Knowledge Base Article - Preview

2978483 - Importing CSV file takes long time

Symptom

If it takes longer time than usual to import CSV file and you can see threads for IMPORT task in status
 "Semaphore Wait CSV_Import_MemoryLimit_Semaphore"  and "Semaphore Wait CSV_Import_WorkerRun_Semaphore".

You can also check these thread status by script  HANA_SQL_StatementHash_DataCollector_2.00.040+.txt with the statement hash of IMPORT statement.

"Images/data in this KBA from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 


Read more...

Environment

  • SAP HANA Platform Edition 1.0 
  • SAP HANA Platform Edition 2.0 

Product

SAP HANA, platform edition all versions

Keywords

CSV import, CSV file, import, slowness, long time , KBA , HAN-DB , SAP HANA Database , 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.