|
|
Archives of the TeradataForum
Message Posted: Wed, 18 Nov 2015 @ 22:04:10 GMT
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) ***********
| |