Skip to main content

dac error code 36331


I have recently faced this error in OBIA 7.9.6.3

To retify it,

1. You need to set Oracle Database Parameter "Processes" from 150 to 500, It will be in the location ---- E:\app\7stl\admin\apps\pfile

2. Go to datawarehouse table W_ORA_GL_JOURNALS_F_TMP and find the column GL_JE_BATCHES_NAME, change the size from 100 to 200.

3. Go to datawarehouse table W_GL_SEGMENT_DS and find the column SEGMENT_VAL_CODE, change the size from 50to 100.

4. more important thing is just check all the connection once again, odbc connection,informatica relational connection and finally dac paramenter generation.

error 36331 mainly happens in informatica because of  values extended  limit from source to target, that is our OLTP to OLAP.



Sample error log for this

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_GLJournals_Full.log] for session parameter:[$PMSessionLogFile].
DIRECTOR> VAR_27028 Use override value [1000] for mapping parameter:[$$DATASOURCE_NUM_ID].
DIRECTOR> VAR_27028 Use override value ['Y'] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$FILTER_BY_LEDGER_ID].
DIRECTOR> VAR_27028 Use override value ['Y'] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$FILTER_BY_LEDGER_TYPE].
DIRECTOR> VAR_27028 Use override value [01/01/2001] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$INITIAL_EXTRACT_DATE].
DIRECTOR> VAR_27028 Use override value [] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$LAST_EXTRACT_DATE].
DIRECTOR> VAR_27028 Use override value [2021] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$LEDGER_ID_LIST].
DIRECTOR> VAR_27028 Use override value ['PRIMARY'] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$LEDGER_TYPE_LIST].
DIRECTOR> TM_6014 Initializing session [SDE_ORA_GLJournals_Full] at [Tue Aug 20 13:47:45 2013].
DIRECTOR> TM_6683 Repository Name: [ORACLE_BI_DW_BASE]
DIRECTOR> TM_6684 Server Name: [ORACLE_BI_DW_BASE_INTEGRATION]
DIRECTOR> TM_6686 Folder: [SDE_ORAR1213_Adaptor]
DIRECTOR> TM_6685 Workflow: [SDE_ORA_GLJournals_Full] Run Instance Name: [] Run Id: [187]
DIRECTOR> TM_6101 Mapping name: SDE_ORA_GLJournals [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_GLJournals_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_6708 Using configuration property [SiebelUnicodeDB,apps@R12PLY baw@ARABIC]
DIRECTOR> TM_6708 Using configuration property [overrideMpltVarWithMapVar,Yes]
DIRECTOR> TM_6708 Using configuration property [DisableDB2BulkMode,Yes]
DIRECTOR> TM_6708 Using configuration property [ServerPort,4006]

DIRECTOR> TM_6703 Session [SDE_ORA_GLJournals_Full] is run by 32-bit Integration Service  [node01_7stl-56], 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: [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_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_GLJournals_Full]
DIRECTOR> PETL_24033 All DTM Connection Info: [<NONE>].
MANAGER> PETL_24004 Starting pre-session tasks. : (Tue Aug 20 13:47:45 2013)
MANAGER> PETL_24027 Pre-session task completed successfully. : (Tue Aug 20 13:47:45 2013)
DIRECTOR> PETL_24006 Starting data movement.
MAPPING> TM_6660 Total Buffer Pool size is 32000000 bytes and Block size is 1280000 bytes.
READER_1_1_1> DBG_21438 Reader: Source is [R12PLY], user [apps]
READER_1_1_1> BLKR_16051 Source database connection [ORA_R1213] code page: [UTF-8 encoding of Unicode]
READER_1_1_1> BLKR_16003 Initialization completed successfully.
WRITER_1_*_1> WRT_8146 Writer: Target is database [ARABIC], 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: [UTF-8 encoding of Unicode]
WRITER_1_*_1> WRT_8397 Appending output data to file [C:\Informatica\9.0.1\server\infa_shared\BadFiles\w_ora_gl_journals_ts1.bad] (initial size [1365]).
WRITER_1_*_1> WRT_8124 Target Table W_ORA_GL_JOURNALS_F_TMP :SQL INSERT statement:
INSERT INTO W_ORA_GL_JOURNALS_F_TMP(SET_OF_BOOKS_ID,CODE_COMB_ID,GL_ACCT_ID,PERIOD_NAME,EFFECTIVE_DATE,ACCT_PERIOD_END_DT,STATUS,ENTERED_DR,ENTERED_CR,ACCOUNTED_DR,ACCOUNTED_CR,JE_CATEGORY,JE_SOURCE,CREATED_BY,LAST_UPDATED_BY,CREATION_DATE,LAST_UPDATE_DATE,POSTED_DATE,CURRENCY_CODE,GL_JE_BATCHES_NAME,GL_JE_LINES_NUM,GL_JE_HEADERS_NAME,ADJUSTMENT_FLG,REFERENCE_1,REFERENCE_2,REFERENCE_3,REFERENCE_4,REFERENCE_5,REFERENCE_6,REFERENCE_7,REFERENCE_8,REFERENCE_9,REFERENCE_10,GL_SL_LINK_ID,PRIMARY_LEDGER_FLG,INTEGRATION_ID,DATASOURCE_NUM_ID)  VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 
WRITER_1_*_1> WRT_8270 Target connection group #1 consists of target(s) [W_ORA_GL_JOURNALS_F_TMP]
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: Tue Aug 20 13:47:49 2013

Target tables:

     W_ORA_GL_JOURNALS_F_TMP


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

  JEL.JE_HEADER_ID,

  JEL.JE_LINE_NUM,

  JEL.LAST_UPDATE_DATE,

  JEL.LAST_UPDATED_BY,

  JEL.LEDGER_ID,

  JEL.CODE_COMBINATION_ID,

  JEL.PERIOD_NAME,

  JEL.STATUS,

  JEL.CREATION_DATE,

  JEL.CREATED_BY,

  JEL.ENTERED_DR,

  JEL.ENTERED_CR,

  JEL.ACCOUNTED_DR,

  JEL.ACCOUNTED_CR,

  JEL.REFERENCE_1,

  JEL.REFERENCE_2,

  JEL.REFERENCE_3,

  JEL.REFERENCE_4,

  JEL.REFERENCE_5,

  JEL.REFERENCE_6,

  JEL.REFERENCE_7,

  JEL.REFERENCE_8,

  JEL.REFERENCE_9,

  JEL.REFERENCE_10,

  JEL.GL_SL_LINK_ID,

  JEH.JE_CATEGORY,

  JEH.JE_SOURCE,

  JEH.NAME,

  JEH.CURRENCY_CODE,

  JEH.POSTED_DATE,

  JEB.NAME,

  PRDS.START_DATE,

  PRDS.END_DATE,

  GL.LEDGER_CATEGORY_CODE,

 PRDS.ADJUSTMENT_PERIOD_FLAG

FROM 

  GL_JE_LINES                     JEL,

  GL_JE_HEADERS             JEH,

  GL_JE_BATCHES             JEB,

  GL_PERIOD_STATUSES PRDS,

  GL_LEDGERS                     GL

WHERE 

            JEL.JE_HEADER_ID                  =   JEH.JE_HEADER_ID  

  AND JEH.ACTUAL_FLAG                  = 'A'  

  AND JEB.STATUS                              = 'P'  

  AND JEH.JE_BATCH_ID                    = JEB.JE_BATCH_ID (+) 

  AND JEL.PERIOD_NAME                   = PRDS.PERIOD_NAME 

  AND JEL.LEDGER_ID                          = PRDS.SET_OF_BOOKS_ID 

  AND JEL.LEDGER_ID                          = GL.LEDGER_ID 

  AND PRDS.APPLICATION_ID            = 101 

  AND JEH.CURRENCY_CODE<>'STAT'

  AND ( JEB.CREATION_DATE  >= 

            TO_DATE('01/01/2001 00:00:00', 'MM/DD/YYYY HH24:MI:SS') 

      )

AND DECODE('Y', 'Y', GL.LEDGER_ID, 1) IN (2021)

AND DECODE('Y', 'Y', GL.LEDGER_CATEGORY_CODE, 'NONE') IN ('PRIMARY')]
READER_1_1_1> RR_4049 SQL Query issued to database : (Tue Aug 20 13:47:49 2013)
READER_1_1_1> RR_4050 First row returned from database to reader : (Tue Aug 20 13:47:53 2013)
WRITER_1_*_1> WRT_8167 Start loading table [W_ORA_GL_JOURNALS_F_TMP] at: Tue Aug 20 13:47:53 2013
WRITER_1_*_1> WRT_8161 
TARGET BASED COMMIT POINT  Tue Aug 20 13:49:00 2013
===================================================

WRT_8036 Target: W_ORA_GL_JOURNALS_F_TMP (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
WRT_8038 Inserted rows - Requested: 10200      Applied: 10200      Rejected: 0          Affected: 10200     

WRITER_1_*_1> WRT_8161 
TARGET BASED COMMIT POINT  Tue Aug 20 13:50:09 2013
===================================================

WRT_8036 Target: W_ORA_GL_JOURNALS_F_TMP (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
WRT_8038 Inserted rows - Requested: 20400      Applied: 20400      Rejected: 0          Affected: 20400     

WRITER_1_*_1> WRT_8161 
TARGET BASED COMMIT POINT  Tue Aug 20 13:51:29 2013
===================================================

WRT_8036 Target: W_ORA_GL_JOURNALS_F_TMP (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
WRT_8038 Inserted rows - Requested: 30600      Applied: 30600      Rejected: 0          Affected: 30600     

WRITER_1_*_1> WRT_8161 
TARGET BASED COMMIT POINT  Tue Aug 20 13:52:12 2013
===================================================

WRT_8036 Target: W_ORA_GL_JOURNALS_F_TMP (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
WRT_8038 Inserted rows - Requested: 40800      Applied: 40800      Rejected: 0          Affected: 40800     

WRITER_1_*_1> WRT_8161 
TARGET BASED COMMIT POINT  Tue Aug 20 13:52:57 2013
===================================================

WRT_8036 Target: W_ORA_GL_JOURNALS_F_TMP (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
WRT_8038 Inserted rows - Requested: 51000      Applied: 51000      Rejected: 0          Affected: 51000     

WRITER_1_*_1> WRT_8161 
TARGET BASED COMMIT POINT  Tue Aug 20 13:53:47 2013
===================================================

WRT_8036 Target: W_ORA_GL_JOURNALS_F_TMP (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
WRT_8038 Inserted rows - Requested: 61200      Applied: 61200      Rejected: 0          Affected: 61200     

WRITER_1_*_1> WRT_8161 
TARGET BASED COMMIT POINT  Tue Aug 20 13:54:38 2013
===================================================

WRT_8036 Target: W_ORA_GL_JOURNALS_F_TMP (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
WRT_8038 Inserted rows - Requested: 71400      Applied: 71400      Rejected: 0          Affected: 71400     

WRITER_1_*_1> WRT_8161 
TARGET BASED COMMIT POINT  Tue Aug 20 13:55:29 2013
===================================================

WRT_8036 Target: W_ORA_GL_JOURNALS_F_TMP (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
WRT_8038 Inserted rows - Requested: 81600      Applied: 81600      Rejected: 0          Affected: 81600     

WRITER_1_*_1> WRT_8161 
TARGET BASED COMMIT POINT  Tue Aug 20 13:56:25 2013
===================================================

WRT_8036 Target: W_ORA_GL_JOURNALS_F_TMP (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
WRT_8038 Inserted rows - Requested: 91800      Applied: 91800      Rejected: 0          Affected: 91800     

WRITER_1_*_1> WRT_8161 
TARGET BASED COMMIT POINT  Tue Aug 20 13:57:27 2013
===================================================

WRT_8036 Target: W_ORA_GL_JOURNALS_F_TMP (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
WRT_8038 Inserted rows - Requested: 102000     Applied: 102000     Rejected: 0          Affected: 102000    

WRITER_1_*_1> WRT_8161 
TARGET BASED COMMIT POINT  Tue Aug 20 13:58:43 2013
===================================================

WRT_8036 Target: W_ORA_GL_JOURNALS_F_TMP (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
WRT_8038 Inserted rows - Requested: 112200     Applied: 112200     Rejected: 0          Affected: 112200    

WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Aug 20 13:59:23 2013]
WRITER_1_*_1> WRT_8229 Database errors occurred: 
ORA-12899: value too large for column GL_JE_BATCHES_NAME (actual: 140, maximum: 100)

Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO W_ORA_GL_JOURNALS_F_TMP(SET_OF_BOOKS_ID,CODE_COMB_ID,GL_ACCT_ID,PERIOD_NAME,EFFECTIVE_DATE,ACCT_PERIOD_END_DT,STATUS,ENTERED_DR,ENTERED_CR,ACCOUNTED_DR,ACCOUNTED_CR,JE_CATEGORY,JE_SOURCE,CREATED_BY,LAST_UPDATED_BY,CREATION_DATE,LAST_UPDATE_DATE,POSTED_DATE,CURRENCY_CODE,GL_JE_BATCHES_NAME,GL_JE_LINES_NUM,GL_JE_HEADERS_NAME,ADJUSTMENT_FLG,REFERENCE_1,REFERENCE_2,REFERENCE_3,REFERENCE_4,REFERENCE_5,REFERENCE_6,REFERENCE_7,REFERENCE_8,REFERENCE_9,REFERENCE_10,GL_SL_LINK_ID,PRIMARY_LEDGER_FLG,INTEGRATION_ID,DATASOURCE_NUM_ID)  VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Aug 20 13:59:23 2013]
WRITER_1_*_1> WRT_8425 ERROR: Writer execution failed.
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Aug 20 13:59:23 2013]
WRITER_1_*_1> WRT_8114 
Row # [1] in bad file

WRITER_1_*_1> CMN_1053 : Rowdata: ( RowType=0(insert) Src Rowid=118696 Targ Rowid=118696
  SET_OF_BOOKS_ID (SET_OF_BOOKS_ID:Double:): "2021.000000000000"
  CODE_COMB_ID (CODE_COMB_ID:Double:): "28976.00000000000"
  GL_ACCT_ID (GL_ACCT_ID:UniChar.80:): "28976"
  PERIOD_NAME (PERIOD_NAME:UniChar.15:): "Nov-11"
  EFFECTIVE_DATE (EFFECTIVE_DATE:Date:): "11/01/2011 00:00:00.000000000"
  ACCT_PERIOD_END_DT (ACCT_PERIOD_END_DT:Date:): "11/30/2011 00:00:00.000000000"
  STATUS (STATUS:UniChar.1:): "P"
  ENTERED_DR (ENTERED_DR:Double:): "20000.00000000000"
  ENTERED_CR (ENTERED_CR:Double:): "(NULL)"
  ACCOUNTED_DR (ACCOUNTED_DR:Double:): "20000.00000000000"
  ACCOUNTED_CR (ACCOUNTED_CR:Double:): "(NULL)"
  JE_CATEGORY (JE_CATEGORY:UniChar.25:): "22"
  JE_SOURCE (JE_SOURCE:UniChar.25:): "Manual"
  CREATED_BY (CREATED_BY:Double:): "1261.000000000000"
  LAST_UPDATED_BY (LAST_UPDATED_BY:Double:): "1261.000000000000"
  CREATION_DATE (CREATION_DATE:Date:): "11/27/2011 18:20:26.000000000"
  LAST_UPDATE_DATE (LAST_UPDATE_DATE:Date:): "01/23/2012 10:41:47.000000000"
  POSTED_DATE (POSTED_DATE:Date:): "01/23/2012 10:41:47.000000000"
  CURRENCY_CODE (CURRENCY_CODE:UniChar.15:): "SAR"
  GL_JE_BATCHES_NAME (GL_JE_BATCHES_NAME:UniChar.100:): "?????? ????? ????? ??????? ???????? ??????? 27-NOV-2011 18:17:54"
  GL_JE_LINES_NUM (GL_JE_LINES_NUM:Double:): "1.000000000000000"
  GL_JE_HEADERS_NAME (GL_JE_HEADERS_NAME:UniChar.100:): "Donations to the care of prisoners in Medina"
  ADJUSTMENT_FLG (ADJUSTMENT_FLG:UniChar.1:): "N"
  REFERENCE_1 (REFERENCE_1:UniChar.240:): "(NULL)"
  REFERENCE_2 (REFERENCE_2:UniChar.240:): "(NULL)"
  REFERENCE_3 (REFERENCE_3:UniChar.240:): "(NULL)"
  REFERENCE_4 (REFERENCE_4:UniChar.240:): "(NULL)"
  REFERENCE_5 (REFERENCE_5:UniChar.240:): "(NULL)"
  REFERENCE_6 (REFERENCE_6:UniChar.240:): "(NULL)"
  REFERENCE_7 (REFERENCE_7:UniChar.240:): "(NULL)"
  REFERENCE_8 (REFERENCE_8:UniChar.240:): "(NULL)"
  REFERENCE_9 (REFERENCE_9:UniChar.240:): "(NULL)"
  REFERENCE_10 (REFERENCE_10:UniChar.240:): "(NULL)"
  GL_SL_LINK_ID (GL_SL_LINK_ID:Double:): "(NULL)"
  PRIMARY_LEDGER_FLG (PRIMARY_LEDGER_FLG:UniChar.1:): "Y"
  INTEGRATION_ID (INTEGRATION_ID:UniChar.80:): "64345~1"
  DATASOURCE_NUM_ID (DATASOURCE_NUM_ID:Double:): "1000.000000000000"
)

WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Aug 20 13:59:23 2013]
WRITER_1_*_1> WRT_8164 Error loading into target [W_ORA_GL_JOURNALS_F_TMP] : Bad rows exceeded Session Threshold [1]
WRITER_1_*_1> WRT_8333 Rolling back all the targets due to fatal session error.
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Aug 20 13:59:23 2013]
WRITER_1_*_1> CMN_1022 Database driver error...
CMN_1022 [

ORA-24795: Illegal ROLLBACK attempt made


Database driver error...

Function Name : Commit

Database driver error...

Function Name : Rollback]

WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Aug 20 13:59:23 2013]
WRITER_1_*_1> WRT_8183 Rollback failed for the target [W_ORA_GL_JOURNALS_F_TMP]
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Aug 20 13:59:23 2013]
WRITER_1_*_1> WRT_8080 Writer run terminated. [Error loading data and error threshold reached]
WRITER_1_*_1> WRT_8168 End loading table [W_ORA_GL_JOURNALS_F_TMP] at: Tue Aug 20 13:59:22 2013
WRITER_1_*_1> WRT_8035 Load complete time: Tue Aug 20 13:59:22 2013

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

WRT_8036 Target: W_ORA_GL_JOURNALS_F_TMP (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
WRT_8038 Inserted rows - Requested: 118728     Applied: 118695     Rejected: 1          Affected: 118695    


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_GLXactsJournalsExtract.SQ_GL_JE_LINES] has completed.
Total Run Time = [695.984375] 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_GLXactsJournalsExtract.SQ_GL_JE_LINES] has completed.
Total Run Time = [689.406250] secs
Total Idle Time = [688.687500] secs
Busy Percentage = [0.104256]
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_ORA_GL_JOURNALS_F_TMP] has completed.
Total Run Time = [689.406250] secs
Total Idle Time = [683.328125] secs
Busy Percentage = [0.881646]

MANAGER> PETL_24005 Starting post-session tasks. : (Tue Aug 20 13:59:26 2013)
MANAGER> PETL_24029 Post-session task completed successfully. : (Tue Aug 20 13:59:26 2013)
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_GLXactsJournalsExtract.SQ_GL_JE_LINES])
Output Rows [119016], Affected Rows [119016], Applied Rows [119016], Rejected Rows [0]
DIRECTOR> TM_6253 Target Load Summary.
DIRECTOR> CMN_1740 Table: [W_ORA_GL_JOURNALS_F_TMP] (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
Output Rows [118524], Affected Rows [118524], Applied Rows [118524], Rejected Rows [1]
DIRECTOR> TM_6023 
===================================================

DIRECTOR> TM_6020 Session [SDE_ORA_GLJournals_Full] completed at [Tue Aug 20 13:59:26 2013].

Comments


  1. When you creating integration service in informatica.

    make sure Data Movement Mode = ASCII not unicode..

    Thanks
    Kashif M

    ReplyDelete

  2. dac error code 36331 happens for many reason,

    If the informatica unable to execute anything, it will pull you for 36331

    ReplyDelete
  3. Mainly we need to check connection establishment between informatica/dac/database

    ReplyDelete

Post a Comment

Popular posts from this blog

Contact Me

Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com

Top 130 SQL Interview Questions And Answers

1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10

Informatica sample project

Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope