Error while creating user

[Former Member]

Hi,

At the moment we try to create a new user in SAP B1 there is an error message : “[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'UserSign', table 'dbname.dbo.CUMI'; column does not allow nulls. INSERT fails. '' (CUMI)”.

We tried what the Note 147217 said (System creates many B1i users), and after deleting and updating those B1i users (we had too many), the same error message is shown when adding a new user.

How can I solve it?

Thanks in advance.

Regards.

[Former Member · Accepted solution]

Dear Maria

We also faced the same issues once. By doing the following process, we able to manage the situation.

1. 1.Delete the unwanted B1i users from OUSR table,
2. 2.Find the maximum number of ouser.userid ( Ensure it is under small integer limit ,32768)
3. Locate the object code in 12 ONNM table
4. 4.Update the  ONNM .autokey value into   Ouser.userid+1

Please check & update your patch level. Otherwise auto generation of B1i users may goes on.

Warm Regds

Vinod

[jitin_chawla]

Hi,

Are you getting the same error after following the solution steps in the Note? Have you checked the autokey value for the ObjectCode '12' in table ONNM?

Updating any values in table of the database without support's approval will render your database out of support scope.

Kindly log a support ticket, if the issue is not resolved and mention the details of the steps already taken and status of the issue.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Hi all,

Thanks for all your responses.

The AutoKey Value for Object'12' in Table ONNM is 52333. The maximum OUSR.UserID is 19975.

Regards,

Maria.