1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link 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 message will disappear after you have made at least 12 posts. Thank you for your cooperation.

TDP_SQL_DIARIO_INC' failed. Return code = 402

Discussion in 'Backup / Archive Discussion' started by pechitoazul, Jun 16, 2007.

  1. pechitoazul

    pechitoazul New Member

    Joined:
    Jun 16, 2007
    Messages:
    1
    Likes Received:
    0
    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.  
  3. cheffern

    cheffern Senior Member

    Joined:
    Mar 9, 2005
    Messages:
    1,004
    Likes Received:
    7
    Occupation:
    TSM Admin / Database & SAP Admin
    Location:
    Massachusetts, USA
    What does your TDP SQL .opt file look like -
    And what is in this sqllog.cmd file?

    Please paste both here.
    -Chef.
     
    Last edited: Jun 16, 2007
  4. lark1964

    lark1964 New Member

    Joined:
    Sep 18, 2006
    Messages:
    3
    Likes Received:
    0
    Occupation:
    TSM / Oracle / SQL Server
    Location:
    Philadelphia, PA
    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.
     
  5. TIVADMIN

    TIVADMIN New Member

    Joined:
    Mar 22, 2007
    Messages:
    7
    Likes Received:
    0
    Occupation:
    Systems Administrator
    Location:
    Brooklyn, NY
    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
     
  6. luisvidal

    luisvidal New Member

    Joined:
    Feb 6, 2006
    Messages:
    111
    Likes Received:
    0
    Occupation:
    TSM Administrator
    Location:
    Miami, FL, USA
    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.
     
  7. TIVADMIN

    TIVADMIN New Member

    Joined:
    Mar 22, 2007
    Messages:
    7
    Likes Received:
    0
    Occupation:
    Systems Administrator
    Location:
    Brooklyn, NY
    No my server is not in VMWare.
    This is a stand alone server.
     
  8. rore

    rore Senior Member

    Joined:
    Nov 27, 2005
    Messages:
    642
    Likes Received:
    15
    Occupation:
    SysAdmin
    Location:
    Montreal, CA
    Hi there,
    Pls post the last lines of your sqlfull.log and sqlsched.log files.
     
: tdp

Share This Page