5 Replies Latest reply on Dec 28, 2009 1:53 PM by 576620

    ETL Tasks failing Database driver error...Function Name : Execute Multiple

    637847
      HI,

      We have Installed OBI Apps V796. Below are the details.

      OBI Apps V796
      OBIEE 10.1.3.4.1
      DAC 10.1.3.4.1
      Informatica 8.6.0

      We are getting the below error for the task "SDE_ORA_PartyPersonDimension_Customer" when we run the execution plan related to supply chain and order management analytics.

      "
      Severity     Timestamp     Node     Thread     Message Code     Message
      ERROR     6/23/2009 8:25:54 PM     node01_obiee     WRITER_1_*_1     WRT_8229     Database errors occurred:

      Database driver error...
      Function Name : Execute Multiple
      SQL Stmt : INSERT INTO W_PARTY_PER_DS(PARTY_TYPE,FST_NAME,FULL_NAME,MID_NAME,LAST_NAME,DEPARTMENT_NAME,CONTACT_ID,CONTACT_TYPE,FAX_PH_NUM,PAGER_NUM,MOBILE_NUM,WORK_PHONE,SEX_MF_CD,ETHNICITY_CD,MARITAL_STAT_CD,BIRTH_DT,BIRTH_PLACE,DEATH_DT,ST_ADDRESS,CITY,STATE,ZIPCODE,COUNTRY,EMAIL_ADDR,JOB_TITLE,ANNL_INCOME,SUPPRESS_EMAIL_FLG,PROF_TITLE,STATUS_CD,ST_ADDRESS2,ST_ADDRESS3,ST_ADDRESS4,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,SRC_EFF_FROM_DT,SRC_EFF_TO_DT,DELETE_FLG,DATASOURCE_NUM_ID,INTEGRATION_ID,TENANT_ID,X_CUSTOM,CUSTOMER_NUM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ".


      As a work around we tried by changing the Target load type option to normal(previously it is bulk) and still the task failed. Also tried by enabling the Constraint based loading option and still the tas got failed.

      Any suggestions............

      As


      Regards
      Venkatesh.
        • 1. Re: ETL Tasks failing Database driver error...Function Name : Execute Multiple
          rmoff
          What's your database & version?

          Can you check the session log for the DB error? For example on Oracle you'd get an ORA-xxxxx error code & message in the session log which might give you more of an indication where the problem lies.
          • 2. Re: ETL Tasks failing Database driver error...Function Name : Execute Multiple
            637847
            HI,

            We are using Oracle Database.

            Source database version : 10.2.0
            Target database version : 10.2.0

            Also Oracle ERP Application 11.5.10 as source

            The strange thing we observed is that we are not getting any error codes.The error message which I have posted in the thread is the only error message. We are getting only message like "database driver error" but not getting any error codes.Also in the session logs we are getting the files with .bin extension.

            thanks
            Venkatesh
            • 3. Re: ETL Tasks failing Database driver error...Function Name : Execute Multiple
              679808
              Hi Venkatesh,

              I recommend you check your Source/Target columns' data types and lengths. If it is OOTB installation (no customization), they should be consistent, but you can never be sure.
              If they are fine, try to run a debug session in your Workflow Manager - it will let you check columns insertion one by one and diagnose where the problem appears.

              P.S. - I agree with rnm1978 - it would be helpful to get a wider context of your error (more of the logfile).

              Hope it helps..
              Michal
              • 4. Re: ETL Tasks failing Database driver error...Function Name : Execute Multiple
                rmoff
                Can you post the entire session logfile?
                • 5. Re: ETL Tasks failing Database driver error...Function Name : Execute Multiple
                  576620
                  Exactly same problem I'm also facing. The log is not showing any exact error information for the cause. And the surprise thing is when i'm running the debugger its inserting all the records. But when i run the task it is failing. Here is the log.

                  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_PartyPersonDimension_Customer_Full.log] for session parameter:[$PMSessionLogFile].
                  DIRECTOR> VAR_27028 Use override value [4] for mapping parameter:[$$DATASOURCE_NUM_ID].
                  DIRECTOR> VAR_27027 Use default value [] for mapping parameter:[mplt_BC_ORA_PartyPersonDimension.$$Hint1].
                  DIRECTOR> VAR_27027 Use default value [] for mapping parameter:[mplt_BC_ORA_PartyPersonDimension.$$Hint2].
                  DIRECTOR> VAR_27027 Use default value [] for mapping parameter:[mplt_BC_ORA_PartyPersonDimension.$$LAST_EXTRACT_DATE].
                  DIRECTOR> VAR_27028 Use override value [DEFAULT] for mapping parameter:[$$TENANT_ID].
                  DIRECTOR> TM_6014 Initializing session [SDE_ORA_PartyPersonDimension_Customer_Full] at [Mon Dec 28 19:10:26 2009].
                  DIRECTOR> TM_6683 Repository Name: [AA_REPOSITORY_SERVICE]
                  DIRECTOR> TM_6684 Server Name: [AA_INTEGRATION_SERVICE]
                  DIRECTOR> TM_6686 Folder: [SDE_ORA11510_Adaptor]
                  DIRECTOR> TM_6685 Workflow: [SDE_ORA_PartyPersonDimension_Customer_Full] Run Instance Name: [] Run Id: [1371]
                  DIRECTOR> TM_6101 Mapping name: SDE_ORA_PartyPersonDimension_Customer [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_6703 Session [SDE_ORA_PartyPersonDimension_Customer_Full] is run by 32-bit Integration Service [node01_obiee], version [8.6.1 HotFix6], build [0622].
                  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: [UTF-8 encoding of Unicode]
                  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> DBG_21075 Connecting to database [BIDB], user [AABAW]
                  MAPPING> CMN_1716 Lookup [Lkp_W_ORA_PARTY_CONTACT_PS] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
                  MAPPING> CMN_1761 Timestamp Event: [Mon Dec 28 19:10:26 2009]
                  MAPPING> TE_7004 Transformation Parse Warning [IIF(ISNULL(CONTACT_PARTY_ID||DATASOURCE_NUM_ID), '', 'Contact')]; transformation continues...
                  MAPPING> CMN_1761 Timestamp Event: [Mon Dec 28 19:10:26 2009]
                  MAPPING> TE_7004 Transformation Parse Warning [<<PM Parse Warning>> [||]: operand converted to a string
                  ... IIF(ISNULL(CONTACT_PARTY_ID||>>>>DATASOURCE_NUM_ID<<<<), '', 'Contact')]; transformation continues...
                  MAPPING> TM_6007 DTM initialized successfully for session [SDE_ORA_PartyPersonDimension_Customer_Full]
                  DIRECTOR> PETL_24033 All DTM Connection Info: [<NONE>].
                  MANAGER> PETL_24004 Starting pre-session tasks. : (Mon Dec 28 19:10:26 2009)
                  MANAGER> PETL_24027 Pre-session task completed successfully. : (Mon Dec 28 19:10:26 2009)
                  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 [DEV01], 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 [BIDB], user [AABAW], 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_PARTY_PER_DS :SQL INSERT statement:
                  INSERT INTO W_PARTY_PER_DS(PARTY_TYPE,FST_NAME,FULL_NAME,MID_NAME,LAST_NAME,DEPARTMENT_NAME,CONTACT_ID,CONTACT_TYPE,FAX_PH_NUM,PAGER_NUM,MOBILE_NUM,WORK_PHONE,SEX_MF_CD,ETHNICITY_CD,MARITAL_STAT_CD,BIRTH_DT,BIRTH_PLACE,DEATH_DT,ST_ADDRESS,CITY,STATE,ZIPCODE,COUNTRY,EMAIL_ADDR,JOB_TITLE,ANNL_INCOME,CON_ACTIVE_FLG1,SUPPRESS_EMAIL_FLG,PROF_TITLE,STATUS_CD,ST_ADDRESS2,ST_ADDRESS3,ST_ADDRESS4,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,SRC_EFF_FROM_DT,SRC_EFF_TO_DT,DELETE_FLG,DATASOURCE_NUM_ID,INTEGRATION_ID,TENANT_ID,X_CUSTOM,CUSTOMER_NUM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
                  WRITER_1_*_1> WRT_8124 Target Table W_PARTY_PER_DS :SQL UPDATE statement:
                  UPDATE W_PARTY_PER_DS SET PARTY_TYPE = ?, FST_NAME = ?, FULL_NAME = ?, MID_NAME = ?, LAST_NAME = ?, DEPARTMENT_NAME = ?, CONTACT_ID = ?, CONTACT_TYPE = ?, FAX_PH_NUM = ?, PAGER_NUM = ?, MOBILE_NUM = ?, WORK_PHONE = ?, SEX_MF_CD = ?, ETHNICITY_CD = ?, MARITAL_STAT_CD = ?, BIRTH_DT = ?, BIRTH_PLACE = ?, DEATH_DT = ?, ST_ADDRESS = ?, CITY = ?, STATE = ?, ZIPCODE = ?, COUNTRY = ?, EMAIL_ADDR = ?, JOB_TITLE = ?, ANNL_INCOME = ?, CON_ACTIVE_FLG1 = ?, SUPPRESS_EMAIL_FLG = ?, PROF_TITLE = ?, STATUS_CD = ?, ST_ADDRESS2 = ?, ST_ADDRESS3 = ?, ST_ADDRESS4 = ?, 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 = ?, SRC_EFF_TO_DT = ?, DELETE_FLG = ?, TENANT_ID = ?, X_CUSTOM = ?, CUSTOMER_NUM = ? WHERE SRC_EFF_FROM_DT = ? AND DATASOURCE_NUM_ID = ? AND INTEGRATION_ID = ?
                  WRITER_1_*_1> WRT_8124 Target Table W_PARTY_PER_DS :SQL DELETE statement:
                  DELETE FROM W_PARTY_PER_DS WHERE SRC_EFF_FROM_DT = ? AND DATASOURCE_NUM_ID = ? AND INTEGRATION_ID = ?
                  WRITER_1_*_1> WRT_8270 Target connection group #1 consists of target(s) [W_PARTY_PER_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_PartyPersonDimension.SQ_HZ_PERSON_PARTY] User specified SQL Query [SELECT b1.party_id,        b1.party_type,        b1.person_name,        b1.person_first_name,        b1.person_middle_name,        b1.person_last_name,        b1.status,        b1.phone_area_code,        b1.phone_number,        b1.address1,        b1.address2,        b1.address3,        b1.address4,        b1.postal_code,        b1.city,        b1.state,        b1.country,        b1.email_address,        b1.date_of_birth,        b1.place_of_birth,        b1.date_of_death,        b1.gender,        b1.declared_ethnicity,        b1.marital_status,        b1.person_title,        b1.personal_income,        b1.do_not_mail_flag,        b1.created_by,        b1.creation_date,        b1.last_updated_by,        b1.last_update_date1 last_update_date,        b1.last_update_date2 last_update_date,        b1.last_update_date3 last_update_date,        b1.party_number,        b1.ACCNT_FLG FROM (SELECT              per.party_id,              pty.party_type,              per.person_name,              per.person_first_name,              per.person_middle_name,              per.person_last_name,              pty.status,              cnp.phone_area_code,              cnp.phone_number,              pty.address1,              pty.address2,              pty.address3,              pty.address4,              pty.postal_code,              pty.city,              pty.state,              pty.country,              pty.email_address,              per.date_of_birth,              per.place_of_birth,              per.date_of_death,              per.gender,              per.declared_ethnicity,              per.marital_status,              per.person_title,              per.personal_income,              pty.do_not_mail_flag,              per.created_by,              per.creation_date,              per.last_updated_by,              per.last_update_date last_update_date1,              pty.last_update_date last_update_date2,              cnp.last_update_date last_update_date3,              pty.party_number,              (CASE WHEN acct.PARTY_ID IS NOT NULL THEN 'Y' END) ACCNT_FLG,              MAX (per.person_profile_id) OVER (PARTITION BY per.party_id) max_person_profile_id,              per.person_profile_id       FROM hz_person_profiles per,            hz_parties pty,            hz_contact_points cnp,            (SELECT a1.party_id,                    COUNT (1) cnt             FROM (SELECT per.party_id                   FROM hz_person_profiles per                                      UNION ALL                   SELECT pty.party_id                   FROM hz_parties pty                                      UNION ALL                   SELECT  --/*+ use_hash(pty cnp) index_ffs(pty, hz_parties_u1)*/                         pty.party_id                   FROM hz_parties pty,                        hz_contact_points cnp                   WHERE pty.party_id = cnp.owner_table_id                         ) a1             GROUP BY party_id) TEMP,            hz_cust_accounts acct       WHERE     per.party_id = TEMP.party_id             AND per.party_id = pty.party_id             AND pty.party_id = cnp.owner_table_id(+)             AND cnp.owner_table_name(+) = 'HZ_PARTIES'             AND cnp.contact_point_type(+) = 'PHONE'             AND cnp.primary_flag(+) = 'Y'             AND acct.PARTY_ID(+) = pty.PARTY_ID) b1 WHERE b1.person_profile_id = b1.max_person_profile_id HAVING COUNT (1) >= 0 GROUP BY b1.party_id,          b1.party_type,          b1.person_name,          b1.person_first_name,          b1.person_middle_name,          b1.person_last_name,          b1.status,          b1.phone_area_code,          b1.phone_number,          b1.address1,          b1.address2,          b1.address3,          b1.address4,          b1.postal_code,          b1.city,          b1.state,          b1.country,          b1.email_address,          b1.date_of_birth,          b1.place_of_birth,          b1.date_of_death,          b1.gender,          b1.declared_ethnicity,          b1.marital_status,          b1.person_title,          b1.personal_income,          b1.do_not_mail_flag,          b1.created_by,          b1.creation_date,          b1.last_updated_by,          b1.last_update_date1,          b1.last_update_date2,          b1.last_update_date3,          b1.party_number,          b1.ACCNT_FLG]
                  READER_1_1_1> RR_4049 SQL Query issued to database : (Mon Dec 28 19:10:26 2009)
                  WRITER_1_*_1> WRT_8005 Writer run started.
                  WRITER_1_*_1> WRT_8158

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

                  Load Start Time: Mon Dec 28 19:10:26 2009

                  Target tables:

                  W_PARTY_PER_DS


                  READER_1_1_1> RR_4050 First row returned from database to reader : (Mon Dec 28 19:10:29 2009)
                  LKPDP_1> DBG_21312 Lookup Transformation [Lkp_W_ORA_PARTY_CONTACT_PS]: Lookup override sql to create cache: SELECT W_ORA_PARTY_CONTACT_PS.DEPARTMENT AS DEPARTMENT, W_ORA_PARTY_CONTACT_PS.ORG_CONTACT_ID AS ORG_CONTACT_ID, W_ORA_PARTY_CONTACT_PS.CONTACT_NUMBER AS CONTACT_NUMBER, W_ORA_PARTY_CONTACT_PS.JOB_TITLE AS JOB_TITLE, W_ORA_PARTY_CONTACT_PS.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, W_ORA_PARTY_CONTACT_PS.CONTACT_PARTY_ID AS CONTACT_PARTY_ID FROM W_ORA_PARTY_CONTACT_PS WHERE CUST_ACCOUNT_ROLE_ID=0 ORDER BY DATASOURCE_NUM_ID,CONTACT_PARTY_ID,DEPARTMENT,ORG_CONTACT_ID,CONTACT_NUMBER,JOB_TITLE

                  LKPDP_1> TE_7212 Increasing [Index Cache] size for transformation [Lkp_W_ORA_PARTY_CONTACT_PS] 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 [BIDB], user [AABAW]
                  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 : (Mon Dec 28 19:10:29 2009)
                  LKPDP_1:READER_1_1> RR_4050 First row returned from database to reader : (Mon Dec 28 19:10:30 2009)
                  LKPDP_1:TRANSF_1_1> DBG_21079 Creating Lookup Cache : (Mon Dec 28 19:10:30 2009)
                  LKPDP_1:READER_1_1> BLKR_16008 Reader run completed.
                  LKPDP_1:TRANSF_1_1> DBG_21682 Lookup table row count : 3247
                  LKPDP_1:TRANSF_1_1> DBG_21297 Lookup cache row count : 3238

                  LKPDP_1:TRANSF_1_1> DBG_21294 Lookup cache creation completed : (Mon Dec 28 19:10:30 2009)
                  LKPDP_1:TRANSF_1_1> CMN_1671 Created new cache files PMLKUP16713_5_0_1371W32.[dat/idx] in directory E:\Informatica\PowerCenter861\server\infa_shared\Cache for Lookup [Lkp_W_ORA_PARTY_CONTACT_PS].
                  LKPDP_1:TRANSF_1_1> DBG_21641 Lkp_W_ORA_PARTY_CONTACT_PS: Index cache size = [1392640], Data cache size = [2097152]
                  WRITER_1_*_1> WRT_8167 Start loading table [W_PARTY_PER_DS] at: Mon Dec 28 19:10:29 2009
                  WRITER_1_*_1> CMN_1761 Timestamp Event: [Mon Dec 28 19:10:30 2009]
                  WRITER_1_*_1> WRT_8229 Database errors occurred:

                  Database driver error...
                  Function Name : Execute Multiple
                  SQL Stmt : INSERT INTO W_PARTY_PER_DS(PARTY_TYPE,FST_NAME,FULL_NAME,MID_NAME,LAST_NAME,DEPARTMENT_NAME,CONTACT_ID,CONTACT_TYPE,FAX_PH_NUM,PAGER_NUM,MOBILE_NUM,WORK_PHONE,SEX_MF_CD,ETHNICITY_CD,MARITAL_STAT_CD,BIRTH_DT,BIRTH_PLACE,DEATH_DT,ST_ADDRESS,CITY,STATE,ZIPCODE,COUNTRY,EMAIL_ADDR,JOB_TITLE,ANNL_INCOME,CON_ACTIVE_FLG1,SUPPRESS_EMAIL_FLG,PROF_TITLE,STATUS_CD,ST_ADDRESS2,ST_ADDRESS3,ST_ADDRESS4,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,SRC_EFF_FROM_DT,SRC_EFF_TO_DT,DELETE_FLG,DATASOURCE_NUM_ID,INTEGRATION_ID,TENANT_ID,X_CUSTOM,CUSTOMER_NUM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
                  WRITER_1_*_1> CMN_1761 Timestamp Event: [Mon Dec 28 19:10:30 2009]
                  WRITER_1_*_1> WRT_8425 ERROR: Writer execution failed.
                  WRITER_1_*_1> WRT_8333 Rolling back all the targets due to fatal session error.
                  WRITER_1_*_1> CMN_1761 Timestamp Event: [Mon Dec 28 19:10:30 2009]
                  WRITER_1_*_1> CMN_1022 Database driver error...
                  CMN_1022 []

                  WRITER_1_*_1> CMN_1761 Timestamp Event: [Mon Dec 28 19:10:30 2009]
                  WRITER_1_*_1> WRT_8183 Rollback failed for the target [W_PARTY_PER_DS]
                  WRITER_1_*_1> CMN_1761 Timestamp Event: [Mon Dec 28 19:10:30 2009]
                  WRITER_1_*_1> WRT_8081 Writer run terminated. [Error in loading data to target table [W_PARTY_PER_DS]]
                  WRITER_1_*_1> WRT_8168 End loading table [W_PARTY_PER_DS] at: Mon Dec 28 19:10:30 2009
                  WRITER_1_*_1> WRT_8035 Load complete time: Mon Dec 28 19:10:30 2009

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

                  WRT_8036 Target: W_PARTY_PER_DS (Instance Name: [W_PARTY_PER_DS])
                  WRT_8038 Inserted rows - Requested: 1568 Applied: 1552 Rejected: 0 Affected: 1552


                  WRITER_1__1> WRT_8043 ****END LOAD SESSION*****
                  TRANSF_1_1_1> CMN_1761 Timestamp Event: [Mon Dec 28 19:10:30 2009]
                  TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [W_PARTY_PER_DS], and the session is terminating.
                  TRANSF_1_1_1> CMN_1761 Timestamp Event: [Mon Dec 28 19:10:30 2009]
                  TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_SA_ORA_PartyPersonDimension.EXP_PARTY_PERSON], and the session is terminating.
                  TRANSF_1_1_1> CMN_1761 Timestamp Event: [Mon Dec 28 19:10:30 2009]
                  TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_SA_ORA_PartyPersonDimension.EXP_PARTY_PERSON], and the session is terminating.
                  TRANSF_1_1_1> CMN_1761 Timestamp Event: [Mon Dec 28 19:10:30 2009]
                  TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_PartyPersonDimension.EXP_PER_PARTY], and the session is terminating.
                  TRANSF_1_1_1> CMN_1761 Timestamp Event: [Mon Dec 28 19:10:30 2009]
                  TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_PartyPersonDimension.EXP_PER_PARTY], and the session is terminating.
                  TRANSF_1_1_1> CMN_1761 Timestamp Event: [Mon Dec 28 19:10:30 2009]
                  TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_PartyPersonDimension.SQ_HZ_PERSON_PARTY], and the session is terminating.
                  TRANSF_1_1_1> CMN_1761 Timestamp Event: [Mon Dec 28 19:10:30 2009]
                  TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_PartyPersonDimension.SQ_HZ_PERSON_PARTY], and the session is terminating.
                  TRANSF_1_1_1> CMN_1761 Timestamp Event: [Mon Dec 28 19:10:30 2009]
                  TRANSF_1_1_1> TM_6085 A fatal error occurred at transformation [mplt_BC_ORA_PartyPersonDimension.SQ_HZ_PERSON_PARTY], 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_PartyPersonDimension.SQ_HZ_PERSON_PARTY] has completed.
                       Total Run Time = [3.765415] secs
                       Total Idle Time = [0.781122] secs
                       Busy Percentage = [79.255350]
                  Thread [TRANSF_1_1_1] created for [the transformation stage] of partition point [mplt_BC_ORA_PartyPersonDimension.SQ_HZ_PERSON_PARTY] has completed.
                       Total Run Time = [1.001440] secs
                       Total Idle Time = [0.690994] secs
                       Busy Percentage = [30.999937]
                       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_PARTY_PER_DS] has completed. The total run time was insufficient for any meaningful statistics.

                  MAPPING> CMN_1793 The index cache size that would hold [3238] rows in the lookup table for [Lkp_W_ORA_PARTY_CONTACT_PS], in memory, is [696320] bytes
                  MAPPING> CMN_1792 The data cache size that would hold [3238] rows in the lookup table for [Lkp_W_ORA_PARTY_CONTACT_PS], in memory, is [1908736] bytes
                  MANAGER> PETL_24005 Starting post-session tasks. : (Mon Dec 28 19:10:30 2009)
                  MANAGER> PETL_24029 Post-session task completed successfully. : (Mon Dec 28 19:10:30 2009)
                  MAPPING> TE_7216 Deleting cache files [PMLKUP16713_5_0_1371W32] for transformation [Lkp_W_ORA_PARTY_CONTACT_PS].
                  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_HZ_PERSON_PARTY] (Instance Name: [mplt_BC_ORA_PartyPersonDimension.SQ_HZ_PERSON_PARTY])
                       Output Rows [1788], Affected Rows [1788], Applied Rows [1788], Rejected Rows [0]
                  DIRECTOR> TM_6253 Target Load Summary.
                  DIRECTOR> CMN_1740 Table: [W_PARTY_PER_DS] (Instance Name: [W_PARTY_PER_DS])
                       Output Rows [1552], Affected Rows [1552], Applied Rows [1552], Rejected Rows [0]
                  DIRECTOR> TM_6023
                  ===================================================

                  DIRECTOR> TM_6020 Session [SDE_ORA_PartyPersonDimension_Customer_Full] completed at [Mon Dec 28 19:10:31 2009].