Relation prop. 'u.UserAccessToOtherCal' not found [ Edited ]

[mtamborini]

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
    }
  }
}

[mtamborini · Accepted solution]

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