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

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 June 30, 2017 - Updated December 2, 2021

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