TPT script getting stuck very initially (not able to find the TD slots)

Database
Enthusiast

TPT script getting stuck very initially (not able to find the TD slots)

Hi All,

When i run below TPT script, it gets stuck very initially...

DEFINE JOB LOAD_APP_TYPE_TEMP

DESCRIPTION 'MOVE DATA FROM source to target'

(

        /*** Schema Definition ***/

   DEFINE SCHEMA source_MIDB

   DESCRIPTION 'Structure of table APP_TYPE_TEMP'

   (

        LANG_TP_CD1 VARCHAR(20) ,

        APP_TP_cd1 VARCHAR(20) ,

        NAME1          VARCHAR(50),

   );

   /*** Export Operator Definition ***/

   DEFINE OPERATOR EXPORT_OPERATOR

   DESCRIPTION 'TERADATA PARALLEL TRANSPORTER EXPORT OPERATOR'

   TYPE EXPORT

   SCHEMA source_MIDB

   ATTRIBUTES

   (

      VARCHAR PrivateLogName = 'exportoper_privatelog',

      INTEGER MaxSessions    =  16,

      INTEGER MinSessions,

      VARCHAR TdpId          = 'DWSANA',

      VARCHAR UserName       = 'AAA',

      VARCHAR UserPassword   = 'Animal12',

      VARCHAR SelectStmt     = 'select * from source_MIDB.Application_Type_bck;'

   );

   /*** Load Operator Definition ***/

   DEFINE OPERATOR LOAD_OPERATOR

   DESCRIPTION 'TERADATA PARALLEL TRANSPORTER LOAD OPERATOR'

   TYPE LOAD

   SCHEMA U_CLOUDIT_MIDB

   ATTRIBUTES

   (

      VARCHAR PrivateLogName = 'loadoper_privatelog',

      INTEGER MaxSessions    = 16,

      INTEGER MinSessions,

      VARCHAR TargetTable    = 'source_MIDB.App_Type_temp',

      vARCHAR TdpId          = 'DWSANA',

      VARCHAR UserName       = 'AAA',

      VARCHAR UserPassword   = 'Animal12',

      VARCHAR ErrorTable1    = 'source_MIDB.LOADOPER_ERRTABLE1',

      VARCHAR ErrorTable2    = 'source_MIDB.LOADOPER_ERRTABLE2',

      VARCHAR LogTable       = 'source_MIDB.LOADOPER_LOGTABLE'

   );

   /*** Apply Statement ***/

   APPLY

   ('INSERT INTO source_MIDB.App_Type_temp (:LANG_TP_CD1,:APP_TP_CD1,:NAME1 );')

   TO OPERATOR (LOAD_OPERATOR [4])

   SELECT * FROM OPERATOR (EXPORT_OPERATOR [4]);

);

below is the message which i get when i run it..  please let me know if any information required

please advise...

whbit@tide:/bitest/TPT_SCRIPTS:$ tbuild -f tpt_load1  LOAD_APP_TYPE_TEMP

Teradata Parallel Transporter Version 14.00.00.10

Job log: /opt/teradata/client/14.00/tbuild/logs/LOAD_APP_TYPE_TEMP-68.out

Job id is LOAD_APP_TYPE_TEMP-68, running on tide1a08

Teradata Parallel Transporter Load Operator Version 14.00.00.10

LOAD_OPERATOR: private log specified: loadoper_privatelog

Teradata Parallel Transporter Export Operator Version 14.00.00.10

EXPORT_OPERATOR: private log specified: exportoper_privatelog

LOAD_OPERATOR: connecting sessions

EXPORT_OPERATOR: connecting sessions