2051624 - Error HDB 00101: Data acquisition has failed. When using large HANA data set. Lumira Desktop

SAP Knowledge Base Article - Public

2051624 - Error HDB 00101: Data acquisition has failed. When using large HANA data set. Lumira Desktop

Symptom

  • Error "data acquisition has failed. (HDB 00101)". This happens after all the data has been downloaded and after step "finalyzing".
  • Exception caught while expanding DBSpace in log file.
  • Following errors are also captured in the log file:

- 2014/08/01 11:10:13.027000|==|S| | 7100|  44| |||||||||||||||[com.sap.hilo.common.hana.AbstractHanaDBHelper]SAP DBTech JDBC: [257] (at 8): sql syntax error: aggregation with ALL/DISTINCT supports up to 1 argument: line 1 col 8 (at pos 8)

2014/08/01 11:24:50.542000|>>|S| | 7100|  60| |||||||||||||||[com.sap.hilo.engine.sybase.SybaseDBSpaceMonitor]Exception caught while expanding DBSpace

java.sql.SQLException: [Sybase][ODBC Driver][Sybase IQ]Filename does not exist. File: C:\Users

u13232\AppData\Local\SAP\Lumira\DataBase\hilomain2.iq

 

Then:

- 2014/08/01 11:24:50.544000|>>|S| | 7100|  60| |||||||||||||||[java.lang.Class]

*** SQLException caught ***SQLState: HY000

Message:  [Sybase][ODBC Driver][Sybase IQ]You have run out of space in IQ_SYSTEM_MAIN DBSpace.

-- (s_blockmap.cxx 4723)

Vendor:   -1009170

 

- 2014/08/01 11:24:50.544000|>>|S| | 7100|  60| |||||||||||||||[com.sap.hilo.engine.sybase.SybaseDBHelper]

java.sql.SQLException: [Sybase][ODBC Driver][Sybase IQ]You have run out of space in IQ_SYSTEM_MAIN DBSpace.

Environment

  • Lumira 1.x
  • Supported HANA online

Cause

The computer's disk swap is maxed out.

Resolution

Try this to increase the cache size by modifying:

 

C:\Users\<user>\AppData\Local\SAP\Lumira\DataBase\params.cfg to

 

-c 2048m

-gc 20

-gd all

-gl all

-gm 100

-gp 4096

-ti 4400

-iqtc 2048

-iqmc 2048

 

 

 

Default was:

-c 1024m

-gc 20

-gd all

-gl all

-gm 100

-gp 4096

-ti 4400

-iqtc 500

-iqmc 500

 

 

Make sure you close and restart Lumira Desktop after the change. Then you will probably see the hilomain2.iq file being created.

Keywords

HDB_00101 , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem

Product

SAP Lumira, desktop edition 1.0