Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when logging into Microsoft Dynamics for Mobile Devices: The formatter threw an exception

Error message when logging into Microsoft Dynamics for Mobile Devices: The formatter threw an exception

View products that this article applies to.

Symptoms

When you try to log in to Microsoft Dynamics SL for Mobile Devices, you receive the following error:

•The user name or password provided is incorrect. 4 The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter http://microsoft.com/dynamics/sl:ExecuteResponse. The InnerException message was 'There was an error deserializing the object of type Microsoft.Dynamics.SL.Mobile.CommonModel.LookupsServiceReference.ExecuteResponseBody. The maximum string content length quota (8192) has been exceeded while reading XML data. This quota may be increased by changing the MaxStringContentLength property on the XmlDictionaryReaderQuotas object used when creating the XML reader. Line 89, position 32.'. Please see InnerException for more details.



↑ Back to the top

Cause

The issue is caused by bug 26215.

↑ Back to the top

Resolution

Run the following SQL script against the SL Application database(s) to correct the WSL_AccessWebSeviceRights stored procedure which is causing the error:

ALTER procedure [dbo].[WSL_AccessWebSeviceRights]
@page  int,@size  int,@sort   nvarchar(200),@CpnyID varchar(10),
@UserID varchar(47),  @Methods varchar(1024),@WinUser varchar(85) as

if (@UserID = '') Begin  set @UserID = (SELECT userID FROM vs_USERREC WHERE RecType = 'U' AND [WindowsUserAcct] = @WinUser AND defaultuser = 1) end
SELECT max(AccessRights),MethodName FROM [vs_WebServiceAccessRi] rights WHERE
(RecType = 'U' and UserId = @UserID or UserId in ( select GroupID from vs_usergrp where UserID=@UserID)) AND
(CompanyID = @CpnyID or CompanyID='[ALL]') and MethodName like @Methods and
 MethodName like 'Microsoft.Dynamics.SL.ProjectTimecardService%'
 and  MethodName not in ('Microsoft.Dynamics.SL.ProjectTimecardService.ReadTimecardSystemAttachment',
       'Microsoft.Dynamics.SL.ProjectTimecardService.ReadTimecardSystemNote',
       'Microsoft.Dynamics.SL.ProjectTimecardService.CreateTimecardSystemAttachment',
       'Microsoft.Dynamics.SL.ProjectTimecardService.CreateTimecardSystemNote',
       'Microsoft.Dynamics.SL.ProjectTimecardService.UpdateTimecardSystemAttachment',
       'Microsoft.Dynamics.SL.ProjectTimecardService.UpdateTimecardSystemNote',
       'Microsoft.Dynamics.SL.ProjectTimecardService.DeleteTimecardSystemAttachment',
       'Microsoft.Dynamics.SL.ProjectTimecardService.DeleteTimecardSystemNote'
       )  Group BY MethodName
GO


↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2895491
Revision : 2
Created on : 2/3/2017
Published on : 2/3/2017
Exists online : False
Views : 372