Pagination not working

I have had some success after changing a few things, but not quite there yet.
I get data in DWH, but the execution job stops with this error: 
 

Failed to execute endpoint 'GetCases':
Pagination for endpoint 'GetCases' stopped due to hitting configured max limit of 60 pages. Please increase limit.

Total results: 29532
Maximum pages are 60
Results per page: 1000

    "pagination": {
        "total": 29532,
        "pages": 60,
        "page": 1,
        "pagesize": 1000
    }

For my Override Pagination settings:
 
stopCondition:  /*/*/pagination[page != pages][1]
i have also tried: 
stopCondition: (*/*/*)[1]

Max number of pages: 1000
page:  {TX_NextPage} 
pageSize = 500

I am caching to file, and all the raw file are identical 

I have to open this on again and need some help , ​@Thomas Lind 
The data stream stops at this:

{
    "pagination": {
        "total": 47480,
        "pages": 16,
        "page": 17,
        "pagesize": 3000
    },
    "data": {
        "cases": null,
        "total": 0
    }
}

I have tried these two stopConditions:
 /*/*/data/cases[1] 
/*/*/data/total[1]

In my logs, i can see that 20 files have been created.

Each files has upto 3000 records
The last file () looks like this:

{
  "pagination": {
    "total": 47480,
    "pages": 16,
    "page": 20,
    "pagesize": 3000
  },
  "data": {
    "cases": null,
    "total": 0
  }
}

Its still not working.
I keep on getting:

Failed to execute endpoint 'GetCases':
Pagination for endpoint 'GetCases' stopped due to hitting configured max limit of 20 pages. Please increase limit.

I have tried Max. number of pages as 0, but then it doesnt stop
The number of log files keep on increasing

 

I have spend a couple of more hours on this with the same result. 
I have now created a ticket

After couple of hours of testing, i have resolved the issue. Though i dont know how and i am hoping that someone can shed some light.

Why did Genric worked while flatning the table, and not Column?

When flatning the table, i have used Genric instead of Column (for my previous flattened tables i have used Column):
 

Instead of Override Pagination, i have used Query to define Dynamic values:
 

WITH Numbers AS
(
    SELECT 1 AS pageNumber

    UNION ALL

    SELECT pageNumber + 1
    FROM Numbers
    WHERE pageNumber < 20
)
SELECT pageNumber
FROM Numbers
OPTION (MAXRECURSION 20);