Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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"
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?
The point is that the error is coming from your SQL server, not qlik sense
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 ?
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