OpenMetadata icon indicating copy to clipboard operation
OpenMetadata copied to clipboard
Published 4 weeks ago • verified publisher icon open-metadata

DB2 AS400 connection failed

Open datapopcorn opened this issue 1 year ago • 0 comments

Affected module Ingestion

Describe the bug Failed to GetTables when connecting to DB2 AS400 database by ibmi connect. Error message:

(pyodbc.DataError) ('22001', '[22001] [IBM][System i Access ODBC Driver]Column 3: CWB0111 - Input data is too big to fit into field (30207) (SQLExecDirectW)') [SQL: /* {"app": "OpenMetadata", "version": "1.4.1.0"} */ SELECT "QSYS2"."SYSTABLES"."TABLE_NAME" FROM "QSYS2"."SYSTABLES" WHERE "QSYS2"."SYSTABLES"."TABLE_SCHEMA" = ? AND "QSYS2"."SYSTABLES"."TABLE_TYPE" IN (?, ?) AND "QSYS2"."SYSTABLES"."SYSTEM_TABLE" = ? ORDER BY "QSYS2"."SYSTABLES"."TABLE_NAME"] [parameters: ('儀䜀倀䰀', 'T', 'P', 'N')]

To Reproduce

  1. Entering connection info
  2. Test Connection image

Expected behavior connect to DB2 AS400 without error

Version:

  • OS: Redhat8.9
  • Python version: 3.9
  • OpenMetadata version: 1.4.1
  • bare metal

Additional context

datapopcorn avatar Aug 15 '24 13:08 datapopcorn