Client Management Suite

Hi all,

last august update my NS7 to SP4 and apparently all function correctly.

Yesterday a technician reports me a problem on connect via PcAnywhere on a machine reinstalled in september.

On Altiris Log Viewer there is this error

"Log File Name: C:\Program Files\Altiris\Notification Server\Logs\a.log
Priority: 2
Date: 05/10/2010 16.25.43
Tick Count: 611073390
Host Name: MIGE114
Process: AeXSvc (12128)
Thread ID: 52
Module: AeXSVC.exe
Source: Altiris.NS.ResourceManagement.Database.DataLoaderSqlClientInserter.CommitBatch
Description: Failed to insert row into table ( INSERT INTO dbo.[Evt_NS_Event_History] ([_ResourceGuid],[ResourceName],[StartTime],[ResourceGuid],[ErrorNumber],[ItemGuid],[EventData],[ItemName],[TickCount],[_eventTime]) VALUES (N'MIGE114 (582a3697-88fa-4943-8626-47854c8aa1df)',N'MISAEI014-11',N'2010-10-05 16:25:37',N'MISAEI014-11 (60e98fdf-fb21-437c-8507-8eec3635458d)',N'-2147217408',N'Basic Inventory Capture Item (1592b913-72f3-4c36-91d2-d4eda21d2f96)',N'',N'Elemento di acquisizione inventario di base',N'16',N'2010-10-05 16.25.44.290') )

( Exception Details: System.Data.SqlClient.SqlException: Arithmetic overflow error converting expression to data type datetime.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.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.ResourceManagement.Database.DataLoaderSqlClientInserter.CommitBatch() )
( Exception logged from:
   at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)
   at Altiris.NS.ResourceManagement.Database.DataLoaderSqlClientInserter.CommitBatch()
   at Altiris.NS.ResourceManagement.Database.SqlClientInserter.CommitAll()
   at Altiris.NS.ResourceManagement.Database.SqlClientInserter.CommitBatch()
   at Altiris.NS.ResourceManagement.DataClassRowCollection.InternalTableInserterImpl(IDataLoaderConnection connection, Hashtable resourceDLInfoHT, TargetTable targetTable, String strInserterTable, DataClass dataClass, DataClassRows dataClassRows)
   at Altiris.NS.ResourceManagement.DataClassRowCollection.InternalTableInserter(IDataLoaderConnection connection, Hashtable resourceDLInfoHT, TargetTable targetTable, String strInserterTable, DataClass dataClass, DataClassRows dataClassRows)
   at Altiris.NS.ResourceManagement.DataClassRowCollection.UpdateDataClass_Impl(DataClass dataClass, DataClassRows rows, Hashtable resourceDLInfoHT, Boolean HistoryEnabled, Hashtable resourceGuidToResourceTypeGuid, IDataLoaderConnection connection)
   at Altiris.NS.ResourceManagement.DataClassRowCollection.<>c__DisplayClassa.<UpdateDataClass>b__6(IDatabaseContext context)
   at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetryHelper(Int32 retries, Boolean inTransaction, Getter`1 getContext, Action`1 action, Action`1 retry)
   at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Boolean startNewTransaction, IsolationLevel isolationLevel, Boolean independentContext, Action`1 action, Action`1 retry)
   at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Boolean startNewTransaction, Action`1 action, Action`1 retry)
   at Altiris.NS.ResourceManagement.DataClassRowCollection.UpdateDataClass(DataClass dataClass, DataClassRows rows, Hashtable resourceDLInfoHT, Boolean HistoryEnabled, Hashtable resourceGuidToResourceTypeGuid, IDataLoaderConnection connection)
   at Altiris.NS.ResourceManagement.DataClassRowCollection.LoadEvents(Guid classGuid, DataClassRows dataClassRows, Boolean rethrowException)
   at Altiris.NS.Logging.EventLog.LogEventDataInternal(Guid dataClassGuid, DataClassRows rows, String eventTableName)
   at Altiris.NS.Logging.EventLog.FlushReportedEventThreadProc()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.runTryCode(Object userData)
   at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()
 )
( Extra Details:  Type=System.Data.SqlClient.SqlException Src=.Net SqlClient Data Provider )"

In Altiris Agent on client there isn't a GUID and in a log pc cannot register on server whit "HTTP 401 error: Unauthorized"

Another error in the server log, indicates a problem because the machine is in "Host Resource Blacklist".

I view in the filter "Blacklisted Hosts Computer" but it's empty.

how i can resolve this problem?

Thanks

Danilo

Have you looked at IIS logs to see which virtual folders in IIS need anonymous access enabled?

Frankly, I'd have to look for that specific error.  I'm not sure why only 1 client is having the problem - seems it'd be a bigger prob than that.  hmmm...  did you look up the error in the KB?

Yes i find if there is this error in KB but i don't find a solution.

There is a big numbers of errors in my Altiris Event Viewer but i cannot understand why.

can you help me?

A 401 error is a failure to authenticate to IIS, not to the console.  It's possible you can look at the 401 errors and fix them by simply enabling anonymous access in the console for that virtual directory.  Here's how that works.

1) Look in IIS logs for a line with a 401 instead of 200 at the end.
2) Near the front of the line, you'll see something like \altiris\taskmanagement\xxxxxxxxxx
3) That tells you the virtual folders you want in IIS, in this case, under Default Web Site \ Altiris\ TaskManagement.
4) in IIS, highlight the selected virtual folder (TaskManagement), right-click, choose Properties.
5) Under Directory Security, click 'Edit' next to Authentication and access control.
6) In the Authentication Methods screen, enable the top check box option for Anonymous access.
7) OK and OK on all those screens and you're done.
8) Repeate as necessary for your errors.
9) Do the same thing for the Altiris folder (parent folder) since it affects the others.

Try that, let us know if that gets past or around some of your errors.

The problem is only the language of SMP7 Server.

I reset this configuration and error is hidden.

Bye Danilo