Connect for Big Data
Documentation
Articles
Exporting Parquet files in Connect ETL
Running I/O Benchmark Tests for Connect ETL Performance Validation
Can I perform upsert from Databricks to DB2 in Connect for Big Data?
Databricks job failing with HDFSCNNF error in Connect for Big Data
Error "Connect Job: (HNODITSR) no distributed sources were found in the job" in Connect for Big data
Resolving S222 ABEND and MFJXE00 Errors when running DMXMFSRT in Micro Focus Enterprise Server - Connect ETL
'No suitable driver found' message for Databricks jdbc connection in Connect ETL
Avoiding "SLF4J: Failed to load class" message during the job execution in Connect ETL
Error password authentication failed for user "<user>" during psql load to postgres with Connect ETL
'KEYINST: (READERR) Unable to install License Key' message in Connect ETL
Windows Server 2022 support with Connect ETL
Memory exhaustion caused by ulimit settings in Connect ETL
Hive target error relating to transactions/locking in Connect for Big data
DFNF error accessing files in HDFS encryption zone using Connect for Big Data
Legacy SyncSort syntax vs. GUI development vs. DTL
Connect for Bigdata job aborts
"CFCNTLSDIR" or "FUNCNOTFOUND" error when using custom functions in cluster mode in Connect ETL (Big Data)
Enabling JDBC driver tracing in Connect for Big data
Setting up SFTP Remote File Connections using Public Key Authentication in Connect ETL
Unable to read ODBC configuration from /etc/odbc.ini or install directory in Connect ETL
Kafka connection fails with java.lang.OutOfMemoryError: Java heap space in DMX Change Data Capture
SRVAUTHFAIL Connecting to Local DMExpress Server on Windows
THREADCREATIONERROR / JNOTHRD error cannot create a thread
"[unexpected condition] occurred in file ODBCSqlServerBulkCopyWriteSqlStatement.cpp" message in Connect ETL
"Unable to send userauth-publickey request" message in Connect ETL
"CONN_CREATE_AUTHENTICATION_TRANSPORT_ERROR" message when connecting to Hive via JDBC using ZooKeeper in Connect ETL
Installation error: Unable to load the license DLL dmxlicense.dll in Connect ETL
Incorrect output of aggregation without reformat in distributed mode in Connect for Big Data
BIT Columns from SQL Server Cause Conversion Issues in DataFunnel using Connect ETL
Resolving the DMExpress Library Not Found Error
(KEYTYPE) the license key file contains invalid key information
Comparison of externally managed and Connect ETL managed Kerberos Authentication
"User <username> doesn't have permission to call 'getServiceState'" in Connect ETL
Amazon S3 connection error: Failed to load "SSAmazonS3Driver_32" library in Connect ETL
Using custom SSL/TLS certificates with Connect - Resolving HTTPSCVF
DMXODBCDRIVERMANAGER setting in the odbcinst.ini file
Handling LargeObject (LOB) data
Kerberos error: Unable to obtain password from user
Unexpected sort order when using DMXMMSRT in Connect ETL
App Mod Syntax Errors and Unsupported Features
Hive target table disposition required to be ACID in Connect for Big Data
AWS IAM Role Authentication for Amazon S3 Remote File Sources and Targets in Connect ETL
Exporting Parquet files in Connect ETL
Running I/O Benchmark Tests for Connect ETL Performance Validation
Can I perform upsert from Databricks to DB2 in Connect for Big Data?
Databricks job failing with HDFSCNNF error in Connect for Big Data
Error "Connect Job: (HNODITSR) no distributed sources were found in the job" in Connect for Big data
Resolving S222 ABEND and MFJXE00 Errors when running DMXMFSRT in Micro Focus Enterprise Server - Connect ETL
'No suitable driver found' message for Databricks jdbc connection in Connect ETL
Avoiding "SLF4J: Failed to load class" message during the job execution in Connect ETL
Error password authentication failed for user "<user>" during psql load to postgres with Connect ETL
'KEYINST: (READERR) Unable to install License Key' message in Connect ETL
Windows Server 2022 support with Connect ETL
Understanding ODBC connection requirements with Databases in Connect ETL
'invalid byte sequence for encoding "UTF8"' message in Connect ETL
Task crashes with input source files greater than 32768 in Connect ETL
Amazon RDS support in Connect ETL/for Big Data
Connect: Databricks - workDirectory vs. WORKTABLEDIRECTORY
Connect ETL (DMX) - Log4J - CVE-2021-44228, CVE-2021-45046, CVE-2021-45105
Memory exhaustion caused by ulimit settings in Connect ETL
Hive target error relating to transactions/locking in Connect for Big data
DFNF error accessing files in HDFS encryption zone using Connect for Big Data
Hive/Impala writes with Snappy work table codec fail with NoSuchMethodError in Connect for BigData
Connect: (HDPRXYSE) unable to start the Hadoop proxy
Connect: Parquet target write fails with OutOfMemoryError: Java heap space
Task connecting to Hive via JDBC hangs during validation in Connect for Big Data
(KILLED) the process has been terminated with the kill command
Accessing Data in Excel Spreadsheets
Legacy SyncSort syntax vs. GUI development vs. DTL
Connect for Bigdata job aborts
"CFCNTLSDIR" or "FUNCNOTFOUND" error when using custom functions in cluster mode in Connect ETL (Big Data)
Hive target generates multiple part files on HDFS in Connect for Big Data
Retrieving YARN logs for Connect for Big data Jobs using Spark or MapReduce Frameworks
Connect: Windows system hangs for up to 15 minutes during product installation
Kerberos: Fail to create credential. (63) - No service creds
HCatalog-related errors with Hive sources/targets in distributed mode in Connect for Big Data
Text/grid display issues with display scaling on high-resolution monitors
Enabling JDBC driver tracing in Connect for Big data
Setting up SFTP Remote File Connections using Public Key Authentication in Connect ETL
Unable to read ODBC configuration from /etc/odbc.ini or install directory in Connect ETL
Connect: The application has failed to start because its side-by-side configuration is incorrect.
About Hive HA - ZooKeeper service discovery and high availability
Kerberos: Cannot find KDC for requested realm
HIVEWERR, Permission denied when writing to Hive
GSS initiate failed
"Could not open client transport with JDBC Uri" message in Connect ETL
Kafka connection fails with java.lang.OutOfMemoryError: Java heap space in DMX Change Data Capture
SRVAUTHFAIL Connecting to Local DMExpress Server on Windows
THREADCREATIONERROR / JNOTHRD error cannot create a thread
"[unexpected condition] occurred in file ODBCSqlServerBulkCopyWriteSqlStatement.cpp" message in Connect ETL
"Unable to send userauth-publickey request" message in Connect ETL
"CONN_CREATE_AUTHENTICATION_TRANSPORT_ERROR" message when connecting to Hive via JDBC using ZooKeeper in Connect ETL
Handling EBCDIC data with DMXMMSRT in Connect ETL
You are not licensed to use this ODBC driver with the DataDirect ODBC Driver Manager under the license you have purchased
Differences between SyncSort and Connect ETL(DMX)
Installation error: Unable to load the license DLL dmxlicense.dll in Connect ETL
Incorrect output of aggregation without reformat in distributed mode in Connect for Big Data
BIT Columns from SQL Server Cause Conversion Issues in DataFunnel using Connect ETL
Unable to obtain Principal Name for authentication
"Failed to construct kafka consumer - DNS resolution failed for url in bootstrap.servers: <broker host>:9092" message in Connect ETL
Resolving the DBCNNTES/FLLDALIB Errors
Applying a new license key to an existing installation
Running mainframe SORT JCL with Connect ETL
User-defined SQL statement not available as lookup source in Connect ETL
Resolving the DMExpress Library Not Found Error
(KEYTYPE) the license key file contains invalid key information
Comparison of externally managed and Connect ETL managed Kerberos Authentication
TERMMISSING, RTRNC, RTRNCOUT, and output cut off after X number of records
Installing multiple DMX-h versions side-by-side on CDH/CDP
(CLOSE) unable to close error with FTP source file
Kerberos: no supported default etypes for default_tkt_enctypes
Connect: Configuring SQL Server or ODBC Connectivity on 64-bit Windows
Changing the Secure FTP port used by DMX
"User <username> doesn't have permission to call 'getServiceState'" in Connect ETL
Amazon S3 connection error: Failed to load "SSAmazonS3Driver_32" library in Connect ETL
Using custom SSL/TLS certificates with Connect - Resolving HTTPSCVF
DMX Install Guide 9.8
"DMX_JDBC_INI_FILE is not set" message in Connect ETL
"(PIMAOR) the record length value is out of range" message in Connect ETL
Importing DTL Files with or without Resolving Environment Variables in Connect ETL
"[FCRFMNVL] layout type of layout does not match file type of target" message in Connect ETL
`GLIBCXX_N.N.NN' not found after fresh Connect install on Linux
DMXODBCDRIVERMANAGER setting in the odbcinst.ini file
Handling LargeObject (LOB) data
Kerberos error: Unable to obtain password from user
CVROP error due to incorrect copybook type for EBCDIC trailing sign data in Connect ETL
Kafka design-time connection fails with UnsupportedClassVersionError in Connect for Big Data
Table list empty or missing table when using Excel connection in Connect ETL
(HNODITSR) no distributed sources were found in the job in Connect for Big Data
CREAT or HIVEWERR on HDP clusters with HDFS/Hive targets in MapReduce
Connect ETL(DMX) uninstaller missing or failing to launch
Unexpected sort order when using DMXMMSRT in Connect ETL
App Mod Syntax Errors and Unsupported Features
Hive target table disposition required to be ACID in Connect for Big Data
Segmentation fault or internal error (INERR 11) in SSTRPHDL with Database Lookups in Connect ETL
"RECTRNIN" or "VALTRNIN" message when inserting records into target table in Connect ETL
Unknown authentication error when connecting to DMX service
Connect ETL installation aborts with error "Permission denied" on RHEL 7
LIBHDFSE error - Cannot allocate memory
Unable to connect to a remote DMX server
Error receiving response from manager message in Connect ETL while using java connector
Debugging a Connect ETL job with Windows Process Monitor (ProcMon)
Capturing completion status of a Connect ETL job or task
Kafka design-time connection fails with UnsupportedClassVersionError in Connect for Big Data
(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
Duplicate records output from aggregate without overflow in Connect ETL
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
"LOBSQLRI" message when extracting LargeObject columns using user-defined SQL in Connect ETL
"Permission denied" error on running MapReduce job in Connect ETL (Big Data)
"Error 1067: The process terminated unexpectedly" when starting Connect ETL DMXManager service on Windows
"RECTRNIN" or "VALTRNIN" message when inserting records into target table in Connect ETL
"Server version error" message when using Simba Hive JDBC driver in Connect ETL (Big Data)
"CFCNTLSDIR" or "FUNCNOTFOUND" error when using custom functions in cluster mode in Connect ETL (Big Data)
MapReduce or Spark job produces empty output when Hive JDBC source table is empty in Connect ETL (Big Data)
Assigning a deafult value in a lookup function if lookup function does not find a match in Connect ETL
Table list empty or missing table when using Excel connection in Connect ETL
Task crashes with no error when using complex regular expression in Connect ETL
System message: "A new license key cannot be applied while DMExpress is running" using Connect ETL
Error password authentication failed for user "<user>" during psql load to postgres with Connect ETL
AWS IAM role authentication for Amazon S3 remote file sources and targets in Connect ETL
Converting a date, time, or timestamp format in Connect ETL
"Failed to construct kafka consumer - DNS resolution failed for url in bootstrap.servers: <broker host>:9092" message in Connect ETL
"CONN_CREATE_AUTHENTICATION_TRANSPORT_ERROR" message when connecting to Hive via JDBC using ZooKeeper in Connect ETL
DTL script fails with DFNF error on using wildcard input file in Connect ETL
Hive/Impala writes with Snappy work table codec fail with NoSuchMethodError in Connect for BigData
JCL hex values in DMXMMSRT (Connect ETL) incorrectly interpreted with ASCII data
Join application fails with (NOSIN), (NOSOUT), and (MFFALLBK) errors in DMXMFSRT (Connect ETL)
Permission denied error on creating Tableau TDE file in Connect ETL
Task crashes with input source files greater than 32768 in Connect ETL
Enabling DataFunnel Trace Logging in Connect ETL
"Could not open client transport with JDBC Uri" message in Connect ETL
Incorrect data output due to endian mismatch when processing big-endian data on little-endian platforms in Connect ETL
'invalid byte sequence for encoding "UTF8"' message in Connect ETL
"[unexpected condition] occurred in file ODBCSqlServerBulkCopyWriteSqlStatement.cpp" message in Connect ETL
“RECVALIV” and “FLDVALIV” messages in Connect ETL
Oracle error ORA-28714 or ORA-03137 with user-defined SQL in Connect for Big Data
Understanding ODBC connection requirements with Databases in Connect ETL
Unable to read ODBC configuration from /etc/odbc.ini or install directory in Connect ETL
BIT Columns from SQL Server Cause Conversion Issues in DataFunnel using Connect ETL
RECTRNC/RTRNC with Hadoop distributable record formats in Connect for BigData
[TBLORCOL / GCAPIERR / GCMSG / 500168] Intermittent JDBC Kerberos authentication errors in Connect for Big Data with Hive target
Debugging Performance Issues in Connect ETL
Changing the number of mappers and reducers for DMX-h jobs and TSQBD projects
Retrieving YARN logs for Connect for Big data Jobs using Spark or MapReduce Frameworks
Oracle database not appearing in drop-down box in Connect ETL
Connect ETL installation aborts with error "Permission denied" on RHEL 7
Error receiving response from manager message in Connect ETL while using java connector
Debugging a Connect ETL job with Windows Process Monitor (ProcMon)
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
Task connecting to Hive via JDBC hangs during validation in Connect for Big Data
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
Source SQL parameterization fails when referencing DMX fields or expressions in Connect ETL
Kafka design-time connection fails with UnsupportedClassVersionError in Connect for Big Data
(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
Duplicate records output from aggregate without overflow in Connect ETL
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
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
"LOBSQLRI" message when extracting LargeObject columns using user-defined SQL in Connect ETL
"Permission denied" error on running MapReduce job in Connect ETL (Big Data)
"Error 1067: The process terminated unexpectedly" when starting Connect ETL DMXManager service on Windows
"RECTRNIN" or "VALTRNIN" message when inserting records into target table in Connect ETL
"Server version error" message when using Simba Hive JDBC driver in Connect ETL (Big Data)
"CFCNTLSDIR" or "FUNCNOTFOUND" error when using custom functions in cluster mode in Connect ETL (Big Data)
MapReduce or Spark job produces empty output when Hive JDBC source table is empty in Connect ETL (Big Data)
Assigning a deafult value in a lookup function if lookup function does not find a match in Connect ETL
Table list empty or missing table when using Excel connection in Connect ETL
Task crashes with no error when using complex regular expression in Connect ETL
System message: "A new license key cannot be applied while DMExpress is running" using Connect ETL
Error password authentication failed for user "<user>" during psql load to postgres with Connect ETL
Compression options in MapReduce in Connect for Big Data
Databricks job failing with HDFSCNNF error in Connect for Big Data
Connect for Bigdata job aborts
Amazon S3 connection error: Failed to load "SSAmazonS3Driver_32" library in Connect ETL
DFNF error accessing files in HDFS encryption zone using Connect for Big Data
"User <username> doesn't have permission to call 'getServiceState'" in Connect ETL
AWS IAM role authentication for Amazon S3 remote file sources and targets in Connect ETL
Converting a date, time, or timestamp format in Connect ETL
"Failed to construct kafka consumer - DNS resolution failed for url in bootstrap.servers: <broker host>:9092" message in Connect ETL
"CONN_CREATE_AUTHENTICATION_TRANSPORT_ERROR" message when connecting to Hive via JDBC using ZooKeeper in Connect ETL
DTL script fails with DFNF error on using wildcard input file in Connect ETL
Hive/Impala writes with Snappy work table codec fail with NoSuchMethodError in Connect for BigData
Error DMExpress Job : (OPTKYEXP) option keyword expected in Connect ETL
"Unable to send userauth-publickey request" message in Connect ETL
Setting up SFTP Remote File Connections using Public Key Authentication in Connect ETL
JCL hex values in DMXMMSRT (Connect ETL) incorrectly interpreted with ASCII data
Join application fails with (NOSIN), (NOSOUT), and (MFFALLBK) errors in DMXMFSRT (Connect ETL)
Permission denied error on creating Tableau TDE file in Connect ETL
Task crashes with input source files greater than 32768 in Connect ETL
Enabling DataFunnel Trace Logging in Connect ETL
"Could not open client transport with JDBC Uri" message in Connect ETL
Incorrect data output due to endian mismatch when processing big-endian data on little-endian platforms in Connect ETL
'invalid byte sequence for encoding "UTF8"' message in Connect ETL
"[unexpected condition] occurred in file ODBCSqlServerBulkCopyWriteSqlStatement.cpp" message in Connect ETL
“RECVALIV” and “FLDVALIV” messages in Connect ETL
Oracle error ORA-28714 or ORA-03137 with user-defined SQL in Connect for Big Data
Understanding ODBC connection requirements with Databases in Connect ETL
Oracle not available as DBMS type in the task editor in Connect ETL
Configuring WORKTABLEDIRECTORY for a local staging file instead of an S3 bucket for Snowflake in Connect ETL
Proxy behavior troubleshooting for S3 and Salesforce connections in Connect ETL
Connect ETL tasks that connect to S3 or Salesforce fail with HTTP/SSL-related errors.
CVROP error due to incorrect copybook type for EBCDIC trailing sign data in Connect ETL
"[FCRFMNVL] layout type of layout does not match file type of target" message in Connect ETL
Unable to read ODBC configuration from /etc/odbc.ini or install directory in Connect ETL
BIT Columns from SQL Server Cause Conversion Issues in DataFunnel using Connect ETL
RECTRNC/RTRNC with Hadoop distributable record formats in Connect for BigData
Using environment variables in Connect ETL as values and condition expressions
Unexpected sort order when using DMXMMSRT in Connect ETL
Running mainframe SORT JCL with Connect ETL
Error: (NTSUC) an attempted I/O on file was not successful in Connect ETL
HCatalog-related errors with Hive sources/targets in distributed mode in Connect for Big Data
[JAVADRIVERMANAGERINTERNAL] and [JDBC] connector errors with hive connections in Connect for Bigdata
[TBLORCOL / GCAPIERR / GCMSG / 500168] Intermittent JDBC Kerberos authentication errors in Connect for Big Data with Hive target
Debugging Performance Issues in Connect ETL
Changing the number of mappers and reducers for DMX-h jobs and TSQBD projects
TERMMISSING, RTRNC, RTRNCOUT, and output cut off after X number of records
cp: cannot stat "<installer directory>/.setup": No such file or directory
Error in pre-sorted join: (EWRIT) unable to write to file "following task" () Broken pipe in Connect ETL
Avoiding "SLF4J: Failed to load class" message during the job execution in Connect ETL
Legacy SyncSort syntax vs. GUI development vs. DTL
Support for explicit and implicit FTPS in Connect ETL
Retrieving YARN logs for Connect for Big data Jobs using Spark or MapReduce Frameworks
Oracle database not appearing in drop-down box in Connect ETL
Connect ETL installation aborts with error "Permission denied" on RHEL 7
Handling EBCDIC data with DMXMMSRT in Connect ETL
Overview of Connect ETL services/daemons
Using Kafka Schema Registry in Connect
DMXMFSRT ZD output is incompatible with MFJSORT when input dataset is EBCDIC encoded in Connect ETL
Memory exhaustion caused by ulimit settings in Connect ETL
DataFunnel job fails with java.lang.IllegalStateException: null 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
"Peer indicated failure: Unsupported mechanism type PLAIN" message in Connect ETL
Failed to construct kafka consumer - No resolvable bootstrap urls
Connect (DMX) Implementation Best Practices
Debugging a hang on Linux/UNIX
Considerations for upgrading or downgrading DMX
Unable to connect to a remote DMX server
`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
Connect: Configuring SQL Server or ODBC Connectivity on 64-bit Windows
DMX Install Guide 9.8
Connect: The application has failed to start because its side-by-side configuration is incorrect.
Numbers in ODBC error messages in DMExpress logs
(KILLED) the process has been terminated with the kill command
What is the DMX repository?
THREADCREATIONERROR / JNOTHRD error cannot create a thread
Connect ETL(DMX) uninstaller missing or failing to launch
Cannot set registry values / Unable to launch vcredist
cp: cannot stat "<installer directory>/.setup": No such file or directory
Hive target error relating to transactions/locking in Connect for Big data
Unexpected LargeObject in PostgreSQL, Redshift, and compatible databases
Retrieving YARN logs for Connect for Big data Jobs using Spark or MapReduce Frameworks
HIVEWERR, Permission denied when writing to Hive
Using Kafka Schema Registry in Connect
Debugging a Connect ETL job with Windows Process Monitor (ProcMon)
DBIOCDFM performance warning with Oracle NUMBER columns
Differences between SyncSort and Connect ETL(DMX)
HDPRXYSE/HDPRXYTO errors: attempt to initialize Hadoop proxy timed out
ODBC Data Source Name Not Found on Windows
Oracle error ORA-28714 or ORA-03137 with user-defined SQL in Connect for Big Data
HDFSCNNF/HDFSNNNF errors: unable to retrieve the host name of your Hadoop namenode
Kafka connection fails with java.lang.OutOfMemoryError: Java heap space in DMX Change Data Capture
DMXMFSRT ZD output is incompatible with MFJSORT when input dataset is EBCDIC encoded in Connect ETL
Changing the Secure FTP port used by DMX
(KEYTYPE) the license key file contains invalid key information
Management service dmxmgr fails to start: Unable to insert row for version '1.6' in Schema History table "PUBLIC"."schema_version"
(HNODITSR) no distributed sources were found in the job in Connect for Big Data
JCL hex values in DMXMMSRT (Connect ETL) incorrectly interpreted with ASCII data
Management service dmxmgr fails to start in RPM, Cloudera parcel, or Ambari package-based install: Unable to open nested entry
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
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
Connect ETL (DMX) - Log4J - CVE-2021-44228, CVE-2021-45046, CVE-2021-45105
"Peer indicated failure: Unsupported mechanism type PLAIN" message in Connect ETL
Failed to construct kafka consumer - No resolvable bootstrap urls
Connect (DMX) Implementation Best Practices
Applying a new license key to an existing installation
Kerberos: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)
GSS initiate failed
Data sources list must not be null
Unknown error 255 with Hadoop files
libjvm.so or jvm.dll not found
Debugging a hang on Linux/UNIX
Considerations for upgrading or downgrading DMX
Unable to connect to a remote DMX server
DMX Release Notes 9.9.10
Debugging Performance Issues in Connect ETL
SFTP error: password authentication is not supported by the server (SSHDNAPS)
Resolving the ODBC DSN Architecture Mismatch Error
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
Transferring Connect (DMX) job and task files across servers
Using custom SSL/TLS certificates with Connect - Resolving HTTPSCVF
Memory exhaustion caused by ulimit settings in Connect ETL
Resolving the DBCNNTES/FLLDALIB Errors
Fixing DMX SSL errors: PKIX path building failed, SSL handshake failed
Hive error: Unable to create staging table, User does not have privileges for CREATETABLE
Connect: Configuring SQL Server or ODBC Connectivity on 64-bit Windows
DMX Install Guide 9.8
Connect: The application has failed to start because its side-by-side configuration is incorrect.
New parcel not showing up in parcel list on Cloudera Manager
SRVAUTHFAIL to PAM enabled DMX service on Linux / Unix
"Extraction or execution of getsysinfo failed" message on running licenseinfo.sh in Connect ETL on Linux
About Hive HA - ZooKeeper service discovery and high availability
Running I/O Benchmark Tests
App Mod Syntax Errors and Unsupported Features
Numbers in ODBC error messages in DMExpress logs
(KILLED) the process has been terminated with the kill command
What is the DMX repository?
You are not licensed to use this ODBC driver with the DataDirect ODBC Driver Manager under the license you have purchased
ODBC Error - You are not licensed to use this product with any application other than DMExpress
Accessing Data in Excel Spreadsheets
Unable to start the manager
Legacy SyncSort syntax vs. GUI development vs. DTL
DMX-h License Package Migration Guide
THREADCREATIONERROR / JNOTHRD error cannot create a thread
Connect ETL(DMX) uninstaller missing or failing to launch
Cannot set registry values / Unable to launch vcredist
CREAT or HIVEWERR on HDP clusters with HDFS/Hive targets in MapReduce
SRVAUTHFAIL Connecting to Local DMExpress Server on Windows
INVNODE license error
Installing multiple DMX-h versions side-by-side on CDH/CDP
Checking whether a license key was successfully applied in Connect ETL
Configuring WORKTABLEDIRECTORY for a local staging file instead of an S3 bucket for Snowflake in Connect ETL
cp: cannot stat "<installer directory>/.setup": No such file or directory
Hive target error relating to transactions/locking in Connect for Big data
Unexpected LargeObject in PostgreSQL, Redshift, and compatible databases
How to check that the bit level of Java and DMExpress match
Handling LargeObject (LOB) data
Amazon RDS support in Connect ETL/for Big Data
"Could not open client transport with JDBC Uri" message in Connect ETL
File jdbc-config.ini was not found
Unknown authentication error when connecting to DMX service
Retrieving YARN logs for Connect for Big data Jobs using Spark or MapReduce Frameworks
HIVEWERR, Permission denied when writing to Hive
Using Kafka Schema Registry in Connect
DMXODBCDRIVERMANAGER setting in the odbcinst.ini file
(CLOSE) unable to close error with FTP source file
(INVPLATFORM) the license key type is not valid for the current platform
Where are Connect Portal (Management Server) logs located?
QEWSD in odbc.ini file
Setting up SFTP Remote File Connections using Public Key Authentication in Connect ETL
Debugging a Connect ETL job with Windows Process Monitor (ProcMon)
DBIOCDFM performance warning with Oracle NUMBER columns
Differences between SyncSort and Connect ETL(DMX)
HDPRXYSE/HDPRXYTO errors: attempt to initialize Hadoop proxy timed out
ODBC Data Source Name Not Found on Windows
Oracle error ORA-28714 or ORA-03137 with user-defined SQL in Connect for Big Data
HDFSCNNF/HDFSNNNF errors: unable to retrieve the host name of your Hadoop namenode
Kafka connection fails with java.lang.OutOfMemoryError: Java heap space in DMX Change Data Capture
DMXMFSRT ZD output is incompatible with MFJSORT when input dataset is EBCDIC encoded in Connect ETL
Changing the Secure FTP port used by DMX
(KEYTYPE) the license key file contains invalid key information
Management service dmxmgr fails to start: Unable to insert row for version '1.6' in Schema History table "PUBLIC"."schema_version"
(HNODITSR) no distributed sources were found in the job in Connect for Big Data
JCL hex values in DMXMMSRT (Connect ETL) incorrectly interpreted with ASCII data
Management service dmxmgr fails to start in RPM, Cloudera parcel, or Ambari package-based install: Unable to open nested entry
Handling EBCDIC data with DMXMMSRT in Connect ETL
Capturing completion status of a Connect ETL job or task
Resolving the SRVAUTHFAIL Error
Downloads
Connect for Big Data 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 for Big Data offers self-service Emergency keys within License Keys for user accounts with active entitlements:
- Go to License Keys.
- Click on the "Emergency Key" link next to your product. Product naming conventions may slightly differ and other products may also display. Note that you may need to switch the Support Site dropdown above the table if you have multiple contracts.
- Follow the instructions on the "Emergency Key" page to create and download your key.
