QMM Statistics portal is empty. EMWSCA.log contains errors similar to the following:
22/06/2011 15.59.03 NTServiceBroker::WaitStopEvent TraceMsg 7000 The service was started.
22/06/2011 15.59.03 CAffectedServer::CImportStat::ImportSessions Warning 2004 Hierarchy import was not completed. The rest of statistics data will be imported during the next session.
22/06/2011 15.59.03 CAffectedServer::CImportStat::ImportSessions Warning 2004 Hierarchy import was not completed. The rest of statistics data will be imported during the next session.
22/06/2011 15.59.04 CAffectedServer::DeleteUseless Informational 610 Cleaning up the tombstones and removing outdated records from the statistics database. Retention period: 30 day(s).
22/06/2011 15.59.04 CAffectedServer::CPersistADO::DeleteUselessRecords Error -2147217913 [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting datetime from character string.
22/06/2011 15.59.04 CAffectedServer::CPersistADO::DeleteUselessRecords Error -2147217913 [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting datetime from character string.
EMWStat.log also has similar errors:
22/06/2011 15.59.03 CPersistADO::DeleteUselessRecords Error -2147217913 [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting datetime from character string.
22/06/2011 15.59.03 CADORow::Update Error -2147217913 [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting datetime from character string.
22/06/2011 15.59.03 CADORow::Update (API) InternalError 3 The system cannot find the path specified.
22/06/2011 15.59.04 CPersistADO::DeleteUselessRecords Error -2147217913 [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting datetime from character string.
22/06/2011 15.59.04 CPersistADO::DeleteUselessRecords Error -2147217913 [Microsoft][ODBC
This could be caused by non-standard time separator being used on the workstations where Statistics Collection Agent is installed. Note the log entries in the above example have timestamps looking like "22/06/2011 15.59.04" rather than usual "22/06/2011 15:59:04"
Logon to computer where SCA is installed with a QMM service account, go to Regional options ->Time and change time separator to : (column)
