BIG PROBLEM : ANS1512E Scheduled event 'SQL_DIFF' failed. Return code = 1.

sapadaps

Active Newcomer
Joined
Aug 6, 2010
Messages
17
Reaction score
0
Points
0
PREDATAR Control23

Hi Everybody,

I have a BIG Problem, all my SQL node crash and i have the same error for all nodes :

02/14/2011 23:01:19 ANS1909E The scheduled command failed.
02/14/2011 23:01:19 ANS1512E Scheduled event 'SQL_DIFF' failed. Return code = 1.

Q sched sql sql_diff maybe could help you to help me :)

Domain * Schedule Name Action Start Date/Time Duration Period Day
------------ - ---------------- ------ -------------------- -------- ------ ---
SQL SQL_DIFF CMD 12/08/2009 23:00:00 30 M (*)
ANR2662I (*) "Query schedule format=standard" displays an asterisk in the day
of week column for enhanced schedules. The period column is blank. Issue
"query schedule format=detailed" to display complete information about an
enhanced schedule.


Do you have any suggestions ?

thanks
 
PREDATAR Control23

Hi,

first thing - log to the nodes check the logs for the TDP clients (you can post it here) and try to run the script mentioned in
q sched sql sql_diff f=d

Harry
 
PREDATAR Control23

Hi Harry :

which log do you need ?

When i try to run the .cmd nothing is happening ... a dos prompt appears and disapears immediatly.
 
PREDATAR Control23


rem ==================================================================
rem Replace "C:" with the drive where Data Protection for SQL
rem is installed. Update the directory to match the installation
rem directory that you chose when you installed the product.
rem ==================================================================

set sql_dir=C:\Progra~1\Tivoli\TSM\TDPSql
set tdp_dir=F:\TDP_SQL
F:

cd %tdp_dir%

rem ==================================================================
rem The two lines below put a date/time stamp in a log file for you.
rem Note: You can change "sqlsched.log" to whatever you prefer in
rem lines below.
rem ==================================================================

date < NUL >> %sql_dir%\sqlsched.log
time < NUL >> %sql_dir%\sqlsched.log

rem ==================================================================
rem Now call the command-line interface to do the backup:
rem
rem Replace "srvrname" with the name of the options file name you
rem plan to use.
rem
rem If SQL authentication is being used and the SQL login settings have
rem not been stored via the GUI, you must also specify the /sqluser and
rem /sqlpassword options on the command below.
rem
rem In this example, we use the '*' to back up all of the databases
rem on the SQL server. Note that database 'tempdb' will not
rem be backed up.
rem
rem Note: You can change "sqlsched.log" and "sqlfull.log" to
rem whatever you prefer.
rem ==================================================================

%sql_dir%\tdpsqlc backup * diff /tsmoptfile=%tdp_dir%\dsm.opt /logfile=%tdp_dir%\sqldiff.log
 
PREDATAR Control23

Hi,

tdp_dir=F:\TDP_SQL
/logfile=%tdp_dir%\sqldiff.log
=> show us F:\TDP_SQL\sqldiff.log

Harry
 
PREDATAR Control23

the last entry is 04.10.2010....


03.10.2010 23:00:31 ============== Log file pruned using log retention period of 60 day(s)
03.10.2010 23:00:31 ============== 130 out of 1571 entries pruned from the top of this log
03.10.2010 23:00:31 =========================================================================
03.10.2010 23:00:32 =========================================================================
03.10.2010 23:00:32 Request : DIFF BACKUP
03.10.2010 23:00:32 Database Input List : *
03.10.2010 23:00:32 Group Input List : -
03.10.2010 23:00:32 File Input List : -
03.10.2010 23:00:32 Number of Buffers : 3
03.10.2010 23:00:32 Buffer Size : 1024
03.10.2010 23:00:32 Number of SQL Buffers : 0
03.10.2010 23:00:32 SQL Buffer Size : 1024
03.10.2010 23:00:32 Number of Stripes specified : 4
03.10.2010 23:00:32 Estimate : 20
03.10.2010 23:00:32 Truncate Log? : -
03.10.2010 23:00:32 Wait for Tape Mounts? : Yes
03.10.2010 23:00:32 TSM Options File : F:\TDP_SQL\dsm.opt
03.10.2010 23:00:32 TSM Nodename Override : -
03.10.2010 23:00:32 Sqlserver : LUCINA\SQL2K8CLUSTER1
03.10.2010 23:00:32
03.10.2010 23:01:37 Total SQL backups selected: 30
03.10.2010 23:01:37 Total SQL backups attempted: 29
03.10.2010 23:01:37 Total SQL backups completed: 29
03.10.2010 23:01:37 Total SQL backups excluded: 1
03.10.2010 23:01:37 Throughput rate: 2,597.45 Kb/Sec
03.10.2010 23:01:37 Total bytes transferred: 159,797,440
03.10.2010 23:01:37 Elapsed processing time: 60.08 Secs
04.10.2010 23:00:42 ============== Log file pruned using log retention period of 60 day(s)
04.10.2010 23:00:42 ============== No log entries pruned
04.10.2010 23:00:43 =========================================================================
04.10.2010 23:00:43 =========================================================================
04.10.2010 23:00:43 Request : DIFF BACKUP
04.10.2010 23:00:43 Database Input List : *
04.10.2010 23:00:43 Group Input List : -
04.10.2010 23:00:43 File Input List : -
04.10.2010 23:00:43 Number of Buffers : 3
04.10.2010 23:00:43 Buffer Size : 1024
04.10.2010 23:00:43 Number of SQL Buffers : 0
04.10.2010 23:00:43 SQL Buffer Size : 1024
04.10.2010 23:00:43 Number of Stripes specified : 4
04.10.2010 23:00:43 Estimate : 20
04.10.2010 23:00:43 Truncate Log? : -
04.10.2010 23:00:43 Wait for Tape Mounts? : Yes
04.10.2010 23:00:43 TSM Options File : F:\TDP_SQL\dsm.opt
04.10.2010 23:00:43 TSM Nodename Override : -
04.10.2010 23:00:43 Sqlserver : LUCINA\SQL2K8CLUSTER1
04.10.2010 23:00:43
04.10.2010 23:02:04 Total SQL backups selected: 30
04.10.2010 23:02:04 Total SQL backups attempted: 29
04.10.2010 23:02:04 Total SQL backups completed: 29
04.10.2010 23:02:04 Total SQL backups excluded: 1
04.10.2010 23:02:04 Throughput rate: 7,178.71 Kb/Sec
04.10.2010 23:02:04 Total bytes transferred: 564,850,880
04.10.2010 23:02:04 Elapsed processing time: 76.84 Secs
 
PREDATAR Control23

i hope you have more info.. cause this say that your last backup was the 4th october 2010?? Did you post the last entry from your log files?

I would add that the server is cluster (03.10.2010 23:00:32 Sqlserver : LUCINA\SQL2K8CLUSTER1)

Look at you other cluster (Cluster2) maybe it did a failedover so post your log from the SQL2K8Cluster2

Should be at the same place
 
PREDATAR Control23

Hi,

Try to run
C:\Progra~1\Tivoli\TSM\TDPSql\tdpsqlc backup * diff /tsmoptfile=F:\TDP_SQL\dsm.opt

and show us the content of F:\TDP_SQL\dsm.opt

When did this backup started to fail? Check that cluster as THE_WIPET suggested ...

Harry
 
PREDATAR Control23

Hi Harry,

When I launch the command the backup crash

ANS1017E (RC-50) Session rejected: TCP/IP connection failure

If i launch the backup by the GUI is work !
 
PREDATAR Control23

Hi,

show us the F:\TDP_SQL\dsm.opt
If you say GUI backup works then it seems to me there are two different dsm.opt files - one used by GUI and second F:\TDP_SQL\dsm.opt
It may point to wrong IP/name of the TSM server or can have other communication options wrong.
What TSM server says in the activity log (q act) in the moment you are trying to run the backup from the command line?

Harry
 
PREDATAR Control23

Hi Harry !

I found the error on my dsm.opt stored in c:\program files\tivoli\tsm\tdpsql\dsm.opt they was an error on the server option... but i don't understand.

Why there is a tdp_sql in c and an other one in F ?

In another node i have always the same error and both of dsm.opt the server option is right.

the message :

ANS1017E (RC-50) Session rejected: TCP/IP connection failure

"*======================================================================*
* *
* IBM Tivoli Storage Manager for Databases *
* *
* Data Protection for Microsoft SQL Server *
* *
* Sample Options File *
* *
*======================================================================*

NODename DIANA_SQL
CLUSTERnode YES
PASSWORDAccess Generate

*======================================================================*
* TCP/IP Communication Options *
*======================================================================*
COMMMethod TCPip
TCPServeraddress artemis.iruworld.org
TCPPort 1500
TCPWindowsize 63
TCPBuffSize 32

*======================================================================*
* Named Pipes Communication Options *
*======================================================================*
*COMMMethod NAMEdpipe
*NAMedpipename \\.\pipe\tsmpipe

*======================================================================*
* - Compression Options *
* *
* Use the "COMPRESSION" option to compress the data before sending *
* it to the IBM Tivoli Storage Manager server. Use the *
* "COMPRESSALWAYS" option to specify whether to continue compressing *
* the data if it grows during compression. *
* *
*======================================================================*
*COMPRESSIon NO
*COMPRESSAlways NO

*======================================================================*
* *
* - Scheduling Options *
* *
* The default scheduling mode is the client polling method. *
* To use server prompted scheduling, you must be sure to use a tcp *
* client port different than the one used by the regular backup *
* client. *
* *
*======================================================================*
SCHEDMODE Polling
*SCHEDLOGRetention 14
*SCHEDMODE Prompted
*TCPCLIENTADDRESS yy.yy.yy.yy
*TCPCLIENTPORT 1502

*======================================================================*
* Include/Exclude Processing *
* *
* For a more complete description of include/exclude processing refer *
* to the Data Protection for Microsoft SQL Server Installation and *
* User's Guide. *
*======================================================================*

*======================================================================*
* The following include statements assign all meta objects to *
* management class SqlDbMetaMgmtClass and all data objects to *
* SqlDbDataMgmtClass *
*======================================================================*
*INCLUDE "\...\meta\...\*" SqlDbMetaMgmtClass
*INCLUDE "\...\data\...\*" SqlDbDataMgmtClass

*======================================================================*
* The following include statements assign all log meta objects to *
* management class SqlLogMetaMgmtClass and all log data objects to *
* SqlLogDataMgmtClass *
*======================================================================*
*INCLUDE "\...\meta\...\log*" SqlLogMetaMgmtClass
*INCLUDE "\...\data\...\log*" SqlLogDataMgmtClass

*======================================================================*
* The following exclude statements exclude all log backups for *
* databases master and msdb *
*======================================================================*
*EXCLUDE "\...\master\...\log*"
*EXCLUDE "\...\msdb\...\log*"

*======================================================================*
* The following exclude statement excludes the "db1" database *
* from being compressed (if compression is enabled for backups.) *
*======================================================================*
*EXCLUDE.COMPRESSION "\...\db1\...\*"

HTTPPORT 1582
MANAGEDSERVICES WEBCLIENT SCHEDULE
"


 
PREDATAR Control23

Hi,

what dsm.opt have you posted? Is this one from F: or C: ? Getting lost ....
is this correct?

NODename DIANA_SQL
TCPServeraddress artemis.iruworld.org
TCPPort 1500

Does the client try to connect to the right server? Have to see the activity log of the server to find if:
a) there is an inbound connection
b) if it is there, why it is rejected

Harry
 
PREDATAR Control23

Yes is the one on C:

Yes the right server is Artemis.iruworld.org
 
PREDATAR Control23

Hi Harry,

maybe the problem is the password ? we need to specify the password on the dsm.opt ?

thanks
 
PREDATAR Control23

Hi,

your .cmd script uses the dsm.opt file from F: - I have to see it.
If it is password issue, then I need to see the activity log part from the server (asking for it for ... 3rd time?) - there should be "Authentication failure" message in it.

Harry
 
PREDATAR Control23

Hi Mark,

I have this error on TSMManager :

ANR2579E Schedule schedule name in domain domain name for node node
name failed (return code return code).

Explanation: This message is displayed when a client reports failure in
executing a scheduled action. The return code reported by the client is
displayed.

System action: Server operation continues.

User response: Examine the node's schedule log to determine the cause
for the failure.


I have this error for all SQL Backup
 
PREDATAR Control23

Hi,

I need the dsm.opt from F:, and the activity log part "q act" output - not just single message - need to see the session started, error message from the session and then the information about failed schedule - all the messages from start to end.

Harry
 
PREDATAR Control23

Hi,

DSM.OPT :


NODename lucina_SQL
CLUSTERnode yes
PASSWORDAccess Generate

*======================================================================*
* TCP/IP Communication Options *
*======================================================================*
COMMMethod TCPip
TCPServeraddress artemis.iruworld.org
TCPPort 1500
TCPWindowsize 63
TCPBuffSize 32

*======================================================================*
* Named Pipes Communication Options *
*======================================================================*
*COMMMethod NAMEdpipe
*NAMedpipename \\.\pipe\tsmpipe

*======================================================================*
* - Compression Options *
* *
* Use the "COMPRESSION" option to compress the data before sending *
* it to the IBM Tivoli Storage Manager server. Use the *
* "COMPRESSALWAYS" option to specify whether to continue compressing *
* the data if it grows during compression. *
* *
*======================================================================*
*COMPRESSIon NO
*COMPRESSAlways NO

*======================================================================*
* *
* - Scheduling Options *
* *
* The default scheduling mode is the client polling method. *
* To use server prompted scheduling, you must be sure to use a tcp *
* client port different than the one used by the regular backup *
* client. *
* *
*======================================================================*
SCHEDMODE Polling
*SCHEDLOGRetention 14
*SCHEDMODE Prompted
*TCPCLIENTADDRESS yy.yy.yy.yy
*TCPCLIENTPORT 1502

*======================================================================*
* Include/Exclude Processing *
* *
* For a more complete description of include/exclude processing refer *
* to the Data Protection for Microsoft SQL Server Installation and *
* User's Guide. *
*======================================================================*

*======================================================================*
* The following include statements assign all meta objects to *
* management class SqlDbMetaMgmtClass and all data objects to *
* SqlDbDataMgmtClass *
*======================================================================*
*INCLUDE "\...\meta\...\*" SqlDbMetaMgmtClass
*INCLUDE "\...\data\...\*" SqlDbDataMgmtClass

*======================================================================*
* The following include statements assign all log meta objects to *
* management class SqlLogMetaMgmtClass and all log data objects to *
* SqlLogDataMgmtClass *
*======================================================================*
*INCLUDE "\...\meta\...\log*" SqlLogMetaMgmtClass
*INCLUDE "\...\data\...\log*" SqlLogDataMgmtClass

*======================================================================*
* The following exclude statements exclude all log backups for *
* databases master and msdb *
*======================================================================*
*EXCLUDE "\...\master\...\log*"
*EXCLUDE "\...\msdb\...\log*"

*======================================================================*
* The following exclude statement excludes the "db1" database *
* from being compressed (if compression is enabled for backups.) *
*======================================================================*
*EXCLUDE.COMPRESSION "\...\db1\...\*"

all msg actlog from 18.02.2011 to 19.02.2011 concerning node lucina :

02/18/2011 23:00:57 ANR0406I Session 4646 started for node LUCINA_SQL (WinNT)
(Tcp/Ip bhairavi.iruworld.org(52442)). (SESSION: 4646)
02/18/2011 23:00:57 ANR0403I Session 4646 ended for node LUCINA_SQL (WinNT).
(SESSION: 4646)
02/18/2011 23:03:59 ANR0406I Session 4656 started for node LUCINA_SQL (WinNT)
(Tcp/Ip bhairavi.iruworld.org(52577)). (SESSION: 4656)
02/18/2011 23:03:59 ANR2579E Schedule SQL_DIFF in domain SQL for node
LUCINA_SQL failed (return code 1). (SESSION: 4656)
02/18/2011 23:03:59 ANR0403I Session 4656 ended for node LUCINA_SQL (WinNT).
(SESSION: 4656)
02/18/2011 23:03:59 ANR0406I Session 4657 started for node LUCINA_SQL (WinNT)
(Tcp/Ip bhairavi.iruworld.org(52578)). (SESSION: 4657)
02/18/2011 23:03:59 ANR0403I Session 4657 ended for node LUCINA_SQL (WinNT).
(SESSION: 4657)
02/19/2011 09:06:04 ANR2017I Administrator TSMM issued command: select
entity,activity,sum(bytes),sum(end_time-start_time),sum(-
affected),sum(failed),sum(mediaw) from summary where
entity like 'LUCINA_SQL%' and
start_time>(current_timestamp-1 day) group by
entity,activity (SESSION: 5535)
02/19/2011 11:03:59 ANR0406I Session 5742 started for node LUCINA_SQL (WinNT)
(Tcp/Ip bhairavi.iruworld.org(64933)). (SESSION: 5742)
02/19/2011 11:03:59 ANR0403I Session 5742 ended for node LUCINA_SQL (WinNT).
(SESSION: 5742)
02/19/2011 11:58:14 ANR0406I Session 5817 started for node LUCINA_SQL (WinNT)
(Tcp/Ip bhagavati.iruworld.org(49687)). (SESSION: 5817)
02/19/2011 11:58:14 ANR1639I Attributes changed for node LUCINA_SQL: TCP Name
from BHAIRAVI to BHAGAVATI, TCP Address from 172.25.13.29
to 172.25.13.26, GUID from 62.e0.01.61.e4.14.11.de.ab.78-
.00.15.17.6d.03.24 to 9a.3e.33.20.e4.14.11.de.b1.54.00.1-
5.17.6d.4d.f8. (SESSION: 5817)
02/19/2011 11:58:14 ANR0403I Session 5817 ended for node LUCINA_SQL (WinNT).
(SESSION: 5817)
02/19/2011 11:58:16 ANR0406I Session 5818 started for node LUCINA_SQL (WinNT)
(Tcp/Ip bhagavati.iruworld.org(49692)). (SESSION: 5818)
02/19/2011 11:58:16 ANR0403I Session 5818 ended for node LUCINA_SQL (WinNT).
(SESSION: 5818)
 
Top