• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

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

sapadaps

Active Newcomer
#1
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
 

Harry_Redl

Moderator
ADSM.ORG Moderator
#2
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
 

sapadaps

Active Newcomer
#3
Hi Harry :

which log do you need ?

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

sapadaps

Active Newcomer
#5

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
 

sapadaps

Active Newcomer
#7
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
 

THE_WIPET

ADSM.ORG Senior Member
#8
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
 

Harry_Redl

Moderator
ADSM.ORG Moderator
#9
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
 

sapadaps

Active Newcomer
#10
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 !
 

Harry_Redl

Moderator
ADSM.ORG Moderator
#11
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
 

sapadaps

Active Newcomer
#12
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
"


 

Harry_Redl

Moderator
ADSM.ORG Moderator
#13
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
 

Harry_Redl

Moderator
ADSM.ORG Moderator
#16
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
 

sapadaps

Active Newcomer
#17
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
 

Harry_Redl

Moderator
ADSM.ORG Moderator
#18
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
 

sapadaps

Active Newcomer
#19
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)
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 14 17.3%
  • Keep using TSM for Spectrum Protect.

    Votes: 51 63.0%
  • Let's be formal and just say Spectrum Protect

    Votes: 9 11.1%
  • Other (please comement)

    Votes: 7 8.6%

Forum statistics

Threads
31,381
Messages
133,669
Members
21,495
Latest member
patbel
Top