Skip to content
Skip to content
  • There are no suggestions because the search field is empty.

"" is not a valid integer value

This happens because there is a company number in cxClient.InternalClientId that is not a valid number.
It must be resolved via SQL.

Run this:

select distinct case when charindex(';', InternalClientId) > 0 
then substring(InternalClientId, 1, charindex(';', InternalClientId) - 1)
else InternalClientId end
from cxClient

Check that one of the rows has a NULL value.

Then run:

select * from cxclient

Find the row where InternalClientId is NULL.
Run delete on the row with the NULL value in InternalClientID:

delete cxclient where ClientId='clientnumber'

Example:

delete cxclient where ClientId='16'

Did you not find the answer?

Contact support at support@aritma.com or +47 55 34 91 50.