Recovery

[Rob_dos_Ramos]

HI All

Busy trying to perform a recover on the EV server and when I get to configuring EV it states that the SQL server was found but this computer was not listed.

Repair was attempted but was not successful.

The thing is I chck the SQL directory database and the names in the computerentry table are the same.

Any ideas?

Regards,

Rob

[JesusWept3]

Any chance of getting a DTrace of EVRunDLL? And you're absolutely sure both the CNAME and Fqdn of the server match?

[Rob_dos_Ramos]

164 14:08:22.010  [3188] (EVRunDll) <2320> EV:M CAUIConfWizSQLServerPage::DoSQLInitialize - IsSQLServerOnComputer completed (1), computer: sql_testbox1, hrx: Success
165 14:08:22.010  [3188] (EVRunDll) <2320> EV:M CBaseDirectoryServiceWrapper::GetInterface - RegKey UseLocalDirectory [False]
167 14:08:22.010  [3188] (EVRunDll) <2320> EV:M CBaseDirectoryServiceWrapper::CreateDirectoryService() - Entry [m_nNumTries = 3]
168 14:08:22.010  [3188] (EVRunDll) <2320> EV:L CBaseDirectoryServiceWrapper::CreateDirectoryService() - Will try to connect to EV Directory Service on ODMEV01
169 14:08:22.057  [3188] (EVRunDll) <2320> EV:M CAUIConfWizSQLServerPage::DoSQLInitialize: bExists: 1
170 14:08:22.057  [3188] (EVRunDll) <2320> EV:M CAUIConfWizSQLServerPage::DoSQLInitialize: Directory database already exists
171 14:08:22.057  [3188] (EVRunDll) <2320> EV:M CAUIConfWizSQLServerPage::DoSQLInitialize: Repairing Directory database on SQL Server 'sql_testbox1'...
172 14:08:22.057  [3188] (EVRunDll) <2320> EV:M GetComputer - enter
173 14:08:22.057  [3188] (EVRunDll) <2320> EV:M GetComputer - [ODMEV01]
174 14:08:22.057  [3188] (EVRunDll) <2320> EV:M CAviProgDlgLauncherThrd::DestroyWindow() - Enter.
175 14:08:22.057  [3188] (EVRunDll) <2320> EV:M CAviProgDlgLauncherThrd::DestroyWindow() - trying to terminate the thread.
176 14:08:22.057  [3188] (EVRunDll) <2320> EV:M CAviProgDlgLauncherThrd::DestroyWindow() - Exit.
177 14:08:22.057  [3188] (EVRunDll) <2320> EV:M GetComputer - enter
178 14:08:22.057  [3188] (EVRunDll) <2320> EV:M GetComputer - [ODMEV01]
179 14:08:22.057  [3188] (EVRunDll) <2320> EV:M Entering function RepairThisComputerIfOrphanedComputerEntryInDirectory()
180 14:08:22.057  [3188] (EVRunDll) <2320> EV:M Creating a computer object...
181 14:08:22.057  [3188] (EVRunDll) <2320> EV:M GetComputer - enter
182 14:08:22.057  [3188] (EVRunDll) <2320> EV:M GetComputer - [ODMEV01]
183 14:08:22.057  [3188] (EVRunDll) <2320> EV:M CBaseDirectoryServiceWrapper::GetInterface - RegKey UseLocalDirectory [False]
185 14:08:22.057  [3188] (EVRunDll) <2320> EV:M CBaseDirectoryServiceWrapper::CreateDirectoryService() - Entry [m_nNumTries = 3]
186 14:08:22.057  [3188] (EVRunDll) <2320> EV:L CBaseDirectoryServiceWrapper::CreateDirectoryService() - Will try to connect to EV Directory Service on ODMEV01
187 14:08:22.057  [3188] (EVRunDll) <3696> EV:M CAviProgDlgLauncherThrd::~CAviProgDlgLauncherThrd() - Final cleanup.
188 14:08:22.057  [3188] (EVRunDll) <3696> EV:M CAviProgDlgLauncherThrd::ExitInstance() - thread terminated successfully.
189 14:08:22.088  [3188] (EVRunDll) <2320> EV:M CBaseDirectoryServiceWrapper::GetInterface - RegKey UseLocalDirectory [False]
191 14:08:22.088  [3188] (EVRunDll) <2320> EV:M CBaseDirectoryServiceWrapper::CreateDirectoryService() - Entry [m_nNumTries = 3]
192 14:08:22.088  [3188] (EVRunDll) <2320> EV:L CBaseDirectoryServiceWrapper::CreateDirectoryService() - Will try to connect to EV Directory Service on ODMEV01
193 14:08:22.134  [1668] (DirectoryService) <3724> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EnterpriseVaultDirectory' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1390,1392,1407,1425}] built Nov  2 19:40:47 2009): |Description:  |Could not find stored procedure 'UpdateVSAAccountDetails'.| | |SQL Command: |  UpdateVSAAccountDetails| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |
194 14:08:22.134  [3188] (EVRunDll) <2320> EV:M HRXEX fn trace :|Source     : .\DirectoryServiceWrapper.cpp (CEnumDirectoryServiceWrapper::CheckDirectorySchemaVersionPublic) [lines {922,927}] built Nov  2 19:42:12 2009|Description: Call error 0x80040e14
195 14:08:22.134  [3188] (EVRunDll) <2320> EV:M HRXEX fn trace :|Source     : .\DirectoryServiceWrapper.cpp (CBaseDirectoryServiceWrapper::GetInterface) [lines {656,696,722,727,730}] built Nov  2 19:42:12 2009|Description: Call error 0x80040e14
196 14:08:22.134  [3188] (EVRunDll) <2320> EV:M HRXEX fn trace :|Source     : .\DirectoryServiceWrapper.cpp (CBaseDirectoryServiceWrapper::Invoke) [lines {401,407}] built Nov  2 19:42:12 2009|Description: Call error 0x80040e14
197 14:08:22.134  [3188] (EVRunDll) <2320> EV:M HRXEX fn trace :|Source     : .\DirectoryServiceWrapper.cpp (CEnumDirectoryServiceWrapper::Invoke) [lines {805,823}] built Nov  2 19:42:12 2009|Description: Call error 0x80040e14
199 14:08:22.134  [3188] (EVRunDll) <2320> EV:M Finished creating a computer object with status: An unspecified SQL error has occurred. See the Enterprise Vault Event log for more details.
200 14:08:22.134  [3188] (EVRunDll) <2320> EV:M CAUIConfWizSQLServerPage::DoSQLInitialize: RepairThisComputerIfOrphanedComputerEntryInDirectory completed, hrx: Success
201 14:08:22.134  [3188] (EVRunDll) <2320> EV:M GetComputer - enter
202 14:08:22.134  [3188] (EVRunDll) <2320> EV:M GetComputer - [ODMEV01]
203 14:08:22.134  [3188] (EVRunDll) <2320> EV:M CAUIConfWizSQLServerPage::DoSQLInitialize: RepairThisComputerIfOrphanedComputerEntryInDirectory dir db exists, but computer not found Computer=[ODMEV01]
204 14:08:22.134  [3188] (EVRunDll) <2320> EV:M GetComputer - enter
205 14:08:22.134  [3188] (EVRunDll) <2320> EV:M GetComputer - [ODMEV01]
206 14:08:23.213  [3188] (EVRunDll) <2320> EV:M CAUIConfWizSQLServerPage::DoSQLInitialize() Wizard updated, SQLServer: sql_testbox1, DBPath: , LogPath:
207 14:08:23.213  [3188] (EVRunDll) <2320> EV:M GetComputer - enter
208 14:08:23.213  [3188] (EVRunDll) <2320> EV:M GetComputer - [ODMEV01]
209 14:08:23.213  [3188] (EVRunDll) <2320> EV:M CBaseDirectoryServiceWrapper::GetInterface - RegKey UseLocalDirectory [False]
211 14:08:23.213  [3188] (EVRunDll) <2320> EV:M CBaseDirectoryServiceWrapper::CreateDirectoryService() - Entry [m_nNumTries = 3]
212 14:08:23.213  [3188] (EVRunDll) <2320> EV:L CBaseDirectoryServiceWrapper::CreateDirectoryService() - Will try to connect to EV Directory Service on ODMEV01

[Rob_dos_Ramos]

CNAME and Fqdn of the server match but I will double check again

[Rob_dos_Ramos]

81 14:08:22.057  [3188] (EVRunDll) <2320> EV:M GetComputer - enter
182 14:08:22.057  [3188] (EVRunDll) <2320> EV:M GetComputer - [ODMEV01]
183 14:08:22.057  [3188] (EVRunDll) <2320> EV:M CBaseDirectoryServiceWrapper::GetInterface - RegKey UseLocalDirectory [False]
185 14:08:22.057  [3188] (EVRunDll) <2320> EV:M CBaseDirectoryServiceWrapper::CreateDirectoryService() - Entry [m_nNumTries = 3]
186 14:08:22.057  [3188] (EVRunDll) <2320> EV:L CBaseDirectoryServiceWrapper::CreateDirectoryService() - Will try to connect to EV Directory Service on ODMEV01
187 14:08:22.057  [3188] (EVRunDll) <3696> EV:M CAviProgDlgLauncherThrd::~CAviProgDlgLauncherThrd() - Final cleanup.
188 14:08:22.057  [3188] (EVRunDll) <3696> EV:M CAviProgDlgLauncherThrd::ExitInstance() - thread terminated successfully.
189 14:08:22.088  [3188] (EVRunDll) <2320> EV:M CBaseDirectoryServiceWrapper::GetInterface - RegKey UseLocalDirectory [False]
191 14:08:22.088  [3188] (EVRunDll) <2320> EV:M CBaseDirectoryServiceWrapper::CreateDirectoryService() - Entry [m_nNumTries = 3]
192 14:08:22.088  [3188] (EVRunDll) <2320> EV:L CBaseDirectoryServiceWrapper::CreateDirectoryService() - Will try to connect to EV Directory Service on ODMEV01

193 14:08:22.134  [1668] (DirectoryService) <3724> EV~E Event ID: 13360 An error was detected while accessing the Vault Database 'EnterpriseVaultDirectory' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1390,1392,1407,1425}] built Nov  2 19:40:47 2009): |Description:  |Could not find stored procedure 'UpdateVSAAccountDetails'.| | |SQL Command: |  UpdateVSAAccountDetails| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Provider for SQL Server |Number:       0x80040e14 |SQL State:    42000 |Native Error: 00002812 |HRESULT|0x80040e14| |

194 14:08:22.134  [3188] (EVRunDll) <2320> EV:M HRXEX fn trace :|Source     : .\DirectoryServiceWrapper.cpp (CEnumDirectoryServiceWrapper::CheckDirectorySchemaVersionPublic) [lines {922,927}] built Nov  2 19:42:12 2009|Description: Call error 0x80040e14
195 14:08:22.134  [3188] (EVRunDll) <2320> EV:M HRXEX fn trace :|Source     : .\DirectoryServiceWrapper.cpp (CBaseDirectoryServiceWrapper::GetInterface) [lines {656,696,722,727,730}] built Nov  2 19:42:12 2009|Description: Call error 0x80040e14
196 14:08:22.134  [3188] (EVRunDll) <2320> EV:M HRXEX fn trace :|Source     : .\DirectoryServiceWrapper.cpp (CBaseDirectoryServiceWrapper::Invoke) [lines {401,407}] built Nov  2 19:42:12 2009|Description: Call error 0x80040e14
197 14:08:22.134  [3188] (EVRunDll) <2320> EV:M HRXEX fn trace :|Source     : .\DirectoryServiceWrapper.cpp (CEnumDirectoryServiceWrapper::Invoke) [lines {805,823}] built Nov  2 19:42:12 2009|Description: Call error 0x80040e14
199 14:08:22.134  [3188] (EVRunDll) <2320> EV:M Finished creating a computer object with status: An unspecified SQL error has occurred. See the Enterprise Vault Event log for more details.
200 14:08:22.134  [3188] (EVRunDll) <2320> EV:M CAUIConfWizSQLServerPage::DoSQLInitialize: RepairThisComputerIfOrphanedComputerEntryInDirectory completed, hrx: Success

[JesusWept3 · Accepted solution]

Ok and this is a test right?? Can you check the production SQL server vs your test one to see if that missing stored proc exists? I'm wondering whether the evadmin has appropriate rights on the SQL server

[Rob_dos_Ramos]

Silly question but where can I check for the stored proc?

[JesusWept3]

Ok so open SQL management studio Expand out Databases -> EnterpriseVaultDirectory -> Programmability -> Stored Procedures You should see every stored proc that EV uses for the directory If you can, use the evadmin login as something tells me it's a permissions thing but I could be wrong

[Rob_dos_Ramos]

Server role is Sysadmin

And it is DB owner on all databases.

The test enviroment is SQL 2008 and the production is SQL 2005.

Background, USer have been unable to access information for about 3 months now and I have a support call about this whole thing. So what I wanted to do is restore the databases back before the problem occured.

So we created a new EV server with the same name etc (old server is down) and we are using a diffrent SQL server and not the production server.

[Rob_dos_Ramos]

OK strange one, I cannot see the EV account when I browser the users but it is in the secuirty section.

[JesusWept3]

Please tell me you are doing this on a separate network where the two EV servers and two SQL servers and storage can't reach each other?! Anywho if you are sysadmin that should be god like rights so it should be ok Does deployment scanner complain about connectivity or Login rights? And in management studio, we're you able to see the stored proc whilst using the evadmin login?

[Rob_dos_Ramos]

OK I do not see the procedure at all in the test enviroment.

[JesusWept3]

And in production?

[Rob_dos_Ramos]

Ok the procedure was missing in SQL, in fact a heck of a lot of procedures where missing so I am going to find another backup and double check.

Thanks JesusWept2, you are a life saver.

[Rob_dos_Ramos]

Production the procedure is there.

Thanks again

[JesusWept3]

good job :)