Analytics Software

Hi all,

The DAC fails on the following 2 mappings:
SDE_ORA_TransactionTypeDimension_PurchaseReceipt
SDE_ORA_TransactionTypeDimension_PurchaseRequest

But I really don't have clue why!

The log files are saying something like: Database drive error or something....

My configuration is as following:
- Windows 2003 server SP2
- Standard apps with R12 and the Vision database preinstalled
- BIA 7.9.5.1 (but I know this same errror occurs with 795)

I have seen simular errors like this, and most of the time when this is happening then your database is down, but this is not the case, it is still up and running.

The error always occurs on this mapping/proces (each mapping has only 1 proces)


Here is the logfile from the dac:


MAPPING PurchaseReceipt


pmcmd startworkflow -u Administrator -p **** -s localhost:4001 -f SDE_ORAR12_Adaptor -lpf O:\BIA\OracleBI\DAC\Informatica\parameters\SDE_ORAR12_Adaptor.SDE_ORA_TransactionTypeDimension_PurchaseReceipt.txt SDE_ORA_TransactionTypeDimension_PurchaseReceipt
Status Desc : Failed
WorkFlowMessage :
=====================================
STD OUTPUT
=====================================

Informatica(r) PMCMD, version [8.1.1 SP5], build [186.0822], Windows 32-bit
Copyright (c) Informatica Corporation 1994 - 2008
All Rights Reserved.

Invoked at Sat Mar 28 22:07:05 2009

Connected to Integration Service at [localhost:4001]
Folder: [SDE_ORAR12_Adaptor]
Workflow: [SDE_ORA_TransactionTypeDimension_PurchaseReceipt] version [1].
Workflow run status: [Failed]
Workflow run error code: [36331]
Workflow run error message: [WARNING: Session task instance [SDE_ORA_TransactionTypeDimension_PurchaseReceipt] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [SDE_ORA_TransactionTypeDimension_PurchaseReceipt] will be failed.]
Start time: [Sat Mar 28 22:06:23 2009]
End time: [Sat Mar 28 22:06:48 2009]
Workflow log file: [O:\Informatica\PowerCenter8.1.1\server\infa_shared\WorkflowLogs\SDE_ORA_TransactionTypeDimension_PurchaseReceipt.log]
Workflow run type: [User request]
Run workflow as user: [Administrator]
Integration Service: [Oracle_BI_DW_Base_Integration_Service]
Disconnecting from Integration Service

Completed at Sat Mar 28 22:07:06 2009

=====================================
ERROR OUTPUT
=====================================

Error Message : Unknown reason for error code 36331
ErrorCode : 36331


AND HERE IS THE INFORMATICA LOG OF PURCHASERECEIPT

DIRECTOR> VAR_27028 Use override value [DataWarehouse] for session parameter:[$DBConnection_OLAP].
DIRECTOR> VAR_27028 Use override value [ORA_R12] for session parameter:[$DBConnection_OLTP].
DIRECTOR> VAR_27028 Use override value [9] for mapping parameter:[$$DATASOURCE_NUM_ID].
DIRECTOR> VAR_27028 Use override value [DEFAULT] for mapping parameter:[$$TENANT_ID].
DIRECTOR> TM_6014 Initializing session [SDE_ORA_TransactionTypeDimension_PurchaseReceipt] at [Sat Mar 28 22:06:30 2009]
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_ORAR12_Adaptor]
DIRECTOR> TM_6685 Workflow: [SDE_ORA_TransactionTypeDimension_PurchaseReceipt]
DIRECTOR> TM_6101 Mapping name: SDE_ORA_TransactionTypeDimension_PurchaseReceipt [version 1]
DIRECTOR> TM_6827 [O:\Informatica\PowerCenter8.1.1\server\infa_shared\Storage] will be used as storage directory for session [SDE_ORA_TransactionTypeDimension_PurchaseReceipt].
DIRECTOR> CMN_1802 Session recovery cache initialization is complete.
DIRECTOR> TM_6708 Using configuration property [SiebelUnicodeDB,apps@vis baw@bia]

DIRECTOR> TM_6703 Session [SDE_ORA_TransactionTypeDimension_PurchaseReceipt] is run by 32-bit Integration Service [node01_IncoreServer], version [8.1.1 SP5], build [0822].
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: [UNICODE]
MAPPING> CMN_1570 Server Code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
MAPPING> TM_6151 Session Sort Order: [Binary]
MAPPING> TM_6185 WARNING! Data code page validation is disabled in this session.
MAPPING> TM_6156 Using LOW precision decimal arithmetic
MAPPING> TM_6180 Deadlock retry logic will not be implemented.
MAPPING> TM_6307 DTM Error Log Disabled.
MAPPING> TE_7022 TShmWriter: Initialized
MAPPING> DBG_21075 Connecting to database [bia], user [baw]
MAPPING> CMN_1716 Lookup [mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
MAPPING> TM_6007 DTM initialized successfully for session [SDE_ORA_TransactionTypeDimension_PurchaseReceipt]
DIRECTOR> PETL_24033 All DTM Connection Info: [<NONE>].
MANAGER> PETL_24004 Starting pre-session tasks. : (Sat Mar 28 22:06:31 2009)
MANAGER> PETL_24027 Pre-session task completed successfully. : (Sat Mar 28 22:06:31 2009)
DIRECTOR> PETL_24006 Starting data movement.
MAPPING> TM_6660 Total Buffer Pool size is 32000000 bytes and Block size is 128000 bytes.
READER_1_1_1> DBG_21438 Reader: Source is [vis], user [apps]
READER_1_1_1> BLKR_16051 Source database connection [ORA_R12] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
READER_1_1_1> BLKR_16003 Initialization completed successfully.
WRITER_1_*_1> WRT_8146 Writer: Target is database [bia], user [baw], bulk mode [ON]
WRITER_1_*_1> WRT_8106 Warning! Bulk Mode session - recovery is not guaranteed.
WRITER_1_*_1> WRT_8221 Target database connection [DataWarehouse] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
WRITER_1_*_1> WRT_8124 Target Table W_XACT_TYPE_DS :SQL INSERT statement:
INSERT INTO W_XACT_TYPE_DS(XACT_CODE,XACT_CAT_CODE,XACT_TYPE_CODE,XACT_TYPE_NAME,XACT_TYPE_DESC,XACT_SUBTYPE_CODE,XACT_SUBTYPE_NAME,XACT_SUBTYPE_DESC,W_XACT_TYPE_CODE,W_XACT_TYPE_DESC,W_XACT_SUBTYPE_CODE,W_XACT_SUBTYPE_DESC,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,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_XACT_TYPE_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_TransactionTypeDimension_PurchaseReceipt.Sq_FND_LOOKUP_VALUES] User specified SQL Query [SELECT
FND_LOOKUP_VALUES.LAST_UPDATE_DATE,
FND_LOOKUP_VALUES.CREATION_DATE,
FND_LOOKUP_VALUES.LOOKUP_CODE,
FND_LOOKUP_VALUES.DESCRIPTION,
'0' AS X_CUSTOM
FROM
FND_LOOKUP_VALUES
WHERE
FND_LOOKUP_VALUES.LANGUAGE = 'US' AND
FND_LOOKUP_VALUES.LOOKUP_TYPE = 'RCV TRANSACTION TYPE' AND
FND_LOOKUP_VALUES.LOOKUP_CODE = 'RECEIVE']
READER_1_1_1> RR_4049 SQL Query issued to database : (Sat Mar 28 22:06:32 2009)
WRITER_1_*_1> WRT_8005 Writer run started.
WRITER_1_*_1> WRT_8158

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

Load Start Time: Sat Mar 28 22:06:31 2009

Target tables:

W_XACT_TYPE_DS


READER_1_1_1> RR_4050 First row returned from database to reader : (Sat Mar 28 22:06:32 2009)
READER_1_1_1> BLKR_16019 Read [1] rows, read [0] error rows for source table [FND_LOOKUP_VALUES] instance name [mplt_BC_ORA_TransactionTypeDimension_PurchaseReceipt.FND_LOOKUP_VALUES]
READER_1_1_1> BLKR_16008 Reader run completed.
LKPDP_1> DBG_21097 Lookup Transformation [mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej]: Default sql to create lookup cache: SELECT DATASOURCE_NUM_ID,INTEGRATION_ID FROM W_XACT_TYPE_DS ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID

LKPDP_1> TE_7212 Increasing [Index Cache] size for transformation [mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej] from [1048576] to [1392640].
LKPDP_1> TM_6660 Total Buffer Pool size is 609824 bytes and Block size is 65536 bytes.
LKPDP_1:READER_1_1> DBG_21438 Reader: Source is [bia], user [baw]
LKPDP_1:READER_1_1> BLKR_16051 Source database connection [DataWarehouse] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
LKPDP_1:READER_1_1> BLKR_16003 Initialization completed successfully.
LKPDP_1:READER_1_1> BLKR_16007 Reader run started.
LKPDP_1:READER_1_1> RR_4049 SQL Query issued to database : (Sat Mar 28 22:06:36 2009)
LKPDP_1:READER_1_1> RR_4050 First row returned from database to reader : (Sat Mar 28 22:06:38 2009)
LKPDP_1:TRANSF_1_1> DBG_21079 Creating Lookup Cache : (Sat Mar 28 22:06:38 2009)
LKPDP_1:READER_1_1> BLKR_16019 Read [6516] rows, read [0] error rows for source table [mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej{{DSQ}}] instance name [mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej{{SRC}}]
LKPDP_1:READER_1_1> BLKR_16008 Reader run completed.
LKPDP_1:TRANSF_1_1> DBG_21682 Lookup table row count : 6516
LKPDP_1:TRANSF_1_1> DBG_21297 Lookup cache row count : 6516

LKPDP_1:TRANSF_1_1> DBG_21294 Lookup cache creation completed : (Sat Mar 28 22:06:38 2009)
LKPDP_1:TRANSF_1_1> CMN_1671 Created new cache files PMLKUP3533_131077W32.[dat/idx] in directory O:\Informatica\PowerCenter8.1.1\server\infa_shared\Cache for Lookup [mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej].
LKPDP_1:TRANSF_1_1> DBG_21641 mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej: Index cache size = [1392640], Data cache size = [2097152]
LKPDP_1:TRANSF_1_1> DBG_21216 Finished transformations for Source Qualifier [mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej{{DSQ}}]. Total errors [0]
TRANSF_1_1_1> DBG_21216 Finished transformations for Source Qualifier [mplt_BC_ORA_TransactionTypeDimension_PurchaseReceipt.Sq_FND_LOOKUP_VALUES]. Total errors [0]
WRITER_1_*_1> WRT_8167 Start loading table [W_XACT_TYPE_DS] at: Sat Mar 28 22:06:38 2009
WRITER_1_*_1> CMN_1761 Timestamp Event: [Sat Mar 28 22:06:38 2009]
WRITER_1_*_1> WRT_8229 Database errors occurred:
ORA-00604: error occurred at recursive SQL level 1
ORA-00054: resource busy and acquire with NOWAIT specified

Database driver error...
Function Name : Prepare DPL
SQL Stmt : INSERT INTO W_XACT_TYPE_DS(XACT_CODE,XACT_CAT_CODE,XACT_TYPE_CODE,XACT_TYPE_NAME,XACT_TYPE_DESC,XACT_SUBTYPE_CODE,XACT_SUBTYPE_NAME,XACT_SUBTYPE_DESC,W_XACT_TYPE_CODE,W_XACT_TYPE_DESC,W_XACT_SUBTYPE_CODE,W_XACT_SUBTYPE_DESC,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,DELETE_FLG,DATASOURCE_NUM_ID,INTEGRATION_ID,TENANT_ID,X_CUSTOM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO W_XACT_TYPE_DS(XACT_CODE,XACT_CAT_CODE,XACT_TYPE_CODE,XACT_TYPE_NAME,XACT_TYPE_DESC,XACT_SUBTYPE_CODE,XACT_SUBTYPE_NAME,XACT_SUBTYPE_DESC,W_XACT_TYPE_CODE,W_XACT_TYPE_DESC,W_XACT_SUBTYPE_CODE,W_XACT_SUBTYPE_DESC,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,DELETE_FLG,DATASOURCE_NUM_ID,INTEGRATION_ID,TENANT_ID,X_CUSTOM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
WRITER_1_*_1> CMN_1761 Timestamp Event: [Sat Mar 28 22:06:38 2009]
WRITER_1_*_1> WRT_8425 ERROR: Writer execution failed.
WRITER_1_*_1> CMN_1761 Timestamp Event: [Sat Mar 28 22:06:38 2009]
WRITER_1_*_1> WRT_8076 Writer run terminated. [Commit Error]
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_XACT_TYPE_DS] at end of load
WRITER_1_*_1> CMN_1761 Timestamp Event: [Sat Mar 28 22:06:38 2009]
WRITER_1_*_1> WRT_8081 Writer run terminated. [Error in loading data to target table [W_XACT_TYPE_DS]]
WRITER_1_*_1> WRT_8168 End loading table [W_XACT_TYPE_DS] at: Sat Mar 28 22:06:38 2009
WRITER_1_*_1> WRT_8035 Load complete time: Sat Mar 28 22:06:38 2009

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

WRT_8036 Target: W_XACT_TYPE_DS (Instance Name: [W_XACT_TYPE_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_TransactionTypeDimension_PurchaseReceipt.Sq_FND_LOOKUP_VALUES] 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_TransactionTypeDimension_PurchaseReceipt.Sq_FND_LOOKUP_VALUES] has completed: Total Run Time = [6.828123] secs, Total Idle Time = [6.812498] secs, Busy Percentage = [0.228833].
Thread [WRITER_1_*_1] created for [the write stage] of partition point [W_XACT_TYPE_DS] has completed. The total run time was insufficient for any meaningful statistics.

MANAGER> PETL_24005 Starting post-session tasks. : (Sat Mar 28 22:06:39 2009)
MANAGER> PETL_24029 Post-session task completed successfully. : (Sat Mar 28 22:06:39 2009)
MAPPING> TE_7216 Deleting cache files [PMLKUP3533_131077W32] for transformation [mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej].
MAPPING> TM_6018 Session [SDE_ORA_TransactionTypeDimension_PurchaseReceipt] run 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_FND_LOOKUP_VALUES] (Instance Name: [mplt_BC_ORA_TransactionTypeDimension_PurchaseReceipt.Sq_FND_LOOKUP_VALUES])
Output Rows [1], Affected Rows [1], Applied Rows [1], Rejected Rows [0]
DIRECTOR> TM_6253 Target Load Summary.
DIRECTOR> CMN_1740 Table: [W_XACT_TYPE_DS] (Instance Name: [W_XACT_TYPE_DS])
Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
DIRECTOR> TM_6023
===================================================

DIRECTOR> TM_6020 Session [SDE_ORA_TransactionTypeDimension_PurchaseReceipt] completed at [Sat Mar 28 22:06:39 2009]



HERE COMES THE PURCHASEREQUEST logfile of the DAC

pmcmd startworkflow -u Administrator -p **** -s localhost:4001 -f SDE_ORAR12_Adaptor -lpf O:\BIA\OracleBI\DAC\Informatica\parameters\SDE_ORAR12_Adaptor.SDE_ORA_TransactionTypeDimension_PurchaseRequest.txt SDE_ORA_TransactionTypeDimension_PurchaseRequest
Status Desc : Failed
WorkFlowMessage :
=====================================
STD OUTPUT
=====================================

Informatica(r) PMCMD, version [8.1.1 SP5], build [186.0822], Windows 32-bit
Copyright (c) Informatica Corporation 1994 - 2008
All Rights Reserved.

Invoked at Sat Mar 28 22:07:01 2009

Connected to Integration Service at [localhost:4001]
Folder: [SDE_ORAR12_Adaptor]
Workflow: [SDE_ORA_TransactionTypeDimension_PurchaseRequest] version [1].
Workflow run status: [Failed]
Workflow run error code: [36331]
Workflow run error message: [WARNING: Session task instance [SDE_ORA_TransactionTypeDimension_PurchaseRequest] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [SDE_ORA_TransactionTypeDimension_PurchaseRequest] will be failed.]
Start time: [Sat Mar 28 22:06:16 2009]
End time: [Sat Mar 28 22:06:48 2009]
Workflow log file: [O:\Informatica\PowerCenter8.1.1\server\infa_shared\WorkflowLogs\SDE_ORA_TransactionTypeDimension_PurchaseRequest.log]
Workflow run type: [User request]
Run workflow as user: [Administrator]
Integration Service: [Oracle_BI_DW_Base_Integration_Service]
Disconnecting from Integration Service

Completed at Sat Mar 28 22:07:02 2009

=====================================
ERROR OUTPUT
=====================================

Error Message : Unknown reason for error code 36331
ErrorCode : 36331



AND HERE THE INFORMATICALOG OF PURCHASE REQUEST*

DIRECTOR> VAR_27028 Use override value [DataWarehouse] for session parameter:[$DBConnection_OLAP].
DIRECTOR> VAR_27028 Use override value [ORA_R12] for session parameter:[$DBConnection_OLTP].
DIRECTOR> VAR_27028 Use override value [9] for mapping parameter:[$$DATASOURCE_NUM_ID].
DIRECTOR> VAR_27028 Use override value [DEFAULT] for mapping parameter:[$$TENANT_ID].
DIRECTOR> TM_6014 Initializing session [SDE_ORA_TransactionTypeDimension_PurchaseReceipt] at [Sat Mar 28 22:06:30 2009]
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_ORAR12_Adaptor]
DIRECTOR> TM_6685 Workflow: [SDE_ORA_TransactionTypeDimension_PurchaseReceipt]
DIRECTOR> TM_6101 Mapping name: SDE_ORA_TransactionTypeDimension_PurchaseReceipt [version 1]
DIRECTOR> TM_6827 [O:\Informatica\PowerCenter8.1.1\server\infa_shared\Storage] will be used as storage directory for session [SDE_ORA_TransactionTypeDimension_PurchaseReceipt].
DIRECTOR> CMN_1802 Session recovery cache initialization is complete.
DIRECTOR> TM_6708 Using configuration property [SiebelUnicodeDB,apps@vis baw@bia]

DIRECTOR> TM_6703 Session [SDE_ORA_TransactionTypeDimension_PurchaseReceipt] is run by 32-bit Integration Service [node01_IncoreServer], version [8.1.1 SP5], build [0822].
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: [UNICODE]
MAPPING> CMN_1570 Server Code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
MAPPING> TM_6151 Session Sort Order: [Binary]
MAPPING> TM_6185 WARNING! Data code page validation is disabled in this session.
MAPPING> TM_6156 Using LOW precision decimal arithmetic
MAPPING> TM_6180 Deadlock retry logic will not be implemented.
MAPPING> TM_6307 DTM Error Log Disabled.
MAPPING> TE_7022 TShmWriter: Initialized
MAPPING> DBG_21075 Connecting to database [bia], user [baw]
MAPPING> CMN_1716 Lookup [mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
MAPPING> TM_6007 DTM initialized successfully for session [SDE_ORA_TransactionTypeDimension_PurchaseReceipt]
DIRECTOR> PETL_24033 All DTM Connection Info: [<NONE>].
MANAGER> PETL_24004 Starting pre-session tasks. : (Sat Mar 28 22:06:31 2009)
MANAGER> PETL_24027 Pre-session task completed successfully. : (Sat Mar 28 22:06:31 2009)
DIRECTOR> PETL_24006 Starting data movement.
MAPPING> TM_6660 Total Buffer Pool size is 32000000 bytes and Block size is 128000 bytes.
READER_1_1_1> DBG_21438 Reader: Source is [vis], user [apps]
READER_1_1_1> BLKR_16051 Source database connection [ORA_R12] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
READER_1_1_1> BLKR_16003 Initialization completed successfully.
WRITER_1_*_1> WRT_8146 Writer: Target is database [bia], user [baw], bulk mode [ON]
WRITER_1_*_1> WRT_8106 Warning! Bulk Mode session - recovery is not guaranteed.
WRITER_1_*_1> WRT_8221 Target database connection [DataWarehouse] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
WRITER_1_*_1> WRT_8124 Target Table W_XACT_TYPE_DS :SQL INSERT statement:
INSERT INTO W_XACT_TYPE_DS(XACT_CODE,XACT_CAT_CODE,XACT_TYPE_CODE,XACT_TYPE_NAME,XACT_TYPE_DESC,XACT_SUBTYPE_CODE,XACT_SUBTYPE_NAME,XACT_SUBTYPE_DESC,W_XACT_TYPE_CODE,W_XACT_TYPE_DESC,W_XACT_SUBTYPE_CODE,W_XACT_SUBTYPE_DESC,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,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_XACT_TYPE_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_TransactionTypeDimension_PurchaseReceipt.Sq_FND_LOOKUP_VALUES] User specified SQL Query [SELECT
FND_LOOKUP_VALUES.LAST_UPDATE_DATE,
FND_LOOKUP_VALUES.CREATION_DATE,
FND_LOOKUP_VALUES.LOOKUP_CODE,
FND_LOOKUP_VALUES.DESCRIPTION,
'0' AS X_CUSTOM
FROM
FND_LOOKUP_VALUES
WHERE
FND_LOOKUP_VALUES.LANGUAGE = 'US' AND
FND_LOOKUP_VALUES.LOOKUP_TYPE = 'RCV TRANSACTION TYPE' AND
FND_LOOKUP_VALUES.LOOKUP_CODE = 'RECEIVE']
READER_1_1_1> RR_4049 SQL Query issued to database : (Sat Mar 28 22:06:32 2009)
WRITER_1_*_1> WRT_8005 Writer run started.
WRITER_1_*_1> WRT_8158

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

Load Start Time: Sat Mar 28 22:06:31 2009

Target tables:

W_XACT_TYPE_DS


READER_1_1_1> RR_4050 First row returned from database to reader : (Sat Mar 28 22:06:32 2009)
READER_1_1_1> BLKR_16019 Read [1] rows, read [0] error rows for source table [FND_LOOKUP_VALUES] instance name [mplt_BC_ORA_TransactionTypeDimension_PurchaseReceipt.FND_LOOKUP_VALUES]
READER_1_1_1> BLKR_16008 Reader run completed.
LKPDP_1> DBG_21097 Lookup Transformation [mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej]: Default sql to create lookup cache: SELECT DATASOURCE_NUM_ID,INTEGRATION_ID FROM W_XACT_TYPE_DS ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID

LKPDP_1> TE_7212 Increasing [Index Cache] size for transformation [mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej] from [1048576] to [1392640].
LKPDP_1> TM_6660 Total Buffer Pool size is 609824 bytes and Block size is 65536 bytes.
LKPDP_1:READER_1_1> DBG_21438 Reader: Source is [bia], user [baw]
LKPDP_1:READER_1_1> BLKR_16051 Source database connection [DataWarehouse] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
LKPDP_1:READER_1_1> BLKR_16003 Initialization completed successfully.
LKPDP_1:READER_1_1> BLKR_16007 Reader run started.
LKPDP_1:READER_1_1> RR_4049 SQL Query issued to database : (Sat Mar 28 22:06:36 2009)
LKPDP_1:READER_1_1> RR_4050 First row returned from database to reader : (Sat Mar 28 22:06:38 2009)
LKPDP_1:TRANSF_1_1> DBG_21079 Creating Lookup Cache : (Sat Mar 28 22:06:38 2009)
LKPDP_1:READER_1_1> BLKR_16019 Read [6516] rows, read [0] error rows for source table [mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej{{DSQ}}] instance name [mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej{{SRC}}]
LKPDP_1:READER_1_1> BLKR_16008 Reader run completed.
LKPDP_1:TRANSF_1_1> DBG_21682 Lookup table row count : 6516
LKPDP_1:TRANSF_1_1> DBG_21297 Lookup cache row count : 6516

LKPDP_1:TRANSF_1_1> DBG_21294 Lookup cache creation completed : (Sat Mar 28 22:06:38 2009)
LKPDP_1:TRANSF_1_1> CMN_1671 Created new cache files PMLKUP3533_131077W32.[dat/idx] in directory O:\Informatica\PowerCenter8.1.1\server\infa_shared\Cache for Lookup [mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej].
LKPDP_1:TRANSF_1_1> DBG_21641 mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej: Index cache size = [1392640], Data cache size = [2097152]
LKPDP_1:TRANSF_1_1> DBG_21216 Finished transformations for Source Qualifier [mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej{{DSQ}}]. Total errors [0]
TRANSF_1_1_1> DBG_21216 Finished transformations for Source Qualifier [mplt_BC_ORA_TransactionTypeDimension_PurchaseReceipt.Sq_FND_LOOKUP_VALUES]. Total errors [0]
WRITER_1_*_1> WRT_8167 Start loading table [W_XACT_TYPE_DS] at: Sat Mar 28 22:06:38 2009
WRITER_1_*_1> CMN_1761 Timestamp Event: [Sat Mar 28 22:06:38 2009]
WRITER_1_*_1> WRT_8229 Database errors occurred:
ORA-00604: error occurred at recursive SQL level 1
ORA-00054: resource busy and acquire with NOWAIT specified

Database driver error...
Function Name : Prepare DPL
SQL Stmt : INSERT INTO W_XACT_TYPE_DS(XACT_CODE,XACT_CAT_CODE,XACT_TYPE_CODE,XACT_TYPE_NAME,XACT_TYPE_DESC,XACT_SUBTYPE_CODE,XACT_SUBTYPE_NAME,XACT_SUBTYPE_DESC,W_XACT_TYPE_CODE,W_XACT_TYPE_DESC,W_XACT_SUBTYPE_CODE,W_XACT_SUBTYPE_DESC,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,DELETE_FLG,DATASOURCE_NUM_ID,INTEGRATION_ID,TENANT_ID,X_CUSTOM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO W_XACT_TYPE_DS(XACT_CODE,XACT_CAT_CODE,XACT_TYPE_CODE,XACT_TYPE_NAME,XACT_TYPE_DESC,XACT_SUBTYPE_CODE,XACT_SUBTYPE_NAME,XACT_SUBTYPE_DESC,W_XACT_TYPE_CODE,W_XACT_TYPE_DESC,W_XACT_SUBTYPE_CODE,W_XACT_SUBTYPE_DESC,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,DELETE_FLG,DATASOURCE_NUM_ID,INTEGRATION_ID,TENANT_ID,X_CUSTOM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
WRITER_1_*_1> CMN_1761 Timestamp Event: [Sat Mar 28 22:06:38 2009]
WRITER_1_*_1> WRT_8425 ERROR: Writer execution failed.
WRITER_1_*_1> CMN_1761 Timestamp Event: [Sat Mar 28 22:06:38 2009]
WRITER_1_*_1> WRT_8076 Writer run terminated. [Commit Error]
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_XACT_TYPE_DS] at end of load
WRITER_1_*_1> CMN_1761 Timestamp Event: [Sat Mar 28 22:06:38 2009]
WRITER_1_*_1> WRT_8081 Writer run terminated. [Error in loading data to target table [W_XACT_TYPE_DS]]
WRITER_1_*_1> WRT_8168 End loading table [W_XACT_TYPE_DS] at: Sat Mar 28 22:06:38 2009
WRITER_1_*_1> WRT_8035 Load complete time: Sat Mar 28 22:06:38 2009

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

WRT_8036 Target: W_XACT_TYPE_DS (Instance Name: [W_XACT_TYPE_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_TransactionTypeDimension_PurchaseReceipt.Sq_FND_LOOKUP_VALUES] 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_TransactionTypeDimension_PurchaseReceipt.Sq_FND_LOOKUP_VALUES] has completed: Total Run Time = [6.828123] secs, Total Idle Time = [6.812498] secs, Busy Percentage = [0.228833].
Thread [WRITER_1_*_1] created for [the write stage] of partition point [W_XACT_TYPE_DS] has completed. The total run time was insufficient for any meaningful statistics.

MANAGER> PETL_24005 Starting post-session tasks. : (Sat Mar 28 22:06:39 2009)
MANAGER> PETL_24029 Post-session task completed successfully. : (Sat Mar 28 22:06:39 2009)
MAPPING> TE_7216 Deleting cache files [PMLKUP3533_131077W32] for transformation [mplt_Xact_Type_Ins_Rej.Lkp_Xact_Type_Ins_Rej].
MAPPING> TM_6018 Session [SDE_ORA_TransactionTypeDimension_PurchaseReceipt] run 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_FND_LOOKUP_VALUES] (Instance Name: [mplt_BC_ORA_TransactionTypeDimension_PurchaseReceipt.Sq_FND_LOOKUP_VALUES])
Output Rows [1], Affected Rows [1], Applied Rows [1], Rejected Rows [0]
DIRECTOR> TM_6253 Target Load Summary.
DIRECTOR> CMN_1740 Table: [W_XACT_TYPE_DS] (Instance Name: [W_XACT_TYPE_DS])
Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
DIRECTOR> TM_6023
===================================================

DIRECTOR> TM_6020 Session [SDE_ORA_TransactionTypeDimension_PurchaseReceipt] completed at [Sat Mar 28 22:06:39 2009]




Hope it is still readeble with all those logfiles!

Hope someone can help me out!!!

Best Regards,

Remc0