Getting error "Object cannot be cast from DBNull to other types" in "Intelligent Defragmentation"
説明
Getting error "Object cannot be cast from DBNull to other types" when going to "Manage Fragmentation"|"Server Name\Intelligent Defragmentation"
対策
RESOLUTION
The issue occurs only in User Interface (UI) when option “Use rebuild operation if defrag operation is ineffective” is checked. To work without the error please make a new profile with the same parameters and uncheck this option:
Run Intel Defrag wizard
Go to <Select Database…> step.
Check instances for defragmentation, set Custom profile and press Edit button
In <Defragmentation Profiles> window press <New> button and set name for a new profile
