Qlikview 8.20 Publisher Standar Edition issue

[#1]

All the Publisher job resulted with error, after we installed the 10g Database in the QV server and we connect to Database using ODBC connectivity of 10g driver.

From the same QV server and press Download button, it works and refreshing.

The problem is with the Publisher only, which is not properly sensing the ODBC and gives ODBC error.

Attached some log files, which may be of helpful for you…

1002819 2009-11-16 06:55:00 Normal Information Preparing "C:\Program Files\QlikView\Examples\QvsDocuments\EPGH_Executive_Summary_2009.qvw" for reload.
1002820 2009-11-16 06:55:00 Normal Information Checking write permissions on "C:\Program Files\QlikView\Examples\QvsDocuments\EPGH_Executive_Summary_2009.qvw"
1002821 2009-11-16 06:55:00 Normal Information Opening "C:\Program Files\QlikView\Examples\QvsDocuments\EPGH_Executive_Summary_2009.qvw"
1002841 2009-11-16 06:55:04 Normal Information Starting Operation: Reload
1002848 2009-11-16 06:55:04 Normal Information Waiting for the document log "C:\Program Files\QlikView\Examples\QvsDocuments\EPGH_Executive_Summary_2009.qvw.log" to become available..
1002851 2009-11-16 06:55:04 Normal Information The Source Document is being reloaded. DocumentPath=C:\Program Files\QlikView\Examples\QvsDocuments\EPGH_Executive_Summary_2009.qvw
1002852 2009-11-16 06:55:04 Normal Information The Source Document reload complete. DocumentPath=C:\Program Files\QlikView\Examples\QvsDocuments\EPGH_Executive_Summary_2009.qvw
1002853 2009-11-16 06:55:04 Normal Information Memory Allocation Delta for this file=-2.99 Mb. Available Physical Memory Before Reload=4035.22 Mb. Available Physical Memory After Reload=4037.96 Mb. Total Physical Memory=4037.96 Mb.
1002854 2009-11-16 06:55:04 Normal Error The Source Document was NOT reloaded successfully. DocumentPath=C:\Program Files\QlikView\Examples\QvsDocuments\EPGH_Executive_Summary_2009.qvw. Errors: 5 ScriptError: General ODBC Error, ScriptErrorList: General ODBC Error General ODBC Error General ODBC Error General ODBC Error General ODBC Error , ScriptErrorDetails=ODBC connection failed
1002856 2009-11-16 06:55:24 Normal Information Document log "C:\Program Files\QlikView\Examples\QvsDocuments\EPGH_Executive_Summary_2009.qvw.log" was not found / not updated. Skipped.
1002858 2009-11-16 06:55:25 Normal Information ReloadASync completed
1002860 2009-11-16 06:55:25 Normal Information Checkin
1002861 2009-11-16 06:55:25 Normal Information Closing QlikView Engine
1002863 2009-11-16 06:55:25 Normal Information Closing the Source Document. DocumentPath=C:\Program Files\QlikView\Examples\QvsDocuments\EPGH_Executive_Summary_2009.qvw
1002864 2009-11-16 06:55:25 Normal Information The Source Document was closed successfully DocumentPath=C:\Program Files\QlikView\Examples\QvsDocuments\EPGH_Executive_Summary_2009.qvw

[kji]

Are both the publisher and the manual reload 32 or 64 bit version, if they are different this is most likely the problem since 32-bit ODBC drivers will only work with 32-bit executables and similarly for 64-bit.

[#3]

Qlikview Publisher and Designer both are 32bit version and the driver is also 32 bit ODBC drivers.

Could you please help me to understand the following line in the log file:

1002853 2009-11-16 06:55:04 Normal Information Memory Allocation Delta for this file=-2.99 Mb. Available Physical Memory Before Reload=4035.22 Mb. Available Physical Memory After Reload=4037.96 Mb. Total Physical Memory=4037.96 Mb.
1002854 2009-11-16 06:55:04 Normal Error The Source Document was NOT reloaded successfully. DocumentPath=C:\Program Files\QlikView\Examples\QvsDocuments\EPGH_Executive_Summary_2009.qvw. Errors: 5 ScriptError: General ODBC Error, ScriptErrorList: General ODBC Error General ODBC Error General ODBC Error General ODBC Error General ODBC Error , ScriptErrorDetails=ODBC connection failed

The one that talks abt "Memory allocation Delta" giving a negative value.

Thanks,

Jinisha Joseph

[lhr]

i think the negative delta is unrelated to the error and nothing to worry about.

is it possible to (on the same machine) open the qvw in desktop qlikview and attempt a reload? chances are you get a bit more verbose error reporting for further investigation.

cheers,

lars

[Bill_Britt]

Check your ODBC driver and make sure when you created it on the server, you didn't create it as a user DSN. Need to be a system DNS.

[#6]

The manual reload from the qvw file is working perfectly fine. Only the publisher is throwing the error.

Is there some known issues in using Oracle 10G with Qlikview. This reload with publisher was working perfectly fine with Oracle 9. Only after the upgrade to 10G the problem started.

Thanks,

Jinisha Joseph

[lhr]

as i think bbt was aiming at, it might be something with lacking permissions on the odbc for the account running the qlikview batch (which is the same as the account running the execution service).

cheers,

lars

[Bill_Britt]

Take a look at this.. This is what I use for setup of Orcale on QVS.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/12/2063.A-QlikView-Connection-to-Oracle.doc:550:0]