Browse By Tags

  • Wiki Page: 536-17216 - SQL error shows when deleting records

    Summary: Deleting a person or company results in an SQL error: "An unexpected event has occured: Exception: SQL Error" However the record is actually deleted. Symptoms: SQL Error : Incorrect syntax near the keyword 'WHERE' (DELETE FROM WHERE Visi_CompanyId = 27579) SQL Error : Incorrect...
  • Wiki Page: 492-17410 - New Line Item button in Quotes performance

    Summary: Selecting the New Line Item button on a quote, where CRM is using a large number of products (100,000+) may result in a timeout. Symptoms: The user may experience a SQL timeout, or the screen may render, eventually. Cause: There are two separate issues here. Typically, a CRM install with an...
  • Wiki Page: 492-17719 - Upgrades: Cannot open a query with no SQL

    Summary: On upgrading a copy of Sage CRM, an error may be logged on running tables.es. The error refers to an issue opening a query with no SQL. This issue is likely caused by the presence of an index on a table, blocking the changing of a column's data type. Symptoms: A specific example was logged...