8 Replies Latest reply: Jun 18, 2015 4:25 PM by Achal Anjaria RSS

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

    Iliyan Somlev

      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

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

          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?

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

            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

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

                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?

              • 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?

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

                  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