Win2003with ZCM agent10.2
SLES10SP2(64bit) - with ZCM10.2 server


On the Win2003 i do:
zac pr
and in the ZCM log i see:

[DEBUG] [08/07/2009 12:32:34.500] [952] [ZenworksWindowsService] [29] [] [Sqlite] [] [(objInfo.db) ReadpVm.sqlite3_step call failed: ERROR. Throwing exception] [] []

[DEBUG] [08/07/2009 12:32:34.500] [952] [ZenworksWindowsService] [29] [] [Sqlite] [] [(objInfo.db) SqliteCommand.ExecuteReader.finalize returned error: CANTOPEN] [] []

[DEBUG] [08/07/2009 12:32:34.500] [952] [ZenworksWindowsService] [29] [] [Sqlite] [] [(objInfo.db) SqliteCommand.ExecuteReader exception: (err=1): sqlite step call failed

at Novell.Zenworks.Cache.Sqlite.SqliteDataReader.Read pVm(IntPtr pVm, Int32 version)

at Novell.Zenworks.Cache.Sqlite.SqliteDataReader..cto r(SqliteCommand cmd, IntPtr pVm, Int32 version)

at Novell.Zenworks.Cache.Sqlite.SqliteCommand.Execute Reader(CommandBehavior behavior, Boolean want_results, Int32& rows_affected)] [] []

[DEBUG] [08/07/2009 12:32:34.500] [952] [ZenworksWindowsService] [29] [] [ZenCache] [] [Sqlite Exception getting object record for key PREVIOUSLY_ENFORCED_LIST_243bda748d7d54dfec8117abe 489f17e~9c43d5e66ad552492ba59c43d5e66ad5_UserPrede sktop on attempt 1: (err=1): sqlite step call failed

at Novell.Zenworks.Cache.Sqlite.SqliteDataReader.Read pVm(IntPtr pVm, Int32 version)

at Novell.Zenworks.Cache.Sqlite.SqliteDataReader..cto r(SqliteCommand cmd, IntPtr pVm, Int32 version)

at Novell.Zenworks.Cache.Sqlite.SqliteCommand.Execute Reader(CommandBehavior behavior, Boolean want_results, Int32& rows_affected)

at Novell.Zenworks.Cache.Sqlite.SqliteCommand.System. Data.IDbCommand.ExecuteReader()

at Novell.Zenworks.Cache.SqliteEntryInfoProvider.GetC acheEntry(IDbConnection dbConn, String key, UserContext owner, Type type)

at Novell.Zenworks.Cache.SqliteEntryInfoProvider.GetO bjectEntry(String key, UserContext owner)] [] []

[DEBUG] [08/07/2009 12:32:34.500] [952] [ZenworksWindowsService] [29] [] [ZenCache] [] [Validating dbSchema...] [] []

[DEBUG] [08/07/2009 12:32:34.500] [952] [ZenworksWindowsService] [29] [] [Sqlite] [] [objInfo.db SqliteCommand.ExecuteReader.prepare returned error: CANTOPEN] [] []

[DEBUG] [08/07/2009 12:32:34.500] [952] [ZenworksWindowsService] [29] [] [Sqlite] [] [(objInfo.db) Throwing sqlite exception from ExecuteReader(sql, want_results, err, errMsg): (pragma quick_check, True, CANTOPEN, )] [] []

[DEBUG] [08/07/2009 12:32:34.515] [952] [ZenworksWindowsService] [29] [] [ZenCache] [] [Unexpected exception while checking database file integrity. ConnStr = URI=file:C:\Program Files\Novell\ZENworks\cache\zmd\ZenCache\metaData\ objInfo.db,version=3

Type: Novell.Zenworks.Cache.Sqlite.SqliteException

Message: Sqlite Error: 14

Stack Trace:

at Novell.Zenworks.Cache.Sqlite.SqliteCommand.Execute Reader(CommandBehavior behavior, Boolean want_results, Int32& rows_affected)

at Novell.Zenworks.Cache.SqliteEntryInfoProvider.IsFi leMalformed(String dbPath)



] [] []

[DEBUG] [08/07/2009 12:32:34.515] [952] [ZenworksWindowsService] [29] [] [Sqlite] [] [objInfo.db SqliteCommand.ExecuteReader.prepare returned error: CANTOPEN] [] []

[DEBUG] [08/07/2009 12:32:34.515] [952] [ZenworksWindowsService] [29] [] [Sqlite] [] [(objInfo.db) Throwing sqlite exception from ExecuteReader(sql, want_results, err, errMsg): (select tbl_name, sql from sqlite_master where type = 'table' and name not like 'sqlite_%' order by tbl_name, True, CANTOPEN, )] [] []

[DEBUG] [08/07/2009 12:32:34.515] [952] [ZenworksWindowsService] [29] [] [ZenCache] [] [Unexpected exception while getting database schema. ConnStr = URI=file:C:\Program Files\Novell\ZENworks\cache\zmd\ZenCache\metaData\ objInfo.db,version=3

Type: Novell.Zenworks.Cache.Sqlite.SqliteException

Message: Sqlite Error: 14

Stack Trace:

at Novell.Zenworks.Cache.Sqlite.SqliteCommand.Execute Reader(CommandBehavior behavior, Boolean want_results, Int32& rows_affected)

at Novell.Zenworks.Cache.SqliteEntryInfoProvider.GetS chemaFromDatabase(String dbConnStr)



] [] []

[DEBUG] [08/07/2009 12:32:34.546] [952] [ZenworksWindowsService] [23] [] [Sqlite] [] [(objInfo.db) SqliteCommand.ExecuteReader exception: Error in the application.

at Novell.Zenworks.Cache.Sqlite.SqliteCommand.Execute Reader(CommandBehavior behavior, Boolean want_results, Int32& rows_affected)] [] []

[DEBUG] [08/07/2009 12:32:34.546] [952] [ZenworksWindowsService] [23] [] [ZenCache] [] [Sqlite Exception putting file record for key ContentMgr::ItemList on attempt 1: Error in the application.

at Novell.Zenworks.Cache.Sqlite.SqliteTransaction.Com mit()

at Novell.Zenworks.Cache.SqliteEntryInfoProvider.PutO bjectEntry(ObjectCacheEntry& objectEntry)] [] []

[DEBUG] [08/07/2009 12:32:34.546] [952] [ZenworksWindowsService] [23] [] [Sqlite] [] [(objInfo.db) SqliteCommand.ExecuteReader exception: Error in the application.

at Novell.Zenworks.Cache.Sqlite.SqliteCommand.Execute Reader(CommandBehavior behavior, Boolean want_results, Int32& rows_affected)] [] []

[DEBUG] [08/07/2009 12:32:34.546] [952] [ZenworksWindowsService] [23] [] [ZenCache] [] [Exception performing transaction rollback: Error in the application.

at Novell.Zenworks.Cache.Sqlite.SqliteTransaction.Rol lback()

at Novell.Zenworks.Cache.SqliteEntryInfoProvider.Roll backTransaction(IDbTransaction dbTransaction)] [] []

[DEBUG] [08/07/2009 12:32:34.734] [952] [ZenworksWindowsService] [29] [] [ZenCache] [] [ValidateSchema() returned: True] [] []

[DEBUG] [08/07/2009 12:32:34.765] [952] [ZenworksWindowsService] [23] [] [ZenCache] [] [Validating dbSchema...] [] []

[DEBUG] [08/07/2009 12:32:34.765] [952] [ZenworksWindowsService] [23] [] [ZenCache] [] [ValidateSchema() returned: False] [] []

[DEBUG] [08/07/2009 12:33:35.125] [952] [ZenworksWindowsService] [29] [] [CLM] [] [Before call to ParseArgs] [] []

[DEBUG] [08/07/2009 12:33:35.140] [952] [ZenworksWindowsService] [29] [] [CLM] [] [Before call to ProcessCommand] [] []

[DEBUG] [08/07/2009 12:33:35.156] [952] [ZenworksWindowsService] [29] [] [ZMD] [] [Processing Command for handler cache-clear] [] []

[DEBUG] [08/07/2009 12:33:35.281] [952] [ZenworksWindowsService] [29] [] [ZMD] [] [Finished Processing Command for handler cache-clear. Result = SUCCESS] [] []

[DEBUG] [08/07/2009 12:33:35.281] [952] [ZenworksWindowsService] [29] [] [CLM] [] [After call to ProcessCommand. Result = SUCCESS] [] []

[DEBUG] [08/07/2009 12:33:35.281] [952] [ZenworksWindowsService] [29] [] [CLM] [] [After call to ParseArgs. Result = SUCCESS] [] []

[DEBUG] [08/07/2009 12:33:35.281] [952] [ZenworksWindowsService] [29] [] [CLM] [] [After call to StopDisplaySpinner()] [] []

[DEBUG] [08/07/2009 12:33:49.437] [952] [ZenworksWindowsService] [29] [] [CLM] [] [Before call to ParseArgs] [] []

[DEBUG] [08/07/2009 12:33:49.437] [952] [ZenworksWindowsService] [29] [] [CLM] [] [Before call to ProcessCommand] [] []

[DEBUG] [08/07/2009 12:33:49.453] [952] [ZenworksWindowsService] [29] [] [CLM] [] [After call to ProcessCommand. Result = ERROR] [] []

[DEBUG] [08/07/2009 12:33:49.453] [952] [ZenworksWindowsService] [29] [] [CLM] [] [After call to ParseArgs. Result = ERROR] [] []

[DEBUG] [08/07/2009 12:33:49.453] [952] [ZenworksWindowsService] [29] [] [CLM] [] [After call to StopDisplaySpinner()] [] []

[DEBUG] [08/07/2009 12:33:59.453] [952] [ZenworksWindowsService] [29] [] [CLM] [] [Before call to ParseArgs] [] []

[DEBUG] [08/07/2009 12:33:59.453] [952] [ZenworksWindowsService] [29] [] [CLM] [] [Before call to ProcessCommand] [] []

[DEBUG] [08/07/2009 12:33:59.453] [952] [ZenworksWindowsService] [29] [] [ZMD] [] [Processing Command for handler policy-refresh] [] []

[DEBUG] [08/07/2009 12:34:05.218] [952] [ZenworksWindowsService] [29] [] [ZMD] [] [Finished Processing Command for handler policy-refresh. Result = SUCCESS] [] []

[DEBUG] [08/07/2009 12:34:05.218] [952] [ZenworksWindowsService] [29] [] [CLM] [] [After call to ProcessCommand. Result = SUCCESS] [] []

[DEBUG] [08/07/2009 12:34:05.218] [952] [ZenworksWindowsService] [29] [] [CLM] [] [After call to ParseArgs. Result = SUCCESS] [] []

[DEBUG] [08/07/2009 12:34:05.218] [952] [ZenworksWindowsService] [29] [] [CLM] [] [After call to StopDisplaySpinner()] [] []



What is this ??


Why i see in the ZCM-log on the Win2003Term-server ?
Every day users have problem for Log in to the W2003TermSevrer
(Nw32client+ZCmAgent).. Users loged in to the NW-cleint and have grey Screen..1min, 10min...30min... after this call to the support..

And Administartor MANUAL restart on the W2003Termserver "Novell Zenworks Agent service".. after this users can log in...:(

If before this Administrator not loged - only Reboot W2003 server.. :(


Serg