Troubleshooting

Recommended tooling:

• MS WebView2 Chromium DevTools, activated via SHIFT+CTRL+I from any ActionPad
• Fiddler Classic Web Debugger running with HTTPS-decryption
• Microsoft SysInternals DebugView

Note: The remaining information in this article largely relates to legacy versions 10.18 and older.

Lime CRM can be started in safe mode which disables all addins that are otherwise loaded at startup. In safe mode the Internet pane web page is also set to a blank page. Use safe mode to temporarily log in to Lime CRM in case of problems. Safe mode is enabled by using a command-line argument to lime.exe:

"C:\Program Files (x86)\Lundalogik\Lime CRM\lime.exe" /safemode

There are a number of registry settings that can make troubleshooting and optimizations easier. The following values can be entered under the registry key HKEY_CURRENT_USER\Software\Lundalogik\Lime\Debug (1 = enabled, 0 = disabled):

To make diagnosing serious problems in Lime CRM easier logging of application crashes can be enabled. When this feature is enabled (available in version 10.7 and later) a detailed log and crash dump will automatically be created if the Lime CRM desktop client crashes.

The crash logging feature is enabled by adding or changing values in the Windows registry below the key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Lundalogik\Lime\CrashHandler. The following values can be set:

The LDC component can be instructed to log all SQL statements that it is about to execute by changing a value in the registry on the application server.

On 32-bit Windows editions the value is located in the registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Lundalogik\Lundalogik Data Components\Databases\<<database name>>\Auditing

On 64-bit Windows editions it is located in the registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Lundalogik\Lundalogik Data Components\Databases\<<database name>>\Auditing

Sometimes it can be interesting for debug or optimization purposes to see which stored procedures are executing and how long they need to execute. By setting sys_procedure_log_level in the setting system table to 1 then calls to some system procedurse (lsp_) will be logged to the table procedurelog.

You can also use the stored procedure logging functionality in custom procedures and functions (csp_, cfn_) by using the following template:

CREATE PROCEDURE [dbo].[csp_myprocedure]
AS
BEGIN
  SET NOCOUNT ON
 
  DECLARE @retval int
  DECLARE @starttime datetime
 
  SET @retval = 0
  SET @starttime = GETDATE()
 
  -- Stored procedure logic here
  -- ...
  -- ...
  -- ...
  -- ...
 
  -- Log procedure
  EXECUTE lsp_addprocedurelog @@procedureid = @@procid, @@starttime = @starttime
 
  RETURN @retval
END

The following query can be used for retrieving log data from the procedurelog table:

SELECT
  pl.[timestamp] AS N'Timestamp',
  ao.name AS N'Procedure',
  pl.prm AS N'Parameters',
  ISNULL(u.username, N'Unknown') AS N'Username',
  pl.duration AS N'Duration (ms)'
FROM
  procedurelog pl
LEFT JOIN
  sys.all_objects ao ON ao.object_id = pl.procid
LEFT JOIN
  [user] u ON u.iduser = pl.iduser

Lime CRM Server stores logs in C:\ProgramData\Lundalogik\Lime CRM Server\<service>\logs\, where <service> is Web Server for the main server. The server logs errors and warnings by default, but info and debug logging can be enabled by adding the following to C:\ProgramData\Lundalogik\Lime CRM Server\Web Server\configs\config.ini

[logging]
level = DEBUG
errorloglevel = DEBUG

Check the server log for the cause, but the two most common reasons are:

• Service user does not have access to the Lundalogik folder in C:\ProgramData
• The certificate used was not exported/converted correctly, see Web server configuration

Database is not indexed, run limefu search index -a <database name>

View is not up to date, log in as admin and use the view editor to add the missing fields, see Views and indexes

Webclient is not enabled, open C:\ProgramData\Lundalogik\Lime CRM Server\Web Server\configs\config.ini and add the following:

[features]
webclient_login = True
api = True

Services might be locked from other open windows so that they cannot be uninstalled properly. Make sure to not have any other windows open when you run the installation.