This discussion is archived
2 Replies Latest reply: Mar 21, 2013 1:51 AM by 872838 RSS

DE_ORAR1211_Adaptor.SDE_ORA_JobDimension_Full failing with below reason

$uresh Newbie
Currently Being Moderated
Hi All,

Following Informatica job is failing due to the following reason. Parameter file has got values initialized. But values are not recognized by the parameters in the maplet. please suggest the solutio.

Here I am attaching the log files.

Workflow Log file: SDE_ORA_JobDimension_Full.log

INFO : LM_36435 [Sun Jan 27 23:57:00 2013] : (3848|224) Starting execution of workflow [SDE_ORA_JobDimension_Full] in folder [SDE_ORAR1211_Adaptor] last saved by user [Administrator].
INFO : LM_44206 [Sun Jan 27 23:57:00 2013] : (3848|224) Workflow SDE_ORA_JobDimension_Full started with run id [818], run instance name [], run type [Concurrent Run Disabled].
INFO : LM_44195 [Sun Jan 27 23:57:00 2013] : (3848|224) Workflow [SDE_ORA_JobDimension_Full] service level [SLPriority:5,SLDispatchWaitTime:1800].
INFO : VAR_27085 [Sun Jan 27 23:57:00 2013] : (3848|224) Parameter file [C:\dac\10gR3_1\bifoundation\dac\Informatica\parameters\\ORA_R1211.DataWarehouse.SDE_ORAR1211_Adaptor.SDE_ORA_JobDimension_Full.txt] is opened for [workflow [SDE_ORA_JobDimension_Full]].
INFO : LM_44253 : (3848|224) Workflow started. Clients will be notified
INFO : LM_36330 [Sun Jan 27 23:57:00 2013] : (3848|224) Start task instance [Start]: Execution started.
INFO : LM_36318 [Sun Jan 27 23:57:00 2013] : (3848|224) Start task instance [Start]: Execution succeeded.
INFO : LM_36505 : (3848|224) Link [Start --> SDE_ORA_JobDimension_Full]: empty expression string, evaluated to TRUE.
INFO : LM_36388 [Sun Jan 27 23:57:00 2013] : (3848|224) Session task instance [SDE_ORA_JobDimension_Full] is waiting to be started.
INFO : LM_36682 [Sun Jan 27 23:57:01 2013] : (3848|224) Session task instance [SDE_ORA_JobDimension_Full]: started a process with pid [5588] on node [node01_w3].
INFO : LM_36330 [Sun Jan 27 23:57:01 2013] : (3848|224) Session task instance [SDE_ORA_JobDimension_Full]: Execution started.
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [TM_6793 Fetching initialization properties from the Integration Service. : (Sun Jan 27 23:57:03 2013)]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [DISP_20305 The [Preparer] DTM with process id [5588] is running on node [node01_w3].
: (Sun Jan 27 23:57:03 2013)]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [PETL_24036 Beginning the prepare phase for the session.]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [TM_6721 Started [Connect to Repository].]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [TM_6722 Finished [Connect to Repository]. It took [2.45313] seconds.]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [TM_6794 Connected to repository [obia_rep] in domain [Domain_w3] as user [Administrator] in security domain [Native].]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [TM_6721 Started [Fetch Session from Repository].]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [TM_6722 Finished [Fetch Session from Repository]. It took [7.28125] seconds.]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [VAR_27028 Use override value [DataWarehouse] for session parameter:[$DBConnection_OLAP].]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [VAR_27028 Use override value [ORA_R1211] for session parameter:[$DBConnection_OLTP].]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [VAR_27028 Use override value [ORA_R1211.DATAWAREHOUSE.SDE_ORAR1211_Adaptor.SDE_ORA_JobDimension_Full.log] for session parameter:[$PMSessionLogFile].]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [VAR_27028 Use override value [26] for mapping parameter:[$$DATASOURCE_NUM_ID].]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [VAR_27027 Use default value [] for mapping parameter:[mplt_BC_ORA_JobDimension.$$FLEX_JOB_CODE].]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [VAR_27027 Use default value [PER_JOBS.JOB_INFORMATION1] for mapping parameter:[mplt_BC_ORA_JobDimension.$$FLEX_JOB_EEO_CATEGORY].]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [VAR_27027 Use default value [] for mapping parameter:[mplt_BC_ORA_JobDimension.$$FLEX_JOB_FAMILY].]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [VAR_27027 Use default value [PER_JOBS.JOB_INFORMATION3] for mapping parameter:[mplt_BC_ORA_JobDimension.$$FLEX_JOB_FLSA_STATUS].]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [VAR_27027 Use default value [] for mapping parameter:[mplt_BC_ORA_JobDimension.$$FLEX_JOB_FUNCTION].]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [VAR_27027 Use default value [] for mapping parameter:[mplt_BC_ORA_JobDimension.$$FLEX_JOB_LEVEL].]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [VAR_27028 Use override value [SEGMENT3] for mapping parameter:[mplt_BC_ORA_JobDimension.$$JOBCODE_FLXFLD_SEGMENT_COL].]
INFO : LM_36488 [Sun Jan 27 23:57:13 2013] : (3848|1144) Session task instance [SDE_ORA_JobDimension_Full] : [VAR_27028 Use override value [JOB_INFORMATION4] for mapping parameter:[mplt_BC_ORA_JobDimension.$$JOBFAMILYCODE_FLXFLD_SEGMENT_COL].]
INFO : LM_36488 [Sun Jan 27 23:57:14 2013] : (3848|336) Session task instance [SDE_ORA_JobDimension_Full] : [VAR_27027 Use default value [] for mapping parameter:[mplt_BC_ORA_JobDimension.$$JOB_NAME_SEGMENT_COL].]
INFO : LM_36488 [Sun Jan 27 23:57:14 2013] : (3848|336) Session task instance [SDE_ORA_JobDimension_Full] : [VAR_27028 Use override value [] for mapping parameter:[mplt_BC_ORA_JobDimension.$$LAST_EXTRACT_DATE].]
INFO : LM_36488 [Sun Jan 27 23:57:14 2013] : (3848|336) Session task instance [SDE_ORA_JobDimension_Full] : [VAR_27027 Use default value [PA_HR_UPDATE_API.GET_JOB_LEVEL(PER_JOBS.JOB_ID,PER_JOBS.JOB_GROUP_ID)] for mapping parameter:[mplt_BC_ORA_JobDimension.$$PROJ_JOB_LEVEL].]
INFO : LM_36488 [Sun Jan 27 23:57:14 2013] : (3848|336) Session task instance [SDE_ORA_JobDimension_Full] : [VAR_27028 Use override value [DEFAULT] for mapping parameter:[$$TENANT_ID].]
INFO : LM_36488 [Sun Jan 27 23:57:14 2013] : (3848|336) Session task instance [SDE_ORA_JobDimension_Full] : [TM_6721 Started [Partition Group Formation].]
INFO : LM_36488 [Sun Jan 27 23:57:14 2013] : (3848|336) Session task instance [SDE_ORA_JobDimension_Full] : [TM_6722 Finished [Partition Group Formation]. It took [0.046875] seconds.]
INFO : LM_36488 [Sun Jan 27 23:57:14 2013] : (3848|336) Session task instance [SDE_ORA_JobDimension_Full] : [PETL_24037 Finished the prepare phase for the session.]
INFO : LM_36488 [Sun Jan 27 23:57:14 2013] : (3848|336) Session task instance [SDE_ORA_JobDimension_Full] : [TM_6792 Notifying the Integration Service that the prepare phase has been completed. : (Sun Jan 27 23:57:13 2013)]
INFO : LM_36488 [Sun Jan 27 23:57:14 2013] : (3848|336) Session task instance [SDE_ORA_JobDimension_Full] : [TM_6228 Writing session output to log file [C:\Informatica\9.0.1\server\infa_shared\SessLogs\ORA_R1211.DATAWAREHOUSE.SDE_ORAR1211_Adaptor.SDE_ORA_JobDimension_Full.log].]
ERROR : LM_36320 [Sun Jan 27 23:57:21 2013] : (3848|224) Session task instance [SDE_ORA_JobDimension_Full]: Execution failed.
WARNING : LM_36331 : (3848|224) Session task instance [SDE_ORA_JobDimension_Full] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [SDE_ORA_JobDimension_Full] will be failed.
ERROR : LM_36320 [Sun Jan 27 23:57:27 2013] : (3848|336) Workflow [SDE_ORA_JobDimension_Full]: Execution failed.


Session Log file: SDE_ORA_JobDimension_Full.log+_

DIRECTOR> VAR_27028 Use override value [DataWarehouse] for session parameter:[$DBConnection_OLAP].
DIRECTOR> VAR_27028 Use override value [ORA_R1211] for session parameter:[$DBConnection_OLTP].
DIRECTOR> VAR_27028 Use override value [ORA_R1211.DATAWAREHOUSE.SDE_ORAR1211_Adaptor.SDE_ORA_JobDimension_Full.log] for session parameter:[$PMSessionLogFile].
DIRECTOR> VAR_27028 Use override value [26] for mapping parameter:[$$DATASOURCE_NUM_ID].
DIRECTOR> VAR_27027 Use default value [] for mapping parameter:[mplt_BC_ORA_JobDimension.$$FLEX_JOB_CODE].
DIRECTOR> VAR_27027 Use default value [PER_JOBS.JOB_INFORMATION1] for mapping parameter:[mplt_BC_ORA_JobDimension.$$FLEX_JOB_EEO_CATEGORY].
DIRECTOR> VAR_27027 Use default value [] for mapping parameter:[mplt_BC_ORA_JobDimension.$$FLEX_JOB_FAMILY].
DIRECTOR> VAR_27027 Use default value [PER_JOBS.JOB_INFORMATION3] for mapping parameter:[mplt_BC_ORA_JobDimension.$$FLEX_JOB_FLSA_STATUS].
DIRECTOR> VAR_27027 Use default value [] for mapping parameter:[mplt_BC_ORA_JobDimension.$$FLEX_JOB_FUNCTION].
DIRECTOR> VAR_27027 Use default value [] for mapping parameter:[mplt_BC_ORA_JobDimension.$$FLEX_JOB_LEVEL].
DIRECTOR> VAR_27028 Use override value [SEGMENT3] for mapping parameter:[mplt_BC_ORA_JobDimension.$$JOBCODE_FLXFLD_SEGMENT_COL].
DIRECTOR> VAR_27028 Use override value [JOB_INFORMATION4] for mapping parameter:[mplt_BC_ORA_JobDimension.$$JOBFAMILYCODE_FLXFLD_SEGMENT_COL].
DIRECTOR> VAR_27027 Use default value [] for mapping parameter:[mplt_BC_ORA_JobDimension.$$JOB_NAME_SEGMENT_COL].
DIRECTOR> VAR_27028 Use override value [] for mapping parameter:[mplt_BC_ORA_JobDimension.$$LAST_EXTRACT_DATE].
DIRECTOR> VAR_27027 Use default value [PA_HR_UPDATE_API.GET_JOB_LEVEL(PER_JOBS.JOB_ID,PER_JOBS.JOB_GROUP_ID)] for mapping parameter:[mplt_BC_ORA_JobDimension.$$PROJ_JOB_LEVEL].
DIRECTOR> VAR_27028 Use override value [DEFAULT] for mapping parameter:[$$TENANT_ID].
DIRECTOR> TM_6014 Initializing session [SDE_ORA_JobDimension_Full] at [Sun Jan 27 23:57:14 2013].
DIRECTOR> TM_6683 Repository Name: [obia_rep]
DIRECTOR> TM_6684 Server Name: [obia_iis]
DIRECTOR> TM_6686 Folder: [SDE_ORAR1211_Adaptor]
DIRECTOR> TM_6685 Workflow: [SDE_ORA_JobDimension_Full] Run Instance Name: [] Run Id: [818]
DIRECTOR> TM_6101 Mapping name: SDE_ORA_JobDimension [version 1].
DIRECTOR> TM_6963 Pre 85 Timestamp Compatibility is Enabled
DIRECTOR> TM_6964 Date format for the Session is [MM/DD/YYYY HH24:MI:SS]
DIRECTOR> TM_6827 [C:\Informatica\9.0.1\server\infa_shared\Storage] will be used as storage directory for session [SDE_ORA_JobDimension_Full].
DIRECTOR> CMN_1805 Recovery cache will be deleted when running in normal mode.
DIRECTOR> CMN_1802 Session recovery cache initialization is complete.
DIRECTOR> TM_6703 Session [SDE_ORA_JobDimension_Full] is run by 32-bit Integration Service [node01_w3], version [9.0.1 HotFix2], build [1111].
MANAGER> PETL_24058 Running Partition Group [1].
MANAGER> PETL_24000 Parallel Pipeline Engine initializing.
MANAGER> PETL_24001 Parallel Pipeline Engine running.
MANAGER> PETL_24003 Initializing session run.
MAPPING> CMN_1569 Server Mode: [ASCII]
MAPPING> CMN_1570 Server Code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
MAPPING> TM_6151 The session sort order is [Binary].
MAPPING> TM_6156 Using low precision processing.
MAPPING> TM_6180 Deadlock retry logic will not be implemented.
MAPPING> TM_6187 Session target-based commit interval is [10000].
MAPPING> TM_6307 DTM error log disabled.
MAPPING> TE_7022 TShmWriter: Initialized
MAPPING> TM_6007 DTM initialized successfully for session [SDE_ORA_JobDimension_Full]
DIRECTOR> PETL_24033 All DTM Connection Info: [<NONE>].
MANAGER> PETL_24004 Starting pre-session tasks. : (Sun Jan 27 23:57:15 2013)
MANAGER> PETL_24027 Pre-session task completed successfully. : (Sun Jan 27 23:57:15 2013)
DIRECTOR> PETL_24006 Starting data movement.
MAPPING> TM_6660 Total Buffer Pool size is 32000000 bytes and Block size is 1280000 bytes.
LKPDP_1> DBG_21693 mplt_SA_ORA_JobDimension.Lkp_Flsa_Exempt_Stat_Code{{SRT}}: Cache size for partition [1] = [19922944]
LKPDP_1> SORT_40419 For Transformation [mplt_SA_ORA_JobDimension.Lkp_Flsa_Exempt_Stat_Code{{SRT}}], memory used is [19922944] bytes and row size is 780 bytes.
LKPDP_1> TE_7212 Increasing [Index Cache] size for transformation [mplt_SA_ORA_JobDimension.Lkp_Flsa_Exempt_Stat_Code] from [1048576] to [1880064].
LKPDP_2> DBG_21693 mplt_SA_ORA_JobDimension.Lkp_EEO_Job_Cat{{SRT}}: Cache size for partition [1] = [19922944]
LKPDP_2> SORT_40419 For Transformation [mplt_SA_ORA_JobDimension.Lkp_EEO_Job_Cat{{SRT}}], memory used is [19922944] bytes and row size is 780 bytes.
LKPDP_2> TE_7212 Increasing [Index Cache] size for transformation [mplt_SA_ORA_JobDimension.Lkp_EEO_Job_Cat] from [1048576] to [1880064].
READER_1_1_1> DBG_21438 Reader: Source is [vis], user [apps]
READER_1_1_1> BLKR_16003 Initialization completed successfully.
WRITER_1_*_1> WRT_8146 Writer: Target is database [vis], user [olap], bulk mode [ON]
WRITER_1_*_1> WRT_8106 Warning! Bulk Mode session - recovery is not guaranteed.
WRITER_1_*_1> WRT_8124 Target Table W_JOB_DS :SQL INSERT statement:
INSERT INTO W_JOB_DS(JOB_CODE,JOB_NAME,JOB_DESC,JOB_FAMILY_CODE,JOB_FAMILY_NAME,JOB_FAMILY_DESC,JOB_LEVEL,JOB_LEVEL_DESC,JOB_FUNCTION_CODE,JOB_FUNCTION_NAME,JOB_FUNCTION_DESC,PROJ_JOB_LEVEL,PROJ_JOB_LEVEL_DESC,W_FLSA_STAT_CODE,W_FLSA_STAT_DESC,W_EEO_JOB_CAT_CODE,W_EEO_JOB_CAT_DESC,AAP_JOB_CAT_CODE,AAP_JOB_CAT_NAME,ACTIVE_FLG,CREATED_BY_ID,CHANGED_BY_ID,CREATED_ON_DT,CHANGED_ON_DT,AUX1_CHANGED_ON_DT,AUX2_CHANGED_ON_DT,AUX3_CHANGED_ON_DT,AUX4_CHANGED_ON_DT,SRC_EFF_FROM_DT,SRC_EFF_TO_DT,DELETE_FLG,DATASOURCE_NUM_ID,INTEGRATION_ID,TENANT_ID,X_CUSTOM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
WRITER_1_*_1> WRT_8270 Target connection group #1 consists of target(s) [W_JOB_DS]
WRITER_1_*_1> WRT_8003 Writer initialization complete.
READER_1_1_1> BLKR_16007 Reader run started.
READER_1_1_1> RR_4029 SQ Instance [mplt_BC_ORA_JobDimension.Sq_Jobs] User specified SQL Query [SELECT

PER_JOBS.JOB_ID,

PER_JOBS.BUSINESS_GROUP_ID,

PER_JOBS.JOB_DEFINITION_ID,

PER_JOBS.DATE_FROM,

PER_JOBS.DATE_TO,

PER_JOBS.LAST_UPDATE_DATE AS CHANGED_ON_DT,      PER_JOBS.LAST_UPDATED_BY, PER_JOBS.CREATED_BY, PER_JOBS.CREATION_DATE,

PER_JOB_DEFINITIONS.LAST_UPDATE_DATE AS AUX1_CHANGED_ON_DT,

PER_JOBS.NAME JOB_DESC, PER_JOBS.JOB_INFORMATION1 EEO_CATEGORY,

PER_JOBS.JOB_INFORMATION3 FLSA_STATUS,

JOB_INFORMATION4 AS JOB_FAMILY_CODE,

  AS JOB_NAME,

AS JOB_CODE,

AS JOB_LEVEL,

AS JOB_FUNCTION,

AS JOB_FAMILY,

PA_HR_UPDATE_API.GET_JOB_LEVEL(PER_JOBS.JOB_ID,PER_JOBS.JOB_GROUP_ID) AS PROJ_JOB_LEVEL ,

'0' AS X_CUSTOM

FROM

PER_JOBS, PER_JOB_DEFINITIONS

WHERE

PER_JOBS.JOB_DEFINITION_ID = PER_JOB_DEFINITIONS.JOB_DEFINITION_ID]
READER_1_1_1> RR_4049 SQL Query issued to database : (Sun Jan 27 23:57:19 2013)
READER_1_1_1> CMN_1761 Timestamp Event: [Sun Jan 27 23:57:19 2013]
READER_1_1_1> RR_4035 SQL Error [
ORA-00936: missing expression

Database driver error...
Function Name : Execute
SQL Stmt : SELECT

PER_JOBS.JOB_ID,

PER_JOBS.BUSINESS_GROUP_ID,

PER_JOBS.JOB_DEFINITION_ID,

PER_JOBS.DATE_FROM,

PER_JOBS.DATE_TO,

PER_JOBS.LAST_UPDATE_DATE AS CHANGED_ON_DT, PER_JOBS.LAST_UPDATED_BY, PER_JOBS.CREATED_BY, PER_JOBS.CREATION_DATE,

PER_JOB_DEFINITIONS.LAST_UPDATE_DATE AS AUX1_CHANGED_ON_DT,

PER_JOBS.NAME JOB_DESC, PER_JOBS.JOB_INFORMATION1 EEO_CATEGORY,

PER_JOBS.JOB_INFORMATION3 FLSA_STATUS,

JOB_INFORMATION4 AS JOB_FAMILY_CODE,

AS JOB_NAME,

AS JOB_CODE,

AS JOB_LEVEL,

AS JOB_FUNCTION,

AS JOB_FAMILY,

PA_HR_UPDATE_API.GET_JOB_LEVEL(PER_JOBS.JOB_ID,PER_JOBS.JOB_GROUP_ID) AS PROJ_JOB_LEVEL ,

'0' AS X_CUSTOM

FROM

PER_JOBS, PER_JOB_DEFINITIONS

WHERE

PER_JOBS.JOB_DEFINITION_ID = PER_JOB_DEFINITIONS.JOB_DEFINITION_ID
Oracle Fatal Error
Database driver error...
Function Name : Execute
SQL Stmt : SELECT

PER_JOBS.JOB_ID,

PER_JOBS.BUSINESS_GROUP_ID,

PER_JOBS.JOB_DEFINITION_ID,

PER_JOBS.DATE_FROM,

PER_JOBS.DATE_TO,

PER_JOBS.LAST_UPDATE_DATE AS CHANGED_ON_DT, PER_JOBS.LAST_UPDATED_BY, PER_JOBS.CREATED_BY, PER_JOBS.CREATION_DATE,

PER_JOB_DEFINITIONS.LAST_UPDATE_DATE AS AUX1_CHANGED_ON_DT,

PER_JOBS.NAME JOB_DESC, PER_JOBS.JOB_INFORMATION1 EEO_CATEGORY,

PER_JOBS.JOB_INFORMATION3 FLSA_STATUS,

JOB_INFORMATION4 AS JOB_FAMILY_CODE,

AS JOB_NAME,

AS JOB_CODE,

AS JOB_LEVEL,

AS JOB_FUNCTION,

AS JOB_FAMILY,

PA_HR_UPDATE_API.GET_JOB_LEVEL(PER_JOBS.JOB_ID,PER_JOBS.JOB_GROUP_ID) AS PROJ_JOB_LEVEL ,

'0' AS X_CUSTOM

FROM

PER_JOBS, PER_JOB_DEFINITIONS

WHERE

PER_JOBS.JOB_DEFINITION_ID = PER_JOB_DEFINITIONS.JOB_DEFINITION_ID
Oracle Fatal Error].
READER_1_1_1> CMN_1761 Timestamp Event: [Sun Jan 27 23:57:19 2013]
READER_1_1_1> BLKR_16004 ERROR: Prepare failed.
WRITER_1_*_1> WRT_8005 Writer run started.
WRITER_1_*_1> WRT_8158

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

Load Start Time: Sun Jan 27 23:57:18 2013

Target tables:

W_JOB_DS


WRITER_1_*_1> WRT_8333 Rolling back all the targets due to fatal session error.
WRITER_1_*_1> WRT_8325 Final rollback executed for the target [W_JOB_DS] at end of load
WRITER_1_*_1> WRT_8035 Load complete time: Sun Jan 27 23:57:18 2013

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

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



WRITER_1__1> WRT_8043 ****END LOAD SESSION*****
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_BC_ORA_JobDimension.Sq_Jobs] 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_BC_ORA_JobDimension.Sq_Jobs] has completed. The total run time was insufficient for any meaningful statistics.
Thread [WRITER_1_*_1] created for [the write stage] of partition point [W_JOB_DS] has completed. The total run time was insufficient for any meaningful statistics.

MAPPING> CMN_1793 The index cache size that would hold [0] rows in the lookup table for [mplt_SA_ORA_JobDimension.Lkp_Flsa_Exempt_Stat_Code], in memory, is [0] bytes
MAPPING> CMN_1792 The data cache size that would hold [0] rows in the lookup table for [mplt_SA_ORA_JobDimension.Lkp_Flsa_Exempt_Stat_Code], in memory, is [0] bytes
MAPPING> CMN_1793 The index cache size that would hold [0] rows in the lookup table for [mplt_SA_ORA_JobDimension.Lkp_EEO_Job_Cat], in memory, is [0] bytes
MAPPING> CMN_1792 The data cache size that would hold [0] rows in the lookup table for [mplt_SA_ORA_JobDimension.Lkp_EEO_Job_Cat], in memory, is [0] bytes
MANAGER> PETL_24005 Starting post-session tasks. : (Sun Jan 27 23:57:20 2013)
MANAGER> PETL_24029 Post-session task completed successfully. : (Sun Jan 27 23:57:20 2013)
MAPPING> TE_7216 Deleting cache files [PMLKUP14146_131076_0_818W32] for transformation [mplt_SA_ORA_JobDimension.Lkp_Flsa_Exempt_Stat_Code].
MAPPING> TE_7216 Deleting cache files [PMLKUP14146_131077_0_818W32] for transformation [mplt_SA_ORA_JobDimension.Lkp_EEO_Job_Cat].
MAPPING> TM_6018 The session completed with [0] row transformation errors.
MANAGER> PETL_24002 Parallel Pipeline Engine finished.
DIRECTOR> PETL_24013 Session run completed with failure.
DIRECTOR> TM_6022

SESSION LOAD SUMMARY
================================================

DIRECTOR> TM_6252 Source Load Summary.
DIRECTOR> CMN_1740 Table: [Sq_Jobs] (Instance Name: [mplt_BC_ORA_JobDimension.Sq_Jobs])
     Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
DIRECTOR> TM_6253 Target Load Summary.
DIRECTOR> CMN_1740 Table: [W_JOB_DS] (Instance Name: [W_JOB_DS])
     Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
DIRECTOR> TM_6023
===================================================

DIRECTOR> TM_6020 Session [SDE_ORA_JobDimension_Full] completed at [Sun Jan 27 23:57:21 2013].

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points