Qlikview reload script not ending

[rjournet]

Hello,

I am facing a really weird issue since few days (everything was fine before).

I know there are many created topics on this, but did not find the right answer.

I am reloading a simple QVD with like 20 columns from a as400 database, 100k rows, db2 iSeries ODBC connector. Everything works fine.

When the reload script comes to the end, the QVD file is well stored into my destination folder, but the reload script does not ending and nothing happens. I am forced to kill the process.

Same when starting the reload from the QMC.

I put some Trace; everywhere to make sur the store part is well completed.. 

Version QV 12.10.0.0

Any suggestion ? 

Regards,

Rémi

[rubenmarin]

Hi, If you comment the drop and the store senteces, It ends? It is a manual reload, from qmc or using a bat or similar file?

[rjournet]

Hello Rubenmarin, it remains the same. The load script is completed (I got 100% of the rows I expect but the progress still freez (with or without exit script). I did not find anything weird within the data.. 

The same script on my personnal computer works fine, but few others similar scripts work too on the Qlikview server. I am retriving 25 fields only.

[BrunPierre]

ODBC connection may sometimes hang open after execution, to terminate the existing connection after reload. Do this;

LOAD ... ;
DISCONNECT; // <--- Add this
STORE ... ;
DROP ... ;

[Daniele_Purrone]

Hi @rjournet ,

I remember seeing problems like this in old versions of QlikView.
If you really are on QlikView 12.10, which was released 9 years ago, I would suggest upgrading to the latest version and see if the problem is still present.

If it was just a typo, and you actually meant 12.100, I would recommend enabling Debug verbosity (900) on the QVB and running the task again on the QMC to start with, and then open a support case if necessary.

[rjournet]

Hello BrunPierre, yes I already tried this, without any success...

My script is exactly like this : 

TempLOAD :
LOAD xxx

;

SQL 

SELECT xxx	
FROM COMAFIKD.HENCDE WHERE ENDFAA > 21;

DISCONNECT;
EXIT SCRIPT;

[rjournet]

Hi Daniele, yes my client is running Qilkview 12.10, no typo mystake 🙂

Upgrading to 12.100 is my last chance but I was hoping to fix this without doing this as my issue happened suddently and as all my others scripts work fine.

[Daniele_Purrone]

Hi @rjournet... at least, I'd recommend updating to the final SR of 12.10 and not staying on the IR.
There have been lots of fixes since then. 
Also consider that 12.10 is unsupported, and has serious security issues that were addressed in later versions.

[marcus_sommer]

What happens if you creates a complete new app - no UI and no other scripts as the connect + sql select (manually written)?

It will exclude any kind of corruption of the app as well as any side-effects from other script-parts. If it's working so far you could add the other stuff step by step.