Alteryx In-DB Bulk Load, discrepancy in the Row Count

[saiirangam]

Hi Everyone, 

I have come across a strange scenario right now with the IN-DB tools. Appreciate your thoughts and ideas to fix this. 

Manual Effort :  There is one SQL query need to be run for each month for last 5 years, we can run only query at a time due to long running queries because of huge data for each month (around 60,00,000 records each time) 

Alteryx solution: I have created a batch macro to run all the 60 SQL's one after another its saving lot of time and manual intervention to run the SQLs too.

Problem:  When I compare the manually load data counts with Alteryx generated tables, I see discrepancy in the counts for the months which has only 30 days and for months which has having 31 days the count is matching exactly.

when I run the same query in Oracle instance the count is matching with required count but not matching when I run the same SQL in the Alteryx.

[FrederikE]

@saiirangam,

Does your batch macro call all the different months, or does it always just call one month (the one specified in the macro), but multiple times?

Often happens with batch macros when there is something wrong in the setup and could explain the behavior. 

[saiirangam]

@FrederikE   My batch macro will run all the months One by one and also it will trigger me an email once it is run for each month , Macro configuration is working fine I feel.

[apathetichell]

Can you share your query and the configuration of your action tool in your batch macro? Sounds like something is off with one of them.