Skip to main content
print this page

Failed to create/update connection of type JDBC(SQL Server only)

· 2 min read
Fix Available
Fix Available
This bug has been fixed
Patch Available
Patch Available
This bug has a patch available for affected versions

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*

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 available

Fix is available in Amorphic v2.1. Please upgrade to the latest version to resolve this issue.

Patch available

Patch is available for Amorphic versions v2.0.

Please contact amorphic-support@cloudwick.com to patch your application.

Timeline​

gantt
    title Timeline
    dateFormat YYYY-MM-DD
    tickInterval 7day
    axisFormat %b-%d
    todayMarker off
    section Tracker
        %% update the ticket number and date of bug report
        CLOUD-3064 : done, 2023-01-30, 0d
    section Identification
        Reported : crit, des1, 2023-01-30, 1d
    section Mitigation
        %% Update number of days took for each step below
        Root cause analysis : 2d
        Bug fixed: crit, done, 2023-02-06
    section Delivery
        %% update the date of each step below
        testing complete: milestone, 2023-03-16, 0d
        patch avaialble: milestone, 2023-03-18, 0d
  • 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