Connect CDC (formerly SQData)
Documentation
Articles
SQDIMSU Utility Support Predicates or WHERE Clauses for Data Filtering in Connect CDC(SQDATA)
Refresh Requests Lost on restarting DB2 Publisher after crash in Connect CDC(SQDATA)
Task connecting to Hive via JDBC hangs during validation in Connect for Big Data
(KILLED) the process has been terminated with the kill command
MonCon commands are timing out even though kernel is running
Can a GMT timestamp be converted to a local timestamp?
FTP error on performing a commit in Connect CDC
(S3IM) - Amazon S3 - SignatureDoesNotMatch error in a Connect ETL job
Understanding enable capture and disable capture in Connect CDC
What are the most common logs to analyze for Replicate1/DTShare, specifically when working with support on an Incident?
Double-Take Share v5.0 - System Reference Guide
Encountered a log count mismatch error / Internal error, log row count does not match tran group
Journaling on AS/400 replication tables and the source AS/400 metabase tables must be set to journaling *BOTH:
What causes the error message "Memory allocation failure in rp_db_info_init_cursors"?
Data not deleting from the queue and request failing: ERROR:[OM:02923] Too many errors in too short a time.
Change Selector does not restart from desired receiver or sequence number in Connect CDC
Error: "Message: String or binary data would be truncated." in Connect CDC
How to manually disable capture for SQL Server in Connect CDC
Change Selector fails with "Service program LVSRV01 not found" message on IBM i using Connect CDC
Double-Take Share v5.3 IBM i Installation Guide
What authorization is needed for replication on OS 400?
What should I do with MIMIX replicate1 when I upgrade Oracle from 9.1 to 9.2?
Double-Take Share v5.0 - User Guide Migrator
Kerberos: Fail to create credential. (63) - No service creds
Creating joblog for IBM i Change Selector
HCatalog-related errors with Hive sources/targets in distributed mode in Connect for Big Data
What is the proper procedure to upgrade the metabase after installing a new release of Connect CDC?
How are uniqueidentifier columns mapped with the product?
What are the characteristics of a distribution key (DKEY) column?
IFS Entries and Wild Card/generic values
Unable to read ODBC configuration from /etc/odbc.ini or install directory in Connect ETL
Connect CDC: Unexpected restart of change selector after using ENDJOB command on IBM i
How do I install the DB2/400 change selector into the installation library?
About Hive HA - ZooKeeper service discovery and high availability
Double-Take Share / Replicate1 v4.0.8.2 - System Reference Guide
HIVEWERR, Permission denied when writing to Hive
Technical Alert: TA_DTSH51_102 Double-Take Share may not correctly handle data replication during the Daylight Savings Time Change
[Error:18488] [State:S0001] Message: Login failed for user 'rpuser'.
Is the listener service supported and what authorization is needed, on Windows 7, 8, or 10 Operating Systems ?
"ERROR:[OM:06407] Too many rows" message after copy on running Sync request in Connect CDC
[Error:701] [State:42000] There is insufficient system memory to run this query in Connect CDC
CICS 6.2 Compatibility with Connect CDC(SQDATA)
SQDIMSU Utility Support Predicates or WHERE Clauses for Data Filtering in Connect CDC(SQDATA)
Refresh Requests Lost on restarting DB2 Publisher after crash in Connect CDC(SQDATA)
RHEL 8 support with Connect CDC(SQDATA) V4.x
Impact of struts-1.2.4.jar vulnerability in Connect CDC
TLS 1.3 support compatibility with Connect CDC(SQDATA)
"SQDV001E Fatal VFILE error occurred" message in Connect CDC (SQDATA)
"errno:12 (Cannot allocate memory)” message in Connect CDC (SQDATA)
Connect CDC (SQData) - Excessive Message Size when connecting to new Kafka broker
Task connecting to Hive via JDBC hangs during validation in Connect for Big Data
(KILLED) the process has been terminated with the kill command
MonCon commands are timing out even though kernel is running
How to view/copy Change Selector logs from IBM i
"Error writing config file for process" message in Connect CDC
Double-Take Share v5.1 Advanced User Guide
How can I ensure that the Listener starts in the OMNIREP subsystem?
Changing default log file path of different components in Connect CDC
Accessing Data in Excel Spreadsheets
Can a GMT timestamp be converted to a local timestamp?
FTP error on performing a commit in Connect CDC
(S3IM) - Amazon S3 - SignatureDoesNotMatch error in a Connect ETL job
Sync request started in copy: By-pass copy and start in replication
Is it possible to output the MIMIX Share Model configuration to print?
MonCon error java.net.ConnectException: Connection refused in Connect CDC
ERROR: Request timed out after 120 seconds
Double-Take Share v5.2 Installation Guide
Double-Take Share 5.2 SP01 IBM i Installation Guide
Understanding enable capture and disable capture in Connect CDC
What are the most common logs to analyze for Replicate1/DTShare, specifically when working with support on an Incident?
Double-Take Share v5.0 - System Reference Guide
Encountered a log count mismatch error / Internal error, log row count does not match tran group
Journaling on AS/400 replication tables and the source AS/400 metabase tables must be set to journaling *BOTH:
What causes the error message "Memory allocation failure in rp_db_info_init_cursors"?
Data not deleting from the queue and request failing: ERROR:[OM:02923] Too many errors in too short a time.
Change Selector does not restart from desired receiver or sequence number in Connect CDC
Error: "Message: String or binary data would be truncated." in Connect CDC
How to manually disable capture for SQL Server in Connect CDC
Change Selector fails with "Service program LVSRV01 not found" message on IBM i using Connect CDC
Double-Take Share v5.3 IBM i Installation Guide
Working with DataStage - Replicate1 v4.0.8. SP01
Legacy SyncSort syntax vs. GUI development vs. DTL
Accessing Azure Blob and ADLS Gen2 with Connect ETL
"CFCNTLSDIR" or "FUNCNOTFOUND" error when using custom functions in cluster mode in Connect ETL (Big Data)
How are tables journaled using the director?
Troubleshooting the Delete Receiver Exit Program (DRE)
What authorization is needed for replication on OS 400?
What should I do with MIMIX replicate1 when I upgrade Oracle from 9.1 to 9.2?
Double-Take Share v5.0 - User Guide Migrator
Retrieving YARN logs for Connect for Big data Jobs using Spark or MapReduce Frameworks
Hive target generates multiple part files on HDFS in Connect for Big Data
DMXMFSRT or DMXMFJCL crash through the Micro Focus framework in Connect ETL
Rows skipped by Gate Condition: Kernel log messages show rows sent and rows received will not be equal
MSG: 'Attempt to put the duplicate entry REQUEST-1 in the active requests persistent list.'
Double-Take Share 5.2 Release Notes
Kerberos: Fail to create credential. (63) - No service creds
Creating joblog for IBM i Change Selector
HCatalog-related errors with Hive sources/targets in distributed mode in Connect for Big Data
Validation message returned: <Database><version>) is not a supported version.
How does the product support Secure Socket Layer (SSL) encryption and/or authentication?
Text/grid display issues with display scaling on high-resolution monitors
Double-Take Share v5.0 - Advanced User Guide
Slow BCP Bulk Copy to SQL Server
(OM:05428) change selector did not start in 40 seconds
What is the proper procedure to upgrade the metabase after installing a new release of Connect CDC?
How are uniqueidentifier columns mapped with the product?
What are the characteristics of a distribution key (DKEY) column?
Setting up SFTP Remote File Connections using Public Key Authentication in Connect ETL
Enabling JDBC driver tracing in Connect for Big data
Double-Take Share / Replicate1 v4.0.8.2 - Advanced User Guide
Selective start does not move data, queue tables continue to fill in Connect CDC
Support for Oracle UTF-8 to DB2/400 and DB2/400 to Oracle UTF-8 replication in Connect CDC
Why doesn't my request stop at the scheduled time?
IFS Entries and Wild Card/generic values
Unable to read ODBC configuration from /etc/odbc.ini or install directory in Connect ETL
Connect CDC: Unexpected restart of change selector after using ENDJOB command on IBM i
CDB$ROOT access requirements for Oracle pluggable databases in Connect CDC
Double-Take Share 5.2 SP01 Getting Started
What is the recommended kernel memory size for Double-Take Share/Replicate1 installation?
MonCon does not open
MSG: '[Error:-204] [State:42704] Message: [SQL0204] OEQADBIFLD in InstallLib type *FILE not found.
Steps to commit/model update and then issue selective start.
How do I install the DB2/400 change selector into the installation library?
About Hive HA - ZooKeeper service discovery and high availability
Double-Take Share / Replicate1 v4.0.8.2 - System Reference Guide
How the Oracle source archive log path/destination is processed
Kerberos: Cannot find KDC for requested realm
Installation Guide - Replicate1 v4.0.8 SP01
MIMIX Share 5.4 System Reference Guide
Save-while-active ; Change Selector hung in CMTW (commit/wait) status
Double-Take Share / Replicate1 v4.0.8.2 - Getting Started Guide
HIVEWERR, Permission denied when writing to Hive
Technical Alert: TA_DTSH51_102 Double-Take Share may not correctly handle data replication during the Daylight Savings Time Change
[Error:18488] [State:S0001] Message: Login failed for user 'rpuser'.
Is the listener service supported and what authorization is needed, on Windows 7, 8, or 10 Operating Systems ?
"ERROR:[OM:06407] Too many rows" message after copy on running Sync request in Connect CDC
[Error:701] [State:42000] There is insufficient system memory to run this query in Connect CDC
If both MIMIX replicate1 and another application use the same OS/400-i5/OS journal, will the Journal Manager delete its receivers?
How is an existing model loaded into MonCon?
AUI (VSP) upgrade/maintenance impact on Connect CDC
Debugging error java.net.ConnectException during installation of Connect CDC on a Unix platform
Name of the UDB change selector log for Connect CDC
Error: "Amazon S3 path must include the bucket and the object name" in Connect ETL
Socket Error(s) on testing SMTP email notification in Connect CDC
Understanding the Queue Table Cleaner process work with MS SQL Server source in Connect CDC
"ERR: ALLOSTMT - invalid connection handle 1" message in Connect CDC
1886-S2-ERROR-The host (<hostname>) cannot access the XML files because it does not specify local access and there is no global access defined on the Model property sheet. during a model validation in Connect CDC
Understanding enable capture and disable capture in Connect CDC
Can records with rp_m_type = 6 be safely deleted from rp_log in Connect CDC?
Determining memory usage of the kernel in Connect CDC
Hive error: Unable to create staging table in Connect for Big Data
Kafka connection error: java.lang.NoClassDefFoundError: com/syncsort/dmx/kafka/error/SchemaNotFoundException in Connect CDC
Tables not visible in source target database table dialog in Connect ETL
Job fails due to invalid HIVE_HOME or HCAT_HOME settings in Connect for Big Data
Kafka UNKNOWN_TOPIC_OR_PARTITION error in Connect for Big Data and Connect CDC
Oracle login succeeds but Windows event log shows authentication errors in Connect ETL
Connect for Big Data Kafka topics missing from Source/Target Message Queue dialog
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption in Connect CDC
Debugging why Connect ETL using less memory than specified in task
Cluster jobs failing even after successful key application in Connect For Big Data
"sqlldr": error=2, A file or directory in the path name does not exist in Connect CDC
RSEOPEN "File exists" error with distributed jobs when using export layout at run-time in Connect for Big Data
XML source shows unsupported layout warning in Connect ETL
Listener service on the iSeries starts and immediately ends for Connect CDC
(S3IM) - Amazon S3 - SignatureDoesNotMatch error in a Connect ETL job
Capture stops / SQDF051W The table <table> is not configured to allow Data Capture error in Connect CDC for DB2 Z/OS
Hive Tez Vertex failure - HDFS file does not exist
Debugging a Connect ETL job with Windows Process Monitor (ProcMon)
Details on the SQL Server/SQL Azure Bulk Load Command used in Connect CDC
Capturing completion status of a Connect ETL job or task
Running a subset of records in a task in Connect ETL
PostgreSQL ODBC error - "undefined symbol: PQconnectdbParams" in Connect ETL
RP_LOGON metabase table in Connect CDC
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption [State:08S01] in Connect CDC
Task connecting to Hive via JDBC hangs during validation in Connect for Big Data
com.microsoft.sqlserver.jdbc.SQLServerDriver: [Error:0] [State:08S01] Message: The TCP/IP connection to the host <host>, port <DMBS_port> has failed in Connect CDC
Too many sql errors encountered while applying row in Connect CDC
Checking whether a license key was successfully applied in Connect ETL
(HNODITSR) no distributed sources were found in the job in Connect for Big Data
Kafka apply error: This server is not the leader for that topic-partition in Connect CDC
Source SQL parameterization fails when referencing DMX fields or expressions in Connect ETL
(ATLASERR) unable to publish lineage information into Apache Atlas using Connect for Big Data
Connect ETL JDBC connection fails with ClassLoader casting error on Java 9 or higher
Japanese characters appear corrupted (mojibake) in Connect ETL DataFunnel logs or Portal copy project logs
CDC apply to Hive target fails with NOT NULL constraint error during MERGE in Connect for Big Data tasks
Hive target table disposition required to be ACID in Connect for Big Data
Message: "Could not find or load main class java " in DataFunnel UI using Connect for Big Data
DataFunnel project execution fails with (EXINIDRT) job directory ownership error when dmxrund runs as root using Connect ETL
Segmentation fault or internal error (INERR 11) in SSTRPHDL with Database Lookups in Connect ETL
Comparison of externally managed and Connect ETL managed Kerberos Authentication
Kafka source task stops before reading full consumer batch size in Connect ETL
"TARNOSQL" message when using user-defined SQL with Hive target in Connect ETL for Big Data
DMXManager fails to start due to repository lock file error org.h2.jdbc.JdbcSQLException in Connect ETL
Job log from DataFunnel reports success even though tasks failed in Connect ETL
Change Selector Error: DATATYPE (DATALINK) UNKNOWN in Connect CDC
'Use autocommit' parameter in 'New SQL Window' of the director in Connect CDC
Error MCH6903 - The heap space has reached its maximum allowable size in RPCS400 job in Connect CDC
Incorrect output of aggregation without reformat in distributed mode in Connect for Big Data
User-defined SQL statement not available as lookup source in Connect ETL
Hive target generates multiple part files on HDFS in Connect for Big Data
0433:A column match failed to table name () column error during mapping creation in Connect CDC
Understanding the error conditions shown in the alerts notification email from Connect CDC
"LOBSQLRI" message when extracting LargeObject columns using user-defined SQL in Connect ETL
0433:A column match failed to table name () column error during mapping creation in Connect CDC
Understanding the error conditions shown in the alerts notification email from Connect CDC
"LOBSQLRI" message when extracting LargeObject columns using user-defined SQL in Connect ETL
Debugging error java.net.ConnectException during installation of Connect CDC on a Unix platform
Name of the UDB change selector log for Connect CDC
Error: "Amazon S3 path must include the bucket and the object name" in Connect ETL
Increasing Memory degrades Join performance in Connect ETL
Debugging error Hive SSL/TLS trust store file not found for Connect for Big Data
Promoting models from one environment to another using RSL in Connect CDC
Replication shutdown when archive log file becomes unavailable in Connect CDC
Handling variable-length mainframe data without RDWs in Connect ETL
Unable to start the kernel, memory is too large or too small error in Connect CDC
Socket Error(s) on testing SMTP email notification in Connect CDC
Understanding the Queue Table Cleaner process work with MS SQL Server source in Connect CDC
"ERR: ALLOSTMT - invalid connection handle 1" message in Connect CDC
1886-S2-ERROR-The host (<hostname>) cannot access the XML files because it does not specify local access and there is no global access defined on the Model property sheet. during a model validation in Connect CDC
Understanding enable capture and disable capture in Connect CDC
Can records with rp_m_type = 6 be safely deleted from rp_log in Connect CDC?
IBM i OS version 7.4 (V7R4) support with Connect CDC
Recovering the omni template jar file (omnitpl.jar) missing in Connect CDC
AUI (VSP) upgrade/maintenance impact on Connect CDC
Determining memory usage of the kernel in Connect CDC
Hive error: Unable to create staging table in Connect for Big Data
Kafka connection error: java.lang.NoClassDefFoundError: com/syncsort/dmx/kafka/error/SchemaNotFoundException in Connect CDC
"Error writing config file for process" message in Connect CDC
Changing default log file path of different components in Connect CDC
Error 'Cannot complete Windows installation Connect ETL already installed' during Connect ETL Install
'Timeout trying to start omnienterprise' message, unable to start kernel process in Connect CDC
Connection error with MongoDB source or target in Connect ETL
Re-reading consumed messages from a kafka topic in Connect ETL
Tables not visible in source target database table dialog in Connect ETL
Job fails due to invalid HIVE_HOME or HCAT_HOME settings in Connect for Big Data
Kafka UNKNOWN_TOPIC_OR_PARTITION error in Connect for Big Data and Connect CDC
Oracle login succeeds but Windows event log shows authentication errors in Connect ETL
Connect for Big Data Kafka topics missing from Source/Target Message Queue dialog
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption in Connect CDC
Connect ETL task with VSAM source hangs
Apply Key Error - license DLL is in use / DMExpress is running in Connect ETL
Debugging error-Cannot open input model: <path to rsm file> in Connect CDC
Debugging why Connect ETL using less memory than specified in task
Cluster jobs failing even after successful key application in Connect For Big Data
"sqlldr": error=2, A file or directory in the path name does not exist in Connect CDC
Replicating AS400 source tables without a primary key or unique index in Connect CDC
Kernels fail to start after Windows HA failover for Connect CDC
Change selector fail to start with Error SQLCODE=100 in Connect CDC
Debugging issue of data not being replicated to target table in Connect CDC
"An error was encountered while retrieving the list of jobs submitted to the server" in Connect ETL
(RTRNCOUT) error in tasks with mainframe fixed record formats in Connect ETL
RSEOPEN "File exists" error with distributed jobs when using export layout at run-time in Connect for Big Data
XML source shows unsupported layout warning in Connect ETL
Listener service on the iSeries starts and immediately ends for Connect CDC
Specifying an alternate location for the krb5.conf/krb5.ini file in Connect ETL
Specifying Kafka Schema Registry with SSL in Connect ETL
DMXMFSRT or DMXMFJCL crash through the Micro Focus framework in Connect ETL
Debugging a crash on Windows for a Connect ETL task or job
Accessing Azure Blob and ADLS Gen2 with Connect ETL
RECTRNEX / VALINVNC error for DB2 time data in Connect ETL
(S3IM) - Amazon S3 - SignatureDoesNotMatch error in a Connect ETL job
Capture stops / SQDF051W The table <table> is not configured to allow Data Capture error in Connect CDC for DB2 Z/OS
Hive Tez Vertex failure - HDFS file does not exist
Cannot Parameterize Table/Schema Name in DataFunnel
Microsoft Visual Studio C++ Redistributable Package was not installed message during Connect ETL install
Connect CDC listener services not started or stuck through the Windows Services
Listener service fails to start on iSeries with java.lang.NoClassDefFoundError for Connect CDC
Determining the cause of a SQL Server Bulk Copy failure in Connect CDC
Error receiving response from manager message in Connect ETL while using java connector
Debugging a Connect ETL job with Windows Process Monitor (ProcMon)
Details on the SQL Server/SQL Azure Bulk Load Command used in Connect CDC
Capturing completion status of a Connect ETL job or task
Running a subset of records in a task in Connect ETL
PostgreSQL ODBC error - "undefined symbol: PQconnectdbParams" in Connect ETL
RP_LOGON metabase table in Connect CDC
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption [State:08S01] in Connect CDC
Task connecting to Hive via JDBC hangs during validation in Connect for Big Data
com.microsoft.sqlserver.jdbc.SQLServerDriver: [Error:0] [State:08S01] Message: The TCP/IP connection to the host <host>, port <DMBS_port> has failed in Connect CDC
Too many sql errors encountered while applying row in Connect CDC
Checking whether a license key was successfully applied in Connect ETL
(HNODITSR) no distributed sources were found in the job in Connect for Big Data
Kafka apply error: This server is not the leader for that topic-partition in Connect CDC
Source SQL parameterization fails when referencing DMX fields or expressions in Connect ETL
(ATLASERR) unable to publish lineage information into Apache Atlas using Connect for Big Data
Connect ETL JDBC connection fails with ClassLoader casting error on Java 9 or higher
Japanese characters appear corrupted (mojibake) in Connect ETL DataFunnel logs or Portal copy project logs
CDC apply to Hive target fails with NOT NULL constraint error during MERGE in Connect for Big Data tasks
Hive target table disposition required to be ACID in Connect for Big Data
Message: "Could not find or load main class java " in DataFunnel UI using Connect for Big Data
DataFunnel project execution fails with (EXINIDRT) job directory ownership error when dmxrund runs as root using Connect ETL
Segmentation fault or internal error (INERR 11) in SSTRPHDL with Database Lookups in Connect ETL
Comparison of externally managed and Connect ETL managed Kerberos Authentication
Kafka source task stops before reading full consumer batch size in Connect ETL
"TARNOSQL" message when using user-defined SQL with Hive target in Connect ETL for Big Data
DMXManager fails to start due to repository lock file error org.h2.jdbc.JdbcSQLException in Connect ETL
Job log from DataFunnel reports success even though tasks failed in Connect ETL
Change Selector Error: DATATYPE (DATALINK) UNKNOWN in Connect CDC
'Use autocommit' parameter in 'New SQL Window' of the director in Connect CDC
Error MCH6903 - The heap space has reached its maximum allowable size in RPCS400 job in Connect CDC
Incorrect output of aggregation without reformat in distributed mode in Connect for Big Data
User-defined SQL statement not available as lookup source in Connect ETL
Hive target generates multiple part files on HDFS in Connect for Big Data
0433:A column match failed to table name () column error during mapping creation in Connect CDC
Understanding the error conditions shown in the alerts notification email from Connect CDC
"LOBSQLRI" message when extracting LargeObject columns using user-defined SQL in Connect ETL
Server not found in Kerberos database
SFTP connection error: SSH: Unable to exchange encryption keys
Kerberos: Fail to create credential. (63) - No service creds
How to: cold start the IBM i Change Selector in Connect CDC (formerly MIMIX Share)
How to cold start (change capture point) for Oracle log-based sources
"Peer indicated failure: Unsupported mechanism type PLAIN" message in Connect ETL
ERROR: [SQL0913] Row or object XXXX in P1FILES type *FILE in use.
Did You Know... Checking for recommended IBM i PTFs is easy with CHKIBMPTF?
How to: Change Hostname/Password in a Connect CDC model
How to find the journal sequence number from the transaction ID to cold start the Change Selector
SQL Server BCP Copy Connection Errors
Data sources list must not be null
Debugging a hang on Linux/UNIX
Component has run out of memory and will shut down
[OM:05438] Log name is null / [OM:05429] Unable to read log file / [OM:05417] Could not find redo log
Error submitting load job #3: java.io.IOException: Cannot run program "BCP": CreateProcess error=2, The system cannot find the file specified
How to add/change table structure of tables used for Replicate1/DT Share/Mimix Share
Starting the Connect CDC (Share) Console in Developer Mode
Resolving the ODBC DSN Architecture Mismatch Error
MonCon commands are timing out even though kernel is running
What does the Change Selector status of DRAINED indicate?
JAVA_HOME is not set
Unable to connect to the local DMX server
How many database connections are used for replication?
What causes message: The Receiver encountered an I/O error initializing the object input stream (reason=invalid stream header)
ERROR:I/O error reading request from client: null. ERROR:[OM:05012] Failed I/O : socket closed
Connect CDC: IBM i Change Selector fails to start due to orphan rp_log rows
"Pipe is full. Waiting for rows to drain." message in Connect CDC
"ERR This command requires the name of the model specified with the '--modelname' argument" message in Connect CDC
How to Execute Catalog Synchronization Report, Checking Difference Between System and Model Table Definitions
How to check replication performance and latency
How to avoid changes hitting the queue tables during the model update process for
Sync request started in copy: By-pass copy and start in replication
Rows skipped by Gate Condition: Kernel log messages show rows sent and rows received will not be equal
MIMIX Share 5.4 System Reference Guide
Resolving the DBCNNTES/FLLDALIB Errors
Change selector won't start: ERROR: Receiver could not be read or receiver and/or sequence number are invalid
Fixing DMX SSL errors: PKIX path building failed, SSL handshake failed
Unable to load model into moncon either newly or from cache. Process appears to hang and no errors are generated
Change selector won't start: ERROR: Receiver could not be read or receiver and/or sequence number are invalid
Fixing DMX SSL errors: PKIX path building failed, SSL handshake failed
Unable to load model into moncon either newly or from cache. Process appears to hang and no errors are generated
Server not found in Kerberos database
SFTP connection error: SSH: Unable to exchange encryption keys
Kerberos: Fail to create credential. (63) - No service creds
Kerberos error: Unable to obtain password from user
How to view/copy Change Selector logs from IBM i
Kerberos: no supported default etypes for default_tkt_enctypes
Kerberos: Cannot find KDC for requested realm
ODBC Data Source Name Not Found on Linux/UNIX
Unable to obtain Principal Name for authentication
How to: cold start the IBM i Change Selector in Connect CDC (formerly MIMIX Share)
How to cold start (change capture point) for Oracle log-based sources
"Peer indicated failure: Unsupported mechanism type PLAIN" message in Connect ETL
Failed to construct kafka consumer - No resolvable bootstrap urls
How the Oracle source archive log path/destination is processed
Deleting queue data manually from Oracle log-based source metabase in Connect CDC
Connect (DMX) Implementation Best Practices
Manually clear AS/400 source metabase queue tables and the order of deleting
Applying a new license key to an existing installation
ERROR: [SQL0913] Row or object XXXX in P1FILES type *FILE in use.
Did You Know... Checking for recommended IBM i PTFs is easy with CHKIBMPTF?
How to: Change Hostname/Password in a Connect CDC model
Kerberos: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)
GSS initiate failed
Troubleshooting the Delete Receiver Exit Program (DRE)
How to modify kernel memory settings manually
Understanding the Oracle rp_restart table and the current capture point
Damage on Physical Files (DB2 tables): [Error:-904] [State:57011] Message: [SQL0904] Resource limit exceeded.
How to find the journal sequence number from the transaction ID to cold start the Change Selector
SQL Server BCP Copy Connection Errors
Data sources list must not be null
Firewall port information for iSeries or AS/400
Connection problem from Unix to DB2/400: ERROR:[OM:08300] SqlModelCreator error connecting to database
Unknown error 255 with Hadoop files
libjvm.so or jvm.dll not found
Journal Receivers Not Eligible for Deletion
What can cause error SQL0204 (-204)?
Debugging a hang on Linux/UNIX
Component has run out of memory and will shut down
[OM:05438] Log name is null / [OM:05429] Unable to read log file / [OM:05417] Could not find redo log
How the Delete Receiver Exit (DRE) Program Works
How do I manually delete data in SQL Server source metabase queues?
Encountered a log count mismatch error / Internal error, log row count does not match tran group
Considerations for upgrading or downgrading DMX
Unable to connect to a remote DMX server
What is the best approach to drain queue tables?
Error submitting load job #3: java.io.IOException: Cannot run program "BCP": CreateProcess error=2, The system cannot find the file specified
How to add/change table structure of tables used for Replicate1/DT Share/Mimix Share
Starting the Connect CDC (Share) Console in Developer Mode
Debugging Performance Issues in Connect ETL
[Error:-99999] [State:08S01] Message: Communication link failure. (Connection was dropped unexpectedly)
Replication problems and data stuck in queue: Too many rows (2) updated for
MIMIX Share 5.4 Getting Started Guide
Can't stop IBM i Change Selector from MonCon
Duplicates/conflicts in RRN_FIELD_DATA and Change Selector shutdown due to REORG (RGZPFM)
Resolving the ODBC DSN Architecture Mismatch Error
MonCon commands are timing out even though kernel is running
What does the Change Selector status of DRAINED indicate?
How to force BCP load jobs to execute serially rather than in parallel
Bulk Copy to SQL Azure target fails due to hitting database resource limits
Error: "1205 [State:40001]" Deadlocked on Lock Resources with Another Process and has Been Chosen as the Deadlock Victim
LIBHDFSE error - Cannot allocate memory
Resolving the DMExpress Library Not Found Error
`GLIBCXX_N.N.NN' not found after fresh Connect install on Linux
JAVA_HOME is not set
Unable to connect to the local DMX server
How many database connections are used for replication?
Connect Error: Unable to resolve service name "XXXprod" in Connect CDC
CDC job has failed/stopped and when trying to start will continuously fail
MSG: [Error:1505] [State:S0001] message: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found
How do you query the DB2/400 metabase queue tables to check for data in the queue using SQL statements?
Slow BCP Bulk Copy to SQL Server
How do I determine capture status of tables?
What causes message: The Receiver encountered an I/O error initializing the object input stream (reason=invalid stream header)
ERROR:I/O error reading request from client: null. ERROR:[OM:05012] Failed I/O : socket closed
Connect CDC: IBM i Change Selector fails to start due to orphan rp_log rows
Removing a transaction from the AS/400 queue tables in Connect CDC
Double-Take Share v5.3 Getting Started
What is the difference between a warm start and cold start of the AS/400 change selector?
Using custom SSL/TLS certificates with Connect - Resolving HTTPSCVF
[SQL0227] FETCH not valid, cursor CRSR0002 in unknown position
How to modify kernel memory setting using the installer
"Pipe is full. Waiting for rows to drain." message in Connect CDC
"ERR This command requires the name of the model specified with the '--modelname' argument" message in Connect CDC
How to Execute Catalog Synchronization Report, Checking Difference Between System and Model Table Definitions
(OM:05428) change selector did not start in 40 seconds
[Error:3701] [State:S0007] Message: Cannot drop the index because it does not exist or you do not have permission.
Steps to commit/model update and then issue selective start.
Connect CDC and Connect Portal: Install DMX and Share components separately
Checking and deleting the orphan rows for DB2/400 source queue tables in Connect CDC
How do I install the MIMIX Share license file?
How to check replication performance and latency
How to avoid changes hitting the queue tables during the model update process for
Sync request started in copy: By-pass copy and start in replication
Rows skipped by Gate Condition: Kernel log messages show rows sent and rows received will not be equal
MIMIX Share 5.4 System Reference Guide
Resolving the DBCNNTES/FLLDALIB Errors
Change selector won't start: ERROR: Receiver could not be read or receiver and/or sequence number are invalid
Fixing DMX SSL errors: PKIX path building failed, SSL handshake failed
Unable to load model into moncon either newly or from cache. Process appears to hang and no errors are generated
Downloads
Connect CDC (formerly SQData) contains self-service downloads within Precisely Data Experience for user accounts with active entitlements:
For more details, please see the Precisely Data Experience user guide.
- Go to Precisely Data Experience.
- Select My Software Products. You may be prompted for a login if not already authenticated.
- Select on the product to download. Product naming conventions may slightly differ and other products may also display.
- Once within a product, the latest version will be displayed by default and older versions can be selected via the Release dropdown.
- Select any product file to download.
For more details, please see the Precisely Data Experience user guide.
Licenses
Connect CDC (formerly SQData) does not currently offer self-service license keys. Please raise a case via the Customer portal or Partner portal for Connect CDC (formerly SQData) license requests.
