Error "Object cannot be cast from dbnull to other types" occurs when using Asset Management reports

book

Article ID: 156377

calendar_today

Updated On:

Products

Asset Management Solution

Issue/Introduction

When accessing certain Asset Management reports, the error "Object cannot be cast from dbnull to other types" occurs.

Server Error in Altiris/AssetContractCommon Application

Object cannot be cast from dbnull to other types

Cause

Product defect.

Resolution

This will be resolved in a future version of Asset Management.

The workaround is to import older versions of the reports. Attached to this article are those from Asset Management 7.0. To import, go to Reports then right click on a folder and choose Import. Note: These will overwrite the prior versions.


Applies To

Asset Management 7.1 SP2.

The following two Asset Management reports are known to cause this:

Count of Serial Numbers that appear as Assets
Count of Serial Numbers that do not appear as Assets'

Attachments

Contracts and their Assets (from SMP 7.0).xml get_app
Contract Serial Numbers without Asset Info (from SMP 7.0).xml get_app