SQL The requested operation was partially successful (1)

Question

&nbsp;&nbsp;Hi,I'm having problems with some DB's was closed with the error (1) partially completed, but I can't find the problem,follow the job details:26/12/2020&nbsp;11:13:43&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;Copyright&nbsp;(c)&nbsp;Microsoft&nbsp;Corporation26/12/2020&nbsp;11:13:43&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;Enterprise&nbsp;Edition:&nbsp;Core-based&nbsp;Licensing&nbsp;(64-bit)&nbsp;on&nbsp;Windows&nbsp;Server&nbsp;2012&nbsp;R2&nbsp;Standard&nbsp;6.3&nbsp;&lt;X64&gt;&nbsp;(Build&nbsp;9600:&nbsp;)&nbsp;(Hypervisor)&nbsp;26/12/2020&nbsp;11:13:43&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;Batch&nbsp;=&nbsp;C:\Program&nbsp;Files\Veritas\NetBackup\DbExt\MsSql\fullmensal_backup.bch,&nbsp;Op#&nbsp;=&nbsp;1026/12/2020&nbsp;11:13:44&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;Using&nbsp;backup&nbsp;image&nbsp;server_db.MSSQL7. server_db\SQLBI1.db.SSISDB.~.7.001of001.20201226101343..C26/12/2020&nbsp;11:13:44&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;backup&nbsp;database&nbsp;"SSISDB"&nbsp;to&nbsp;VIRTUAL_DEVICE='VNBU0-13780-13452-1608988424'&nbsp;with&nbsp;&nbsp;stats&nbsp;=&nbsp;10,&nbsp;blocksize&nbsp;=&nbsp;65536,&nbsp;maxtransfersize&nbsp;=&nbsp;4194304,&nbsp;buffercount&nbsp;=&nbsp;226/12/2020&nbsp;11:13:44&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;Number&nbsp;of&nbsp;stripes:&nbsp;1,&nbsp;Number&nbsp;of&nbsp;buffers&nbsp;per&nbsp;stripe&nbsp;2.26/12/2020&nbsp;11:13:44&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;Created&nbsp;VDI&nbsp;object&nbsp;for&nbsp;SQL&nbsp;Server&nbsp;instance&nbsp;&lt;SQLBI1&gt;.&nbsp;Connection&nbsp;timeout&nbsp;is&nbsp;&lt;300&gt;&nbsp;seconds.26/12/2020&nbsp;11:14:13&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;ODBC&nbsp;return&nbsp;code&nbsp;&lt;2&gt;,&nbsp;SQL&nbsp;State&nbsp;&lt;01000&gt;,&nbsp;SQL&nbsp;Message&nbsp;&lt;3211&gt;&lt;[Microsoft][SQL&nbsp;Server&nbsp;Native&nbsp;Client&nbsp;11.0][SQL&nbsp;Server]10&nbsp;percent&nbsp;processed.&gt;.26/12/2020&nbsp;11:14:24&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;ODBC&nbsp;return&nbsp;code&nbsp;&lt;2&gt;,&nbsp;SQL&nbsp;State&nbsp;&lt;01000&gt;,&nbsp;SQL&nbsp;Message&nbsp;&lt;3211&gt;&lt;[Microsoft][SQL&nbsp;Server&nbsp;Native&nbsp;Client&nbsp;11.0][SQL&nbsp;Server]20&nbsp;percent&nbsp;processed.&gt;.26/12/2020&nbsp;11:14:35&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;ODBC&nbsp;return&nbsp;code&nbsp;&lt;2&gt;,&nbsp;SQL&nbsp;State&nbsp;&lt;01000&gt;,&nbsp;SQL&nbsp;Message&nbsp;&lt;3211&gt;&lt;[Microsoft][SQL&nbsp;Server&nbsp;Native&nbsp;Client&nbsp;11.0][SQL&nbsp;Server]30&nbsp;percent&nbsp;processed.&gt;.26/12/2020&nbsp;11:14:46&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;ODBC&nbsp;return&nbsp;code&nbsp;&lt;2&gt;,&nbsp;SQL&nbsp;State&nbsp;&lt;01000&gt;,&nbsp;SQL&nbsp;Message&nbsp;&lt;3211&gt;&lt;[Microsoft][SQL&nbsp;Server&nbsp;Native&nbsp;Client&nbsp;11.0][SQL&nbsp;Server]40&nbsp;percent&nbsp;processed.&gt;.26/12/2020&nbsp;11:15:08&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;ODBC&nbsp;return&nbsp;code&nbsp;&lt;2&gt;,&nbsp;SQL&nbsp;State&nbsp;&lt;01000&gt;,&nbsp;SQL&nbsp;Message&nbsp;&lt;3211&gt;&lt;[Microsoft][SQL&nbsp;Server&nbsp;Native&nbsp;Client&nbsp;11.0][SQL&nbsp;Server]50&nbsp;percent&nbsp;processed.&gt;.26/12/2020&nbsp;11:15:24&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;ODBC&nbsp;return&nbsp;code&nbsp;&lt;2&gt;,&nbsp;SQL&nbsp;State&nbsp;&lt;01000&gt;,&nbsp;SQL&nbsp;Message&nbsp;&lt;3211&gt;&lt;[Microsoft][SQL&nbsp;Server&nbsp;Native&nbsp;Client&nbsp;11.0][SQL&nbsp;Server]60&nbsp;percent&nbsp;processed.&gt;.26/12/2020&nbsp;11:15:40&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;ODBC&nbsp;return&nbsp;code&nbsp;&lt;2&gt;,&nbsp;SQL&nbsp;State&nbsp;&lt;01000&gt;,&nbsp;SQL&nbsp;Message&nbsp;&lt;3211&gt;&lt;[Microsoft][SQL&nbsp;Server&nbsp;Native&nbsp;Client&nbsp;11.0][SQL&nbsp;Server]70&nbsp;percent&nbsp;processed.&gt;.26/12/2020&nbsp;11:15:46&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;ODBC&nbsp;return&nbsp;code&nbsp;&lt;2&gt;,&nbsp;SQL&nbsp;State&nbsp;&lt;01000&gt;,&nbsp;SQL&nbsp;Message&nbsp;&lt;3211&gt;&lt;[Microsoft][SQL&nbsp;Server&nbsp;Native&nbsp;Client&nbsp;11.0][SQL&nbsp;Server]80&nbsp;percent&nbsp;processed.&gt;.26/12/2020&nbsp;11:16:08&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;ODBC&nbsp;return&nbsp;code&nbsp;&lt;2&gt;,&nbsp;SQL&nbsp;State&nbsp;&lt;01000&gt;,&nbsp;SQL&nbsp;Message&nbsp;&lt;3211&gt;&lt;[Microsoft][SQL&nbsp;Server&nbsp;Native&nbsp;Client&nbsp;11.0][SQL&nbsp;Server]90&nbsp;percent&nbsp;processed.&gt;.26/12/2020&nbsp;11:16:19&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;Thread&nbsp;has&nbsp;been&nbsp;closed&nbsp;for&nbsp;stripe&nbsp;#026/12/2020&nbsp;11:16:27&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;OPERATION&nbsp;#10&nbsp;of&nbsp;batch&nbsp;C:\Program&nbsp;Files\Veritas\NetBackup\DbExt\MsSql\fullmensal_backup.bch&nbsp;SUCCEEDED&nbsp;with&nbsp;STATUS&nbsp;0&nbsp;(0&nbsp;is&nbsp;normal).&nbsp;Elapsed&nbsp;time&nbsp;=&nbsp;164(145)&nbsp;seconds26/12/2020&nbsp;11:16:29&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;Results&nbsp;of&nbsp;executing&nbsp;&lt;C:\Program&nbsp;Files\Veritas\NetBackup\DbExt\MsSql\fullmensal_backup.bch&gt;:&nbsp;26/12/2020&nbsp;11:16:29&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;&lt;9&gt;&nbsp;operations&nbsp;succeeded.&nbsp;&lt;1&gt;&nbsp;operations&nbsp;failed.26/12/2020&nbsp;11:16:29&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;The&nbsp;following&nbsp;object(s)&nbsp;were&nbsp;not&nbsp;backed&nbsp;up&nbsp;successfully.26/12/2020&nbsp;11:16:29&nbsp;-&nbsp;Info&nbsp;dbclient&nbsp;(pid=13780)&nbsp;INF&nbsp;-&nbsp;DM_C326/12/2020&nbsp;11:16:50&nbsp;-&nbsp;Error&nbsp;bpbrm&nbsp;(pid=21196)&nbsp;from&nbsp;client&nbsp;server_db:&nbsp;ERR&nbsp;-&nbsp;command&nbsp;failed:&nbsp;the&nbsp;requested&nbsp;operation&nbsp;was&nbsp;partially&nbsp;successful&nbsp;(1)26/12/2020&nbsp;11:16:50&nbsp;-&nbsp;Error&nbsp;bpbrm&nbsp;(pid=21196)&nbsp;from&nbsp;client&nbsp;server_db:&nbsp;ERR&nbsp;-&nbsp;bphdb&nbsp;exit&nbsp;status&nbsp;=&nbsp;1:&nbsp;the&nbsp;requested&nbsp;operation&nbsp;was&nbsp;partially&nbsp;successful26/12/2020&nbsp;11:16:50&nbsp;-&nbsp;Info&nbsp;bpbrm&nbsp;(pid=21196)&nbsp;validating&nbsp;image&nbsp;for&nbsp;client&nbsp;server_db26/12/2020&nbsp;11:16:54&nbsp;-&nbsp;Error&nbsp;bpbrm&nbsp;(pid=21196)&nbsp;cannot&nbsp;send&nbsp;mail&nbsp;26/12/2020&nbsp;11:16:54&nbsp;-&nbsp;Info&nbsp;bphdb&nbsp;(pid=9452)&nbsp;done.&nbsp;status:&nbsp;1:&nbsp;the&nbsp;requested&nbsp;operation&nbsp;was&nbsp;partially&nbsp;successful26/12/2020&nbsp;11:16:54&nbsp;-&nbsp;end&nbsp;writingThe&nbsp;requested&nbsp;operation&nbsp;was&nbsp;partially&nbsp;successful&nbsp; (1)

marianne · Answer

Eduardo_Aguiar&nbsp;
According to Job Details, there were 10 'objects'. 9 were successful, 1 failed :
&lt;9&gt; operations succeeded. &lt;1&gt; operations failed.
26/12/2020 11:16:29 - Info dbclient (pid=13780) INF - The following object(s) were not backed up successfully.
26/12/2020 11:16:29 - Info dbclient (pid=13780) INF - DM_C3
There should be more info about DM_C3. Maybe backup for this db ran in another stream? Do you have dbclient log folder on the SQL Client? If not, please create the folder, set logging level to 3 and retry the backup. (Best to have logging level on the client set to 3 for SQL backup or restore failures.)
Please copy the log to dbclient.txt and upload as attachment.

l_br · Answer

On master server:Host Properties &gt; Client Properties &gt; Select the clientSelect Logging from the left hand panel and change the DB Logging to 3.&nbsp;On the client go to &lt;install path&gt;\Netbackup\Logs and look for the folder: dbclientif it isn't there, create it and restart the NBU services on the client.

l_br · Answer

I don't believe that is the enitre job details. Please give the full details so we can see when SQL returns the info to Netbackup.Also provide the child job details for that DB's backup.

marianne · Answer

To change logging level, open Host Properties on the master. Choose Clients, then double-click this SQL Client name to open the Client's Properties. Under Logging, change Global logging to 3. (Details about Host Properties in chapter 3 of NBU Admin Guide I.)
The dbclient process runs on the SQL client, so, this is where the folder needs to be created under &lt;install-path&gt;
etbackup\logs\. (Details in Troubleshooting chapter of NBU for SQL Admin Guide)

eduardo_aguiar · Answer

Marianne&nbsp;Hello Marianne,Thanks for answer. How setting log level 3?This folder I create in server client of SQL?

Forum Discussion

SQL The requested operation was partially successful (1)

Related Content

The requested operation was partially successful (1)

the requested operation was partially successful(1)

ERR - bphdb exit status = 1: the requested operation was partially successful

the requested operation was partially successful(1)

Restore done with Status Code (1) the requested operation was partially successful

Recent Discussions

How to add a Oracle RAC instance with #nboracmd to 10.4

Orace RAC credentials validation is failing

Netbackup Puredisk?

Installing a New Media Server and Transferring the Media Server Role

NetBackup for VMware: Exclude deleted blocks