Results 1 to 7 of 7
  1. #1
    Newcomer
    Join Date
    Jun 2007
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default TDP_SQL_DIARIO_INC' failed. Return code = 402

    Hello i have the problem.
    help me!!!!

    Executing Operating System command or script:
    d:\servicio\tivoli\tsm\tdpsql\sqllog.cmd
    06/16/2007 07:00:32 Finished command. Return code is: 402
    06/16/2007 07:00:32 ANS1909E The scheduled command failed.
    06/16/2007 07:00:32 ANS1512E Scheduled event 'TDP_SQL_DIARIO_INC' failed. Return code = 402.
    06/16/2007 07:00:32 Sending results for scheduled event 'TDP_SQL_DIARIO_INC'.
    06/16/2007 07:00:33 Results sent to server for scheduled event 'TDP_SQL_DIARIO_INC'.

    06/16/2007 07:00:33 Querying server for next scheduled event.
    06/16/2007 07:00:33 Node Name: LD_QTOW01
    06/16/2007 07:00:33 Session established with server PECOM85_SERVER4: Windows
    06/16/2007 07:00:33 Server Version 5, Release 2, Level 6.0
    06/16/2007 07:00:33 Server date/time: 06/16/2007 07:00:32 Last access: 06/16/2007 07:00:06

  2. #2
    Senior Member cheffern's Avatar
    Join Date
    Mar 2005
    Location
    Massachusetts, USA
    Posts
    1,000
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Default

    What does your TDP SQL .opt file look like -
    And what is in this sqllog.cmd file?

    Please paste both here.
    -Chef.
    Last edited by cheffern; 06-16-2007 at 08:04 PM. Reason: changed .pot to .opt - duh =)

  3. #3
    Member
    Join Date
    Sep 2006
    Location
    Philadelphia, PA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default 402 usually is a software failure

    Hi Petch - I'd see if the .dll is available on another box and copy it from there. I get that periodically when some of the other folks I work with (re: green/newbies) install a client, and they screw something up. If you can copy the .dll from another client, just do it.
    Maureen E. O\'Connor
    Private Consultant

  4. #4
    Member
    Join Date
    Mar 2007
    Location
    Brooklyn, NY
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    I get the same error every now and then.

    Here is the .opt file:
    *================================================= =====================*
    * *
    * IBM Tivoli Storage Manager for Databases *
    * *
    * Data Protection for Microsoft SQL Server *
    * *
    * Sample Options File *
    * *
    *================================================= =====================*
    NODename AT-FACET-DB03_TDP
    CLUSTERnode NO
    PASSWORDAccess Generate
    *================================================= =====================*
    * TCP/IP Communication Options *
    *================================================= =====================*
    COMMMethod TCPip
    TCPServeraddress 172.17.1.219
    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 10
    *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\...\*"

    And the SQLFULL.CMD file:
    @ECHO OFF
    rem ================================================== ================
    rem sqlfull.smp sample command file
    rem
    rem Sample command file containing commands to do a scheduled full
    rem backup of all SQL databases to an IBM Tivoli Storage Manager
    rem server.
    rem
    rem This file is meant to be executed by the IBM Tivoli Storage
    rem Manager central scheduler in response to a defined schedule on
    rem the IBM Tivoli Storage Manager server.
    rem
    rem ================================================== ================
    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
    C:
    cd %sql_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 NPITEST431,NPITEST431xc full /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqlfull.log >> %sql_dir%\sqlsched.log

    Any assistance would be greatly appreciated.

    Thanks,
    Danny

  5. #5
    Member luisvidal's Avatar
    Join Date
    Feb 2006
    Location
    Miami, FL, USA
    Posts
    111
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Are these VMware servers by any chance? These "402" errors are sometimes link to a "memory leakage" issue between TDP and VMware. I read that somewhere. I get these once in a while, but I just run the incrmental again, and works fine after that.

  6. #6
    Member
    Join Date
    Mar 2007
    Location
    Brooklyn, NY
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    No my server is not in VMWare.
    This is a stand alone server.

  7. #7
    Senior Member rore's Avatar
    Join Date
    Nov 2005
    Location
    Montreal, CA
    Posts
    637
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Default

    Hi there,
    Pls post the last lines of your sqlfull.log and sqlsched.log files.

Similar Threads

  1. ANS1512E Scheduled event 'DOMINOTEST' failed. Return code = 402
    By jcabrera in forum TDP/Application Layer Backup
    Replies: 1
    Last Post: 03-19-2007, 12:38 PM
  2. Failed backup - ANS1512E Return code = 12
    By twillia in forum Backup / Archive Discussion
    Replies: 0
    Last Post: 06-08-2006, 12:56 AM
  3. ANS1512E Scheduled event 'SCH_2300' failed. Return code = 12.
    By ramico in forum Backup / Archive Discussion
    Replies: 0
    Last Post: 01-23-2006, 04:28 PM
  4. Replies: 0
    Last Post: 03-22-2005, 10:39 AM
  5. ANS1512E Scheduled event 'DAILY' failed. Return code = 12
    By mricca in forum Backup / Archive Discussion
    Replies: 1
    Last Post: 07-13-2004, 11:44 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •