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

Za.Helpdesk

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

Discussion Filed Under:

Security, Endpoint Protection (AntiVirus) - 12.x, Endpoint Protection (AntiVirus), Error messages, Recovering, Troubleshooting

Comments RSS Feed

Comments 23 Comments • Jump to latest comment

Ashish-Sharma

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:27 Sep 2012 : Link

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):

Verify if there is any running instance of dbsrv11 in the Task Manager > Processes tab. If yes, then end that process;
Stop the Embedded database service;
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;
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;
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;
Click Start, click on Run and Type “services.msc” then click OK and start the SymantecEmbedded Database Service;
Start the Symantec Endpoint Protection Manager service;
If it stays started then go ahead and log into the Symantec Endpoint Protection Manager and everything should now be working properly.

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

Log in to the Sep Manager.
Click Admin and select Servers.
Select the localhost under Servers.
Under Tasks, Select Edit Database Properties.
In the General tab under Database Maintenance Tasks.
Select the checkboxes next to Truncate the database transaction logs and Rebuild Indexes.
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

SEPM Knowledgebase Documents

Za.Helpdesk

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:27 Sep 2012 : Link

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.

Za.Helpdesk

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

Ashish, following your instructions made no difference to the size of the DB file.

Chetan Savade Symantec Employee Technical Support Accredited

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:27 Sep 2012 : Link

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

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

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

Rafeeq

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:27 Sep 2012 : Link

whats the total number of clients you have in your network?

Symantec Endpoint Protection Database Sizing Tool.xls

Please don't forget to mark your thread solved with whatever answer helped you : ) Rafeeq

Za.Helpdesk

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

Rafeeq, we hav around 300 clients.

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

Za.Helpdesk

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

Is anyone able to help me with the original error with the ShrinkEmbeddedDB.bat tool?

Chetan Savade Symantec Employee Technical Support Accredited

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

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

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

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

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

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

SEPM Knowledgebase Documents

Za.Helpdesk

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

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

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

HI,

Currently how many space available in SEPM server ?

Thanks In Advance

Ashish Sharma

SEPM Knowledgebase Documents

Za.Helpdesk

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

52Gb free. However, the error is given immediately as soon as the command is run.

Chetan Savade Symantec Employee Technical Support Accredited

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

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

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

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

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

HI,

Which version are you installed ?

Java 7 not supporting SEPM.

SEPM support Java 1.6 Update 31 instead

Thanks In Advance

Ashish Sharma

SEPM Knowledgebase Documents

Za.Helpdesk

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

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 Symantec Employee Technical Support Accredited

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

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.

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

Chetan Savade
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

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

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

ShrinkEmbeddedDB.bat fails with Could not find the main class: com.sygate.scm.tools.db.ShrinkEmbededDB - Comment:28 Sep 2012 : Link

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

Client pacakges
AV defs
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

SEPM Knowledgebase Documents