Invalid object name "Inv_HPCMS_HCI_Video" and invalid dataclass

Article:TECH26141  |  Created: 2007-01-26  |  Updated: 2007-06-15  |  Article URL http://www.symantec.com/docs/TECH26141
Article Type
Technical Solution


Issue



When client computers attempt to post inventory NSEs that were generated by HP Client Manager, the following error messages appear in the log files:

<event date='Jan 19 11:07:53' severity='1' hostName='NS' source='Altiris.NS.StandardItems.Messaging.InventoryCaptureItem.OnMessage_Impl' module='AltirisNativeHelper.dll' process='aexsvc.exe' pid='6696' thread='5904' tickCount='-1807776781' >
  <![CDATA[Failed to process NSE :  ( Unhandled exception.  Type=Altiris.NS.Exceptions.AeXException Msg=Failed to load inventory. [Incorrect syntax near the keyword 'with'.] Src=Altiris.NS
StackTrace=
   at Altiris.NS.ResourceManagement.DataClassImporter.LoadInventory_Impl(XmlReader reader, Boolean bProcessData, Boolean bForceSchemaValidation, Guid resourceGuidOverride)
   at Altiris.NS.ResourceManagement.DataClassImporter.LoadInventory(XmlReader reader, Boolean bProcessData, Boolean bForceSchemaValidation, Guid resourceGuidOverride)
   at Altiris.NS.ResourceManagement.DataClassImporter.LoadInventory(Guid resourceGuid, XmlReader reader)
   at Altiris.NS.StandardItems.Messaging.InventoryCaptureItem.OnMessage_Impl(String message, Boolean useFilename)

Inner exception.  Type=System.Data.SqlClient.SqlException Msg=Incorrect syntax near the keyword 'with'.  Src=.Net SqlClient Data Provider StackTrace=   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader()
   at Altiris.NS.ResourceManagement.DataClass.GetHashString(Guid ResourceGuid)
   at Altiris.NS.ResourceManagement.DataClassRowCollection.CommitData_Impl(IDataLoaderConnection connection)
   at Altiris.NS.ResourceManagement.DataClassRowCollection.CommitData(IDataLoaderConnection connection)
   at Altiris.NS.ResourceManagement.DataClassImporter.ProcessData(DataClass dataClass, XmlReader reader, Guid resourceGuidOverride, ProcessingDirective processingDirective)
   at Altiris.NS.ResourceManagement.DataClassImporter.LoadInventory_Impl(XmlReader reader, Boolean bProcessData, Boolean bForceSchemaValidation, Guid resourceGuidOverride) )]]>
</event>


Environment



Notification Server 6.0 SP3 R2
HP Client Manager 6.1.1119 Hotfix 1 (6.1.1011)

Cause



The Inv_HPCMS_HCI_Video table and HPCMS HCI Video dataclass are missing from the database.

Solution



To resolve the issue, execute the attached SQL file and ItemCreator.exe. This will create the missing table and the missing dataclass.

  1. Open Query Analyzer and execute the attached Inv_HPCMS_HCI_Video.sql file.
  2. Execute ItemCreator.exe

For HP Client Manager 6.2.1011, run either the HCI Video (2000).sql or HCI Video (2005).sql depending on which version of SQ you are running, and then import the HPCMS HCI Video.xml file into the Resource Settings > Data Classes > HP Client Manager Inventory resource folder.

Attachments

Inv_HPCMS_HCI_Video.sql (1 kBytes)
ItemCreator.exe (28 kBytes)


HCI_Video (2000).sql (3 kBytes)
HCI_Video (2005).sql (2 kBytes)
HPCMS HCI Video.xml (6 kBytes)

Legacy ID



32284


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


Terms of use for this information are found in Legal Notices