a CMS_AUDITTABLE table column is too small

[cifirim]

Hi,

A null value is inserted in the UserGroups column of the CMS_AUDITTABLE when a user is member of too many groups.
In the Windows Event Viewer we have the following error :


Event Type: Warning
Event Source: Crystal_CrystalMS
Event Category: (40)
Event ID: 50255
Date: 29/11/2006
Time: 17:32:19
User: N/A
Computer: CRYSTAL
Description:
The value Administrators|Group1|Group2|Group3|Group4|HR|Finance|Safety|Sales|Eco|Stocks|Purchases|Production|Highlights|Plans|Restriction/NI/FI/N0|Restriction/NI/PR/N2|Restriction/NI/VE/X2|Restriction/NI/VE/X1|Restriction/NI/VE/X9|Restriction/GR/RH/N0|Users ERL|Restriction/GR/FI/N0|Restriction/GR/TR/N0|ERM Group|Nomad|Mobile|ALL_MEMBERS|Restriction/GR/AC/N0|Restriction/GR/PR/N0|Restriction/GR/ST/N0|Restriction/GR/VE/N0|Group|Domain|lala|GRP_ADM_ERL|Restrictions|Everyone is too large for the audit database column UserGroups


The initial size of that column is 255, we increased it to 1024 but the error still occurs.
Is there any way to fix that problem or any workaround ?

Michael

 

[satinsilhouette]

Sounds like you need to contact support at BOBJ.

Thanks so much!
satinsilhouette

 

[elsenorjose]

If you're using the MySQL database that came with BO, this shouldn't be causing a problem. What data type do you have that field defined as? If it's VARCHAR (1024) then that value should not be too large. Verify the datatype. If it's not VARCHAR (1024), change it and try it again. If it is, then as satin says, sounds like a BO call.

 

[cifirim]

We are actually using CE 10 with SQL Server, the column is originally nvarchar (255).
After the modification we restarted the CMS (we even restarted the server itself) but it didn't help.
Yes, me might need to contact BO support unless someone here has THE idea.

Thanks for your help