07-15-2015 07:39 AM
When I run Provisioning in report mode I get this:
---x---
Mailboxes on Exchange Server [SVR-EML-06] that have entries in the Enterprise Vault database but which are not in any provisioning group:
/o=pharmamar/ou=Exchange Administrative Group (FYDIBOHF23SPDLT)/cn=Recipients/cn=mosibi2013 (state = enabled)
/o=pharmamar/ou=Exchange Administrative Group (FYDIBOHF23SPDLT)/cn=Recipients/cn=emenos (state = enabled)
/o=pharmamar/ou=Exchange Administrative Group (FYDIBOHF23SPDLT)/cn=Recipients/cn=sbenitez (state = enabled)
---x---
These users doesn't exist anymore. Their AD account was deleted as well as their Exchange mailboxese.
I have opened the MailxBoxEntry table of the EnterpriseVaultDirectory dabase, but they are not there. What can I do?
I'm running EV 9.0.5.
Thanks in advanced and best regards.
//Juan A.
Solved! Go to Solution.
07-27-2015 01:16 AM
As Andrew and Tony have stated it will be because the entries are in the ExchangeMailboxEntry table in SQL and will need to be removed to stop these errors if the AD Object and Exchange Mailboxes have been removed from the environment.
Use something along the lines of:-
USE EnterpriseVaultDirectory
DELETE FROM ExchangeMailboxEntry
WHERE ExchangeMbxType = '1'
AND PolicyTargetGroupEntryId is NULL
The above will remove any entries from the ExchangeMailboxEntry table that is a normal mailbox (not system or journal) that does not belong to a Provisioning Group.
****** DISCLAIMER ******
TEST THIS IN A NON-PRODUCTION ENVIRONMENT TO ENSURE YOU ARE HAPPY WITH THE RESULTS BEFORE USING IT IN A PRODUCTION ENVIRONMENT
As always it is strongly recommended to ensure you have a full working backup of your SQL DBs before carrying out ANY alterations to the DBs at all to ensure you have a roll back plan.
07-15-2015 09:47 AM
here you go:
also here:
https://www-secure.symantec.com/connect/forums/mailboxes-have-entries-ev-db-which-are-not-any-provisioning-group-0
07-16-2015 12:25 AM
Hi AndrewB,
Reading your first article, the only thing I can do is manually remove these entries from SQL. I have done this some other times. But when I open the MailxBoxEntry table I can't find those users there. There are no entries for them. That's my problem. I don't know if I should look at anothe table.
Your second link (https://www-secure.symantec.com/connect/forums/not...) doesn't work for me. Could you check it, please?
Thanks a lot.
//Juan A.
07-16-2015 08:14 AM
sorry not sure what happened when i copied and pasted the link before. trying again... https://www-secure.symantec.com/connect/forums/mailboxes-have-entries-ev-db-which-are-not-any-provisioning-group-0
07-17-2015 12:19 AM
Thanks AndrewB. The link is working now. I'll take a look.
Regards.
07-17-2015 12:32 AM
Hello again,
What I have read is no exactly the same. They're talking about deleting a user AD account an create a new account for the same user. My problema is that EV says
"Mailboxes on Exchange Server [SVR-EML-06] that have entries in the Enterprise Vault database but which are not in any provisioning group".
These AD accounts and mailboxes where deleted. They don't exist anymore. But EV says they are. And they don's exist even in the MailxBoxEntry table.
Why EV knows about these users is they were deleted from everywhere?
07-26-2015 01:36 PM
Are you sure they are not in the ExchangeMailboxEntry table? I would double check.
07-27-2015 01:16 AM
As Andrew and Tony have stated it will be because the entries are in the ExchangeMailboxEntry table in SQL and will need to be removed to stop these errors if the AD Object and Exchange Mailboxes have been removed from the environment.
Use something along the lines of:-
USE EnterpriseVaultDirectory
DELETE FROM ExchangeMailboxEntry
WHERE ExchangeMbxType = '1'
AND PolicyTargetGroupEntryId is NULL
The above will remove any entries from the ExchangeMailboxEntry table that is a normal mailbox (not system or journal) that does not belong to a Provisioning Group.
****** DISCLAIMER ******
TEST THIS IN A NON-PRODUCTION ENVIRONMENT TO ENSURE YOU ARE HAPPY WITH THE RESULTS BEFORE USING IT IN A PRODUCTION ENVIRONMENT
As always it is strongly recommended to ensure you have a full working backup of your SQL DBs before carrying out ANY alterations to the DBs at all to ensure you have a roll back plan.
07-27-2015 04:00 AM
I have checked the ExchangeMailboxEntry table not twice, but several times. This is not new. I have this "problem" since more than a year ago. So, I check the table from time to time. This is why I found this so weird.
Anyway, I'll check again and I'll try with the query you sent.
Thanks!
07-27-2015 08:08 AM
I found them!!!
They were in the ExchangeMailboxEntry but with a MbxAlias different from the one in the Exchange Provisioning Task in Report mode log.
I could identify them using Ben's SQL query.
Thanks a lot to all of you.
Kind regards.
//Juan A.