Hi, I'm trying to use the GenerateTableFetch component for 'MS SQL 2012+' database - for a full table export each time its run. However I'm forced to set a column name in the 'Maximum-value Columns' field when the component is run (error only shows during execution if I omit this setting). I'm seeing the following error: IllegalArgumentException: Order by clause cannot be null or empty when using row paging
So it looks like it only works with incremental mode - which I don't want. Can someone see why this is the case or is it a bug? I'm not getting this error if I set the database type to 'Generic' - but unfortunately the sql it generates isn't valid for MS SQL server. I'm using Nifi v1.3.0 Thanks, Bryan --- Bryan Quinn | Asavie Principal Analytics Architect E: [email protected]<mailto:[email protected]> W: www.asavie.com<https://outlook.office.com/owa/www.asavie.com> | T: @asavie
