Hi,
I saw that in the console of SMP is a section where it appears the list of open tickets in SD divided by computer.
I noticed that only the first ticket associated with an asset are present, the later are not seen.
In the SMP console log I see an error when creating the relationship between Asset and Ticket.
This is the error:
Log File Name: C:\ProgramData\Symantec\SMP\Logs\a.log
Priority:
Date: 4/26/2011 3:05:34 PM
Tick Count: 11346046
Host Name: xxxxxxxx
Process: AeXSvc (1212)
Thread ID: 65
Module: AeXSVC.exe
Source: Altiris.NS.ResourceManagement.database.DataLoaderSqlClientInserter.SetColumn
Description: SetColumn: Couldn't set [IncidentCreateDate] to (26/04/2011 15:05:30).
AND
Log File Name: C:\ProgramData\Symantec\SMP\Logs\a.log
Priority: 2
Date: 4/26/2011 3:05:34 PM
Tick Count: 11346046
Host Name: xxxxxxxx
Process: AeXSvc (1212)
Thread ID: 65
Module: AeXSVC.exe
Source: DataClassRowCollection.InternalTableInserter
Description: Failed on first attempt to commit fast insert for data class : ServiceDesk Incident Details (ServiceDesk Incident Details (cd4b67fc-2b2c-42ca-8a3a-c7a24f530dd5)) . Trying again.
AND
Log File Name: C:\ProgramData\Symantec\SMP\Logs\a.log
Priority: 2
Date: 4/26/2011 3:05:34 PM
Tick Count: 11346062
Host Name: xxxxxxxxx
Process: AeXSvc (1212)
Thread ID: 65
Module: AeXSVC.exe
Source: DataClassRowCollection.InternalTableInserter
Description: Bad dataloader data : A 'Replace row (rRow)' has been ignored due to missing non-null fields for data class Inv_ServiceDesk_Incident_Details (ServiceDesk Incident Details (cd4b67fc-2b2c-42ca-8a3a-c7a24f530dd5)) and resource PERSONAL COMPUTER (ff26e8a8-7309-43c1-af80-e034b17638f2)
I have controlled the language and International Settings of SQLServer, SD7.1 and SMP 7.1 but is same into the all.
Any idea?
Thanks
Danilo