Connecting to views in DB2: ODBC error

[shephali23]

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?

[lorenzoconforti]

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

[shephali23]

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?

[lorenzoconforti]

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

[shephali23]

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 ?

[lorenzoconforti]

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