Question

4
Replies
1025
Views
Vadym582 Member since 2017 1 post
Luxoft
Posted: 3 years ago
Last activity: 2 years 7 months ago
Closed

Pega + database - > some issues

Hi

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
Share this page LinkedIn