Skip to content

Lime CRM Knowledge Base

Version 10.18.419

Released August 24, 2020.

Improvements

  • The Lime CRM Desktop Client will only allow connections to Lime CRM servers with certificates that are signed by a certificate authority. End users will no longer be able to accept the warnings and connect to Lime CRM servers with self-signed certificates. However, we do allow connecting to localhost, 127.0.0.1 or everything else where Uri.IsLoopback = true. That means that it is still possible to access local installations with self-signed certificates.

Bug fixes

  • Fixed regression error in email validation that caused suggest email address to ignore logic for sibling records.
  • Added logging with performance measurements for back-end communication
  • Fixed crash in string formatting for messages exceeding 600 characters.
  • Disabled embedded folder panes by default for Office 32-bit (no longer supported by Microsoft)
  • Added stability fixes for embedded folder panes for Office 32-bit.
  • Added support for outgoing email from multiple accounts, previously only default account was properly supported.
  • Fixed crash when trying to print document record without attached document.
  • Fixed regression in sending email to lists.
  • Fixed regression in organizing meeting for other organizer.
  • Fixed bug for accessing database where current application locale is not active, now handles cases where Application.Locale != Database.Locale.
  • Fixed bug where locales are sent in non-standard format, ie en_us instead of en-us.
  • Improved error handling for back-end communication to preserve root cause. This will enable end-users and support to better diagnose authentication errors, network problems and configuration problems, including invalid certificates.
  • Properly handle HTTP-requests without content.
  • Updated application .config to use default security setting from Windows where applicable.
  • Updated Outlook Redemption to workaround crash in specific versions of MS Outlook 365, current version is now 5.24.0.5736

Version 10.17.1001

  • Add translation string to Excel document save dialog.
  • Do not reset defaults after an installation if it was an upgrade (e.g. don't revert to Auto Select on language).
  • Add new option pane for Telavox settings, where users can log out from the Telavox addin, and change call preferences.
  • Allow users with their mobile attached to Telavox desktop client to make calls through Lime.
  • Generate a better message if login with the Telavox addin fails.
  • Improve authentication against Telavox API.
  • Fix an issue with stack memory running out at startup in some cases.
  • Allow the server URL textbox to scroll if URL is too large.
  • Registry autoupdate channel setting now takes precedence over database settings.
  • Fix an issue where context menus were being clipped on non-primary monitors in some cases.
  • Add new generic browser icon
  • Fix bug where Excel save dialog would not display on top of Excel window
  • Add check for .NET version at startup.
  • Allow links with '_blank' as target to open in default browser (Chromium only).
  • Add support for links to the web client when copying and sending Limelinks
  • Fix bug with Outlook calendar item causing an error after closing inspector after drag/drop of the item
  • Fix crash that occurs after sorting columns in a dialog created with lkSearchRecords
  • Chromium version in this release: 63.0.3239.109
  • We've upgraded to .NET framework 4.5.2 which is now a requirement for Lime to run
  • Some usage statistics are now being logged
  • No longer reset language setting for current user on new install
  • Show 'loading lists' on splash screen before loading addins
  • It is now possible to cancel drag/drop of email files no matter when the application's drop event is hooked
  • Login logo now rotates and shows version if clicked, same as web client
  • Update images in merge wizard
  • Better error message is now shown when a session has timed out, allowing the user to restart Lime to login again.
  • Bug fix: Column filtering of system users now works
  • Experimental Chromium implementation, hidden behind a miscellaneous option
  • 1 min read

Outlook integration does not work correctly with Office 2013 in “Click-to-Run”-mode

Summary

Click-to-Run is a technology from Microsoft that uses data streaming and virtualization to run Office application on the fly. Microsoft has confirmed that a problem in Outlook 2013, when used with Click-to-Run, causes the Outlook integration in Lime CRM to work incorrectly.

Note that the error only covers Outlook 2013 Click-to-Run.

Symptoms

An error message saying “Not logged on, please log on first” is displayed.

Resolution

Download, unzip and run this hotfix. According to Microsoft, this issue may (or may not) be fixed in a future Office service pack.

Cause

Technical details regarding this problem can be found here.

Affected products

All versions of Lime CRM Desktop Client when used with Microsoft Outlook 2013 in Click-to-Run mode.

Questions?

Please contact our support team if you have questions regarding any of the above.

  • 2 min read

Lime CRM Server can cause high memory usage and/or return invalid search results

Summary

It has come to our attention that a caching feature in Lime CRM Server can cause abnormally high memory usage and/or return invalid search results.

Symptoms

There are two different symptoms which may appear separately from each other:

  • The process hosting the LDC subsystem of Lime CRM Server (dllhost.exe) is using very large amounts of memory — hundreds of MBs for smaller installations and > 1 GB for larger installations.
  • When record access filtering is used with a condition on the form [company].[responsible] = ActiveUser records may be shown in lists that the user should not see and also lacks permission to open.

Resolution

Note!

It is NOT necessary to carry out any changes unless you are experiencing any of the above symptoms!

Since the query cache does not provide much of a performance boost (if any) the best solution is to disable it. The cache is disabled by default in Lime CRM Server versions 12.0.973 and later but must be disabled manually by editing the system registry for earlier versions:

  1. Using the Registry Editor, navigate to HKEY_LOCAL_MACHINE\Software\Wow6432Node\Lundalogik\Lundalogik Data Components\Databases\<database>
  2. Add a DWORD value named UseLDCQueryCache and set it to 0 (zero).
  3. Repeat steps 1-2 for each database in use on the application server.
  4. Restart LDC by going to Component Services | My Computer | COM+ Applications, right-clicking Lundalogik Data Components and selecting Shut down from the context menu.

Cause

The LDC subsystem caches all database queries by storing the generated SQL queries with the LDC XML format query as the key. This means that LDC with time uses more and more memory with performance hits as the result. In some cases the dllhost.exe process may even run out of memory which can cause LDC to crash. When record access filtering with a condition as mentioned above is used the cache key will be identical for all users even though the generated SQL query should differ. This means that the query for the first user that gets his or her query stored in the cache will be used for all other users.

Affected products

All Lime CRM Server versions prior to 12.0.973.

Questions?

Please contact our support team if you have questions regarding any of the above.

  • 1 min read

Map Integration can cause problems after installing Windows Updates

Summary

The Lime CRM Map Integration may not function correctly after a certain Windows Update has been installed.

Symptoms

There are multiple symptoms:

  • LIME pro may crash when the application is started
  • Lime CRM may crash when displaying the map pane
  • When clicking a map marker the tooltip window may not be possible to close

Resolution

If the Map Integration is not being used on the machine having problems, the simplest solution is to uninstall it using Control panel | Add/remove programs. Otherwise, follow these steps:

  1. Using Windows Registry Editor (regedit.exe), browse to:
    • HKLM\SOFTWARE\Microsoft\Internet Explorer\MAIN\FeatureControl\FEATURE_BROWSER_EMULATION (32-bit Windows)
    • HKLM\SOFTWARE\Wow6432Node\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION (64-bit Windows)
  2. Add a DWORD value named Lime.exe and set the value to:
    • 8000 decimal when Internet Explorer 9 is used
    • 9999 (decimal) when Internet Explorer 10 or later is used
  3. Restart Lime CRM

Cause

We believe these problems occur due to a compatibility problem introduced in an update from Microsoft, KB3003057.

Affected products

All versions of Lime CRM Maps Integration.

Questions?

Please contact our support team if you have questions regarding any of the above.

  • 1 min read

Upgrade/uninstallation of Lime CRM Server 12.0.973.1 may fail

Summary

Due to a problem with the uninstallation script shipped and installed with Lime CRM Server 12.0.973.1, uninstallation and therefore also upgrade, may not work as intended.

Symptoms

An error message saying that Lime CRM Server Administration (LISA) and/or Lundalogik Data Components (LDC) could not be installed appears in the installation log window when upgrading or uninstalling and the setup application indicates failure.

Resolution

Download and run this hotfix. Then re-run the installer.

Cause

A bug in the uninstallation script for version 12.0.973.1 makes the setup application unable to detect which version of LDC and LISA currently installed. Since the version number is part of the .msi file name for these applications the installer can't find out which .msi files to uninstall.

Affected products

Lime CRM Server 12.0.973.1.

Questions?

Please contact our support team if you have questions regarding any of the above.

  • 1 min read

Incompatibility with certain versions of SQL Server 2012/2014

Summary

Due to problems detecting the SQL Server version, Lime CRM Server may stop functioning with the following versions of SQL Server:

  1. SQL Server 2012 Service Pack 2 with Cumulative Update package 9 (CU9)
  2. SQL Server 2012 Service Pack 2 with Cumulative Update package 7 (CU7)
  3. SQL Server 2012 Service Pack 3/GDR
  4. SQL Server 2014 Service Pack 1 with Cumulative Update package 3 (CU3)

Symptoms

In Lime CRM Desktop Client, after logging in, all operations requiring roundtrips to the database (e.g. loading lists and records) will cause the error messages similar to the ones below to be displayed:

Conversion failed when converting the nvarchar value ('CU7) (KB3072100) - 11' to data type int.

or

Conversion failed when converting the nvarchar value 'CU3) (KB3094221) - 12' to data type int.

or

Conversion failed when converting the nvarchar value 'CU9) (KB3098512) - 11' to data type int.

Resolution

Apply this hotfix to patch the relevant stored procedure.

Cause

An issue with the SQL Server detection logic in combination with the version string used by the new update package causes Lime CRM Server to be unable to execute many database queries.

Affected products

All Lime CRM Server versions of Lime CRM Server up to and including 12.0.973.15.

Questions?

Please contact our support team if you have questions regarding any of the above.

  • 1 min read

Removing tables containing relation fields breaks Lime CRM

Summary

Due to problems in removing relation fields when removing a table in Lime CRM, the Lime CRM Desktop Client throws an error message and makes it impossible to use Lime CRM.

Symptoms

In Lime CRM Desktop Client, after logging in, you will receive the following message and won't be able to do any operations:

The system cannot locate the object specified.

Resolution

Run the SQL-code below to locate and thereafter remove the faulty relation fields.

-- Find invalid relations. 
-- Please verify the found fields and make 
-- sure they are indeed not supposed to exist.
SELECT 
            idfield, name, tablename, fieldtype, relatedtable, relatedfield, relatedidfield
FROM 
            relationfieldview
WHERE 
            relatedtable IS NULL
            OR relatedfield IS NULL
            OR relatedidfield IS NULL
            OR idrelation IS NULL
            OR relationside IS NULL
 
GO
 
-- Delete each invalid relation by id
BEGIN TRANSACTION
            EXEC dbo.lsp_removefield @@idfield = <INSERT id here>
--COMMIT TRANSACTION
ROLLBACK TRANSACTION

Cause

When removing the table in LISA; the relation fields are not being removed. This has previously been ignored by the desktop client, but not in later versions.

Affected products

All Lime CRM Desktop Client versions from 10.12.107 and above. The issue is solved from Lime CRM Server 12.2.0.91.

Questions?

Please contact our support team if you have questions regarding any of the above.

  • 1 min read

Installing Lime CRM Desktop Client on top of Lime CRM Server may cause problems

Summary

When installing the Lime CRM Desktop Client after Lime CRM Server is installed (on the same machine) ldc.dll is sometimes being unregistered. This makes it impossible to login to Lime CRM using the desktop client.

Symptoms

You will not be able to login using the desktop client or see any databases in LISA. When trying to login using the desktop client you might get the following message:

The library is not registered

Resolution

Follow the steps below in order to solve the issue:

  1. Shut down the Lime CRM Desktop Client.
  2. Shut down LDC (go to Componentservices, right-click on LDC and choose shut down).
  3. Start cmd.exe with administrator rights.
  4. Go to the servers installation-folder (usually C:\Program Files (x86)\Lundalogik\Lime Pro Server).
  5. Run c:\windows\syswow64\regsvr32 ldc.dll

You might have to restart the machine in order for the solution to take effect.

Cause

When installing the desktop client on the same machine as Lime CRM Server, ldc.dll sometimes is being unregistered.

Affected products

All Lime CRM Desktop Client versions from 10.12.100 and above.

Questions?

Please contact our support team if you have questions regarding any of the above.

  • 1 min read

nVidia nView Desktop Manager causes Lime CRM Desktop Client to malfunction

Summary

Several oddities may come about when nVidia nView Desktop Manager is enabled and used with Lime CRM.

Symptoms

The following symptoms have been observed:

  • The Lime CRM process cannot be launched at all.
  • THE Lime CRM process is launched but the login dialog/splash screen is never displayed.
  • Clicking Lime links in email messages does not work.

Resolution

If you experience problems with Lime CRM while having the nView Desktop Manager enabled, please disable it. The option to change nView should be found by going to Control Panel and opening the nVidia nView icon.

Affected products

All Lime CRM Desktop Client versions.

Questions?

Please contact our support team if you have questions regarding any of the above.