Analytics Software

Dears,

Running finance module using dac. this task has been failed.
log file for your reference.


DIRECTOR> VAR_27028 Use override value [DataWarehouse] for session parameter:[$DBConnection_OLAP].
DIRECTOR> VAR_27028 Use override value [ORA_R1213] for session parameter:[$DBConnection_OLTP].
DIRECTOR> VAR_27028 Use override value [ORA_R1213.DATAWAREHOUSE.SDE_ORAR1213_Adaptor.SDE_ORA_CodeDimension_Bank_Cat.log] for session parameter:[$PMSessionLogFile].
DIRECTOR> VAR_27027 Use default value [] for mapping parameter:[MPLT_ADI_CODES.$$CATEGORY].
DIRECTOR> VAR_27028 Use override value [1000] for mapping parameter:[MPLT_SA_ORA_CODES.$$DATASOURCE_NUM_ID].
DIRECTOR> VAR_27028 Use override value [DEFAULT] for mapping parameter:[MPLT_SA_ORA_CODES.$$TENANT_ID].
DIRECTOR> TM_6014 Initializing session [SDE_ORA_CodeDimension_Bank_Cat] at [Sat Apr 13 20:10:18 2013].
DIRECTOR> TM_6683 Repository Name: [Oracle_BI_DW_Base]
DIRECTOR> TM_6684 Server Name: [Oracle_BI_DW_Base_Integration_Service]
DIRECTOR> TM_6686 Folder: [SDE_ORAR1213_Adaptor]
DIRECTOR> TM_6685 Workflow: [SDE_ORA_CodeDimension_Bank_Cat] Run Instance Name: [] Run Id: [2791]
DIRECTOR> TM_6101 Mapping name: SDE_ORA_CodeDimension_Ap_Lookup [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 [E:\Informatica\9.0.1\server\infa_shared\Storage] will be used as storage directory for session [SDE_ORA_CodeDimension_Bank_Cat].
DIRECTOR> CMN_1805 Recovery cache will be deleted when running in normal mode.
DIRECTOR> CMN_1802 Session recovery cache initialization is complete.
DIRECTOR> TM_6708 Using configuration property [DisableDB2BulkMode,Yes]
DIRECTOR> TM_6708 Using configuration property [ServerPort,4006]
DIRECTOR> TM_6708 Using configuration property [SiebelUnicodeDB,apps@R12PLY baw@orcl]
DIRECTOR> TM_6708 Using configuration property [overrideMptlVarWithMapVar,Yes]

DIRECTOR> TM_6703 Session [SDE_ORA_CodeDimension_Bank_Cat] is run by 64-bit Integration Service [node01_OBIEETESTAPP], 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_6155 Using HIGH 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> DBG_21075 Connecting to database [orcl], user [baw]
MAPPING> TM_6007 DTM initialized successfully for session [SDE_ORA_CodeDimension_Bank_Cat]
DIRECTOR> PETL_24033 All DTM Connection Info: [<NONE>].
MANAGER> PETL_24004 Starting pre-session tasks. : (Sat Apr 13 20:10:18 2013)
MANAGER> PETL_24027 Pre-session task completed successfully. : (Sat Apr 13 20:10:18 2013)
DIRECTOR> PETL_24006 Starting data movement.
MAPPING> TM_6660 Total Buffer Pool size is 32000000 bytes and Block size is 128000 bytes.
LKPDP_1> DBG_21097 Lookup Transformation [mplt_ADI_Codes.Lkp_Master_Map]: Default sql to create lookup cache: SELECT MASTER_CODE,DATASOURCE_NUM_ID,SOURCE_CODE,CATEGORY,LANGUAGE_CODE FROM W_MASTER_MAP_D ORDER BY DATASOURCE_NUM_ID,SOURCE_CODE,CATEGORY,LANGUAGE_CODE,MASTER_CODE

LKPDP_3> DBG_21312 Lookup Transformation [mplt_ADI_Codes.Lkp_W_CODE_D]: Lookup override sql to create cache: SELECT W_CODE_D.SOURCE_NAME_1 AS SOURCE_NAME_1, W_CODE_D.SOURCE_NAME_2 AS SOURCE_NAME_2, W_CODE_D.MASTER_DATASOURCE_NUM_ID AS MASTER_DATASOURCE_NUM_ID, W_CODE_D.MASTER_CODE AS MASTER_CODE, W_CODE_D.MASTER_VALUE AS MASTER_VALUE, W_CODE_D.W_INSERT_DT AS W_INSERT_DT, W_CODE_D.TENANT_ID AS TENANT_ID, W_CODE_D.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, W_CODE_D.SOURCE_CODE AS SOURCE_CODE, W_CODE_D.CATEGORY AS CATEGORY, W_CODE_D.LANGUAGE_CODE AS LANGUAGE_CODE FROM W_CODE_D

WHERE

W_CODE_D.CATEGORY IN () ORDER BY DATASOURCE_NUM_ID,SOURCE_CODE,CATEGORY,LANGUAGE_CODE,SOURCE_NAME_1,SOURCE_NAME_2,MASTER_DATASOURCE_NUM_ID,MASTER_CODE,MASTER_VALUE,W_INSERT_DT,TENANT_ID

LKPDP_2> DBG_21097 Lookup Transformation [mplt_ADI_Codes.Lkp_Master_Code]: Default sql to create lookup cache: SELECT MASTER_VALUE,MASTER_DATASOURCE_NUM_ID,MASTER_CODE,CATEGORY,LANGUAGE_CODE FROM W_MASTER_CODE_D ORDER BY MASTER_DATASOURCE_NUM_ID,MASTER_CODE,CATEGORY,LANGUAGE_CODE,MASTER_VALUE

LKPDP_1> TE_7212 Increasing [Index Cache] size for transformation [mplt_ADI_Codes.Lkp_Master_Map] from [1000000] to [2611200].
LKPDP_1> TE_7212 Increasing [Data Cache] size for transformation [mplt_ADI_Codes.Lkp_Master_Map] from [2000000] to [2007040].
LKPDP_3> TE_7212 Increasing [Index Cache] size for transformation [mplt_ADI_Codes.Lkp_W_CODE_D] from [1000000] to [2611200].
LKPDP_3> TE_7212 Increasing [Data Cache] size for transformation [mplt_ADI_Codes.Lkp_W_CODE_D] from [2000000] to [2007040].
LKPDP_2> TE_7212 Increasing [Index Cache] size for transformation [mplt_ADI_Codes.Lkp_Master_Code] from [1000000] to [2611200].
LKPDP_2> TE_7212 Increasing [Data Cache] size for transformation [mplt_ADI_Codes.Lkp_Master_Code] from [2000000] to [2007040].
READER_1_1_1> DBG_21438 Reader: Source is [R12PLY], user [apps]
READER_1_1_1> BLKR_16003 Initialization completed successfully.
WRITER_1_*_1> WRT_8147 Writer: Target is database [orcl], user [baw], bulk mode [OFF]
WRITER_1_*_1> WRT_8124 Target Table W_CODE_D :SQL INSERT statement:
INSERT INTO W_CODE_D(DATASOURCE_NUM_ID,SOURCE_CODE,SOURCE_CODE_1,SOURCE_CODE_2,SOURCE_CODE_3,SOURCE_NAME_1,SOURCE_NAME_2,CATEGORY,LANGUAGE_CODE,MASTER_DATASOURCE_NUM_ID,MASTER_CODE,MASTER_VALUE,W_INSERT_DT,W_UPDATE_DT,TENANT_ID) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
WRITER_1_*_1> WRT_8124 Target Table W_CODE_D :SQL UPDATE statement:
UPDATE W_CODE_D SET SOURCE_CODE_1 = ?, SOURCE_CODE_2 = ?, SOURCE_CODE_3 = ?, SOURCE_NAME_1 = ?, SOURCE_NAME_2 = ?, MASTER_DATASOURCE_NUM_ID = ?, MASTER_CODE = ?, MASTER_VALUE = ?, W_INSERT_DT = ?, W_UPDATE_DT = ?, TENANT_ID = ? WHERE DATASOURCE_NUM_ID = ? AND SOURCE_CODE = ? AND CATEGORY = ? AND LANGUAGE_CODE = ?
WRITER_1_*_1> WRT_8124 Target Table W_CODE_D :SQL DELETE statement:
DELETE FROM W_CODE_D WHERE DATASOURCE_NUM_ID = ? AND SOURCE_CODE = ? AND CATEGORY = ? AND LANGUAGE_CODE = ?
WRITER_1_*_1> WRT_8270 Target connection group #1 consists of target(s) [W_CODE_D]
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_Codes_Ap_Lookup.Sq_Ap_Lookup_Codes] User specified SQL Query [SELECT AP_LOOKUP_CODES.LOOKUP_CODE, AP_LOOKUP_CODES.LOOKUP_TYPE, AP_LOOKUP_CODES.DESCRIPTION
FROM
AP_LOOKUP_CODES
WHERE
LOOKUP_TYPE = 'ACCOUNT TYPE']
READER_1_1_1> RR_4049 SQL Query issued to database : (Sat Apr 13 20:10:19 2013)
WRITER_1_*_1> WRT_8005 Writer run started.
WRITER_1_*_1> WRT_8158

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

Load Start Time: Sat Apr 13 20:10:19 2013

Target tables:

W_CODE_D


READER_1_1_1> RR_4050 First row returned from database to reader : (Sat Apr 13 20:10:19 2013)
READER_1_1_1> BLKR_16019 Read [4] rows, read [0] error rows for source table [AP_LOOKUP_CODES] instance name [mplt_BC_ORA_Codes_Ap_Lookup.AP_LOOKUP_CODES]
READER_1_1_1> BLKR_16008 Reader run completed.
LKPDP_3> TM_6660 Total Buffer Pool size is 609824 bytes and Block size is 65536 bytes.
LKPDP_3:READER_1_1> DBG_21438 Reader: Source is [orcl], user [baw]
LKPDP_3:READER_1_1> BLKR_16003 Initialization completed successfully.
LKPDP_3:READER_1_1> BLKR_16007 Reader run started.
LKPDP_3:READER_1_1> RR_4049 SQL Query issued to database : (Sat Apr 13 20:10:19 2013)
LKPDP_3:READER_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
LKPDP_3:READER_1_1> RR_4035 SQL Error [
ORA-00936: missing expression

Database driver error...
Function Name : Execute
SQL Stmt : SELECT W_CODE_D.SOURCE_NAME_1 AS SOURCE_NAME_1, W_CODE_D.SOURCE_NAME_2 AS SOURCE_NAME_2, W_CODE_D.MASTER_DATASOURCE_NUM_ID AS MASTER_DATASOURCE_NUM_ID, W_CODE_D.MASTER_CODE AS MASTER_CODE, W_CODE_D.MASTER_VALUE AS MASTER_VALUE, W_CODE_D.W_INSERT_DT AS W_INSERT_DT, W_CODE_D.TENANT_ID AS TENANT_ID, W_CODE_D.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, W_CODE_D.SOURCE_CODE AS SOURCE_CODE, W_CODE_D.CATEGORY AS CATEGORY, W_CODE_D.LANGUAGE_CODE AS LANGUAGE_CODE FROM W_CODE_D

WHERE

W_CODE_D.CATEGORY IN () ORDER BY DATASOURCE_NUM_ID,SOURCE_CODE,CATEGORY,LANGUAGE_CODE,SOURCE_NAME_1,SOURCE_NAME_2,MASTER_DATASOURCE_NUM_ID,MASTER_CODE,MASTER_VALUE,W_INSERT_DT,TENANT_ID
Oracle Fatal Error
Database driver error...
Function Name : Execute
SQL Stmt : SELECT W_CODE_D.SOURCE_NAME_1 AS SOURCE_NAME_1, W_CODE_D.SOURCE_NAME_2 AS SOURCE_NAME_2, W_CODE_D.MASTER_DATASOURCE_NUM_ID AS MASTER_DATASOURCE_NUM_ID, W_CODE_D.MASTER_CODE AS MASTER_CODE, W_CODE_D.MASTER_VALUE AS MASTER_VALUE, W_CODE_D.W_INSERT_DT AS W_INSERT_DT, W_CODE_D.TENANT_ID AS TENANT_ID, W_CODE_D.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, W_CODE_D.SOURCE_CODE AS SOURCE_CODE, W_CODE_D.CATEGORY AS CATEGORY, W_CODE_D.LANGUAGE_CODE AS LANGUAGE_CODE FROM W_CODE_D

WHERE

W_CODE_D.CATEGORY IN () ORDER BY DATASOURCE_NUM_ID,SOURCE_CODE,CATEGORY,LANGUAGE_CODE,SOURCE_NAME_1,SOURCE_NAME_2,MASTER_DATASOURCE_NUM_ID,MASTER_CODE,MASTER_VALUE,W_INSERT_DT,TENANT_ID
Oracle Fatal Error].
LKPDP_3:READER_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
LKPDP_3:READER_1_1> BLKR_16004 ERROR: Prepare failed.
TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_ADI_Codes.Lkp_W_CODE_D], and the session is terminating.
TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
WRITER_1_*_1> WRT_8333 Rolling back all the targets due to fatal session error.
TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_ADI_Codes.Exp_Master_Code_Lookup], and the session is terminating.
TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_ADI_Codes.Exp_Master_Code_Lookup], and the session is terminating.
TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_ADI_Codes.Exp_Master_Map_Lookup], and the session is terminating.
TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_ADI_Codes.Exp_Master_Map_Lookup], and the session is terminating.
WRITER_1_*_1> WRT_8325 Final rollback executed for the target [W_CODE_D] at end of load
TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_SA_ORA_Codes.Fil_Code_Valid], and the session is terminating.
TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
WRITER_1_*_1> WRT_8035 Load complete time: Sat Apr 13 20:10:19 2013

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

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



WRITER_1__1> WRT_8043 ****END LOAD SESSION*****
TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_SA_ORA_Codes.Fil_Code_Valid], and the session is terminating.
TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_SA_ORA_Codes.Exp_Code_Cleanse], and the session is terminating.
TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_SA_ORA_Codes.Exp_Code_Cleanse], and the session is terminating.
TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
MANAGER> PETL_24007 Received request to stop session run. Attempting to stop worker threads.
TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_SA_ORA_Codes.Exp_Code_Name_Resolution], and the session is terminating.
TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_SA_ORA_Codes.Exp_Code_Name_Resolution], and the session is terminating.
TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_Codes_Ap_Lookup.Exp_Ap_Lookup_Codes], and the session is terminating.
TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_Codes_Ap_Lookup.Exp_Ap_Lookup_Codes], and the session is terminating.
TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_Codes_Ap_Lookup.Sq_Ap_Lookup_Codes], and the session is terminating.
TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_Codes_Ap_Lookup.Sq_Ap_Lookup_Codes], and the session is terminating.
TRANSF_1_1_1> CMN_1761 Timestamp Event: [Sat Apr 13 20:10:19 2013]
TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_Codes_Ap_Lookup.Sq_Ap_Lookup_Codes], and the session is terminating.
TRANSF_1_1_1> DBG_21511 TE: Fatal Transformation Error.
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_Codes_Ap_Lookup.Sq_Ap_Lookup_Codes] 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_Codes_Ap_Lookup.Sq_Ap_Lookup_Codes] 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_CODE_D] 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_ADI_Codes.Lkp_W_CODE_D], in memory, is [0] bytes
MAPPING> CMN_1792 The data cache size that would hold [0] rows in the lookup table for [mplt_ADI_Codes.Lkp_W_CODE_D], in memory, is [0] bytes
MANAGER> PETL_24005 Starting post-session tasks. : (Sat Apr 13 20:10:19 2013)
MANAGER> PETL_24007 Received request to stop session run. Attempting to stop worker threads.
MANAGER> PETL_24007 Received request to stop session run. Attempting to stop worker threads.
MANAGER> PETL_24029 Post-session task completed successfully. : (Sat Apr 13 20:10:19 2013)
MAPPING> TE_7216 Deleting cache files [PMLKUP13765_131084_0_2791W32] for transformation [mplt_ADI_Codes.Lkp_Master_Map].
MAPPING> TE_7216 Deleting cache files [PMLKUP13765_131081_0_2791W32] for transformation [mplt_ADI_Codes.Lkp_W_CODE_D].
MAPPING> TE_7216 Deleting cache files [PMLKUP13765_131083_0_2791W32] for transformation [mplt_ADI_Codes.Lkp_Master_Code].
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_Ap_Lookup_Codes] (Instance Name: [mplt_BC_ORA_Codes_Ap_Lookup.Sq_Ap_Lookup_Codes])
Output Rows [4], Affected Rows [4], Applied Rows [4], Rejected Rows [0]
DIRECTOR> TM_6253 Target Load Summary.
DIRECTOR> CMN_1740 Table: [W_CODE_D] (Instance Name: [W_CODE_D])
Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
DIRECTOR> TM_6023
===================================================

DIRECTOR> TM_6020 Session [SDE_ORA_CodeDimension_Bank_Cat] completed at [Sat Apr 13 20:10:20 2013].