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 .
Published February 26, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.