Ok this is my problem. I can't reload any documents if I use an ODBC connection!
I explain :
1) I write my script with an ODBC connexion which should look like this:
2) Then I write an SQL LOAD like this :CONNECT TO [gnx_prod;DBQ=gnx] (XUserId is QILFVZdNMKI, XPassword is ZeDUEZNGbEXYcS);
SQL Select customer.customerID, customer.namecustomer
3) Then, after saving that, I publish the document in a QlikView Server Directory where I'll find it in QMC. Then in my QMC (QlikView Management Console) through the "User Documents" I try a "Reload now" for the document above... Then I wait. Then... nothing!! To see if the reload thing runs correctly, I've created a Text Object in my document which give the time of reload (with the fonction =reloadtime() ).
When I erase my ODBC connection, the documents reloads perfectly, but when I try to let it... It fails. Moreover for those who will ask me, I am able to reload manually through the QlikView Desktop... This is only the QlikView Server which is not able to run the task. This is an extract of my log file :
25/02/2010 18:03:03.8869043 Information Executing ClusterID=1, QDSID=560f4d8d-ddbe-20b6-f1ed-5363ff198ea0QDSMain.ReloadTask
25/02/2010 18:03:03.8869043 Information Starting task ""Reload Now" of test pro.qvw" (Attempt 1 of 0)
25/02/2010 18:03:03.8869043 Information Max run time: 1.00:00:00
25/02/2010 18:03:03.9025303 Information Opening "C:\Documents and Settings\All Users\Application Data\QlikTech\Documents\Documents\test pro.qvw"
25/02/2010 18:03:03.9025303 Information Allocating QlikView Engine
25/02/2010 18:03:03.9025303 Information Allocating new QlikView Engine. Current usagecount=1 of 2
25/02/2010 18:03:03.9025303 Information An instance of the QlikView Engine is being created
25/02/2010 18:03:03.9025303 Information Starting QlikView Engine
25/02/2010 18:03:04.0900423 Information The QlikView Engine was started successfully. Version=9.00.7320.7, ProcessID=976
25/02/2010 18:03:04.0900423 Information Allocated QlikView Engine successfully. Current usagecount=1 of 2, Ticket=71709
25/02/2010 18:03:04.0900423 Information Loading document "C:\Documents and Settings\All Users\Application Data\QlikTech\Documents\Documents\test pro.qvw" (0.13 Mb)
25/02/2010 18:03:04.1994243 Information Physical FileSize=0.13 Mb. Memory Allocation Delta for this file=2.72 Mb. Available Physical Memory Before Open=3073.77 Mb. Available Physical Memory After Open=3070.14 Mb. Total Physical Memory=4090.64 Mb.
25/02/2010 18:03:04.1994243 Information The document was loaded successfully.
25/02/2010 18:03:04.2306763 Information Initializing Checkout (0), Loading document (188), Initializing load (188), Checking read (188), Creating QlikView Engine (188), Checking Size (219), Load (219), Load Completed (250), Tables read (266), Opened successfully (297)
25/02/2010 18:03:04.2306763 Information Document was opened successfully
25/02/2010 18:03:04.2306763 Information Opened successfully (0)
25/02/2010 18:03:04.2306763 Information Starting reload
25/02/2010 18:03:04.2463023 Information QlikView->Settings->Document Peferences->Generate Logfile in document is not set.
25/02/2010 18:03:04.2463023 Information The Source Document is being reloaded. DocumentPath=C:\Documents and Settings\All Users\Application Data\QlikTech\Documents\Documents\test pro.qvw
25/02/2010 18:03:04.2619283 Information The Source Document reload complete. DocumentPath=C:\Documents and Settings\All Users\Application Data\QlikTech\Documents\Documents\test pro.qvw
25/02/2010 18:03:04.2619283 Information Memory Allocation Delta for this file=0.50 Mb. Available Physical Memory Before Reload=3069.98 Mb. Available Physical Memory After Reload=3069.11 Mb. Total Physical Memory=3069.11 Mb.
25/02/2010 18:03:04.3400583 Error The Source Document was NOT reloaded successfully. DocumentPath=C:\Documents and Settings\All Users\Application Data\QlikTech\Documents\Documents\test pro.qvw.
25/02/2010 18:03:04.3556843 Information Initializing Reload (0), Finished (125)
25/02/2010 18:03:04.3556843 Error Reload failed.
25/02/2010 18:03:04.3713103 Information Closing the document.
25/02/2010 18:03:04.5588223 Information Closed the QlikView Engine successfully. ProcessID=976
25/02/2010 18:03:04.5588223 Information Initializing (0), Finished (203)
25/02/2010 18:03:04.5588223 Error The task ""Reload Now" of test pro.qvw" failed. ErrorCount=2
25/02/2010 18:03:07.6215183 Information Temporary Task has finished execution.
So... Is there something I did wrong? Or What?
Please make me enjoy QlikView like I used too in my dreams... lol
P.S : I run QVS and QV in the same machine... I can do a successful ping of the database (Oracle 10g), I can connect it throught the QV desktop but a reload with of THE SAME DOCUMENT is not possible through QVServer...