02-15-2012 03:40 AM
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
Solved! Go to Solution.
02-15-2012 04:19 AM
02-15-2012 04:05 AM
02-15-2012 04:12 AM
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
02-15-2012 04:14 AM
CNAME and Fqdn of the server match but I will double check again
02-15-2012 04:15 AM
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
02-15-2012 04:19 AM
02-15-2012 04:21 AM
Silly question but where can I check for the stored proc?
02-15-2012 04:24 AM
02-15-2012 04:24 AM
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.
02-15-2012 04:28 AM
OK strange one, I cannot see the EV account when I browser the users but it is in the secuirty section.
02-15-2012 04:35 AM
02-15-2012 04:35 AM
OK I do not see the procedure at all in the test enviroment.
02-15-2012 04:38 AM
02-15-2012 04:41 AM
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.
02-15-2012 05:50 AM
Production the procedure is there.
Thanks again
02-15-2012 06:03 AM
good job :)