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?
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
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
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
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.
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
Differences between SyncSort and Connect ETL(DMX)
Installation error: Unable to load the license DLL dmxlicense.dll in Connect ETL
BIT Columns from SQL Server Cause Conversion Issues in DataFunnel using Connect ETL
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
"(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
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
Where are Connect Portal (Management Server) logs located?
CDC Apply fails for case sensitive Snowflake target with lowercase column names in DMX Change Data Capture
Hive on Windows causes (ASSERT) internal error in SigmaActivity.cpp in Connect for BigData
Hive JDBC transport error with reason "null" in Connect for BigData
Using multiple record layouts for the same source file in Connect ETL
DMXMFSRT ZD output is incompatible with MFJSORT when input dataset is EBCDIC encoded in Connect ETL
SRVAUTHFAIL to PAM enabled DMX service on Linux / Unix
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?
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
'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
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
(KILLED) the process has been terminated with the kill command
Accessing Data in Excel Spreadsheets
Legacy SyncSort syntax vs. GUI development vs. DTL
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
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
BIT Columns from SQL Server Cause Conversion Issues in DataFunnel using Connect ETL
Unable to obtain Principal Name for authentication
Resolving the DBCNNTES/FLLDALIB Errors
Applying a new license key to an existing installation
Running mainframe SORT JCL with Connect ETL
Resolving the DMExpress Library Not Found Error
(KEYTYPE) the license key file contains invalid key information
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
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
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
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
Schema Registry: "Unrecognized SSL message, plaintext connection?" when Connecting to Kafka Schema Registry in Connect ETL
Unexpected LargeObject in PostgreSQL, Redshift, and compatible databases
Where are Connect Portal (Management Server) logs located?
CDC Apply fails for case sensitive Snowflake target with lowercase column names in DMX Change Data Capture
Hive on Windows causes (ASSERT) internal error in SigmaActivity.cpp in Connect for BigData
Server not found in Kerberos database
(INVPLATFORM) the license key type is not valid for the current platform
HDPRXYSE/HDPRXYTO errors: attempt to initialize Hadoop proxy timed out
Error DMExpress Job : (OPTKYEXP) option keyword expected in Connect ETL
Oracle error ORA-28714 or ORA-03137 with user-defined SQL in Connect for Big Data
Failed to construct kafka consumer - No resolvable bootstrap urls
Hive JDBC transport error with reason "null" in Connect for BigData
Using multiple record layouts for the same source file in Connect ETL
DMXMFSRT ZD output is incompatible with MFJSORT when input dataset is EBCDIC encoded in Connect ETL
Debugging a hang on Linux/UNIX
JCL hex values in DMXMMSRT (Connect ETL) incorrectly interpreted with ASCII data
ODBC Error - You are not licensed to use this product with any application other than DMExpress
Data sources list must not be null
Running I/O Benchmark Tests
SRVAUTHFAIL to PAM enabled DMX service on Linux / Unix
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
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
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.
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
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
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
Differences between SyncSort and Connect ETL(DMX)
Using multiple record layouts for the same source file in Connect ETL
"(PIMAOR) the record length value is out of range" message in Connect ETL
Resolving S222 ABEND and MFJXE00 Errors when running DMXMFSRT in Micro Focus Enterprise Server - Connect ETL
Hive on Windows causes (ASSERT) internal error in SigmaActivity.cpp in Connect for BigData
Hive JDBC transport error with reason "null" in Connect for BigData
Connecting to Oracle via JDBC through Connect ETL
Converting DateToString using custom functions in Connect ETL
Installation error: Unable to load the license DLL dmxlicense.dll in Connect ETL
Schema Registry: "Unrecognized SSL message, plaintext connection?" when Connecting to Kafka Schema Registry in Connect ETL
Kafka connection fails with java.lang.OutOfMemoryError: Java heap space in DMX Change Data Capture
Error: "(ASSERT) internal error (unexpected condition) occurred in file StageBuffer.cpp at 84" in Connect ETL
CDC Apply fails for case sensitive Snowflake target with lowercase column names in DMX Change Data Capture
Connect: Windows system hangs for up to 15 minutes during product installation
Connect: Parquet target write fails with OutOfMemoryError: Java heap space
Connect: The application has failed to start because its side-by-side configuration is incorrect.
Unable to connect to the local DMX server
GSS initiate failed
(KEYTYPE) the license key file contains invalid key information
Resolving the DBCNNTES/FLLDALIB Errors
Unable to connect to a remote DMX server
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
Fixing DMX SSL errors: PKIX path building failed, SSL handshake failed
MapReduce job fails with "Broken pipe" error in mappers, and no DMX stderr log
Mapper or reducer ID in HDFS intermediate file path causes CREAT error
Enabling JDBC driver tracing in Connect for Big data
Differences between SyncSort and Connect ETL(DMX)
Using multiple record layouts for the same source file in Connect ETL
"(PIMAOR) the record length value is out of range" message in Connect ETL
"Extraction or execution of getsysinfo failed" message on running licenseinfo.sh in Connect ETL on Linux
Windows Server 2022 support with Connect ETL
Importing DTL Files with or without Resolving Environment Variables in Connect ETL
"DMX_JDBC_INI_FILE is not set" message in Connect ETL
Connect ETL(DMX) uninstaller missing or failing to launch
Hive target error relating to transactions/locking in Connect for Big data
Resolving S222 ABEND and MFJXE00 Errors when running DMXMFSRT in Micro Focus Enterprise Server - Connect ETL
Hive on Windows causes (ASSERT) internal error in SigmaActivity.cpp in Connect for BigData
Hive JDBC transport error with reason "null" in Connect for BigData
Connecting to Oracle via JDBC through Connect ETL
Converting DateToString using custom functions in Connect ETL
Installation error: Unable to load the license DLL dmxlicense.dll in Connect ETL
Schema Registry: "Unrecognized SSL message, plaintext connection?" when Connecting to Kafka Schema Registry in Connect ETL
Kafka connection fails with java.lang.OutOfMemoryError: Java heap space in DMX Change Data Capture
Error: "(ASSERT) internal error (unexpected condition) occurred in file StageBuffer.cpp at 84" in Connect ETL
CDC Apply fails for case sensitive Snowflake target with lowercase column names in DMX Change Data Capture
Connect: Windows system hangs for up to 15 minutes during product installation
Connect: Parquet target write fails with OutOfMemoryError: Java heap space
Connect: (HDPRXYSE) unable to start the Hadoop proxy
Connect: Databricks - workDirectory vs. WORKTABLEDIRECTORY
Running I/O Benchmark Tests
Changing the Secure FTP port used by DMX
"Peer indicated failure: Unsupported mechanism type PLAIN" message in Connect ETL
Using custom SSL/TLS certificates with Connect - Resolving HTTPSCVF
Connect: The application has failed to start because its side-by-side configuration is incorrect.
Unable to connect to the local DMX server
GSS initiate failed
Numbers in ODBC error messages in DMExpress logs
Accessing Data in Excel Spreadsheets
JAVA_HOME is not set
Resolving the DMExpress Library Not Found Error
Unable to obtain Principal Name for authentication
Amazon RDS support in Connect ETL/for Big Data
(KEYTYPE) the license key file contains invalid key information
Resolving the DBCNNTES/FLLDALIB Errors
Unable to connect to a remote DMX server
DMX Release Notes 9.9.10
(USERIMPERSONATEERROR) cannot impersonate a user / (SVCAUTHF)
DMXODBCDRIVERMANAGER setting in the odbcinst.ini file
(KILLED) the process has been terminated with the kill command
`GLIBCXX_N.N.NN' not found after fresh Connect install on Linux
libjvm.so or jvm.dll not found
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
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
HIVEWERR, Permission denied when writing to Hive
Using Kafka Schema Registry in Connect
DMXODBCDRIVERMANAGER setting in the odbcinst.ini file
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
Management service dmxmgr fails to start: Unable to insert row for version '1.6' in Schema History table "PUBLIC"."schema_version"
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
cp: cannot stat "<installer directory>/.setup": No such file or directory
Configuring WORKTABLEDIRECTORY for a local staging file instead of an S3 bucket for Snowflake in Connect ETL
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
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"
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
Resolving the SRVAUTHFAIL Error
Hive JDBC transport error with reason "null" in Connect for BigData
(USERIMPERSONATEERROR) cannot impersonate a user / (SVCAUTHF)
CVROP error due to incorrect copybook type for EBCDIC trailing sign data in Connect ETL
'No suitable driver found' message for Databricks jdbc connection in Connect ETL
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.