Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjour à tous,
J'aimerai avoir une aide afin de gérer un Job qui doit durer plusieurs jours. J'interroge des tables de ma base MSSQL contenant dans des champs de contenu XML que je remets donc en forme etc.
Le problème est que tous les soirs nous avons une maintenance sur le serveur MSSQL de 21h à 2h environ. Cela entraine l'arrêt de mon Job, j'ai donc l'impossibilité d'aller jusqu'au bout.
Voici le message que j'obtiens :
Démarrage du Job Prod_B_Extract_Contenu_XML_2023_1 à 11:09 02/05/2024.
[statistics] connecting to socket on port 4035
[statistics] connected
Exception in component tDBInput_1 (Prod_B_Extract_Contenu_XML_2023_1)
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:481)
at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:767)
at net.sourceforge.jtds.jdbc.JtdsStatement.reset(JtdsStatement.java:722)
at net.sourceforge.jtds.jdbc.JtdsStatement.close(JtdsStatement.java:966)
at easily_xml_specialites.prod_b_extract_contenu_xml_2023_1_0_1.Prod_B_Extract_Contenu_XML_2023_1.tDBInput_1Process(Prod_B_Extract_Contenu_XML_2023_1.java:2559)
at easily_xml_specialites.prod_b_extract_contenu_xml_2023_1_0_1.Prod_B_Extract_Contenu_XML_2023_1.runJobInTOS(Prod_B_Extract_Contenu_XML_2023_1.java:4586)
at easily_xml_specialites.prod_b_extract_contenu_xml_2023_1_0_1.Prod_B_Extract_Contenu_XML_2023_1.main(Prod_B_Extract_Contenu_XML_2023_1.java:4377)
[statistics] disconnected
Job Prod_B_Extract_Contenu_XML_2023_1 terminé à 21:54 02/05/2024. [Code de sortie = 1]
J'ai bien essayé de mettre le code suivant dans un des mes composants tJava (dans la capture, tJava_5), mais rien n'y fait car une déconnexion à la base MSSQL a lieu, ce qui interrompt donc le Job.
LocalTime currentTime = LocalTime.now();
LocalTime startTime = LocalTime.parse("21:00");
LocalTime endTime = LocalTime.parse("02:00");
if (!currentTime.isBefore(startTime) && currentTime.isBefore(endTime)) {
long sleepTime = java.time.Duration.between(currentTime, endTime).toMillis();
Thread.sleep(sleepTime);
}
Je vous joint une capture d'écran de mon Job.
Pourriez-vous m'aider à trouver une solution à ce problème ? Merci à tous par avance.
Hello,
We have Qlik Sense Enterprise installed on a Windows VM. Each day of the work week, the VM automatically stop at 19:00. Each morning, we start manually the VM and the Qlik services are set to start automatically when the VM starts. Since the 15/04/2024, when we start the VM, the Qlik services stopped working properly. When the qlik services starts, its make the VM very slow and unnable to access. It takes around 1 hour for the VM to be accessible again. Once the VM is accessible, i'm able to access it and restart properly the Qlik services and then it starts working properly.
I've try starting every Qlik services in different order to identify the one causing the crash and i've found that it is the Qlik Scheduler Service.
By waiting for the VM to be accessible, we are able to solve the problem but it is not very convenient since we have to wait some time and more than that, we would like to understand why the Qlik services stopped working properly. Before the 15/04/2024, everything was working fine.
Hello,
i have a pivot table and when I select a cell, Qlik only show the value of the two dimensions who are impacted by the cell.
What must I do to be able to select a cell and in the same time show all the pivot table and the value.
thanks for helping
Hi ,
I need to parse and load DB a pipe delimited file having data in the below structure using Talend.
Col1|Col2|Col3
"abc|111"|100|"zzz"
"xyz|222"|200|"yyy"
I am using dynamic schema as there are are multiple files with different schemas.(but all files follow the above rules).
Issue : It is note able to parse the entire content inside double quotes (abc|111) as single field.
Please help.
Thanks
I have the following where I'm parsing raw files into a dbTable then I want to iterate to a second sub with a tForeach
See attached example screenshot
When I try to connect the tForeach2 to the Raw transactions I get an error
Thanks for any help
During Qlik Sense installation, you are prompted to specify the hostname of your computer.
When installing Qlik Sense enterprise on Windows on a single node on a customer server, you will see a different hostname than the hostname of the installation server (for example, 000.com).
Myserver hostname -> Qlik_Sense
displayed hostname -> 000.com
So how does Qlik Sense recognize hostnames?
Hi Qlik,
I want to ask about the specifications of Qlik Replicate Enterprise Manager Repository.
We use AWS PostgreSQL RDS as a repository. What are the minimum specifications?
Thank you.
Best regards,
Herra
Hello Community,
i have a column in "sectors" and i also have "Tkt_no" column
so same "Tkt_no" I am getting multiple "sectosrs" see blow
current output
"Tkt_no" "sectors"
6697256429 JNBPOL
6697256429 POLJNB
6697256429 BOMDOH
6697256429 DOHJNB
Expected Output
"Tkt_no" "sectors"
6697256429 JNBPOL,POLJNB,BOMDOH,DOHJNB
I created 2 tables(qlik_users and qlik_attribute) in database (screenshot attached)
and successfully synced then using user directory connector ,
But these synced users are failing to authenticate / login to Qlik hub and QMC
Tried different ways to resolve this , -
But nothing worked, please help if anyone can provide suggestions
Hi,
I have data like this and when we do the calculation like below it ends up with duplicates.
if(num([cal date])-num(today())>0 and confirmed='N',1,0) as "Review Eve"
expression: sum("Review Eve") gives duplicates
ref | cal date | major code | minor code | review | quoted amt | agreed amt | confirmed | today() |
00ACCL27 | 01-04-2016 | 200 | 100 | Initial Rent | 177947.88 | Y | 09-05-2024 | |
00ACCL27 | 01-04-2016 | 200 | 130 | Initial Rent | 14351.93 | Y | 09-05-2024 | |
00ACCL27 | 01-01-2017 | 200 | 100 | Rent Review | 177948 | Y | 09-05-2024 | |
00ACCL27 | 01-01-2017 | 200 | 130 | Rent Review | 14352 | Y | 09-05-2024 | |
00ACCL27 | 01-04-2019 | 200 | 100 | Rent Review | 177947.88 | 177947.88 | Y | 09-05-2024 |
00ACCL27 | 01-04-2019 | 200 | 130 | Rent Review | 14351.93 | 14351.93 | Y | 09-05-2024 |
00ACCL27 | 01-04-2022 | 200 | 100 | Rent Review | 177947.88 | 177947.88 | Y | 09-05-2024 |
00ACCL27 | 01-04-2022 | 200 | 130 | Rent Review | 14351.93 | 14351.93 | Y | 09-05-2024 |
00ACCL27 | 01-04-2025 | 200 | 100 | Rent Review | 177947.88 | 0 | N | 09-05-2024 |
00ACCL27 | 01-04-2025 | 200 | 130 | Rent Review | 14351.93 | 0 | N | 09-05-2024 |
00ACCL27 | 01-04-2028 | 200 | 100 | Rent Review | 177947.88 | 0 | N | 09-05-2024 |
00ACCL27 | 01-04-2028 | 200 | 130 | Rent Review | 14351.93 | 0 | N |
09-05-2024
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!