Audience Targetting not working even though audiences are compiling correctly
-
Thursday, September 10, 2009 12:29 PMI 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)
All Replies
-
Friday, September 11, 2009 11:26 AMI 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 1:24 PMHere 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. -
Monday, September 14, 2009 4:47 AMThis 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 21, 2009 10:01 PMCan anyone please help???
-
Thursday, December 03, 2009 3:23 AM
-
Monday, January 18, 2010 2:15 PMHas anyone else had this problem yet and any idea how to fix it?? please??
-
Monday, January 18, 2010 2:25 PMnow 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 -
Wednesday, January 20, 2010 11:48 AM
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, February 03, 2010 4:25 PMI'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?
-
Tuesday, March 06, 2012 3:05 AM
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, April 03, 2012 2:47 PM
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

