Results 1 to 6 of 6

Thread: change capture error

  1. #1
    solar.chen is offline Junior Member
    Join Date
    May 2009
    Location
    Taiwan
    Posts
    3
    Rep Power
    0

    change capture error

    Dear sirs :

    change capture error :

    when i update some date of the only table for oracle database

    CDC-management show

    WED MAY 06 18:03:17 2009: ORACDC: Parsing error : Unexpected token found. - / Failure in oracdc_fetchNextRow(...)

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

    Most likely this error is related to a datatype unsupported by the Oracle logminer.

    Please supply the following information so we can analyze the problem further:

    1. Oracle table metadata - Perform describe table using SQLPlus

    2. CDC Service log files with detailed trace - Using the CDC Management Console do the following:
    • Pause the Change Capture in the CDC Management page.
    • Activate the trace and set the detaled trace to debug in the CDC Configuration page.
    • Resume the Change Capture in the CDC Management page.
    • After getting the error, Click on the "Open Log Folder..." and attache a zip of all log files.
    3. The exact file name of the product installation kit.

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

  3. #3
    solar.chen is offline Junior Member
    Join Date
    May 2009
    Location
    Taiwan
    Posts
    3
    Rep Power
    0
    Hi Gadi ,
    thank your answer.
    I find out the cause of the problem
    because source table have the value is '' ( not ' ' )
    -----------------------------------------------------
    select uuid ,ORIG from EQ
    where uuid between 563 and 580 ;
    --------------------------------------------------
    uuid ORIG
    563 (null)
    564 (null)
    565
    566 (null)
    --------------------------------------------------------------------


    other question is :
    on Error Handling from CDC Management
    i try to use skip button
    but it still keep the error:
    THU MAY 07 14:48:28 2009: ORACDC: Parsing error : Unexpected token found. - / Failure in oracdc_fetchNextRow(...)


    how can i skip this error ?






    Thanks,
    Solar
    Last edited by solar.chen; 05-07-2009 at 03:31 AM.

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

    If I understand you correctly then you have a string column with an empty value (''). I am not sure how you inserted empty string ('') to a string column in Oracle because, Oracle handle empty value as NULL.

    Please provide the table metadata and the log files so that we analyze the problem.

    Anyway, in order to skip the problematic record, you may use the Reset CDC option, from the CDC Management page, and set the stream position to a time later than the change occurrence time or to an SCN greater that the change SCN.

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

  5. #5
    solar.chen is offline Junior Member
    Join Date
    May 2009
    Location
    Taiwan
    Posts
    3
    Rep Power
    0
    Hi Gadi ,
    thank your answer.

    1-It is a useful tool to skip my problematic record by using the Reset CDC option .
    2-The attachments is the table metadata and the log file
    3-from export.zip , I find out The string column with an value is (' ') not ('').



    Thanks,
    Solar

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

    Thank you for supplying the information.

    As you can see from the logs, the query returned by the Oracle logminer has an incorrect syntax therefore, the parser report an error.


    We still want to understand when this problem happens. So please check the following:

    1. Is it possible that the data stored in this column, in the problematic record, is non English characters and not spaces? They may be not displayed because the Oracle client codepage is not set correctly.

    2. Did you choose the correct language when configuring the CDC Sevice? You may open the Management Console, in the Configuration page, please make sure the language and the NLS_LANG are set properly.


    Thanks,

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

Posting Permissions

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