none
Audience Targetting not working even though audiences are compiling correctly

    Question

  • I am having a problem with audience targetting. I can compile an audience fine. I t doesnt have any errors and it shows up the correct users assigned to that group.

    However when I assign the target audience to a Web Part or Navigational item, the web part just dissapears and is not shown, as if I am not actually in the group. I have checked and my user is deffinatly in the group which has compiled. I have even tried other users and on different computers.

    So far I have been unable to get audience targetting to work from the MOSS Farm, which is running all on Server 2008 (Virtual machines running on Hyper-V), whereas an older Farm running off 2003 has no problems with audience targetting.

    I saw another thread which advised me to change the SID of all the farm servers, which I have done but it hasnt made a difference.

    Any help would be very much appreciated.

    Thanks,

    Shaun Rudge
    • Moved by Mike Walsh FIN Monday, September 14, 2009 4:48 AM admin q (From:SharePoint - Design and Customization)
    Thursday, September 10, 2009 12:29 PM

All replies

  • I have been looking through the logs and I am getting this error every time a user tries to view a page with a webpart on which has audience targeting enabled:

    GetUserAudienceIDs::GetUserAudienceIDs() : siteURL=http://wgs-moss-01:22201/ssp/admin GetUserAudienceIDs::GetUserAudienceIDs() : Retrieving user audience list has encountered an error. AccountName=OURDOMAIN\USERNAME, Error code = 8145

    Its like all the users are supposed to have access to something, which they dont currently.

    Any help please?
    Friday, September 11, 2009 11:26 AM
  • Here is a full copy of the errors in the log:

                            880i High     System.Data.SqlClient.SqlException: @GetAudiences is not a parameter for procedure Orgle_GetUserOrgleList.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()     at System.Data.SqlClient.SqlDataReader.get_MetaData()     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(... 
    09/11/2009 14:21:04.69* w3wp.exe (0x0944)                        0x0A88                                484                            880i High     ...CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)     at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior) 
    09/11/2009 14:21:04.69  w3wp.exe (0x0944)                        0x0A88                                484                            880j High     SqlError: '@GetAudiences is not a parameter for procedure Orgle_GetUserOrgleList.'    Source: '.Net SqlClient Data Provider' Number: 8145 State: 1 Class: 16 Procedure: 'Orgle_GetUserOrgleList' LineNumber: 0 Server: 'WGS-SQL-01' 
    09/11/2009 14:21:04.69  w3wp.exe (0x0944)                        0x0A88                                484                            880k High        at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command)     at Microsoft.Office.Server.UserProfiles.DBHelper.RunSqlCommand(SqlCommand command)     at Microsoft.Office.Server.Audience.SQLWrapper.RunSqlCommand(SqlCommand command)     at Microsoft.Office.Server.Audience.AudienceManager.GetUserAudienceIDs(String accountName, SPWeb web, Boolean loadAudiences, Boolean loadSharePointGroups, Boolean loadMemberships)     at Microsoft.Office.Server.WebControls.AudienceLoader.EnsureCurrentUserAudienceIDs(Boolean loadAudiences, Boolean loadMemberships, Boolean loadSharePointGroups)     at Microsoft.Office.Server.Audience.AudienceManager.IsCurrentUserInAudienceOf(AudienceLoader audienceLoader, String audienceTextRepresentation, Boolean showUntargetedAudience)     at Microsoft.Of... 
    09/11/2009 14:21:04.69* w3wp.exe (0x0944)                        0x0A88                                484                            880k High     ...fice.Server.Audience.AudienceManager.IsCurrentUserInAudienceOf(String audienceTextRepresentation, Boolean showUntargetedAudience)     at Microsoft.Office.Server.Audience.AudienceManager.CheckRuntimeRender(String isIncludedFilter)     at Microsoft.SharePoint.SPWeb.InitFromWebPartManager(SPWebPartManager manager, HttpContext context)     at Microsoft.SharePoint.WebPartPages.SPWebPartManager.LoadWebParts()     at Microsoft.SharePoint.WebPartPages.SPWebPartManager.OnPageInitComplete(Object sender, EventArgs e)     at System.EventHandler.Invoke(Object sender, EventArgs e)     at System.Web.UI.Page.OnInitComplete(EventArgs e)     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     at System.Web.UI.Page.ProcessRequest(Boolean i... 
    09/11/2009 14:21:04.69* w3wp.exe (0x0944)                        0x0A88                                484                            880k High     ...ncludeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     at System.Web.UI.Page.ProcessRequest()     at System.Web.UI.Page.ProcessRequest(HttpContext context)     at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)     at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)     at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)     at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)     at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)     at System.Web.Hosting.ISAPIRuntime.P... 
    09/11/2009 14:21:04.69* w3wp.exe (0x0944)                        0x0A88                                484                            880k High     ...rocessRequest(IntPtr ecb, Int32 iWRType)   
    09/11/2009 14:21:04.69  w3wp.exe (0x0944)                        0x0A88                                484                            880l High     ConnectionString: 'Server=WGS-SQL-01;Database=HAL_SharedServices1_DB;Trusted_Connection=yes;App=Windows SharePoint Services;Timeout=15'    ConnectionState: Closed ConnectionTimeout: 15 
    09/11/2009 14:21:04.69  w3wp.exe (0x0944)                        0x0A88                                484                            880m High     SqlCommand: 'dbo.Orgle_GetUserOrgleList'     CommandType: StoredProcedure CommandTimeout: 0     Parameter: '@NTName' Type: NVarChar Size: 400 Direction: Input Value: 'WOODGREENSCHOOL\administrator'     Parameter: '@GetAudiences' Type: Bit Size: 0 Direction: Input Value: 'False'     Parameter: '@GetMemberships' Type: Bit Size: 0 Direction: Input Value: 'True' 
    09/11/2009 14:21:04.69  w3wp.exe (0x0944)                        0x0A88 SharePoint Portal Server       User Profiles                  62ml High     GetUserAudienceIDs::GetUserAudienceIDs() : siteURL=http://wgs-moss-01:22201/ssp/admin GetUserAudienceIDs::GetUserAudienceIDs() : Retrieving user audience list has encountered an error. AccountName=WOODGREENSCHOOL\administrator, Error code = 8145 
    09/11/2009 14:21:04.69  w3wp.exe (0x0944)                        0x0A88 SharePoint Portal Server       User Profiles                  62mp Exception IsCurrentUserInAudienceOf throws exception. Return false. Microsoft.Office.Server.Audience.AudienceNoContentException: GetUserAudienceIDs::GetUserAudienceIDs() : Retrieving user audience list has encountered an error. AccountName=WOODGREENSCHOOL\administrator, Error code = 8145     at Microsoft.Office.Server.Audience.AudienceManager.GetUserAudienceIDs(String accountName, SPWeb web, Boolean loadAudiences, Boolean loadSharePointGroups, Boolean loadMemberships)     at Microsoft.Office.Server.WebControls.AudienceLoader.EnsureCurrentUserAudienceIDs(Boolean loadAudiences, Boolean loadMemberships, Boolean loadSharePointGroups)     at Microsoft.Office.Server.Audience.AudienceManager.IsCurrentUserInAudienceOf(AudienceLoader audienceLoader, String audienceTextRepresentation, Boolean showUntargetedAu... 
    09/11/2009 14:21:04.69* w3wp.exe (0x0944)                        0x0A88 SharePoint Portal Server       User Profiles                  62mp Exception ...dience) 
    09/11/2009 14:21:04.69  w3wp.exe (0x0944)                        0x0A88 SharePoint Portal Server       User Profiles                  62mq Assert   IsCurrentUserInAudienceOf throws exception. Return false. StackTrace:   at Microsoft.Office.Server.Audience.AudienceManager.IsCurrentUserInAudienceOf(AudienceLoader audienceLoader, String audienceTextRepresentation, Boolean showUntargetedAudience)     at Microsoft.Office.Server.Audience.AudienceManager.IsCurrentUserInAudienceOf(String audienceTextRepresentation, Boolean showUntargetedAudience)     at Microsoft.Office.Server.Audience.AudienceManager.CheckRuntimeRender(String isIncludedFilter)     at Microsoft.SharePoint.SPWeb.InitFromWebPartManager(SPWebPartManager manager, HttpContext context)     at Microsoft.SharePoint.WebPartPages.SPWebPartManager.LoadWebParts()     at Microsoft.SharePoint.WebPartPages.SPWebPartManager.OnPageInitComplete(Object sender, EventArgs e)     at System.EventHa... 
    09/11/2009 14:21:04.69* w3wp.exe (0x0944)                        0x0A88 SharePoint Portal Server       User Profiles                  62mq Assert   ...ndler.Invoke(Object sender, EventArgs e)     at System.Web.UI.Page.OnInitComplete(EventArgs e)     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     at 
    09/11/2009 14:21:04.69  w3wp.exe (0x0944)                        0x0A88 CMS                            Publishing                     8ztg Medium   Got List Item Version, but item was null. 
    09/11/2009 14:21:04.69  w3wp.exe (0x0944)                        0x0A88 CMS                            Publishing                     8ztg Medium   Got List Item Version, but item was null. 
    09/11/2009 14:21:04.69  w3wp.exe (0x0944)                        0x0A88 Windows SharePoint Services    General                        75fe High     Failed to determine definition for Feature with ID '00057002-c978-11da-ba52-00042350e42e'.  Skipping this feature for element querying consideration. 
    09/11/2009 14:21:04.71  w3wp.exe (0x0944)                        0x0A88 Windows SharePoint Services    General                        75fe High     Failed to determine definition for Feature with ID '3a465ae2-6114-418b-be8d-081557b79517'.  Skipping this feature for element querying consideration. 
    09/11/2009 14:21:04.71  w3wp.exe (0x0944)                        0x0A88 Windows SharePoint Services    General                        75fe High     Failed to determine definition for Feature with ID 'aebdd598-142f-4a93-8aa5-54f66b776cdf'.  Skipping this feature for element querying consideration. 
    09/11/2009 14:21:04.71  w3wp.exe (0x0944)                        0x0A88 Windows SharePoint Services    General                        75fe High     Failed to determine definition for Feature with ID '00057002-c978-11da-ba52-00042350e42e'.  Skipping this feature for element querying consideration. 
    09/11/2009 14:21:04.71  w3wp.exe (0x0944)                        0x0A88 Windows SharePoint Services    General                        75fe High     Failed to determine definition for Feature with ID '3a465ae2-6114-418b-be8d-081557b79517'.  Skipping this feature for element querying consideration. 
    09/11/2009 14:21:04.71  w3wp.exe (0x0944)                        0x0A88 Windows SharePoint Services    General                        75fe High     Failed to determine definition for Feature with ID 'aebdd598-142f-4a93-8aa5-54f66b776cdf'.  Skipping this feature for element querying consideration. 
    Friday, September 11, 2009 1:24 PM
  • This isn't a customization question. 

    Moving to Admin.

    WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
    Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx
    Monday, September 14, 2009 4:47 AM
  • Can anyone please help???
    Monday, September 21, 2009 10:01 PM
  • Feature 'aebdd598-142f-4a93-8aa5-54f66b776cdf'



     
    Feature 'aebdd598-142f-4a93-8aa5-54f66b776cdf' for list template '11111' is not installed in this farm.  The operation could not be completed.

    I'v got the same problem ,can anyone help ?
    Thursday, December 03, 2009 3:23 AM
  • Has anyone else had this problem yet and any idea how to fix it?? please??
    Monday, January 18, 2010 2:15 PM
  • now i'v reslove this ploblem

    use this command 

    stsadm -o deletelist -url http://youdomain/yourListNameThatHasAPloblem/ -force

    you should be know what's list that has a ploblem by go to Show All Site Content menu on left navigation bar
    Monday, January 18, 2010 2:25 PM
  • now i'v reslove this ploblem

    use this command 

    stsadm -o deletelist -url http://youdomain/yourListNameThatHasAPloblem/ -force

    you should be know what's list that has a ploblem by go to Show All Site Content menu on left navigation bar

    I am not having problems with a list. Im having problems with the audience targetting, and I believe its some problem with the MOSS server communicating with the SQL server. I cant work out how to fix this problem though.
    Wednesday, January 20, 2010 11:48 AM
  • I'm seeing the same issue and have looked through all SQL& application log files.  I've not been able to find anything on what is causing the issue from an access/permission perspective.  Has anyone made any progress on this? 
    Wednesday, February 03, 2010 4:25 PM
  • I'm getting the same error trying to use the Datapolis SharePoint Column Protector product on my site. The product works on a different site collection however. I imagine the product uses audience targeting to hide information in list views, but I'm not sure of the cause of the issue.

    Tuesday, March 06, 2012 3:05 AM
  • I am not sure if we have got the same problem, but I believe we have got to the bottom of our problem.

    Both audiences have compiledI can search for users, change rules and recompile.

    Audience 1

    • Rule1 - account name contains......mydomainXX\
    • Rule2 - account name contains......mydomainYY\
    • Rule3 - account name contains......mydomainZZ\

    CONTAINS 5600 Users

    This audeince compiles and targets content to our users correctly......but if I create another audience, using the same rule 1  ---- a conflict seems to occurs and both audiences fail to trim content.......

    Audience 2

    • Rule1 - account name contains......mydomainXX\

    Contains 1000 Users

    So it appears I cannot use the same rules in different audiences......if someone has a work around or any literature outlining this problem - please post

    Thank you

    Tuesday, April 03, 2012 2:47 PM