27
2012
Symantec Veritas Netbackup issue – Error (31073)
While setting up netbackup on one SQL Server 2008 R2, faced few errors on netbackup GUI client as,
Error 1:
Error in GUI interface,
Error (31073)
INF – Results of executing <C:\lclbin\tsv\bin\Trans_Trunc.bch>:
<0> operations succeeded. <1> operations failed.
Troubleshooting Steps:
With above error, getting no clue how to find the issue, so did following as per article http://www.symantec.com/connect/forums/mssql-2008-backup-status-2-29 ,
1. Check the environment variables and add the path of veritas dbbackex.exe as E:\PROGRA~1\Veritas\NetBackup\bin\ (may vary based on your system)
2. Create the logs directory (it was missing on my system) –change drive letter based on installation in your system
mkdir E:\Program Files\Veritas\NetBackup\logs\dbclient
3. Ran backup again and it throwed following error in GUI client interface,
Error 2:
Error in GUI interface,
Error (31073)
CONTINUATION: – Could not write to the registry
CONTINUATION: – Could not write to the registry
CONTINUATION: – Driver’s ConfigDSN, ConfigDriver, or ConfigTranslator failed
ERR – Internal error. See the dbclient log for more information.
With above error, check the error log present in dbclient folder and it gave following result,
05:41:06.498 [27904.20740] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
05:41:06.498 [27904.20740] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
05:41:06.644 [27904.20740] <2> logconnections: BPRD CONNECT FROM 10.57.16.16.60981 TO 10.62.208.4.13724
05:41:06.874 [27904.20740] <4> CGlobalInformation::VCSVirtualNameList: INF – Veritas Cluster Server is not installed.
05:41:06.875 [27904.20740] <1> CGlobalInformation::VCSVirtualNameList: CONTINUATION: – The system cannot find the path specified.
05:41:06.875 [27904.20740] <4> getServerName: Read server name from nb_master_config: nbprodcl1
05:41:06.875 [27904.20740] <4> CDBIniParms::CDBIniParms: INF – NT User is ngarg_adm
05:41:06.882 [27904.20740] <4> CGlobalInformation::CreateDSN: INF – Error Creating ODBC data source name
05:41:06.888 [27904.20740] <1> CGlobalInformation::CreateDSN: CONTINUATION: – Could not write to the registry
05:41:06.888 [27904.20740] <1> CGlobalInformation::CreateDSN: CONTINUATION: – Could not write to the registry
05:41:06.888 [27904.20740] <1> CGlobalInformation::CreateDSN: CONTINUATION: – Driver’s ConfigDSN, ConfigDriver, or ConfigTranslator failed
05:41:06.892 [27904.20740] <16> CDBbackrec::CDBbackrec: ERR – Internal error. See the dbclient log for more information.
05:41:06.892 [27904.20740] <32> CDBbackrec::CDBbackrec: ERR – Error 1 has been returned from GetCurrentDSN
05:41:08.892 [27904.20740] <4> CDBbackmain::dbbackup: INF – Results of executing <C:\lclbin\tsv\bin\Trans_Trunc.bch>:
<0> operations succeeded. <1> operations failed.
Troubleshooting Steps:
From the dbclient log snips, it appeared that the issue is with creating the ODBC datasource name when connecting to the SQL server via API, so did following (as per useful link: http://fixunix.com/veritas-net-backup/481537-start-netbackup-sqlserveragent.html ),
It would appear that Netbackup creates temporary DSN entries (I was using dbbackex.exe and calling the exe via batch file). The error is question is due to the fact that the account running the backup (i.e. the SQL Agent account in my case) does not have permissions to modify the ODBC.INI in the registry (HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI)
Modify the registry and also give the account full access to the VERITAS folder on the E: drive and things will hopefully work.
In my case as soon as I gave privileges, it resolved modify dsn error.
Below is list of other troubleshooting steps for this error,
.
There are a couple of possible reasons for this error.
1.The NetBackup client service login account specified on the SQL client or the user account that was logged in to the OS and initiating the backup doesn’t have the correct permissions to backup/restore the databases in the SQL server.
2. The SQL server version is not supported with the current NetBackup DB agent software installed on the client. For example: Windows 2008 R2, SQL 2008 R2 support starts at NetBackup 6.5.5.
3. The SQLHOST, SQLINSTANCE names specified in the script is incorrect.
4. The SQL server and instance being backed up is not running.
–Make sure that the NetBackup client service login account is a domain user with local and sysadmin roles to the SQL server.
–Make sure that the SQL server version being backed up is supported.
–Check the .bch backup script file for accuracy. Use the NetBackup Microsoft client software GUI when creating the backup script.
–Login to the SQL server and instance via SQL management studio to make sure that a connection to the server can be made outside of NetBackup.
–Login to the SQL server using the SQL administrator account and attempt to create an ODBC Data Source Name to test the connection to the SQL server. Refer to the ODBC administrator guide for further details
After fixing above, when ran backup again, it failed with following error,
Error 3:
Error in GUI interface,
Error (-1)
ERR – Error in CreateEx: 0x80070005.
CONTINUATION: – Unknown VDI error code
When checked dbclient error log then following error was reported over there,
08:33:29.503 [9600.19388] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
08:33:29.690 [9600.19388] <2> logconnections: BPRD CONNECT FROM 10.57.16.16.51505 TO 10.62.208.4.13724
08:33:31.790 [9600.19388] <16> CDBbackrec::InitDeviceSet(): ERR – Error in CreateEx: 0x80070005.
08:33:31.790 [9600.19388] <1> CDBbackrec::InitDeviceSet(): CONTINUATION: – Unknown VDI error code
08:33:31.790 [9600.19388] <4> KillAllThreads: INF – Killing group #0
08:33:31.790 [9600.1504] <4> KillAllThreads: INF – Killing group #0
08:33:31.810 [9600.27752] <4> KillAllThreads: INF – Killing group #0
08:33:31.810 [9600.10560] <4> KillAllThreads: INF – Killing group #0
Troubleshooting Steps:
As per link: http://www.symantec.com/business/support/index?page=content&id=TECH196751
Gave privileges as,
To identify the issue log in as user account for backup run and run whoami/priv. If SeCreateGlobalPrivilege is not listed as enabled user does not have correct permissions.
Follow these steps to resolve the issue:
1. From the Microsoft SQL Server, run gpedit.msc from the Start | Run menu. Expand the group policy management console and view the properties of the Create Global Objects
2. Add the account that is being used for the Netbackup Client Service.
3. Log out of the server then back in and verify with whoami/priv.
Above also didn’t solved my issue, then tested following,
Make the NT user ID (in this case SQLNBU) into which the Veritas NetBackup client service is logging as an account that has SQL backup and restore privileges on the local (SQL) server.
Above test looked fine as I have sysadmin privileges, then did following,
Ran the batch file with “Run as Administrator” privileges and voila! Backup started running fine.
But this was not the solution, as the account under which this needs to run is still causing failure, so gave all privileges as above to that account and issue still persist but now with error as,
Error 4:
Error in GUI Interface,
Error (31073)
CONTINUATION: – Component not found in the registry
ERR – Internal error. See the dbclient log for more information.
In dbclient log,
12:00:04.198 [26904.584] <4> DBConnect: INF – Logging into SQL Server with DSN <NBMSSQL_26904_584_1>, SQL userid <sa> handle <0x02bff800>.
12:00:04.214 [26904.584] <4> DBConnect: INF – Logging into SQL Server with DSN <NBMSSQL_26904_584_1>, SQL userid <sa> handle <0x02c00810>.
12:00:04.220 [26904.584] <4> CGlobalInformation::CreateDSN: INF – Error Creating ODBC data source name
12:00:04.220 [26904.584] <1> CGlobalInformation::CreateDSN: CONTINUATION: – Component not found in the registry
12:00:04.220 [26904.584] <16> CDBbackrec::CDBbackrec: ERR – Internal error. See the dbclient log for more information.
12:00:04.220 [26904.584] <32> CDBbackrec::CDBbackrec: ERR – Error 1 has been returned from GetCurrentDSN
12:00:06.220 [26904.584] <4> CDBbackmain::dbbackup: INF – Results of executing <c:\lclbin\tsv\bin\Trans_Trunc.bch>:
<0> operations succeeded. <1> operations failed.
Troubleshooting steps:
As per article, http://www.symantec.com/business/support/index?page=content&id=TECH140543 verified the account under which job is running has sysadmin or privileges and found that it is missing, so gave privileges to account.
Ensure that the NetBackup Client Service on the affected client system is logged on as an account that is a member of the SysAdmin server role in SQL Server.
After doing it, job started running fine, at last! 🙂
Useful references:
http://www.symantec.com/connect/forums/mssql-2008-backup-status-2-29
http://www.symantec.com/business/support/index?page=content&id=TECH44647
http://www.symantec.com/business/support/index?page=content&id=TECH143774
http://www.symantec.com/business/support/index?page=content&id=TECH138096
http://fixunix.com/veritas-net-backup/481537-start-netbackup-sqlserveragent.html
http://www.symantec.com/business/support/index?page=content&id=TECH31961
http://www.symantec.com/business/support/index?page=content&id=TECH16961
http://www.symantec.com/business/support/index?page=content&id=TECH196751
http://www.symantec.com/business/support/index?page=content&id=TECH140543

4 Comments + Add Comment
Leave a comment to Geoff
Subscribe to this blog via Email
Old Posts
- November 2017 (3)
- October 2017 (4)
- September 2017 (2)
- May 2017 (1)
- April 2017 (1)
- July 2016 (3)
- May 2016 (1)
- April 2016 (1)
- February 2016 (2)
- January 2016 (1)
- October 2015 (1)
- September 2015 (1)
- August 2015 (1)
- July 2015 (2)
- June 2015 (3)
- April 2015 (1)
- March 2015 (1)
- December 2014 (1)
- September 2014 (2)
- April 2014 (1)
- January 2014 (3)
- October 2013 (2)
- September 2013 (2)
- August 2013 (4)
- July 2013 (1)
- June 2013 (2)
- May 2013 (5)
- April 2013 (3)
- March 2013 (1)
- February 2013 (9)
- January 2013 (11)
- December 2012 (14)
- November 2012 (3)
- October 2012 (4)
- July 2012 (2)
- June 2012 (3)
- May 2012 (2)
- April 2012 (8)
- March 2012 (6)
- February 2012 (3)
- January 2012 (1)
- December 2011 (5)
- November 2011 (8)
- October 2011 (5)
- September 2011 (3)
- August 2011 (3)
- July 2011 (3)
- May 2011 (1)
- November 2010 (1)
Tags
Calender
M | T | W | T | F | S | S |
---|---|---|---|---|---|---|
« Nov | ||||||
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 |
View Post by Categories
Recent Articles
- Setting up Always ON Availability Group in Multi Subnet Cluster – Recommendations
- Configuring Replication with Always ON Availability Group
- Login failed for user ‘DOMAIN\COMPUTER$’. Reason: Could not find a login matching the name provided. [CLIENT: ]
- Modern Servicing Model (Service Pack and Cumulative Updates) for SQL Server 2017 and onwards
- Fix: SSMS 2012 opening Debug window when pressing F5
[…] continuation with my old post where I troubleshoot the Symantec NetBackup Error (31073), today faced similar error on another […]
[…] http://blogs.lostincreativity.com/sqldba/symantec-veritas-netbackup-issue-error-31073/ […]
Thanks! This worked for us, by adding permissions to the odbc folder in the registry.
Thanks Geoff, good to hear that it worked!