Connector and connectivity issues

Read the following pages to learn about fixed issues, known limitations, and third-party limitations that apply to connectors that you can use in your service. Consider the following guidelines for the release notes:

Amazon Redshift V2

Known issues

Issue	Description
DBMI-12846, DBMI-12847	If you use a Secure Agent on Windows that is configured for NTLM proxy authentication, when you try to create an application ingestion and replication task or database ingestion and replication task that has an Amazon Redshift target, the task wizard fails to fetch the list of target schemas. As a result, you cannot complete the task definition. (April 2023)

Google BigQuery V2

Fixed issues

Issue	Description
DBMI-19760	An application ingestion and replication or a database ingestion and replication initial load job that has a Google BigQuery target might fail while uploading a staging file in Google Cloud Storage. (October 2024)

Microsoft Azure Synapse Analytics Database Ingestion

Known issues

Issue	Description
DBMI-19405	Tests of a Microsoft Azure Synapse Analytics Database Ingestion connection for an application ingestion and replication task or database ingestion and replication task fail with the following error if the user name specified in the connection properties includes a special character such as @ and the target database uses AAD authentication: Cannot instantiate datasource because of error: Failed to initialize pool: Cannot open server 'noconline.onmicrosoft.com' requested by the login. The login failed. ClientConnectionId: <identifier> This problem occurs because the Synapse Analytics connector package is missing some .jar files that are required to connect to the target database in this situation. Workaround: Copy the following jars to the connector package: - activation-1.1 - adal4j-1.4.0 - jcip-annotations-1.0-1 - json-smart-1.3.1 - mail-1.4.7 - nimbus-jose-jwt-9.40 - oauth2-oidc-sdk-5.24.1 The package location is: package-AzureDWGen2MI.xxx\package\dw\thirdparty\informatica.azuredwgen2mi (August 2024)

Issue

Description

DBMI-19405

Tests of a Microsoft Azure Synapse Analytics Database Ingestion connection for an application ingestion and replication task or database ingestion and replication task fail with the following error if the user name specified in the connection properties includes a special character such as @ and the target database uses AAD authentication:

Cannot instantiate datasource because of error: Failed to initialize pool: Cannot open server 'noconline.onmicrosoft.com' requested by the login. The login failed. ClientConnectionId: <identifier>

This problem occurs because the Synapse Analytics connector package is missing some .jar files that are required to connect to the target database in this situation.

Workaround: Copy the following jars to the connector package:

- activation-1.1
- adal4j-1.4.0
- jcip-annotations-1.0-1
- json-smart-1.3.1
- mail-1.4.7
- nimbus-jose-jwt-9.40
- oauth2-oidc-sdk-5.24.1

The package location is: package-AzureDWGen2MI.xxx\package\dw\thirdparty\informatica.azuredwgen2mi

(August 2024)

Microsoft SQL Server

Fixed issues

Issue	Description
DBMI-19742	Application ingestion and replication jobs and database ingestion and replication jobs that have a SQL Server target write empty strings from the source as nulls on the target. This behavior can cause problems with downstream processing of the target data. Instead, write each source empty string as a space on the target to prevent these problems. (October 2024)

Oracle Database Ingestion

Known issues

Issue	Description
DBMI-12846, DBMI-12847	If you use a Secure Agent on Windows that is configured for NTLM proxy authentication, when you try to create an application ingestion and replication task or database ingestion and replication task that has an Amazon RDS for Oracle target, the task wizard fails to fetch the list of target schemas. As a result, you cannot complete the task definition. This problem does not occur with an on-premises Oracle target. (April 2023)

Issue

Description

DBMI-12846, DBMI-12847

If you use a Secure Agent on Windows that is configured for NTLM proxy authentication, when you try to create an application ingestion and replication task or database ingestion and replication task that has an Amazon RDS for Oracle target, the task wizard fails to fetch the list of target schemas. As a result, you cannot complete the task definition. This problem does not occur with an on-premises Oracle target.

(April 2023)

PostgreSQL

Fixed issues

Issue	Description
DBMI-18843	Application ingestion and replication jobs and database ingestion and replication jobs that have a PostgreSQL target fail with the following error if you enabled the SSL encryption method in the PostgreSQL connection properties but didn't specify a KeyStore value: Process <UNLOAD-SALESFORCE-Account PostgreSQLFile Writer> failed to initialize due to an unexpected exception creating of POSTGRESQL connection. Error : [informatica][PostgreSQL JDBC Driver]Error establishing socket to host and port: <host>:<port>. Reason: null (No such file or directory) (July 2024)

Issue

Description

DBMI-18843

Application ingestion and replication jobs and database ingestion and replication jobs that have a PostgreSQL target fail with the following error if you enabled the SSL encryption method in the PostgreSQL connection properties but didn't specify a KeyStore value:

Process <UNLOAD-SALESFORCE-Account PostgreSQLFile Writer> failed to initialize due to an unexpected exception creating of POSTGRESQL connection. Error : [informatica][PostgreSQL JDBC Driver]Error establishing socket to host and port: <host>:<port>. Reason: null (No such file or directory)

(July 2024)

Snowflake Data Cloud

Fixed issues

Issue	Description
AIN-6535	Application ingestion and replication and database ingestion and replication jobs that use the Superpipe option to stream data to a Snowflake target fail with the following exception when there is a large number of target tables and no LIMIT on the show columns command. SnowflakeSQLException: Statement exhausted execution resources and was canceled. Please contact support. (July 2024)
DBMI-18827	Application ingestion and replication jobs and database ingestion and replication jobs that use the Superpipe option to stream rows of data directly to Snowflake target tables need to prevent the stream from becoming stale during periods of no change data activity, when the pointer for the last read is not advanced. If the stream becomes stale, views of the CDC target tables might not be available. (July 2024)

Issue

Description

AIN-6535

Application ingestion and replication and database ingestion and replication jobs that use the Superpipe option to stream data to a Snowflake target fail with the following exception when there is a large number of target tables and no LIMIT on the show columns command.

SnowflakeSQLException: Statement exhausted execution resources and was canceled. Please contact support.

(July 2024)

DBMI-18827

Application ingestion and replication jobs and database ingestion and replication jobs that use the Superpipe option to stream rows of data directly to Snowflake target tables need to prevent the stream from becoming stale during periods of no change data activity, when the pointer for the last read is not advanced. If the stream becomes stale, views of the CDC target tables might not be available.

(July 2024)