a CMS_AUDITTABLE table column is too small
a CMS_AUDITTABLE table column is too small
(OP)
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
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

Talk To Other Members
RE: a CMS_AUDITTABLE table column is too small
Thanks so much!
satinsilhouette
RE: a CMS_AUDITTABLE table column is too small
RE: a CMS_AUDITTABLE table column is too small
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