SA-28062

Summary

When running a Distribution test, the campaign fails with error.

Error Messages

On the screen
"Exception in stage: BatchOutPRXXXXXX
Suspend and Update the campaign to resolve this issue. After updating, you can Restart or Skip this run."

In the PegaRULES.log
When opening the problem Data Flow instance in Designer studio->Decisioning->Decisions->Data Flows->Batch Processing, a NullpointerException is thrown as below:

2016-09-01 07:43:24,123 [http-bio-8080-exec-3] [TABTHREAD2] [ AN_APP:01.01.01] (a_Decision_DDF_RunOptions.When) ERROR a_host|aaa.bb.cc.dd an_operator - Exception caught while evaluating when java.lang.NullPointerException
at com.pegarules.generated.pzIsDataFlowUltimatePrimarySourceA_071017_Q_LoGQoB4ZtD2vYbHIRHaQ.pzIsDataFlowUltimatePrimarySourceAbstract07_10_17(pzIsDataFlowUltimatePrimarySourceA_071017_Q_LoGQoB4ZtD2vYbHIRHaQ.java:99)
at com.pegarules.generated.pzIsDataFlowUltimatePrimarySourceA_071017_Q_LoGQoB4ZtD2vYbHIRHaQ.invoke(pzIsDataFlowUltimatePrimarySourceA_071017_Q_LoGQoB4ZtD2vYbHIRHaQ.java:77)
at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:133)
at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:110)
at com.pega.pegarules.generation.internal.library.LibraryFunctionUtilityImpl.resolveMethodCall(LibraryFunctionUtilityImpl.java:3138)
at com.pega.pegarules.session.internal.mgmt.Executable.resolveMethodCall(Executable.java:11077)
at com.pegarules.generated.when.ra_when_pzultimateprimarysourceisabstractorstream_03c6155c0f0bca2fe2076296eecee9ea.evaluate(ra_when_pzultimateprimarysourceisabstractorstream_03c6155c0f0bca2fe2076296eecee9ea.java:50)
at com.pega.pegarules.session.internal.mgmt.Executable.evaluateWhen(Executable.java:4224)

Steps to Reproduce

1. Create campaign.
2. Go to Distribution test > Error.

Root Cause

A defect or configuration issue in the operating environment. When tracing the Data Flow opening event through the Designer Studio, an Oracle error of ORA-12899 is capture when the pxLoadProcess activity is invoked. The stacktrace indicates a defined attribute length in the database is too short and causing an insert problem.

Resolution

Increase the database column attribute length.