Article ID: 3667, created on Feb 8, 2008, last review on May 1, 2014

  • Applies to:
  • Helm 3

Resolution

Problem/Summary
When trying to add new users, they don't get added to site permissions. The following error is given:

SELECT (Max(CONVERT(Int, RIGHT(AccountNumber, LEN(AccountNumber)-LEN('CF'))))+1) as NextAccountNumber FROM Account WHERE LEFT(AccountNumber,2) = 'CF'
(Syntax error converting the varchar value 'MX1' to a column of data type int.)
2003-08-05 21:33:47 HELMDA:UserData::GetNextAccNum Execution failed. SQL was:
SELECT (Max(CONVERT(Int, RIGHT(AccountNumber, LEN(AccountNumber)-LEN('CF'))))+1) as NextAccountNumber FROM Account WHERE LEFT(AccountNumber,2) = 'CF'
(Syntax error converting the varchar value 'MX1' to a column of data type int.)
 
Solution

These errors are to do with creating new Helm user accounts where the prefix that someone is using is part of someone else's. You need to choose a different prefix.
 

110556ad4b9f1c73a3682661cd1dca89 152090ff5e9a05ea7e1cf0c248449638 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF