View more results: All Community | Knowledgebase
  • Wiki Page: 492-16799 - Error connecting to database when a language is specified in db.properties

    Summary: An incorrect parameter in your database connection string may prevent the CRMJ webapp from connecting to the database. The error given refers to an error connecting to the database - you may also get an error referring to CloneReportController. The error has only been observed where the SQL...
  • Wiki Page: 492-16896 - Info: CRM and SQL Server's ntext data type

    Summary: Microsoft will be removing support for the ntext data type from a future release of SQL Server. In preparation for this, new Sage CRM installs use the nvarchar(max) data type instead of ntext for multiline text fields. How does this affect upgrades? Will the data types for these fields be updated...
  • Wiki Page: 632-17087 - Only one communication gets created in CRM when sending an email with 3 recipients

    Summary: Only one communication gets created in CRM when an email with three reciepients is sent. All three recipients are set up as Person Records in CRM. Symptoms: Send out an email with 3 recipients. One of these will be the email address of a user of CRM. The other two email addresses will be for...
  • Wiki Page: 608-17143 - Unable to upgrade from 6.2 to 7.0

    Summary: Upon installing 7.0 to upgrade CRM you are given a warning "The database is already partially upgraded. Please restore from backup", although no upgrade has been attempted. You can drop a table in SQL which the database creates when upgrading so that it will start the upgrade again...
  • Wiki Page: 536-17192 - SQL 2008 Runtime Version for CRM

    Summary: Does Sage provide SQL 2008 Express Runtime version with CRM? Answer: No, we do not provide the SQL 2008 Express Runtime Edition. A link below showing comparisons of the different editions http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.105).aspx There is a build specific to runtime called...
  • Wiki Page: 492-17279 - Sage CRM data model

    Summary: A customer or development partner may wish to download the Sage CRM data model. More information: The data model are avilable in either PDF, JPG or SMS format from the Sage CRM Community site. The SMS files can be opened using Open ModelSphere . v7.3 data model: https://community.sagecrm.com...
  • Wiki Page: 536-17311 - How often does Sage CRM establish a connection with the database?

    Summary: When the application (Sage CRM) is started and running, in what circumstances will Sage CRM trigger the connection to database that requires the id and password again? Resolution: If you set the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\eWare\Config\CRM\SQLLogging value for a CRM install to 6...
  • Wiki Page: 492-17439 - CRM v7.2 on Oracle: TNS Listener was not found

    Summary: When using an Oracle database, an issue may occur when installing a new copy of Sage CRM v7.2, or upgrading an earlier version to v7.2. On attempting to save the Oracle database connection, the following error message may be displayed: TNS listener was not found This issue is generally caused...
  • Wiki Page: 492-16178 - HOWTO: Troubleshoot duplicate companies returned by Company search

    Summary: This KBA illustrates a technique for identifying the cause of duplicate companies being returned when doing a Company search. This issue may also manifest as views being missing when creating a group on the Company entity. Symptoms: An number of existing scripts for the identification fo duplicates...
  • Wiki Page: 492-17513 - Patch upgrade: Uncommitable transaction in ViewsUpdate.es

    Summary: An error referring to an uncommittable transaction may be logged as part of an upgrade to an on-premise copy of Sage CRM. Symptoms: The below may appear in 7.1ViewsUpdate.es: Get Errors 1 Items After line 6675: SQLError: Uncommitable transaction is detected at the end of the batch. The transaction...
  • Wiki Page: 536-15802 - Cannot complete metadata refresh for views after upgrade

    Summary: The following issue may be logged to eWare system and SQL logs following an upgrade of Sage CRM: execsql,time,sql,errormsg 1248 exec fixViewsMetadata Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1 Symptoms...
  • Wiki Page: 536-17536 - External Db Date Fields Imported to CRM as 0-Length Text Type

    Summary: When you add a MySQL or MSSQL database connection through Administration -> Advanced Customisation -> Tables and Databases all Date type fields are imported as Text with a length of 0. Workaround: Use DateTime as the field type on the database. Status: This issue has been resolved in Sage...
  • Wiki Page: 492-17713 - Restricted characters in CRM passwords

    Summary: There exist four restricted characters in Sage CRM that indicate whether a password string is encrypted. These characters are " # ", " ^ ", " $ " and " & ". Passwords to be used in CRM, such as database connection passwords, should not begin with any...
  • Wiki Page: 687-17849 - Troubleshooting issues with Oracle Database connections

    Summary: There are several steps that should be taken when troubleshooting connection issues to Oracle databases. Firstly you should follow the guide on installing Oracle in a distributed environment: https://community.sagecrm.com/partner_community/b/hints_tips_and_tricks/archive/2010/08/12/setting-up...
  • Wiki Page: 492-17877 - Webapp connection failure when using Latin1_General_Bin collation

    Summary: After installing a copy of Sage CRM onto an instance of Microsoft SQL Server using the Latin1_General_Bin collation, you may find that the CRM webapps cannot connect to the database. This is due to Latin1_General_Bin being a case-sensitive collation, and a setting in the db.properties being...
  • Wiki Page: 492-17885 - User Access Logging database performance issues

    Summary: Errors being logged by the User Access Logging (UAL) feature in Windows Server 2012 may result in poor database server performance. Symptoms: Users may report poor database performance when interacting with Sage CRM. This may take the form of timeouts, or actions taking longer than expected...
  • Wiki Page: 492-15653 - Unable to connect to database - non-default SQL Server instance

    Summary: An error may appear in the Tomcat localhost.log specifying that it is unable to load a resource. Depending on the CRM version, this error may refer to an issue loading a bean with names metaDataDao, currencyList or some other resource. The root cause of the error as given in the logs will be...
  • Wiki Page: 632-17538 - How to re-encrypt the SQL database password from plain text.

    Summary: If there is connection problem between Sage CRM and the SQL database the database password may need to be changed into plain text. This guide explains how to re-encrypt the SQL database password from plain text. More information: 1. To Update the SQL login details for Sage CRM open the registry...
  • Wiki Page: 687-17980 - Linking to external table doesn't create entry in Custom_Edits

    Summary: If you create a connection to an external database, then a table connection based on the external database the Custom_Edits table will not auto populate with the fields from the external table. Symptoms: Custom_Edits table is not automatically updated with the fields from an external table when...
  • Wiki Page: 492-18017 - You may need to recreate views manually: Class does not exist

    Summary: Users of Sage CRM may periodically experience a "You may need to recreate views manually" error when using Sage CRM. The issue can only be resolved by carrying out an IIS reset. Symptoms: The following error message appears onscreen You may need to recreate views manually. In the eWare...
  • Wiki Page: 492-18038 - Sage CRM 7.2: Compatibility with SQL Server 2014 and 2016

    Summary: A query was received regarding whether Sage CRM 7.2 will be supported with Microsoft SQL Server 2014 or 2016. Sage CRM 7.2 has not been tested with Microsoft SQL Server 2014, and as such has not been added to the support matrix. It will not be tested with Microsoft SQL Server 2016. While it...
  • Wiki Page: 710-18095 - SQL Views script

    Summary: This will list all of the views on the database with a column highlighting if they are working correctly or not. Views that are populated with ‘Bad’ will need to be dropped or refreshed. Please also be aware that some views are dependent on other views. Once you have fixed the issue...
  • Wiki Page: 710-18102 - SQL script that can be used to search a database for text.

    Summary: SQL script that can be used to search a database for text. Resolution: DECLARE @search_string VARCHAR(100), @table_name SYSNAME, @table_id INT, @column_name SYSNAME, @sql_string VARCHAR(2000) SET @search_string = 'Test' DECLARE tables_cur CURSOR FOR SELECT name, object_id FROM sys.objects...
  • Wiki Page: 720-18175 - Identity value jumps when SQL Server restarts

    Summary: Identity value jumps when SQL Server restarts Version: SQL Server 2012 Issue: When you restart SQL Server instance then the value of table's Identity column jumps and the actual jumped value depends on identity column data type. If it is integer (int) data type, then jump value is 1000 and...
  • Wiki Page: 720-18146 - Results being returned via Keyword Search

    Summary: Results being returned via keyword search. Resolution: If you are experiencing issues with the results being returned via keyword search. Please try the below steps: 1. Using SQL, Clear out the values held in KeywordFullIndexStart and KeywordFullIndexFinish entries on Custom_Sysparams 2. Restart...