Symantec Mobile Management 7.1 SP1 fails to install when the database name is not Symantec_CMDB

Article:TECH184444  |  Created: 2012-03-21  |  Updated: 2013-10-24  |  Article URL
Article Type
Technical Solution


When Symantec Mobile Management 7.1 SP1 is installed to a server that does not use the default database name, [Symantec_CMDB], the installation fails to be properly configured.


In the logs, the following entry is seen:

System.Data.SqlClient.SqlException caught in ImportSqlObjectNodes. Reason: System.Data.SqlClient.SqlException: Invalid object name 'Symantec_CMDB.dbo.DataClassAttribute'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Altiris.NS.ItemManagement.ItemHelper.ImportSqlObjectNodes(XmlNodeList nodes). SQL:
UPDATE [Symantec_CMDB].[dbo].[DataClassAttribute]
SET [ShortName] = 'IsRoam'
AttrName = 'IsRoaming' AND AttrId = 15 AND ShortName = 'Roam' AND
InvClassId = (SELECT id FROM [Symantec_CMDB].[dbo].[DataClass] WHERE Guid = 'f6962dfd-6764-4acb-8128-078c21882575')


Symantec Mobile Management 7.1 SP1


The database name is hardcoded in two lines in the file found at "C:\Program Files\Altiris\MobileManagement\Config\MobileManagement_PostInstallSQL.config" on lines 339-349, as shown:

  <sqlObject name="fix_Mobile_Phone_iOS_Double_Roam">
    <sqlStatement exists="false">
      UPDATE [Symantec_CMDB].[dbo].[DataClassAttribute]
      SET [ShortName] = 'IsRoam'
      AttrName = 'IsRoaming' AND AttrId = 15 AND ShortName = 'Roam' AND
      InvClassId = (SELECT id FROM [Symantec_CMDB].[dbo].[DataClass] WHERE Guid = 'f6962dfd-6764-4acb-8128-078c21882575')


Edit the MobileManagement_PostInstallSQL.config file, and on the two effected lines, remove the references to [Symantec_CMDB].[dbo] as follows:

 UPDATE [DataClassAttribute]
 InvClassId = (SELECT id FROM [DataClass] WHERE Guid = 'f6962dfd-6764-4acb-8128-078c21882575')

Then, in the Symantec Installation Manager, reconfigure the solution.  Or, run the AexConfig.exe program to reconfigure it:

"C:\Program Files\Altiris\Notification Server\Bin\AexConfig.exe" /configure "C:\Program Files\Altiris\MobileManagement\Config\MobileManagement.config"

(Substitute the Drive letters and paths as needed, if the installation did not use the default drives or paths.)

Supplemental Materials


Article URL

Terms of use for this information are found in Legal Notices