Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 18 Nov 2015 @ 22:04:10 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   TPT API Error: Invalid arguments passed to
 
From:   Kothari, Mahesh

Hello All,

All of our Informatica workflows which is using TPT started failing with below error: We are using oracle as source and Teradata as Target.

     [ERROR] Type:(Teradata PT API Error), Error: (Invalid arguments passed to PutBuffer)

We are using TPT load operator to load the target table for the workflow. The log file below is for one of the Informatica session which is failing.

I would appreciate If I get help on this as soon as possible . Because this is holding all our TPT jobs .


Mahesh Kothari
Sr.Consultant, Information Management

     Severity   Timestamp   Node   Thread   Message Code   Message
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   DIRECTOR   VAR_27028
                 Use override value [T43_UTLTY_CRM] for user-defined workflow/worklet variable:[$$UTLTYDATABASE].
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   DIRECTOR   VAR_27027
                 Use default value [] for mapping parameter:[$$DATASOURCE_NUM_ID].
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   DIRECTOR   VAR_27027
                 Use default value [] for mapping parameter:[$$TENANT_ID].
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   DIRECTOR   TM_6014
        Initializing session [Custom_SDE_SBL_MarketingLeadFact] at [Wed Nov 18 16:29:15 2015].
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   DIRECTOR   TM_6683
        Repository Name: [OBIEE_Sys]
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   DIRECTOR   TM_6684   Server Name: [OBIEE_Sys_IntSvc]
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   DIRECTOR   TM_6686   Folder: [Custom_Q3]
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   DIRECTOR   TM_6685
        Workflow: [Custom_SDE_SBL_MarketingLeadFact] Run Instance Name: [] Run Id: [176702]
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   DIRECTOR   TM_6101
        Mapping name: Custom_SDE_SBL_MarketingLeadFact [version 6].
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   DIRECTOR   TM_6963   Pre 85
     Timestamp Compatibility is Enabled
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   DIRECTOR   TM_6964   Date format for the Session is [MM/DD/YYYY HH24:MI:SS]
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   DIRECTOR   TM_6708   Using configuration property [OraDateToTimestamp,yes]
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   DIRECTOR   TM_6708   Using configuration property
     [LoaderControlFileDirectory,/gpfsobiee/syst/obiee/pcenterdata/ctlfiles/]
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   DIRECTOR   TM_6708   Using configuration property [ServerPort,4006]
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   DIRECTOR   TM_6708   Using configuration property [overrideMpltVarWithMapVar,yes]
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   DIRECTOR   TM_6703
        Session [Custom_SDE_SBL_MarketingLeadFact] is run by 64-bit Integration Service
     [OBIEE_Syst_Node1], version [9.0.1 HotFix2], build [1111].
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MANAGER   PETL_24058
        Running Partition Group [1].
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MANAGER   PETL_24000
        Parallel Pipeline Engine initializing.
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MANAGER   PETL_24001
        Parallel Pipeline Engine running.
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MANAGER   PETL_24003
        Initializing session run.
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   CMN_1569   Server Mode: [ASCII]
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   CMN_1570   Server Code page: [ISO 8859-1 Western European]
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TM_6151   The session sort order is [Binary].
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TM_6156   Using low precision processing.
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TM_6180
        Deadlock retry logic will not be implemented.
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TM_6187
        Session target-based commit interval is [100000].
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TPTWR_32600   [INFO]
     PowerExchange for Teradata PT Writer Plugin Version[9.0.1].
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TPTWR_33626   [INFO]
     Set Encrypt Data flag...

     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TPTWR_32603   [INFO]
     Teradata Paraller Transporter Connection and Session level attributes retrieved
     successfully.

     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TPTWR_34228
        [DEBUG] Pause Acquistion [Disabled].

     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TPTWR_35062   [INFO]
     Log table name for the target [T43_CRM_APPL_TBL.W_MKTG_LEAD_FS] is :
     [T43_UTLTY_CRM.INFA_LT_1080745398990].
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TPTWR_35063   [INFO]
     ErrorTable1 Name for the target [T43_CRM_APPL_TBL.W_MKTG_LEAD_FS] is :
     [T43_UTLTY_CRM.INFA_ET1_1080745398990].
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TPTWR_35064   [INFO]
     ErrorTable2 Name for the target [T43_CRM_APPL_TBL.W_MKTG_LEAD_FS] is :
     [T43_UTLTY_CRM.INFA_ET2_1080745398990].
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TPTWR_35065   [INFO]
     Work table name for the target [T43_CRM_APPL_TBL.W_MKTG_LEAD_FS] is :
     [T43_UTLTY_CRM.INFA_WT1080745398990].
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TPTWR_32303   [INFO]
     Target Drivers created successfully.

     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TPTWR_32301   [INFO]
     Initialized Teradata PT Writer Plug-In.

     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   SDKS_38024   Plug-
     in 315000 initialization complete.
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   SDKS_38017   Writer
     SDK plug-in intialization complete.
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TPTWR_35117   [INFO]
     Initializing TPTSyncManager for Target [1] with partitions [1] and instances [1].

     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TPTWR_32403   [INFO]
     Group Drivers created successfully.

     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TPTWR_32401   [INFO]
     Initialized Teradata PT Writer Target Driver.

     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TPTWR_32503   [INFO]
     Partition Drivers created successfully.

     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TPTWR_32501   [INFO]
     Initialized Teradata PT Writer Group Driver.

     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   SDKS_38509   SDK
     target and group initialization complete.
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TM_6307   DTM
     error log disabled.
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   TE_7022
        TShmWriter: Initialized
     INFO   11/18/2015 1:29:15 PM   OBIEE_Syst_Node1   MAPPING   DBG_21075
        Connecting to database [DataWarehouse], user [T43_CRM_APPL_UTL]
     INFO   11/18/2015 1:29:16 PM   OBIEE_Syst_Node1   MAPPING   CMN_1021
        Database driver event...
     CMN_1021 [Teradata Event Using array fetches.
     Teradata Event Using Single Row Inserts. connect string = [DWTEST2]. userid =
     [T43_CRM_APPL_UTL]
     Teradata Event Using Single Row Updates. connect string = [DWTEST2]. userid =
     [T43_CRM_APPL_UTL]
     Teradata Event Using Single Row Deletes. connect string = [DWTEST2]. userid =
     [T43_CRM_APPL_UTL]]

     INFO   11/18/2015 1:29:16 PM   OBIEE_Syst_Node1   MAPPING   TM_6007   DTM
     initialized successfully for session [Custom_SDE_SBL_MarketingLeadFact]
     INFO   11/18/2015 1:29:16 PM   OBIEE_Syst_Node1   DIRECTOR   PETL_24033   All
     DTM Connection Info: [].
     INFO   11/18/2015 1:29:16 PM   OBIEE_Syst_Node1   MANAGER   PETL_24004
        PETL_24004 Starting pre-session tasks. : (Wed Nov 18 16:29:16 2015)
     INFO   11/18/2015 1:29:16 PM   OBIEE_Syst_Node1   MANAGER   PETL_24027
        PETL_24027 Pre-session task completed successfully. : (Wed Nov 18 16:29:16 2015)
     INFO   11/18/2015 1:29:16 PM   OBIEE_Syst_Node1   DIRECTOR   PETL_24006
        Starting data movement.
     INFO   11/18/2015 1:29:16 PM   OBIEE_Syst_Node1   MAPPING   TM_6660   Total
     Buffer Pool size is 40000000 bytes and Block size is 512000 bytes.
     INFO   11/18/2015 1:29:16 PM   OBIEE_Syst_Node1   LKPDP_1   DBG_21097   Lookup
     Transformation [LKP_W_LOV_G_Retire_Reason1]: Default sql to create lookup cache: SELECT
     NAME,NAMEVAL,R_TYPE FROM W_LOV_G ORDER BY NAMEVAL,R_TYPE,NAME

     INFO   11/18/2015 1:29:16 PM   OBIEE_Syst_Node1   LKPDP_1   TE_7212
        Increasing [Index Cache] size for transformation [LKP_W_LOV_G_Retire_Reason1] from
     [1048576] to [1059840].
     INFO   11/18/2015 1:29:16 PM   OBIEE_Syst_Node1   READER_1_1_1   DBG_21438
        Reader: Source is [CRM1DEV], user [SIEBEL]
     INFO   11/18/2015 1:29:16 PM   OBIEE_Syst_Node1   READER_1_1_1   BLKR_16003
        Initialization completed successfully.
     INFO   11/18/2015 1:29:16 PM   OBIEE_Syst_Node1   WRITER_1_*_1   TPTWR_32604   [INFO]
     Table information (schema) retrieved successfully.

     INFO   11/18/2015 1:29:16 PM   OBIEE_Syst_Node1   WRITER_1_*_1   TPTWR_32605   [INFO]
     DML statements on table [T43_CRM_APPL_TBL.W_MKTG_LEAD_FS] for system operator [TD_LOAD]
     built successfully.

     INFO   11/18/2015 1:29:19 PM   OBIEE_Syst_Node1   WRITER_1_*_1   TPTWR_24514   [INFO]
     [T43_CRM_APPL_TBL.W_MKTG_LEAD_FS] Table has been Truncated.

     INFO   11/18/2015 1:29:29 PM   OBIEE_Syst_Node1   WRITER_1_*_1   TPTWR_35051   [INFO]
     Log table [T43_UTLTY_CRM.INFA_LT_1080745398990] is dropped successfully.

     INFO   11/18/2015 1:29:29 PM   OBIEE_Syst_Node1   WRITER_1_*_1   TPTWR_32601   [INFO]
     Initialized Teradata PT Writer Partition Driver.

     INFO   11/18/2015 1:29:29 PM   OBIEE_Syst_Node1   WRITER_1_*_1   WRT_8270   Target
     connection group #1 consists of target(s) [W_MKTG_LEAD_FS: Partition 1]
     INFO   11/18/2015 1:29:29 PM   OBIEE_Syst_Node1   WRITER_1_*_1   WRT_8003   Writer
     initialization complete.
     INFO   11/18/2015 1:29:29 PM   OBIEE_Syst_Node1   WRITER_1_*_1   WRT_8005   Writer
     run started.
     INFO   11/18/2015 1:29:29 PM   OBIEE_Syst_Node1   READER_1_1_1   BLKR_16007   Reader
     run started.
     INFO   11/18/2015 1:29:29 PM   OBIEE_Syst_Node1   WRITER_1_*_1   WRT_8158

     *****START LOAD SESSION*****

     Load Start Time: Wed Nov 18 16:29:28 2015

     Target tables:

          W_MKTG_LEAD_FS: Partition 1


     INFO   11/18/2015 1:29:29 PM   OBIEE_Syst_Node1   READER_1_1_1   RR_4029   SQ
     Instance [mplt_Custom_BC_SBL_MarketingLeadFact.SQ_S_LEAD] User specified SQL Query
     [SELECT /*+ FIRST_ROWS(20000) */
     S_LEAD.ROW_ID,
     S_LEAD.CREATED,
     S_LEAD.CREATED_BY,
     S_LEAD.LAST_UPD,
     S_LEAD.LAST_UPD_BY,
     S_LEAD.LEAD_NUM,
     S_LEAD.CONVERTED_TS,
     S_LEAD.LAST_ORG_ASGN_TS, S_LEAD.LAST_PSTN_ASGN_TS,
     S_LEAD.REJECTED_TS,
     S_LEAD.RETIRED_TS,
     S_LEAD.SCORE,
     S_LEAD.ACCNT_ID,
     S_LEAD.BU_ID,
     S_LEAD.CONTACT_ID,
     S_LEAD.DCP_ID,
     S_LEAD.OUTCOME_CD,
     S_LEAD.PRSP_CON_ID,
     S_LEAD.PRTNR_ORG_ID,
     S_LEAD.PR_OPTY_ID,
     S_LEAD.PR_POSTN_ID,
     S_LEAD.PR_PROD_ID,
     S_LEAD.QUALITY_CD,
     S_LEAD.REJECT_REASON_CD, S_LEAD.RETIRE_REASON_CD,
     S_COMMUNICATION.SRC_ID,
     S_LEAD.STATUS_CD,
     S_POSTN.OU_ID,
     S_POSTN.PR_EMP_ID,
     (SELECT OWNERORG.PAR_BU_ID FROM S_ORG_EXT OWNERORG WHERE S_POSTN.OU_ID =OWNERORG.ROW_ID)
     AS PR_OWNER_BU_ID,
     (SELECT S_CAMP_CON.PR_CALL_LST_ID FROM S_CAMP_CON WHERE S_LEAD.CAMP_CON_ID =
     S_CAMP_CON.ROW_ID) PR_CALL_LST_ID,
     S_SRC.REGION_ID,
     '0' AS X_CUSTOM,
     S_LEAD.X_HOT_TRNSFR_CD,
     S_LEAD.X_DISPOSITION_CODE,
     S_LEAD.X_RESP_CHAN,
     S_LEAD.X_MED_CHAN,
     S_LEAD.X_EVENTPRI_ID,
     S_LEAD.X_ROUTER_ID,
     S_LEAD.ROW_ID,
     S_LEAD.X_PRD_INTEREST,
     S_SRC.LAUNCHED_TS,
     S_LEAD.X_EVENT_ID,
     S_SRC.X_DIRECT_FLG,
     S_COMMUNICATION.COMM_DATE,
     S_COMMUNICATION.X_REF_NUM,
     (SELECT S_CONTACT.X_PRSP_CONTACT_ID FROM S_CONTACT WHERE S_LEAD.CONTACT_ID =
     S_CONTACT.ROW_ID) X_PRSP_CONTACT_ID,
     -- Added below 2 columns as part of CQ# WLPRD01127134 in Dec-14 release
     S_LEAD.X_SF_LEAD_CREATED_DT,
     S_LEAD.X_SF_RESP_CREATED_DT
     FROM
     V_LEAD S_LEAD,
     S_POSTN,
     S_SRC,
     S_COMMUNICATION
     WHERE
     {
     V_LEAD S_LEAD
     LEFT OUTER JOIN S_POSTN ON
     S_LEAD.PR_POSTN_ID = S_POSTN.ROW_ID
     LEFT OUTER JOIN S_COMMUNICATION ON
     S_LEAD.X_EVENT_ID  = S_COMMUNICATION.ROW_ID
     LEFT OUTER JOIN S_SRC ON
     S_COMMUNICATION.SRC_ID = S_SRC.ROW_ID
     }]
     INFO   11/18/2015 1:29:29 PM   OBIEE_Syst_Node1   READER_1_1_1   RR_4049
        RR_4049 SQL Query issued to database : (Wed Nov 18 16:29:29 2015)
     INFO   11/18/2015 1:29:29 PM   OBIEE_Syst_Node1   READER_1_1_1   RR_4011
        Informatica inner/outer join syntax found, SQL query converted to [SELECT
         /*+ FIRST_ROWS(20000) */ S_LEAD.ROW_ID , S_LEAD.CREATED , S_LEAD.CREATED_BY ,
     S_LEAD.LAST_UPD , S_LEAD.LAST_UPD_BY , S_LEAD.LEAD_NUM , S_LEAD.CONVERTED_TS ,
     S_LEAD.LAST_ORG_ASGN_TS , S_LEAD.LAST_PSTN_ASGN_TS , S_LEAD.REJECTED_TS ,
     S_LEAD.RETIRED_TS , S_LEAD.SCORE , S_LEAD.ACCNT_ID , S_LEAD.BU_ID , S_LEAD.CONTACT_ID ,
     S_LEAD.DCP_ID , S_LEAD.OUTCOME_CD , S_LEAD.PRSP_CON_ID , S_LEAD.PRTNR_ORG_ID ,
     S_LEAD.PR_OPTY_ID , S_LEAD.PR_POSTN_ID , S_LEAD.PR_PROD_ID , S_LEAD.QUALITY_CD ,
     S_LEAD.REJECT_REASON_CD , S_LEAD.RETIRE_REASON_CD , S_COMMUNICATION.SRC_ID ,
     S_LEAD.STATUS_CD , S_POSTN.OU_ID , S_POSTN.PR_EMP_ID , (SELECT OWNERORG.PAR_BU_ID FROM
     S_ORG_EXT OWNERORG WHERE S_POSTN.OU_ID =OWNERORG.ROW_ID) AS PR_OWNER_BU_ID , (SELECT
     S_CAMP_CON.PR_CALL_LST_ID FROM S_CAMP_CON WHERE S_LEAD.CAMP_CON_ID = S_CAMP_CON.ROW_ID)
     PR_CALL_LST_ID , S_SRC.REGION_ID , '0' AS X_CUSTOM , S_LEAD.X_HOT_TRNSFR_CD ,
     S_LEAD.X_DISPOSITION_CODE , S_LEAD.X_RESP_CHAN , S_LEAD.X_MED_CHAN , S_LEAD.X_EVENTPRI_ID
     , S_LEAD.X_ROUTER_ID , S_LEAD.ROW_ID , S_LEAD.X_PRD_INTEREST , S_SRC.LAUNCHED_TS ,
     S_LEAD.X_EVENT_ID , S_SRC.X_DIRECT_FLG , S_COMMUNICATION.COMM_DATE ,
     S_COMMUNICATION.X_REF_NUM , (SELECT S_CONTACT.X_PRSP_CONTACT_ID FROM S_CONTACT WHERE
     S_LEAD.CONTACT_ID = S_CONTACT.ROW_ID) X_PRSP_CONTACT_ID ,
     -- Added below 2 columns as part of CQ# WLPRD01127134 in Dec-14 release
      S_LEAD.X_SF_LEAD_CREATED_DT , S_LEAD.X_SF_RESP_CREATED_DT
     FROM
         V_LEAD S_LEAD,
         S_POSTN,
         S_SRC,
         S_COMMUNICATION
     WHERE
        S_LEAD.PR_POSTN_ID = S_POSTN.ROW_ID(+) AND S_LEAD.X_EVENT_ID =
     S_COMMUNICATION.ROW_ID(+) AND S_COMMUNICATION.SRC_ID = S_SRC.ROW_ID(+)
     ]
     INFO   11/18/2015 1:29:29 PM   OBIEE_Syst_Node1   READER_1_1_1   RR_4050
        RR_4050 First row returned from database to reader : (Wed Nov 18 16:29:29 2015)
     INFO   11/18/2015 1:29:29 PM   OBIEE_Syst_Node1   READER_1_1_1   BLKR_16019   Read
     [2] rows, read [0] error rows for source table [S_LEAD] instance name
     [mplt_Custom_BC_SBL_MarketingLeadFact.S_LEAD]
     INFO   11/18/2015 1:29:29 PM   OBIEE_Syst_Node1   READER_1_1_1   BLKR_16008   Reader
     run completed.
     INFO   11/18/2015 1:29:29 PM   OBIEE_Syst_Node1   LKPDP_1   TM_6660   Total
     Buffer Pool size is 609824 bytes and Block size is 65536 bytes.
     INFO   11/18/2015 1:29:29 PM   OBIEE_Syst_Node1   LKPDP_1:READER_1_1   DBG_21438
        Reader: Source is [DataWarehouse], user [T43_CRM_APPL_UTL]
     INFO   11/18/2015 1:29:30 PM   OBIEE_Syst_Node1   LKPDP_1:READER_1_1   BLKR_16003
        Initialization completed successfully.
     INFO   11/18/2015 1:29:30 PM   OBIEE_Syst_Node1   LKPDP_1:READER_1_1   BLKR_16007
        Reader run started.
     INFO   11/18/2015 1:29:30 PM   OBIEE_Syst_Node1   LKPDP_1:READER_1_1   RR_4049
        RR_4049 SQL Query issued to database : (Wed Nov 18 16:29:30 2015)
     INFO   11/18/2015 1:29:30 PM   OBIEE_Syst_Node1   LKPDP_1:READER_1_1   RR_4050
        RR_4050 First row returned from database to reader : (Wed Nov 18 16:29:30 2015)
     INFO   11/18/2015 1:29:30 PM   OBIEE_Syst_Node1   LKPDP_1:TRANSF_1_1   DBG_21079
        DBG_21079 Creating Lookup Cache : (Wed Nov 18 16:29:30 2015)
     INFO   11/18/2015 1:29:30 PM   OBIEE_Syst_Node1   LKPDP_1:TRANSF_1_1   TT_11195
        Warning: Unsorted input found when building the cache for the Lookup
     transformation [LKP_W_LOV_G_Retire_Reason1]. The current number of entries in the index
     cache is 350. For optimal performance, use sorted input.

     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   LKPDP_1:READER_1_1   BLKR_16008
        Reader run completed.
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   LKPDP_1:TRANSF_1_1   DBG_21682
        Lookup table row count : 40073
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   LKPDP_1:TRANSF_1_1   DBG_21297
        Lookup cache row count : 40073

     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   LKPDP_1:TRANSF_1_1   DBG_21294
        DBG_21294 Lookup cache creation completed : (Wed Nov 18 16:29:31 2015)
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   LKPDP_1:TRANSF_1_1   CMN_1671
        Created new cache files PMLKUP24620_3_0_176702A64.[dat/idx] in directory
     /gpfsobiee/syst/obiee/pcenterdata/Cache/Custom_Q3 for Lookup
     [LKP_W_LOV_G_Retire_Reason1].
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   LKPDP_1:TRANSF_1_1   DBG_21641
        LKP_W_LOV_G_Retire_Reason1: Index cache size = [1059840], Data cache size =
     [2097152]
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   LKPDP_1:TRANSF_1_1   DBG_21216
        Finished transformations for Source Qualifier [LKP_W_LOV_G_Retire_Reason1{{DSQ}}].
     Total errors [0]
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   TRANSF_1_1_1   DBG_21293
        Existing cache of lookup source [W_LOV_G] created by lookup
     [LKP_W_LOV_G_Retire_Reason1] is re-used by lookup [LKP_W_LOV_G_Reject_Reason]

     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   TRANSF_1_1_1   DBG_21293
        Existing cache of lookup source [W_LOV_G] created by lookup
     [LKP_W_LOV_G_Retire_Reason1] is re-used by lookup [LKP_W_LOV_G_Quality]

     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   TRANSF_1_1_1   DBG_21293
        Existing cache of lookup source [W_LOV_G] created by lookup
     [LKP_W_LOV_G_Retire_Reason1] is re-used by lookup [LKP_W_LOV_G_Status]

     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   TRANSF_1_1_1   DBG_21293
        Existing cache of lookup source [W_LOV_G] created by lookup
     [LKP_W_LOV_G_Retire_Reason1] is re-used by lookup [LKP_W_LOV_G_Outcome]

     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   TRANSF_1_1_1   DBG_21216
        Finished transformations for Source Qualifier
     [mplt_Custom_BC_SBL_MarketingLeadFact.SQ_S_LEAD]. Total errors [0]
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   WRITER_1_*_1   WRT_8167   Start
     loading table [W_MKTG_LEAD_FS: Partition 1] at: Wed Nov 18 16:29:30 2015
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   WRITER_1_*_1   TPTWR_34210
        [DEBUG] Formatting TPT API error message...

     ERROR   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   WRITER_1_*_1   TPTWR_21014
        [ERROR] Type:(Teradata PT API Error), Error: (Invalid arguments passed to
     PutBuffer)
     ERROR   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   WRITER_1_*_1   TPTWR_31630
        [ERROR] Plug-in failed while Data Manipulation.

     ERROR   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   WRITER_1_*_1   SDKS_38502   Plug-
     in #315000's target [W_MKTG_LEAD_FS: Partition 1] failed in method [execute].
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   WRITER_1_*_1   WRT_8333
        Rolling back all the targets due to fatal session error.
     ERROR   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   WRITER_1_*_1   WRT_8081   Writer
     run terminated. [Error in loading data to target table [W_MKTG_LEAD_FS: Partition 1]]
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   WRITER_1_*_1   WRT_8168   End
     loading table [W_MKTG_LEAD_FS: Partition 1] at: Wed Nov 18 16:29:30 2015
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   WRITER_1_*_1   TPTWR_32203   [INFO]
     Teradata database connection terminated successfully.

     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   WRITER_1_*_1   TPTWR_32602   [INFO]
     De-Initialized Teradata PT Writer Partition Driver.

     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   WRITER_1_*_1   WRT_8035   Load
     complete time: Wed Nov 18 16:29:30 2015

     LOAD SUMMARY
     ============

     WRT_8036 Target: W_MKTG_LEAD_FS: Partition 1 (Instance Name: [W_MKTG_LEAD_FS])
     WRT_8044 No data loaded for this target



     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   WRITER_1_*_1   WRT_8043
        *****END LOAD SESSION*****
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   MANAGER   PETL_24031
     ***** RUN INFO FOR TGT LOAD ORDER GROUP [1], CONCURRENT SET [1] *****
     Thread [READER_1_1_1] created for [the read stage] of partition point
     [mplt_Custom_BC_SBL_MarketingLeadFact.SQ_S_LEAD] has completed. The total run time was
     insufficient for any meaningful statistics.
     Thread [TRANSF_1_1_1] created for [the transformation stage] of partition point
     [mplt_Custom_BC_SBL_MarketingLeadFact.SQ_S_LEAD] has completed.
        Total Run Time = [1.847415] secs
        Total Idle Time = [1.844548] secs
        Busy Percentage = [0.155202]
        Transformation-specific statistics for this thread were not accurate enough to
     report.
     Thread [WRITER_1_*_1] created for [the write stage] of partition point [W_MKTG_LEAD_FS]
     has completed. The total run time was insufficient for any meaningful statistics.

     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   MAPPING   CMN_1793   The
     index cache size that would hold [40073] rows in the lookup table for
     [LKP_W_LOV_G_Retire_Reason1], in memory, is [9538560] bytes
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   MAPPING   CMN_1792   The
     data cache size that would hold [40073] rows in the lookup table for
     [LKP_W_LOV_G_Retire_Reason1], in memory, is [2580480] bytes
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   MAPPING   CMN_1793   The
     index cache size that would hold [40073] rows in the lookup table for
     [LKP_W_LOV_G_Reject_Reason], in memory, is [9538560] bytes
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   MAPPING   CMN_1792   The
     data cache size that would hold [40073] rows in the lookup table for
     [LKP_W_LOV_G_Reject_Reason], in memory, is [2580480] bytes
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   MAPPING   CMN_1793   The
     index cache size that would hold [40073] rows in the lookup table for
     [LKP_W_LOV_G_Quality], in memory, is [9538560] bytes
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   MAPPING   CMN_1792   The
     data cache size that would hold [40073] rows in the lookup table for
     [LKP_W_LOV_G_Quality], in memory, is [2580480] bytes
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   MAPPING   CMN_1793   The
     index cache size that would hold [40073] rows in the lookup table for
     [LKP_W_LOV_G_Status], in memory, is [9538560] bytes
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   MAPPING   CMN_1792   The
     data cache size that would hold [40073] rows in the lookup table for
     [LKP_W_LOV_G_Status], in memory, is [2580480] bytes
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   MAPPING   CMN_1793   The
     index cache size that would hold [40073] rows in the lookup table for
     [LKP_W_LOV_G_Outcome], in memory, is [9538560] bytes
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   MAPPING   CMN_1792   The
     data cache size that would hold [40073] rows in the lookup table for
     [LKP_W_LOV_G_Outcome], in memory, is [2580480] bytes
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   MANAGER   PETL_24005
        PETL_24005 Starting post-session tasks. : (Wed Nov 18 16:29:31 2015)
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   MANAGER   PETL_24029
        PETL_24029 Post-session task completed successfully. : (Wed Nov 18 16:29:31 2015)
     INFO   11/18/2015 1:29:31 PM   OBIEE_Syst_Node1   MAPPING   TPTWR_32502   [INFO]
     De-Initialized Teradata PT Writer Group Driver.

     FATAL   11/18/2015 1:29:33 PM   OBIEE_Syst_Node1          *********** FATAL
     ERROR : Caught a fatal signal or exception. ***********
     FATAL   11/18/2015 1:29:33 PM   OBIEE_Syst_Node1          *********** FATAL
     ERROR : Aborting the DTM process due to fatal signal or exception. ***********
     FATAL   11/18/2015 1:29:33 PM   OBIEE_Syst_Node1          *********** FATAL
     ERROR : Signal Received: SIGSEGV (11) ***********


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016