Getting error while creating segments in Pega Marketing 8.7

General
, , , ,
1

Hi Team

When I am trying to save a segment, it is showing the below exception.

And also, it is not creating the segment tables for the segment class.

Found below issue in tracer :

CreateSegmentTable - Exception retrieving DB connection to create segment table

Fail :

 Unable to open an instance using the given inputs: pxObjClass = "Data-Admin-DB-Table", pyClassName = "TalkFree-Data-Subscription-SEGPOC"

Segment error ss.png
Segment error ss.png1677×560 39.4 KB

Please let me know what am I missing here.

Thankyou

Harsh

Segment error ss.png
Segment error ss.png1677×560 39.4 KB

2

@Harsh_Kumar Check the mapping of your ExternalMktData database rule. It should have the connection details to directly connect to the schema in the database. FYI, if you are trying to do any POC and not using separate database and schema to store customer details, do not inherit the details from PegaDATA which is a usual mistake.

The jdbc connection URL has to be in below format:

jdbc:postgresql://:/?currentSchema=externalmktdata