Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

iliyansomlev
Contributor

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

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.2343750Information17/01/2013 18:29:14:      Execution started.
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      QlikView Version:11.0.11440.0
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      CPU Target                    x86
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      Operating System              Microsoft Windows Server 2003 Service Pack 2 (32 bit edition)
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      Wow64 mode                    Not using Wow64
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      MDAC Version                  2.82.3959.0
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      MDAC Full Install Version     2.82.3959.0
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      PreferredCompression          2
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      EnableParallelReload          1
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      ParallelizeQvdLoads           1
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      AutoSaveAfterReload           0
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      BackupBeforeReload            0
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      EnableFlushLog                0
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      SaveInfoWhenSavingFile        0
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      UserLogfileCharset            0
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      OdbcLoginTimeout              -1
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      OdbcConnectionTimeout         -1
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      ScriptWantsDbWrite            false
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      ScriptWantsExe                false
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14:      LogFile CodePage Used:        1251
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14: 0002  SET ThousandSep=' '
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14: 0003  SET DecimalSep='.'
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14: 0004  SET MoneyThousandSep=' '
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14: 0005  SET MoneyDecimalSep='.'
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14: 0006  SET MoneyFormat='# ##0.00 ��;-# ##0.00 ��'
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14: 0007  SET TimeFormat='hh:mm:ss'
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14: 0008  SET DateFormat='DD/MM/YYYY'
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14: 0009  SET TimestampFormat='DD/MM/YYYY hh:mm:ss'
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14: 0010  SET MonthNames='���;���;���;���;���;���;���;���;���;���;���;���'
17/01/2013 18:29:14.2343750Information17/01/2013 18:29:14: 0011  SET DayNames='����������;�������;�����;���������;�����;������;������'
17/01/2013 18:29:14.6718750Information17/01/2013 18:29:14: 0013  OLEDB CONNECT32*Provider*XPassword*
17/01/2013 18:29:14.6718750Information17/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.6718750Information17/01/2013 18:29:14:      
17/01/2013 18:29:14.6718750Information17/01/2013 18:29:14:       Provider is unable to function until these components are installed.
17/01/2013 18:29:14.6718750Information17/01/2013 18:29:14:       General Script Error
17/01/2013 18:29:14.6718750Information17/01/2013 18:29:14:       Execution Failed
17/01/2013 18:29:14.6718750Information17/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.7812500Information17/01/2013 18:04:45:      Execution started.
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      QlikView Version:11.0.11440.0
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      CPU Target                    x86
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      Operating System              Microsoft Windows Server 2003 Service Pack 2 (32 bit edition)
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      Wow64 mode                    Not using Wow64
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      MDAC Version                  2.82.3959.0
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      MDAC Full Install Version     2.82.3959.0
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      PreferredCompression          2
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      EnableParallelReload          1
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      ParallelizeQvdLoads           1
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      AutoSaveAfterReload           0
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      BackupBeforeReload            0
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      EnableFlushLog                0
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      SaveInfoWhenSavingFile        0
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      UserLogfileCharset            0
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      OdbcLoginTimeout              -1
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      OdbcConnectionTimeout         -1
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      ScriptWantsDbWrite            false
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      ScriptWantsExe                false
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45:      LogFile CodePage Used:        1251
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45: 0002  SET ThousandSep=' '
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45: 0003  SET DecimalSep='.'
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45: 0004  SET MoneyThousandSep=' '
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45: 0005  SET MoneyDecimalSep='.'
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45: 0006  SET MoneyFormat='# ##0.00 ��;-# ##0.00 ��'
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45: 0007  SET TimeFormat='hh:mm:ss'
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45: 0008  SET DateFormat='DD/MM/YYYY'
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45: 0009  SET TimestampFormat='DD/MM/YYYY hh:mm:ss'
17/01/2013 18:04:45.7812500Information17/01/2013 18:04:45: 0010  SET MonthNames='���;���;���;���;���;���;���;���;���;���;���;���'
17/01/2013 18:04:45.7812500Information17/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

Tags (3)
8 Replies
iliyansomlev
Contributor

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

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?

Employee
Employee

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

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

iliyansomlev
Contributor

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

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.6093750Information18/01/2013 14:47:17: 0010  SET MonthNames='���;���;���;���;���;���;���;���;���;���;���;���'
18/01/2013 14:47:17.6093750Information18/01/2013 14:47:17: 0011  SET DayNames='����������;�������;�����;���������;�����;������;������'
18/01/2013 14:47:17.9375000Information18/01/2013 14:47:17: 0015  ODBC CONNECT*XUserId*XPassword*
18/01/2013 14:47:17.9375000Information18/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.0468750Information18/01/2013 14:47:17:       General Script Error
18/01/2013 14:47:18.0468750Information18/01/2013 14:47:17:       Execution Failed
18/01/2013 14:47:18.0468750Information18/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?

Employee
Employee

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

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

iliyansomlev
Contributor

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

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.

Not applicable

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

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?

Not applicable

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

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

Not applicable

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

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

Community Browser