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