Application Metering fails with a message, "There was a problem saving the software product."
Article ID: 165231
Updated On:
Products
Issue/Introduction
When attempting to enable Application Metering on a Software Resource, by enabling it on a specific executable file, a popup appears stating, "There was a problem saving the software product. Check the Altiris logs for further details."
In the logs, the following error is found:
<event date="02/23/2017 16:28:05.2953366 -03:00" severity="1" hostName="SRV-ALTIRIS" source="ResourceItem" module="Altiris.NS.dll" process="w3wp" pid="3772" thread="951" tickCount="81407889"><![CDATA[Failed to save resource data: guid=ab96bf0a-c9e3-4d3a-b624-21ffa0aa24c8, table=Inv_Software_Execution
Database context invalidated by inner exception
[Altiris.Database.InvalidDatabaseContextException @ Altiris.Database]
at Altiris.Database.DatabaseContext`1.ProcessException(Exception exception)
at Altiris.NS.ResourceManagement.Database.DataLoaderSqlClientInserter.ExecuteBatch(SqlCommand command, IDatabaseContext context, String batch, Int32 done)
at Altiris.NS.ResourceManagement.Database.DataLoaderSqlClientInserter.CommitBatchImpl(IDatabaseContext ctx, Boolean inOuterTransaction)
at Altiris.NS.ResourceManagement.Database.DataLoaderSqlClientInserter.CommitBatch()
at Altiris.NS.ResourceManagement.DataClassRowCollection.InternalTableInserterAttempt(NullableDictionary`2 mapResourceInsertInfo, TargetTable targetTable, DataClass dataClass, DataClassRows dataClassRows, IDataLoaderInserter2 inserter, Boolean dataClassIsSplit, Boolean showMessages, Int32 nAttempt)
at Altiris.NS.ResourceManagement.DataClassRowCollection.InternalTableInserterImpl(IDataLoaderConnection connection, NullableDictionary`2 mapResourceInsertInfo, TargetTable targetTable, String strInserterTable, DataClass dataClass, DataClassRows dataClassRows)
at Altiris.NS.ResourceManagement.DataClassRowCollection.InternalTableInserter(IDataLoaderConnection connection, NullableDictionary`2 mapResourceInsertInfo, TargetTable targetTable, String strInserterTable, DataClass dataClass, DataClassRows dataClassRows)
at Altiris.NS.ResourceManagement.DataClassRowCollection.UpdateInventoryDataClass(DataClass dataClass, DataClassRows rows, NullableDictionary`2 mapResourceInsertInfo, Boolean historyEnabled, Dictionary`2 resourceGuidToResourceTypeGuid, IDataLoaderConnection connection, String spResourceUpdateSummary, Guid& updateInstanceGuid, List`1& fixedResources)
at Altiris.NS.ResourceManagement.DataClassRowCollection.UpdateDataClassImpl(DataClass dataClass, DataClassRows rows, NullableDictionary`2 mapResourceInsertInfo, Boolean historyEnabled, Dictionary`2 resourceGuidToResourceTypeGuid, IDataLoaderConnection connection)
at Altiris.NS.ResourceManagement.DataClassRowCollection.<>c__DisplayClass1c.<CommitDataImpl>b__18(IDatabaseContext ctx)
at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception, Boolean inTransaction)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetryHelper(Int32 retries, Boolean inTransaction, Getter`1 getContext, Action`1 action, Action`1 retry, Boolean transacted)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Boolean startNewTransaction, Nullable`1 isolationLevel, Boolean independentContext, Action`1 action, Action`1 retry)
at Altiris.NS.ResourceManagement.DataClassRowCollection.CommitDataImpl(IDataLoaderConnection connection)
at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception, Boolean inTransaction)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetryHelper(Int32 retries, Boolean inTransaction, Getter`1 getContext, Action`1 action, Action`1 retry, Boolean transacted)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Boolean startNewTransaction, Nullable`1 isolationLevel, Boolean independentContext, Action`1 action, Action`1 retry)
at Altiris.NS.ResourceManagement.DataClassRowCollection.CommitData(IDataLoaderConnection connection)
at Altiris.Resource.ResourceDataTable.SaveMultiRowDataClassRows(DataClass dataClass, DataTable dtChanges)
at Altiris.Resource.ResourceDataTable.Save()
at Altiris.Resource.ResourceData.<>c__DisplayClass12.<SaveImpl>b__10(IDatabaseContext ac)
at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception, Boolean inTransaction)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetryHelper(Int32 retries, Boolean inTransaction, Getter`1 getContext, Action`1 action, Action`1 retry, Boolean transacted)
at Altiris.Database.DatabaseContext`1.PerformTransactedDeadlockRetry(Int32 retries, Getter`1 getContext, Action`1 action, Action`1 retry)
at Altiris.Resource.ResourceData.SaveImpl(Boolean dataClassDataChanged, Boolean associationDataChanged, ResourceAssociationDataCollection resourceAssociationsToLoad)
XML parsing: line 1, character 554846, illegal name character
[System.Data.SqlClient.SqlException @ .Net SqlClient Data Provider]
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Altiris.NS.ResourceManagement.Database.DataLoaderSqlClientInserter.ExecuteBatch(SqlCommand command, IDatabaseContext context, String batch, Int32 done)
SQL Exception details: code=9421, line=11, procedure=sp_Inv_Adding_Metering
Exception logged from:
at Altiris.NS.ContextManagement.AdminDatabaseContext.ReportException(String, String, Exception)
at Altiris.Resource.ResourceData.SaveImpl(Boolean, Boolean, Altiris.NS.ResourceManagement.ResourceAssociationDataCollection)
at Altiris.Resource.ResourceData.Save()
at Altiris.Resource.ResourceItem.OnSave(Boolean)
at Altiris.Resource.ResourceManagementItem.OnSave(Boolean)
at Altiris.NS.ItemManagement.Item.Save()
at Altiris.Inventory.Utilities.InvDataClassAPI.SetSoftwareExecutionDataClass(Altiris.Common.GuidCollection, Altiris.Common.GuidCollection, Int32)
at Altiris.NS.Services.CoreServices.SoftwareService.UpdateSoftwareProduct(Altiris.NS.Services.CoreServices.Contracts.SoftwareComponent, Altiris.NS.Services.CoreServices.Contracts.FaultDetail&)
at ]]></event>
<event date="02/23/2017 16:28:05.3109404 -03:00" severity="1" hostName="SRV-ALTIRIS" source="Resource.SaveResourceToDatabase" module="Altiris.NS.dll" process="w3wp" pid="3772" thread="951" tickCount="81407904"><![CDATA[Item save to DB failed: ab96bf0a-c9e3-4d3a-b624-21ffa0aa24c8, (fromClone=False, user=DOMAIN\altiris)
Database context invalidated by inner exception
[Altiris.Database.InvalidDatabaseContextException @ Altiris.Database]
at Altiris.Database.DatabaseContext`1.ProcessException(Exception exception)
at Altiris.NS.ResourceManagement.Database.DataLoaderSqlClientInserter.ExecuteBatch(SqlCommand command, IDatabaseContext context, String batch, Int32 done)
at Altiris.NS.ResourceManagement.Database.DataLoaderSqlClientInserter.CommitBatchImpl(IDatabaseContext ctx, Boolean inOuterTransaction)
at Altiris.NS.ResourceManagement.Database.DataLoaderSqlClientInserter.CommitBatch()
at Altiris.NS.ResourceManagement.DataClassRowCollection.InternalTableInserterAttempt(NullableDictionary`2 mapResourceInsertInfo, TargetTable targetTable, DataClass dataClass, DataClassRows dataClassRows, IDataLoaderInserter2 inserter, Boolean dataClassIsSplit, Boolean showMessages, Int32 nAttempt)
at Altiris.NS.ResourceManagement.DataClassRowCollection.InternalTableInserterImpl(IDataLoaderConnection connection, NullableDictionary`2 mapResourceInsertInfo, TargetTable targetTable, String strInserterTable, DataClass dataClass, DataClassRows dataClassRows)
at Altiris.NS.ResourceManagement.DataClassRowCollection.InternalTableInserter(IDataLoaderConnection connection, NullableDictionary`2 mapResourceInsertInfo, TargetTable targetTable, String strInserterTable, DataClass dataClass, DataClassRows dataClassRows)
at Altiris.NS.ResourceManagement.DataClassRowCollection.UpdateInventoryDataClass(DataClass dataClass, DataClassRows rows, NullableDictionary`2 mapResourceInsertInfo, Boolean historyEnabled, Dictionary`2 resourceGuidToResourceTypeGuid, IDataLoaderConnection connection, String spResourceUpdateSummary, Guid& updateInstanceGuid, List`1& fixedResources)
at Altiris.NS.ResourceManagement.DataClassRowCollection.UpdateDataClassImpl(DataClass dataClass, DataClassRows rows, NullableDictionary`2 mapResourceInsertInfo, Boolean historyEnabled, Dictionary`2 resourceGuidToResourceTypeGuid, IDataLoaderConnection connection)
at Altiris.NS.ResourceManagement.DataClassRowCollection.<>c__DisplayClass1c.<CommitDataImpl>b__18(IDatabaseContext ctx)
at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception, Boolean inTransaction)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetryHelper(Int32 retries, Boolean inTransaction, Getter`1 getContext, Action`1 action, Action`1 retry, Boolean transacted)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Boolean startNewTransaction, Nullable`1 isolationLevel, Boolean independentContext, Action`1 action, Action`1 retry)
at Altiris.NS.ResourceManagement.DataClassRowCollection.CommitDataImpl(IDataLoaderConnection connection)
at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception, Boolean inTransaction)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetryHelper(Int32 retries, Boolean inTransaction, Getter`1 getContext, Action`1 action, Action`1 retry, Boolean transacted)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Boolean startNewTransaction, Nullable`1 isolationLevel, Boolean independentContext, Action`1 action, Action`1 retry)
at Altiris.NS.ResourceManagement.DataClassRowCollection.CommitData(IDataLoaderConnection connection)
at Altiris.Resource.ResourceDataTable.SaveMultiRowDataClassRows(DataClass dataClass, DataTable dtChanges)
at Altiris.Resource.ResourceDataTable.Save()
at Altiris.Resource.ResourceData.<>c__DisplayClass12.<SaveImpl>b__10(IDatabaseContext ac)
at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception, Boolean inTransaction)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetryHelper(Int32 retries, Boolean inTransaction, Getter`1 getContext, Action`1 action, Action`1 retry, Boolean transacted)
at Altiris.Database.DatabaseContext`1.PerformTransactedDeadlockRetry(Int32 retries, Getter`1 getContext, Action`1 action, Action`1 retry)
at Altiris.Resource.ResourceData.SaveImpl(Boolean dataClassDataChanged, Boolean associationDataChanged, ResourceAssociationDataCollection resourceAssociationsToLoad)
at Altiris.Resource.ResourceData.Save()
at Altiris.Resource.ResourceItem.OnSave(Boolean bExistingItem)
at Altiris.Resource.ResourceManagementItem.OnSave(Boolean bExistingItem)
at Altiris.NS.ItemManagement.Item.Save()
XML parsing: line 1, character 554846, illegal name character
[System.Data.SqlClient.SqlException @ .Net SqlClient Data Provider]
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Altiris.NS.ResourceManagement.Database.DataLoaderSqlClientInserter.ExecuteBatch(SqlCommand command, IDatabaseContext context, String batch, Int32 done)
SQL Exception details: code=9421, line=11, procedure=sp_Inv_Adding_Metering
Exception logged from:
at Altiris.NS.ItemManagement.Item.Save()
at Altiris.Inventory.Utilities.InvDataClassAPI.SetSoftwareExecutionDataClass(Altiris.Common.GuidCollection, Altiris.Common.GuidCollection, Int32)
at Altiris.NS.Services.CoreServices.SoftwareService.UpdateSoftwareProduct(Altiris.NS.Services.CoreServices.Contracts.SoftwareComponent, Altiris.NS.Services.CoreServices.Contracts.FaultDetail&)
at ]]></event>
<event date="02/23/2017 16:28:05.3109404 -03:00" severity="1" hostName="SRV-ALTIRIS" source="Altiris.NS.Services.CoreServices.Logging.EventLogger.ReportException" module="Altiris.NS.Services.CoreServices.dll" process="w3wp" pid="3772" thread="951" tickCount="81407904"><![CDATA[Unable to update product 'Software Product Name' (27784b8b-45f6-4613-a90d-62c2d251f7e1):
Item save failed: 'filename.exe' (ab96bf0a-c9e3-4d3a-b624-21ffa0aa24c8)
[Altiris.NS.Exceptions.AeXException @ Altiris.NS]
at Altiris.NS.ItemManagement.Item.Save()
at Altiris.Inventory.Utilities.InvDataClassAPI.SetSoftwareExecutionDataClass(GuidCollection gCollObsoleteFileResource, GuidCollection gCollAddFileResource, Int32 IsMetered)
at Altiris.NS.Services.CoreServices.SoftwareService.UpdateSoftwareProduct(SoftwareComponent product, FaultDetail& fault)
Database context invalidated by inner exception
[Altiris.Database.InvalidDatabaseContextException @ Altiris.Database]
at Altiris.Database.DatabaseContext`1.ProcessException(Exception exception)
at Altiris.NS.ResourceManagement.Database.DataLoaderSqlClientInserter.ExecuteBatch(SqlCommand command, IDatabaseContext context, String batch, Int32 done)
at Altiris.NS.ResourceManagement.Database.DataLoaderSqlClientInserter.CommitBatchImpl(IDatabaseContext ctx, Boolean inOuterTransaction)
at Altiris.NS.ResourceManagement.Database.DataLoaderSqlClientInserter.CommitBatch()
at Altiris.NS.ResourceManagement.DataClassRowCollection.InternalTableInserterAttempt(NullableDictionary`2 mapResourceInsertInfo, TargetTable targetTable, DataClass dataClass, DataClassRows dataClassRows, IDataLoaderInserter2 inserter, Boolean dataClassIsSplit, Boolean showMessages, Int32 nAttempt)
at Altiris.NS.ResourceManagement.DataClassRowCollection.InternalTableInserterImpl(IDataLoaderConnection connection, NullableDictionary`2 mapResourceInsertInfo, TargetTable targetTable, String strInserterTable, DataClass dataClass, DataClassRows dataClassRows)
at Altiris.NS.ResourceManagement.DataClassRowCollection.InternalTableInserter(IDataLoaderConnection connection, NullableDictionary`2 mapResourceInsertInfo, TargetTable targetTable, String strInserterTable, DataClass dataClass, DataClassRows dataClassRows)
at Altiris.NS.ResourceManagement.DataClassRowCollection.UpdateInventoryDataClass(DataClass dataClass, DataClassRows rows, NullableDictionary`2 mapResourceInsertInfo, Boolean historyEnabled, Dictionary`2 resourceGuidToResourceTypeGuid, IDataLoaderConnection connection, String spResourceUpdateSummary, Guid& updateInstanceGuid, List`1& fixedResources)
at Altiris.NS.ResourceManagement.DataClassRowCollection.UpdateDataClassImpl(DataClass dataClass, DataClassRows rows, NullableDictionary`2 mapResourceInsertInfo, Boolean historyEnabled, Dictionary`2 resourceGuidToResourceTypeGuid, IDataLoaderConnection connection)
at Altiris.NS.ResourceManagement.DataClassRowCollection.<>c__DisplayClass1c.<CommitDataImpl>b__18(IDatabaseContext ctx)
at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception, Boolean inTransaction)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetryHelper(Int32 retries, Boolean inTransaction, Getter`1 getContext, Action`1 action, Action`1 retry, Boolean transacted)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Boolean startNewTransaction, Nullable`1 isolationLevel, Boolean independentContext, Action`1 action, Action`1 retry)
at Altiris.NS.ResourceManagement.DataClassRowCollection.CommitDataImpl(IDataLoaderConnection connection)
at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception, Boolean inTransaction)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetryHelper(Int32 retries, Boolean inTransaction, Getter`1 getContext, Action`1 action, Action`1 retry, Boolean transacted)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Boolean startNewTransaction, Nullable`1 isolationLevel, Boolean independentContext, Action`1 action, Action`1 retry)
at Altiris.NS.ResourceManagement.DataClassRowCollection.CommitData(IDataLoaderConnection connection)
at Altiris.Resource.ResourceDataTable.SaveMultiRowDataClassRows(DataClass dataClass, DataTable dtChanges)
at Altiris.Resource.ResourceDataTable.Save()
at Altiris.Resource.ResourceData.<>c__DisplayClass12.<SaveImpl>b__10(IDatabaseContext ac)
at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception, Boolean inTransaction)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetryHelper(Int32 retries, Boolean inTransaction, Getter`1 getContext, Action`1 action, Action`1 retry, Boolean transacted)
at Altiris.Database.DatabaseContext`1.PerformTransactedDeadlockRetry(Int32 retries, Getter`1 getContext, Action`1 action, Action`1 retry)
at Altiris.Resource.ResourceData.SaveImpl(Boolean dataClassDataChanged, Boolean associationDataChanged, ResourceAssociationDataCollection resourceAssociationsToLoad)
at Altiris.Resource.ResourceData.Save()
at Altiris.Resource.ResourceItem.OnSave(Boolean bExistingItem)
at Altiris.Resource.ResourceManagementItem.OnSave(Boolean bExistingItem)
at Altiris.NS.ItemManagement.Item.Save()
XML parsing: line 1, character 554846, illegal name character
[System.Data.SqlClient.SqlException @ .Net SqlClient Data Provider]
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Altiris.NS.ResourceManagement.Database.DataLoaderSqlClientInserter.ExecuteBatch(SqlCommand command, IDatabaseContext context, String batch, Int32 done)
SQL Exception details: code=9421, line=11, procedure=sp_Inv_Adding_Metering
Exception logged from:
at Altiris.NS.Services.CoreServices.Logging.EventLogger.ReportException(String, Exception)
at Altiris.NS.Services.CoreServices.SoftwareService.UpdateSoftwareProduct(Altiris.NS.Services.CoreServices.Contracts.SoftwareComponent, Altiris.NS.Services.CoreServices.Contracts.FaultDetail&)
at ]]></event>
Cause
Inventory Solution reports file inventory information to the Management Platform/ITMS server. Inventory details from a file was saved improperly, causing corruption in the database entry used by Application Metering. This prevents Application Metering from updating.
Resolution
{KNOWN_ISSUE.EN_US}
A workaround can be done with Symantec's assistance, to update the database entry used by Application Metering, and remove the corrupt entry. This fix is not recommended to be performed by the end user. Please contact Symantec Support for assistance.
Feedback
