Hi While ingestion metadata from oracle database we are getting below error.

dhubv0812/lib64/python3.6/site-packages/sqlalchemy/engine/result.py", line 1215, in _fetchone_impl
return self.cursor.fetchone()

DatabaseError: (cx_Oracle.DatabaseError) DPI-1037: column at array position 0 fetched with error 1406

Is there anything more in the stacktrace? Something which might suggest this is happening for one particular table or column?

Complete stacktrace.

@big-carpet-38439 any idea if Oracle integration has been used by someone else and has been tested?

I believe it has been used by others. But I don't recall the specific folks off the top of my head. @rich-policeman-92383 do you know what the actual types of these columns are in oracle? like recordownertype? and are you using a recent distribution of oracle?

@rich-policeman-92383 Any update about the DPI-1037 error? I got the same issue when ingestion oracle metedata. Thanks!

@big-carpet-38439 PFB column types and we are using "Oracle Database 19c Enterprise Edition Release 19.0.0.0.0"

SQL> desc ag_main.roagcredentialrole;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 RECORDOWNERIMPORTSOURCEID                          NUMBER(19)
 RECORDOWNERTYPE                                    NVARCHAR2(1)
 RECORDLASTSYNCBYPERSONID                           NUMBER(19)
 RECORDLASTSYNCDATE                                 TIMESTAMP(6)
 RECORDISLASTSYNCREJECTED                           NCHAR(1)
 LASTMODIFYINGIMPORTRUNID                           NUMBER(19)
 LASTMODIFIEDDATE                                   TIMESTAMP(6)
 LASTMODIFIEDBYPERSONID                             NUMBER(19)
 AGRESOURCEID                              NOT NULL NUMBER(19)
 AGPRODUCTROLEID                           NOT NULL NUMBER(19)
 AGRESOURCECREDENTIALID                    NOT NULL NUMBER(19)
 FOAGRESOURCECREDENTIALID                           NUMBER(19)
 OTAGRESOURCECREDENTIALID                           NVARCHAR2(1)
 SPAGRESOURCECREDENTIALID                           NUMBER(19)
 SDAGRESOURCECREDENTIALID                           TIMESTAMP(6)
 SRAGRESOURCECREDENTIALID                           NCHAR(1)
 MDAGRESOURCECREDENTIALID                           TIMESTAMP(6)
 MSAGRESOURCECREDENTIALID                           NUMBER(19)
 MPAGRESOURCECREDENTIALID                           NUMBER(19)
 PRIORITY                                  NOT NULL NUMBER(18)
 FOPRIORITY                                         NUMBER(19)
 OTPRIORITY                                         NVARCHAR2(1)
 SPPRIORITY                                         NUMBER(19)
 SDPRIORITY                                         TIMESTAMP(6)
 SRPRIORITY                                         NCHAR(1)
 MDPRIORITY                                         TIMESTAMP(6)
 MSPRIORITY                                         NUMBER(19)
 MPPRIORITY                                         NUMBER(19)
 UPDATESTAMP                               NOT NULL NUMBER(19)
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0

Ah I see. We may need to create an issue to track this one then

@rich-policeman-92383, I have the same issue with some views in Oracle. My error stems from the TEXT in ALL_VIEWS table. Did you have any success after this thread?