Data Replication 2
Page 1 of 2 12 LastLast
Results 1 to 10 of 13
Like Tree1Likes

Thread: ORA-01406 when starting the Oracle CDC service

  1. #1
    minh is offline Junior Member
    Join Date
    Oct 2012
    Posts
    6
    Rep Power
    0

    ORA-01406 when starting the Oracle CDC service

    Hi,

    This morning our Oracle CDC service was in pause status (yellow) Détailed Status : LOGGER

    i have restarted the service but after few seconds it failed again...

    in the Collect diagnostics file i have found the error ORA-01406, i have checked in the oracle "alert" file and didn't find any error in it

    Could anyone help me ?? as i don't know what could be the cause and if it's on oracle side or CDC part

    Thanks !!
    Minh



    /* ************************************************** ********** */
    "10/11/2012 9:20:28 AM","INFO","bel-cdm-dsql","RUNNING","IDLE","ORACDC302I:The Oracle CDC instance for service ECBI_CDC and database ECBI_DV_CDC_BEL_PREP received a stop signal.","service","",""
    "10/11/2012 9:20:28 AM","INFO","bel-cdm-dsql","STOPPED","STOP","ORACDC301I:The Oracle CDC instance for service ECBI_CDC and database ECBI_DV_CDC_BEL_PREP stopped.","service","",""
    "10/11/2012 9:20:59 AM","INFO","bel-cdm-dsql","RUNNING","INIT","ORACDC300I:The Oracle CDC instance for service ECBI_CDC and database ECBI_DV_CDC_BEL_PREP started.","service","",""
    "10/11/2012 9:20:59 AM","INFO","bel-cdm-dsql","RUNNING","INIT","ORACDC305I:The value of the option 'source_env_report' was changed to 9.","infrastructure","",""
    "10/11/2012 9:20:59 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "10/11/2012 9:20:59 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "10/11/2012 9:21:10 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "10/11/2012 9:21:10 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "10/11/2012 9:21:10 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "10/11/2012 9:21:10 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "10/11/2012 9:21:10 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "10/11/2012 9:21:10 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "10/11/2012 9:21:10 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "10/11/2012 9:21:58 AM","INFO","bel-cdm-dsql","RUNNING","IDLE","ORACDC303I:The Oracle CDC instance for service ECBI_CDC and database ECBI_DV_CDC_BEL_PREP received a reconfigure signal.","service","",""
    "10/11/2012 9:21:58 AM","INFO","bel-cdm-dsql","RUNNING","IDLE","ORACDC305I:The value of the option 'source_env_report' was changed to 10.","infrastructure","",""
    "10/11/2012 9:21:58 AM","REPORT","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000R:Oracle Diagnostics","infrastructure","
    Character set information:
    NLS_CHARACTERSET: 31
    LS_NCHAR_CHARACTERSET: 2000
    Reader Information:
    Thread: 1
    Last Transaction SCN: 9915841651996
    Last SCN: 9915841651996
    Greatest Sequence: 188720
    Start SCN: 9915841651996
    Transaction Sequencer: 1
    Context Sequencer: 0
    Max SCN: 0
    Last RBASQN: 188702
    Last RBABLK: 76850
    Last RBABYTE: 16
    State: 4
    Redo logs:
    /tablespaces/oradata/BEL_PREP/redo02.log (Sequence=188720)
    /flashrecovery/BEL_PREP/archivelog/2012_10_11/o1_mf_1_188719_87d77lw6_.arc (Sequence=188719)
    /flashrecovery/BEL_PREP/archivelog/2012_10_11/o1_mf_1_188718_87d73s6v_.arc (Sequence=188718)
    /flashrecovery/BEL_PREP/archivelog/2012_10_11/o1_mf_1_188717_87d6ws5z_.arc (Sequence=188717)
    /flashrecovery/BEL_PREP/archivelog/2012_10_11/o1_mf_1_188716_87d6kj31_.arc (Sequence=188716)
    /flashrecovery/BEL_PREP/archivelog/2012_10_11/o1_mf_1_188715_

  2. #2
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    Hi Minh,

    Please run the following query against the source Oracle database and let me know the results:

    SELECT DBTIMEZONE , SESSIONTIMEZONE FROM dual;


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    minh is offline Junior Member
    Join Date
    Oct 2012
    Posts
    6
    Rep Power
    0
    Quote Originally Posted by Gadi.Farhat View Post
    Hi Minh,

    Please run the following query against the source Oracle database and let me know the results:

    SELECT DBTIMEZONE , SESSIONTIMEZONE FROM dual;


    Regards,

    Gadi


    Hi Gadi,

    here is the results


    DBTIMEZONE SESSIONTIMEZONE
    -------------------- --------------------
    +00:00 +02:00


    Minh

  4. #4
    Costi Zaboura is offline World Wide Support Manager
    Join Date
    Aug 2006
    Posts
    300
    Rep Power
    14
    Pls reproduce with trace set to ‘SOURCE’ and then get and provide us the output using the "collect diagnosis" button.

    See the following forum in how to achieve that:
    http://www.attunity.com/forums/chang...cing-2122.html



    Costi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  5. #5
    shaolao is offline Junior Member
    Join Date
    Nov 2012
    Posts
    5
    Rep Power
    0
    Greetings Costi, here are the results:

    Code:
    timestamp,type,node,status,sub_status,status_message,source, text_data,binary_data
    "11/5/2012 8:20:13 AM","INFO","bel-cdm-dsql","RUNNING","IDLE","ORACDC302I:The Oracle CDC instance for service ECBI_CDC and database ECBI_DV_CDC_BEL_PROD received a stop signal.","service","",""
    "11/5/2012 8:20:14 AM","INFO","bel-cdm-dsql","STOPPED","STOP","ORACDC301I:The Oracle CDC instance for service ECBI_CDC and database ECBI_DV_CDC_BEL_PROD stopped.","service","",""
    "11/5/2012 8:22:14 AM","INFO","bel-cdm-dsql","RUNNING","INIT","ORACDC300I:The Oracle CDC instance for service ECBI_CDC and database ECBI_DV_CDC_BEL_PROD started.","service","",""
    "11/5/2012 8:22:14 AM","INFO","bel-cdm-dsql","RUNNING","INIT","ORACDC305I:The value of the option 'source_env_report' was changed to 2.","infrastructure","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:** Debug / Announce input parameters. **
    Component Type:     
    Component Name:      
     at: 'oracle_source_allocate(...)'","source","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:** Debug / Announce input parameters. **
    Prepare 
     at: 'oracle_source_prepare(...)'","source","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Metadata Manager BUILD TABLE LIST Enter","engine","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Metadata Manager CONNECT Enter","engine","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Metadata Manager CONNECT Exit","engine","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Metadata Manager GET TABLES Enter","engine","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Metadata Manager GET TABLES Exit","engine","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Metadata Manager BUILD INDEXES Enter","engine","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Metadata Manager BUILD INDEXES Exit","engine","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Metadata Manager BUILD TABLE LIST Enter","engine","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:** Debug / Announce input parameters. **
    Component Type:     
    Component Name:      
     at: 'oracle_source_allocate(...)'","source","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:** Debug / Announce input parameters. **
    Prepare 
     at: 'oracle_source_prepare(...)'","source","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Sorter CONSTRUCTOR Enter","sorter","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Sorter CONSTRUCTOR Exit","sorter","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:** Debug / Announce input parameters. ** 
     at: 'oracle_source_set_stream(...)'","source","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:Oracle CDC Capture start","source","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Sorter RUN Enter","sorter","",""
    "11/5/2012 8:22:14 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:Oracle CDC Merger was allocated","source","",""
    "11/5/2012 8:22:16 AM","ERROR","bel-cdm-dsql","RUNNING","IDLE","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:22:17 AM","ERROR","bel-cdm-dsql","RUNNING","IDLE","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:22:17 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:22:17 AM","ERROR","bel-cdm-dsql","RUNNING","IDLE","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:22:29 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:22:29 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:22:29 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:22:41 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:22:41 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:22:41 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:22:53 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:22:53 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:22:53 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:23:04 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:23:04 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:23:04 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:23:16 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:23:16 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:23:16 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:23:28 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:23:28 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:23:28 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:23:40 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:23:40 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:23:40 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:23:52 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:23:52 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:23:52 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:24:04 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:24:04 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:24:04 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:24:16 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:24:16 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:24:16 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:24:28 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:24:28 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:24:28 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:24:39 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:24:39 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:24:39 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:24:51 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:24:51 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:24:51 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:25:02 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:25:02 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:25:02 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:25:13 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:25:13 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:25:13 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:25:25 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:25:25 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:25:25 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:25:36 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:25:36 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:25:36 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:25:48 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:25:48 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:25:48 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:26:00 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:26:00 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:26:00 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:26:11 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:26:11 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:26:11 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:26:23 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:26:23 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:26:23 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:26:34 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:26:34 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:26:34 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:26:46 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:26:46 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:26:46 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:26:58 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:26:58 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:26:58 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:27:09 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:27:09 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:27:09 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:27:21 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:27:21 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:27:21 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:27:32 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:27:32 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:27:32 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:27:44 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:27:44 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:27:44 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:27:56 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:27:56 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:27:56 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:28:07 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:28:07 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:28:07 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:28:19 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:28:19 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:28:19 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:28:19 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:28:19 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:28:32 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:28:32 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:28:32 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:28:32 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:28:32 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:28:43 AM","INFO","bel-cdm-dsql","RUNNING","IDLE","ORACDC303I:The Oracle CDC instance for service ECBI_CDC and database ECBI_DV_CDC_BEL_PROD received a reconfigure signal.","service","",""
    "11/5/2012 8:28:43 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:** Debug / Announce input parameters. ** 
     at: 'oracle_source_notify(...)'","source","",""
    "11/5/2012 8:28:43 AM","INFO","bel-cdm-dsql","RUNNING","IDLE","ORACDC305I:The value of the option 'source_env_report' was changed to 3.","infrastructure","",""
    "11/5/2012 8:28:43 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH Enter","engine","",""
    "11/5/2012 8:28:43 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager FIRST TABLE DEF Enter","engine","",""
    "11/5/2012 8:28:43 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager FIRST TABLE DEF Exit","engine","",""
    "11/5/2012 8:28:43 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager FIRST TABLE DEF Enter","engine","",""
    "11/5/2012 8:28:43 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager FIRST TABLE DEF Exit","engine","",""
    "11/5/2012 8:28:43 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager FIRST TABLE DEF Enter","engine","",""
    "11/5/2012 8:28:43 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager FIRST TABLE DEF Exit","engine","",""
    "11/5/2012 8:28:43 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager FIRST TABLE DEF Enter","engine","",""
    "11/5/2012 8:28:43 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager FIRST TABLE DEF Exit","engine","",""
    "11/5/2012 8:28:43 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH Exit","engine","",""
    "11/5/2012 8:28:43 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC514E:Failed to add redo log with sequence 176049.","source","",""
    "11/5/2012 8:28:43 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 8:28:43 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 8:28:43 AM","REPORT","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000R:Oracle Diagnostics","infrastructure","
    Character set information:
        NLS_CHARACTERSET: 31
        LS_NCHAR_CHARACTERSET: 2000
    
    Reader Information: 
        Thread: 1
        Last Transaction SCN: 9917013823339
        Last SCN: 9917013823339
        Greatest Sequence: 176242
        Start SCN: 9917013823339
        Transaction Sequencer: 1
        Context Sequencer: 0
        Max SCN: 0
        Last RBASQN: 175497
        Last RBABLK: 46103
        Last RBABYTE: 16
        State: 0
    
    Redo logs:
        /tablespaces/oradata/BEL_PROD/redo03.log (Sequence=176242)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176241)
        /tablespaces/oradata/BEL_PROD/1_176241_687958755.dbf (Sequence=176241)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176240)
        /tablespaces/oradata/BEL_PROD/1_176240_687958755.dbf (Sequence=176240)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176239)
        /tablespaces/oradata/BEL_PROD/1_176239_687958755.dbf (Sequence=176239)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176238)
        /tablespaces/oradata/BEL_PROD/1_176238_687958755.dbf (Sequence=176238)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176237)
        /tablespaces/oradata/BEL_PROD/1_176237_687958755.dbf (Sequence=176237)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176236)
        /tablespaces/oradata/BEL_PROD/1_176236_687958755.dbf (Sequence=176236)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176235)
        /tablespaces/oradata/BEL_PROD/1_176235_687958755.dbf (Sequence=176235)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176234)
        /tablespaces/oradata/BEL_PROD/1_176234_687958755.dbf (Sequence=176234)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176233)
        /tablespaces/oradata/BEL_PROD/1_176233_687958755.dbf (Sequence=176233)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176232)
        /tablespaces/oradata/BEL_PROD/1_176232_687958755.dbf (Sequence=176232)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176231)
        /tablespaces/oradata/BEL_PROD/1_176231_687958755.dbf (Sequence=176231)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176095)
        /tablespaces/oradata/BEL_PROD/1_176095_687958755.dbf (Sequence=176095)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176094)
        /tablespaces/oradata/BEL_PROD/1_176094_687958755.dbf (Sequence=176094)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176093)
        /tablespaces/oradata/BEL_PROD/1_176093_687958755.dbf (Sequence=176093)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176092)
        /tablespaces/oradata/BEL_PROD/1_176092_687958755.dbf (Sequence=176092)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176091)
        /tablespaces/oradata/BEL_PROD/1_176091_687958755.dbf (Sequence=176091)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176090)
        /tablespaces/oradata/BEL_PROD/1_176090_687958755.dbf (Sequence=176090)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176089)
        /tablespaces/oradata/BEL_PROD/1_176089_687958755.dbf (Sequence=176089)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176088)
        /tablespaces/oradata/BEL_PROD/1_176088_687958755.dbf (Sequence=176088)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176087)
        /tablespaces/oradata/BEL_PROD/1_176087_687958755.dbf (Sequence=176087)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176086)
        /tablespaces/oradata/BEL_PROD/1_176086_687958755.dbf (Sequence=176086)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176085)
        /tablespaces/oradata/BEL_PROD/1_176085_687958755.dbf (Sequence=176085)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176084)
        /tablespaces/oradata/BEL_PROD/1_176084_687958755.dbf (Sequence=176084)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176083)
        /tablespaces/oradata/BEL_PROD/1_176083_687958755.dbf (Sequence=176083)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176082)
        /tablespaces/oradata/BEL_PROD/1_176082_687958755.dbf (Sequence=176082)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176081)
        /tablespaces/oradata/BEL_PROD/1_176081_687958755.dbf (Sequence=176081)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176080)
        /tablespaces/oradata/BEL_PROD/1_176080_687958755.dbf (Sequence=176080)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176079)
        /tablespaces/oradata/BEL_PROD/1_176079_687958755.dbf (Sequence=176079)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176078)
        /tablespaces/oradata/BEL_PROD/1_176078_687958755.dbf (Sequence=176078)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176077)
        /tablespaces/oradata/BEL_PROD/1_176077_687958755.dbf (Sequence=176077)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176076)
        /tablespaces/oradata/BEL_PROD/1_176076_687958755.dbf (Sequence=176076)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176075)
        /tablespaces/oradata/BEL_PROD/1_176075_687958755.dbf (Sequence=176075)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176074)
        /tablespaces/oradata/BEL_PROD/1_176074_687958755.dbf (Sequence=176074)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176073)
        /tablespaces/oradata/BEL_PROD/1_176073_687958755.dbf (Sequence=176073)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176072)
        /tablespaces/oradata/BEL_PROD/1_176072_687958755.dbf (Sequence=176072)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176071)
        /tablespaces/oradata/BEL_PROD/1_176071_687958755.dbf (Sequence=176071)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176070)
        /tablespaces/oradata/BEL_PROD/1_176070_687958755.dbf (Sequence=176070)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176069)
        /tablespaces/oradata/BEL_PROD/1_176069_687958755.dbf (Sequence=176069)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176068)
        /tablespaces/oradata/BEL_PROD/1_176068_687958755.dbf (Sequence=176068)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176067)
        /tablespaces/oradata/BEL_PROD/1_176067_687958755.dbf (Sequence=176067)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176066)
        /tablespaces/oradata/BEL_PROD/1_176066_687958755.dbf (Sequence=176066)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176065)
        /tablespaces/oradata/BEL_PROD/1_176065_687958755.dbf (Sequence=176065)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176064)
        /tablespaces/oradata/BEL_PROD/1_176064_687958755.dbf (Sequence=176064)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176063)
        /tablespaces/oradata/BEL_PROD/1_176063_687958755.dbf (Sequence=176063)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176062)
        /tablespaces/oradata/BEL_PROD/1_176062_687958755.dbf (Sequence=176062)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176061)
        /tablespaces/oradata/BEL_PROD/1_176061_687958755.dbf (Sequence=176061)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176060)
        /tablespaces/oradata/BEL_PROD/1_176060_687958755.dbf (Sequence=176060)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176059)
        /tablespaces/oradata/BEL_PROD/1_176059_687958755.dbf (Sequence=176059)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176058)
        /tablespaces/oradata/BEL_PROD/1_176058_687958755.dbf (Sequence=176058)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176057)
        /tablespaces/oradata/BEL_PROD/1_176057_687958755.dbf (Sequence=176057)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176056)
        /tablespaces/oradata/BEL_PROD/1_176056_687958755.dbf (Sequence=176056)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176055)
        /tablespaces/oradata/BEL_PROD/1_176055_687958755.dbf (Sequence=176055)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176054)
        /tablespaces/oradata/BEL_PROD/1_176054_687958755.dbf (Sequence=176054)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176053)
        /tablespaces/oradata/BEL_PROD/1_176053_687958755.dbf (Sequence=176053)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176052)
        /tablespaces/oradata/BEL_PROD/1_176052_687958755.dbf (Sequence=176052)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176051)
        /tablespaces/oradata/BEL_PROD/1_176051_687958755.dbf (Sequence=176051)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176050)
        /tablespaces/oradata/BEL_PROD/1_176050_687958755.dbf (Sequence=176050)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176049)
        (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=bel-dwh-pora.conseur.org)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=BELSTB_XPT.WORLD)(INSTANCE_NAME=BELSTB)(SERVER=dedicated))) (Sequence=176048)
        (D
    Captured Tables:
        91182
        91167
        91084
        90998
    ",""

  6. #6
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    Hi Minh,

    The error you are getting now is different. You are getting now the following error: "Failed to add redo log with sequence 176049".

    This happens because the redo log with sequence 176049 is no longer available. I.e. it was deleted from "/tablespaces/oradata/BEL_PROD". This may happen because the instance was stopped for long time and therefore the redo log was deleted.

    You need to reset the CDC instance and then reproduce the original error with trace turned on.


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  7. #7
    shaolao is offline Junior Member
    Join Date
    Nov 2012
    Posts
    5
    Rep Power
    0
    Here goes:

    Code:
    timestamp,type,node,status,sub_status,status_message,source, text_data,binary_data
    "11/5/2012 9:30:44 AM","INFO","bel-cdm-dsql","RUNNING","IDLE","ORACDC302I:The Oracle CDC instance for service ECBI_CDC and database testPREP received a stop signal.","service","",""
    "11/5/2012 9:30:44 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Sorter RUN Exit","sorter","",""
    "11/5/2012 9:30:44 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:** Debug / Announce input parameters. **
     at: 'oracle_source_free(...)'","source","",""
    "11/5/2012 9:30:44 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:** Debug / Announce input parameters. **
     at: 'oracle_source_free(...)'","source","",""
    "11/5/2012 9:30:44 AM","INFO","bel-cdm-dsql","STOPPED","STOP","ORACDC301I:The Oracle CDC instance for service ECBI_CDC and database testPREP stopped.","service","",""
    "11/5/2012 9:32:44 AM","INFO","bel-cdm-dsql","RUNNING","INIT","ORACDC300I:The Oracle CDC instance for service ECBI_CDC and database testPREP started.","service","",""
    "11/5/2012 9:32:44 AM","INFO","bel-cdm-dsql","RUNNING","INIT","ORACDC305I:The value of the option 'source_env_report' was changed to 4.","infrastructure","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:** Debug / Announce input parameters. **
    Component Type:    
    Component Name:      
     at: 'oracle_source_allocate(...)'","source","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:** Debug / Announce input parameters. **
    Prepare
     at: 'oracle_source_prepare(...)'","source","",""
    "11/5/2012 9:32:44 AM","ERROR","bel-cdm-dsql","RUNNING","INIT","ORACDC519E:Archiving mode is not set.","source","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Metadata Manager BUILD TABLE LIST Enter","engine","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Metadata Manager CONNECT Enter","engine","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Metadata Manager CONNECT Exit","engine","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Metadata Manager GET TABLES Enter","engine","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Metadata Manager GET TABLES Exit","engine","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Metadata Manager BUILD INDEXES Enter","engine","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Metadata Manager BUILD INDEXES Exit","engine","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Metadata Manager BUILD TABLE LIST Enter","engine","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:** Debug / Announce input parameters. **
    Component Type:    
    Component Name:      
     at: 'oracle_source_allocate(...)'","source","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:** Debug / Announce input parameters. **
    Prepare
     at: 'oracle_source_prepare(...)'","source","",""
    "11/5/2012 9:32:44 AM","ERROR","bel-cdm-dsql","RUNNING","INIT","ORACDC519E:Archiving mode is not set.","source","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Sorter CONSTRUCTOR Enter","sorter","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Sorter CONSTRUCTOR Exit","sorter","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:** Debug / Announce input parameters. **
     at: 'oracle_source_set_stream(...)'","source","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:Oracle CDC Capture start","source","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","INIT","ORACDC000T:The Sorter RUN Enter","sorter","",""
    "11/5/2012 9:32:44 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:Oracle CDC Merger was allocated","source","",""
    "11/5/2012 9:32:48 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch CALLBACK Success Exit","sorter","",""
    "11/5/2012 9:32:48 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Enter","sorter","",""
    "11/5/2012 9:32:48 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER New Transaction","sorter","",""
    "11/5/2012 9:32:48 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Begin Empty Transaction Exit","sorter","",""
    "11/5/2012 9:32:48 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Enter","sorter","",""
    "11/5/2012 9:32:48 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Commit Exit","sorter","",""
    "11/5/2012 9:32:48 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Enter","sorter","",""
    "11/5/2012 9:32:48 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER EndOfBatch Exit","sorter","",""
    "11/5/2012 9:33:01 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch CALLBACK Success Exit","sorter","",""
    "11/5/2012 9:33:01 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Enter","sorter","",""
    "11/5/2012 9:33:01 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER New Transaction","sorter","",""
    "11/5/2012 9:33:01 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Begin Empty Transaction Exit","sorter","",""
    "11/5/2012 9:33:01 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Enter","sorter","",""
    "11/5/2012 9:33:01 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Commit Exit","sorter","",""
    "11/5/2012 9:33:01 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Enter","sorter","",""
    "11/5/2012 9:33:01 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER EndOfBatch Exit","sorter","",""
    "11/5/2012 9:33:12 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch CALLBACK Success Exit","sorter","",""
    "11/5/2012 9:33:12 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Enter","sorter","",""
    "11/5/2012 9:33:12 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER New Transaction","sorter","",""
    "11/5/2012 9:33:12 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Begin Empty Transaction Exit","sorter","",""
    "11/5/2012 9:33:12 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Enter","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER New Transaction","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Begin Empty Transaction Exit","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Enter","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Commit Exit","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Enter","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter GET MEMORY CHUNK Enter","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter GET MEMORY CHUNK Exit","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:15 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter GET MEMORY CHUNK Enter","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter GET MEMORY CHUNK Exit","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER New Transaction","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Begin Empty Transaction Exit","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Enter","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Commit Exit","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Enter","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER EndOfBatch Exit","sorter","",""
    "11/5/2012 9:34:24 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    
    "11/5/2012 9:34:29 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Enter","sorter","",""
    "11/5/2012 9:34:29 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter PROCESS CDC EVENT Exit","sorter","",""
    "11/5/2012 9:34:34 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:34:34 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:34:34 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:34:44 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:34:44 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:34:44 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:34:54 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:34:54 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:34:54 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:35:04 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:35:04 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:35:04 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:35:14 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:35:14 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:35:14 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:35:25 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:35:25 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:35:25 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:35:35 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:35:35 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:35:35 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:35:45 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:35:45 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:35:45 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:35:55 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:35:55 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:35:55 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:36:05 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:36:05 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:36:05 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:36:15 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:36:15 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:36:15 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:36:25 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:36:25 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:36:25 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:36:29 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter UNLOAD OLD TRANSACTION CHUNKS active","sorter","",""
    "11/5/2012 9:36:29 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter UNLOAD TRANSACTION CHUNKS Enter","sorter","",""
    "11/5/2012 9:36:29 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Enter","sorter","",""
    "11/5/2012 9:36:29 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Exit","sorter","",""
    "11/5/2012 9:36:29 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Enter","sorter","",""
    "11/5/2012 9:36:29 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Exit","sorter","",""
    "11/5/2012 9:36:29 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Enter","sorter","",""
    "11/5/2012 9:36:29 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Exit","sorter","",""
    "11/5/2012 9:36:29 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Exit","sorter","",""
    "11/5/2012 9:36:29 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Enter","sorter","",""
    "11/5/2012 9:36:29 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Exit","sorter","",""
    "11/5/2012 9:36:29 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Enter","sorter","",""
    "11/5/2012 9:36:30 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Exit","sorter","",""
    "11/5/2012 9:36:30 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Enter","sorter","",""
    "11/5/2012 9:36:30 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Exit","sorter","",""
    "11/5/2012 9:36:30 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Enter","sorter","",""
    "11/5/2012 9:36:30 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Exit","sorter","",""
    "11/5/2012 9:36:30 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter UNLOAD TRANSACTION CHUNKS Exit","sorter","",""
    "11/5/2012 9:36:30 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter UNLOAD OLD TRANSACTION CHUNKS 1 transactions has been unloaded","sorter","",""
    "11/5/2012 9:36:35 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:36:35 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:36:35 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:36:45 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:36:45 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:36:45 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:36:55 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:36:56 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:36:56 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:37:06 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:37:06 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:37:06 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:37:16 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:37:16 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:37:16 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:37:26 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:37:26 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:37:26 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:37:36 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:37:36 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:37:36 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:37:46 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    "11/5/2012 9:39:14 AM","INFO","bel-cdm-dsql","RUNNING","IDLE","ORACDC305I:The value of the option 'source_env_report' was changed to 5.","infrastructure","",""
    "11/5/2012 9:39:14 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH Enter","engine","",""
    "11/5/2012 9:39:14 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager FIRST TABLE DEF Enter","engine","",""
    "11/5/2012 9:39:14 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager FIRST TABLE DEF Exit","engine","",""
    "11/5/2012 9:39:14 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH Exit","engine","",""
    "11/5/2012 9:39:14 AM","REPORT","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000R:Oracle Diagnostics","infrastructure","
    Character set information:
        NLS_CHARACTERSET: 31
        LS_NCHAR_CHARACTERSET: 2000
    
    Reader Information:
        Thread: 1
        Last Transaction SCN: 9917189064147
        Last SCN: 9917189064148
        Greatest Sequence: 195358
        Start SCN: 9917189064148
        Transaction Sequencer: 0
        Context Sequencer: 0
        Max SCN: 9917189064166
        Last RBASQN: 195356
        Last RBABLK: 97266
        Last RBABYTE: 176
        State: 0
    
    Redo logs:
        /tablespaces/oradata/BEL_PREP/redo01.log (Sequence=195358)
    
    Captured Tables:
        800697
    ",""
    "11/5/2012 9:39:17 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:39:17 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:39:17 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:39:27 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:39:27 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:39:27 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:39:37 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:39:37 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:39:37 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:39:47 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:39:47 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:39:47 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:39:57 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:39:57 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:39:57 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:40:07 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:40:07 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:40:07 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:40:17 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:40:18 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:40:18 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:40:28 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:40:28 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:40:28 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:40:38 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:40:38 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:40:38 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:40:48 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:40:48 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:40:48 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:40:58 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:40:58 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:40:58 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:41:08 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:41:08 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:41:08 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:41:18 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:41:18 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:41:18 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:41:29 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:41:29 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:41:29 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:41:39 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:41:39 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:41:39 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:41:49 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:41:49 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:41:49 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:41:59 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:41:59 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:41:59 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:42:09 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:42:09 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:42:09 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:42:19 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:42:19 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:42:19 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:42:29 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:42:29 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:42:29 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:42:39 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01291: missing logfile
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 2
    .","source","",""
    "11/5/2012 9:42:39 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "11/5/2012 9:42:39 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
    "11/5/2012 9:42:44 AM","INFO","bel-cdm-dsql","RUNNING","IDLE","ORACDC303I:The Oracle CDC instance for service ECBI_CDC and database testPREP received a reconfigure signal.","service","",""
    "11/5/2012 9:42:44 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:** Debug / Announce input parameters. **
     at: 'oracle_source_notify(...)'","source","",""
    "11/5/2012 9:42:44 AM","INFO","bel-cdm-dsql","RUNNING","IDLE","ORACDC305I:The value of the option 'source_env_report' was changed to 6.","infrastructure","",""
    "11/5/2012 9:42:44 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH Enter","engine","",""
    "11/5/2012 9:42:44 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager FIRST TABLE DEF Enter","engine","",""
    "11/5/2012 9:42:44 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager FIRST TABLE DEF Exit","engine","",""
    "11/5/2012 9:42:44 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH Exit","engine","",""
    "11/5/2012 9:42:44 AM","REPORT","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000R:Oracle Diagnostics","infrastructure","
    Character set information:
        NLS_CHARACTERSET: 31
        LS_NCHAR_CHARACTERSET: 2000
    
    Reader Information:
        Thread: 1
        Last Transaction SCN: 9917189064147
        Last SCN: 9917189064148
        Greatest Sequence: 195358
        Start SCN: 9917189064148
        Transaction Sequencer: 0
        Context Sequencer: 0
        Max SCN: 9917189064166
        Last RBASQN: 195356
        Last RBABLK: 97266
        Last RBABYTE: 176
        State: 0
    
    Redo logs:
        /tablespaces/oradata/BEL_PREP/redo01.log (Sequence=195358)
    
    Captured Tables:
        800697
    ",""

  8. #8
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    Hi,

    Seems like your source Oracle database is not set to work in ARCHIVELOG mode. From the log, you can find the following error:

    "ORACDC519E:Archiving mode is not set."

    To work with the Change Data Capture, you must enable the source Oracle database for archiving. To change the mode to ARCHIVELOG, you can run:

    ALTER DATABASE ARCHIVELOG


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  9. #9
    shaolao is offline Junior Member
    Join Date
    Nov 2012
    Posts
    5
    Rep Power
    0
    here's the error after everything is set and with trace:

    Code:
    "11/5/2012 11:45:18 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER Enter","sorter","",""
    "11/5/2012 11:45:18 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter Batch READER EndOfBatch Exit","sorter","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:The Metadata Manager REFRESH SOURCE TABLE METADATA Enter","engine","",""
    "11/5/2012 11:45:21 AM","ERROR","bel-cdm-dsql","RUNNING","IDLE","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "11/5/2012 11:45:21 AM","TRACE","bel-cdm-dsql","RUNNING","IDLE","ORACDC000T:Error encountered at fetch - EOF simulated","source","",""
    "11/5/2012 11:45:21 AM","ERROR","bel-cdm-dsql","RUNNING","IDLE","ORACDC512E:Failed to fetch a new record.","source","",""
    "11/5/2012 11:45:32 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "11/5/2012 11:45:32 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at fetch - EOF simulated","source","",""
    "11/5/2012 11:45:32 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "11/5/2012 11:45:42 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "11/5/2012 11:45:42 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at fetch - EOF simulated","source","",""
    "11/5/2012 11:45:42 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "11/5/2012 11:45:53 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "11/5/2012 11:45:53 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at fetch - EOF simulated","source","",""
    "11/5/2012 11:45:53 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "11/5/2012 11:46:03 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "11/5/2012 11:46:03 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at fetch - EOF simulated","source","",""
    "11/5/2012 11:46:03 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "11/5/2012 11:46:14 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "11/5/2012 11:46:14 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at fetch - EOF simulated","source","",""
    "11/5/2012 11:46:14 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "11/5/2012 11:46:25 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "11/5/2012 11:46:25 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at fetch - EOF simulated","source","",""
    "11/5/2012 11:46:25 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "11/5/2012 11:46:35 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "11/5/2012 11:46:35 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at fetch - EOF simulated","source","",""
    "11/5/2012 11:46:35 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "11/5/2012 11:46:46 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "11/5/2012 11:46:46 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at fetch - EOF simulated","source","",""
    "11/5/2012 11:46:46 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "11/5/2012 11:46:56 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "11/5/2012 11:46:56 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at fetch - EOF simulated","source","",""
    "11/5/2012 11:46:56 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "11/5/2012 11:47:07 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "11/5/2012 11:47:07 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at fetch - EOF simulated","source","",""
    "11/5/2012 11:47:07 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "11/5/2012 11:47:17 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "11/5/2012 11:47:17 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at fetch - EOF simulated","source","",""
    "11/5/2012 11:47:17 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "11/5/2012 11:47:21 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter UNLOAD OLD TRANSACTION CHUNKS active","sorter","",""
    "11/5/2012 11:47:21 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter UNLOAD TRANSACTION CHUNKS Enter","sorter","",""
    "11/5/2012 11:47:21 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Enter","sorter","",""
    "11/5/2012 11:47:21 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter INSERT STAGED CHUNK Exit","sorter","",""
    "11/5/2012 11:47:21 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter UNLOAD TRANSACTION CHUNKS Exit","sorter","",""
    "11/5/2012 11:47:21 AM","TRACE","bel-cdm-dsql","RUNNING","PROCESSING","ORACDC000T:The Sorter UNLOAD OLD TRANSACTION CHUNKS 1 transactions has been unloaded","sorter","",""
    "11/5/2012 11:47:28 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "11/5/2012 11:47:28 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at fetch - EOF simulated","source","",""
    "11/5/2012 11:47:28 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "11/5/2012 11:47:39 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "11/5/2012 11:47:39 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at fetch - EOF simulated","source","",""
    "11/5/2012 11:47:39 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "11/5/2012 11:47:49 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "11/5/2012 11:47:49 AM","TRACE","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000T:Error encountered at fetch - EOF simulated","source","",""
    "11/5/2012 11:47:49 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""

  10. #10
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    What is the Oracle database version you are using?

    Also, please run the following query and and let me know the results:

    select parameter , value from nls_database_parameters where parameter like 'NLS%';


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •