error occurs at data-stream out in-db tool

[EnaK]

i get a random error (not always)  and looking for some help with finding a solution...

 

i tried to run the workflow for less data and still randomly get this error.

example of error itself:

Start: Designer x64: Started running C:\Users\KOVALCHE\AppData\Local\Temp\Staging\_________________GLB-Consignment.yxmd at 04/05/2024 14:09:54
Error: Data Stream Out (2838): Error SQLExecute: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;4 cannot allocate enough memory:  [9] Memory allocation failed;exception 1000002: Allocation failed ; $failure_type$=STATEMENT_MEMORY_LIMIT_FROM_USER_PARAMETER; $failure_flag$=; $size$=15518736; $name$=BitVector; $type$=pool; $inuse_count$=4627; $allocated_size$=183257752; $alignment$=16
,Exception in executor plan33950780@bwhbhpdbln301:30003 while executing pop 27
End: Designer x64: Finished running GLB-Consignment.yxmd in 1:46 minutes with 1 error

[apathetichell]

Which driver are you running and what DB are you connecting to? 

[EnaK]

HANA

[apathetichell]

https://community.sap.com/t5/technology-q-a/sap-dbtech-jdbc-4-cannot-allocate-enough-memory-details/...

There are some other posts on SAP messageboards which discuss adding a memory limit in your query itself.

[JYOTIPRAKASH_2023]

I am getting a error while using the Data Stream Out tool using Simba Driver to Oracle . Simba OracleOCU (3000) - Caller Interface :ORA-00907- Missing Parenthesis error - The rest of the workflow which uses database in and join tool works just fine . I face this issue only while out functon is executed