API transfer #9960

5 Answer(s)

• 

  0

  AI-Bot created yesterday

  Support Team ABP Agent

  The error you are encountering is due to the DeviceInfo column in your AbpSessions table being defined as nvarchar(64), which is too short to store the full device information string sent by some Android devices. The error message:

  String or binary data would be truncated in table 'eMRFusion2_KranjTEST.dbo.AbpSessions', column 'DeviceInfo'. Truncated value: 'Dalvik/2.1.0 (Linux; U; Android 15; SM-A546B Build/AP3A.240905.0'
  

  indicates that the value being inserted exceeds the 64-character limit.

  Solution

  You need to increase the length of the DeviceInfo column in your AbpSessions table. For example, you can change it from nvarchar(64) to nvarchar(4000):

  ALTER TABLE [AbpSessions] ALTER COLUMN [DeviceInfo] NVARCHAR(4000) NULL;
  

  After updating the column size, you should also update your Entity Framework Core model if you have any explicit configuration for this property.

  Steps:

  1. Update the database column as shown above.
  2. If you have an EntityTypeConfiguration or model definition for AbpSession, update the DeviceInfo property to match the new length.
  3. Regenerate and apply any necessary EF Core migrations if you are using code-first migrations.

  This will allow longer device info strings to be stored without causing truncation errors.

  ---

  • ABP Session Management Documentation

  ---

  This response was generated by AI. If it didn’t solve your problem, feel free to post a new answer — our support team will jump in to help you soon.

  Save Cancel
• 

  0

  matija.ropret@infotim.com created yesterday

  We are not able to increase the column size in AbpSessions, because it is part of ABP solution.

  Save Cancel
• 

  0

  maliming created yesterday

  Support Team Fullstack Developer

  hi

  You can

  1. Change the IdentitySessionConsts.MaxDeviceInfoLength and add a new EF Core migration to increase the length of the session entity.

  public class IdentitySessionConsts
  {
      public static int MaxSessionIdLength { get; set; } = 128;
  
      public static int MaxDeviceLength { get; set; } = 64;
  
      public static int MaxDeviceInfoLength { get; set; } = 64;
  
      public static int MaxClientIdLength { get; set; } = 64;
  
      public static int MaxIpAddressesLength { get; set; } = 2048;
  }
  

  2. Replace the built-in IWebClientInfoProvider service.

  using Microsoft.AspNetCore.Http;
  using Microsoft.Extensions.Logging;
  using MyCSharp.HttpUserAgentParser.Providers;
  using Volo.Abp.DependencyInjection;
  
  namespace Volo.Abp.AspNetCore.WebClientInfo;
  
  [Dependency(ReplaceServices = true)]
  [ExposeServices(typeof(HttpContextWebClientInfoProvider), typeof(IWebClientInfoProvider))]
  public class MyHttpContextWebClientInfoProvider : HttpContextWebClientInfoProvider
  {
      public MyHttpContextWebClientInfoProvider(
          ILogger<HttpContextWebClientInfoProvider> logger,
          IHttpContextAccessor httpContextAccessor,
          IHttpUserAgentParserProvider httpUserAgentParser)
          : base(logger, httpContextAccessor, httpUserAgentParser)
      {
      }
  
      protected override string? GetDeviceInfo()
      {
          var info = base.GetDeviceInfo();
          return info?.Substring(0, 64);
      }
  }
  

  Save Cancel
• 

  0

  matija.ropret@infotim.com created yesterday

  Second solution works.Thank you.

  Save Cancel
• 

  0

  maliming created yesterday

  Support Team Fullstack Developer

  Thanks, we also will increase the length in abp 10.0

  Save Cancel