Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have deployed the app Application Automations Monitoring v1.1 in the SaaS tenant and was reloading successfully till last month.
Now, the reload fails with error below. No changes have been made to the data connection.
Any ideas on how to fix it?
Hi, I'm working in Talend Studio, and I need to run 2 jobs which contain data services at the same time to test a route. I get an error because they cannot be run in same port (8090). Is there any way to set a different port when you run a data service?
Error message:
Endpoint deployed at: <localhost>:8090/ <myEndPoint>
[statistics] connecting to socket on port 3717
Exception in component tRESTRequest_1_Loop (<myDataService>)
java.lang.IllegalArgumentException: Cannot start provider with uri: <localhost>:8090/ <myEndPoint>. Port 8090 already in use.
at XXXXXXX.<myDataService>.checkEndpointUrl(<myDataService>.java:1250)
at XXXXXXX.<myDataService>.tRESTRequest_1_LoopProcess(<myDataService>.java:5300)
at XXXXXXX.<myDataService>.runJobInTOS(<myDataService>.java:6863)
at XXXXXXX.<myDataService>.main(<myDataService>.java:6171)
We wanted to Convert a numeric value to String and then check the length of the string and if it exceeding 255 we need to get first 255 char or we need to load it as it is.
Below is the Code we are using , the case statement is working as the data is coming as numeric the code is failing
case when
length($code_value) > 255 then substr($code_value,1,instr($code_value, ";")+250)
else
$code_value
end
Is there a way we convert numeric to string.
We run Replicate and Compose on-prem, writing to a SQL Server instance also on-prem. Our DBA has scheduled 4-hour backups for all the company's SQL Servers which is supposed to truncate the transaction logs for all the databases after doing so. However, the logs for both my test and production data warehouse databases seem to be immune to such truncation:
Notice in particular the fact that the log for the test data warehouse is actually bigger than the test data warehouse itself!
Any systems-knowledgeable folks out there have any insights?
Is there a setting in Replicate that I have inadvertently toggled to cause such behavior?
I need to modify an existing P&L table with several scenarios (using the Vizlib solution with external Excel table).
Is is possible in a P&L table to use different factors per line?
sum( Value* $(=PL_View_Factor_Best) )
I get the right calculation, when the factor is the same for all lines, but when using different values or even an conditional value for different scenarios, it returns no value.
Is there another/better way to solve this?
i have dat like below in postman request
in qlik connection i am using nextUrl as my pagination
Next Url path :paging/link
it bring only one page can you help here
I made a measure for taking into account the efficiency of certain producers
(
Sum(
Aggr(
Count( {< ACTION_CODE = {'LABOR_OFF'}>} distinct MainSFC) * Standard_Time,
MainSFC)
)
)
/
(
Count(
distinct WorkingDay)
* 7.5 * 60)
And it works fine for the single producer. I want to abstract this, make one that takes into consideration ALL of the producers/employees, so in my mind I tried to do:
(
Sum( {<Employee=>}
Aggr(
Count( {< ACTION_CODE = {'LABOR_OFF'}, Employee=>}} distinct MainSFC) * Standard_Time,
MainSFC)
)
)
/
(
Count( {<Employee=>}
distinct WorkingDay)
* 7.5 * 60)
But this doesn't work, and gives me null values. How could I fix this?
Impact on SourceDB side when CDC using LogMiner is executed
I would like to check how much load CDC using LogMiner is putting on SourceDB.
Please tell us about the impact of LogMiner on the performance of Oracle (SourceDB) CPU/IO, etc.
Best regards,
Hironori Fujihira
Hi,
Recently we tried to upgrade our Qlik Sense from May 2023 to August 2023 (IR). The upgrade went well for DEV and QA servers. But it failed on production servers. We had to restore production servers with backed up AMI. Now we are investigating the reason why it failed. We have realized that we made a mistake when upgrading QS production which has two nodes: We stopped services on both nodes and then ran installation on two nodes at the same time. We know it is incorrect. But why did it cause problem? I am writing a report and need to gather deeper information.
Based on installation log files, I can tell the failure occurred at ServiceDispatcher step. Error occurred when it tried to create schema 'qlik_notifier_service'. I checked the log file for the successful installation on DEV server. When it tried to create schema 'qlik_notifier_service' there, it skipped this step because "Schema 'qlik_notifier_service' already exists" (the sentence in log). Why did the installation not skip it during production installation?
The attached ServiceDispatcher_installation_logs.txt contains related content from log files.
We need to make sure there is nothing else which caused installation failure. Please advise.
Thanks
I have a dimension that I created called Proposed Bucket.
Here is my if statement:
I want to create a measure that adds up certain elements of this proposed bucket.
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Join us on May 15th at 11 AM ET to discuss the Qlik Ideation Process. Bring your questions.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!