Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Segment Refresh failures in Production

SA-3938

Summary



A segments refresh was executed btw 4PM-7PM GMT which later got failed.

The segment refresh jobs are failing regularly. We would like to know the cause for these failures and what actions need to be taken to avoid segment refresh failures in future?


Error Messages



Aample from one of the nodes:

2014-10-29 17:25:51,492 [ PegaRULES-Batch-3] [ STANDARD] [ PegaNBAM:06.03] (port_Definition_Segment.Action) ERROR - PopulateSegmentTable: SQL Error ocurred whilst populating the segment PopulateSegmentTable: SQL error whilst populating segment: There was a problem getting a list: code: 17002 SQLState: 08006 Message: IO Error: Connection timed outSQL = INSERT INTO MKTSEGChaser2UserExTr (CustomerID) SELECT "PC0".CUSTOMER_ID AS "CustomerID" FROM GENIE.V_CUSTOMER_SPINE "PC0" WHERE ( ( ( "PC0".CAR_LAST_PURCH_DT < TRUNC(SYSDATE) - ? OR "PC0".CAR_LAST_PURCH_DT is null ) AND ( "PC0".HOM_LAST_PURCH_DT < TRUNC(SYSDATE) - ? OR "PC0".HOM_LAST_PURCH_DT is null ) AND ( "PC0".BIKE_LAST_PURCH_DT < TRUNC(SYSDATE) - ? OR "PC0".BIKE_LAST_PURCH_DT is null ) AND ( "PC0".PET_LAST_PURCH_DT < TRUNC(SYSDATE) - ? OR "PC0".PET_LAST_PURCH_DT is null ) AND ( "PC0".VAN_LAST_PURCH_DT < TRUNC(SYSDATE) - ? OR "PC0".VAN_LAST_PURCH_DT is null ) ) AND "PC0".IS_MAILABLE_IND = ? AND "PC0".IS_LATEST_IND = ? AND "PC0".MRKTG_OPT_IN_IND = ? AND "PC0".CAMPAIGN_COUNT < ? AND "PC0".ACQSTN_DT < TRUNC(SYSDATE) - ? ) AND ( ( "PC0".CUSTOMER_ID IN( SELECT "S_MKTSEGQtEQ4dClkMo4d".CustomerID From MKTSEGQtEQ4dClkMo4d "S_MKTSEGQtEQ4dClkMo4d")) )

2014-10-29 17:25:51,499 [ PegaRULES-Batch-3] [ STANDARD] [ PegaNBAM:06.03] (port_Definition_Segment.Action) ERROR - Failure in processing segment: CHASER2USEREXTR -

2014-10-29 17:25:51,773 [ PegaRULES-Batch-3] [ STANDARD] [ PegaNBAM:06.03] (PegaMKT_Work_ProgramRun.Action) ERROR - ExecuteProgramRun - Error in refreshing the segment '' for 'Chaser2UserExTr Program Run' with the following message - Segment population error

2014-10-29 17:25:51,924 [ PegaRULES-Batch-3] [ STANDARD] [ PegaNBAM:06.03] (Work_ProgramRun_TestRun.Action) ERROR - Failure on ExecuteProgramRun: Your Program Run has failed because of a problem refreshing your Starting Population 'CHASER2USEREXTR'

Steps to Reproduce



Runs daily

Root Cause



The root cause of this problem is defect/misconfiguration in the PRPC operating environment. There is a firewall between the App server and DB server and the connectivity between them is via a VPN. We observed lots DB alert of "TNS: operation Timeout Error" that suggest a session timeout.



Resolution



This issue is resolved through the following local change:
Updated the SQLNET.ora file to increase the Expire_Time to 10 minutes.
SQLNET.EXPIRE_TIME=10
 

Published January 31, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us