Hello there! I'm encountering a problem with the creation of phased deployment on my SCCM.
For a week now, when i create a phased deployment, SCCM doesn't create automatically the associated deployment in the tab deployment.
So i did as it follows:
- Clean up and free some space on the sccm server.
- Reboot both the SCCM server and the SCCM DB Server following the best practice.
- Reboot (many times) the component SMS_BUSINESS_APP_PROCESS_MANAGER.
- Change the package deployed and the collection affected by it.
- Delete the phase deployment directly from the db by query.
The problem still persist...
So i checked the SMS_PhasedDeployment logs and the only thing i found is this error:
<![LOG[Exception: System.Data.SqlClient.SqlException (0x80131904): A trigger returned a resultset and/or was running with SET NOCOUNT OFF while another outstanding result set was active.
*(Multiple "at System.data.sqlclient...")*
Error Number:523,State:12,Class:16 ]LOG]!><time="02:55:51.9633512" date="2-24-2025" component="SMS_BUSINESS_APP_PROCESS_MANAGER_PhasedDeploymentWorker" context="" type="3" thread="195" file="">
Also, i checked in the DB in the table dbo.PhasedDeployment and found that the new phased i've created has NULL in the value "LastEvaluateTime"...
Looks like something's off with the Phased Deployment Evaluation...
Any hint?
For a week now, when i create a phased deployment, SCCM doesn't create automatically the associated deployment in the tab deployment.
So i did as it follows:
- Clean up and free some space on the sccm server.
- Reboot both the SCCM server and the SCCM DB Server following the best practice.
- Reboot (many times) the component SMS_BUSINESS_APP_PROCESS_MANAGER.
- Change the package deployed and the collection affected by it.
- Delete the phase deployment directly from the db by query.
The problem still persist...
So i checked the SMS_PhasedDeployment logs and the only thing i found is this error:
<![LOG[Exception: System.Data.SqlClient.SqlException (0x80131904): A trigger returned a resultset and/or was running with SET NOCOUNT OFF while another outstanding result set was active.
*(Multiple "at System.data.sqlclient...")*
Error Number:523,State:12,Class:16 ]LOG]!><time="02:55:51.9633512" date="2-24-2025" component="SMS_BUSINESS_APP_PROCESS_MANAGER_PhasedDeploymentWorker" context="" type="3" thread="195" file="">
Also, i checked in the DB in the table dbo.PhasedDeployment and found that the new phased i've created has NULL in the value "LastEvaluateTime"...
Looks like something's off with the Phased Deployment Evaluation...
Any hint?
