ITMS 7.1.2 MP1 - VMM Inventory is failing.

Article:TECH200188

Created: 2012-11-28

Updated: 2012-11-28

Article URL http://www.symantec.com/docs/TECH200188

Article Type
Technical Solution

Product(s)

Show all

Languages

Show all

Problem

VMM Inverntory task fails without clear reason. Task status is 'failed' within a second after start time.

Error

n/a

Environment

7.1.2, 7.1.2 MP1

Cause

ESX server resource may have a parent resource. Currently, any parent is treated as vCenter where ESX server is intergrated and task is sent to the parent resource.

In case if it is not a vCenter but some other resource type without IP Address (e.g Dell chassis) the task will fail.

Solution

Attached SQL script to update stored procedures. New stored procedures return only vCenter parent. In case if there is no vCenter resource is considered as an independent ESX Server and task sent directly.

1. Download attached file (Alter_SQL_SP2.sql)

2. Execute contents of the files in SQL Management Studio against Symantec_CMDB database (default name)

Attachments

Alter_SQL_SP2.sql (1 kBytes)

Supplemental Materials

Source	ETrack
Value	2989117