Error "inserted value too large for column" When Adding Users to Collaboration Project. (Doc ID 726798.1)

Last updated on MAY 09, 2023

Applies to:

Symptoms

When trying to add more users to a project, the following error is generated:

Event generated by user 'e59322' at host '<Sample Domain>.com'. Unable to execute service
EDIT_COLLABORATION_MEMBERS and function UcollectionAccessLists.
(System Error: Unable to execute query 'UcollectionAccessLists(UPDATE ColMeta SET
xClbraUserList='&c23149(RW),&e18186(RW),&c29838(RW),&e44256(RWDA),&e61108(RWDA),&c17988(RW),&e19887(
RWD),&e23609(RW),&e34779(RW),&e44341(RW),&c29866(RW),&c36143(RW),&c16574(RW),&c19268(RW),&c19373(RW)
,&c29111(RW),&c29830(RWD),&c29950(RW),&c20799(RW),&e18616(RW),&c21408(RW),&e44342(RW),&c29591(RW),&c
20782(RWD),&e28038(RW),&e22291(RW),&c35071(RWD),&e36735(RW),&e29294(RW),&e19825(RW),&e20371(RW),&e23
321(RW),&e24182(RW),&e26445(RW),&e27097(RW),&e27989(RW),&e29323(RW),&e33158(RW),&e33817(RW),&e34027(
RW),&e34052(RW),&e34478(RW),&e34742(RW),&e34835(RW),&e34857(RW),&E34864(RW),&e35326(RW),&e37161(RW),
&e37224(RW),&e37248(RW),&e37320(RW),&e37348(RW),&e37733(RW),&e37872(RW),&e37970(RW),&e38096(RW),&e38
133(RW),&e38496(RW),&e38786(RW),&e41888(RW),&e41926(RW),&e44231(RW),&e44257(RW),&e44317(RW),&e44346(
RW),&e44374(RW),&e44488(RW),&e44613(RW),&e44656(RW),&e44665(RW),&e44699(RW),&e46167(RW),&e46310(RW),
&e49239(RW),&e49444(RW),&e50049(RW),&e24828(RW),&c29614(RW),&c29956(RW),&c18871(RW),&e41925(RW),&q80
480(RW),&e20152(RW),&e28096(RW),&c28111(RW),&c19077(RW),&e59950(RW),&c18851(RW),&e24765(RW),&e44575(
RW),&e34632(R),&e44236(RW),&e59648(RW),&c29999(RW),&c19216(RW),&e25655(RW),&e44751(RW),&c20706(RW),&
c19379(RW),&e82639(RWDA),&e25023(RWD),&e27382(RW),&c20600(RW),&e44294(RWDA),&c21228(RW),&e44363(RW),
&e44581(RW),&e28237(RW),&e44548(RW),&e35185(RW),&e25870(RWDA),&e34487(RWDA),&e25787(RW),&e49561(RW),
&q59995(RW),&c17350(RW),&c30108(RWD),&e20343(RW),&e36799(RWDA),&q78535(RW),&e59614(RW),&c19851(RW),&
c20180(RW),&nocagent1(RW),&nocagent2(RW),&nocagent3(RW),&nocagent4(RW),&NOCAdmin(RWDA),&e44350(RW),&
e27059(RW),&q81166(RW),&c30182(RW),&q39097(RW),&q49288(RW),&q49630(RW),&q49650(RW),&c25442(RW),&c200
53(RW),&c30200(RW),&q78534(RW),&e42679(RW),&c29755(RW),&e28383(RW),&c23348(RWD),&e19055(RWA),&c16418
(RW),&c28409(RW),&e44280(RW),&e44701(RW),&e29489(RW),&e33908(RW),&c19639(RW),&e24593(RW),&e26107(RW)
,&c25441(RW),&e18815(RW),&q84257(RW),&c19978(RW),&e24875(RW),&e41892(RWDA),&c20275(RWD),&c35658(RWD)
,&e58837(RW),&e28508(RW),&e41900(RW)', xClbraAliasList=''
WHERE ColMeta.dCollectionID=5)'.
ORA-01401: inserted value too large for column)

Error in the browser states:

Content Server Request Failed
Unable to build the collaboration project form. The value entered for
'apNgClbraUserListFieldCaption' exceeds 2,000 characters, the maximum length allowed for this field.





.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.