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

Program, when run, does not write to database table

SA-14346

Summary



Program is run and does not write to database table. However, if the output template is file, it completes successfully.


Error Messages



2015-09-08 12:21:51,039 [   PegaRULES-Batch-2] [  STANDARD] [                    ] [     DEMO:01.01.01] (      internal.mgmt.Executable) ERROR   - Exception 
java.lang.NullPointerException 
    at com.pegarules.generated.activity.ra_action_writetotable_b744c409820e875ce9ddbed320414583.step14_circum0(ra_action_writetotable_b744c409820e875ce9ddbed320414583.java:1326) 
    at com.pegarules.generated.activity.ra_action_writetotable_b744c409820e875ce9ddbed320414583.perform(ra_action_writetotable_b744c409820e875ce9ddbed320414583.java:357) 
    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500) 
    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521) 
    at com.pegarules.generated.activity.ra_action_outboundagenthelper_c005c0a4a34fc2534b353fc093a57cb6.step3_circum0(ra_action_outboundagenthelper_c005c0a4a34fcc093a57cb6.java:362) 
    at com.pegarules.generated.activity.ra_action_outboundagenthelper_c005c0a4a34fc2534b353fc093a57cb6.perform(ra_action_outboundagenthelper_c005c0a4a34fc253fc093a57cb6.java:103) 
    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500) 
    at com.pega.pegarules.session.internal.async.agent.QueueProcessor.runActivity(QueueProcessor.java:721) 
    at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:602) 
    at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:945) 
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1259) 
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1008) 
    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:901) 
    at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:670) 
    at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:991) 
    at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:532) 
    at java.lang.Thread.run(Thread.java:745)



Steps to Reproduce



1. Create a Segment.
2. Create an Email treatment .
3. Create an Offer with Generic Shape. Connect to Start and End shape. Add the earlier created email treatment and DB template in the shape and save the offer.
4. Create a strategy and use the earlier created offer.
5. Create a program using the above components.
6. Once the program completes, verify the table is generated with said number of records as per segment in the database.


Root Cause



Issue is due to the missing DEFAULT instance of Data-System-Topology.


Resolution



Enable the Agent ProcessBatchJob in the PegaNBAM-Artifacts by following the below procedure. The default topology instance is automatically created on saving the agent status from topology landing page.

1. Ensure that the agent ProcessBatchJob in the PegaNBAM-Artifacts is enabled and running.
2. Log in as the default user - [email protected]
3. Navigate to DesignerStudio > Decisioning > Infrastructre > simulation Settings >Topology. Save the topology.
4. Navigate to Data-System-Topology and the DEFAULT instance is created. 

Published October 1, 2015 - 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