Vadym V (Vadym582)

Vadym582 Member since 2017 1 post
Posted: September 21, 2017
Last activity: October 16, 2018
Posted: 21 Sep 2017 6:36 EDT
Last activity: 16 Oct 2018 12:03 EDT

Pega + database - > some issues


I have a few questions:

1. I added a field in the table with restriction NOT NULL.

This field is populated inside the BEFORE INSERT/UPDATE TRIGGER on the table.

It is works in sql via INSERT INTO table Values(...)

But Pega, says error like "pyCommitError: Trying to store empty properties XXX to a database column that does not accept nulls"

I.e. Pega does not try to call the database :-(

How to do that Pega does not check some properties/fields?

2. I have two tables

master table - primary key PZINSKEY

child table - has field PXINSINDEXEDKEY as reference to MASTER.PZINSKEY

When I work in Pega UI and add new record

then first INSERT into child table

next INSERT into master table

How to change order of INSERT operation?

First INSERT must be into MASTER table

Next INSERT must be into CHILD table

Is it possible?

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

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

System Administration Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.