PegaProDeveloper3000 Member since 2018 1 post
VEB Technologies
Posted: January 3, 2019
Last activity: January 4, 2019

Problem writing an instance to the database: code: -302 SQLState: 22001

We have a problem with sql error.

The size of our BLOB is 1.572 Mb. Size of our work object is greater than this value, but information of the case is about 65 Kb.
I will try to explain in the screenshots below.
If we delete a large page, our blob size will be 1.5 Mb smaller, and we will be able to save the work object.

Then, if we create a blank page with the same name, then the size of the object is big again
If we repeat steps (delete and create page) the problem is fixed.

These cases with such problem appear randomly.
Does anybody know why it happened?
Thank you!
Pega Platform 7.1.9

Pega Platform Case Management
Moderation Team has archived post
Share this page LinkedIn