Video Screencast Help

can't backup embedded database

Created: 30 Jan 2014 | 19 comments
yamc's picture

hi

i want to upgrade my sepm to sep 12.1.4. before do it, i'm trying to backup the database using Database Backup and Restore wizard as require by symantec . But i cannot. i see this error: " backup failed due to a database problem: [Sybase][JDBC Driver][SQL Anywhere] I/O error Fatal error: A disk read from file "C:\Program files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db" failed with error code: (23) -- transaction rolled back "

how can i solve this problem. i need help

Operating Systems:

Comments 19 CommentsJump to latest comment

Rafeeq's picture

Do you have enough space on C drive? whats the size of SEM5.db?

and also try restarting embedded db service once and then try the backup

https://www-secure.symantec.com/connect/forums/backup-failed-sepm

.Brian's picture

How much space do you have on C:?

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

yamc's picture

space on C drive: 12.2 GB

size of SEM5.db : 3.8 GB

.Brian's picture

Should be OK, have you tried restarting the SEPM?

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

Chetan Savade's picture

Hi,

Thank you for posting in Symantec community.

Could you repair the SEPM? Go to add/remove programs, select SEPM and click on repair.

Do you see any latest backup under ..\Symantec Endpoint Protection Manager\data\backup.

Chetan Savade
Sr Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

SameerU's picture

Hi

Can you try repairing the SEPM server and check

Regards

 

yamc's picture

i'm repairing  the SEPM but i have the same error when i try to backup the database using Database Backup and Restore wizard . when this error appear, it stop the symantec embedded database service. i'm restarting manually this service and running the Database Validation tool. the database is valid. so i don't know why i have again this error. please help me.

Can i copy manually the database and paste it on another disk for backup before upgrading the SEPM ? i'm never doing the backup of this database, it's my first time. or can i upgrade the SEPM without backup the database?

Chetan Savade's picture

Hi,

You mean SEPM repair is successful but not able to take database backup. Correct me if I am wrong.

It's strongly recommended to take a database backup prior to SEPM upgrade.

Total how many clients are managed by SEPM? If there are limited number of clients and don't have specific policies then can think to upgrade without backup. Can export policies manually and import after upgrade if those are custom.

Chetan Savade
Sr Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

Rafeeq's picture

are you able to login to SEPM?

You can try backing up the DB within SEPM console too

 

Tony K.'s picture

Go to the SEPM Install Dir\Tools run DBVALIDATOR.BAT - it will run and then place a log file in the SEPM Install dir\Tomcat\logs\dbvalidator-0.log

Paste the contents there - also - how many clients are reporting to the SEPM? Do you have any advanced configurations going on? Maybe exporting your policies and saving your S/N and the recovery file - remove the SEPM and reinstall using the upgrade SEPM install file and just recreate a new DB with the existing recovery file may be the solution (Disaster Recovery w/o database) just re-import your policies and recreate your client groups and go from there.

 

A remove/reinstall w/o db is not something I would say do off the bat, but if there are only like 50 clients or less or if you are really not attached to the database or starting with a fresh baseline isn't a concern - you could save yourself quite a few hours by starting over (if you have your policies exported) - obviously if this is a bigger environment or you are hesistatn, then run the valdation tool and post the results

AjinBabu's picture

Hello, 

Are you able to login to SEPM?

Regards

Ajin

yamc's picture

i'm able to login to SEPM and i'm trying to backup the DB within SEPM console but it's the same result.the backup fails and the symantec embedded database service stops. so i  restart manually the symantec embedded database service . 150 clients are managed by SEPM with specific policies.

.Brian's picture

Did you try the steps outlined above by Tony K.?

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

Chetan Savade's picture

Hi,

Navigate to C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\

Locate the sem5.log and check the size of log file.

Total how many custom policies are there for 150 clients?

Chetan Savade
Sr Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

yamc's picture

to Tony K.

the contents of the dbvalidator.log after running  DBVALIDATOR.BAT :

2014-02-04 16:01:14.484 THREAD 1 INFO: logger initialized ...
2014-02-04 16:01:14.500 THREAD 1 INFO: SEPM Server Home:[C:\Program Files\Symantec\Symantec Endpoint Protection Manager\Tools\..\tomcat]
2014-02-04 16:01:17.062 THREAD 1 INFO: Initialized the database.
2014-02-04 16:01:39.156 THREAD 1 INFO: Starting to travel the schema ...
2014-02-04 16:01:49.437 THREAD 1 INFO: ... finished travelling schema.
2014-02-04 16:01:49.453 THREAD 1 INFO: Total ids found >> TargetIds [197] PhysicalFileIds :[62]
2014-02-04 16:01:49.453 THREAD 1 INFO: SELECT ID FROM BASIC_METADATA WHERE ID IN ('5BE9C54CC096C567E631DF3BAF6301E8','990F2E4F0A00000C00D7C58A46891416','6C77C52A0A00000C01D471171175C37F','F36F73D80A00000C000D93A193E75805','2774F3F60A00000C0085BD217963A38D','BE3EEB31B2764FF03C9D90DA6A33B5E2','6B4BC70C0A00000C00D254381E3C1F93','1AE40DCE0A00000C00E5A8653AA854D7','7FB0DE129B4233F28B488168EECB7F01','55FDAA600A00000C00F94F724FCF2557','894FD33F0A00000C00D7E7FCC78EF130','30C6798636FBED65806D84A442421008','2DC042A3D5407C3AB32F618A8FA0A827','DF02FDFC0A00000C0100A107BCE69262','741CD7470A00000C0148FB701613A8D4','D4676F9E0A0000C701B71DD41A407870','1D3370730A00000C012C013F0D778677','B350974369F9FE9EF2D936E24A4DB71D','B69985940A00000C0070A760DD67529A','0DD569C80A00000C0007745BB08D3361','3E294F01CF81584A389E32938CFEC195','4006E680E80C4E0EDCEA5B296A2FB17E','782A93340A00000C00F6B0871292FAA2','60288DCC0A00000C012B6582F4BE4E25','F68AD8A8508CBE26E9BF0D48F89D177C','04463F2C0A00000C00D3AC27DC6B9A15','F64AF2D2FB5430DF364508D201163593','E495D00B0A00000C010AAE2F34C203CA','753FDA2E29FC1F77E8F67833C4B459AC','B3C514960A0000C70145C81FD83544BB','173073460A00000C001CF0BBF962358A','924DF0A30A00000C01AAA1C73EBF31E4','7972EE32BFB4AF914D45FC5C3142E519','AD0DEA3B2702E5F17C1DB8DB84534006','EAE4057D0A00000C006FB8029EAF9665','9AE8636E0A00000C0164770CEEA42F52','487EB4840A00000C0122A017B210A019','3E8968B4CC500324A48141402978406B','7EB247C20A00000C0003ABF8142CDA6B','857435900A00000C003D7B6DF01035BA','D87B96C40A00000C0003ABF89D6B7751','D851F0FC0A00000C005E4471C77BBA51','29A5F4AC6B059EDE25F886ED34DF9E44','F00DD1A00A00000C01AB639C55D5E103','920735050A00000C00E5A75738AB475D','6CFF89570EF7D9616023CEBC1233FD67','56B7C1280A00000C00905B91316CB6AE','A36834570A00000C017606541CF501E2','B44A3E0D9FA3586B76163E456B333FFC','B7F09DA7686A2AD8DD2D35715B7904F0','C134FE6A0A00000C00E4771E9B4F71F0','93454D080A00000C010B3958F021B659','1373E70A0A00000C00A4E66DAD94D2D2','D3BD2CD60A00000C005CC30E8359AC38','9A7104A30A00000C019196AA835EF65E','8A42D2410A00000C009EC6184136FBFC','0DBA9FFA9BD188993D44121E8D272912','EF16AA180A0000C7019E338412FCE99B','EE49D2F089ECA0473F7B5D2289C9363D','4BE9A81D0A00000C01EE2989915FCD16','0BCC789041072C9AC188AF34D6A2EC43','57E908F63DAAEBBC5802F37CBA50D5C0','BE680A160A00000C0154270DA6BED50A','026526770A00000C00429BB78B736F4C','5B9A891B96D25E3BE516C7F995598497','C3A2CD990A00000C009F293A124FD42E','F8DE9ACB0A00000C0193E4A4DA89D247','D3AC52B109F6C5BA711F6C4B483FD7C6','F51F91B8CA419799847A4E55899FF98F','F5EDBA0B0A00000C0000BEA8C5F0D34E','64ED307A0A0000C70007B0F120A4FA42','5A7842E80A00000C011FD57CE004B112','7335CA230A0000C701E0730A5AB0917E','D9520B1A0A00000C017388E4F2450261','20D8C8A90A00000C0008E73CBB41A3DB','34A8561A0A00000C00D20917A94FE684','190803B90A00000C01E43EA052779229','CAEC8299E1DFB68B1D38988B6EB429FF','84FFD9330A00000C00A0328BB48932BF','1D8F00740A00000C013ACA6149B9DF6F','EF06427B208780D79E1EC08CD96E2924','3EF90D820A00000C001A1C67EEAF867F','3F30AE5C5A64256058BFFC2395867486','9D369288B13691C8139C49868BF8425B','96EEE5CA90BAE89108A998C7B0157E45','BD3DA1FBC44BB58C7C7491FABE39E594','C912D1D7770F6B461EF1F4259CC60D6E','255643615074802E207181AB3CAA6A6B','8178151A0A00000C015F86284CB70566','32B95BD3EADD291F38FEC47612B1F268','3D678D4E0A00000C007B8E1AD0AB69BF','85E0EEF20A00000C0148A67A82A9C5A9','A360F74A0A00000C0182BDA8CB391508','6166857C412F9B4CC263AB30E6D8B00F','E79FC6A20A1C8988D29E1BB13F57EBA5','7A457BE519715C4E7DCC7E485B19C200','3432D5076E1265A8DE3D30135463A3E8','6028C6E625754ECE4312D41CB963A039','9AE12CBD0A00000C00B6ADD76E83A353','5FFA61E152D7699C3C02D49D5344BD84','2A3D2D240F7FB7FDDD954AE0799D933E','17A1A65C0A0000C700867209ADFE0F6C','72AAA2E142815C9903421D39E0F3930B','1E3D8FE30A0000C7010C0B4102BBE8E0','D597779D0A00000C016A9FD3FCBD7917','ECA79EAA0A00000C0088E7ECDDB58D3D','5DB4E2300A0000C7013E87F7B57C4D4C','5A6972B00A00000C016F1374A6C2DD94','B54D57460A00000C0135E6175551CEA6','F38F46810A00000C00D25FF216F495A3','DC2D86F30A00000C01172AC0D7187C0A','DF47D8F97CFBFBAD10DB6F9C50052BAD','EE5BF1290A00000C01F796F0028F4E09','1FF98BF00A00000C005AE0477ADC35F2','D39EEF4A9D9F2E700854A3CD68FAF2F8','BC170D430A00000C01F27B79AE961B2C','934370A60A00000C00EEE2E66E3071EF','586A00330A00000C002D50F7747C8495','57917A1A0A00000C00B9F18939B2098C','DC3D1B890A00000C00D3FF7AA0D29913','C62387560A00000C010D33EAC219DD79','8AE380550A0000C700917D75D4C5B8E6','7B78BAC60A00000C008711E29923A565','44E69B3C0A00000C0076BB9CD88E9BBE','89DE26D77AA17E9E03BAD77C3A1A1276','7C1787C10A0000C701C37C9BA867B48A','6CBD625F9C75B8E2A36014DFCB343542','E355A6520A00000C00FE9AB399805F98','A81C2D1E267D5AF1CCD71252A73434E8','F5A69F1471D5003259578CF9187F5A18','B26679A40A00000C009628C3FA0FFD46','B1F63FBB571B0E84082748A78B4A4F33','4A313EF673172994F2C65FA697606FB5','B655E64D0A320801000000E164041B79','BF729EFA0A0000C7006E921D0F2FED6B','63CDE9B1D24164F82CA4A7A677052400','9DC52C9BDAB932062922012195E88273','DADF64A10A00000C01711A778C3E7CD2','8FF0A0700FE0C3BB9A56D28A1E3E2168','18903C9D0A00000C00B024087FC699C5','61A4DC06CD49B8B8E6103537AAEAFF50','B20B6E870A980D7A00AF2A50862A396D','C1951A3D0A00000C01A1E2C78DE8EB88','99DA4AA70A00000C0160E50B3746632C','D79C1F4E0A00000C005E8F58C5A54678','9C99FF5C0A00000C01101F9991BC2D8F','F00808980A00000C018FF0AFE8EAEE58','09139EBCDE6D2990BA6CBB21FADE2BA6','9E83C77E0A00000C00497A1B820EEA34','7E702C07B77693660AE5D914B3EC0F0B','B78CF131DA25C93EFDA2276C5238393C','89A2E7B10A00000C0003ABF8EAFFC6DD','384B522D0A00000C01FC15F25C2556F3','87B79C5A0A00000C001359AD9D8B179D','BFD94D920A00000C01791E673C1D1B69','AFFCDB30027BAE1473EDC8F12C440D12','86A38E0B0A00000C018C44A766852526','DA1EE4480A00000C00A139304BBADC3A','2A7C56DA0A00000C01D3C0F391C31AD8','60C7CACF0A00000C01DFEEAEE523CC54','982F98810A00000C0173B4CF55DED486','FCC810C99F325E48853F78920B6F537E','BA16FA10A0484CC2E6E355BE4B0B12C0','067BE6CF0A00000C009D738325CA59DE','53E6D4BA0A00000C003C14A0BF25563D','06DF2358AFC4CD3AC585497138F0ED95','275E0A800A00000C00FCC8F08751715E','B0318F0B0A00000C0091B770709CC8B2','95033305366EBDD5CD0E8DF035BD430D','803282CF0A00000C01D0AD977073BBA6','F8B699EC0A00000C00CA213F9DA8DE8C','51EA3F000A00000C00BC71FBE0BB5588','081165CB6EAF929ED4B979B0CF6869FA','EAB4FAE30A00000C006A25BB44E520FB','F155909F5D4B9B5356E06C83E23BC723','9CDA58DE0A00000C00272A0208D1D30C','F0E8F9920A0000C7009ACE22E1C0D990','26DB9E870A00000C013BCE7E316C59F8','B6DB31020A00000C00F922CF250103D6','6B7186270A00000C01DFE1506A0E4280','8CBB75F00A00000C01A517E9917E420D','21B2CFE10A00000C001A688495081801','18EDA0240A00000C0193F4D540452C44','1D0C9B6A0A00000C00E48CA0541EB368','A58E42700A00000C004EBFD24A0C4BEE','C3E0A71284BA0D20ABD4D0BCCF74A483','2BDD12CD5E0C00086D9FDEDC728363D4','95D36A850A00000C01064482022E5F60','E6F723C8F8E54E0E3E1E9400F78CD7CA','25CADA560D3E6B6FF1690DC7F91CDE92','82ECB6AC0A00000C00D0AAF7EA2DDF2A','C4A1BAF5A4BEB9C460C10A8C5932459A','F9536E170A00000C01C5D754D58E98C8','A53148FE0A00000C00E28D65096DFC79','13AEFDF4A231E8CF239A726F303F9736','7A38537F0A00000C00D4BBB0F8F073EF','AFCFF1F70A00000C01F6002AC59E0612') AND DELETED=1
2014-02-04 16:01:49.484 THREAD 1 INFO: SELECT ID FROM BINARY_FILE WHERE ID IN ('A95D30A50903C25FE4B441116B09A611','19229941D57A350C264B288A0B5D6A18','7B822AC5110193604DDEE41F9E15A715','309855DB2BCECD3A2B64ECD8407D1B3F','72BCE6D19F346670F66010E49B81D279','56EA09337406D900E93CC01DE846CD3C','60DB336C05CA67CEDFA2CE25109C8145','675084182881E79AAD5D933727F62930','40DF0DF3F4595726E63BF598A6A7ACF8','5FD940A29ED5A539DD73B37296CD8D9F','6BF8674E0E9636291E1E6C18AF8CE64C','F988A90E3307ED83A2B81F45C694519F','AF15BFC4958368DD691816E7F8004CE0','E8343D4C5B21BC4AFFC21EC0CE468B66','26EA53370A96ED06FFECCBE6E475A90A','8D9DB41ECECF7044AE27A8B2A2AD7415','3F84ABC7BC3D97A89D8FFEA685D99220','296C9098BDECB3F08DC96F07C4372C59','BB5FA6BC375CA14E39190B7CEAAC867A','6FB6667220AF74BDAEFAADAF3F0A23ED','ABCCE2DE262F95E42C0704B632E8BD89','13094D2E17AF03A32EFD962DE588081A','7E932127D12EFB09C500F5FF04EC10D8','6142319CFCA349A9087E3EACD400A627','CFBC662FFDF1968C4C8687E695032E49','53F48F0B95D9EEC08CE498ABB302FBEC','0586398F6C2FB3D1B278A8BA042A7547','72880FAE3C357C3D618F8469AAB7E7AD','715A0A4C9ACB32186C6829A6B71520AB','AF13963B0EAEFCC653F0F3757F34EF1E','21055EEF37A292904CD785A2FD79FEAC','5F072B54E9E31C0965353E34764CCC4D','80DDB1459C10AF285F62321C780BC460','03005962955934654049162D7B00B63C','BFEA7D7ACFBCD1EC86D28E28D89DDFD8','28F2B28A99A05F0DAA11895239B75ED9','E2BCBB398AEDFED4B64D777CDA02EF97','CFF498683912BB0CC1A976A39614696B','8CA2B3707E0EE54C84318D1EA889E3EB','53472E2DC6C340404232690A50127101','84F3B3F71876D9C3B39C8550640EF078','D50C6EFB8C91544FAA66C4A276847837','D2E454C1CF659F94ED90B19A16338A5D','16FFCE6E900A7CA9184551E9D26A95C1','2D15222F8F244552E3CC01564BBA2859','05084C193EFBBD67FF98E7603D4BCD5A','2ECB06A77064A71DA775AEFD2715D5F4','E4D17DC55F07B1D3639597E971FFD8F1','12E8A1AEB714DEB0EF2E9943D94016E6','75B1F7BD9437B411978BEC412DC46A0A','A90780DE279B855E3F65FE9DBFD52A24','55CF538FFE8EE4EA75654DA1247FD820','F19D147B367FA137B1582AF14B79D2A6','732AB98A50D4E9978D3865E12EA5AD4F','71F9BDB9DF4858B7E26FC6FD0D8672CA','3461D3C9651EF5970C3AFBFBC942387E','53C9479B5822F3FE5E0958D87A0B9CF5','77255BE3D61F52FE033922C359FCB2DB','0F3D463780F36E8A1F7957594FBC0824','14CF86727CF52E9BC81EB0248A593934','FA549888030D989561EDC3F9339C1F8C','9F4D98BFCB6913CCDA3DD0098E4E6E06') AND DELETED=0 and CONTENT IS NOT NULL
2014-02-04 16:01:49.484 THREAD 1 INFO: *********************************************
2014-02-04 16:01:49.500 THREAD 1 INFO: Following ids are not present in the database.
2014-02-04 16:01:49.500 THREAD 1 INFO: *********************************************
2014-02-04 16:01:49.500 THREAD 1 INFO: Link is broken for [0] target ids :
2014-02-04 16:01:49.500 THREAD 1 INFO: *********************************************
2014-02-04 16:01:49.515 THREAD 1 INFO: Link is broken for [0] physical file ids :
2014-02-04 16:01:49.515 THREAD 1 INFO: *********************************************
2014-02-04 16:01:49.515 THREAD 1 INFO: Database validation passed.
2014-02-04 16:01:49.531 THREAD 1 INFO: Finished.

 

yamc's picture

size of sem5.log : 576 KB

custom policies are for a group of 30 clients.

Rafeeq's picture

Try the following steps:

1) Navigate to the following path:

C:\Program Files (x86) or SEPM installed drive\Symantec\Symantec Endpoint Protection Manager\tomcat\etc\conf.properties.

Open the conf.properties file with Notepad.Before making any changes take the backup of file.

Check for the line scm.agent.root= C\:\\Program Files (x86)\\Symantec\\Symantec Endpoint Protection Manager\\data

Change the location to  scm.agent.root= D\:\\test folder or any other custom location

Run the management server configuration wizard, make sure server data folder path is showing custom location.

Run the database backup & wizard & confirm backup has been placed on custom location or not.

Chetan Savade's picture

Hi,

Take the backup of policies & disaster recovery file.

Give a try to perform an ugprade

If failed I would suggest to go with a fresh install of SEP 12.1 RU4 & perform following steps:

You can perform a disaster recovery without a database backup, but the following points apply in this case:

  • All policies must be re-created, or imported from other backups i.e. exported policy files.
  • Clients will be able to communicate with the SEPM but will re-appear in the console only after their next check-in.
  • Clients will reappear in the default group as they check in, unless you enable automatic creation of client groups on the re-installed SEPM by editing "scm.agent.groupcreation=true" to the conf.properties file. This file is located <drive>Program files or(x86)/Symantec/Symantec Endpoint Protection Manager/tomcat/etc.
  • If you originally had multiple SEPM domains beyond the default domain, you must re-create them using domain IDs from Backup.txt.3

Reference: http://www.symantec.com/docs/TECH160736

Chetan Savade
Sr Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

Tony K.'s picture

I agree with Chetan's assessment here - IMO, the database is nowhere near as important as it is trumped up to be these days. Especially when you are dealing with 250 or less clients - many times you can stand up a new install of the SEPM with the latest version (provided that you have a [recovery-file].zip handy) and get an environment managable again much faster than it takes to pick apart and figure out exactly where it fell apart at.

 

However, with policy imports and exports - I generally do not like keeping AV and FW and the A&DC policies that were built in 11.x and migrated on up. If they were, you can import them in and reference them for information, but I tend to stay away from their defaults because of significant secuirty issues and/or functionality issues that are presented when running or that SEP 12.1.x has a much different way it works vs. 11. When you migrate from 11.x to 12.1.x, policies are migrated (to the best of ability), and anything that is new is sorta...just filled in with default. However, the GIGO pricipal applies - GIGO meaning: Garbage In, Garbage Out.

 

Moral of the story, if you elect to follow the disaster recovery w/o DB steps - export your policies, keep them handy (if something goes completely crazy, you can enable them) but use them as a reference if you are wanting to improve your overall security (as I would assume for the whole intention here is to upgrade, which theoretically should help improve overall security). Just food for thought.