Video Screencast Help

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB

Created: 27 Sep 2012 • Updated: 02 Oct 2012 | 23 comments
This issue has been solved. See solution.

 

I'm trying to run the ShrinkEmbeddedDB.bat tool to shrink our SEPM 12.1.1000.157 database as it's grown to 22GB in size. The tool fails though with the following details:
 
*********
 
 
 
C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Tools>Shrin
kEmbeddedDB.bat
Exception in thread "main" java.lang.NoClassDefFoundError: com/sygate/scm/server
/util/ScmFormatter
Caused by: java.lang.ClassNotFoundException: com.sygate.scm.server.util.ScmForma
tter
        at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB.  Program
 will exit.
**********
 
Our Antivirus definitions stopped updating on the 23rd August which prompted me to try shrinking the DB. I was on holiday and my collegues tried to update the definitions with no luck. Wanted to upgrade to the latest MU1 version but am waiting on our head office as our serial number reports that we have exceeded the number of downloads we are allowed.
 
Many thanks for any assistance
 
Patrick

Comments 23 CommentsJump to latest comment

Ashish-Sharma's picture

Hello,

Check this Thread: https://www-secure.symantec.com/connect/forums/sem5-datbase-file-too-big#comment-7750721

Try the Following steps to Create new transaction log(sem5.log):

  1. Verify if there is any running instance of dbsrv11 in the Task Manager > Processes tab. If yes, then end that process;
  2. Stop the Embedded database service;
  3. Go to "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\" and renamesem5.log to sem5.log.old for SEP12.1. ( Please use "Program Files (x86)" instead of "Program Files" if it is a 64 bit machine;
  4. In the Command Prompt type: "CD C:\Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32\" and press Enter this will change directories to the folder containing dbsrv11.exe for SEP 12.1;
  5. To force the recreation of sem5.log. Type: dbsrv11 -f "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db" and press Enter for SEP 12.1;
  6. Click Start, click on Run and Type “services.msc” then click OK and start the SymantecEmbedded Database Service;
  7. Start the Symantec Endpoint Protection Manager service;
  8. If it stays started then go ahead and log into the Symantec Endpoint Protection Manager and everything should now be working properly.

OR

Simply enable both options to Truncate the database transaction logs and Rebuild Indexes from the SEPM Database Maintenance Tasks to keep Sem5 under control:

  1. Log in to the Sep Manager.
  2. Click Admin and select Servers.
  3. Select the localhost under Servers.
  4. Under Tasks, Select Edit Database Properties.
  5. In the General tab under Database Maintenance Tasks.
  6. Select the checkboxes next to Truncate the database transaction logs and Rebuild Indexes.
  7. Click OK to apply the changes.

(Source: TECH166658 and https://www-secure.symantec.com/connect/articles/symantec-endpoint-protection-manager-121-database-using-high-amount-hard-drive-space )

To reduce the size of Sem5 right away, simply click on Truncate Transaction Log Now and Rebuild Indexes Now from Admin/Servers/Tasks.

Thanks In Advance

Ashish Sharma

 

 

Za.Helpdesk's picture

The sem5.log file is not the problem, it's only 5mb in size, the sem5.db databse is 22Gb, hence the first half of your post doesn't apply. In the second section to enable the Truncate and Rebuild options, these are already enabled.

Manually running Rebuild Indexes now. Will see how it goes.

Chetan Savade's picture

Hi,

There are some other ways as well to reduce the databse size.

Best Practices for configuring the number of content revisions to keep in Symantec Endpoint Protection Manager:

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

Disk Space Management procedures for the Symantec Endpoint Protection Manager

http://www.symantec.com/docs/TECH96214

Changing the log settings to reduce the size of the database.

http://www.symantec.com/docs/TECH105238

Managing log data in the Symantec Endpoint Protection Manager (SEPM)

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

I hope it helps

 

 

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.<

Za.Helpdesk's picture

Chetan, due to offsite users who only connect once or twice a month (and have limited 3G/Mobile Broadband contracts) we are keeping 25 content revisions. Any less and the users monthly limit for their mobile broadband contract is exceeded with one full definition update. Our company mobile broadband bill jumped by $2,700 in one month as all mobile users were downloading the full definitions every time they connected.

Re - Disk Space Management procedures for the Symantec Endpoint Protection Manager. This document is for the older version of SEPM, these settings are now under Admin > Servers > localhost > Log Settings and not Local Site > Database.

Re - Managing log data in the Symantec Endpoint Protection Manager (SEPM). This document is for SEPM 11.0

 

Za.Helpdesk's picture

Rafeeq, we hav around 300 clients.

 

P.S. This sizing tool spreadsheet is for SEPM 11 and seems to be 4 years old.

Chetan Savade's picture

Hi,

Could you please confirm free space available on the SEPM installed drive.

To run this tool successfully you need sufficient disk space.

I hope you would have gone through following download.

https://www-secure.symantec.com/connect/downloads/...

You can PM Elisha as well.

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.<

Za.Helpdesk's picture

Chetan, we have 52Gb free on this server (Server 2003 R2 X64 enterprise SP2)

Yes, I've gone through that thread and nowhere does it make any mention of Java errors, also, none of the troubleshooting tips given have helped my issue.

Ashish-Sharma's picture

HI,

May Shrink embedded tool may be corrupt you can download new tool

Shrink the Symantec Endpoint Protection Manager 12.1 embedded database

https://www-secure.symantec.com/connect/downloads/shrink-symantec-endpoint-protection-manager-121-embedded-database

Thanks In Advance

Ashish Sharma

 

 

Za.Helpdesk's picture

That's the same version I've already downloaded, however, in the spirit of covering all the bases I redownloaded the file and extracted it over the current copy. I still get the same error when running it though.

 

Ashish-Sharma's picture

HI,

Currently how many space available in SEPM server ?

Thanks In Advance

Ashish Sharma

 

 

Chetan Savade's picture

Hi,

Thanks for an update.

Apart from this error, are you able to login to the SEPM console successfully? Embedded database and Manager service is up & running?

This error we have seen while running management server configuration wizard or in some cases installed jave might have a problem.

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.<

Za.Helpdesk's picture

Yes, we can login to the SEPM successfully and apart from the virus defs not updating everything is working correctly. I wanted to shrink the DB and upgrade to the lates MU1 before trying to troubleshoot the def updates.

 

I actually just installed the latest version of Java before running the Shrink tool.

Ashish-Sharma's picture

HI,

Which version are you installed ?

Java 7 not supporting SEPM.

SEPM support  Java 1.6 Update 31 instead

 

Thanks In Advance

Ashish Sharma

 

 

Za.Helpdesk's picture

Yes, that's the version we are on. (build 1.6.0_31-b05). It shows in Add Remove programs though that it's Java 6 Update 31 (64-bit). Will this make a difference?

Chetan Savade's picture

Hi,

Follow these steps and let me know.

Stop the Symantec Endpoint Protection Manager services

Kill all instances of javaw in task manager .

Follow the steps below to fix the java files.

  1. Browse to <%SEPM installation folder%>\tomcat\webapps\ROOT\clientpkg
  2. Install Jre using the Jre installer present in the folder .   eg. jre-6u26-windows-i586.exe
  3. Navigate to %program files%\Java\jre6
  4. Copy the bin and lib folder
  5. Paste it in the folder  <%SEPM installation folder%>\jre
  6. Overwrite all files when the prompt appears
  7. Run Management Configuration Wizard once the files have been copied

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.<

SOLUTION
Za.Helpdesk's picture

Ran through these steps, but I think you missed a few, between 6 and 7 I started the SEPM services again and then ran the MC wizard. I assume you wanted me to recover the installation as you didn't specify what needed to be done in the wizard.

That has fixed the problem, the tools is now running. Will post back once it is finished

Ashish-Sharma's picture

Most of the data in the databse usually comes from one of three places:

  1. Client pacakges
  2. AV defs
  3. Log files

All of these can be controlled.  Try the follwoing:

  • Remove old client packages you don't need any more.  This can be done via SEPM console --> Admin tab --> Install Packages tab.
  • Reduce the number of revisoins of content (AV defs) SEPM stores.  This can be done via SEPM console --> Admin tab --> Servers tab under Site Properties --> LiveUpdate tab.
  • Reduce the amount of log files SEPM stores.  This can be done via SEPM console --> Admin tab --> Servers tab under Database Properties --> Log Settings tab.

Artical :

Symantec Endpoint Protection Manager 12.1 database using a high amount of Hard drive space

https://www-secure.symantec.com/connect/articles/symantec-endpoint-protection-manager-121-database-using-high-amount-hard-drive-space

Thanks In Advance

Ashish Sharma

 

 

Za.Helpdesk's picture

1. We only have the default 3 client packages, i.e.SEP for WIN32BIT, SEP for WIN64BIT and SEP for Mac.

2. Please see earlier post, we need a large number of definitions to update our mobile users who only connect a few times a month.

3. I've already reduced the Log files max age from 60 to 45. This only freed up about 4mb.

Ashish-Sharma's picture

Hi,

Try to Repaire SEPM server for ADD/ Remove

Or you can raised support ticket

How to create a new case in MySupport

http://www.symantec.com/business/support/index?page=content&id=TECH58873

Phone numbers to contact Tech Support:-

Regional Support Telephone Numbers:

United States: 800-342-0652 (407-357-7600 from outside the United States)
Australia: 1300 365510 (+61 2 8220 7111 from outside Australia)
United Kingdom: +44 (0) 870 606 6000
 

 

Thanks In Advance

Ashish Sharma