Hi Support,

We have recently seen an issue where the Qlik Enterprise Manager service fails to start with the QEM logs indicating the following error:
"[ERROR] REPO-E-FACSQLREP, Failed to connect to SQLite repository 'C:\Program Files\Attunity\Enterprise Manager\data\rtdata.sqlite' "

We were able to resolve the issue by stopping the QEM service and renaming the rtdata.sqlite file to rtdata_old.sqlite, and then renaming the rtdata.new.sqlite file to rtdata.sqlite. After then running the command to upgrade the repository (aemctl.exe repository upgrade), the QEM service was able to run and the console could be accessed.

Previously when we have seen an issue with a data repository file it has been a result of memory or disk space issues on the server. However, in this case, there have been no reported memory/disk space issues on the server. What we'd like to understand is what are the possible reasons the rtdata.sqlite file becomes unreadable/corrupted.

This instance of Enterprise Manager is v2023.11.0.259

Thanks,

Nak

How do I keep two tables separately when uploaded?  Each table is a separate Excel file (Feb.xls and March.xls).  Row heading and columns are the same on both files except data are different (production numbers).  I created a new App.  Then uploaded two separate files.  But both gets combined into one table once uploaded.  Instead of seeing two Bubbles, I see one Bubble in Data manager (as shown below). I would like to see each table separately with two Bubbles in a Data Manager. One for Feb and one for March.  Thank you.   

Hi qlik community,

Could you please confirm whether we need separate licenses for configuring the high availability environments for Qlik Replicate, Talend (TAC + Job Server), and Qlik NPrinting?

Regards,

Nilesh

Hello...

I'm trying to publish an app from a shared space to a managed space.

Using, Rest, Qlik CLI, and Qlik SDK I'm getting the same 404 error. I created an automation and that worked okay.

When I go to the URL for the app its fine, I return the json. Same if I look at /scripts, that works fine too

However when I look at 

https://xxxxxxx.us.qlikcloud.com/api/v1/apps/73b24e00-bf66-4228-8065-44d55eb5ba7b/publish

I get a 404 error, which is the same error all the API are returning.

Everything else seems to be working fine, does anyone know why there's a 404 on this page?

qlik app publish create 73b24e00-bf66-4228-8065-44d55eb5ba7b --spaceId="66311b85b13342805b11e332" -v

Response time: 643ms
Status: 404 Not Found
Error: 404 - Not Found (empty response)

Space details:

"createdAt": "2024-04-30T16:25:41.937Z",
"createdBy": "6580520ea968030de1483f82",
"description": "",
"id": "66311b85b13342805b11e332",
"meta": {
"actions": [
"change_owner",
"create",
"delete",
"read",
"update"
],
"assignableRoles": [
"basicconsumer",
"consumer",
"contributor",
"dataconsumer",
"facilitator",
"operator",
"publisher"
],
"roles": []
},
"name": "Managed",
"ownerId": "6580520ea968030de1483f82",
"tenantId": "xxxxxxxxxxxxxxxxxxxxxxxx",
"type": "managed",
"updatedAt": "2024-04-30T16:25:41.937Z"
}

Application details

{
"attributes": {
"_resourcetype": "app",
"createdDate": "2024-04-30T15:57:28.367Z",
"custom": {},
"description": "XXXXX",
"dynamicColor": "",
"encrypted": true,
"hasSectionAccess": false,
"id": "73b24e00-bf66-4228-8065-44d55eb5ba7b",
"isDirectQueryMode": false,
"lastReloadTime": "2024-04-30T17:03:42.230Z",
"modifiedDate": "2024-04-30T17:03:43.153Z",
"name": "Data Gateway",
"originAppId": "",
"owner": "",
"ownerId": "6580520ea968030de1483f82",
"publishTime": "",
"published": false,
"spaceId": "66311ae57c1e52122254af4d",
"thumbnail": "",
"usage": "ANALYTICS"
},
"create": [
{
"canCreate": true,
"resource": "sheet"
},
{
"canCreate": true,
"resource": "bookmark"
},
{
"canCreate": true,
"resource": "snapshot"
},
{
"canCreate": true,
"resource": "story"
},
{
"canCreate": true,
"resource": "dimension"
},
{
"canCreate": true,
"resource": "measure"
},
{
"canCreate": true,
"resource": "masterobject"
},
{
"canCreate": true,
"resource": "variable"
}
],
"privileges": [
"read",
"update",
"delete",
"export",
"change_owner",
"export_reduced"
]
}

Hi Team,

We have requirement to Filter Common records in Qlik Report based on multi values selected in 1 selection filter.

If it is possible thus Please suggest any solution.

Thanks

Manish Arora

Hi Team, 

We are in initial phase to move our Qlik sense enterprise applications on to the SaaS tenant . The very basic query we are struggling with alerting on application failure. On existing Sense enterprise platform (GCP machine) we have separate feature  to read the application reload logs and generate the alert on failures. For SaaS based application also we want to get alerting through existing mechanism.

is there any way to get the app reload logs out of SaaS tenant and store on the GCP platform ?

Hello everybody, I am using qlik cloud and I want to achieve an expression that calculates the number of teus per day but disregards any current date selections. I am currently using the following expression that considers the date selections: Avg( Aggr(TEU, TRACER_USER_ID, (DATE)) ). So, if I have for example a period of 2 months selected I want my expression to be able to calculate the average number of TEU's per day but for the complete period and not only for those 2 months.