topic Re: Connecting to views in DB2: ODBC error in Connectivity & Data Prep

Connecting to views in DB2: ODBC error

shephali23 — Thu, 02 Apr 2020 14:04:58 GMT

I am trying to load data from a view in DB2 to Qliksense . The view has around 7.5 million records. The data loads progresses for 7 -8 minutes then fails with below error:

ERROR [HY000] [Qlik][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]Unknown error: SQLCODE -420

Could anyone help on what the error is and how to resolve?

Re: Connecting to views in DB2: ODBC error

lorenzoconforti — Thu, 02 Apr 2020 14:32:10 GMT

Not sure how to solve it but here what it means; it is of course returned by the SQL DB2 server so you'll need to fix it in there:

"SQLCODE -420, Error: THE VALUE OF A CHARACTER STRING ARGUMENT WAS NOT ACCEPTABLE TO THE FUNCTION"

https://sites.google.com/site/sugumaribm/abend/db2-error

Re: Connecting to views in DB2: ODBC error

shephali23 — Thu, 02 Apr 2020 15:26:51 GMT

Thanks. But it doesnt look like the error is related to this: THE VALUE OF A CHARACTER STRING ARGUMENT WAS NOT ACCEPTABLE TO THE FUNCTION".

I tried loading top 700k rows and it worked fine. I think its the volume of the data thats causing the error.

How does Qliksense connect to VIEWS? Does it keep querying the view until the data is completely loaded and might cause the import to fail gradually?

Re: Connecting to views in DB2: ODBC error

lorenzoconforti — Thu, 02 Apr 2020 15:35:55 GMT

The point is that the error is coming from your SQL server, not qlik sense

Re: Connecting to views in DB2: ODBC error

shephali23 — Thu, 02 Apr 2020 15:37:29 GMT

That makes sense. Also want to understand how does Qliksense connect to VIEWS? Does it keep querying the view until the data is completely loaded ?

Re: Connecting to views in DB2: ODBC error

lorenzoconforti — Thu, 02 Apr 2020 15:58:06 GMT

I don't have direct experience with DB2 but the connection is managed by the ODBC driver; in general, a request is made by qlik sense to the driver, that sends the request to the SQL server and returns the results to qlik sense