PENDING Error when creating deployment

[goody]

Just stared to receive the following error when creating deployments in SCCM. Below is the error we are getting in the deployment creation wizard. I have also checked the SMSPROV log, but it basically lists the same details. I have attached the section from that log as well.

Error: Software Deployment Failed [ConfigMgr Error Object:
instance of SMS_ExtendedStatus
{
CauseInfo = "";
Description = "SQL command failed: declare @t StringIntList; ; EXEC spProcessPolicyBinding @t, 16779810 ";
ErrorCode = 2168851714;
File = "..\\ssputility.cpp";
Line = 1879;
ObjectInfo = "Please check SMS Provider log file for details of the SQL errors";
Operation = "PutInstance";
ParameterInfo = "";
ProviderName = "ExtnProv";
SQLMessage = "[42000][4121][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot find either column \"dbo\" or the user-defined function or aggregate \"dbo.fn_IsAfwAppConfigCI\", or the name is ambiguous. : spProcessPolicyBinding";
SQLSeverity = 16;
SQLStatus = 4121;
StatusCode = 2147749889;
};]

 

[Prajwal Desai]

never seen this error before. Do you see this deployment error for every new deployment ?.

 

[goody]

Yes every deployment that we try to create.

 

[Garth]

If it just started what changed within SQL? aka did your SQL admins touch anything within CM? Did you apply any udpates? etc...

 

[goody]

That's what we have been looking into, but they are stating that nothing has changed. Trying to dig more on that side as I find it hard to believe that nothing changed.