Areteans Technology Solutions Private Limited
Last activity: 24 Feb 2023 1:32 EST
Data Jobs Import Failing for Constraints
We have recently moved to Pega v8.8.1. We are currently trying to implement data jobs in our application wherein we are importing data from a file dataset to CAR. We are testing few failure scenarios like sending few rows with CustomerID as blank where CustomerID is the primary key. Strangely, it is not throwing any constraint violation and allowing to insert the data with blank CustomerID. Same thing is happening for any column which has a NOT NULL constraint. Also, if I remove the CustomerID field from any row in the file, instead of failing the run completely, it is skipping that row and inserting the remaining ones.
Has anyone faced this issue before? How can we resolve this as this is happening for any non-null type column.