'ODBC access error' occurs after upgrading Backup Exec and/or selections are missing in the Restore Selections window.
| Article:TECH67271 | | | Created: 2009-01-28 | | | Updated: 2011-01-03 | | | Article URL http://www.symantec.com/docs/TECH67271 |
Problem
'ODBC access error' occurs after upgrading Backup Exec and/or selections are missing in the Restore Selections window.
Error
ODBC access error. Possible lost connection to database or unsuccessful access catalog index database
Solution
SYMPTOMS:
1. ERROR: ODBC access error. Possible lost connection to database or unsuccessful access catalog index database
2. Blank restore selection list.
ISSUE:
This error usually occurs after an upgrade. It is most common among "multi-step upgrades." For example, upgrading from 9.1 > 11d > 12.5 OR 10d > 12.0 > 12.5. Multiple alerts and notifications regarding the catalogs are seen in the Windows Event Viewer and the Backup Exec Alerts tab.
One of the following can be tried to resolve such issue:
Resolution 1
1. Stop the Backup Exec Services.
2. Open a command prompt on the media server
3. Change the directory to the Backup Exec installation directory: \Program Files\Symantec\Backup Exec
4. Type the follow and then press Enter: catrebuildindex -r
5. After the process completes, scroll up and confirm the log show files were successfully migrated
6. Restart all of the Backup Exec Services on the media server.
Note: In some cases, it may be necessary to clear the alerts tab and reboot the server after performing the steps above.
Resolution 2
Change the location of Catalogs folder to another volume using Beutility. For more details on how to change location of catalogs refer to the link below:
Resolution 3
Ensure the value of the following registry keys are as mentioned below.(Depending on the Backup Exec Server configuration)
Warning: Incorrect use of the Windows Registry Editor may prevent the operating system from functioning properly. Great care should be taken when making changes to a Windows registry. Registry modifications should only be carried-out by persons experienced in the use of the registry editor application. It is recommended that a complete backup of the registry and workstation be made prior to making any registry changes.
HKEY_LOCAL_MACHINE\SOFTWARE\Symantec\Backup Exec For Windows\Backup Exec\Server
HKEY_LOCAL_MACHINE\SOFTWARE\Symantec\Backup Exec For Windows\Backup Exec\Catalogs
I. For a Standalone Backup Exec server:
SSOState=0
Catalog Remote Server Name = (Does not exist)
II. For a SSO Primary server:
SSOState=1
Catalog Remote Server Name = (Does not exist)
III. For a SSO Secondary server:
SSOState=2
Catalog Remote Server Name = (Name of primary server)
|
|
| Source | Error Code |
| Value | E0008445 |
| Description | ODBC Access Error. Possible lost connection to database or unsuccessful access to catalog index in the database.
|
| Source | UMI |
| Value | V-79-57344-33861 |
| Description | ODBC Access Error. Possible lost connection to database or unsuccessful access to catalog index in the database.
|
Related Articles
Legacy ID
318287
Article URL http://www.symantec.com/docs/TECH67271
Terms of use for this information are found in Legal Notices
Thank you.