User is Failed to create/update connection of type JDBC(SQL Server only) becuase of the updated driver version.
Affected Versions: 2.0
Fix Version: 2.1 2.0*
Customers upgrading to 2.0 after March 18, 2023 does not require explicit patching as the fix will be part of the release artifacts.
Root cause(s)
As part of continuous enhancements to Amorphic, python version has been upgraded from 3.7 to 3.9 in version 2.0 and the pyodbc driver that is being used to connect to SQLServer database has a known issue with 3.9 version where it results in unsuccesful connection to the database.
Impact
Users would not be able to create the data ingestion connections(jdbc - SQLServer type) or update connections fail with timeout error and task creation will not proceed further because of unsuccesful connection to source where database and tables fetch from source will fail.
Mitigation
Fix is available in Amorphic v2.1. Please upgrade to the latest version to resolve this issue.
Patch is available for Amorphic versions v2.0.
Timeline
- 2023-01-30: Bug reported/identified (CLOUD-3064)
- 2023-02-01: Bug triaged
- 2023-02-06: Bug fixed
- 2023-03-16: Testing of patch on v2.0 is completed
- 2023-03-18: Patch for v2.0 released
- 2023-03-28: Amorphic version 2.1 Released with the bugfix