Question

1
Replies
332
Views
EugeneR7 Member since 2013 30 posts
Deutsche Bank
Posted: April 24, 2018
Last activity: April 26, 2018
Closed

Pega save to non-nullable column populated by database triggers

On the back of this original question (which was never answered)

https://pdn.pega.com/community/product-support/question/pega-database-some-issues

We have a number of optimizations of our work tables (pc_work equivalent) which require the use of oracle triggers to populate a few columns. The columns are non-nullable, and are not expected to be set/populated by Pega workflows. They are populated with Before Insert / Update trigger.

On issuing a Obj-Save / commit, we run into an issue where we get an error such as:
** trying to store an empty property MY_PROPERTY_NAME to a database column that does not accept nulls: code: <none> SQLState: <none> Message: <none>

This is not an Oracle error, but a Pega generated error because there is not an ORA error, nor is the query registered on database. There are also no relevant errors in the Pega logs except for EXCP0001 in the Pega Alerts indicating the issue above.

Question is: Without creating column-named properties, and defaulting their values (via Pega trigger, or something like NewDefaults), is there an ability to have Pega ignore column definition? Or at least allow inserts to non-nullable columns? It might be better to have this handled by database where we have a proper trackable error.

***Moderator Edit: Vidyaranjan | Updated Categories***

Data Integration
Moderation Team has archived post
Share this page LinkedIn