Lookup task on Datawarehouse execution issue since 1 Jan 2025

Hi Testaaaaaa,

Thank you for your follow-up. To access the Operations Manager event log on MS Fabric Datawarehouse, you can follow this step:

• On your Datawarehouse server, open the Event Viewer application.In the Event Viewer, expand the "Applications and Services Logs" section, then look for "Operations Manager". This log will contain errors and events related to the Datawarehouse.

Regarding the delay you're experiencing, it seems like the MS Fabric Datawarehouse might need some additional time to fully initialize after starting the capacity. Here are a few suggestions to address this:

• Try increasing the time between starting the MS Fabric capacity and the beginning of your ETL process. This will give the Datawarehouse more time to be fully ready.
• Ensure that the resources allocated to the Datawarehouse are sufficient and that there are no bottlenecks during the initialization phase.
• Verify if there are any updates or patches available for MS Fabric that might address this initialization delay.

Since your query is simple and works fine when manually started, it indicates that the issue is likely related to the readiness of the Datawarehouse rather than the query itself.

If you find this information helpful, kindly accept it as a solution and leave a "Kudos" to aid other members in locating it more easily.
Thank you.