Discussion Board for collaboration related to QlikView Deployment.
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);
PRO: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...
To ask the obvious question: does you Publisher account have read access on the database? If you reload manually, then QV reloads using your currently-logged-in Windows account. If you reload the document in Publisher, it will use the account you set up during installation...
Turn on "Generate Logfile" for the document (Settings > Document Properties > General), relload form QMC and look at the document log for clues. The log will be in the same directory as the document.
First of all thank you for your reply so quick!
I've enabled de logfile and that's what it write (translated from french...):
Error: SQL Error: Specified Driver couldn't load due to error system 1114 (Oracle in OraClient10g_home1)
SQL State : IM003
I can't resolve that error...
In fact in my Qlikview services this is the Administrator Account that is pointed as defauld login, but I can make reload of .QVD files or .XLS files for example, this is just an ODBC connexion that fails... So is there something to do in my Oracle Client? And why I can request in Desktop mode but not in Server mode?
Thank you for all
Hmm, could be a driver problem, but that's strange because you mentioned that manual reloads work from that same box...
I think it's worth check if it's an access problem. The reason you can reload manually is because QlikView uses your currently-logged-in Windows account when you reload manually, but uses the Publisher account when the job is run from the server. Of course the Publisher account will have access to all flat files (XLS and QVD) since it's a Windows admin. But if you're using Oracle it doesn't matter that the Publisher account is an administrator, you still need to grant it read access on the appropriate database.
OK thanks. I'll see that. But it's hard for me to believe that my Admin account don't have read access to Oracle, because if he doesn't, who does? lol
Thank you for your replies, I owe you one.
Sorry but I don't understand who my Admin account has to have "read access" to Oracle since I use an ODBC connexion with all connexion parameters (the ODBC connexion holds the keys for Oracle identification...). I mean, whatever the account you choose, you can connect with Oracle, through excel for example, with a valid ODBC connexion. And I tried to reload a document through QV Desktop with my Admin account and it runs perfectly.
But thank you for the tip because I couldn't figure out that issue.
Is QlikView Server trying to connect through a special port? I mean Do I have to setup a port to my Oracle Database in Qv Server? I think it's possible that QvServer is pointing to the wrong port... What do you think?
I have cut the firewall down in the QlikView Server side but not in the Oracle one... (Qvs and Oracle are not in the same machine...) May I have to allow a special access in the Oracle server?
I'm tryin' all issues since I'm desperate lol
No, I don't think Publisher uses any special port by default to connect to ODBC resources. Make sure your Publisher account has been granted Logon As Service rights in the domain (or local if applicable) security policy. I've found that a good way to test whether something is an access issue is to login to Windows using the Publisher account and then try reloading the QVW in QlikView Desktop. If it works, then it's not an access issue and it's time to submit a bug report to Qliktech (firstname.lastname@example.org). If it doesn't work, then it's almost definitely an access issue, at which point you would need to start checking your NTFS and Oracle permissions. You might also be able to get more detailed information in the Desktop log file if the reload fails.