locked
get data from Teradata using SSIS RRS feed

  • Question

  • i configured odbc connection.. using that connection i was to login to terdata sql assistant and run query... but when i connect to ssis and try to pull data i get " TDWM Throttle violation for Concurrent Sessions: For Rule Name 'User Session Limit', Limit of 5 concurrent requests"

    please suggest 

    Wednesday, August 14, 2013 8:35 PM

Answers

All replies

  • Must use ADO (.Net) connection


    Arthur My Blog

    Wednesday, August 14, 2013 8:44 PM
  • This is a limit your Teradata admin has put on your login.  The simplest thing is to ask them to remove the limit. 

    However, if that is not an option, then set "RetainSameConnection"=true.  This will cause the connection to only open once.  If you want concurrent sessions, you would have to create 4 more connections and assign them to data flow tasks individually.

    Please see:

    http://munishbansal.wordpress.com/2009/04/01/how-to-retain-same-data-connection-across-multiple-tasks-in-ssis/

    • Proposed as answer by Mike Yin Tuesday, August 20, 2013 2:11 PM
    • Marked as answer by Mike Yin Thursday, August 22, 2013 2:21 PM
    Wednesday, August 14, 2013 8:48 PM
  • would like to try that   "RetainSameConnection"=true.  but how do i restart my teradata session or end the other sessions? i am unable to get thorough this error.

    • Edited by Dkuud Wednesday, August 14, 2013 9:00 PM
    Wednesday, August 14, 2013 8:59 PM
  • Hi Dkuud,

    To kill a Teradata session, you can use the Teradata Manager or use the following query:

    SELECT 
     *
    FROM 
     dbc.SessionInfoVX
    WHERE 
     UserName LIKE '%USER_NAME_HERE%'
    ;
    
    Related Random Notes
     Abort session hostno.username 
     Abort session hostno:sessionno
    
    
     syslib.AbortSessions
    
     select 
      *
     from 
      syslib
     ;

    Reference:
    http://paintingbluecode.blogspot.in/2011/09/teradata-abort-or-kill-session.html

    Regards,


    Mike Yin
    TechNet Community Support


    • Edited by Mike Yin Wednesday, August 21, 2013 8:36 AM
    • Marked as answer by Mike Yin Thursday, August 22, 2013 2:25 PM
    Wednesday, August 21, 2013 8:36 AM
  • Hi Dkuud,

    To kill a Teradata session, you can use the Teradata Manager or use the following query:

    SELECT 
     *
    FROM 
     dbc.SessionInfoVX
    WHERE 
     UserName LIKE '%USER_NAME_HERE%'
    ;
    
    Related Random Notes
     Abort session hostno.username 
     Abort session hostno:sessionno
    
    
     syslib.AbortSessions
    
     select 
      *
     from 
      syslib
     ;

    Reference:
    http://paintingbluecode.blogspot.in/2011/09/teradata-abort-or-kill-session.html

    Regards,


    Mike Yin
    TechNet Community Support


    Hi .. i was able to look into my login session .but how to kill them now? suggest please
    Thursday, September 5, 2013 9:41 PM