cancel
Showing results for 
Search instead for 
Did you mean: 

credentials error on epo server

i have a probelm on epo server from yesterday credentials error on epo server.

here are more than 7 gb space avliabe on epo server but orion log show space issue

see orion log

2015-01-17 14:03:36,552 ERROR [mfsSmiley Tongueool-2-thread-8] agentmgmt.AgentHandlerStatusTask  - Error during agent handler status task

java.sql.SQLException: Could not allocate space for object 'dbo.EPOServerEvents' in database 'ePO4_WINDOWS-J5HAO8E' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

see full orion log on following link

https://onedrive.live.com/?cid=4B014DEE7898B390&id=4B014DEE7898B390%217192&authkey=%21ADBJDKtS-FXqFS...

10 Replies

Re: credentials error on epo server

Morning,

You need to create free space in your database. Follow this document for that

https://kc.mcafee.com/corporate/index?page=content&id=KB68961

Best regards

Jose

Re: credentials error on epo server

i had already followed this doc. but no old event found.....

Re: credentials error on epo server

Which vàlues have you put in here (DELETE FROM ePOevents WHERE DetectedUTC < 'yyyy-mm-dd 00:00:00.000' )?

I canot believe you do not have any events....

Best regards,

Jose


avinash34
Level 12
Report Inappropriate Content
Message 5 of 11

Re: credentials error on epo server

Hello Sriniraula,

try freeing up the space depending on the events

Follow the steps below to reduce the size of database

1.Login to SQL Management Studio locate the database of the McAfee ePO the name will be like ePO4_<servername>

 

2.Right click on the database and select ‘New Query’ and paste the following and execute it

select top  10 E.ThreatEventid, EF.Description , Count(E.ThreatEventID) from epoevents E inner join EPOEventfilterDesc EF ON E.ThreateventID = EF.EventID Where EF.Language = '0409'

group by E.ThreatEventid, EF.Description order by Count(e.ThreatEventID) Desc

This query gives the top  10 with the respective event ID listed.

3. After executing this query see the event id which takes more space and execute this query to clear the event id logs:

 

SET rowcount 10000

DELETE FROM EPOEvents

WHERE ThreatEventid = '1092'

WHILE @@rowcount > 0

BEGIN

   DELETE FROM EPOEvents

   WHERE ThreatEventid = '1092'

END

SET rowcount 0

GO

Note : The number 1092 is an example and it can be any event id depending upon your database logs

Thanks,
Avinash

Re: credentials error on epo server

i had already check this query but no event found.

SET rowcount 10000

DELETE FROM epoEvents

WHERE detectedutc < '2014-11-21'

WHILE @@rowcount > 0

BEGIN

DELETE FROM epoEvents

WHERE detectedutc < '2014-11-21'

END

SET rowcount 0

GO

Re: credentials error on epo server

Can you make sure you are running the query under your EPO SQL instance data base?

Can you try to put the date like June 2014 to see if that find any events?

A screeshot when running the script on the DDBB would be usefull

Best regards,

Jose

Re: credentials error on epo server

i had checked here are only last 7 days events on this server.

nteferi
Level 9
Report Inappropriate Content
Message 9 of 11

Re: credentials error on epo server

If you are unable to log on to the ePO 4.x console (issue: ePO database limit reached)!

 

This is the KB Technical Articles ID:  KB53607

or

 

if the issue is with SQL2008 R2 Express edition database size is
limited to 10GB.

Solution could be :

- split the database

- drop/move some data

  Also identified the table occupying all that data and search for index
records

 

If you shrink the mdf file, keep in mind to rebuild all your indexes
after the shrink operation.

 

and remember dropping PK etc is not supported with McAfee , have a full back
up before dropping anything in SQL

  

Hopefully that will help .

Re: credentials error on epo server

its a 3.2 GB size on sql epress 2008r2

Main Data File  file 3.2 gb

Log Data File 1.6 gb