SA-23363

Summary

An intermittent  Visual Business Director (VBD) problem where the application freezes when writing out. The issue is preceded by an error message.
This is connected to VBD because when the corresponding interaction rule is modified by deselecting the "Write to VBD," the system works fine. When it fails it writes to the interaction history.

Error Messages

**Date and time**,067 [_vbd.cached.thread-1] [ STANDARD] [ ] [ ] (l.access.ConnectionManagerImpl) ERROR - Connection returned to manager with auto commit off; rolling back transactions
java.lang.Exception
at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.returnConnection(ConnectionManagerImpl.java:2290)
at com.pega.decision.vbd.hazelcast.service.actuals.ActualsPersistenceImpl.loadPartition(ActualsPersistenceImpl.java:414)
at com.pega.decision.vbd.hazelcast.service.operation.ActualsLoadDataTask.run(ActualsLoadDataTask.java:124)
at com.hazelcast.util.executor.CachedExecutorServiceDelegate$Worker.run(CachedExecutorServiceDelegate.java:209)
.
.
.

Steps to Reproduce

Create interaction, and use the application without deselecting the "Write to VBD" option.

Root Cause

A defect in Pegasystems’ code or rules:
VBD partitions fail to load when facts refer to dimensions of SQL type Timestamp, Time or Date, and the dimension value is null.

Resolution

Apply HFix-27441.