Error: "Patch integration in progress" when validating a folder

There is a patch running on another folder, or an update previously failed without updating status correctly

CAUTION: Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.

Since V12 patch 26 additional checks were introduced. In essence the process is checking for the following SQL to return some data, and if so will block ANY folder validation, patch, etc. until the one that is running completes (with or without errors)

SELECT [UPDSEQ_0] "Sequence No"
,[AFOLDER_0] "Folder"
,[UPDTYP_0] "Update type" -- 1=Standard, 2=Hotfix
,[UPDINTREL_0] "Release"
,[UPDSTATUS_0] "Integration Status" -- 1=Control OK, 2=In Progress, 3=Ended, 4=n/a, 5=Error, 6=Warnings
,[GENSTATUS_0] "Generation Status"
,[UPDPROCESS_0] "Process type" -- 1=Integration, 2=Validation, 3=Import, 4=Restoration
,[FOLDERSYNC_0] "Deferred Validation"
,[UPDLOGFIL_0] "Log file 1"
,[UPDLOGFIL_1] "Log file 2"
,[ENDDATTIM_0] "End date"
,[CREDATTIM_0] "Created"
,[UPDDATTIM_0] "Updated"
,[CREUSR_0] "Create user"
,[UPDUSR_0] "Update user"
FROM [X3].[AUPDATE]
where UPDPROCESS_0 = 1 and (UPDSTATUS_0 = 1 or UPDSTATUS_0 = 2)
order by [AFOLDER_0] ASC, [UPDTYP_0] ASC, [UPDINTREL_0] ASC, [UPDSEQ_0] ASC

If the above SQL return data you should check for a previous validation or patch application on one of the folders in the instance to see if it has hung/not completed correctly for some reason.

If you are certain there is no current patching or other validations ongoing, you may need to manually reset the UPDSTATUS_0 value to "Error" rather than "In progress" in order to proceed.