Invalid sub status of 'None' when deploying a GPO or OU in GPOADmin (4361441)

Invalid sub status of 'None' when deploying a GPO or OU in GPOADmin

When working with GPOADmin, you may run into a problem where the deployment or import of a GPO or OU in GPOADmin gets interrupted with the following error:

Invalid sub status of 'None'.

When this issue occurs it appears that the deployment happens correctly, however, at the end of the deployment, the last approval information is not being removed from the object in our configuration store. This leads the UI to believe we are in a state where the approvals are complete and we should be pending deployment, when in fact we have deployed the object. As a result, a second attempt to deploy will see the "Invalid substatus of None" error as there are no operations to perform on the object (it has been deployed).

Please contact technical support if you have had debug logging inside the GPOADmin Options available before the issue occurred. If you ran into the problem without debug logging enabled, enable debug logging now via the GPOADmin Options. Should you experience the issue again, please send the debug logs to technical support.

 

Workaround for SQL configuration store

The SQL command below must be run in SQL Management Studio targeted at the GPOAdmin database. If you are not using the default [GPOADmin] database name, change this to the correct name in the USE statement below. The GPOADmin GUID referenced in the command must be the GPOADmin GUID that can be seen by right-clicking on an item with this issue in the UI.

Note that this SQL will return the item to an available state before any approvals were done. After the script is completed, you will have to restart the approval and deployment process for any item whose state has been corrected.

Included a commented-out example where the clause shows how this should look.

----- Start SQL -----

 USE [GPOADmin]

 GO

 UPDATE [dbo].[ObjectData] 

SET [StatusID] = 1

  , [SubStatusID] = 0

, [ApprovalStageIndex] = 0

, [ApprovalStageCount] = 0

, [ApprovalWorkflow] = NULL

, [TrusteeSID] = NULL

, [ApprovalRequesterSID] = NULL

, [ActionAuthenticationID] = NULL

, [IsDeploying] = 0

, [ApprovedByList] = NULL

 WHERE [VersionControlID] = 'GPOADmin GUID Without Braces'

 

 -- Example where clause: WHERE [VersionControlID] = 'b0b28b3c-97b8-489c-b436-4774716f0422' --

 

----- End SQL -----

 

Workaround for AD/LDS configuration store