How can I see that a Qlik Compose project is active and running after I deployed it successfully? After my deployment, I'm not able to see my project running in the monitor section.
Since Replicate is generally used to load to the target in near to real-time , it is not advisable to try to execute every time Replicate loads data into the target.
Rather, the best approach is to define a workflow (if needed to run the CDC ETL and then Data Mart), and schedule that task to run every X. For example every 15 minutes. When executing, Compose will detect via the _CT tables if there is data to be loaded and only process tables that have data waiting to be processed. (This is via the CDC tasks).
Note, that if you are using Replicate for FULL LOAD only - i.e. to load a file to your DW, then instead of scheduling in Replicate, you can assign a Landing area in Compose to that task, and have Compose orchestrate the Replicate full load job, followed by the DW / DM ETL processes via a Workflow. This is ONLY available for full load tasks as they have a discrete START and STOP (whereas CDC tasks in Replicate are continuously running).
After a deploying a project into another project, Validate Database and Model
To avoid recreating Datawarehouse/DM objects check the option "Generate DDL but do not run them in Project settings" and create the Datawarehouse. Generate the task statements and validate.
@kavitha1312 You should be able to see the project in the UI if the project is deployed successfully. From your description, it sounds like the deployment didn't go thru successfully.
I would suggest you check on these:
1. Check the Compose installation data folder for the project name that you deployed. The default location is C:\Program Files\Qlik\Compose\data\projects\your_project_name
2. If your compose log is set to verbose then you can also check the COmpose log to see if the deployment was successful
3. If your project folder exists as mentioned in the first step, then I would suggest you run the below command from the installation Bin folder. If the deployment is successful then you should see the project name stating it was upgraded successfully. The below upgrade command will just sync all the projects.
For example:
C:\Program Files\Qlik\Compose\bin>composecli upgrade Executing ComposeCliUpgradeProject command. Repository "GlobalRepo.sqlite" has been successfully upgraded. Upgrading project "Project_1" Repository "ProjectRepo.sqlite" has been successfully upgraded. Repository "ProjectRepoRuntime.sqlite" has been successfully upgraded. All the Repositories and its ingredients are upgraded to latest version. Compose Control Program completed successfully.
If none of the above works please open a support case so we can check it in detail and provide the right solution/answer.
Hi Nanda, Thanks for your response. We checked on our side and it looks like our project got deployed successfully but we still don't see the task running in the monitor section. Can you please arrange a call so that I can show you what issue I'm seeing? Thanks Kavitha
Hi Suresh, Thanks for your response. Yes, I manually ran the project after deployment and it was successful. So, do we need a third party scheduler for Qlik Compose to automatically run the project whenever there are changes on the source side in Qlik Replicate?
Hi Shashi, I knew about Qlik Compose scheduling but I don't want to schedule the project for a certain time or interval. I want the project to automatically run every time the replicate task loads new data into source tables. Is this possible in Qlik Compose? Thanks Kavitha
