CSA MC DATABASE SHRINK ERROR

Answered Question
Oct 7th, 2008
User Badges:

HI ,

I am facing a problem frequently in CSA MC when I Shrink the database in the Database maintanence .I am getting error

Error: Shrink operation failed for database csamc52. See csamclog.txt for details .When I look in to CSAMC LOG The error is

SQL: shrinking db

[2008-10-08 02:26:11.643] [PID=4712] [Csamcmanager52]: DoFlushIfNeeded: Failed to sync events to database: 0x80004005

[2008-10-08 02:27:43.782] [PID=4712] [Csamcmanager52]: DoFlushIfNeeded: Failed to sync events to database: 0x80004005


Can any one revert on this ?

Correct Answer by diicalutu about 8 years 7 months ago

I think I've seen this a while back.

The issue is likely caused by a corrupt full-text catalog. Disabling and re-enabling event full-text indexing via Maintenance-Database Maintenance should do the trick.


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Anonymous (not verified) Mon, 10/13/2008 - 09:19
User Badges:

You may try using the following steps:


Open a CMD command window on the CSAMC50 server, and type :


- net stop csagent ( stop CSA agent )


- net stop crmdmgtd ( stop CiscoWorks )


- osql -E

Use csamc50

go

backup log csamc50 with no_log

go

dbcc shrinkfile (csamc50_log)

go


- net start crmdmgtd ( start CiscoWorks )


- net start csagent ( Start CSA agent )


srinagesh108 Tue, 10/14/2008 - 01:30
User Badges:

Thanks for replying my CSA MC 52 is running on Windows 2003 Server.

tsteger1 Tue, 10/14/2008 - 16:01
User Badges:
  • Red, 2250 points or more

You didn't mention which SQL version you have or if it's local or remote.


Do you have SQL Studio Manager installed? It can also backup and shrink the db.


If not, you could try rrjoas45 suggestion but replace csamc50 with csamc52.


Back it up first though...


Tom

srinagesh108 Tue, 10/14/2008 - 21:34
User Badges:

Thanks Tom for your posting


Q)You didn't mention which SQL version you have or if it's local or remote.


A)MS SQL Server 2000 ,Its Local Database.

B)SQL Studio manager is not installed

C)We are running CSAMC52


Should mssqladhelpder service should also get started,pls suggest.




srinagesh108 Thu, 10/23/2008 - 01:43
User Badges:

Tom ,


Still the error is repeating once I shrink the database .I should not install the SQL studio manager as I am a thrid party vendor.

Can you please suggest

tsteger1 Thu, 10/23/2008 - 13:46
User Badges:
  • Red, 2250 points or more

Sorry, you've exhausted my vast (limited) SQL troubleshooting skills.


I suggest opening a TAC case or posting in a SQL forum.


Good luck...


Tom

srinagesh108 Wed, 11/12/2008 - 21:48
User Badges:

we 've disabled the "event full text search" option and it worked for us,in database maintanence options

Correct Answer
diicalutu Thu, 12/11/2008 - 11:54
User Badges:

I think I've seen this a while back.

The issue is likely caused by a corrupt full-text catalog. Disabling and re-enabling event full-text indexing via Maintenance-Database Maintenance should do the trick.


f.cordero Thu, 02/26/2009 - 09:29
User Badges:

Hello!

Which commands do i use on CSA 5.0? i have search for osql tool on my this version but it is not present, i am running VMS 2.


Regards

Actions

This Discussion