The following issues can occur when you connect to a data source:
Initialization exception error occurs while reading or writing a large amount of data.
If you encounter an initialization exception error, configure the JVM memory requirements to resolve the issue.
Perform the following steps to configure the JVM memory from Administrator in Informatica Intelligent Cloud Services:
1Open Administrator in Informatica Intelligent Cloud Services.
2Navigate to the Runtime Environments tab.
3Select the Secure Agent, and then click Edit.
4In the System Configuration Details section, select Data Integration Service as the service and DTM as the type.
5Edit the JVMOption1 property, and increase the -Xms and -Xmx values based on the amount of data that you want to process.
6Click Save.
If you encounter connection-specific errors, see the applicable Cloud Data Integration Connector documentation in the Informatica documentation portal at https://docs.informatica.com
Error occurs when using a single slash "\n" entry for the Google Cloud Spanner private key.
When you create a Google Cloud Spanner connection and add the private key value in the Google Cloud Spanner connection properties from the JupyterLab for INFACore interface to connect to Google Cloud Spanner, you need to manually replace \\n in place of \n in the private key code using the Python SDK.
Connection with Aurora and MySQL data sources fails with MS1252 code page.
The connection fails when you use the default code page value MS1252. You need to change the code page value to UTF-8 or any other supported value.
The Box connection fails for the token value entry in the OAuth Access Token field.
The OAuth Support Refresh field displays along with the OAuth Access Token field. You need to enter the token value in both of the fields to successfully create a Box connection.
Connection parameters are not displayed as mandatory for SAP ODP Extractor.
The SAP ODP Extractor connection does not display which parameter is mandatory. See the Connector documentation for the list of mandatory parameters that you need to specify.
A write operation to a Google Cloud Spanner target fails when the source does not have a primary key
If you write data to a Google Cloud Spanner target from a source table that does not have a primary key defined, the operation fails.
Error occurs when you write Null data
When you call the DataFrameWriter method to write data that is completely Null, the from_pandas() call fails to convert Null to String while writing data to the target.
Error occurs when accessing SharePoint.
Ensure that the INFACore agent is installed on the same virtual machine where the SharePoint server runs
Unsupported advanced target attributes listed for File Processor or Microsoft Excel
Even though you cannot use the File Processor or Microsoft Excel connection to write data, the advanced target attributes for these data sources appear when you attempt to configure a write operation from the INFACore Python SDK code. The write operation for File Processor and Microsoft Excel is not supported. Do not use the listed Microsoft Excel or File Processor advanced attributes.
Mapping fails when you create a new target at runtime in Google Cloud Storage
When you specify a path to create a new target at runtime in Google Cloud Storage, you need to also specify the path in the Google Cloud Storage Path field in the advanced source properties. Else, the mapping fails.