Forum Discussion
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.
Hi v-ssriganesh
Thank you for replying, are you able to tell me how to access the Operations Manager event log on MS Fabric Datawarehouse?
- I have just turned on MS Fabric and 5 minute later, the morning ETL stats, so ressources is not a problem as Lookup is the first step of the process. This ETL used to work with no issue for about 3 months without issue
- Query is very simple - returning up to1 row, 5 columns as a select statement :
SELECT * FROM [dbo].[Pipeline_Run_Status] WHERE is_running = 'Y'- I have started manually the pipeline when getting to work this morning and lookup worked with no issue. It seems a delay in MS Fabric DW being ready upon starting MS Fabric capacity?
v-ssriganeshCommunity Support
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.