Error when trying to create a new collection "Form that is already visible cannot be displayed as a modal dialog box"

Error when trying to create a new collection

Getting below error when creating a New collection.

Form that is already visible cannot be displayed as a modal dialog box

Error Code Below

ConfigMgr Error Object:
instance of SMS_ExtendedStatus
{
CauseInfo = "11";
Description = "Unable to update parent collection due to SQL error.";
ErrorCode = 3242722566;
File = "e:\\nts_sms_fre\\sms\\siteserver\\sdk_provider\\smsprov\\sspcollection.cpp";
Line = 766;
ObjectInfo = "Adobe ;
Operation = "PutInstance";
ParameterInfo = "";
ProviderName = "ExtnProv";
SQLMessage = "[HYT00][0][Microsoft][ODBC SQL Server Driver]Timeout expired";
SQLSeverity = 0;
SQLStatus = 0;
StatusCode = 2147749889;

Suggested Steps To check

1. Restart the console, log out and log back in,

2. Check in the Smsprov.log file for SQL related Errors 

3. Reboot the SCCM Server

4. Try Increasing the tempdb size from 10MB to 100MB 

5. Check with the SQL Team for to see  DDL Auditing is turned on

6. See if the last collection value of CollectionsID and NextCollectionID are in series

     If value of CollectionsID in collections table is 101, and the value of NextCollectionID in nextids table is should be102.

  Select * From Collections 

  Select * from Nextids

7. But still getting the error in smsprov.log file

"e:\nts_sms_fre\sms\siteserver\sdk_provider\smsprov\sspcollection.cpp(766) : Unable to update parent collection due to SQL error."

 I would recommend opening a ticket with Customer 

 Support.