Question

6
Replies
81
Views
MarcusS9941 Member since 2015 4 posts
Deutsche Bank AG
Posted: December 14, 2017
Last activity: February 15, 2018
Closed
Solved

MARKETING DIRECTOR - segment creation is causing unique constraint violation in table STORED_FLD_TEMPL

Hi together,

we are using PEGA MARKETING DIRECTOR 6.6. Our business users are facing the issue that the creation of a new segment is causing an error. When checking the user logs we can see the oracle error UNIQUE CONSTRAINT VIOLATED for table STORED_FLD_TEMPL.

When checking the table based on the primary key it seems that the application has taken an existing SEG_ID for the new segment.

We have discovered a workaround for this in a way that business users can create a copy of an existing segment. This is working for them and a new valid SEG_ID is created. After doing that the CREATE SEGMENT option is working from scratch also.

Anyways this behaviour is unsatisfying and needs to be solved.

Thank you in advance for your support.

***Updated by moderator: Lochan to tag SR***

Data Integration SR Created
Moderation Team has archived post
Share this page LinkedIn