Skip to main content

General Product Q&A

Not sure where to post? Ask your product-related questions here and get support from the community.

  • 2,562 Topics
  • 5,881 Replies
2561 Topics
PhuongBHN
Level 3
PhuongBHNLevel 3
posted in General Product Q&A
Error: Extractor cannot write to temp directory during Redshift connection test "Unable to write a test file to the temporary directory '/tmp/CEL_CON_TEMP'. Please make sure that application is provided with the write permission on it and it exists."

!--startfragment>Hi everyone,I'm currently facing an issue when trying to connect from Celonis to Redshift via the Extractor.!--endfragment>  When I check the Extractor logs, I consistently get the following error:!--endfragment>!--startfragment>ERROR 66250 --- [pool-4-thread-1] c.c.c.j.c.u.status.GetDataSourceStatus   : Error during connection test --EOM--cloud.celonis.connector.client.exception.ExtractorException: Unable to write a test file to the temporary directory '/tmp/CEL_CON_TEMP'. Please make sure that application is provided with the write permission on it and it exists. To troubleshoot, I’ve already ensured that the folder exists and has correct permissions. Here's what I've done:!--endfragment>!--startfragment>   sudo mkdir -p /opt/celonis/tmp/CEL_CON_TEMP   sudo chown ubuntu:ubuntu /opt/celonis/tmp/CEL_CON_TEMP   sudo chmod 755 /opt/celonis/tmp/CEL_CON_TEMP   sudo -u ubuntu touch /tmp/CEL_CON_TEMP/test.parquet !--startfragment>The manual file creation

30
PhuongBHN
Level 3
PhuongBHN
Level 3
PhuongBHNLevel 3
posted in General Product Q&A
Uplink could not connect: 'Error while extracting response for type [class cloud.celonis.uplink.manager.UplinkDataWrapper] and content type [application/json;charset=UTF-8]'

I have tried to connect to my Redshift by Extractor Server. But I have meet the issue below when start the extractor. How can I fix this? [class cloud.celonis.uplink.manager.UplinkDataWrapper] and content type [application/json;charset=UTF-8]', waiting 3000ms before retrying --EOM--2025-06-13 02:11:40.256  INFO 22860 --- [uplink-thread-1] c.celonis.uplink.manager.UplinkManager   : Uplink could not connect: 'Error while extracting response for type [class cloud.celonis.uplink.manager.UplinkDataWrapper] and content type [application/json;charset=UTF-8]'

101
N
Celonaut
abhishekbidwe
Level 2
abhishekbidweLevel 2
asked in General Product Q&A
Can we change Data model of an existing Knowledge model?

Can we change Data model of an existing Knowledge model? As I am trying to change the data model, I am getting Data model fail notification.

111
N
Celonaut
E
Level 3
ewa.aniśkLevel 3
asked in General Product Q&A
How can we apply colours to charts/process explorer/tables in Views?

How can we apply colours to charts/process explorer/tables in Views?

235
leonardo.spina
Level 3
L
Level 1
loretta.nelso12Level 1
asked in General Product Q&A
Where can I find JDE reference customers?

We are working with a prospect who uses JDE and he requested us this information.

112
P
Celonaut
Saba
Level 4
SabaLevel 4
asked in General Product Q&A
Filter

Hello everyone,I have a list of Material Numbers, and some of them belong to the P18 Business Unit, some to the P20 Business Unit, and some belong to both P18 and P20 at the same time.I created a Quick Filter to show only the materials that belong to P18, and it works correctly:FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P18')I did the same for materials that belong to P20, which also works correctly:FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P20')However, when I try to filter for materials that belong to both P18 and P20 at the same time, the following filter does not work correctly — it also shows materials that belong only to P18 or only to P20:FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P18')AND "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P20')Do you have any idea how to fix this?Thanks! 

180
Saba
Level 4
S
Level 3
sayan.chakr12Level 3
asked in General Product Q&A
How Can i connect the purchase side and sales side in a process explorer which will display the P2P-AP process in one side and O2C-AR process in one side AND the explorer should also display the connection between the 2 process flow??

I am working on an intercompany transaction where one subsidiary of the parent in buying material from a vendor which is a subsidiary of the same parent. Hence O2C-AR of the buyer should be synced with the P2P-AP of the vendor.

115
swapnil.karad12
Level 2
varvara.bachu
Level 2
varvara.bachuLevel 2
asked in General Product Q&A
Wrong result when adding percentages

Dear Community,I want to calculate an average error rate for each year under certain conditions. Even though it may seem quite simple, I receive an incorrect result. 🤔This is my formula:COUNT (DISTINCT (“Table”.”Column”))/COUNT (DISTINCT (“Table”.”Column”)). The KPI “2023” has the following conditions as filters: Do you have any idea what is wrong with my formulas? Many thanks and kind regards,Varvara

130
varvara.bachu
Level 2
thomas.keim
Level 4
thomas.keimLevel 4
asked in General Product Q&A
Create Table with field of various 1:N and N:1 Relations

Hello Community,I hope you can help me to find the best approach of my issue. My challenge is to build a table with the complete SAP Process Flow: Order, Delivery, ShipmentFor this I have created a data model with the following linked tablesVBAK (1) - (N) VBAP (1) - (N) LIPS (N) - (1) LIKP (1) - (N) VTTP (N) - (1) VTTK When I try to add fields from all tables into one studio table I get the following error:I have understand the problem but missing the best approach to solve it.What do you think? Is the a studio table with different PQL formulas the solution? If yes, how can I do it?Or is it better, when I create a table (e.g. TAB_PROCESS_FLOW) within the transformations that includes all the key columns and connect the other tables (VTTK, VBAK...) within the data model. So the table TAB_PROCESS_FLOW is like a case/common table.Best, Thomas 

180
thomas.keim
Level 4
A
Level 2
akash.suhag12Level 2
asked in General Product Q&A
i have activity table which have same timestamp(T) for multiple activities in a single case.for eg : activity A has T 5:00, Activity B has T 5:10, activity C has T 5 :10. here i want the flow to be like A->B and A->C.but flow is A->B->C

i have activity table which have same timestamp(T) for multiple activities in a single case. for eg : activity A has T 5:00, Activity B has T 5:10, activity C has T 5 :10. here i want the flow to be like A->B and A->C. but flow is A->B->C

236
herique.sarme
Level 3
srikar.akell11
Level 2
srikar.akell11Level 2
asked in General Product Q&A
Is there a way to get the export of the data permissions

Hi, I want to know if there is a way to export the following listData model name ------ Data permissions ( Enabled/Disabled )if enabled then Group / User name ------ condition ( if any ) ----- unlimited (yes/no)i want to download this list as an excel, is it possible?

434
benjamin.strem12
Level 2
S
Level 3
sayan.chakr12Level 3
asked in General Product Q&A
I am trying to access transformation scripts from ML worbench with pycelonis 2.6 . But i am not able to fetch SQL scripts from transformation jobs which belongs to a template with visibility type protected. How to open the protected from task te

I am trying to access transformation scripts from ML worbench with pycelonis 2.6 . But i am not able to fetch SQL scripts from transformation jobs which belongs to a template with visibility type protected. How to open the protected from task templates?

193
Dhilip Kumar Vijayan
Level 2
.
Level 2
.1460096356Level 2
asked in General Product Q&A
Change the name to an event

Hi! I would like to personalize the event names for a client demo. How can we do it? Regards

113
andré.tafur
Level 4
Sverre Klein
Level 6
Sverre KleinLevel 6
asked in General Product Q&A
Asset Library not responsive

Hi all, I have a problem with loading the asset library, it shows the following error.Cannot read properties of undefined (reading 'children') Anyone has the same issue? Thanks!

220
Sverre Klein
Level 6
jan.vajse12
Level 3
jan.vajse12Level 3
asked in General Product Q&A
Shared link opens last user's selection

Hello,our users face regulary the issue that if someone sends them link with a certain selection, what opens is their last selection of the view and not the selection that was shared with them. Is there any known way how to overcome this setup? If you send somebody a selection, this selection should alway show up if the person clicks on the link. Thank you for any advice.Jan

214
jan.vajse12
Level 3
Mst11
Level 3
Mst11Level 3
asked in General Product Q&A
Font size

Hello everyone,Does anybody knows what is happening with the font size of numbers in KPI Cards. Some of them are extremely big and some seem to be normal sized. Thanks a lot!

675
J
Celonaut
michaela.gebha
Level 3
michaela.gebhaLevel 3
asked in General Product Q&A
Order Mgmt Execution App - Filtering on a range of postal codes

Dear Community,Is there a possibility to create a filter component in the Order Mgmt Execution App giving the users the possibility to filter on a range of postal codes from/to (similar like a date filter)?Thanks for your help!Kind regards,Michaela 

90
michaela.gebha
Level 3
Saba
Level 4
SabaLevel 4
asked in General Product Q&A
Classiffy

Hi everyone,I have a column with many numbers, and I have uploaded a screenshot as an example. I want to classify them into groups. FYI: I know the maximum, minimum, and median, and I also know the total number of numbers.How can I do that?Thanks in advance! 

9515
matthias.gielk11
Level 3
douglas.souza
Level 3
douglas.souzaLevel 3
asked in General Product Q&A
Variable Clear

Good afternoon/Good morning Celonautas, could any of you tell me if there is any way I can clear the variable? For example, the variable is disabled. I would like it to clear the variable from my dropdown when it is selected.Here is how it looks when I disable it.And how I would like it to look  

131
jonas.hess
Level 3
Saba
Level 4
SabaLevel 4
asked in General Product Q&A
Classification

Hello everyone,I have a coloumn with a lot of numbers and as an example i have uploaded a screenshot of it.I wanted to classify them into groups so i wrote a case when like this :CASE        WHEN KPI("max_potential_saving") BETWEEN 7000 AND 70000  THEN 1          WHEN KPI("max_potential_saving") BETWEEN 1000 AND 7000  THEN 2              WHEN KPI("max_potential_saving") BETWEEN 800 AND 1000  THEN 3            WHEN KPI("max_potential_saving") BETWEEN  600 AND  800 THEN 4          WHEN KPI("max_potential_saving") BETWEEN  400 AND  600 THEN 5        WHEN KPI("max_potential_saving") BETWEEN  200 AND  400 THEN 6        WHEN KPI("max_potential_saving") BETWEEN  0 AND 200  THEN 7        ELSE 8      ENDbut when i sort it based on the classification it does not show the Max Potential Saving in order from highest to lowest. Does anyone have an idea ? Thanks in advance !

573
Julie Shih
Celonaut
J
Level 2
josh.bozziLevel 2
asked in General Product Q&A
Cropping the Process Explorer using a component filter

The Process Explorer can have its activities cropped via use of the Crop Selection page filter, however when using the formulas CALC_CROP and CALC_CROP_TO_NULL in its component filter, the Process Explorer fails to crop Can the Process Explorer be cropped via component filter? If yes, what is the correct formula / way to do this?

244
Poovarasan
Level 2
jonas.hess
Level 3
jonas.hessLevel 3
asked in General Product Q&A
See no Records in smart Sensor

RecordsHello, unfortunatly i could not see any Records in my smart sensor, anyone familiar with this Problem? ThxHeSee no Records over here

50
jonas.hess
Level 3
omar.elmou
Level 3
omar.elmouLevel 3
asked in General Product Q&A
Dear Celomates,I would like to add the rework rate as a KPI without using PQL.

I have added an OLAP table with three columns where the Count of activities is compared to the Distinctcount activity for each case key. Please find attached the OLAP table. Besides the OLAP table i would like to show the rework rate as one number by referring to the formula and outcomes of the OLAP table. How can i add a number (without using PQL) where the ration of cases with a YES", as displayed in the OLAP table, is returned as one percentage. Many thanks!

252
Poovarasan
Level 2
marcin.konop13
Level 3
marcin.konop13Level 3
asked in General Product Q&A
Custom Attribute not available for KPIs

Hi all I have created a simple attribute that calculates a metric I will be averaging out.  And in the table it looks fine. However whenever I try to call it I get an error  Please assist. I presumed as documentation states that those calculated attributes are treated the same as values in a column. KindestMarcin

438
rita.kiss12
Level 4
ritesh3719
Level 3
ritesh3719Level 3
asked in General Product Q&A
How to Apply Role-Based Access Filters in Celonis for Users?

In our team, we have different roles assigned to users, such as Junior Buyer and Tactical Buyer. I want to ensure that when they access Celonis, they only see records relevant to their role.We have a mapping between user and their assigned documents (Purchase Requisitions, Purchase Orders, etc.) in a table. Based on their role, users should see only the documents assigned to them.

351
janpeter.van.d
Level 8

Badge Winners

  • Qualified to Manage Implementation Projects
    jauhar.khalihas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Manage Implementation Projects
    julia.portehas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Deliver Business Value with Celonis
    manali.malpahas earned the badge Qualified to Deliver Business Value with Celonis
  • Celonis Certified Data Analyst
    ihtishaam.khanhas earned the badge Celonis Certified Data Analyst
  • Qualified to Build Action Flows
    ihtishaam.khanhas earned the badge Qualified to Build Action Flows
VIEW ALL
Community Code of Conduct