Forum Discussion

Rob_dos_Ramos's avatar
Rob_dos_Ramos
Level 6
14 years ago
Solved

Recovery

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's avatar
    JesusWept3
    14 years ago
    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

15 Replies

  • JesusWept3's avatar
    JesusWept3
    Level 6
    14 years ago
    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's avatar
    Rob_dos_Ramos
    Level 6
    14 years ago

    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's avatar
    Rob_dos_Ramos
    Level 6
    14 years ago

    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's avatar
    JesusWept3
    Level 6
    14 years ago
    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
  • JesusWept3's avatar
    JesusWept3
    Level 6
    14 years ago
    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's avatar
    Rob_dos_Ramos
    Level 6
    14 years ago

    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's avatar
    Rob_dos_Ramos
    Level 6
    14 years ago

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

     

  • JesusWept3's avatar
    JesusWept3
    Level 6
    14 years ago
    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?