Issues with pre aggregation scheduled refresh workers

Hi there, I want to have scheduled refreshing for multiple schemas. But my refresh worker only seems to be refreshing the pre ags for one schema
My pre ags look like this:
note: certain details are obfuscated

daily: {
    sqlAlias: `15m_daily`,
    type: `rollup`,
    external: true,
    measureReferences: [...],
    dimensionReferences: [...],
    timeDimensionReference: ...,
    granularity: "day",
    partitionGranularity: "year",
    scheduledRefresh: true,
    refreshKey: {
        every: `15 minute`,
        incremental: true,
        updateWindow: `7 day`
    },
},
hourly: {
    sqlAlias: `15m_hourly`,
    type: `rollup`,
    external: true,
    measureReferences: [...],
    dimensionReferences: [...],
    timeDimensionReference: ...,
    granularity: "hour",
    partitionGranularity: "month",
    scheduledRefresh: true,
    refreshKey: {
        every: `1 hour`,
        incremental: true,
        updateWindow: `7 day`
    },
},

it’s the same across multiple schemas. Is the cause of the issue the fact that the sqlAlias’s are the same?

Welcome @shaariqchpkf to the Cube.js forum :smiley: I believe @artyom also responded to you on Slack, but pasting his response here so others can see it as well.

One common issue is when pre-aggregations take too long to build which leads to an infinite loop and refresh worker can’t pick up some pre-aggs to build at all. Could you please check your database execution time for pre-aggs?