Support Article

Live Campaign fails due to an error on the program run



User has configured a campaign to run every month. The campaign execution fails.

Error Messages

Below error appears in the log :-

Error on node [] com.pega.dsm.dnode.api.dataflow.StageException: Exception in stage: BatchOutPR123_VC at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageOutputSubscriber.onError( at com.pega.dsm.dnode.api.dataflow.DataFlowStageProcessor.onError( at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageInputSubscriber.onError( at

Caused by: Cannot insert records to database Message: BatchUpdateException: ORA-12899: value too large for column "PEGA_NBAM"."BATCHOUTPR365_VC"."PRIMARYCONTACTDETAILS" (actual: 33, maximum: 32) Message: SQLException: ORA-12899: value too large for column "PEGA_NBAM"."BATCHOUTPR365_VC"."PRIMARYCONTACTDETAILS" (actual: 33, maximum: 32) at com.pega.dsm.dnode.impl.dataset.database.DatabaseSaveOperation.insertBatch( at com.pega.dsm.dnode.impl.dataset.database.DatabaseSaveOperation.access$400( at com.pega.dsm.dnode.impl.dataset.database.DatabaseSaveOperation$1.executeExposedLogic( at com.pega.dsm.dnode.impl.dataset.database.DatabaseOperationsUtil$2.emit( ... 18 more

Caused by: java.sql.BatchUpdateException: ORA-12899: value too large for column "PEGA_NBAM"."BATCHOUTPR123_VC"."PRIMARYCONTACTDETAILS" (actual: 33, maximum: 32) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch( at oracle.jdbc.driver.OracleStatementWrapper.executeBatch( at at com.pega.dsm.dnode.impl.dataset.database.DatabaseSaveOperation.insertBatch( ... 21 more

Steps to Reproduce

Run a Campaign in Pega Marketing with Segment having user's contacts with longer characters (32 characters).

Root Cause

The property PRIMARYCONTACTDETAILS did not have a "Max Length" set.

As a result in the BatchOUTPR table the corresponding column size defaulted to 32 bytes.

The column 'PRIMARYCONTACTDETAILS' was attempted to populate with larger data when the property was set with a value larger than 32 characters.


Modify the Property PRIMARYCONTACTDETAILS and increase "Max length".

Published May 16, 2017 - Updated June 29, 2017

Have a question? Get answers now.

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