SAP Knowledge Base Article - Preview

2733984 - Column profile error on large HANA table - Information Steward

Symptom

  • [E] 2018-11-28 11:08:26.747 [TaskUtility][pool-5-thread-1] (14.2) 11-28-18 11:08:17 (R) (13936:14264) DBS-070407: |Data flow DF_SPF_NP_opt_2601_1|Reader PROFILE_OUTPUT
                                                           SQL submitted to database <> resulted in error <[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search
                                                           table error:  [2620] "sourcetablename": line 71 col 1 (at pos 17430): [130] (range 2) InternalFatal
                                                           exception: exception 1000002:
                                                           ltt/impl/memory.cpp:86
                                                           Allocation failed ; $size$=609690760; $name$=libhdbcs.so; $type$=pool; $inuse_count$=674666; $allocated_size$=28865862312
                                                           >. The SQL submitted is <SELECT * FROM "sourcetablename">.
  • Cannot profile a table with hundreds of millions of rows.
  • Memory allocation issue.
  • HANA out of memory issue.
  • Profiling a large table with over 100 million records fails.


Read more...

Environment

  • SAP Information Steward
  • SAP HANA

Product

SAP Information Steward 4.2

Keywords

memory, alloc , KBA , EIM-IS-DI , Information Steward - Data Insight , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

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