Question
Standard Charted
IN
Last activity: 13 Mar 2024 1:46 EDT
Commit Error: ORA-12899: Value too long in Pega
Hi All,
WE are getting Commit Error while submitting assignment,
dataPlease let me know any idea how we can over come this error from Pega end
Attached image.
Kindly help me on this
Regards,
Surya
Accepted Solution
Updated: 13 Mar 2024 1:46 EDT
LTIMindtree
IN
@SuryaYanamandradont know if substring is required rather go on a holistic way of increasing, if not use @substring from expression builder to capture only data which you require.
LTIMindtree
IN
@SuryaYanamandra The ORA-12899 is an Oracle error that occurs when the value entered into the column string is too large.
Check the size of the column and its corresponding data am pretty sure its a size mismatch either increase character size in table in oracle DB. or reduce the size of the data which you are going to insert.
If you have db access fine check using DESC and its corresponding size.
Else check from configure and then go to database and see schema from selecting schema and table.
Hope this helps.
Standard Charted
IN
@Soham_Chanda1107 Hi Soham, thanks for the response, may I know any function that we need to substring particular property value once user clicks on submit to compelte assignment
Accepted Solution
Updated: 13 Mar 2024 1:46 EDT
LTIMindtree
IN
@SuryaYanamandradont know if substring is required rather go on a holistic way of increasing, if not use @substring from expression builder to capture only data which you require.
Standard Charted
IN
@Soham_Chanda1107 Thanks bhai for your help.