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

[#1]

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?

[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.

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

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_u...

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

[#3]

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?

[#4]

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?

[#5]

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 μμ Automatic refresh of task list Refresh

[#6]

Diamantis:

Please confirm if I understand correctly.

1. Expressor is installed onto the same computer as QlikView
2. You successfully developed and tested an Expressor Dataflow
3. The Dataflow was successfully run from a QlikView script when run from QlikView Developer/Desktop
4. The Dataflow does not run when the QlikView script is executed from QV publisher or QV server.

Is this correct?

[Michael_Tarallo]

Diamantis:

What version of QlikView Expressor are you using 3.7.0 or 3.7.1? - I have been told that there is an issue with 3.7.0 when running the QV Conenctor form Publisher and that this is solved with version 3.7.1.

Regards,

Mike T

[#8]

Hello Michael:

I am running QV Server V11 SR1 and Expressor 3.7.1.

I do not have publusher installed however. The task runs from standard QV Server.

[#9]

John:

I confirm the situation is as described by you.

Could this be the case as described in the installation manual?

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.

Message was edited by: Diamantis Archontoglou

[Michael_Tarallo]

Hello Diamantis ,

I sent your inquireis to our engineering group. Someone should respond shortly.

Regards,

Mike T