ADSM-L

[ADSM-L] TDP SQL backup fails but is reported as a success ??

2017-01-18 17:52:52
Subject: [ADSM-L] TDP SQL backup fails but is reported as a success ??
From: Tom Alverson <tom.alverson AT GMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 18 Jan 2017 17:52:05 -0500
I periodically have an SQL backup fail but the scheduler reports that it
was a success so I never get a failure ticket (the database admin complains
about the lack of a backup).  Here you can see I get the ACO5436E error
with RC=-50 which there is almost no hit for on an internet search.  Here
you can see the error and the fact that only 6 of the 11 databases were
successful yet the scheduler has a return code of 0.  This issue happens
intermittently on many of our SQL backups.

Backup Log:
01/17/2017 01:10:28 ANS1017E (RC-50)  Session rejected: TCP/IP connection
failure.

01/17/2017 01:10:28 ACO5436E A failure occurred on stripe number (0), rc =
-50

01/17/2017 01:10:28 ANS1017E (RC-50)  Session rejected: TCP/IP connection
failure.

01/17/2017 01:10:28 Backup of VCM failed.

01/17/2017 01:10:28 ANS1017E (RC-50)  Session rejected: TCP/IP connection
failure.

01/17/2017 01:10:28 Total SQL backups selected:               11

01/17/2017 01:10:28 Total SQL backups attempted:              11

01/17/2017 01:10:28 Total SQL backups completed:              6

01/17/2017 01:10:28 Total SQL backups excluded:               0

01/17/2017 01:10:28 Total SQL backups inactivated:            0

01/17/2017 01:10:28 Total SQL backups deduplicated:           0





Schedule Log:

01/18/2017 01:20:34

Executing scheduled command now.

01/18/2017 01:20:41 Node Name: servername_SQL

01/18/2017 01:20:41 Session established with server storageserver: AIX

01/18/2017 01:20:41   Server Version 6, Release 3, Level 5.100

01/18/2017 01:20:41   Data compression forced off by the server

01/18/2017 01:20:41   Server date/time: 01/18/2017 01:20:41  Last access:
01/18/2017 01:10:33

01/18/2017 01:20:42

Executing Operating System command or script:

   C:\TSM\TDP\SQLFULL.bat

01/18/2017 01:40:36 Finished command.  Return code is: 0

01/18/2017 01:40:36 ANS1908I The scheduled command completed successfully.

01/18/2017 01:40:36 Scheduled event 'TDP_1AM' completed successfully.

01/18/2017 01:40:36 Sending results for scheduled event 'TDP_1AM'.

01/18/2017 01:40:37 Results sent to server for scheduled event 'TDP_1AM'.