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 http://www.symantec.com/docs/TECH184444
Article Type
Technical Solution


Issue



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.


Error



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'
WHERE
AttrName = 'IsRoaming' AND AttrId = 15 AND ShortName = 'Roam' AND
InvClassId = (SELECT id FROM [Symantec_CMDB].[dbo].[DataClass] WHERE Guid = 'f6962dfd-6764-4acb-8128-078c21882575')
 


Environment



Symantec Mobile Management 7.1 SP1


Cause



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">
      <![CDATA[
      UPDATE [Symantec_CMDB].[dbo].[DataClassAttribute]
      SET [ShortName] = 'IsRoam'
      WHERE
      AttrName = 'IsRoaming' AND AttrId = 15 AND ShortName = 'Roam' AND
      InvClassId = (SELECT id FROM [Symantec_CMDB].[dbo].[DataClass] WHERE Guid = 'f6962dfd-6764-4acb-8128-078c21882575')
       ]]>
    </sqlStatement>
  </sqlObject>
 


Solution



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

SourceETrack
Value2727658


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


Terms of use for this information are found in Legal Notices