Vickie Ortega  

Thanks for the prompt response, so according to our DBA manager, there are no errors in any database logs or event viewers. The behavior observed is indicative of either a deadlock situation or complete consumption of system resources. In each instance, our DBA team intervened to mitigate the issue before it escalated.

I checked the activity log and it ends with this error:

INFO -- Verifying endpoints...
INFO -- The environment endpoint "MoveRecordOnCheckIn" was reachable.
INFO -- The environment endpoint "MoveRecordOnValidation" was reachable.
INFO -- The environment endpoint "MoveRecordOnCheckOut" was reachable.
ERROR -- The environment endpoint "StandardNotificationReceiver" was not reachable.

Activity Summary
===============================================
User: ------------
Version: 1,878
Label: Version 1.4714.060
Destination Environment: PROD Environment
Server time zone: Mountain Daylight Time (America/Denver)
Start time: 5/23/24 6:17 PM
Stop time: 5/23/24 6:17 PM
Total time: 0 min, 7 sec
Status: failed
===============================================

it sounds like it is not a SQL database issue as they stated. And the application deployment failed seven seconds after it was launched, as shown in the activities log, which I think is not enough to make that load on the server resources. A few months ago I added three new fields to the same table with some default values and it has been deployed successfully, but usually, I dont use that "Verify endpoints" option.

Vickie Ortega  

Thanks for the prompt response, so according to our DBA manager, there are no errors in any database logs or event viewers. The behavior observed is indicative of either a deadlock situation or complete consumption of system resources. In each instance, our DBA team intervened to mitigate the issue before it escalated.

I checked the activity log and it ends with this error:

INFO -- Verifying endpoints...
INFO -- The environment endpoint "MoveRecordOnCheckIn" was reachable.
INFO -- The environment endpoint "MoveRecordOnValidation" was reachable.
INFO -- The environment endpoint "MoveRecordOnCheckOut" was reachable.
ERROR -- The environment endpoint "StandardNotificationReceiver" was not reachable.

Activity Summary
===============================================
User: ------------
Version: 1,878
Label: Version 1.4714.060
Destination Environment: PROD Environment
Server time zone: Mountain Daylight Time (America/Denver)
Start time: 5/23/24 6:17 PM
Stop time: 5/23/24 6:17 PM
Total time: 0 min, 7 sec
Status: failed
===============================================

it sounds like it is not a SQL database issue as they stated. And the application deployment failed seven seconds after it was launched, as shown in the activities log, which I think is not enough to make that load on the server resources. A few months ago I added three new fields to the same table with some default values and it has been deployed successfully, but usually, I dont use that "Verify endpoints" option.