Discussion Categories

org.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session:

We have a requirement to delete data from multiple records ie., almost 30+ records. Seems like we can pass data of only one record type at a time while trying to delete using delete records smart service which increases the number of process variables. Is there any optimized way of deleting data from these many number of records ?? We are trying to query each record individually since the number of records to delete at a time can be high more than 100 which is more than the number of related records that can be queried.

Hi All, Please help on below -  I'm trying to pass my below rule to JsonToExcel Smart Service which needs a json data. How do I pass this rule so my output looks something like this: expected output sample - "[   {     ""Name"": ""Robert"",""age"": ""30""   }]" Rule I want to convert to json by passing from process parameters in start process- a!localVariables( local!data: a!refreshVariable( /*RMSP1-2105 - Added rule input - refresh to getlatest data*/ value: a!queryEntity( entity: cons!RMO_ENTITY_VW_EMPLOYEES, query: a!query( selection: if( rule!RMO_RULE_isNullorEmpty(ri!columns), rule!RMO_RULE_employeeSelection(), a!querySelection( columns: a!forEach( items: ri!columns, expression: a!queryColumn(field: fv!item) ) ) ), logicalExpression: a!queryLogicalExpression( operator: "AND",

Hello Folks,We are trying to deploy a Process HQ report to higher environments, but while doing it,  we are seeing protected as status for the Process HQ Report Object, did any one faced this or have idea?Please let me know as this is a high priority task. Appreciate your time & response![mention:9861aef97eb2483a8b76175d9eda1e37:e9ed411860ed4f2ba0265705b8793d05] 

There is an Interface C which has parent as B and B has parent as A. Now I am passing via rule input from C it is working in B but not in A. The value gets refreshed at A interface automatically. FYI the rule input data types are same for all 3 interfaces A, B and C.

Calling all developers! Earn the Appian AI Skill Badge to demonstrate your knowledge of Appian AI concepts and implementation. The exam is based on coursework from the Appian AI learning path, and tutorials and resources from Appian Documentation. This Skill Badge is aimed at developers who have already earned the Associate Developer certification and have 6+ months of hands-on experience with Appian projects. Skill Badges allow you to showcase your expertise to the Appian Community through short, topic-focused exams on Academy Online. These exams are free, non-proctored, and a great way to highlight your skills. More information about skill badges here. Enroll here! Questions? Please reach out to academyonline@appian.com.

Hi Everyone, I am working on an Editable Grid in Appian where the grid data comes from a Record Type (Employee Request). The record also has a relationship (requestDetails) which contains fields like categoryId, typeId, and referenceNumber. For normal fields (like department or location) I can update values using saveInto with the local variable and fv!index. However, when I try to update fields that belong to the relationship object, the values are not saved and I receive errors. Example dropdown: a!dropdownField( label: "Category", choiceLabels: local!categoryLabels, choiceValues: local!categoryValues, value: fv!item.requestDetails.categoryId, saveInto: { a!save( fv!item.requestDetails.categoryId, save!value ) } ) This results in the error: The save target must be a local variable that does not refresh on every evaluation, a process variable, or a node input... I understand that fv!item cannot be used as a save target, so I tried updating using loca

Hi Everyone,I want to add new value using custom picker field .Let's say , I have picker field name country and its having all country but not "XYZ".So how can we add it?

Hi Everyone, I am learning Appian and working on a simple interface form. While submitting the form, I am getting the following error: "A button component must not contain both a 'recaptchaSaveInto' and a 'saveInto' parameter." I tried removing some parameters but the error still appears. Can someone explain why we cannot use both saveInto and recaptchaSaveInto in the same button and what is the correct way to handle this? Any guidance would be helpful. Thank you.

My client is concerned about reducing token usage, and we are investigating how to prevent repeated tokenization and embedding. We understand that Document Management Record Types embed the document representations for use in the smart search.  Are these embeddings used system wide when document content is provided to an AI Agent or Skill? Are they only available if the document is referenced using the special system document type? Help us understand. Thanks!

I have been facing an issue since I started working with Appian related to the behavior of Process Model labels when using multiple languages. Currently, Appian requires me to manually replicate the same labels across different languages, which is not efficient nor logical in my development environment. Although I understand that a large portion of the community primarily uses one language (English), my team operates in a multilingual setting, where developers have different language preferences. Given this context, it becomes necessary for me to enter the same label in another language to maintain clarity and understanding among my team members. However, this redundancy could easily be avoided if Appian implemented a feature allowing us to persist labels across multiple languages. A simple checkbox option like "use same labels for multiple languages" when creating a process model would greatly enhance our workflow by ensuring consistency and saving time. Moreover, the curre

We are using Appian DocCenter for document extractions, mainly pdfs. Sometimes for few pdfs preview is not appearing. But data is getting extracted fine. Did anyone faced this issue.

How to export data to excel in a grid with more than 50 columns? (grid source is database)? Please advise?

I’m testing an Appian AI Agent that needs to read data from an XLSX document. I have two copies of the exact same XLSX file stored in two different folders in Appian. When I point the AI Agent to the file in Folder A, it works as expected and can read/extract the data. When I point it to the identical file in Folder B, it does not work (the agent appears to find nothing in the file / doesn’t extract data). Both documents are valid Appian documents of type .xlsx, AI Agent uses Semantic Search to read the data, and the file contents are identical. The only difference is the folder they’re stored in.  Has anyone seen this behavior before or can suggest what to check? Any guidance on why the same file would work in one folder but not another would be appreciated. I created new folders, checked the folder security, but I can't find the issue. 

Hi I'm experimenting with the AI Agent Studio object and setup a test case to read excel file, but when it tries to use the Semantic Search Tool I always receive this response.An error occurred while executing the tool [SemanticSearch]: The user [username] does not have sufficient privileges to perform the requested action.And return error from the tool. Is there anything that need to be setup or allowed?

I am using Export DSE to Excel node so currently, the data in each tab of the Export uses the default horizontal (normal) formatting.  The user would like to have the columns transposed to Vertical formatting when the Excel is created. Excel tab show the data in vertical rather than horizontal.  So, column A would have all of the column headers, Column B  & Column C should hold the related data and so forth. Kindly give your suggestions From this to  To this

Hi Guys, what is the prefered way to create and use constants in an appian application. I have created the following record types "Order", "Order Lines", "Order Type" and "Order Status". The "Order" Record Type has an orderTypeId (Number - integer) and orderStatusId (Number - integer) fields and relationships added to these tables.  I have now created two constants called "CONS_ORDER_TYPE" and "CONS_ORDER_STATUS" which binds directly to the above mentioned Record Types. How would you use these two constants in eg. a dropdown list?  I mean, if you create a constant of type array and add text values {"Created","On Hold", "Fulfilled"} what is the purpose to create the "Record Type" entities for the constants (Order Type and Order Status) since you can just use the data type "text" for the orderStatusId and orderTypeId fields on the "Order" record type

Hi! Is it possible to use Databricks as a data source with Appian? I know it's not directly supported but maybe there's like a workaround possible? Any help would be great!

Hi, in our environment the IdP changed some usernames from lowercase to uppercase. Appian configured for SAML authentication with "Retain Casing" option, returns error code 401. Do you have any experience that the configuration option at docs.appian.com/.../SAML_for_Single_Sign-On.htmlcan resolve the issue, and can these changes be made hot or do some services need to be restarted? Thanks!

Hi everyone, I am developing a Custom UI SDK component (JavaScript/Web Component) to create a custom image gallery. My goal is to have this component working seamlessly in both Appian Sites and Appian Portals in version 25.4. The Problem: I have tried using existing plugins and my own custom code, but images are not rendering. When passing the Document IDs to the SDK, the component fails to display the images. I suspect this is due to session/authentication restrictions or how the source URL is being handled, especially considering the architectural differences between Portals and Sites. Technical Details: Version: Appian 25.4. Component type: UI SDK (JavaScript). Current approach: Passing a list of Document IDs and trying to resolve them within the component. Issue: The <img> tags remain empty or return 401/403 errors when the component is loaded. What I need help with: What is the best practice for passing Appian Documents to a Custom UI SDK so they are accessible i

Hi All, Greeting! We have faced this issue with one of the users. They are able to see the requests that they created. But when they are added as watcher for records, they are receiving an email with link from that link they are unable to open the record and facing this and they have necessary permissions as viewer in the respective group.  Could anyone please suggest any answer for this. Best regards, Kiranmai Palanki.

The Dynamic Letter Generation module uses multiple styletexteditors where users can select which sections should appear in the generated letter. There are no formatting issues in the final generated letter. However, in the preview section, there is a numbering issue where an extra number appears even though there are no additional <li> elements present.Please find the screenshot of the code below,

Hi, I'm new to the Appian. I'm unable to see the 'New Data table' option as mentioned in this documentation: Create-record-data-source.html  So, I Selected Database option and I'm unable to proceed after that. No options provided here to select. Help me resolve this and provide me the steps to create an database and make connection to the interface. Share any documentation URL or online course for this.

Hi Everyone, I have few questions regarding the two AWS S3 related plugins available in Appian. Currently there are two plugins that appear to provide similar functionality for uploading and downloading documents to Amazon S3: Amazon S3 Utilities (Smart Services) AWS S3 Bucket Management (Connected System / Integration based) Both plugins seem to support operations such as uploading documents to S3 and downloading objects from S3. However, they follow different approaches in terms of configuration and usage. My questions are: 1. What is the main architectural difference between these two plugins? 2. Are they intended for different use cases (e.g., process-based vs integration-based)? 3. Is the AWS S3 Utilities plugin considered a legacy approach compared to the Connected System based plugin? 4. For new implementations, which plugin is generally recommended by Appian? I would appreciate any insights on when to use each approach in the real time. Thanks in advance! Ananda

Hi Team  we have requirement of generaing pdf file.we have designed a flow for that first we are generating the docx file from that will bys using PDF from DOCX service trying to convert pdf file. In this process we could see docx file generating successfully we are giving docx file as input to PDF from DOCX smart service.Docx file is generating successfully but pdf file is not generating.I can see PDF from DOCX is not running sucessfully with error message of "Exception exporting package".Can someone help me what could be the reason . Thanks for the response in advance.