0 Replies Latest reply on May 5, 2017 1:04 PM by amcmahon

    Date Conversion in Mapping

    New Member

      I am trying to complete a mapping with a flat file source to a Salesforce target . I am receiving the following error in my log: error evaluating output column [rC_Bios__Start_Date__c]. Error message is [Expression Error [TO_DATE]: invalid string for converting to Date ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')]. I just can't seem to resolve this.  Below is the full log

       

       

       

      05/05/2017 15:38:53 **** Importing Connection: Conn_000YLI0B000000000002 ...

      05/05/2017 15:38:53 **** Importing Source Definition: banner_activities_csv ...

      05/05/2017 15:38:53 **** Importing Source Definition: UniversityAdvancementActivities__c ...

      05/05/2017 15:38:53 **** Importing Target Definition: UAAlumniStudentAwards__c ...

      05/05/2017 15:38:53 **** Importing Target Definition: UABoardandCommittee__c ...

      05/05/2017 15:38:53 **** Importing Target Definition: UAClubsVolunteering__c ...

      05/05/2017 15:38:53 **** Importing Target Definition: Event_Banner__c ...

      05/05/2017 15:38:53 **** Importing Target Definition: UARatingAffiliations__c ...

      05/05/2017 15:38:53 **** Importing Target Definition: UAStudentActivities__c ...

      05/05/2017 15:38:53 **** Importing SessionConfig: default_session_config ...

          <Warning> :  The Error Log DB Connection value should have Relational: as the prefix.

          <Warning> :  Invalid value  for attribute Error Log DB Connection. Will use the default value

          Validating Source Definition  UniversityAdvancementActivities__c...

          Validating Source Definition  banner_activities_csv...

          Validating Target Definition  UAStudentActivities__c...

          Validating Target Definition  UARatingAffiliations__c...

          Validating Target Definition  Event_Banner__c...

          Validating Target Definition  UAClubsVolunteering__c...

          Validating Target Definition  UABoardandCommittee__c...

          Validating Target Definition  UAAlumniStudentAwards__c...

      05/05/2017 15:38:53 **** Importing Mapping: Mapping0 ...

          <Warning> :  transformation: BannerActivities - Invalid value  for attribute Output is repeatable. Will use the default value Never    [transformation< BannerActivities > ]

      Validating transformations of mapping Mapping0...

      Validating mapping variable(s).

          <Warning> :  Invalid table attribute: Exec SQL

      05/05/2017 15:38:53 **** Importing Workflow: wf_mtt_000YLI0Z00000000003O ...

          <Warning> :  invalid attribute Append if Exists for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Header Options for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  Invalid value 0 for attribute Treat insert as upsert. Will use the default value NO    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Output Type for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Append if Exists for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Header Options for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  Invalid value 0 for attribute Treat insert as upsert. Will use the default value NO    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Output Type for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Append if Exists for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Header Options for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  Invalid value 0 for attribute Treat insert as upsert. Will use the default value NO    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Output Type for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Append if Exists for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Header Options for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  Invalid value 0 for attribute Treat insert as upsert. Will use the default value NO    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Output Type for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Append if Exists for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Header Options for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  Invalid value 0 for attribute Treat insert as upsert. Will use the default value NO    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Output Type for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Append if Exists for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Header Options for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  Invalid value 0 for attribute Treat insert as upsert. Will use the default value NO    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  invalid attribute Output Type for element ATTRIBUTE    [Session< s_mtt_000YLI0Z00000000003O >  --> Salesforce Writer< Salesforce Writer > ]

          <Warning> :  Invalid value Optimize throughout for attribute Concurrent read partitioning. Will use the default value Optimize throughput    [Session< s_mtt_000YLI0Z00000000003O >  --> File Reader< File Reader > ]

          <Warning> :  The value entered is not a valid integer.

          <Warning> :  Invalid value NO for attribute Fail task after wait time. Will use the default value

      [Summary for Application Source Qualifier Salesforce]

           Is a new repartition point.

           Partition type changed from None to Pass Through.

      Successfully extracted session instance [s_mtt_000YLI0Z00000000003O].  Starting repository sequence id is [328336086]

      ======================================================================

      DIRECTOR> VAR_27085 [2017-05-05 15:38:54.132] Parameter file [C:\Program Files\Informatica Cloud Secure Agent\apps\Data_Integration_Server\data\parameters\s_mtt_000YLI0Z00000000003O.param] is opened for [session [wf_mtt_000YLI0Z00000000003O.s_mtt_000YLI0Z00000000003O]].

      DIRECTOR> VAR_27062 [2017-05-05 15:38:54.132] Warning! Cannot find section for worklet [wf_mtt_000YLI0Z00000000003O] and folder [] in parameter file [C:\Program Files\Informatica Cloud Secure Agent\apps\Data_Integration_Server\data\parameters\s_mtt_000YLI0Z00000000003O.param].

      DIRECTOR> VAR_27028 [2017-05-05 15:38:54.132] Use override value [s_mtt_000YLI0Z00000000003O_5_error.csv] for user-defined workflow/worklet variable:[$ErrorFileName].

      DIRECTOR> VAR_27028 [2017-05-05 15:38:54.132] Use override value [2017-05-05] for user-defined workflow/worklet variable:[$LastRunDate].

      DIRECTOR> VAR_27028 [2017-05-05 15:38:54.132] Use override value [2017-05-05 19:32:51] for user-defined workflow/worklet variable:[$LastRunTime].

      DIRECTOR> VAR_27028 [2017-05-05 15:38:54.132] Use override value [s_mtt_000YLI0Z00000000003O_5_5_2017_19_38_success.csv] for user-defined workflow/worklet variable:[$SuccessFileName].

      DIRECTOR> TM_6014 [2017-05-05 15:38:54.132] Initializing session [s_mtt_000YLI0Z00000000003O] at [Fri May 05 15:38:54 2017].

      DIRECTOR> TM_6683 [2017-05-05 15:38:54.132] Repository Name: [XMLRepository]

      DIRECTOR> TM_6684 [2017-05-05 15:38:54.132] Server Name: [rDTM]

      DIRECTOR> TM_6686 [2017-05-05 15:38:54.132] Folder: []

      DIRECTOR> TM_6685 [2017-05-05 15:38:54.132] Workflow: [wf_mtt_000YLI0Z00000000003O] Run Instance Name: [] Run Id: [0]

      DIRECTOR> TM_6101 [2017-05-05 15:38:54.132] Mapping name: Mapping0.

      DIRECTOR> TM_6964 [2017-05-05 15:38:54.132] Date format for the Session is [MM/DD/YYYY HH24:MI:SS.US]

      DIRECTOR> TM_6703 [2017-05-05 15:38:54.132] Session [s_mtt_000YLI0Z00000000003O] is run by 64-bit Integration Service  [], version [9.1.0 HotFix1], build [0627].

      MANAGER> PETL_24058 [2017-05-05 15:38:54.132] Running Partition Group [1].

      MANAGER> PETL_24000 [2017-05-05 15:38:54.132] Parallel Pipeline Engine initializing.

      MANAGER> PETL_24001 [2017-05-05 15:38:54.132] Parallel Pipeline Engine running.

      MANAGER> PETL_24003 [2017-05-05 15:38:54.132] Initializing session run.

      MAPPING> CMN_1569 [2017-05-05 15:38:54.148] Server Mode: [UNICODE]

      MAPPING> CMN_1570 [2017-05-05 15:38:54.148] Server Code page: [MS Windows Latin 1 (ANSI), superset of Latin1]

      MAPPING> TM_6151 [2017-05-05 15:38:54.148] The session sort order is [Binary].

      MAPPING> TM_6185 [2017-05-05 15:38:54.148] Warning. Code page validation is disabled in this session.

      MAPPING> TM_6155 [2017-05-05 15:38:54.148] Using HIGH precision processing.

      MAPPING> TM_6180 [2017-05-05 15:38:54.148] Deadlock retry logic will not be implemented.

      MAPPING> TM_6187 [2017-05-05 15:38:54.148] Session target-based commit interval is [10000].

      MAPPING> SDKS_38029 [2017-05-05 15:38:54.148] Loaded plug-in 310600: [PowerExchange for Salesforce.com Reader Plugin 9.1.0].

      MAPPING> SDKS_38024 [2017-05-05 15:38:54.148] Plug-in 310600 initialization complete.

      MAPPING> SDKS_38016 [2017-05-05 15:38:54.148] Reader SDK plug-in intialization complete.

      MAPPING> SDKS_38029 [2017-05-05 15:38:54.148] Loaded plug-in 310600: [PowerExchange for Salesforce.com Writer Plugin 9.1.0].

      MAPPING> SDKS_38024 [2017-05-05 15:38:54.148] Plug-in 310600 initialization complete.

      MAPPING> SDKS_38017 [2017-05-05 15:38:54.148] Writer SDK plug-in intialization complete.

      MAPPING> SDKS_38509 [2017-05-05 15:38:54.148] SDK target and group initialization complete.

      MAPPING> TM_6307 [2017-05-05 15:38:54.148] DTM error log disabled.

      MAPPING> TE_7022 [2017-05-05 15:38:54.148] TShmWriter: Initialized

      MAPPING> DBG_21694 [2017-05-05 15:38:54.148] NewJoiner Partition [0]: Index cache size = [71530973], Data cache size = [143061946]

      MAPPING> TT_11098 [2017-05-05 15:38:54.148] The Joiner transformation [NewJoiner] is configured with the join algorithm: Nested-Loop.

      MAPPING> TM_6007 [2017-05-05 15:38:54.195] DTM initialized successfully for session [s_mtt_000YLI0Z00000000003O]

      DIRECTOR> PETL_24033 [2017-05-05 15:38:54.195] All DTM Connection Info: [<NONE>].

      MANAGER> PETL_24004 [2017-05-05 15:38:54.195] Starting pre-session tasks. : (Fri May 05 15:38:54 2017)

      MANAGER> PETL_24027 [2017-05-05 15:38:54.273] Pre-session task completed successfully. : (Fri May 05 15:38:54 2017)

      DIRECTOR> PETL_24006 [2017-05-05 15:38:54.273] Starting data movement.

      MAPPING> TM_6660 [2017-05-05 15:38:54.273] Total Buffer Pool size is 81123712 bytes and Block size is 1124496 bytes.

      READER_1_1_1> DBG_21437 [2017-05-05 15:38:54.273] Reader: Source is a file-based source.

      READER_1_1_1> FR_3118 [2017-05-05 15:38:54.273] source [BannerActivities] code page: [UTF-8 encoding of Unicode]

      READER_1_1_1> FR_3071 [2017-05-05 15:38:54.273] Maximum Line sequential buffer length is 2697.

      READER_1_1_1> BLKR_16003 [2017-05-05 15:38:54.273] Initialization completed successfully.

      READER_1_2_1> SFDC_31104 [2017-05-05 15:38:54.273] [INFO] SOQL is [Select Id, Name, Contact__c, Contact__r.Banner_PIDM_ID__c From UniversityAdvancementActivities__c].

      READER_1_2_1> SFDC_31131 [2017-05-05 15:38:54.273] [INFO] The Salesforce connection timeout is set to: [300].

      READER_1_2_1> SFDC_31132 [2017-05-05 15:38:54.273] [INFO] The Salesforce connection is using [TLSv1.2] for encryption.

      READER_1_2_1> SFDC_31122 [2017-05-05 15:38:55.336] [INFO] Account [apionly@wpi.edu] logged on salesforce.com at [https://login.salesforce.com/services/Soap/u/31.0].

      WRITER_1_*_1> SFDC_31230 [2017-05-05 15:38:55.336] [INFO] The UseExternalId attribute is set. The Integration Service will use external Id [AwardsExternalID__c] for upsert operations.

      WRITER_1_*_1> SFDC_31212 [2017-05-05 15:38:55.336] [INFO] Target [UAAlumniStudentAwards__c] enables treat update as upsert. external Id: [AwardsExternalID__c].

      WRITER_1_*_1> SFDC_31210 [2017-05-05 15:38:55.336] [INFO] Target [UAAlumniStudentAwards__c] will process Salesforce.com object type [UAAlumniStudentAwards__c].

      WRITER_1_*_1> SFDC_31217 [2017-05-05 15:38:55.336] [INFO] The Salesforce connection timeout is set to: [300].

      WRITER_1_*_1> SFDC_31218 [2017-05-05 15:38:55.336] [INFO] The Salesforce connection is using [TLSv1.2] for encryption.

      WRITER_1_*_1> SFDC_31216 [2017-05-05 15:38:55.336] [INFO] Account [apionly@wpi.edu] logged on salesforce.com at [https://login.salesforce.com/services/Soap/u/31.0].

      WRITER_1_*_1> SFDC_31230 [2017-05-05 15:38:55.336] [INFO] The UseExternalId attribute is set. The Integration Service will use external Id [ExternalID__c] for upsert operations.

      WRITER_1_*_1> SFDC_31212 [2017-05-05 15:38:55.351] [INFO] Target [UABoardandCommittee__c] enables treat update as upsert. external Id: [ExternalID__c].

      WRITER_1_*_1> SFDC_31210 [2017-05-05 15:38:55.351] [INFO] Target [UABoardandCommittee__c] will process Salesforce.com object type [UABoardandCommittee__c].

      WRITER_1_*_1> SFDC_31217 [2017-05-05 15:38:55.351] [INFO] The Salesforce connection timeout is set to: [300].

      WRITER_1_*_1> SFDC_31218 [2017-05-05 15:38:55.351] [INFO] The Salesforce connection is using [TLSv1.2] for encryption.

      WRITER_1_*_1> SFDC_31216 [2017-05-05 15:38:55.351] [INFO] Account [apionly@wpi.edu] logged on salesforce.com at [https://login.salesforce.com/services/Soap/u/31.0].

      WRITER_1_*_1> SFDC_31230 [2017-05-05 15:38:55.351] [INFO] The UseExternalId attribute is set. The Integration Service will use external Id [ExternalID__c] for upsert operations.

      WRITER_1_*_1> SFDC_31212 [2017-05-05 15:38:55.351] [INFO] Target [UAClubsVolunteering__c] enables treat update as upsert. external Id: [ExternalID__c].

      WRITER_1_*_1> SFDC_31210 [2017-05-05 15:38:55.351] [INFO] Target [UAClubsVolunteering__c] will process Salesforce.com object type [UAClubsVolunteering__c].

      WRITER_1_*_1> SFDC_31217 [2017-05-05 15:38:55.351] [INFO] The Salesforce connection timeout is set to: [300].

      WRITER_1_*_1> SFDC_31218 [2017-05-05 15:38:55.351] [INFO] The Salesforce connection is using [TLSv1.2] for encryption.

      WRITER_1_*_1> SFDC_31216 [2017-05-05 15:38:55.367] [INFO] Account [apionly@wpi.edu] logged on salesforce.com at [https://login.salesforce.com/services/Soap/u/31.0].

      WRITER_1_*_1> SFDC_31230 [2017-05-05 15:38:55.367] [INFO] The UseExternalId attribute is set. The Integration Service will use external Id [ExternalID__c] for upsert operations.

      WRITER_1_*_1> SFDC_31212 [2017-05-05 15:38:55.367] [INFO] Target [Event_Banner__c] enables treat update as upsert. external Id: [ExternalID__c].

      WRITER_1_*_1> SFDC_31210 [2017-05-05 15:38:55.367] [INFO] Target [Event_Banner__c] will process Salesforce.com object type [Event_Banner__c].

      WRITER_1_*_1> SFDC_31217 [2017-05-05 15:38:55.367] [INFO] The Salesforce connection timeout is set to: [300].

      WRITER_1_*_1> SFDC_31218 [2017-05-05 15:38:55.367] [INFO] The Salesforce connection is using [TLSv1.2] for encryption.

      WRITER_1_*_1> SFDC_31216 [2017-05-05 15:38:55.367] [INFO] Account [apionly@wpi.edu] logged on salesforce.com at [https://login.salesforce.com/services/Soap/u/31.0].

      WRITER_1_*_1> SFDC_31230 [2017-05-05 15:38:55.367] [INFO] The UseExternalId attribute is set. The Integration Service will use external Id [ExternalID__c] for upsert operations.

      WRITER_1_*_1> SFDC_31212 [2017-05-05 15:38:55.367] [INFO] Target [UARatingAffiliations__c] enables treat update as upsert. external Id: [ExternalID__c].

      WRITER_1_*_1> SFDC_31210 [2017-05-05 15:38:55.367] [INFO] Target [UARatingAffiliations__c] will process Salesforce.com object type [UARatingAffiliations__c].

      WRITER_1_*_1> SFDC_31217 [2017-05-05 15:38:55.367] [INFO] The Salesforce connection timeout is set to: [300].

      WRITER_1_*_1> SFDC_31218 [2017-05-05 15:38:55.367] [INFO] The Salesforce connection is using [TLSv1.2] for encryption.

      WRITER_1_*_1> SFDC_31216 [2017-05-05 15:38:55.382] [INFO] Account [apionly@wpi.edu] logged on salesforce.com at [https://login.salesforce.com/services/Soap/u/31.0].

      WRITER_1_*_1> SFDC_31230 [2017-05-05 15:38:55.382] [INFO] The UseExternalId attribute is set. The Integration Service will use external Id [ExternalID__c] for upsert operations.

      WRITER_1_*_1> SFDC_31212 [2017-05-05 15:38:55.382] [INFO] Target [UAStudentActivities__c] enables treat update as upsert. external Id: [ExternalID__c].

      WRITER_1_*_1> SFDC_31210 [2017-05-05 15:38:55.382] [INFO] Target [UAStudentActivities__c] will process Salesforce.com object type [UAStudentActivities__c].

      WRITER_1_*_1> SFDC_31217 [2017-05-05 15:38:55.382] [INFO] The Salesforce connection timeout is set to: [300].

      WRITER_1_*_1> SFDC_31218 [2017-05-05 15:38:55.382] [INFO] The Salesforce connection is using [TLSv1.2] for encryption.

      WRITER_1_*_1> SFDC_31216 [2017-05-05 15:38:55.382] [INFO] Account [apionly@wpi.edu] logged on salesforce.com at [https://login.salesforce.com/services/Soap/u/31.0].

      WRITER_1_*_1> WRT_8270 [2017-05-05 15:38:55.382] Target connection group #1 consists of target(s) [UAAlumniStudentAwards__c: Partition 1]

      WRITER_1_*_1> WRT_8270 [2017-05-05 15:38:55.382] Target connection group #2 consists of target(s) [UABoardandCommittee__c: Partition 1]

      WRITER_1_*_1> WRT_8270 [2017-05-05 15:38:55.382] Target connection group #3 consists of target(s) [UAClubsVolunteering__c: Partition 1]

      WRITER_1_*_1> WRT_8270 [2017-05-05 15:38:55.382] Target connection group #4 consists of target(s) [Event_Banner__c: Partition 1]

      WRITER_1_*_1> WRT_8270 [2017-05-05 15:38:55.382] Target connection group #5 consists of target(s) [UARatingAffiliations__c: Partition 1]

      WRITER_1_*_1> WRT_8270 [2017-05-05 15:38:55.382] Target connection group #6 consists of target(s) [UAStudentActivities__c: Partition 1]

      WRITER_1_*_1> WRT_8003 [2017-05-05 15:38:55.382] Writer initialization complete.

      READER_1_1_1> BLKR_16007 [2017-05-05 15:38:55.382] Reader run started.

      READER_1_1_1> FR_3076 [2017-05-05 15:38:55.382] Skipped over [1] lines.

      READER_1_1_1> DBG_21430 [2017-05-05 15:38:55.382] Reading data from input source file [C:\daily_salesforce_uploads\banner-activities.csv] : (Fri May 05 15:38:55 2017)

      READER_1_1_1> BLKR_16019 [2017-05-05 15:38:55.382] Read [34] rows, read [0] error rows for source table [banner_activities_csv] instance name [banner_activities_csv]

      READER_1_1_1> BLKR_16008 [2017-05-05 15:38:55.382] Reader run completed.

      WRITER_1_*_1> WRT_8005 [2017-05-05 15:38:55.382] Writer run started.

      WRITER_1_*_1> WRT_8158 [2017-05-05 15:38:55.382]

       

       

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

       

       

      Load Start Time: Fri May 05 15:38:55 2017

       

       

      Target tables:

       

       

           UAAlumniStudentAwards__c: Partition 1

           UABoardandCommittee__c: Partition 1

           UAClubsVolunteering__c: Partition 1

           Event_Banner__c: Partition 1

           UARatingAffiliations__c: Partition 1

           UAStudentActivities__c: Partition 1

       

       

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.382] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.382] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.382] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.382] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.382] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.382] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.382] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.382] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.382]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=1 Targ Rowid=1

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "798773EK"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "798773"

        Contact_Name (Contact_Name:UniChar.255:): "Alexandra M. Burr"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Fraternities/Sororities"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "(NULL)"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2014"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "PHI SIGMA SIGMA"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.382] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2015',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.382] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.382] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2015',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.382] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.382] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.382] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.382] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.382] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=2 Targ Rowid=2

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "798773KK"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "798773"

        Contact_Name (Contact_Name:UniChar.255:): "Alexandra M. Burr"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "School Involvement"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "(NULL)"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2015"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "STUDENT GOVERNMENT"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=3 Targ Rowid=3

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "798773KNC"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "798773"

        Contact_Name (Contact_Name:UniChar.255:): "Alexandra M. Burr"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "School Involvement"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Chairman"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2014"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "STUDENT ALUMNI SOCIETY"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=4 Targ Rowid=4

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "846702EUD"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "846702"

        Contact_Name (Contact_Name:UniChar.255:): "Anna L. Schozer"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Fraternities/Sororities"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Director"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2014"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "ALPHA PHI"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=5 Targ Rowid=5

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "846702EUV"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "846702"

        Contact_Name (Contact_Name:UniChar.255:): "Anna L. Schozer"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Fraternities/Sororities"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Vice President"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2014"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "ALPHA PHI"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=6 Targ Rowid=6

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "846702EUX"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "846702"

        Contact_Name (Contact_Name:UniChar.255:): "Anna L. Schozer"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Fraternities/Sororities"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Member"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2014"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "ALPHA PHI"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=7 Targ Rowid=7

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "846702FTAT"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "846702"

        Contact_Name (Contact_Name:UniChar.255:): "Anna L. Schozer"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Honor Societies"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Attendee"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2016"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "ORDER OF OMEGA"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=8 Targ Rowid=8

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "846702FTS"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "846702"

        Contact_Name (Contact_Name:UniChar.255:): "Anna L. Schozer"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Honor Societies"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Secretary"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2016"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "ORDER OF OMEGA"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=9 Targ Rowid=9

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "846702FTX"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "846702"

        Contact_Name (Contact_Name:UniChar.255:): "Anna L. Schozer"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Honor Societies"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Member"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2016"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "ORDER OF OMEGA"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=10 Targ Rowid=10

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "846702MVAT"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "846702"

        Contact_Name (Contact_Name:UniChar.255:): "Anna L. Schozer"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Undergraduate Prof. Societies"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Attendee"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2014"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "MU SIGMA DELTA (PRE-HLTH SOC)"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=11 Targ Rowid=11

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "846702MVX"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "846702"

        Contact_Name (Contact_Name:UniChar.255:): "Anna L. Schozer"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Undergraduate Prof. Societies"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Member"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2014"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "MU SIGMA DELTA (PRE-HLTH SOC)"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=12 Targ Rowid=12

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "846702VP"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "846702"

        Contact_Name (Contact_Name:UniChar.255:): "Anna L. Schozer"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Special Programs"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "(NULL)"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2016"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "PROJ CENTER-WORC COMMUNITY"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=13 Targ Rowid=13

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "847404ELV"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "847404"

        Contact_Name (Contact_Name:UniChar.255:): "Zachary M. Ericson"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Fraternities/Sororities"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Vice President"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2014"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "SIGMA ALPHA EPSILON"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=14 Targ Rowid=14

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "847404KA"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "847404"

        Contact_Name (Contact_Name:UniChar.255:): "Zachary M. Ericson"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "School Involvement"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "(NULL)"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2016"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "CAMPUS HEARING BOARD"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=15 Targ Rowid=15

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "847404KD"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "847404"

        Contact_Name (Contact_Name:UniChar.255:): "Zachary M. Ericson"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "School Involvement"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "(NULL)"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2016"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "FRESHMAN ORIENTATION COMM"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2017',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2017',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=16 Targ Rowid=16

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "847404KT"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "847404"

        Contact_Name (Contact_Name:UniChar.255:): "Zachary M. Ericson"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "School Involvement"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "(NULL)"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2017"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "CRIMSON AND GRAY"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2017',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2017',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=17 Targ Rowid=17

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "847404KW"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "847404"

        Contact_Name (Contact_Name:UniChar.255:): "Zachary M. Ericson"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "School Involvement"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "(NULL)"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2017"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "ADMISSIONS TOUR GUIDE"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=18 Targ Rowid=18

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "847404KYV"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "847404"

        Contact_Name (Contact_Name:UniChar.255:): "Zachary M. Ericson"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "School Involvement"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Vice President"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2016"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "INTERFRATERNITY COUNCIL (IFC)"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=19 Targ Rowid=19

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "847404N2"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "847404"

        Contact_Name (Contact_Name:UniChar.255:): "Zachary M. Ericson"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Club Sports"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "(NULL)"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2014"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "SKI TEAM"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=20 Targ Rowid=20

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "847404VE"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "847404"

        Contact_Name (Contact_Name:UniChar.255:): "Zachary M. Ericson"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Special Programs"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "(NULL)"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2016"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "PROJ CENTER-INDIA"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2015',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2015',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=21 Targ Rowid=21

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "857974ECV"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "857974"

        Contact_Name (Contact_Name:UniChar.255:): "Carolina E. Ramos"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Fraternities/Sororities"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Vice President"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2015"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "ALPHA GAMMA DELTA"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2015',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2015',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=22 Targ Rowid=22

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "857974ECX"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "857974"

        Contact_Name (Contact_Name:UniChar.255:): "Carolina E. Ramos"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Fraternities/Sororities"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Member"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2015"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "ALPHA GAMMA DELTA"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2017',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2017',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=23 Targ Rowid=23

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "857974FTX"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "857974"

        Contact_Name (Contact_Name:UniChar.255:): "Carolina E. Ramos"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Honor Societies"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Member"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2017"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "ORDER OF OMEGA"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=24 Targ Rowid=24

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "857974KKC"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "857974"

        Contact_Name (Contact_Name:UniChar.255:): "Carolina E. Ramos"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "School Involvement"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Chairman"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2014"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "STUDENT GOVERNMENT"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=25 Targ Rowid=25

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "857974KKX"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "857974"

        Contact_Name (Contact_Name:UniChar.255:): "Carolina E. Ramos"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "School Involvement"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Member"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2014"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "STUDENT GOVERNMENT"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2015',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2015',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=26 Targ Rowid=26

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "857974KNX"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "857974"

        Contact_Name (Contact_Name:UniChar.255:): "Carolina E. Ramos"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "School Involvement"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Member"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2015"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "STUDENT ALUMNI SOCIETY"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=27 Targ Rowid=27

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "857974SZX"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "857974"

        Contact_Name (Contact_Name:UniChar.255:): "Carolina E. Ramos"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Clubs"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Member"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2014"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "CAMPUS RADIO"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=28 Targ Rowid=28

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "857974VYX"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "857974"

        Contact_Name (Contact_Name:UniChar.255:): "Carolina E. Ramos"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Special Programs"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "Member"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2016"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "PROJ CENTER - MOROCCO"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=29 Targ Rowid=29

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "858837DMP"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "858837"

        Contact_Name (Contact_Name:UniChar.255:): "Roger Andrew A. Santos"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Clubs"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "President"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2014"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "NEWMAN"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2015',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2015',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=30 Targ Rowid=30

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "858837FD"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "858837"

        Contact_Name (Contact_Name:UniChar.255:): "Roger Andrew A. Santos"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Honor Societies"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "(NULL)"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2015"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "ETA KAPPA NU"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2015',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2015',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=31 Targ Rowid=31

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "858837FM"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "858837"

        Contact_Name (Contact_Name:UniChar.255:): "Roger Andrew A. Santos"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "Honor Societies"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "(NULL)"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2015"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "TAU BETA PI"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=32 Targ Rowid=32

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "858837KT"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "858837"

        Contact_Name (Contact_Name:UniChar.255:): "Roger Andrew A. Santos"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "School Involvement"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "(NULL)"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2016"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "CRIMSON AND GRAY"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2016',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=33 Targ Rowid=33

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "858837KW"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "858837"

        Contact_Name (Contact_Name:UniChar.255:): "Roger Andrew A. Santos"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "School Involvement"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "(NULL)"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2016"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "ADMISSIONS TOUR GUIDE"

      )

       

       

      TRANSF_1_1_1> TE_7007 [2017-05-05 15:38:55.398] Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')]

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11132 [2017-05-05 15:38:55.398] Transformation [NewExpression] had an error evaluating output column [rC_Bios__Start_Date__c]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date

      ... t:TO_DATE(u:'07/01/2014',u:'YYYY-MM-DD hh:mi:ss.US')].

       

       

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11019 [2017-05-05 15:38:55.398] There is an error in the port [rC_Bios__Start_Date__c]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      TRANSF_1_1_1> CMN_1761 [2017-05-05 15:38:55.398] Timestamp Event: [Fri May 05 15:38:55 2017]

      TRANSF_1_1_1> TT_11021 [2017-05-05 15:38:55.398] An error occurred moving data from the transformation NewExpression: to the transformation NewJoiner.

      TRANSF_1_1_1> DBG_21082 [2017-05-05 15:38:55.398] NewExpression (Input Group 0):  : Current Input data:

      TRANSF_1_1_1> CMN_1053 [2017-05-05 15:38:55.398]   Input row from BannerActivities: Rowdata: ( RowType=0(insert) Src Rowid=34 Targ Rowid=34

        rC_Bios__External_ID__c (rC_Bios__External_ID__c:UniChar.255:): "858837Q9P"

        RecordTypeId (RecordTypeId:UniChar.255:): "012G0000001NIrMIAW"

        rC_Bios__Contact__c (rC_Bios__Contact__c:UniChar.255:): "858837"

        Contact_Name (Contact_Name:UniChar.255:): "Roger Andrew A. Santos"

        rC_Bios__Active__c (rC_Bios__Active__c:UniChar.255:): "1"

        rC_Bios__Category__c (rC_Bios__Category__c:UniChar.255:): "Unknown/Other"

        rC_Bios__Subcategory__c (rC_Bios__Subcategory__c:UniChar.255:): "International Clubs"

        Leadership_Role__c (Leadership_Role__c:UniChar.255:): "President"

        Lead_Begin (Lead_Begin:UniChar.29:): "(NULL)"

        Lead_End (Lead_End:UniChar.29:): "(NULL)"

        Start (Start:UniChar.29:): "07/01/2014"

        End (End:UniChar.29:): "(NULL)"

        rC_Bios__Comments__c (rC_Bios__Comments__c:UniChar.255:): "(NULL)"

        rC_Bios__Type__c (rC_Bios__Type__c:UniChar.255:): "INTERNATIONAL STUDENT COUNCIL"

      )

       

       

      TRANSF_1_1_1> DBG_21077 [2017-05-05 15:38:55.398] Create joiner cache on master relation : (Fri May 05 15:38:55 2017)

      TRANSF_1_1_1> TE_7212 [2017-05-05 15:38:55.414] Increasing [Index Cache] size for transformation [NewJoiner] from [71530973] to [71562752].

      TRANSF_1_1_1> TE_7212 [2017-05-05 15:38:55.414] Increasing [Data Cache] size for transformation [NewJoiner] from [143061946] to [143064064].

      TRANSF_1_1_1> CMN_1690 [2017-05-05 15:38:55.461] Created new data file [C:\PROGRA~1\INFORM~1\apps\Data_Integration_Server\data\cache\PMJNR328336372_12_0.dat] and index file [C:\PROGRA~1\INFORM~1\apps\Data_Integration_Server\data\cache\PMJNR328336372_12_0.idx] for Joiner [NewJoiner].

      TRANSF_1_1_1> DBG_21214 [2017-05-05 15:38:55.461] Finished joiner cache on master relation : (Fri May 05 15:38:55 2017)

      TRANSF_1_1_1> DBG_21216 [2017-05-05 15:38:55.461] Finished transformations for Source Qualifier [BannerActivities]. Total errors [0]

      TRANSF_1_2_1> DBG_21273 [2017-05-05 15:38:57.211] Joiner transform : NewJoiner

       

       

      TRANSF_1_2_1> CMN_1103 [2017-05-05 15:38:57.211] WARNING : No row found from the master relation. Joiner will not produce any output row.

      TRANSF_1_2_1> DBG_21603 [2017-05-05 15:38:57.211] Open master relation cache for detail joiner : (Fri May 05 15:38:57 2017)

      TRANSF_1_2_1> DBG_21215 [2017-05-05 15:39:33.338] Finished processing detail relation : (Fri May 05 15:39:33 2017)

      TRANSF_1_2_1> CMN_1795 [2017-05-05 15:39:33.338] The index cache size that would hold [0] input rows from the master for [NewJoiner], in memory, is [0] bytes

      TRANSF_1_2_1> CMN_1794 [2017-05-05 15:39:33.338] The data cache size that would hold [0] input rows from the master for [NewJoiner], in memory, is [5632] bytes

      TRANSF_1_2_1> DBG_21216 [2017-05-05 15:39:33.338] Finished transformations for Source Qualifier [Salesforce]. Total errors [0]

      WRITER_1_*_1> WRT_8167 [2017-05-05 15:39:33.338] Start loading table [UAAlumniStudentAwards__c: Partition 1] at: Fri May 05 15:39:32 2017

      WRITER_1_*_1> WRT_8167 [2017-05-05 15:39:33.338] Start loading table [UABoardandCommittee__c: Partition 1] at: Fri May 05 15:39:32 2017

      WRITER_1_*_1> WRT_8167 [2017-05-05 15:39:33.338] Start loading table [UAClubsVolunteering__c: Partition 1] at: Fri May 05 15:39:32 2017

      WRITER_1_*_1> WRT_8167 [2017-05-05 15:39:33.338] Start loading table [Event_Banner__c: Partition 1] at: Fri May 05 15:39:32 2017

      WRITER_1_*_1> WRT_8167 [2017-05-05 15:39:33.338] Start loading table [UARatingAffiliations__c: Partition 1] at: Fri May 05 15:39:32 2017

      WRITER_1_*_1> WRT_8167 [2017-05-05 15:39:33.338] Start loading table [UAStudentActivities__c: Partition 1] at: Fri May 05 15:39:32 2017

      WRITER_1_*_1> WRT_8168 [2017-05-05 15:39:33.338] End loading table [UAAlumniStudentAwards__c: Partition 1] at: Fri May 05 15:39:32 2017

      WRITER_1_*_1> WRT_8168 [2017-05-05 15:39:33.338] End loading table [UABoardandCommittee__c: Partition 1] at: Fri May 05 15:39:32 2017

      WRITER_1_*_1> WRT_8168 [2017-05-05 15:39:33.338] End loading table [UAClubsVolunteering__c: Partition 1] at: Fri May 05 15:39:32 2017

      WRITER_1_*_1> WRT_8168 [2017-05-05 15:39:33.338] End loading table [Event_Banner__c: Partition 1] at: Fri May 05 15:39:32 2017

      WRITER_1_*_1> WRT_8168 [2017-05-05 15:39:33.338] End loading table [UARatingAffiliations__c: Partition 1] at: Fri May 05 15:39:32 2017

      WRITER_1_*_1> WRT_8168 [2017-05-05 15:39:33.338] End loading table [UAStudentActivities__c: Partition 1] at: Fri May 05 15:39:32 2017

      WRITER_1_*_1> WRT_8035 [2017-05-05 15:39:33.367] Load complete time: Fri May 05 15:39:32 2017

       

       

      LOAD SUMMARY

      ============

       

       

      WRT_8036 Target: UAAlumniStudentAwards__c: Partition 1 (Instance Name: [UAAlumniStudentAwards__c])

      WRT_8044 No data loaded for this target

       

       

       

       

      WRT_8036 Target: UABoardandCommittee__c: Partition 1 (Instance Name: [UABoardandCommittee__c])

      WRT_8044 No data loaded for this target

       

       

       

       

      WRT_8036 Target: UAClubsVolunteering__c: Partition 1 (Instance Name: [UAClubsVolunteering__c])

      WRT_8044 No data loaded for this target

       

       

       

       

      WRT_8036 Target: Event_Banner__c: Partition 1 (Instance Name: [Event_Banner__c])

      WRT_8044 No data loaded for this target

       

       

       

       

      WRT_8036 Target: UARatingAffiliations__c: Partition 1 (Instance Name: [UARatingAffiliations__c])

      WRT_8044 No data loaded for this target

       

       

       

       

      WRT_8036 Target: UAStudentActivities__c: Partition 1 (Instance Name: [UAStudentActivities__c])

      WRT_8044 No data loaded for this target

       

       

       

       

       

       

      WRITER_1_*_1> WRT_8043 [2017-05-05 15:39:33.367] *****END LOAD SESSION*****

      WRITER_1_*_1> WRT_8006 [2017-05-05 15:39:33.367] Writer run completed.

      MANAGER> PETL_24031 [2017-05-05 15:39:33.367]

      ***** RUN INFO FOR TGT LOAD ORDER GROUP [1], CONCURRENT SET [1] *****

      Thread [READER_1_1_1] created for [the read stage] of partition point [BannerActivities] 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 [BannerActivities] has completed. The total run time was insufficient for any meaningful statistics.

      Thread [READER_1_2_1] created for [the read stage] of partition point [Salesforce] has completed.

        Total Run Time = [37.955456] secs

        Total Idle Time = [0.000000] secs

        Busy Percentage = [100.000000]

      Thread [TRANSF_1_2_1] created for [the transformation stage] of partition point [Salesforce] has completed.

        Total Run Time = [36.127356] secs

        Total Idle Time = [36.127356] secs

        Busy Percentage = [0.000000]

        Transformation-specific statistics for this thread were not accurate enough to report.

      Thread [WRITER_1_*_1] created for [the write stage] of partition point [UAAlumniStudentAwards__c, UABoardandCommittee__c, UAClubsVolunteering__c, Event_Banner__c, UARatingAffiliations__c, UAStudentActivities__c] has completed. The total run time was insufficient for any meaningful statistics.

       

       

      MANAGER> PETL_24005 [2017-05-05 15:39:33.539] Starting post-session tasks. : (Fri May 05 15:39:33 2017)

      MANAGER> PETL_24029 [2017-05-05 15:39:33.617] Post-session task completed successfully. : (Fri May 05 15:39:33 2017)

      MAPPING> SDKS_38510 [2017-05-05 15:39:33.617] SDK target and group deinitialized with status [0].

      MAPPING> SDKS_38025 [2017-05-05 15:39:33.617] Plug-in 310600 deinitialized and unloaded with status [0].

      MAPPING> SDKS_38019 [2017-05-05 15:39:33.617] Writer SDK plug-ins deinitialized with status [0].

      MAPPING> SDKS_38025 [2017-05-05 15:39:33.617] Plug-in 310600 deinitialized and unloaded with status [0].

      MAPPING> SDKS_38018 [2017-05-05 15:39:33.617] Reader SDK plug-ins deinitialized with status [0].

      MAPPING> TM_6018 [2017-05-05 15:39:33.617] The session completed with [34] row transformation errors.

      MANAGER> TE_7216 [2017-05-05 15:39:33.679] Deleting cache files [C:\PROGRA~1\INFORM~1\apps\Data_Integration_Server\data\cache\PMJNR328336372_12_0.dat] for transformation [NewJoiner].

      MANAGER> TE_7216 [2017-05-05 15:39:33.679] Deleting cache files [C:\PROGRA~1\INFORM~1\apps\Data_Integration_Server\data\cache\PMJNR328336372_12_0.idx] for transformation [NewJoiner].

      MANAGER> PETL_24002 [2017-05-05 15:39:33.836] Parallel Pipeline Engine finished.

      DIRECTOR> PETL_24012 [2017-05-05 15:39:33.898] Session run completed successfully.

      DIRECTOR> TM_6022 [2017-05-05 15:39:33.898]

       

       

      SESSION LOAD SUMMARY

      ================================================

       

       

      DIRECTOR> TM_6252 [2017-05-05 15:39:33.898] Source Load Summary.

      DIRECTOR> CMN_1740 [2017-05-05 15:39:33.898] Table: [BannerActivities] (Instance Name: [BannerActivities])

        Output Rows [34], Affected Rows [34], Applied Rows [34], Rejected Rows [0]

      DIRECTOR> CMN_1740 [2017-05-05 15:39:33.898] Table: [Salesforce] (Instance Name: [Salesforce])

        Output Rows [133244], Affected Rows [133244], Applied Rows [133244], Rejected Rows [0]

      DIRECTOR> TM_6253 [2017-05-05 15:39:33.898] Target Load Summary.

      DIRECTOR> CMN_1740 [2017-05-05 15:39:33.898] Table: [UAAlumniStudentAwards__c] (Instance Name: [UAAlumniStudentAwards__c])

        Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]

      DIRECTOR> CMN_1740 [2017-05-05 15:39:33.898] Table: [UABoardandCommittee__c] (Instance Name: [UABoardandCommittee__c])

        Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]

      DIRECTOR> CMN_1740 [2017-05-05 15:39:33.898] Table: [UAClubsVolunteering__c] (Instance Name: [UAClubsVolunteering__c])

        Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]

      DIRECTOR> CMN_1740 [2017-05-05 15:39:33.898] Table: [Event_Banner__c] (Instance Name: [Event_Banner__c])

        Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]

      DIRECTOR> CMN_1740 [2017-05-05 15:39:33.898] Table: [UARatingAffiliations__c] (Instance Name: [UARatingAffiliations__c])

        Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]

      DIRECTOR> CMN_1740 [2017-05-05 15:39:33.898] Table: [UAStudentActivities__c] (Instance Name: [UAStudentActivities__c])

        Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]

      DIRECTOR> TM_6023 [2017-05-05 15:39:33.898]

      ===================================================

       

       

      DIRECTOR> TM_6020 [2017-05-05 15:39:33.898] Session [s_mtt_000YLI0Z00000000003O] completed at [Fri May 05 15:39:33 2017].

       

      Cheers,

       

      Anthony