We need to whitelist Engines running  jobs that connect to SQL server that uses IP white listing. We don't see to be able to fine anywhere the IP addresses in use?

We have:

I have a pivot table that has a date picker. When the pivot opens, it goes to the lowest date in the date picker.

I would like it to open based on the max date pivot. The report has 45 rolling calendar dates.

I really appreciate any help you can provide.

using the diagnose claim link: /api/v1/diagnose-claims I do not see the group claim under mapped claims.  is this a configuration issue with Okta? What are some troubleshooting steps? 

Hi,

we have users with the full level authorization, so they can create their own charts.

In our data model we have two fact tables (say purchases and sales) and sometimes the users will create charts picking dimensions and measures from both tables.

This creates a spike in the server RAM, because the specific combination of dimensions and measures creates a cross join.

Can we use a preemptive control to avoid this situation? It would be nice to put a memory limit on the specific charts or, even better, to prohibit specific dimensions and measures combinations.

Thanks

Fabiano

Hi, Community

I need help : 

When I run an sql script in "Oracle sql Developper" it takes 2 minutes to return result, but same script running in "Qliksens" runs endlessly, without result, which imposes cancellation.

Has anyone experienced this problem? How can it be solved?

thanks in advance.

the sql script : 

select * from

(

select /*+parallel(8)*/

trunc(oc_recordtimestamp) dates,

to_char (oc_recordtimestamp,'DAY') DAY_,

to_char(oc_recordtimestamp,'hh24') hours,

round(SUM(OC_TOTAL_USED_DURATION)/60,2) as  MINUTES

 from  ods.fct_cc_ccs_cdr_new   t,

       ods.Ref_At_Account_Type        v,

       ods.Ref_Tip_Transaction_Prefix w,

       ods.Ref_Prd_Product,

       insight.f_rt_record_type       y

 where f_rt_seqid = rt_seqid(+)

   and ref_at_id = at_id(+)

   and ref_tip_id = tip_id(+)

   and ref_prd_id = prd_id(+)

      and oc_recordtimestamp >=trunc(sysdate)

     and rt_common_code in ('VOICE')

and at_id not in ('10946','10903','10947')

GROUP BY trunc(oc_recordtimestamp) ,

to_char(oc_recordtimestamp,'hh24') ,

to_char (oc_recordtimestamp,'DAY')

union all

select

DATES,

to_char (dates,'DAY') DAY_,

HOURS,

sum(minutes) as Minutes

from  voice_openet

where DATES>=trunc(sysdate)-30

and charge_type='InB'

and to_char (dates,'DAY')=to_char(sysdate,'DAY')

group by DATES,to_char (dates,'DAY'),

HOURS)

Hi,

Facing error  "Failed to write record id: x, Number of values: y is not equal to number of columns: z" .   When Qlik is reading the file and at the same time , file is being overwritten by another job.

So is there any setting in the replicate, to lock the file while reading by replicate.

Thanks.

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"
]
}

Does the users API support sending multiple roles on a user create post call? The documentation only shows an example with one name in assignedRoles.  

Hello there,

Can anyone please show how to analyse the "Coredump..." files found in the C >ProgramData>Qlik>Sense>Engine>CrashDumps folder in an enterprise environment?

A typical file will have the following:

[ContextInfo]

Integrity=2

NbrActiveRequests=8

.... etc

How can I load these files, and load the fields in a table format in a Qlik Sense app?

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.