Customer recently upgraded to Service Pack 1 for Symantec Management Platform (SMP) 7.1. If you upgrade from SMP 7.1 MP1 to 7.1 SP1, either does not create or delete 'spGetWindowsAccountsWithNoADResourceKeys'. This causes AD imports to fail during run time. It seems that a fresh install of 7.1 SP1, does have this stored procedure. When you run a Full AD import, you may see the error below.
Description: While DoDirectoryImportTask for import rule Import Role and Account resources from test.domain, from Domain Admins/Users, Domain Computers/Users, Domain Users/Users and using the default column mappings. Perform this import on the specified schedules. (d749ca3e-ef02-43e5-b55e-ef0bb8bf8adf) System.Data.SqlClient.SqlException caught in DoDirectoryImportTask. Reason: Could not find stored procedure 'spGetWindowsAccountsWithNoADResourceKeys'.
Under investigation. Missing 'spGetWindowsAccountsWithNoADResourceKeys' on upgrade from SMP 7.1 MP1 to 7.1 SP1.
Symantec Corporation has acknowledged that the above-mentioned issue is present in the current version(s) of the product(s) mentioned on this article. Symantec Corporation is committed to product quality and satisfied customers.
This issue is currently under investigation by Symantec Corporation. Pending the outcome of the investigation, this issue may be resolved by way of a patch or hotfix in current or future revisions of the software. However, this particular issue is not currently scheduled for any release. If you feel this issue has a direct business impact for you and your continued use of the product, please contact your Symantec Sales representative or the Symantec Sales group to discuss these concerns. For information on how to contact Symantec Sales, please see http://www.symantec.com
WORKAROUND: The workaround for this issue is to manually create the missing stored procedure. Run the following query to recreate it: