Data Replication 1

Search:

Type: Posts; User: DrorHarari; Keyword(s):

Page 1 of 10 1 2 3 4

Search: Search took 0.00 seconds.

  1. Sybase connection problem - Bad TDS response stream received from server

    When working with a Sybase source, the following error was observed:



    The cause of this error is a Sybase installation problem. Normally that installation sets up global environment variables...
  2. How to check that a pooled JDBC connection is still active

    When the Attunity Connect JDBC driver is used via a connection pool manager in an application server (e.g. Oracle WebLogic) there is often an option to configure an SQL statement to use for checking...
  3. Replies
    0
    Views
    2,487

    Does AIS support TVIRLIQ authentication

    Not at this time, sorry.
  4. When communicating with the daemon process...

    When communicating with the daemon process (IRPCD), you typically need to provide a username and a password. If you do not provide a username then the current account name is used and the password...
  5. DPL response 27 refers to the PGMIDERR condition...

    DPL response 27 refers to the PGMIDERR condition - please consult the following IBM page for possible reasons:

    Help -

    Recycling the Attunity server is not likely to solve this issue. The...
  6. Now this is anunsupported hack that will have to...

    Now this is anunsupported hack that will have to be repeated whenever a new version of Studio is installed but it might help you better use the Attunity Studio. There is no commitment it would work...
  7. To move 5000 SQL Server tables to Sybase ASE or...

    To move 5000 SQL Server tables to Sybase ASE or Sybase IQ you can use Attunity Replicate. It deals with both the initial load and the CDC and setting it up is a few minutes work. Contact Attunity...
  8. Replies
    2
    Views
    5,560

    This is reasonable and doable - look in the...

    This is reasonable and doable - look in the manual for the special CONTROL_TABLE staging area table. Using it you can pause/resume the change processing.
  9. These are tables that are used for bulk loading...

    These are tables that are used for bulk loading change data to the target database. Replicate uses a few of those tables and they should not accumulate. Please contact support for additional help.
  10. Replies
    6
    Views
    3,810

    Sql arm...

    Sql arm - this question is not related to this thread - please open a different thread, Also posting the UI picture does not provide any info, you need to collect logs (see documentation).
  11. Replies
    1
    Views
    2,621

    By design, the only way to communicate with the...

    By design, the only way to communicate with the CDC process is by means of the database so those procedures xdbcdc_start/stop
    which update the table xdbcdc_databases are the way to go. The CDC...
  12. In cases such as the one you have reported, it is...

    In cases such as the one you have reported, it is better to run the linked server out of process so as to avoid destabilizing SQL Server's main process.

    To identify the root cause, the easiest...
  13. Likely those are background Oracle servers used...

    Likely those are background Oracle servers used by the Oracle Log Miner infrastructure and not directly under the direct control of the CDC service (see Background Processes).
  14. That is a strange error indeed. This error is...

    That is a strange error indeed. This error is reported during the dynamic loading of the Oracle client. Specifically, the symbol OCIDirPathFinish is being loaded from the Oracle client DLL and this...
  15. James, The numbers you give ~500 million rows,...

    James,

    The numbers you give ~500 million rows, each of ~150 columns correlate with the ~600GB DISAM file size so DPACK would not gain you any significant savings... what is eating your storage is...
  16. The first thing you need to check is how much...

    The first thing you need to check is how much data there is actually on that file - use a SELECT COUNT(*) on the corresponding staging area table and you will find out. If the actual # of rows in...
  17. Anything the CDC instance does is reflected in...

    Anything the CDC instance does is reflected in its state table in SQL Server. While not part of the supported scenarios, anything you can achieve by means of triggers that would not affect the...
  18. Most likely your task fails in the validation...

    Most likely your task fails in the validation phase were, according to the SSIS component design, the components must ensure before running that they have the right database, table and columns as...
  19. By the way, I have just noticed that you are...

    By the way, I have just noticed that you are using PWD= rather than PASSWORD= which IIRC is the right property for use with standard SSIS components (again, as I mentioned we are following the...
  20. Hi dwainew, To your question, we (some people...

    Hi dwainew,

    To your question, we (some people at Attunity) are monitoring the forum and when we can, answer about issues that directly relate to the working of our components. This specific issue...
  21. Kevin, I updated the sample with a reference...

    Kevin,

    I updated the sample with a reference to adapter that implements the interaction that the Cobol program calls. It is a C test program that can be built on various platforms but is already...
  22. Replies
    3
    Views
    3,017

    When defining an Oracle Source Component in SSIS,...

    When defining an Oracle Source Component in SSIS, after providing the name of the connection manager and the 'Table Name' data access mode, there is a text box called 'Name of the table of the view'....
  23. [NOTE: The code in the attached Zip file has...

    [NOTE: The code in the attached Zip file has errors. Hein.
    See: http://www.attunity.com/forums/application-data-access-using-c-cobol/3gl-api-returning-invalid-binary-response-2850.html]

    We have...
  24. Yes - at least to object that are synonyms for...

    Yes - at least to object that are synonyms for tables in other data sources.
  25. Steven, I do not want to argue with what you...

    Steven,

    I do not want to argue with what you see - I believe that in your particular setting, you have seen that adding "Log on as Batch Job" privilege helped you resolve the log-in issue you had....
Results 1 to 25 of 233
Page 1 of 10 1 2 3 4