Random Database Deployment error 24R2- IFS remote deployment

Something to consider might be whether a non-IFS process is getting in the way at the server level, such as antivirus or UAC, which is delaying the deployment and resulting in incomplete transactions that then result in locks.  Possibly either on the Apps Server or the DB side.

I used to get timeouts that manifested in strange ways when AV was running and scanning.  If it is something like this you should be able to turn it back on again as needed after deployment.

Hi ​@NuwanK,

You can add the following to your list of troubleshooting steps

1. Make sure all scheduled tasks and background jobs are stopped before the delivery process.

Follow the below steps to turn off scheduled tasks:
-Go to 'System Parameters' > Filter for 'Scheduled tasks process startup' parameter > Set to 'OFF'

Disable ongoing DB processes:
-Go to 'Database Processes' window > Filter all jobs in 'Scheduled' state and use 'Break' command

2. Perform both database and middle tier restart

If the issue keeps happening, it is best to raise a Support case to investigate this in detail.