5.8.06.03 - connect_cdc_mimix_share - Latest

Connect CDC Release Notes

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
Latest
Language
English
Product name
Connect CDC
Title
Connect CDC Release Notes
Copyright
2024
First publish date
2021
Last edition
2024-08-01
Last publish date
2024-08-01T21:24:12.809750
Symptom Area Affected Reference Number Release fixed in

Error obtaining table information for catalog 'null' schemas '%' tables '%' on host <hostName> server <instanceName>: connection id #<n>

ERROR DETAILS >>> [Error:586] [State:S0002] Message: The prepared statement handle <n> is not valid in this context. Please verify that current database, user default schema, and ANSI_NULLS and QUOTED_IDENTIFIER set options are not changed since the handle is prepared.

This symptom can occur starting in 5.8.06 when the following conditions are met:
  • Operations are performed that list tables, keys, indexes, or table privileges for SQL Server or SQL Azure from the Director.
  • Version 10.2 of the JDBC driver is being used.
  • The operations are using the same database connection.
  • The operations act upon more than one SQL Server database or database owner (such as a “Refresh Available Tables” or “Refresh List”).

    For example, this can happen when performing “Refresh Available Tables” on database A, followed by another “Refresh Available Tables” operation on database B; database A would succeed, and database B would fail.

MXSHR-7490 5.8.06.03