Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Obj-Open not bringing columns having blank value in table

SA-19572

Summary



When a table is having a NOT NULL column and entered a space value into the column. If the record is opened using obj-open the column values with space are not populated in clipboard. If modified, the record shows exception. Customer is using oracle.The same feature was working in PRPC 6.2


Error Messages



"TBSPACEID=9, TABLEID=28, COLNO=13" is not allowed.. SQLCODE=-407, SQLSTATE=23502, DRIVER=3.64.133 at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:260) at com.pega.pegarules.data.internal.access.Saver.updateInstance(Saver.java:1169) at com.pega.pegarules.data.internal.access.Saver.saveInstance(Saver.java:903) at com.pega.pegarules.data.internal.access.Saver.saveInstance(Saver.java:777) at com.pega.pegarules.data.internal.access.Committer.performOps(Committer.java:285) at

Steps to Reproduce



1. Create a table with NOT NULL columns.
2. Make entry to that table with blank space as values.
3. try to modify that record with Obj-Open.

Root Cause



User wasn't providing values to non-null columns.

Resolution

Suggested user to pass all the values to non-null columns or make those columns nullable so that they wouldn't provide values to nullable columns .

Suggest Edit

Published February 26, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

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

Pega Community 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
Contact us