Discussion Categories

Hello Folks, I got this below error in my process. I am not updating anything in the process. Please assist An error occurred while trying to write to the entity "EMP_CASE " [id=916ee3cb-938e-4931-a61b-ba630fe5a543@61527, type=EMP_CASE (id=5350)] (data store: EMP Main DS). Details: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement: org.hibernate.exception.ConstraintViolationException: could not execute statement: java.sql.SQLIntegrityConstraintViolationException: (conn=7948467) Duplicate entry '229' for key 'EmpID': org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Duplicate entry '229' for key 'EmpID': java.sql.SQLException: Duplicate entry '229' for key 'EmpID' Data: TypedValue[it=5351,v={{<null>,229,eFront,89777,<null>,<null>,Open,0,TEST,Case,1,1,0,,1.0,56777,<null>,<null>,,,<null>,,<null>,,<

hi,  I am looking to get the start date and end date for all weeks given a month and year. I am learning Appian, I could see some functions in documentation that needs a date. The other way i could think around is write a procedure in the backed and call it , which will add overhead. Any ideas or suggestion will help. 

Hi all, I am a beginner of Appian, and the name of uploaded file is not visible fully... Is there any limited length? If so, I would like to make a longer name in an interface.. For instance, the following end of the name should be "report", but "rep..." in an interface...

Hi all, I am a beginner of Appian, and I would like to know how to display the place holder of calendar picker from mm/dd/yyyy to yyyy/mm/dd? A user requires to choose a data from calendar picker, and want to change the order from mm/dd/yyyy to yyyy/mm/dd. Hope you advice me... Best regards,

HI ,I am using "Google Sheet Connected System"  to write data in google sheet . I am trying to write data in the different columns for example column is I & J so range and values are- Ranges:- " Sheetname&"!I2:J" "  values:- { "Text10@Text4", "Text2@Text5", "Text3@Text6"} but If i want to update the column T also and giving range :- Sheetname&"!I2:T" values : _ {"Text10@Text4@Text9","Text2@Text5@Text8","Text3@Text6@Text7"} In this case ,T column is not updating or writing anything.So Can anyone tell me that what will be the correct way to update or write in the google sheet.Thanks in advance

I am using Locust with Appian to do performance testing. When I am trying to find a link using the options provided in Locust documentation, I am getting the message as "No components with label field_name not found" or "No components with type "record link" found on page. visit_record_type(record_type="Add Start Date")click_button(label="Add Start Date") click_grid_plaintext_record_link(column_name = "Add Start Date") visit_and_get_form("WAR Audit")click_button(label="Add Start Date")click_record_link(label="Add Start Date")click_record_list_action(label ="Add Start Date")click_link(label="Add Start Date") click_record_link(label="Add Start Date") click_record_view_link(label="Add Start Date") click_record_link_by_index(index=1,locust_request_label="Add Start Date")click_grid_rich_text_link(column_name="Add Start Date",row_index=0, grid_labe

Hello Everyone, There is an issue in Write Records Smart Service Its not giving as output with/of primary keys in the Output section    It works for a record which takes single value as input but not working for array pv!   Please ping if anyone has faced this issue before, We,ve tried everything but nothing is working Thanks in advance.

When a new task email is generated for a group, it is sending 2 different emails for the users in different time zones. For example people in PST are not copied in the email sent out for EST and vice-versa. Is this an expected behavior? 

Thank you very much for your continued support.I would like to display only completed instances in the process report.I checked "Completed" in the report filter settings and saved it. However, I'm experiencing an issue where the process instances displayed include ones with a status of "Active", or only the status "Active" is displayed.Does anyone know the cause of the problem or have any hints on how to solve it?I would appreciate your help.Thank you in advance. いつも大変お世話になっております。プロセスレポートに、完了済みのインスタンスのみを表示したいです。レポートのフィルター設定で、「完了済み」にチェックし、保存しています。 しかし、表示されるプロセスインスタンスにはステータス「有効」が含まれる、あるいはステータス「有効」しか表示されないという事象が発生しております。問題の原因、あるいは解決のヒントをご存じの方はおられますか？皆様のお力をお借りしたく存じます。よろしくお願いいたします。

In a Process Model I have added an Execute Stored Procedure and configured everything very well, in Data in the data source I put the constant with the connected system, in the name of the procedure I put the correct one and I configure the 2 input variables of the procedure, save and it is published fine and when it is executed it returns the error: ERROR: insert_in_din_tbl_tests(character varying, integer) is a procedure Hint: To call a procedure, use CALL. Position: 15, I understand that by default the Execute Stored Procedure executes with CALL without any prior configuration, but rather it executes it by default, so I don't understand how to arrange my execution.

We have an application that on a flow assign a series of task to a series of users or group. In this case we have a user that shared to another user  (for internal policy the second one dont have to see, and dont see, the specific set of data related to the task, but this isn't the problem)  The problem is that even the specific task was assigned to a group where there isn't the second user (that have received the task link) if that user use the link, it can see the task. Why? Are there some restriction that i can apply? Obviously we talk about task in report and not in tempo.

Hi Everyone, Is there any way to export data in local variable to excel? The Actual Requirement is 1. I have created some custom columns in Record Type 2. Generated an expression using Aggregation and stored the data in local variable 3. Created a Grid Report using the local variable 4. Now I need to enable download excel option for the data available in local variable But Appian is not allowing to enable showExportButton: true(), and getting below error. Thanks in Advance

Hi Guys, I have a requirement where the user has to fill in around 5000 characters in a paragraph field, is it possible to store 5000 characters to the database ? 

Hello :  My local machine is a windows 11 Home Named ( hostname ) zenbooktxuss .  The temporary license was working ( until it has expired ) . I requested  a permanent license twice .  I selected Local environment , introduced zenbooktxuss.casaredns.ddns.net as FQDN  ( the machine has that domain suffix configured but is not in a windows domain or workgroup)  and the Q output of my machine was something similar to this --> KDB+ 4.0 2023.05.26 Copyright (C) 1993-2023 Kx Systems w64/ 12()core 32574MB jesus zenbooktxuss 192.168.0.49 ... Just with the hostname But the license is registered like --> KDB+ 4.0 2023.05.26 Copyright (C) 1993-2023 Kx Systems w64/ 12()core 32574MB jesus zenbooktxuss.casaredns.ddns.net ..... The hostname was replaced ty the FQDN .  Once i have installed the permanent license . When i test the license 4 with the q script  i get this message . '2024.09.17T08:24:28.985 license error: host ze

Any latest plugin or smart service to call subprocess dynamically ?

Hi everyone,  I'm having this issue not sure if it is something wrong with my code or Appian issue itself, please help.  I'm having an editable grid, the data for it is a data subset type local variable, and in rows I use forEach of its data. I already provided the id for the gridRowLayout(), but not sure why it does not store anything into my local variable. I also tried with fv!index and it does not work either.  This is my input local variable with data subset type:  

hi,  I have a record list with values  {name:"Test1",id:1},{name:"Test1",id:2},{name:"Test2",id:3},{name:"Test1",id:4} my output should show - pid should be concat of the name and the sequence based on count 1. id:1,pid:"Test1001" 2. id:2,pid:"Test1002" 3.id:3,pid:"Test2001" 4.id:4,pid:"Test1003" any code suggestion will help 

Hi Everyone, I have a situation, i want to show the a constant timezone to every user no matter user is from USA, Canada or india, every user should see a constant date and time , No matter user changes his timezone in appian setting , timzzone should be remain same, changes in timezone in appian setting should not impact interface setted timezone, For exmaple: In the I created a record at 13 Sept 2024 12:11 AM IST , but i want to show on the inferface 12 Sept 2024 11:41 PDT, i implement a code when i set my timezone in appian setting as India Standard Time (IST) but when i change my time to PST in appian setting it impacts on interface as well  text( todatetime( gmt( text( gmt(fv!row.createdOn, "750"), "mm/dd/yyyy hh:mm AM/PM" ), ) ), "MM/dd/YYYY HH:MM AM/PM" )

Hello, Is there a way to set a read-only grid to have a height that matches the viewport height? I understand that the "fixed" setting keeps the grid at a set height, but it doesn’t adjust dynamically with the user’s viewport. I’m looking for a solution that combines the behavior of the fixed setting—such as scrolling and locked headers—with a height that adjusts to the available space in the viewport. Using a match statement with a!isPageWidth() won’t work in this case, as it does not provide enough control over the height.  Thank you! Nick

Hi All, Video component is not showing in Android mobile Appian App when the file upload is being used. is it a bug in Appian or is there any hotfix or any other option is available? Please help Regards, Bharat

can someone answer this question. what are the data management techniques in appian As I am new to appian and this is the question that i have faced in an interview

Hi  I am using Import Excel to  Database Smart service and for Datasource I tried to make connection using Connected System .I called the CS in constant using  CS as its type .But in Import excel smart service , Datasource is defined Text type .Is it possible to give DB connection url string as Text and pass it in constant and then use it .If yes then what is correct connection url string?

Hi all, I need to move an Appian 20.4 installation on a Windows server 2012R2 to a Windows server 2022 standard, and I want also to upgrade to Appian 24.1. Has anyone some clues to perform the activity?

Hi everyone, I need help checking whether I’m doing something wrong with my code. I’m having an editable grid with data is a data subset local variable. In it’s gridRowLayout() I also provided the id parameter. But somehow when selecting the row, it does not save any data to local!selectedAzureId. I also tried with fv!index instead of fv!item.fileId but did not work either. And below is local!data – the gridLayout data source:

this kind of output my SP giving me, and I have used print statement of SQL to print this output,  but when I call SP with the correct input Parameter then it's not returning the result.