Data Replication 2
Results 1 to 2 of 2

Thread: Log Error SQLCDCLGR

  1. #1
    Yudhi.Hermawan is offline Junior Member
    Join Date
    Jun 2010
    Location
    Indonesia
    Posts
    2
    Rep Power
    0

    Log Error SQLCDCLGR

    Hi All

    I found error message on SQLCDCLGR- .log
    The change capture not show data updateable, job detainer and log reader agent was running.

    here the error message

    Please help what should i check

    "
    <<20100729-094951>> Module:sqlcdclgr/Line:712

    Attunity Ltd. All Rights Reserved.
    SQLCDCLGR Version facility:

    November-2009
    +++++++++

    <<20100729-094951>> Module:SQLCDCLGR/Line:304 Input parameters display:

    SQLCDCLGR run at: 29-Jul-2010 09:49.51

    SQLCDCLGR parameters:
    +++++++++++++++++++++
    <!--
    SQLCDCLGR parameters
    ++++++++++++++++++++
    -->
    <config datasource='BULK' retryInterval='2' getBeforeImage='false' realTime='true' logLevel='none' ignoreTransactionInfo='false' checkTimeoutEveryNEvents='1000' transientStorageDirectory='D:\CDC\Attunity-Transaction\CDC\AIS\.transientStorage' lgrAutoConfig='true'>
    <routers></routers>

    <serviceInfo serviceName='AttunitySQLServerCDC_Attunity-Transaction_Logger' logDirectory='D:\CDC\Attunity-Transaction\CDC\Logs'></serviceInfo>

    <detainer detainingTimeInterval='300' disableReplicationBasedLogDetainer='false' traceActivity='false' replicationProcessingInterval='500' loggerPollingInterval='30'></detainer>

    <transientStorage directory='D:\CDC\Attunity-Transaction\CDC\AIS\.transientStorage' maxFileSize='10' maxStorageSize='50000' truncateOnExceededMaxStorage='false' eventExpirationHours='4' cleanupInterval='10'></transientStorage>

    <scanner batchSize='50000' retryInterval='1' enableStatusTracking='true' statusTrackingInterval='30' logLevel='none' traceDBCC='false' traceStatistics='false'></scanner>

    <cdcOrigin server='SFIDBOLTP2SVR\sfi_sql_instance' database='mfin' defaultOwner='dbo' useWindowsAuthentication='false'>
    <authenticator authenticatorType='adapter' resourceName='CDC_LOGGER'></authenticator>
    </cdcOrigin>
    </config>

    <<20100729-094951>> Module:SQLCDC_TRNSTOR/Line:623 Attending LGR abnormal end situation:
    Ok.
    <<20100729-094951>> Module:SQLCDC_TRNSTOR/Line:2053 Cleanup message:
    Cleanup could not complete. An occupied cleanup candidate?? D:\CDC\Attunity.cdc
    <<20100729-094951>> Module:trnStorClearAgedData/Line:2054 trnStor I/O error tracer:

    Operation: remove
    File name: D:\CDC\Attunity.cdc
    errno: 2
    Message: No such file or directory
    Comment:

    <<20100729-094952>> Module:sqlcdclgr/Line:984 Warning:

    *** Problems in SQLDMO sampling of MS-SQL server status for 'SFIDBOLTP2SVR\sfi_sql_instance'.

    Microsoft SQL-DMO Error: -2147024891

    [SQL-DMO]Service Control Error: Access is denied.



    Access is denied.


    *** Server instance is assumed as 'Running'

    <<20100729-094952>> Module:sqlcdclgr/Line:996 Info:
    MS-SQL server on 'SFIDBOLTP2SVR\sfi_sql_instance' IS available for connection. Status is 'Service is running'
    <<20100729-094952>> Module:SQLCDC_SESSION/Line:111 informational:


    Attunity Ltd. All Rights Reserved.
    SQLCDCLGR Version facility:
    November-2009
    +++++++++

    <<20100729-094952>> Module:SQLCDC_SESSION/Line:140
    informational:


    SQLCDC connection details:
    Server : SFIDBOLTP2SVR\sfi_sql_instance
    Database : [mfin]
    User : sqlservice
    Pasword: *********

    <<20100729-094953>> Module:SQLCDC_SESSION/Line:242 informational:


    SQLCDC connection establish successfully(!):
    Time : 2010-07-29T09:49:53.917
    Server : SFIDBOLTP2SVR\sfi_sql_instance
    Database : [mfin]
    User : sqlservice
    <<20100729-094954>> Module:sqlcdclgr/Line:523 Informational:
    Detainer job 'AttunityDetainerJob-10' **IS** running.
    <<20100729-094954>> Module:sqlcdclgr/Line:529 Informational:
    Replication job 'SFIDBOLTP2SVR\SFI_SQL_INSTANCE-MFIN-1' is not runnig.
    <<20100729-094954>> Module:sqlcdclgr/Line:1047 MS-SQL version sampled:
    Microsoft SQL Server 2000 - 8.00.2273 (Intel IA-64)
    Mar 7 2008 21:30:36
    Copyright (c) 1988-2003 Microsoft Corporation
    Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

    <<20100729-095021>> Module:trnStorSealTOCentry/Line:929 trnStor I/O error tracer:

    Operation: rename
    File name: D:\CDC\Attunity-Transaction\CDC\AIS\.transientStorage\00012759_000 03f18_0001-0001275b_00002e0a_003b.toc
    errno: 17
    Message: File exists
    Comment: D:\CDC\Attunity-Transaction\CDC\AIS\.transientStorage\00012759_000 03f18_0001.toc

    <<20100729-095956>> Module:SQLCDC_TRNSTOR/Line:2053 Cleanup message:
    Cleanup could not complete. An occupied cleanup candidate?? D:\CDC\Attunity.cdc
    <<20100729-095956>> Module:trnStorClearAgedData/Line:2054 trnStor I/O error tracer:

    Operation: remove
    File name: D:\CDC\Attunity.cdc
    errno: 2
    Message: No such file or directory
    Comment:

    "

  2. #2
    Costi Zaboura is offline World Wide Support Manager
    Join Date
    Aug 2006
    Posts
    300
    Rep Power
    14
    Hi Yudhi

    Please contact the Attunity Support team on that . we will need logs and cetrainly more info. in order to be able to check this issue.

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

Tags for this Thread

Posting Permissions

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