topic Too often Error (SQL_ERROR SqlState: HYC00 NativeError: 30058) occurred on DB2i source endpoint in Qlik Replicate

Too often Error (SQL_ERROR SqlState: HYC00 NativeError: 30058) occurred on DB2i source endpoint

khchoy — Tue, 01 Jun 2021 02:43:47 GMT

Hi All

Too often error occurred on DB2i source endpoint.

But replicate seems no problem. In what cases does this error occur?

Error are occurred like as below ;

00027068: 2021-05-03T12:27:31:377011 [SOURCE_CAPTURE ]I: Initial positioning by timestamp '2021-05-03 07:19:04' (db2i_endpoint_capture.c:1274)
00027068: 2021-05-03T12:27:31:377011 [SOURCE_CAPTURE ]V: Construct statement execute internal: 'select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME from QSYS2.SYSTABLES where TABLE_SCHEMA='KSSLIB' and TABLE_NAME='ATCHFILE'' (ar_odbc_stmt.c:3718)
00027068: 2021-05-03T12:27:31:377011 [SOURCE_CAPTURE ]T: RetCode: RetCode: SQL_ERROR SqlState: HYC00 NativeError: 30058 Message: [IBM][System i Access ODBC Driver]Driver not capable. (ar_odbc_stmt.c:3656)
00027068: 2021-05-03T12:27:31:377011 [SOURCE_CAPTURE ]V: Execute: 'select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME from QSYS2.SYSTABLES where TABLE_SCHEMA='KSSLIB' and TABLE_NAME='ATCHFILE'' (ar_odbc_stmt.c:2476)
00027068: 2021-05-03T12:27:31:392637 [SOURCE_CAPTURE ]T: Retrieved system names 'KSSLIB '.'ATCHFILE ' for 'KSSLIB'.'ATCHFILE' (db2i_endpoint_util.c:930)
00027068: 2021-05-03T12:27:31:392637 [SOURCE_CAPTURE ]V: Construct statement execute internal: 'select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME from QSYS2.SYSTABLES where TABLE_SCHEMA='KSSLIB' and TABLE_NAME='E_FMRLTP'' (ar_odbc_stmt.c:3718)
00027068: 2021-05-03T12:27:31:392637 [SOURCE_CAPTURE ]T: RetCode: RetCode: SQL_ERROR SqlState: HYC00 NativeError: 30058 Message: [IBM][System i Access ODBC Driver]Driver not capable. (ar_odbc_stmt.c:3656)
00027068: 2021-05-03T12:27:31:392637 [SOURCE_CAPTURE ]V: Execute: 'select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME from QSYS2.SYSTABLES where TABLE_SCHEMA='KSSLIB' and TABLE_NAME='E_FMRLTP'' (ar_odbc_stmt.c:2476)
00027068: 2021-05-03T12:27:31:408262 [SOURCE_CAPTURE ]T: Retrieved system names 'KSSLIB '.'E_FMRLTP ' for 'KSSLIB'.'E_FMRLTP' (db2i_endpoint_util.c:930)
00027068: 2021-05-03T12:27:31:408262 [SOURCE_CAPTURE ]V: Construct statement execute internal: 'select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME from QSYS2.SYSTABLES where TABLE_SCHEMA='KSSLIB' and TABLE_NAME='E_TOTMEM2'' (ar_odbc_stmt.c:3718)

Regards,

Kwangho,

Re: Too often Error (SQL_ERROR SqlState: HYC00 NativeError: 30058) occurred on DB2i source endpoint

john_wang — Tue, 01 Jun 2021 04:35:44 GMT

Hello KwangHo,

Thanks for you contacting Qlik support.

I'm assuming you are mentioning this warning message:

2021-05-03T12:27:31:377011 [SOURCE_CAPTURE ]T: RetCode: RetCode: SQL_ERROR SqlState: HYC00 NativeError: 30058 Message: [IBM][System i Access ODBC Driver]Driver not capable

When working with ODBC, it is expected to get these messages.

Basically when Replicate negotiates with the ODBC driver, it queries a list of functions the driver is cable of handling, if some function is not supported by the driver, Replicate will use another, or handle this differently, so unless this message appears as an error (]E:) it can be ignored (in your scenario it's (]T:)).

Hope this helps.

Regards,

John.

Re: Too often Error (SQL_ERROR SqlState: HYC00 NativeError: 30058) occurred on DB2i source endpoint

PadmaPriya — Tue, 01 Jun 2021 16:07:41 GMT

Hello @khchoy

The "Drive not capable" is displayed only when tracing is ON. As we work with several ODBC drivers, this is something related to one of the properties we set on the statement.

Seems like in your source endpoint, please enable "Use Schema and table system names" option. Let me know if that doesn't solve the issue.

You may refer to below article very similar to the issue you have reported:

https://support.qlik.com/articles/000005615

Thanks,

Padma Priya