Video Screencast Help

Symantec Embedded Database 12.1 RU2 Problems

Created: 26 Feb 2013 | 6 comments

After I upgraded to the RU2 it seems the database service can't stay running for more than a day. I have tried to run dbvalidator but it failed. I can start the service manually and it seems to run for about 24 hours or so. Here is what happened when I ran dbvalidator.

 

 

2013-02-26 11:41:30.790 THREAD 1 INFO: logger initialized ...
2013-02-26 11:41:30.790 THREAD 1 INFO: SEPM Server Home:[C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Tools\..\tomcat]
2013-02-26 11:42:33.565 THREAD 1 INFO: Initialized the database.
2013-02-26 11:43:34.064 THREAD 1 SEVERE: Error occurred.
com.sygate.scm.server.metadata.MetadataException: 
at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:965)
at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:931)
at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:971)
at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:997)
at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:254)
at com.sygate.scm.server.configmanager.ConfigManagerCache.prepareTopLevelObject(ConfigManagerCache.java:362)
at com.sygate.scm.server.configmanager.ConfigManagerCache.getTopLevelObject(ConfigManagerCache.java:275)
at com.sygate.scm.server.configmanager.ConfigManager.getTopLevelObject(ConfigManager.java:336)
at com.sygate.scm.server.configmanager.ConfigManager.getSemConfigRootObject(ConfigManager.java:2190)
at com.sygate.scm.tools.ludbfix.XmlValidator.<init>(XmlValidator.java:119)
at com.sygate.scm.tools.ludbfix.XmlValidator.main(XmlValidator.java:498)
Caused by: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Database server not found
at sybase.jdbc4.sqlanywhere.IDriver.makeODBCConnection(Native Method)
at sybase.jdbc4.sqlanywhere.IDriver.connect(IDriver.java:772)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:243)
at sybase.jdbc4.sqlanywhere.ASADataSource.getConnection(ASADataSource.java:317)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDataSourceDBConnection(DatabaseUtilities.java:398)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:285)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:270)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:260)
at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:963)
... 10 more
com.sygate.scm.server.util.ServerException: Unexpected server error.
at com.sygate.scm.server.configmanager.ConfigManagerCache.prepareTopLevelObject(ConfigManagerCache.java:379)
at com.sygate.scm.server.configmanager.ConfigManagerCache.getTopLevelObject(ConfigManagerCache.java:275)
at com.sygate.scm.server.configmanager.ConfigManager.getTopLevelObject(ConfigManager.java:336)
at com.sygate.scm.server.configmanager.ConfigManager.getSemConfigRootObject(ConfigManager.java:2190)
at com.sygate.scm.tools.ludbfix.XmlValidator.<init>(XmlValidator.java:119)
at com.sygate.scm.tools.ludbfix.XmlValidator.main(XmlValidator.java:498)
Caused by: com.sygate.scm.server.metadata.MetadataException: 
at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:965)
at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:931)
at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:971)
at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:997)
at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:254)
at com.sygate.scm.server.configmanager.ConfigManagerCache.prepareTopLevelObject(ConfigManagerCache.java:362)
... 5 more
Caused by: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Database server not found
at sybase.jdbc4.sqlanywhere.IDriver.makeODBCConnection(Native Method)
at sybase.jdbc4.sqlanywhere.IDriver.connect(IDriver.java:772)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:243)
at sybase.jdbc4.sqlanywhere.ASADataSource.getConnection(ASADataSource.java:317)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDataSourceDBConnection(DatabaseUtilities.java:398)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:285)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:270)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:260)
at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:963)
... 10 more
 
 
Any ideas?
Operating Systems:

Comments 6 CommentsJump to latest comment

SebastianZ's picture

Caused by: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Database server not found

...have a look here:

 

https://www-secure.symantec.com/connect/forums/end...

https://www-secure.symantec.com/connect/forums/fai...

+ check the odbc connection to database:

http://www.symantec.com/business/support/index?pag...

 

To verify ODBC connection with the embedded database:

  1. On the management server, click Start > Control Panel > Administrative Tools.
  2. In the Administrative Tools dialog box, double-click "Data Sources (ODBC)".
  3. In the ODBC Data Source Administrator dialog box, click System DSN.
  4. On the System DSN tab, double-click SymantecEndpointSecurityDSN.
  5. On the ODBC tab, verify that the Data source name drop-down list is SymantecEndpointSecurityDSN and type an optional description.
  6. Click Login.
  7. On the Login tab, in the User ID text box, type dba.
  8. In the Password text box, type the password for the database. This password is the one that you entered for the database when you installed the management server.
  9. Click Database.
  10. On the Database tab, in the Server name text box, type<\\servername\instancename>. If you use the English version of Symantec Endpoint Protection Manager, type the default, sem5. Otherwise, leave the Server name text box blank.
  11. On the ODBC tab, click "Test Connection" and verify that it succeeds.
  12. Click OK.
  13. Click OK.

To verify ODBC connection to the SQL database:

  1. On the management server, click Start > Control Panel > Administrative Tools.
  2. In the Administrative Tools dialog box, double-click "Data Sources (ODBC)".
  3. In the ODBC Data Source Administrator dialog box, click System DSN.
  4. On the System DSN tab, double-click SymantecEndpointSecurityDSN.
  5. In the Server drop-down list, verify that the correct server and instance is selected.
  6. Click Next.
  7. For Login ID, type sa.
  8. In the Password text box, type the password for the database. This password is the one that you entered for the database when you installed the management server.
  9. Click Next and make sure that sem5 is selected for the default database.
  10. Click Next.
  11. Click Finish.
  12. Click "Test Data Source" and look for the result that states: TESTS COMPLETED SUCCESSFULLY!

 

+ repair SEP from control Panel and start Management Server configuration wizard.

phillipfry's picture

I misunderstood how the dbvalidator worked. I started the embedded database and it succeeded I think. Here is what the log says now:

 

2013-02-26 20:38:04.685 THREAD 1 INFO: logger initialized ...
2013-02-26 20:38:04.685 THREAD 1 INFO: SEPM Server Home:[c:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Tools\..\tomcat]
2013-02-26 20:38:06.355 THREAD 1 INFO: Initialized the database.
2013-02-26 20:38:11.425 THREAD 1 INFO: Starting to travel the schema ...
2013-02-26 20:38:14.045 THREAD 1 INFO: ... finished travelling schema.
2013-02-26 20:38:14.045 THREAD 1 INFO: Total ids found >> TargetIds [185] PhysicalFileIds :[57]
2013-02-26 20:38:14.045 THREAD 1 INFO: SELECT ID FROM BASIC_METADATA WHERE ID IN ('1476E5B5CC087A98C34F84369C59A78D','0404E0AC0E28C308610C28E0BAFE6367','66894B43C17167DCC5C946BBF98F182F','B417F42345DFFA6A157F743A26A5A72A','DF9C7E11C0A865D500D47C6534E36255','90EDFA86C0A865D500213E13FD99F82F','451EF1F1C0A865D5017AEA9990501342','A59A56E7C0A865D500D42D4939D82980','D6C51D90C0A865D500E007889ADE511C','44782F78C0A865D501F249084DEF7663','FE998CFEC0A865D50033D6F1ED5462B5','6B8CFCF3C0A865D50162CA061C58C54B','5DDA17265647BC4A58F9527841AC6F51','7E1E9BBBC0A865D501E0592C117C46D3','3E294F01CF81584A389E32938CFEC195','060B10F3C0A865D50129E211FB83F2F5','20D6E325C0A865D501F11BE16CDBA664','F64AF2D2FB5430DF364508D201163593','C61164E7C0A865D500556AA90F387F55','6C0FA18E6D791E6F67A160F27236E54E','C3653A1EC0A865D5001301FA62EF0F96','90F5C4F7C0A865D501978F4F53F10E1E','B2F0B636C0A865D501BBA96664B067C7','C3B1C2130729C2C72E6BE99CEDBC0DAF','C75BBF1AC0A865D500BD9256A3691CC7','99DB71F629E7EE03F543332DF260CFF7','D15FBDBAC0A865D501502283AFB00DCD','6FD723D39B5F3D8E62B86D5A5DC1E232','841DB2B3A6BBFF85002B6B9BA6346F67','1235020CC0A865D5007A78ECD2B6D79A','4E2D2D6A14F8038B1A6518C3E308496D','55D2B809C0A865D5010AC73BC2B22DFA','5F680AC8C0A865D501A996FFC1185C4F','2CF3BD7CC0A865D5006F26BB97B14D37','CCEE0591C0A865D501EE9422604060F0','B5142D6E280D45AB4BCF56DF11CEF2EE','66B60501C0A865D500AD93F6EABA4624','2822E3FAC0A865D5000B495EA68F90B4','540D6AF8C0A865D501BEFFCD61222AFE','7B7B8367C0A865D501A84F3CF8DF8B90','5B711928BD70BE882FBE553E28B2C843','E6BF0E44C0A865D5017F9A2982A45839','AF7040C9C0A865D5013FD0688BC84DCE','DAC5928BC0A865D5003DC831F5D424CD','5A1E8CFC79D0221BCD3ABAFFB1E8E497','10D13E2EC0A865D50032AF899977A2A4','DAFA11590EA4B4438A3DCE320D6B7A9F','0DBA9FFA9BD188993D44121E8D272912','1D519777C0A865D5000A8D453B645F86','A3314CB5C0A865D50026A4CE57926C04','3A2A8A1AC0A865D501B8DBA599E21A86','AF2306993021DC6080546311031A9CEE','6B404C8EC0A865D50079FF89F3A6A0C4','921F80B7C0A865D500DAAE1DC6FA04E6','E4BC6ADDC0A865D501B90C555F5D756B','0BCC789041072C9AC188AF34D6A2EC43','6E415DD8C0A865D501591DA26F728473','B1037D3DC0A865D500DC8DE9EC02A378','AC1369EFC0A865D50159BE0D8F34D5F6','2950E72AC0A865D5011CDF8A49CBB713','20A875DEC0A865D50066458B95C4DC2C','0D83C411C0A865D501E7DEB64BF90D12','E67B9C40C0A865D500B25809F0B9E885','568B410EC0A865D5006901DC89D839E0','3A18996AC0A865D501516197B189ED1A','028F0C98C0A865D5002A544E3B733D72','69F32E8BC0A865D5009FDA4179EE2396','2E3B60A0C0A865D500A39A114DDE177A','00BCA663C0A865D50163542C0FAA4D32','8CA0770CFA78AB90E1FB1310AC68F5B7','C9FAB27A15792B47A2AD911E16992271','3F30AE5C5A64256058BFFC2395867486','275A9D64C0A865D501ADC6A5D149A607','49E521F43EAD68675B0977FC47D133B9','22F0EE92C0A865D5009F0DF077A95AAD','BD3DA1FBC44BB58C7C7491FABE39E594','41B38D79C0A865D500E03BD6CA66B6C3','3E418D9EC0A865D500B9F649B3199192','AD6396F8FC5303DD9ED0FC22AB1C4884','98BBF15D0DF864D1B0164E74D0BA802B','32B95BD3EADD291F38FEC47612B1F268','B0973B5AC0A865D500CC8237539F39A5','906F12ADC0A865D501BD83B205131C76','3218C8CAC0A865D50135D8589BF6B12D','CA8C96D2C0A865D500D7E6EF6F621BAB','8B3E6337D1C2A84DB7E0340B8B3A9588','47617DFE87FBBFCE115A139521902DFA','E04882B1C0A865D50004E2AE929068A5','443F0F4D8F0D47E55DC5274A916EEF17','5A80A873C0A865D501AD3AC18D5D2849','B910E54E89EA4EF51447C7BA914C87F9','E4188F0EC0A865D500D96814BBCD1049','DB6535C2AF77888C1049E91940103C2E','F4C7A158C0A865D50084291378F62826','6028C6E625754ECE4312D41CB963A039','D27DD4B2C0A865D5004AEE539EA7E25F','221200A2C0A865D5002EB8E3E6C10E63','7A3F1CB2BAE4356DBBD3BAA95C56527B','3E9A07FFC0A865D500150C2C8C063052','2A3D2D240F7FB7FDDD954AE0799D933E','69F55822C0A865D501AAE35732B55017','5D3558D8C0A865D5003C019611756615','270FC2D89460177D5F2605D11CB93A51','88281B8641B4784A587CDE2CFA92DAE9','37480984C0A865D501E33378CCA65A22','8686B85FC0A865D501F34DAD494D2B51','F5879BBEC0A865D500BEAFE73D74980C','7ACB09446F1982F42926DD23565CFA6B','CB77039DC0A865D500803A13571DEFEC','3B993BB9C0A865D5007DAF5B9C89830B','F4CAE1F9C0A865D500B2E7B496C6C2A3','CCB602C4C0A865D50115F1D361AAC705','7A05101BC0A865D5011BBE4F027B0F02','B193E0C6C0A865D50193B520BD4CF314','8078782DC0A865D501AEA1ED68B19522','FFEE4202C0A865D5015814485F419B03','5AF09EAFC0A865D50119537A2C49BAC3','338656C8C0A865D501D62AC48486CDED','356809E5C0A865D501AD8678D37A6A1D','75FF60A1B1A83BA51A469EE6E3AC10AF','0CE428F1F05EBB5096E5531B5EBC9B7E','EEF8FE53C0A865D5004CB16250E9CBDC','3165FD56C5790BC3ED69F8C9E0099ADF','5C3A12B5C0A865D501C041FF5F5EFBE5','D3FF136037C0BA74FAFAFABF79F21524','DF5166D9C0A865D501D37013D8D30E28','91FF3703C0A865D50143CC2011128137','EEA2D55AC0A865D5010A238E2C5D466C','8945ED9544A38EADCD1FA76EF24D955B','F18E25F4C0A865D5015ED12CB22B1921','4A256622D963B59F54738BA981155378','84832AF3C0A865D50063AACE5F3C5A2D','53457F1FE2F251872E7E02F171C8ED02','307FC4A99C2D2B8F4429F6004D68E16E','B655E64D0A320801000000E164041B79','42CA4F27C0A865D5001972BF98096148','3941506DC0A865D500BF091DAC059D8D','B910F5CCC0A865D5013A4AD017B93F2B','474658E3C0A865D5019C1DC4E188C286','6C6DDEB1C0A865D50077243DDC43C8AB','B20B6E870A980D7A00AF2A50862A396D','B8989990C0A865D501B15447BFC0F801','D724BEB6C0A865D50146950C32E4CCE5','CD768331E089D91A9CCB2B564E6E8F5B','33407770818F46DF5E62B5EB38DBCDB5','5ED406ABC0A865D5004C98E7B16CD839','996791F2C0A865D50145409687849587','0BAFBA22AAEA4BD06C373989DC8322D4','DC3894F8C0A865D50166A538C712A3F5','3A44C5D0C0A865D500B2AAA67A01263F','9A713704AC66B7F0245A58BB4A3BBBB2','43DF2DB64559A1453B4EAB63F734F50D','489AEBE487D732BD701952F4CE7C9925','A01FD158C0A865D501AA6088F6B18E81','4A6DD866D1B10FA50641B43DD03F4D83','A92713E4C0A865D501AC0D4583CFD927','047904F055302437E61932857014809A','D0057E8AB1C47D30ABDB6149E4AC22B1','6B8E615568F8AAC9ED17A0FDED8A80D7','E2290A05C0A865D50158E45864DB6E80','CDBD8F47C0A865D50194737D212EEB0F','16E7B6E3C0A865D5016E5ECB69CADFF5','2AD51B2B42FC2013656B13EE8E52BA92','4AC3E6C2C0A865D501F7CED87B9BA273','A9C43B8E8E822462C37C3FC590E1DDB0','28F86A92C0A865D50174A57EE7E1BA86','70F66CCAC0A865D5005D7A8DFF0F95A5','F160CB467310766585FA1F74175CF10F','901E7A95C0A865D5000847E7BFACC596','FF9421D7C0A865D501E8AC6F77DFD7D0','8B227B6C6B391E2C4A3F4011D1555DF2','9268C29FC0A865D5013DDBDD087D9D83','693C9DADC0A865D500967E8CB02582C0','97A6CF01C0A865D501B8DC933930712A','E289F88B78EC6632E671B71C59B9205C','EA64B9EFC0A865D500DF20AE15AB6809','76481100C0A865D501DE5F0BE47A6BE1','854F816AB5090871135F2ACFEBC503C5','DAEF3F8EC0A865D5001BCC9F3D04F1AE','CE3358AAC0A865D5007CDDCBCC745B4F','C384A4E7C0A865D500B59FD96B698D9A','74931177C0A865D5008746474AB8EB04','CCF9A581C0A865D500059579253FB936','D853F92C0A5BD6BCCA82982DF9606A92','0D02B53AC7226601637E3FF5E24F4472') AND DELETED=1
2013-02-26 20:38:14.077 THREAD 1 INFO: SELECT ID FROM BINARY_FILE WHERE ID IN ('D1925D48C5CB2BBDC0A69CC92BAE0F13','8A7DD792540E9983AAF27D1DE986CB35','831DBD591AD3E469450011AA115EE957','7B822AC5110193604DDEE41F9E15A715','F0D2A84001882A0CF902FE2B96BC8C90','E6567B5665784F1E02F5272A3C7913BC','F25639EE2881C0DBC0A9E1A41600846C','CF087C92BAEF91BD82BD3D282F6637FF','77614AADF4A43804675E4943C86C7360','5A3281B90FD67E3A7E7B7EC41F235BD7','73FB9FB69453D51EB70BF0ADAF19184B','7F5A19DB065B0D71337F76F6C99E67E6','F6B90DF5EB3A077A01774610AAF7BA61','41E710FDCC4D14088A1BDA10D06CF5BB','A4D421CA6F891BCC0E6D0D671DDAD5EF','BA957A9559D9170D046CC0013103BE5E','911608E39D651334524E1FB80938D0FB','B92A97CED488CBBEDA86890365F65E95','0C1DC66DB8CE8C11B9DB82CB0178E50E','B48F30EA2B93F963B4B485B38C29893A','0586398F6C2FB3D1B278A8BA042A7547','3B45AF9A618E76B79254B032EF3EE870','C9DC01D980B92066940BCAA611F947FB','E45AF8912BE0F7204FC481AF49E7C8F2','DB9D3C4AF766BB14561118178CF722E5','8015A7665B03905464224CE552F3F16F','715A0A4C9ACB32186C6829A6B71520AB','EE6A229DD16D4ED20C9F16D967FE7EA6','5F072B54E9E31C0965353E34764CCC4D','A2606A49C2600298D4C9FFE36FFD361F','8128C8FA90121874659F16F5D225EA75','BA76160D21DD569D1A4D1CE802B5924F','C2C007E1526389162BDFAC74BB555AA2','0A90F640608E042D720597E24F54503D','E3AC0CA99B2B347AF4B18C871989A652','45B9C41149EB162F13D55C6AB7F39965','15D3F7FC20623FFAAFB0F7A71CAB24FE','5BD652D08E1953592AF7FF8EFCD55320','B84D12CBB2CCE8E879E1B1F8B2CDB3FB','4B8B7E1F03ADB487DEFBE700DA0E5BA3','84F3B3F71876D9C3B39C8550640EF078','D2E454C1CF659F94ED90B19A16338A5D','6C68E363278C9D2923759FD949B6CE3B','24E722EFAF142329917DCFD20C3F5F40','CF03ECBDBF81D215578C1C9AF11ADDB2','2D15222F8F244552E3CC01564BBA2859','05084C193EFBBD67FF98E7603D4BCD5A','178A7A8C5301700362A21D72FC317E47','16F986E93E8167FB58F470F5491520A5','CCF2930723F152A4B74565A53D8E3696','5AF7D7280EB06DBC46BB307FE6897744','25E2F214E7466DD64192298FA59E4318','1020A2EE60B31178C6FD251419100586','848D6708174993A37F8A3D735EB5A925','A38A16923F001A125EA4CDD9C970DA00','1A6A32BC529AF57555A6F176A31A4283','93CF93C4DEA1318C7F686005A239EEDC') AND DELETED=0 and CONTENT IS NOT NULL
2013-02-26 20:38:14.092 THREAD 1 INFO: *********************************************
2013-02-26 20:38:14.092 THREAD 1 INFO: Following ids are not present in the database.
2013-02-26 20:38:14.092 THREAD 1 INFO: *********************************************
2013-02-26 20:38:14.092 THREAD 1 INFO: Link is broken for [0] target ids :
2013-02-26 20:38:14.092 THREAD 1 INFO: *********************************************
2013-02-26 20:38:14.092 THREAD 1 INFO: Link is broken for [0] physical file ids :
2013-02-26 20:38:14.092 THREAD 1 INFO: *********************************************
2013-02-26 20:38:14.092 THREAD 1 INFO: Database validation passed.
2013-02-26 20:38:14.092 THREAD 1 INFO: Finished.
 
The database seems to only stay up for a little bit now. Here is what the out.log says:
 
I. 02/26 21:46:18. This database is licensed for use with:
I. 02/26 21:46:18.     Application: Symantec Endpoint Protection Manager
I. 02/26 21:46:18.     Company: Symantec Corp
I. 02/26 21:46:18. Performance warning: Server cache size is too small for database "sem5"
I. 02/26 21:46:18. Database server started at Tue Feb 26 2013 21:46
I. 02/26 21:46:18. Trying to start SharedMemory link ...
I. 02/26 21:46:18.     SharedMemory link started successfully
I. 02/26 21:46:18. Trying to start TCPIP link ...
I. 02/26 21:46:18. Starting on port 2638
I. 02/26 21:46:18.     TCPIP link started successfully
I. 02/26 21:46:19. Now accepting requests
I. 02/26 21:46:20. Performance warning: No unique index or primary key for table "SERVER_SYSTEM_LOG_1" in database "sem5"
I. 02/26 21:46:20. Starting checkpoint of "sem5" (sem5.db) at Tue Feb 26 2013 21:46
I. 02/26 21:46:20. Finished checkpoint of "sem5" (sem5.db) at Tue Feb 26 2013 21:46
I. 02/26 21:46:20. Starting checkpoint of "sem5" (sem5.db) at Tue Feb 26 2013 21:46
I. 02/26 21:46:20. Finished checkpoint of "sem5" (sem5.db) at Tue Feb 26 2013 21:46
I. 02/26 21:46:20. Starting checkpoint of "sem5" (sem5.db) at Tue Feb 26 2013 21:46
I. 02/26 21:46:20. Finished checkpoint of "sem5" (sem5.db) at Tue Feb 26 2013 21:46
I. 02/26 21:46:21. Starting checkpoint of "sem5" (sem5.db) at Tue Feb 26 2013 21:46
I. 02/26 21:46:21. Finished checkpoint of "sem5" (sem5.db) at Tue Feb 26 2013 21:46
I. 02/26 21:46:21. Starting checkpoint of "sem5" (sem5.db) at Tue Feb 26 2013 21:46
I. 02/26 21:46:21. Finished checkpoint of "sem5" (sem5.db) at Tue Feb 26 2013 21:46
I. 02/26 21:46:31. Starting checkpoint of "sem5" (sem5.db) at Tue Feb 26 2013 21:46
I. 02/26 21:46:31. Finished checkpoint of "sem5" (sem5.db) at Tue Feb 26 2013 21:46
I. 02/26 21:46:32. Starting checkpoint of "sem5" (sem5.db) at Tue Feb 26 2013 21:46
I. 02/26 21:46:33. Finished checkpoint of "sem5" (sem5.db) at Tue Feb 26 2013 21:46
I. 02/26 21:47:21. Performance warning: View "V_CLIENT_CHANGE_LOG" in database "sem5" was invalidated due to DDL operations on one of its referenced objects
E. 02/26 21:48:51. *** ERROR *** Assertion failed: 200505 (12.0.1.3554)[sem5]
Checksum failure on page 2951
I. 02/26 21:48:52. Database server shutdown requested via server console
 
 
 
SebastianZ's picture
E. 02/26 21:48:51. *** ERROR *** Assertion failed: 200505 (12.0.1.3554)[sem5]
Checksum failure on page 2951
 
...the error does not look really good. Do you have any older backups of the database - it may be corrupted at this point and possible the fastest solution will be teh disaster recovery
 
phillipfry's picture

I read that others had luck with doing a disk defrag. So I initiated a disk defrag and started the embedded database service after it completed. The service has been running for 2 hours so far without crashing/stopping.

It is too bad the small business edition doesn't support MSSQL as I would just move the database to MSSQL. 

Thanks!

 

phillipfry's picture

OK. I spoke too soon. It seems it ran for about 12 hours before it stopped again. I have a database backup but it was before I upgraded the schema from RU1 -> RU2. I'm assuming that backup won't be any good since i'm running RU2? The database was fine before the upgrade but ever since upgrading it cant stay up for more than a day.

 

SebastianZ's picture

To use that backup you would need to do the disaster recovery of the SEPM first to RU1 version and then do the upgrade one more time.

Info about disaster recovery: http://www.symantec.com/docs/TECH160736