Analytics Software

hi

I have Face the Problem in Incremental loading in DAC the Task SDE_ORA_GL_LinkageInformation_Extract fail every time.

the log file of the SDE_ORA_GL_LinkageInformation_Extract in informatinca

DIRECTOR> VAR_27028 Use override value [DataWarehouse] for session parameter:[$DBConnection_OLAP].
DIRECTOR> VAR_27028 Use override value [ORA_11_5_10] for session parameter:[$DBConnection_OLTP].
DIRECTOR> VAR_27028 Use override value [ORA_11_5_10.DATAWAREHOUSE.SDE_ORA11510_Adaptor.SDE_ORA_GL_LinkageInformation_Extract.log] for session parameter:[$PMSessionLogFile].
DIRECTOR> VAR_27028 Use override value [4] for mapping parameter:[$$DATASOURCE_NUM_ID].
DIRECTOR> VAR_27028 Use override value [01/01/1980] for mapping parameter:[mplt_BC_ORA_GL_LinkageInformation_Extract.$$INITIAL_EXTRACT_DATE].
DIRECTOR> VAR_27028 Use override value [11/01/2011] for mapping parameter:[mplt_BC_ORA_GL_LinkageInformation_Extract.$$LAST_EXTRACT_DATE].
DIRECTOR> TM_6014 Initializing session [SDE_ORA_GL_LinkageInformation_Extract] at [Fri Nov 04 08:30:52 2011].
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_ORA11510_Adaptor]
DIRECTOR> TM_6685 Workflow: [SDE_ORA_GL_LinkageInformation_Extract] Run Instance Name: [] Run Id: [88061]
DIRECTOR> TM_6101 Mapping name: SDE_ORA_GL_LinkageInformation_Extract [version 2].
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\PowerCenter8.6.1\server\infa_shared\Storage] will be used as storage directory for session [SDE_ORA_GL_LinkageInformation_Extract].
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 [SiebelUnicodeDB,baw@BIPROD]

DIRECTOR> TM_6703 Session [SDE_ORA_GL_LinkageInformation_Extract] is run by 64-bit Integration Service [node01_BIPRODDB], version [8.6.1], build [1218].
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 The session sort order is [Binary].
MAPPING> TM_6185 Warning. Code page validation is disabled in this session.
MAPPING> TM_6156 Using low precision processing.
MAPPING> TM_6180 Deadlock retry logic will not be implemented.
MAPPING> TM_6307 DTM error log disabled.
MAPPING> TE_7022 TShmWriter: Initialized
MAPPING> TM_6007 DTM initialized successfully for session [SDE_ORA_GL_LinkageInformation_Extract]
DIRECTOR> PETL_24033 All DTM Connection Info: [<NONE>].
MANAGER> PETL_24004 Starting pre-session tasks. : (Fri Nov 04 08:30:52 2011)
MANAGER> PETL_24027 Pre-session task completed successfully. : (Fri Nov 04 08:30:52 2011)
DIRECTOR> PETL_24006 Starting data movement.
MAPPING> TM_6660 Total Buffer Pool size is 12582912 bytes and Block size is 128000 bytes.
READER_1_1_1> DBG_21438 Reader: Source is [PROD], user [APPS]
READER_1_1_1> BLKR_16051 Source database connection [ORA_11_5_10] 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 [BIPROD], 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_GL_LINKAGE_INFORMATION_GS :SQL INSERT statement:
INSERT INTO W_GL_LINKAGE_INFORMATION_GS(SOURCE_DISTRIBUTION_ID,JOURNAL_LINE_INTEGRATION_ID,LEDGER_ID,LEDGER_TYPE,DISTRIBUTION_SOURCE,JE_BATCH_NAME,JE_HEADER_NAME,JE_LINE_NUM,POSTED_ON_DT,GL_ACCOUNT_ID,DATASOURCE_NUM_ID) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
WRITER_1_*_1> WRT_8020 No column marked as primary key for table [W_GL_LINKAGE_INFORMATION_GS]. UPDATEs Not Supported.
WRITER_1_*_1> WRT_8270 Target connection group #1 consists of target(s) [W_GL_LINKAGE_INFORMATION_GS]
WRITER_1_*_1> WRT_8003 Writer initialization complete.
READER_1_1_1> BLKR_16007 Reader run started.
WRITER_1_*_1> WRT_8005 Writer run started.
WRITER_1_*_1> WRT_8158

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

Load Start Time: Fri Nov 04 08:30:52 2011

Target tables:

W_GL_LINKAGE_INFORMATION_GS


READER_1_1_1> RR_4029 SQ Instance [mplt_BC_ORA_GL_LinkageInformation_Extract.SQ_GL_JE_LINES] User specified SQL Query [SELECT

GL_JE_LINES.JE_HEADER_ID,

GL_JE_LINES.JE_LINE_NUM,

GL_JE_LINES.SET_OF_BOOKS_ID,

GL_JE_HEADERS.JE_SOURCE,

GL_JE_HEADERS.NAME,

GL_JE_BATCHES.NAME,

GL_PERIOD_STATUSES.END_DATE,

GL_JE_LINES.GL_SL_LINK_ID,

GL_IMPORT_REFERENCES.REFERENCE_1,

GL_IMPORT_REFERENCES.REFERENCE_2,

GL_IMPORT_REFERENCES.REFERENCE_3,

GL_IMPORT_REFERENCES.REFERENCE_4,

GL_IMPORT_REFERENCES.REFERENCE_9,

GL_IMPORT_REFERENCES.REFERENCE_10,

GL_JE_HEADERS.JE_CATEGORY,

GL_SETS_OF_BOOKS.MRC_SOB_TYPE_CODE,

GL_JE_LINES.CODE_COMBINATION_ID

FROM

GL_JE_LINES,

GL_JE_HEADERS,

GL_JE_BATCHES,

GL_PERIOD_STATUSES,

GL_SETS_OF_BOOKS,

GL_IMPORT_REFERENCES

WHERE

GL_JE_LINES.JE_HEADER_ID = GL_JE_HEADERS.JE_HEADER_ID AND

UPPER(GL_JE_HEADERS.JE_SOURCE) IN ('PAYABLES', 'PURCHASING','RECEIVABLES','BUDGETARY TRANSACTION') AND

GL_JE_LINES.JE_HEADER_ID = GL_IMPORT_REFERENCES.JE_HEADER_ID AND

GL_JE_LINES.JE_LINE_NUM = GL_IMPORT_REFERENCES.JE_LINE_NUM AND

GL_JE_HEADERS.ACTUAL_FLAG IN ( 'A','E') AND

GL_JE_BATCHES.STATUS = 'P' AND

GL_JE_HEADERS.JE_BATCH_ID = GL_JE_BATCHES.JE_BATCH_ID(+) AND

GL_JE_LINES.PERIOD_NAME = GL_PERIOD_STATUSES.PERIOD_NAME AND

GL_JE_LINES.SET_OF_BOOKS_ID = GL_PERIOD_STATUSES.SET_OF_BOOKS_ID AND

GL_PERIOD_STATUSES.APPLICATION_ID = 101 AND

GL_JE_LINES.SET_OF_BOOKS_ID = GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID AND

(

GL_JE_BATCHES.LAST_UPDATE_DATE > TO_DATE('11/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS')

)]
READER_1_1_1> RR_4049 SQL Query issued to database : (Fri Nov 04 08:30:52 2011)
READER_1_1_1> RR_4050 First row returned from database to reader : (Fri Nov 04 08:30:53 2011)
WRITER_1_*_1> WRT_8167 Start loading table [W_GL_LINKAGE_INFORMATION_GS] at: Fri Nov 04 08:30:53 2011
WRITER_1_*_1> CMN_1761 Timestamp Event: [Fri Nov 04 08:30:53 2011]
WRITER_1_*_1> WRT_8229 Database errors occurred:
ORA-26002: Table BAW.W_GL_LINKAGE_INFORMATION_GS has index defined upon it.

Database driver error...
Function Name : Prepare DPL
SQL Stmt : INSERT INTO W_GL_LINKAGE_INFORMATION_GS(SOURCE_DISTRIBUTION_ID,JOURNAL_LINE_INTEGRATION_ID,LEDGER_ID,LEDGER_TYPE,DISTRIBUTION_SOURCE,JE_BATCH_NAME,JE_HEADER_NAME,JE_LINE_NUM,POSTED_ON_DT,GL_ACCOUNT_ID,DATASOURCE_NUM_ID) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO W_GL_LINKAGE_INFORMATION_GS(SOURCE_DISTRIBUTION_ID,JOURNAL_LINE_INTEGRATION_ID,LEDGER_ID,LEDGER_TYPE,DISTRIBUTION_SOURCE,JE_BATCH_NAME,JE_HEADER_NAME,JE_LINE_NUM,POSTED_ON_DT,GL_ACCOUNT_ID,DATASOURCE_NUM_ID) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
WRITER_1_*_1> CMN_1761 Timestamp Event: [Fri Nov 04 08:30:53 2011]
WRITER_1_*_1> WRT_8425 ERROR: Writer execution failed.
WRITER_1_*_1> CMN_1761 Timestamp Event: [Fri Nov 04 08:30:53 2011]
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_GL_LINKAGE_INFORMATION_GS] at end of load
WRITER_1_*_1> CMN_1761 Timestamp Event: [Fri Nov 04 08:30:53 2011]
WRITER_1_*_1> WRT_8081 Writer run terminated. [Error in loading data to target table [W_GL_LINKAGE_INFORMATION_GS]]
WRITER_1_*_1> WRT_8168 End loading table [W_GL_LINKAGE_INFORMATION_GS] at: Fri Nov 04 08:30:53 2011
WRITER_1_*_1> WRT_8035 Load complete time: Fri Nov 04 08:30:53 2011

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

WRT_8036 Target: W_GL_LINKAGE_INFORMATION_GS (Instance Name: [W_GL_LINKAGE_INFORMATION_GS])
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_GL_LinkageInformation_Extract.SQ_GL_JE_LINES] has completed.
Total Run Time = [0.906250] secs
Total Idle Time = [0.000000] secs
Busy Percentage = [100.000000]
Thread [TRANSF_1_1_1] created for [the transformation stage] of partition point [mplt_BC_ORA_GL_LinkageInformation_Extract.SQ_GL_JE_LINES] 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_GL_LINKAGE_INFORMATION_GS] has completed. The total run time was insufficient for any meaningful statistics.

MANAGER> PETL_24005 Starting post-session tasks. : (Fri Nov 04 08:30:53 2011)
MANAGER> PETL_24029 Post-session task completed successfully. : (Fri Nov 04 08:30:53 2011)
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_GL_JE_LINES] (Instance Name: [mplt_BC_ORA_GL_LinkageInformation_Extract.SQ_GL_JE_LINES])
Output Rows [128], Affected Rows [128], Applied Rows [128], Rejected Rows [0]
DIRECTOR> TM_6253 Target Load Summary.
DIRECTOR> CMN_1740 Table: [W_GL_LINKAGE_INFORMATION_GS] (Instance Name: [W_GL_LINKAGE_INFORMATION_GS])
Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
DIRECTOR> TM_6023
===================================================

DIRECTOR> TM_6020 Session [SDE_ORA_GL_LinkageInformation_Extract] completed at [Fri Nov 04 08:30:54 2011].