Unable to View Contacts in the SalesLogix LAN client- ” is not a valid integer value

 We recently had a client run into an issue where they were unable to open the Contact area of the SalesLogix LAN client.  When they attempted to navigate there, they would receive the following:


It turns out that somehow a Contact Process had been created with a bad value in the SUSPENDED column.  in the PROCESS table, the SUSPENDED column is supposed to store either a 0 or 1, but one record had a NULL value.

Running the following SQL statement fixed the issue:

update process set suspended = 0 where suspended  is null


Kris Halsrud

Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!