11 Replies Latest reply: Sep 5, 2012 1:55 PM by John Lifter RSS

    How to get a licence file for Expressor Desktop Studio edition?

    Diamantis Archontoglou

      How can we get a license file for expressor desktop?

      We need to copy it into "all users" application data so publisher or server can find it, right?

        • Re: How to get a licence file for Expressor Desktop Studio edition?
          Michael Tarallo

          Hello Diamantis,

           

          Desktop Only use - does not require a license - it is free to use - for local creation and execution; very similiar to how QlikView Personal Edition is used today.

           

          If you want to explore past Desktop and unlock additional features that include Teradata Parallel Transport operator, Repository and server side enginer thne a license is provided by our sales and services team. Are you interested in a trial license? If so I will alert our team to facilitate this request.

           

          When using Desktop - if you receive a license - then you would just paste the key (long character string) into the license dialog available under the help menu License item.

           

          license.PNG

           

          When installing the software full version - you have a choice of what components to install. We have had customers install the full version on the server side - including Desktop, Repository and Engine - the license for the server can also be enabled by simply placing the key in the license dialog within the Desktop software running on the same machine as the engine / repository.

           

          http://documentation.qlik.com/expressor/3.7/expressor_3.htm

           

          install.png

           

          If you choose to only install the Engine or Repository without Desktop on the server / engine machine - then there is a command to execute named elicense

           

          http://documentation.qlik.com/expressor/3.7/expressor_command_line_utilities/elicense_command_line_utility.htm

           

          elicense.PNG

           

          Please note that paid versions will require a specific "node-locked" license - which will require you to send information back to our team so a license can be created for you - when that time is appropriate.

           

          Please let us know how you do.

           

          Mike T

            • Re: How to get a licence file for Expressor Desktop Studio edition?
              Diamantis Archontoglou

              Hello

               

              In the desktop installation document there is the following info:

               

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------

              The QlikView Expressor Connector does not require a license. It is available to the QlikView business discovery

              software when the Desktop Edition is installed on the same system.

              Note: Before Connector can be run from QlikView Publisher, the license for Standard, Enterprise, or

              Desktop must be copied from "C:\AppData\Roaming\expressor\Engine.lic" to

              "C:\Users\All Users\Application Data\expressor\Engine.lic." Even though the Desktop Edition does

              not require the user to install a license, it does have a license file that can be moved to enable use of

              the Connector by QlikView Publisher. The Publisher runs as a service and so does not have a "current

              user" location.

              ---------------------------------------------------------------------------------------------------------------------------------------------------------------

               

              I have developed a qvw that runs a package with QV Connector and runs perfect. When i schedule it in the

              server the task fails. I assumed that is due to the fact that the .lic file is missing...

               

              Is it missing or not?

                • Re: How to get a licence file for Expressor Desktop Studio edition?

                  Diamantis:

                   

                  The free desktop version of Expressor will work with the QlikView Connector without an additional license, which means that a QlikView script may use an Expressor application as a data source.  When the QlikView script executes it in turn causes the Expressor dataflow to run.  The Expressor dataflow writes data to a .qvx file, which is then read by the QlikView script.

                   

                  So, the value of the Expressor application is that it provides a way for a QlikView script to ensure that the loaded data is the most up-to-date as it can be.

                   

                  You must install the Expressor desktop edition onto the same computer that is running the QlikView script.  Additionally, the Expressor application must be 'compiled' into an artifact called a deployment package.  The QlikView script then runs the 'compiled' dataflow that is in the deployment package.

                   

                  From your posting, it appears that you have done everything correctly to create the Expressor application and test it from a QlikView script.  Is Expressor installed onto the same computer as the one running QlikView?

                    • Re: How to get a licence file for Expressor Desktop Studio edition?
                      Diamantis Archontoglou

                      Yes both are installed on the same Server.

                      I have the following log:

                       

                       

                      (2012-08-27 12:29:25) Information: Starting task 'QLIK-Docs/expressor/DCW_PurchaseInvoices.qvw'. Id:ed6cf461-7745-496f-bae3-ba5874f083b1. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

                      (2012-08-27 12:29:25) Information: Entering Task Execution.

                      (2012-08-27 12:29:25) Information: ClusterID=1

                      (2012-08-27 12:29:25) Information: QDSID=ac58aeec-1441-e93e-0abd-145461987bcb

                      (2012-08-27 12:29:25) Information: TaskID=ed6cf461-7745-496f-bae3-ba5874f083b1

                      (2012-08-27 12:29:25) Information: MaxRunTime=06:00:00

                      (2012-08-27 12:29:25) Information: MachineName=PC116

                      (2012-08-27 12:29:25) Information: Max attempts:1

                      (2012-08-27 12:29:25) Information: Current Attempt=0

                      (2012-08-27 12:29:25) Information: Task Dependencies are OK

                      (2012-08-27 12:29:25) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

                      (2012-08-27 12:29:25) Information: Opening "D:\QlikView_DATA\Documents\QLIK-Docs\expressor\DCW_PurchaseInvoices.qvw"

                      (2012-08-27 12:29:25) Information: Allocating new QlikView Engine. Current usagecount=1 of 2

                      (2012-08-27 12:29:25) Information: Max retries:5

                      (2012-08-27 12:29:25) Information: Attempt:01

                      (2012-08-27 12:29:25) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 2, Ticket=2

                      (2012-08-27 12:29:25) Information: Loading document "D:\QlikView_DATA\Documents\QLIK-Docs\expressor\DCW_PurchaseInvoices.qvw" (0.24 Mb)

                      (2012-08-27 12:29:26) Information: Physical FileSize=0.24 Mb. Memory Allocation Delta for this file=1.36 Mb. Available Physical Memory Before Open=2397.86 Mb. Available Physical Memory After Open=2394.45 Mb. Total Physical Memory=3454.25 Mb.

                      (2012-08-27 12:29:26) Information: Attempted to load the document without data.

                      (2012-08-27 12:29:26) Information: The document was loaded successfully.

                      (2012-08-27 12:29:26) Information: Document was opened successfully

                      (2012-08-27 12:29:26) Information: Starting reload

                      (2012-08-27 12:29:26) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

                      (2012-08-27 12:29:26) Information: The Source Document is being reloaded. DocumentPath=D:\QlikView_DATA\Documents\QLIK-Docs\expressor\DCW_PurchaseInvoices.qvw

                      (2012-08-27 12:29:27) Information: Reloading.

                      (2012-08-27 12:29:27) Information: The Source Document reload complete. DocumentPath=D:\QlikView_DATA\Documents\QLIK-Docs\expressor\DCW_PurchaseInvoices.qvw

                      (2012-08-27 12:29:27) Information: Memory Allocation Delta for this file=0.39 Mb. Available Physical Memory Before Reload=2394.41 Mb. Available Physical Memory After Reload=2381.50 Mb. Total Physical Memory=2381.50 Mb.

                      (2012-08-27 12:29:28) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\QlikView_DATA\Documents\QLIK-Docs\expressor\DCW_PurchaseInvoices.qvw.

                      (2012-08-27 12:29:28) Information: Closing the document.

                      (2012-08-27 12:29:28) Information: Closed the QlikView Engine successfully. ProcessID=3820

                      (2012-08-27 12:29:28) Error: The task "QLIK-Docs/expressor/DCW_PurchaseInvoices.qvw" failed. Exception:

                      (2012-08-27 12:29:28) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=D:\QlikView_DATA\Documents\QLIK-Docs\expressor\DCW_PurchaseInvoices.qvw.

                      (2012-08-27 12:29:28) Error:    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

                      (2012-08-27 12:29:28) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

                      (2012-08-27 12:29:28) Error:    --- End of inner exception stack trace ---

                      (2012-08-27 12:29:28) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

                      (2012-08-27 12:29:28) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

                      (2012-08-27 12:29:28) Error:    --- End of inner exception stack trace ---

                      (2012-08-27 12:29:28) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

                      (2012-08-27 12:29:28) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

                      (2012-08-27 12:29:28) Information: Task Execute Duration=00:00:03.0312500

                      (2012-08-27 12:29:28) Information: Sending Alert mail

                      (2012-08-27 12:29:30) Warning: Failed to send mail to diamantis_archontoglou@athentis.eu

                      (2012-08-27 12:29:30) Information: TaskResult.status=Finished

                      (2012-08-27 12:29:30) Information: Notifying all triggers of new state:FinishedWithErrors

                      (2012-08-27 12:29:30) Information: Notifying all triggers of new state:FinishedWithErrors - completed

                      (2012-08-27 12:29:30) Information: Saving Task Result

                       

                      Last updated @ 27/8/2012 4:51:06 μμ


                • Re: How to get a licence file for Expressor Desktop Studio edition?

                  The free QlikView Expressor download does not require licensing.  The discussion of licensing that is in the documentation refers to the Standard and Enterprise editions of Expressor, which do require a purchased license.

                   

                  With the free version of Expressor, you can develop and test your applications.  Additionally, you can integrate your Expressor applications with a QlikView application as long as the QlikView data load is executed from QlikView Desktop or QlikView Personal Edition.

                   

                  To integrate Expressor with QlikView Server or Publisher requires a purchased Expressor license for either Standard or Enterprise editions.  Once you receive the purchased license, you use the elicense command to install onto the computer hosting Expressor.  QlikView Connector, the Expressor component that integrates Expressor with QlikView, looks for a valid purchased license before it allows a QlikView script running from within Server or Publisher to execute an Expressor dataflow.

                   

                  To enable QlikView Connector integration with Server/Publisher, copy, if necessary, the license file into the following directories.

                  Windows 7, Windows Server 2008: C:\ProgramData\expressor

                  Windows XP: :\Documents and Settings\All Users\Application Data\expressor