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
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 EnabledDIRECTOR> 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: InitializedMAPPING> 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 2013Target tables:W_ORA_GL_JOURNALS_F_TMPREADER_1_1_1> RR_4029 SQ Instance [mplt_BC_ORA_GLXactsJournalsExtract.SQ_GL_JE_LINES] User specified SQL Query [SELECTJEL.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_FLAGFROMGL_JE_LINES JEL,GL_JE_HEADERS JEH,GL_JE_BATCHES JEB,GL_PERIOD_STATUSES PRDS,GL_LEDGERS GLWHEREJEL.JE_HEADER_ID = JEH.JE_HEADER_IDAND JEH.ACTUAL_FLAG = 'A'AND JEB.STATUS = 'P'AND JEH.JE_BATCH_ID = JEB.JE_BATCH_ID (+)AND JEL.PERIOD_NAME = PRDS.PERIOD_NAMEAND JEL.LEDGER_ID = PRDS.SET_OF_BOOKS_IDAND JEL.LEDGER_ID = GL.LEDGER_IDAND PRDS.APPLICATION_ID = 101AND 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 2013WRITER_1_*_1> WRT_8161TARGET 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: 10200WRITER_1_*_1> WRT_8161TARGET 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: 20400WRITER_1_*_1> WRT_8161TARGET 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: 30600WRITER_1_*_1> WRT_8161TARGET 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: 40800WRITER_1_*_1> WRT_8161TARGET 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: 51000WRITER_1_*_1> WRT_8161TARGET 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: 61200WRITER_1_*_1> WRT_8161TARGET 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: 71400WRITER_1_*_1> WRT_8161TARGET 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: 81600WRITER_1_*_1> WRT_8161TARGET 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: 91800WRITER_1_*_1> WRT_8161TARGET 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: 102000WRITER_1_*_1> WRT_8161TARGET 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: 112200WRITER_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 MultipleSQL 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_8114Row # [1] in bad fileWRITER_1_*_1> CMN_1053 : Rowdata: ( RowType=0(insert) Src Rowid=118696 Targ Rowid=118696SET_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 madeDatabase driver error...Function Name : CommitDatabase 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 2013WRITER_1_*_1> WRT_8035 Load complete time: Tue Aug 20 13:59:22 2013LOAD 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: 118695WRITER_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] secsTotal Idle Time = [0.000000] secsBusy 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] secsTotal Idle Time = [688.687500] secsBusy 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] secsTotal Idle Time = [683.328125] secsBusy 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_6022SESSION 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].
ReplyDeleteWhen you creating integration service in informatica.
make sure Data Movement Mode = ASCII not unicode..
Thanks
Kashif M
ReplyDeletedac error code 36331 happens for many reason,
If the informatica unable to execute anything, it will pull you for 36331
Mainly we need to check connection establishment between informatica/dac/database
ReplyDelete