Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Kanstantsin Krylovich (KanstantsinKrylovich)
VEB Technologies
software engineer
VEB Technologies
KanstantsinKrylovich Member since 2018 1 post
VEB Technologies
Posted: Jan 3, 2019
Last activity: Jan 4, 2019
Posted: 3 Jan 2019 4:39 EST
Last activity: 4 Jan 2019 13:59 EST
Closed

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

Hello!
We have a problem with sql error.

Show More

Hello!
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


Show Less
To see attachments, please log in.
Pega Platform
Case Management

Related content:

Question

Problem writing an instance to the database: code: 1502 SQLState: 72000 Message: ORA-01502: index 'PEGA_DATA.PK_PC_EVENTS' or partition of such index is in unusable state

Question

SQL error in ListView: There was a problem getting a list: code: 0 SQLState: 42601 message

Question Solved

Pega 8.7.1 - There was a problem getting a list: code: 0 SQLState: HY008

Question Solved

There was a database problem when performing an RDBExecute: code: 0 SQLState: Message: Invalid column count. Cannot be less or equal to zero

Question Solved

There was a database problem when performing an RDBExecute: code: 0 SQLState: <none> Message: No value has been inserted

Question

An error occured on executing the query for the report definition - There was a problem getting a list: code: 200035 SQLState:

Question Solved

trying to store an empty property ID to a database column that does not accept nulls: code: SQLState: Message:

Question

Obj-Browse SQL query: Error sqlcode=-302 sqlstate=22001

Question Solved

getting here was a problem getting a list: code: 22835 SQLState: 99999 while running Report definition

Discussion

An error occured on executing the query for the report definition - There was a problem getting a list: code: 200035 SQLState: 0A0

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice