Re: Reload from server doesn't complete, but is OK... - Qlik Community

iliyansomlev · ‎2013-01-17

Hi, dear community,

I read a lot about the issue on the forum and did all suggestions given, stil am not able to fix this.

I have an app that reloads for 13 seconds from Desktop client (11440 - QV11, SR2) but when started from the reload engine on the server (with no Publisher license) (also 11440-QV11, SR2), the status shows running forever (the qvb.exe process shows 0 for processor time and the process qvconnect32.exe does not close when I abort the task but hangs (please see the attached pic taken while the task was Running).

I am on Windows 2003 SP 2 OS, 32 bit. The connection is OLEDB to Oracle DB. There are two ways to build the connection

1) via Microsoft OLEDB provide for Oracle - OLEDB CONNECT32 TO [Provider=MSDAORA.1;User ID=*;Data Source=*] (XPassword is *);

2) via Oracle provider for OLEDB - OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=*;Data Source=*;Extended Properties=""] (XPassword is *); (Oracle client is installed on the machine)

Both work fine and reload from the Desktop version of QV on this server. The first fails right after the start of Task reload on the server. The generated log file says:

17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: Execution started.
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: QlikView Version:11.0.11440.0
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: CPU Target x86
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: Operating System Microsoft Windows Server 2003 Service Pack 2 (32 bit edition)
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: Wow64 mode Not using Wow64
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: MDAC Version 2.82.3959.0
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: MDAC Full Install Version 2.82.3959.0
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: PreferredCompression 2
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: EnableParallelReload 1
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: ParallelizeQvdLoads 1
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: AutoSaveAfterReload 0
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: BackupBeforeReload 0
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: EnableFlushLog 0
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: SaveInfoWhenSavingFile 0
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: UserLogfileCharset 0
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: OdbcLoginTimeout -1
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: OdbcConnectionTimeout -1
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: ScriptWantsDbWrite false
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: ScriptWantsExe false
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: LogFile CodePage Used: 1251
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: 0002 SET ThousandSep=' '
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: 0003 SET DecimalSep='.'
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: 0004 SET MoneyThousandSep=' '
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: 0005 SET MoneyDecimalSep='.'
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: 0006 SET MoneyFormat='# ##0.00 ��;-# ##0.00 ��'
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: 0007 SET TimeFormat='hh:mm:ss'
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: 0008 SET DateFormat='DD/MM/YYYY'
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: 0009 SET TimestampFormat='DD/MM/YYYY hh:mm:ss'
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: 0010 SET MonthNames='��;��;��;��;��;��;��;��;��;��;��;��'
17/01/2013 18:29:14.2343750	Information	17/01/2013 18:29:14: 0011 SET DayNames='��;��;��;��;��;��;��'
17/01/2013 18:29:14.6718750	Information	17/01/2013 18:29:14: 0013 OLEDB CONNECT32ProviderXPassword*
17/01/2013 18:29:14.6718750	Information	17/01/2013 18:29:14: Error: ErrorSource: Microsoft OLE DB Provider for Oracle, ErrorMsg: Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.
17/01/2013 18:29:14.6718750	Information	17/01/2013 18:29:14:
17/01/2013 18:29:14.6718750	Information	17/01/2013 18:29:14: Provider is unable to function until these components are installed.
17/01/2013 18:29:14.6718750	Information	17/01/2013 18:29:14: General Script Error
17/01/2013 18:29:14.6718750	Information	17/01/2013 18:29:14: Execution Failed
17/01/2013 18:29:14.6718750	Information	17/01/2013 18:29:14: Execution finished.

The second reload from server never stops except if I don't terminate it, the log file says then:

17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: Execution started.
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: QlikView Version:11.0.11440.0
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: CPU Target x86
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: Operating System Microsoft Windows Server 2003 Service Pack 2 (32 bit edition)
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: Wow64 mode Not using Wow64
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: MDAC Version 2.82.3959.0
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: MDAC Full Install Version 2.82.3959.0
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: PreferredCompression 2
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: EnableParallelReload 1
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: ParallelizeQvdLoads 1
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: AutoSaveAfterReload 0
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: BackupBeforeReload 0
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: EnableFlushLog 0
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: SaveInfoWhenSavingFile 0
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: UserLogfileCharset 0
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: OdbcLoginTimeout -1
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: OdbcConnectionTimeout -1
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: ScriptWantsDbWrite false
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: ScriptWantsExe false
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: LogFile CodePage Used: 1251
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: 0002 SET ThousandSep=' '
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: 0003 SET DecimalSep='.'
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: 0004 SET MoneyThousandSep=' '
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: 0005 SET MoneyDecimalSep='.'
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: 0006 SET MoneyFormat='# ##0.00 ��;-# ##0.00 ��'
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: 0007 SET TimeFormat='hh:mm:ss'
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: 0008 SET DateFormat='DD/MM/YYYY'
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: 0009 SET TimestampFormat='DD/MM/YYYY hh:mm:ss'
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: 0010 SET MonthNames='��;��;��;��;��;��;��;��;��;��;��;��'
17/01/2013 18:04:45.7812500	Information	17/01/2013 18:04:45: 0011 SET DayNames='��;��;��;��;��;��;��'

It has stopped to the establishing the connection. Just like the hanging connect32.exe process (in the attched pic) suggests. I have tried running the QV.exe and this app from the QVService user and this user also reloads fine with Desktop client.

What could be the problem? I would appreciate any help.

Thanks,

Iliyan

iliyansomlev · ‎2013-01-18

Do you have any suggestions?

Could this happen because the user QVService is not a domain user and so doesn't see the other computers in the network, incl. the one with Oracle DB? But why then reload from Desktop when QV.exe is started with the same QVService user works fine? What can I do to solve this issie?

Bill_Britt · ‎2013-01-18

The best way to try and find the issue is to login as the account that the services are running under. Open the QVW and try a reload. This interaction will show you the error. Most of the time it is a rights issues or a misconfigured ODBC connection (setup as User and nto system DSN).

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

iliyansomlev · ‎2013-01-18

Thank you for your answer. I have tried login as QVService and opening the app locally and reload runs fine. I have a new info: I established ODBC connection as well (the above was about OLEDB with 2 different providers) and it also reloads fine with desktop but gives following error in Server reload (copied from the log file at the place after SET Date is executed and server reaches the Connection string:

18/01/2013 14:47:17.6093750	Information	18/01/2013 14:47:17: 0010 SET MonthNames='��;��;��;��;��;��;��;��;��;��;��;��'
18/01/2013 14:47:17.6093750	Information	18/01/2013 14:47:17: 0011 SET DayNames='��;��;��;��;��;��;��'
18/01/2013 14:47:17.9375000	Information	18/01/2013 14:47:17: 0015 ODBC CONNECTXUserIdXPassword*
18/01/2013 14:47:17.9375000	Information	18/01/2013 14:47:17: Error: SQL##f - SqlState: IM004, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
18/01/2013 14:47:18.0468750	Information	18/01/2013 14:47:17: General Script Error
18/01/2013 14:47:18.0468750	Information	18/01/2013 14:47:17: Execution Failed
18/01/2013 14:47:18.0468750	Information	18/01/2013 14:47:17: Execution finished.

Could it be that the user QVService has no rights upon certain drivers? But why then the same user successfully reloads the app locally in all the three ways?

Bill_Britt · ‎2013-01-18

I think your problem is that your Oracle drivers are not setup correct. I am going to attach an old document and it is my understanding that the instructions are still go, you just need to download the current driver version.

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

iliyansomlev · ‎2013-01-18

Hi, thank you for the detailed document. I asked our IT head to reinstall the drivers (on our server the Oracle client 10G was reinstalled), but still reload through the server (both with OLEDB and ODBC connections) fails. We will restart the services (also using another, a domain user account - in place of QVService that is a local machine account/administrator - to run QV services) and computers and check through other means to find solution. Is it possible that QV doesn't support the connector when OS is Windows 2003 (too old)? Our server OS is Win 2003 (32 bit).

I think to post the case with QT support if by Monday we haven't found a way to use our server.

Report Inappropriate Content · ‎2014-01-10

Open the ODBC administrator. test the connection. Leave the 'Oracle ODBC Driver Configuration' window open after you confirm success.

Now run the reload.

Works for me.... Probably should update to 11g?

Report Inappropriate Content · ‎2015-06-17

Iliyan,

Were you able to fix the issue? I am hitting the same issue on my prod server QV11 on Win2012. Please share your thoughts/solution.

Thanks,

Achal

Report Inappropriate Content · ‎2015-06-18

We got this issue resolved by completely restarting the windows server - shudown and then start.

Reload from server doesn't complete, but is OK from desktop