SQL Backup failure

[wannawin]

Hello Team,

.bch file has been created but sql backup has failed.

dbclient logs

14:30:18.333 [8944.8296] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:30:18.334 [8944.8296] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59840 TO 10.180.26.201.1556 fd = 620
14:30:18.350 [8944.8296] <4> CGlobalInformation::VCSVirtualNameList: INF - Veritas Cluster Server is not installed.
14:30:18.351 [8944.8296] <1> CGlobalInformation::VCSVirtualNameList:     CONTINUATION: - The system cannot find the path specified.
14:30:18.352 [8944.8296] <4> getServerName: Read server name from nb_master_config: fisnbmp010
14:30:18.352 [8944.8296] <4> CDBIniParms::CDBIniParms: INF - NT User is fnfgbkup
14:30:18.373 [8944.8296] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_temp_8944_8296_1>, SQL userid <fnfg\fnfgbkup> handle <0x010794d0>.
14:30:18.445 [8944.8296] <4> CGlobalInformation::CreateDSN: INF - A successful connection to SQL Server <FNGWENGDBPR02\RECORD_ENGAGE> has been made using standard security with DSN <NBMSSQL_temp_8944_8296_1>
14:30:18.445 [8944.8296] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x010794d0>
14:30:18.445 [8944.8296] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_temp_8944_8296_1>, SQL userid <fnfg\fnfgbkup> handle <0x010794d0>.
14:30:18.522 [8944.8296] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x010794d0>
14:30:23.106 [8944.8296] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_8944_8296_2>, SQL userid <fnfg\fnfgbkup> handle <0x010794d0>.
14:30:23.133 [8944.8296] <4> CGlobalInformation::CreateDSN: INF - A successful connection to SQL Server <FNGWENGDBPR02\RECORD_ENGAGE> has been made using standard security with DSN <NBMSSQL_8944_8296_2>
14:30:23.133 [8944.8296] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x010794d0>
14:30:23.134 [8944.8296] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_8944_8296_2>, SQL userid <fnfg\fnfgbkup> handle <0x010794d0>.
14:30:23.586 [8944.8296] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x010794d0>
14:30:23.592 [8944.8296] <8> CDBbackupView::ClassDropDownList: WARN - Error: bppllist not found in C:\Program Files\Veritas\NetBackup\bin\admincmd\bppllist.exe.
14:30:23.592 [8944.8296] <1> CDBbackupView::ClassDropDownList:     CONTINUATION: - The system cannot find the path specified.
14:30:23.592 [8944.8296] <8> CBackupDBDlg::OnInitDialog: WARN - Policy Dropdown not created: Server = fisnbmp010, Client = FNGWENGDBPR02
14:30:23.592 [8944.8296] <1> CBackupDBDlg::OnInitDialog:     CONTINUATION: - The system cannot find the path specified.
14:31:58.056 [6204.7320] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:31:58.057 [6204.7320] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59873 TO 10.180.26.201.1556 fd = 596
14:31:58.074 [6204.7320] <4> CGlobalInformation::VCSVirtualNameList: INF - Veritas Cluster Server is not installed.
14:31:58.074 [6204.7320] <1> CGlobalInformation::VCSVirtualNameList:     CONTINUATION: - The system cannot find the path specified.
14:31:58.075 [6204.7320] <4> getServerName: Read server name from nb_master_config: fisnbmp010
14:31:58.075 [6204.7320] <4> CDBIniParms::CDBIniParms: INF - NT User is SYSTEM
14:31:58.132 [6204.7320] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_6204_7320_1>, SQL userid <sa> handle <0x00f994b0>.
14:31:58.169 [6204.7320] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_6204_7320_1>, SQL userid <sa> handle <0x00f9a530>.
14:31:58.180 [6204.7320] <4> CGlobalInformation::CreateDSN: INF - Error Creating ODBC data source name
14:31:58.180 [6204.7320] <1> CGlobalInformation::CreateDSN:     CONTINUATION: - Component not found in the registry
14:31:58.204 [6204.7320] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:31:58.205 [6204.7320] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59876 TO 10.180.26.201.1556 fd = 828
14:31:58.261 [6204.7320] <16> CDBbackmain::LoadUserLogin: ERR - Internal error. See the dbclient log for more information.
14:31:58.276 [6204.7320] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:31:58.277 [6204.7320] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59877 TO 10.180.26.201.1556 fd = 828
14:31:58.333 [6204.7320] <32> CDBbackmain::LoadUserLogin: ERR - Error 1 has been returned from GetCurrentDSN
14:31:58.341 [6204.7320] <4> CDBbackmain::dbbackup: INF - Results of executing <d:\Netbackup Scripts\FNFG_OPT1_LCKPRT_SQL_WEEKLY.bch>:

<0> operations succeeded. <0> operations failed.
14:31:58.345 [6204.7320] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:31:58.346 [6204.7320] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59878 TO 10.180.26.201.1556 fd = 628
14:32:22.417 [8944.8296] <4> StartupProcess: INF - Starting: <notepad C:\Program Files\Veritas\NetBackup\DbExt\MsSql\test_fngwengdbpr02.bch>
14:34:13.586 [7944.6840] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:34:13.587 [7944.6840] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59895 TO 10.180.26.201.1556 fd = 596
14:34:13.605 [7944.6840] <4> CGlobalInformation::VCSVirtualNameList: INF - Veritas Cluster Server is not installed.
14:34:13.605 [7944.6840] <1> CGlobalInformation::VCSVirtualNameList:     CONTINUATION: - The system cannot find the path specified.
14:34:13.606 [7944.6840] <4> getServerName: Read server name from nb_master_config: fisnbmp010
14:34:13.606 [7944.6840] <4> CDBIniParms::CDBIniParms: INF - NT User is SYSTEM
14:34:13.642 [7944.6840] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7944_6840_1>, SQL userid <sa> handle <0x00f794b0>.
14:34:13.685 [7944.6840] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7944_6840_1>, SQL userid <sa> handle <0x00f7a530>.
14:34:13.701 [7944.6840] <4> CGlobalInformation::CreateDSN: INF - Error Creating ODBC data source name
14:34:13.701 [7944.6840] <1> CGlobalInformation::CreateDSN:     CONTINUATION: - Component not found in the registry
14:34:13.708 [7944.6840] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:34:13.709 [7944.6840] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59898 TO 10.180.26.201.1556 fd = 828
14:34:13.766 [7944.6840] <16> CDBbackmain::LoadUserLogin: ERR - Internal error. See the dbclient log for more information.
14:34:13.772 [7944.6840] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:34:13.773 [7944.6840] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59899 TO 10.180.26.201.1556 fd = 828
14:34:13.829 [7944.6840] <32> CDBbackmain::LoadUserLogin: ERR - Error 1 has been returned from GetCurrentDSN
14:34:13.830 [7944.6840] <4> CDBbackmain::dbbackup: INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\test_fngwengdbpr02.bch>:

<0> operations succeeded. <0> operations failed.
14:34:13.835 [7944.6840] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:34:13.835 [7944.6840] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59900 TO 10.180.26.201.1556 fd = 628
14:42:21.907 [800.7704] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:42:21.908 [800.7704] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59963 TO 10.180.26.201.1556 fd = 596
14:42:21.925 [800.7704] <4> CGlobalInformation::VCSVirtualNameList: INF - Veritas Cluster Server is not installed.
14:42:21.925 [800.7704] <1> CGlobalInformation::VCSVirtualNameList:     CONTINUATION: - The system cannot find the path specified.
14:42:21.926 [800.7704] <4> getServerName: Read server name from nb_master_config: fisnbmp010
14:42:21.926 [800.7704] <4> CDBIniParms::CDBIniParms: INF - NT User is SYSTEM
14:42:22.048 [800.7704] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_800_7704_1>, SQL userid <sa> handle <0x010894b0>.
14:42:22.170 [800.7704] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_800_7704_1>, SQL userid <sa> handle <0x0108a530>.
14:42:22.185 [800.7704] <4> CGlobalInformation::CreateDSN: INF - Error Creating ODBC data source name
14:42:22.185 [800.7704] <1> CGlobalInformation::CreateDSN:     CONTINUATION: - Component not found in the registry
14:42:22.204 [800.7704] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:42:22.205 [800.7704] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59967 TO 10.180.26.201.1556 fd = 828
14:42:22.265 [800.7704] <16> CDBbackmain::LoadUserLogin: ERR - Internal error. See the dbclient log for more information.
14:42:22.270 [800.7704] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:42:22.271 [800.7704] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59973 TO 10.180.26.201.1556 fd = 828
14:42:22.327 [800.7704] <32> CDBbackmain::LoadUserLogin: ERR - Error 1 has been returned from GetCurrentDSN
14:42:22.331 [800.7704] <4> CDBbackmain::dbbackup: INF - Results of executing <d:\Netbackup Scripts\FNFG_OPT1_LCKPRT_SQL_WEEKLY.bch>:

<0> operations succeeded. <0> operations failed.
14:42:22.336 [800.7704] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:42:22.337 [800.7704] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59974 TO 10.180.26.201.1556 fd = 628
14:44:35.892 [8804.3884] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:44:35.893 [8804.3884] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59987 TO 10.180.26.201.1556 fd = 596
14:44:35.910 [8804.3884] <4> CGlobalInformation::VCSVirtualNameList: INF - Veritas Cluster Server is not installed.
14:44:35.911 [8804.3884] <1> CGlobalInformation::VCSVirtualNameList:     CONTINUATION: - The system cannot find the path specified.
14:44:35.911 [8804.3884] <4> getServerName: Read server name from nb_master_config: fisnbmp010
14:44:35.911 [8804.3884] <4> CDBIniParms::CDBIniParms: INF - NT User is SYSTEM
14:44:35.955 [8804.3884] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_8804_3884_1>, SQL userid <sa> handle <0x010194b0>.
14:44:35.988 [8804.3884] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_8804_3884_1>, SQL userid <sa> handle <0x0101a530>.
14:44:36.004 [8804.3884] <4> CGlobalInformation::CreateDSN: INF - Error Creating ODBC data source name
14:44:36.004 [8804.3884] <1> CGlobalInformation::CreateDSN:     CONTINUATION: - Component not found in the registry
14:44:36.020 [8804.3884] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:44:36.021 [8804.3884] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59990 TO 10.180.26.201.1556 fd = 828
14:44:36.078 [8804.3884] <16> CDBbackmain::LoadUserLogin: ERR - Internal error. See the dbclient log for more information.
14:44:36.083 [8804.3884] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:44:36.084 [8804.3884] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59991 TO 10.180.26.201.1556 fd = 828
14:44:36.140 [8804.3884] <32> CDBbackmain::LoadUserLogin: ERR - Error 1 has been returned from GetCurrentDSN
14:44:36.140 [8804.3884] <4> CDBbackmain::dbbackup: INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\test_fngwengdbpr02.bch>:

<0> operations succeeded. <0> operations failed.
14:44:36.145 [8804.3884] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:44:36.145 [8804.3884] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.59992 TO 10.180.26.201.1556 fd = 628
14:54:58.992 [6868.7196] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:54:58.993 [6868.7196] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.53161 TO 10.180.26.201.1556 fd = 596
14:54:59.010 [6868.7196] <4> CGlobalInformation::VCSVirtualNameList: INF - Veritas Cluster Server is not installed.
14:54:59.010 [6868.7196] <1> CGlobalInformation::VCSVirtualNameList:     CONTINUATION: - The system cannot find the path specified.
14:54:59.011 [6868.7196] <4> getServerName: Read server name from nb_master_config: fisnbmp010
14:54:59.011 [6868.7196] <4> CDBIniParms::CDBIniParms: INF - NT User is SYSTEM
14:54:59.044 [6868.7196] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_6868_7196_1>, SQL userid <sa> handle <0x00f494b0>.
14:54:59.091 [6868.7196] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_6868_7196_1>, SQL userid <sa> handle <0x00f4a530>.
14:54:59.100 [6868.7196] <4> CGlobalInformation::CreateDSN: INF - Error Creating ODBC data source name
14:54:59.100 [6868.7196] <1> CGlobalInformation::CreateDSN:     CONTINUATION: - Component not found in the registry
14:54:59.115 [6868.7196] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:54:59.116 [6868.7196] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.53164 TO 10.180.26.201.1556 fd = 828
14:54:59.173 [6868.7196] <16> CDBbackmain::LoadUserLogin: ERR - Internal error. See the dbclient log for more information.
14:54:59.186 [6868.7196] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:54:59.187 [6868.7196] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.53165 TO 10.180.26.201.1556 fd = 828
14:54:59.243 [6868.7196] <32> CDBbackmain::LoadUserLogin: ERR - Error 1 has been returned from GetCurrentDSN
14:54:59.244 [6868.7196] <4> CDBbackmain::dbbackup: INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\test_fngwengdbpr02.bch>:

<0> operations succeeded. <0> operations failed.
14:54:59.248 [6868.7196] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:54:59.248 [6868.7196] <2> logconnections: BPRD CONNECT FROM 10.180.20.187.53166 TO 10.180.26.201.1556 fd = 628

[pri3006]

Seems like a problem related to privileges. A couple of forum articles are present for this issue. One of them is :

http://www.symantec.com/connect/forums/ms-sql-agent-application-connection-failed-servername

Also,

http://www.symantec.com/business/support/index?page=content&id=TECH140543

[Marianne · Accepted solution]

"14:31:58.261 [6204.7320] <16> CDBbackmain::LoadUserLogin: ERR - Internal error. " Permission issue. Work with your SQL dba. Change NBU Client service logon account to a domain user with sufficient SQL rights. PS: Please copy log files to .txt (e.g. dblient.txt) and upload as File attachments.

[Michael_G_Ander]

The account needs the have sysadmin on the SQL server, be aware on that the local system account does not have that as default anymore