Data Loss using data-stream Out in-db tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
- Labels:
- Bug
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you very much for all your help and ideas, i will definitely share what I find :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It looks like it has to do with the amount of data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I am currently experiencing the same issue. What was your resolution?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@CodyConner - are you on S4/Hana - @EnaK was. Most common explanation is user error. @CodyConner can you share screen shots like @EnaK did?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@apathetichell I can show the basic issue. As @EnaK said in the last post, I am pretty certain it is a Hana issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Preview here:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I will answer tomorrow as I have left the office just now.
