SMS_POLICY_PROVIDER message id 620

Hello,

I have installed system center 2012 SP1 anf SQL server 2008 in another server. I have a problem with SMS_POLICY_PROVIDER component. 

Microsoft SQL Server reported SQL message 266, severity 16: [25000][266][Microsoft][SQL Server Native Client 11.0][SQL Server]Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1. : sp_UpdatePolicyTargetingMap

Please refer to your Configuration Manager documentation, SQL Server documentation, or the Microsoft Knowledge Base for further troubleshooting information.

in policypv log

*** exec sp_UpdatePolicyTargetingMap 16777230 SMS_POLICY_PROVIDER 18.10.2013 09:48:17 6348 (0x18CC)
*** [42S22][207][Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'CollectionID'. : sp_UpdatePolicyTargetingMap SMS_POLICY_PROVIDER 18.10.2013 09:48:17 6348 (0x18CC)
*** exec sp_UpdatePolicyTargetingMap 16777230 SMS_POLICY_PROVIDER 18.10.2013 09:48:17 6348 (0x18CC)
*** [25000][266][Microsoft][SQL Server Native Client 11.0][SQL Server]Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1. : sp_UpdatePolicyTargetingMap SMS_POLICY_PROVIDER 18.10.2013 09:48:17 6348 (0x18CC)
UpdatePolicyTargetingMap: could not process the Updated Policies SMS_POLICY_PROVIDER 18.10.2013 09:48:17 6348 (0x18CC)

who can tell how to fix this error?

October 18th, 2013 7:07am

Which version of SQL have you installed? SQL 2008 without a service pack would not be supported: http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLDBconfig
Free Windows Admin Tool Kit Click here and download it now
October 18th, 2013 7:18am

I had the same SMS_POLICY_PROVIDER component errors (Message ID 620) in our SCCM 2012 R2 environment running on SQL 2008 Standard R2.  The issue was not related to SQL version/build, rather a typo in the stored procedure "sp_UpdatePolicyTargetingMap".  The component errors were directly related to our Application Catalog and a recent inability to display new software deployments to user groups.

Correcting the following typo (CollecitonID) in "sp_UpdatePolicyTargetingMap" immediately resolved the SMS_POLICY_PROVIDER component errors as well as our ability to display new software deployments to user groups.

MERGE INTO PolicyTargetingChg_Notify T
      USING
      (
          SELECT @CollectionID, D.PADBID, CAST(3 AS TINYINT) AS Op, CAST(0 AS BIT) AS Flag   
          FROM #DelPolicies D   
      ) S (CollecitonID, PADBID, Op, Flag)
      ON T.CollectionID = S.CollectionID AND T.PADBID = S.PADBID AND T.Flag = S.Flag   
      WHEN MATCHED THEN   
          UPDATE SET Op = S.Op   
      WHEN NOT MATCHED BY TARGET THEN   
          INSERT (CollectionID, PADBID, Op, Flag)   
          VALUES (S.CollectionID, S.PADBID, S.Op, S.Flag);

April 22nd, 2014 10:24pm

Hi ChadDumpert,

i've edited the sp but still getting the same error...any other recommendations...

thanks

M.Zakaria

Free Windows Admin Tool Kit Click here and download it now
June 15th, 2014 1:22pm

Keep in mind that it's not supported to edit anything in the database manually.
June 15th, 2014 1:50pm

Hi Torsten,

so, how to make the above editing automatically??

thanks 

Free Windows Admin Tool Kit Click here and download it now
June 16th, 2014 7:54am

You can't. Open a call at Microsoft instead.
June 16th, 2014 8:08am

What? I found the typo in the procedure and corrected with a simple Alter. The error went away. You're not altering data, just the proc.
Free Windows Admin Tool Kit Click here and download it now
June 4th, 2015 4:14pm

That does not change the fact that this is unsupported.
June 4th, 2015 7:05pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics