06-06-2014 07:32 AM - edited 06-06-2014 07:40 AM
Hi,
SLX WEB 8.0 Core06, Model04:
When navigating to Activities > Events we get the follwoing error:
"Relationship property 'u.UserAccessToOtherCal' not found."
My Activities, All Open, etc. is working. I already checked, "UserAccessToOtherCal" and "OthersAccessToUserCal" relationships are available.
Any ideas?
Thanks & best regards,
Marco
2014-06-06 15:56:16,071 [45] ERROR Global - Sage Integration Messaging MessagingService unhandled exception [SalesLogix Error Id=SLXF233C0C5158144BF] { "slxErrorId": "SLXF233C0C5158144BF", "mitigation": "AjaxMessagingServiceError (400)", "date": "2014-06-06T15:56:16", "utc": "2014-06-06T13:56:16", "message": "Relationship property 'u.UserAccessToOtherCal' not found.", "source": "Sage.Platform.SData.RequestHandlerBase`3, Sage.Platform, Version=8.0.0.8570, Culture=neutral, PublicKeyToken=null", "type": "Sage.Common.Syndication.DiagnosesException", "stackTrace": " at Sage.Platform.SData.RequestHandlerBase`3.MapPath(IList`1 path, ICriteria criteria, RequestHandlerPathType type)\r\n at Sage.Platform.SData.RequestHandlerBase`3.Sage.Platform.SData.IRequestHandler.MapPath(IList`1 path, ICriteria criteria, RequestHandlerPathType type)\r\n at Sage.Platform.SData.RequestHandlerBase`3.MapPath(IList`1 path, ICriteria criteria, RequestHandlerPathType type)\r\n at Sage.Platform.SData.RequestHandlerBase`3.<>c__DisplayClass46.<GetEntities>b__44(String path)\r\n at Sage.Platform.SData.ExpressionToCriteriaVisitor.OnVisited(FieldExpression node)\r\n at Sage.Common.Expressions.FieldExpression.AcceptCore(ExpressionVisitor visitor)\r\n at Sage.Common.Expressions.Expression.AcceptChildren(ExpressionVisitor visitor, IExpressions list)\r\n at Sage.Common.Expressions.EqualsExpression.AcceptCore(ExpressionVisitor visitor)\r\n at Sage.Common.Expressions.Expression.AcceptChildren(ExpressionVisitor visitor, IExpressions list)\r\n at Sage.Common.Expressions.ParenthesesExpression.AcceptCore(ExpressionVisitor visitor)\r\n at Sage.Common.Expressions.Expression.Accept(ExpressionVisitor visitor)\r\n at Sage.Platform.SData.RequestHandlerBase`3.GetEntities(SDataUri uri, Int64& totalResults, Int32& startIndex, Int32& itemsPerPage)\r\n at Sage.Platform.SData.RequestHandlerBase`3.InternalGet()\r\n at Invoke2f06ec6e83e5427fba329c277c3f0539.Invoke(Object , IRequest )\r\n at Sage.Integration.Messaging.RequestTargetRegistration.RequestTargetInvoker.Invoke(IRequest request)\r\n at Sage.Integration.Messaging.Request.Process(RequestTargetInvoker invoker)\r\n at Sage.Integration.Adapter.AdapterController.RealAdapterController.Process(IRequest request)\r\n at Sage.Integration.Adapter.AdapterController.RealAdapterController.ProcessWorker(IProtocolRequest protocolRequest)\r\n at Sage.Integration.Adapter.AdapterController.Process(IProtocolRequest request)\r\n at Sage.Integration.Messaging.MessagingService.Process(IProtocolRequest protocolRequest)", "targetSite": "System.String MapPath(System.Collections.Generic.IList`1[System.String], NHibernate.ICriteria, Sage.Platform.SData.RequestHandlerPathType)", "hashCode": "FA95BF4E-EDB02376-0104271F", "pid": 656, "identity": { "name": "admin", "isAuthenticated": true, "authenticationType": "Forms" }, "version": "8.0.0.8570", "logger": { "level": "ERROR", "location": "Sage.Platform.Diagnostics.ErrorHelper.LogException(:0)", "name": "Global", "message": "Sage Integration Messaging MessagingService unhandled exception [SalesLogix Error Id=SLXF233C0C5158144BF]" }, "request": { "looksLikeAjax": false, "isLocal": true, "method": "GET", "url": "http://localhost:3333/SlxClient/slxdata.ashx/slx/dynamic/-/events?_includeContent=false&select=$key,Type,StartDate,EndDate,Location,Description,User/UserInfo/UserName,User/UserAccessToOtherCal/OthersAccessToUserCal/Id&where=(User.UserAccessToOtherCal.OthersAccessToUserCal.Id eq \"ADMIN\")&startIndex=1&count=25&format=json&_t=1402062657638", "referrer": "", "ipAddress": "127.0.0.1", "userAgent": "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)", "userLanguages": "de-CH; en-US;q=0.7; en;q=0.3" }, "browser": { "type": "IE9", "name": "IE", "version": "9.0", "majorVersion": 9, "minorVersion": 0.0, "platform": "WinNT" }, "server": { "machineName": "SERVER", "timeZone": "W. Europe Standard Time", "commandLine": "C:\\Windows\\SysWOW64\\inetsrv\\w3wp.exe -ap \"Saleslogix_Dev\" -v \"v4.0\" -l \"webengine4.dll\" -a \\\\.\\pipe\\iisipm8a52b2f2-5612-41c9-9d52-0aaa15d4ad43 -h \"C:\\inetpub\\temp\\apppools\\Saleslogix_Dev\\Saleslogix_Dev.config\" -w \"\" -m 0 -t 20", "versionString": "Microsoft Windows NT 6.1.7601 Service Pack 1", "is64BitOperatingSystem": true, "host": { "siteName": "Saleslogix_Dev", "applicationId": "/LM/W3SVC/2/ROOT/SlxClient", "applicationPhysicalPath": "C:\\inetpub\\wwwroot\\Saleslogix_Dev\\SlxClient\\", "applicationVirtualPath": "/SlxClient", "isDebuggingEnabled": false, "isHosted": true, "maxConcurrentRequestsPerCPU": 5000, "maxConcurrentThreadsPerCPU": 0 }, "logonUser": { "name": "DOMAIN\\WebDLL", "authenticationType": "Forms", "impersonationLevel": "Impersonation", "isAnonymous": false, "isGuest": false, "isSystem": false } } }
Solved! Go to Solution.
06-11-2014 04:50 AM
Took some time but found the issue:
UserCalendar Entity SData Feed was not generated. I have no idea why it was unchecked but this was the cause.
Regards,
Marco