Hi,

we are facing this warning message when using the PATCH method in tRestClient:

WARNING: An illegal reflective access operation has occurred

WARNING: Illegal reflective access by org.apache.cxf.common.util.ReflectionUtil$11 (file:/C:/Program%20Files%20(x86)/Talend/studio/configuration/.m2/repository/org/apache/cxf/cxf-core/3.4.4/cxf-core-3.4.4.jar) to field sun.net.www.protocol.https.HttpsURLConnectionImpl.delegate

WARNING: Please consider reporting this to the maintainers of org.apache.cxf.common.util.ReflectionUtil$11

WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations

WARNING: All illegal access operations will be denied in a future release

We tried Open Studio and Studio Data Fabric with Zulu Version 11.

The patch is successfully executed but the warnings are still irritating.

With other methods (GET, POST, PUT) no warnings occure.

The design of the job is straight forward.

Any ideas?

Thanks

Ben

Hi,

I am looking to get different dimension values based on same ranking. So, I have created an inline view with Dim and Exp by assigning a value to each dim.

Load * Inline
[
dim, exp
'Style', '1'
'Colour', '2'
'Min Range of Month', '3'
'RRP', '4'

];

 And I am looking to bring the corresponding values thru if statement on Straight table

The below expression is not working as expected,

if(exp='1',only(if(Aggr(rank(sum(total <[Style Colour]> [Sales Amount]),4),[Style Colour]) = 1, [Style])),

if(exp='2', only(if(aggr(rank(sum(total <[Style Colour]> [Sales Amount]),4),[Style Colour]) = 1, [Colour])),

if(exp='3', only(if(aggr(rank(sum(total <[Style Colour]> [Sales Amount]),4),[Style Colour]) = 1, [Min Range Month])),
if(aggr(rank(sum(total <[Style Colour]> [Sales Amount]),4),[Style Colour]) = 1, Sum([Sales Amount]))
)
)
)

Can you please check my set analysis and advise why it's not working for other values. 

Thanks in advance.

Hi, I'm trying to connect SharePoint via Qlik Sense. Below steps i followed, 

1. Creating a new data connection. 

2. Choosing  the data source "Office 365 Sharepoint"

3. Then given the base URL of Office 365 Sharepoint in the baseURL.

4. Then choose the "None" from Prompt/Consent level. 

5. Click on Authenticate button. Then it will take to next tab and code generated. Then copied code and paste in the respective tab. Then clicked on the Authenticate tab. 

6. After that taking some time and faced the error. Below is the error message,

"error verifying: A connection attempt failed because the connected party did not properly respond after a period of time or established connection failed because connected host has failed to respond "Some IP (1.1.1.1:443)"

kindly suggest

Hi Team,

I have this below code to get the task list from QEM. 

# Define the URL for the API call
$url = "https://computer.network.net/attunityenterprisemanager/api/v1/servers/myrepsrv1/tasks"

# Prepare the headers for the API call, specifically the session ID
$headers = @{
"EnterpriseManager.APISessionID" = "wCo0_KvjEUFROvfHF5KGrw"
}

# Make the HTTP GET request and ignore SSL certificate validation errors
try {
$response = Invoke-WebRequest -Uri $url -Headers $headers -Method Get -SkipCertificateCheck

# Check if the request was successful (status code 200)
if ($response.StatusCode -eq 200) {
Write-Output "Tasks retrieved successfully:"
Write-Output $response.Content # Print the response content which includes the task list
} else {
Write-Output "Failed to retrieve tasks, status code: $($response.StatusCode)"
}
} catch {
Write-Output "An error occurred: $_"
}

how to find Session ID of QEM? Pls suggest.. Also I need last week task list using the same.

thanks

Vish123

Dear all

We have successfully upgraded PostgreSQL with 14 version.

Everything running fine but only one thing I have noticed about the postgres service user running this service

 By default "Log On showing as" network service, is it normal ? or do we need to change its user as service account user running all other qliksense services?

I have been trying to create a report using the excel tabular reporting, that creates a new sheet for each Sales Person. To do this I have been trying to use the pages option.

It appears that this works fine for the straight table that is used for the report (i.e. it creates a sheet for each sales person with a straight table on it and the data filtered for each sales person).

However, I need the chart to be shown as a pivot table and if I use the pages option on the pivot table it doesn't seem to work? I end up with a sheet created for each Sales Person (i.e. the tab of the sheet is named correctly for each sales person) but the data within each sheet is not filtered to each Sales Person, all sheets created show the same data on the pivot table which is for the first Sales Person only. 

Can someone advise if what I am attempting to do is actually possible? 

Thanks. 

HI ,

Please refer the below Snap shot . I need the help to calculate 'Active' Count from the expression field.

Can anybody solve this problem.