Video Screencast Help

SEPM SERVICE AUTO WHILE START CURRENT RUNNING SEPM MR 7

Created: 08 Nov 2013 • Updated: 10 Nov 2013 | 6 comments

SEPM SERVICE AUTO WHILE START CURRENT RUNNING SEPM MR 7

Operating Systems:

Comments 6 CommentsJump to latest comment

HAROONKHANZ's picture

YES SIR SEPM SERVICE STOP AUTO

DB SIZE IS TOO LARGE

DUBLOAD ERROR

SEPM CONFIGURATION NOT RUNNING

logs are attached too

 

 

AttachmentSize
lg.zip 7.66 KB
HAROONKHANZ's picture

while trying to repair db...this error below.,..

 

Connection terminated abnormally; client socket shut downDisconnected TCPIP client's AppInfo: HOST=khidpl2av*** ERROR *** Assertion failed: 201501 (9.0.2.3654)---

---

Adaptive Server Anywhere Network Server Version 9.0.2.3654Copyright © 1989-2007 Sybase, Inc.
Portions Copyright © 2002-2007, iAnywhere Solutions, Inc.
All rights reserved. All unpublished rights reserved.
 
This software contains confidential and trade secret information of
iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and documentation
by the U.S. Government is subject to restrictions set forth in a license
agreement between the Government and iAnywhere Solutions, Inc. or
other written agreement specifying the Government's rights to use the
software and any applicable FAR provisions, for example, FAR 52.227-19.
 
iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA 94568, USA
2 logical processor(s) on 1 physical processor(s) detected.
Per-processor licensing model. The server is limited to use 16 processor(s).
This server is licensed to:
    Symantec
    Symantec
Running on Windows 2003 Build 3790 Service Pack 2
521472K of memory used for caching
Minimum cache size: 2048K, maximum cache size: 521472K
Using a maximum page size of 8192 bytes
Database server started at Fri Nov 08 2013 17:18
Trying to start SharedMemory link ...    SharedMemory link started successfullyTrying to start NamedPipes link ...    NamedPipes link started successfullyTrying to start TCPIP link ...Starting on port 2638
    TCPIP link started successfullyTrying to start SPX link ...SPX communication link not startedNow accepting requests
Starting database "sem5" (d:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db) at Fri Nov 08 2013 17:18
Performance warning: Database file "d:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db" consists of 3819 disk fragments
Transaction log: sem5.log
Starting checkpoint of "sem5" (sem5.db) at Fri Nov 08 2013 17:18
Finished checkpoint of "sem5" (sem5.db) at Fri Nov 08 2013 17:18
Database "sem5" (sem5.db) started at Fri Nov 08 2013 17:18
Starting database "a_dbinit" (d:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.dbR) at Fri Nov 08 2013 17:18
Performance warning: Database file "d:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.dbR" consists of 3 disk fragments
Transaction log: d:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.logR
Starting checkpoint of "a_dbinit" (sem5.dbR) at Fri Nov 08 2013 17:18
Finished checkpoint of "a_dbinit" (sem5.dbR) at Fri Nov 08 2013 17:18
Database "a_dbinit" (sem5.dbR) started at Fri Nov 08 2013 17:18
Starting checkpoint of "a_dbinit" (sem5.dbR) at Fri Nov 08 2013 17:18
Finished checkpoint of "a_dbinit" (sem5.dbR) at Fri Nov 08 2013 17:18
Database "a_dbinit" (sem5.dbR) stopped at Fri Nov 08 2013 17:18
Starting database "replacement" (d:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.dbR) at Fri Nov 08 2013 17:18
Performance warning: Database file "d:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.dbR" consists of 18 disk fragments
Transaction log: d:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.logR
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Database "replacement" (sem5.dbR) started at Fri Nov 08 2013 17:18
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:18
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Starting checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
Finished checkpoint of "replacement" (sem5.dbR) at Fri Nov 08 2013 17:20
*** ERROR *** Assertion failed: 201501 (9.0.2.3654)
Page for requested record not a table page or record not present on page

Attempting to save dump file at 'C:\DOCUME~1\HAROON~1.AHM\LOCALS~1\Temp\1\sa_dump.dmp'
Dump file saved
Connection terminated abnormallyDisconnected SharedMemory client's AppInfo: HOST=KHIDPL2AV;OS=Windows 2003 Build 3790 Service Pack 2;PID=0xbcc;THREAD=0x9a0;EXE=D:\Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32\dbunload.exe;VERSION=9.0.2.3654;API=DBLIB;TIMEZONEADConnection terminated abnormallyDisconnected SharedMemory client's AppInfo: HOST=KHIDPL2AV;OS=Windows 2003 Build 3790 Service Pack 2;PID=0xbcc;THREAD=0x9a0;EXE=D:\Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32\dbunload.exe;VERSION=9.0.2.3654;API=DBLIB;TIMEZONEAD

AttachmentSize
lg.zip 7.66 KB
HAROONKHANZ's picture

i have no backup

thats why need a hard code command to repair and compact this corrupt db

 

file size= 4.24GB

 

THX

pete_4u2002's picture

does repair of SEPM fix the problem?

if not you have to reinstall SEPM with DB ( since you dont have DB backup). clients will stil connect however the groups and policies have to be created again.

.Brian's picture

Have any changes been made on the SEPM recently?

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.