VERIFIED SOLUTION i

Resolve error message when opening the Operations Log in Portrait Dialogue Visual Dialogue

Product Feature: Visual Dialog
 

Issue

When trying to open the Operations Log in Portrait Dialogue's Visual Dialogue application, we sometimes see an error message containing the text:
Invalid floating point operation.

The same message can also be seen for some operations when we try to select them in the Operation History Browser with the 'All Runs' pane open.
This only affects version 6.1 of Portrait Dialogue.

Cause

The error message is harmless but is seen because the calculated 'process time' for one or more of the operations has been set to zero in the database. This is because many of the rows in the table that were created under earlier versions will have a value of zero. The framework attempts to calculate the operation speed, and as a result, a "divide by zero" error manifests itself as the above error message.

Resolution

UPDATED: April 24, 2017
Releases of Portrait Dialogue after v6.1 will attempt to fix the issue internally, but until then it is possible to prevent the error from being reported simply by changing the zeroes in the affected database table column into an extremely small value. The SQL script to do this is as follows. You should run this script during a period of low database activitity:
UPDATE DLG_OPERATION_LOG SET DOL_PROCESS_TIME = cast(1 as float)/24/3600/10 WHERE DOL_PROCESS_TIME = 0

If you are unsure about how to apply this script, please contact Pitney Bowes Software Support before making any database changes.