I have a view with 11017 records and I'm trying to export this data to csv via Export Data Store Entity to CSV smart service. The issue is that it exports only 11015 records and the file size is around 200KB
Discussion posts and replies are publicly visible
does your view have a primary key? I would suggest checking the view, this might be causing the issue. You can find more suggestions here:
https://docs.appian.com/suite/help/23.1/Export_To_CSV_Smart_Service.html#avoiding-query-timeouts-when-exporting-data
No, my view doesn't have a primary key. So I did try assigning the primary key but interestingly the smart service started exporting more than 173430+ records and throws an error while the view has only 11017 records.
I used row_number() as the primary key which for some reason generated 173430+ records. So instead I have used 2 ID columns from the table to create a primary key in the view and that solved the problem