Data Loss using data-stream Out in-db tool

[EnaK]

I have an issue with data stream out in-db tool and was wondering if anyone has a solution:

it is randomly losing data, example below shows same filters applied but different output as a result before and after data stream out used: 

[EnaK]

thank you very much for all your help and ideas, i will definitely share what I find :)

[EnaK]

It looks like it has to do with the amount of data 

[CodyConner]

Hi, I am currently experiencing the same issue. What was your resolution?

[apathetichell]

@CodyConner - are you on S4/Hana - @EnaK was. Most common explanation is user error. @CodyConner can you share screen shots like @EnaK did?

[CodyConner]

@apathetichell I can show the basic issue. As @EnaK  said in the last post, I am pretty certain it is a Hana issue.

[apathetichell]

Yeah - not really sure here. I'd recommend enabling logging and then looking at the odbc logs for what's pulled out. I'd then try to identify specific line items which are not coming through to the canvas and try to see if they have anything in common.

[Alder]

Same exact issue with and without AMP.

This is ridiculous, tested also on other softwares that we have at work and they actually extract all the rows correctly without any data loss.

[Alder]

Preview here:

 

[apathetichell]

@Alder which version of Alteryx are you running? can you add a record id tool to both sides -> add a count distinct on the reocrdid tool? It's deifnitely odd behavior - and not something I've seen with the DBs I use regularly (Databricks/Snowflake/Redshift/Postgres/BigQuery).

[Alder]

I will answer tomorrow as I have left the office just now.