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



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 at at at at 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.


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 .

Published February 26, 2016 - Updated October 8, 2020

Was this useful?

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.

Did you find this content helpful?

Want to help us improve this content?

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