Discussion Categories

Hello Community, I don't know if I'm searching the wrong terms to find answers in the documentation, so I'm going to lean on the community for some insight into my situation. Background:  We are dealing with a rehosting scenario transitioning from Appian Cloud to another environment configured differently.  I am unable to make changes to the new cloud space environment.  I can only work redesign of our app.  In Appian Cloud, we were the only system in our cloud space and utilized JDBC to connect to the underlying MariaDB.  The new environment is a shared space.  The use of JDBC is causing issues with the other tenants interfering with our data and tables.  We have been asked to transition to the use of the connected system object.   Questions:   1.  The database was set up in Appian Cloud by a different resource.  When attempting to build a new Connected System to our MariaDB, it's requesting a username an

Hi , I am using Appian Doccentre to look for few of the keyword to set one of the variable value. In my model I have created a field and given description/prompt to look for few of the keyword and if those found, then setting that new field value to those keywords in a comma separated way. The issue is, I am able to find few of the keywords but unable to find some although those are there in the document. I have tried giving all possible prompt but still unable to get those keywords. Did anyone find any such issue ? Any help is really appreciated. I am giving my prompt something like this.. From ONLY this list: ["abc","def","pqr"], return a comma-separated list of those found anywhere (case-insensitive). Match whole words; treat “claims” as “claims”. Include headers, footers, labels, and stamps. Regards, Ghanashyam

I have a requirement I have datetime component user can select the time maximum 2 hours from their current time else there should be validation error , i want to show the current time defaulted in the time field and they should select the time upto 2 hours . It should be in est . Can anyone help me with this 

Hi everyone, We have an application where business users can start a process using a Start Process Smart Service from the application site. The process model includes an Execute Robotic Task node, which is currently configured to “Run as whoever designed this process model”. This configuration is required because the process is initiated by basic business users whose usernames are not available in the Appian RPA users list. As a result, setting the node to “Run as whoever started the process” causes the robotic task execution to fail. Is there any supported way to configure the Execute Robotic Task node to run as “whoever started the process” by changing any other configuration in robotic task/RPA? Thank you in advance.

In one of our production apps, we currently send emails directly from the main process models using the Send Email smart service. As volume is increasing, we’re starting to rethink whether this is the best long-term approach. For those who’ve worked on larger implementations — do you keep email logic in the main process, or move it to a reusable subprocess? Also curious how you’re handling retries and basic monitoring in production. Just trying to sense-check our design as the app scales.

i am getting the above error when i am trying to edit "display value" in "addedBy". below expression i have used- rule!W0866aa_FormatDisplayName(user:fv!row[recordType!W0866aaVehicle.fields.addedBy]) given in guide -

How can I give the entire Dev access to a AI agent like how we provide access in VScode, Github so that the AI can have the full context of the applications and can reply with accurate results.

Hi everyone,  I'm curious to know if anybody using Lightspeed Devops CI/CD pipeline with Appian. if so what's your take on it. Thank you

Hi Everyone, We are looking for the ways to monitor the Disk, Memory and CPU usage metrics through logs in Appian Cloud environment and send alerts if it reaches certain thresholds. I know Appian Support will notify us through a support ticket when certain threshold reaches, but we would like to have our own monitoring and automated alerts before Appian Support creates the ticket to act on it immediately. Also, we know that we can monitor these metrics through Appian Support portal which is not an efficient way as this needs to be monitored manually during our entire business hours. If we have these logs, we wanted to get them to our Splunk logs and create the alerts accordingly when a particular metric reaches certain thresholds which will reduce the manual effort and can respond on time. So please let me know if anyone implemented this kind of feature in your Appian Cloud space. Appreciate your response. Thank you, Veera

I have a stored procedure (called from Appian’s Execute Stored Procedure smart service) that reads from a view and then creates, updates, or deletes rows in a materialized table that is also sourced from that same view. The view is heavily used by multiple applications, so I created the stored procedure smart service to read the updated values from the view and reflect them in the materialized table. This process is triggered by various create or update forms across different applications. Most of the time the stored procedure works, but sometimes it fails with the following error: Deadlock found when trying to get lock; try restarting transaction How can I reduce or avoid these deadlocks?

I am facing a weird issue while sending mail using send email smart service. I am getting everything that is required to send a mail. I have valid email ID, body that is needed, subject and everything. The process model is also getting executed successfully but email are not being sent. We also tested this before one day of this. At that time, we were getting mails. We didn't do any deployment since then but it is not working in both environment now. This is the common process to send an email. It is working elsewhere, just not sending mail for one scenario which was working before. Attaching screenshots of configuration. Please suggest something.

i am trying to create a data store , i have already created teh data type and i can see teh field from database , The data source schema does not match the type mappings: Schema-validation: missing table [`xxxx_LIST`] (APNX-x-xxx)

what is the maximum limit of data that an integration call can retrive/query/ get  in vice versa .., How much (what is the maximum limit) of data we can expose to the external systems (when using WEB API's), where we can configure/ set these data limits

Hi Team, We are facing an issue when we try to fetch the data through a query entity with a specified column sorting. When we execute the expression we specify the column on which sorting needs to happen. But when we get the result back we see two sorting columns in the result set. Is there any reason that might cause this? This is causing us perfomance issues

Hi All, I have a requirement; we need to store the document in S3, or at times we need to read the document (.xlsx) and present it in a grid format. Sometimes, it contains 1 million rows. Is it possible to fetch the data in batches while reading the document from S3, or is there any other alternative approach to achieve this? without impact any performance.

In Community edition , I am not able to find "Try Prompt Builder" under AI Skills . Do I need any other permissions for that ?

Product: Appian Area: Interfaces → Plug‑ins → Grid Plus Layout (gridPlusLayoutField) Appian version: [e.g., 25.3] Database: MariaDB Problem Summary I’m displaying data in Grid Plus using gridPlusLayoutField + gridtextcolconfig, with the grid sourced from a query rule (Record DataSubset). When I configure a column using recordField: gridrecordfield(recordType!...fields.<key>), I’m getting: Interface Definition: Expression evaluation error at function 'gridRecordField': Record field input must not be null or empty I need to render null‑safe text (e.g., “-”, “Not Available”) for some fields, but my Grid Plus build does not support a value/valueFunction/valueExpression property on gridtextcolconfig. Full Error Interface Definition: Expression evaluation error at function 'gridRecordField' [line 36]: Record field input must not be null or empty I have attached my code alsogridPlusLayoutField(   queryRuleName

I have been checking if there is way to have versioning display the JIRA numbers we work on. Currently versions help compare with previous version and inside interfaces we have to make comments with JIRA ticket numbers to understand why we did a specific piece of code. But if its possible to have the JIRA numbers displayed on each version wouldnt it be great to have only one final version of each change and delete all the previous ones like Save Final Version with JIRA number may be add comments to each version. Will it take up a lot of memory at Appian end? Currently we have only packages with JIRA ticket numbers and to find why we did some change for a specific line we need to add comments everywhere adding up the lines in Dev block. This way if we need to find for a particular ticket what changes we did would be easier. because sometimes making a start end block with JIRA numbers for small changes in same conditional block or same piece of code kills the code view.

Hello,  I have a text field who's value is linked to a dropdown field. If the dropdown value changes, the text field automatically changes as well. The text field is disabled as the user should not be able to change the value. The problem I have is that the value of this text field should be saved into a rule input but since I do not interact with the text field, the save into parameter does not trigger. I have no buttons on the interface so I could not add an a!save there. The user does not have to interact with any other field if they don't want so I couldn't put the a!save in another field as well.  Is there a way for the text field to refresh without interacting with it to trigger the save into? 

Hi, I have several editable grids in my interface with an add row link. When I'm testing the interface in the rule editor, the link works just fine for all grids, but when I try to create a new record using the record list action, clicking the link does not do anything.  The grids are implemented as follows: a!gridLayout( label: "Wachstumstreiber und Schlüsselerfolgsfaktoren", labelPosition: "ABOVE", emptyGridMessage: "Keine Wachstumstreiber angegeben", headerCells: { a!gridLayoutHeaderCell(label: "Wachstumstreiber"), a!gridLayoutHeaderCell(label: "Schlüsselerfolgsfaktoren"), if( local!readOnly, {}, { a!gridLayoutHeaderCell(label: "") } ) }, columnConfigs: { a!gridLayoutColumnConfig(weight: 1), a!gridLayoutColumnConfig(weight: 1), if( local!readOnly, {}, { a!gridLayoutColumnConfig(width: "ICON") } ) }, rows: a!forEach( items: ri!konzeptRecord['recordType!{e6823cb0-0826-4ba1-a489-d1b628fb0037}PEP Ko

Team, good morning! I’m facing a situation similar to some previous discussions here in the community about how to handle large numbers in Appian. I’ve seen topics mentioning Appian’s integer limit, where values may end up being converted to infinity, as well as recommendations to store certain values as text. However, my scenario is different. I’m not dealing with values that will never be used for calculations (such as phone numbers, ID numbers, zip codes, etc.). In my case, I need to store values that may potentially be used in calculations in the future — I don’t know for sure yet (the client hasn’t provided this information), but the possibility exists. This application will be used by wholesale clients who deal with very large revenue amounts (in the billions+). Because of that, I want to handle this situation as conservatively as possible. I’m using Oracle, and I defined these fields as NUMBER(15, 2), in appian it gets converted to

HI All, We have been constantly facing an issue with Appian Records where whenever a smart service writes data to a table using write to records, an error is triggered like - Modified Source Rows By Primary Key: 246113, 246112, 246117, 246107, 246111. Manual Sync never fails afterwards and is always successful.Note: We have multiple records referring the same Table which fails.

Explore our newest Appian AI courses and elevate your developer expertise with AI agents, AI skills, prompting, smart search, and more. Browse all courses here.

Hi Guys, we are facing the below issue in the document viewer. i do have admin access for this pdf which i am accessing to and i can able to download (via link field), but not really sure of the root cause for this .

Hi team! I have the following issue. When using a test environment, any read-only grids are stuck with the loading data animation, which only occurs until I perform an action such as resizing the screen, at which point the data finally renders on the grid. That behaviour only happens in the test environment; on dev, the information renders when the page loads. Has anyone faced a similar behaviour/issue? Thanks!