Dev Environment Down.. SQL Exception in logs

Unknown

Dev Environment Down.. SQL Exception in logs

Unknown

We have an issue that is preventing us from proceeding with development.

Yesterday evening I completed creating a new branch in the Repo and pointed one of our Dev Environments to it. It appeared ok at that time. But few hours during our periodic restart of the Decisions Service, we are unable to get the service restarted. When I looked up the Application Logs in Windows, this is what I found –

Service cannot be started. System.Exception: error bootstrapping ---> System.Exception: error running update query with LatestData as ( select id, ROW_NUMBER() over (partition by (primary_flow_tracking_id) order by flow_run_date DESC ) as row_num from flow_step_run_data ) delete from flow_step_run_data where id not in (select id from LatestData where row_num <= 50) ---> System.Exception: Error executing database command: with LatestData as ( select id, ROW_NUMBER() over (partition by (primary_flow_tracking_id) order by flow_run_date DESC ) as row_num from flow_step_run_data ) delete from flow_step_run_data where id not in (select id from LatestData where row_num <= 50) Error message: Error executing database command: with LatestData as ( select id, ROW_NUMBER() over (partition by (primary_flow_tracking_id) order by flow_run_date DESC ) as row_num from flow_step_run_data ) delete from flow_step_run_data where id not in (select id from LatestData where row_num <= 50) Error message: Execution Timeout Expired. The time...

I keep getting that on repeated attempts to start the service manually.

Unknown

Do you have SQL management studio access to this servers database? First thing I would like to try is running this query directly against the DB.
Would you be able to send us the primary logs on the server? You can find these here: C:Program FilesDecisionsDecisions Services ManagerLogs