An unexpected error occurred. Error Message: Internal Error: DBO setter threw exception

Technical Articles ID: KB84888
Last Modified: 5/11/2022

Environment

McAfee ePolicy Orchestrator (ePO) 5.10.x
McAfee Performance Optimizer 2.2.0.111

Problem

In the Performance Optimizer dashboard, when you select Server tasks - Length of runtime, the following error displays:

An unexpected error occurred. Error Message: Internal Error: DBO setter threw exception

The Orion.log file contains errors similar to the following:

ERROR [http-nio-8443-exec-364] table.LoadTableRecords - error creating table response
java.lang.RuntimeException: Internal Error: DBO setter setDuration threw exception
At com.mcafee.orion.core.db.base.DatabaseMapper$Column.callSetter(DatabaseMapper.java:2654)

Cause

Performance Optimizer assesses the server task durations for tasks that are still in progress. In this scenario, Performance Optimizer records a null for the task durations.

Solution

This issue is resolved in Performance Optimizer 2.2.0.112.

Install Performance Optimizer 2.2.0.112 from the ePO Software Manager or the Product Downloads site.

Our product software, upgrades, maintenance releases, and documentation are available on the Product Downloads site.

NOTE: You need a valid Grant Number for access. See KB56057 - How to download Enterprise product updates and documentation for more information about the Product Downloads site, and alternate locations for some products.

Customers who want to remain on 2.2.0.111 must apply the attached stored procedure to the ePO database. The changes in this stored procedure resolve the issue in ePO Performance Optimizer 2.2.0.111, and correct any previous null values for the task durations.

IMPORTANT: This solution is valid only for ePO Performance Optimizer 2.2.0.111. In a future release, this updated stored procedure is included with the product.

Instructions:

Save the attached SQL file to the database server.
Open SQL Server Management Studio and connect to the ePO database server.
Open the SP_ePA_PopulateUC32Score.sql file.
Edit the top of the SP_ePA_PopulateUC32Score.sql file and specify the name of the ePO database inside the square brackets.
Execute the query and run the SQL script.

Workaround

Run the server task Performance Optimizer: Analyze ePO configuration, database configuration, and database backups when all other server tasks have completed and none are in progress.

Attachment

SP_ePA_PopulateUC32Score.zip
1K • < 1 minute @ broadband

Affected Products

ePolicy Orchestrator 5.10.x
Known Issue/Product Defect
Performance Optimizer

Languages:

This article is available in the following languages:

English United States
Spanish Spain
French
Italian
Japanese
Portuguese Brasileiro
Chinese Simplified

Knowledge Center

An unexpected error occurred. Error Message: Internal Error: DBO setter threw exception

Environment

Problem

Cause

Solution

Workaround

Attachment

Affected Products

Languages:

Title

Title

Knowledge Center

An unexpected error occurred. Error Message: Internal Error: DBO setter threw exception

Environment

Problem

Cause

Solution

Workaround

Attachment

Affected Products

Languages:

Choose your region

Title

Title