Governance

Hi all, We want to restrict the drop table and truncate table privileges to certain users in certain schemas. I'm aware of the documentation strategy for restricting write or admin permissions: https://docs.appian.com/suite/help/25.4/appian-cloud-database-administration.html#cloud-database We need to go finer here, not that radical. We have designers maintaining our PRO environment, we need them to write into the DB (as they may need to fix incidents) but we want to prevent them running more "hardcore" commands, like drop or truncate. I've also looked at the Appian admin stored procedures, to see if we can do anything similar to the normal "grant" dba commands, but I've been unable to find anything useful. Any advice? Thanks in advance.

Hi , have 6 integrations in the process model flow , it should be run in sequence manner and each integration is depending on previous integration call, now i have to complete the process model within 5 see , could you please let me best approach to follow ? thanks!

Hello Team, Can you please help me out to findout this server.conf.notifications file in Appian (25.1). Regards, Srini

My use case is: I receive a dynamic Excel file from the user each time, with changing column names, different sheet numbers, and a large amount of data. I need to insert this data into the database and display it in the interface. I tried Excel-to-DB, but it doesn’t work dynamically. I also tried using AI to extract data from Excel, but I’m not able to extract all sheets dynamically. What should I try?

Hi everyone, I’m starting a new application in Appian and I want to choose the right approach for storing and managing data. Should I go for  Data Store (CDT + Data Store mappings) from there creating record type or  Directly use the Record Type backed by a database table What's the purpose of data store generally? I meant by for the modern Appian developement do we need data store necessarily  Since this is a new build, I want to follow best practices and avoid making architectural mistakes early. My Question For a fresh application, what is the recommended approach for: Application/master/transactional data CRUD operations Reporting and relationships Security and scalability Long-term maintainability Should I rely on Data Store, PDP, Record Sync, or directly use a Database-backed Record Type? If you have any guidelines, comparison points, or real-world experience on which option is better in 2025 Appian architecture, please share your insights. Notes : 

Hello Appian Community, I’m exploring Appian Case Management and came across some implementations described as “case management style.” However, when researching, I see references to Appian Case Management as a native framework. Observations from typical implementations: Short-lived processes triggered on UI submission Routing logic partly handled via staric Match() expressions State stored in database tables Audit/history maintained manually in tables My questions: 1. In Appian, is Case Management a native framework that you configure, or is it just a coding style/pattern? 2. How can we objectively distinguish a true case management implementation from a hybrid or DB-driven workflow that only simulates case management? 3. Are there official Appian guidelines or best practices confirming this? Thank you for your guidance!

Thank you for your earlier advice on saving logs at application startup. As we approach the production phase of the system, I am attempting to deploy from the development environment to the testing environment, but I am encountering an import error with the aforementioned logging output application. It indicates that there is a problem with the baseURL in the connected system, but I do not see anything particularly wrong. Is there anything specific I should check? What I'm concerned about is that this application connects to a Web API within my server, and it's authenticated with a security account. The security account for the testing environment has not yet been created; could this be a factor? <ERROR>An error occurred while creating connectedSystem [uuid=_a-0000eeac-676e-8000-XXXX-XXXcXXXXXcXX_XXXXX]: The connected system [id= uuid=_a-0000eeac-676e-8000-XXXX-XXXcXXXXXcXX_XXXXX] was not created because a value for baseUrl must be provided in an import customization file

Hi Team, which tool is better to use for testing with appian application for automation testing? thanks!

Can we install Appian Designer on our local system or on a cloud VM to explore server-level configurations and functionality?

I am looking forward to create a notification for some users before the Idle User Deactivation process run. Is there a way to check when the Idle User Deactivation happened?

I'm unable to build SAML authentication for Azure Entra ID authentication using SAML Single Sign on. Whenever I try to to test connection from appian its showing me No trusted assertions were provided by the Identity Provider. My Azure Basic SAML Configuration:- Identifier (Entity ID): https://mysite.appiancloud.com Reply URL (Assertion Consumer Service URL): mysite.appiancloud.com/.../AssertionConsumer

docs.appian.com/.../appian-cloud-database-administration.html Does anyone have additional context on the reasoning behind these recommendations?  My client has hard data segregation needs and plans to use multiple schemas to address them, but we want to know more about what problems we might expect to run into.  We're using the cloud database. The biggest issue reported to me so far had to do was a problem around using compare and deploy to update stored procedures (ones that reference multiple schemas), but they found a manual workaround to mitigate that issue.  I'm curious if there's any other notable issues that can be expected or if there's any loss of other capabilities we're unaware of at this time. Thanks

This may be an odd request, but can I call deployments api v2 in the lowest environment (dev) to get the export log files associated with a package? I ask because in Admin->Infrastructure, we have enabled incoming and outgoing external deployments only for our 'next' environment (SIT), and adding new environment doesn't allow self-reference. My connected system seems to be failing and suspect that enable incoming / outgoing is only set for 'SIT' environment. The motivation for the ask is to grab the export logs of a package at the dev level to load in unexported precedents for further processing. Thanks for any insight, Eric Casteel

Hi. We need more precise information regarding advice and best practices for doing a rollback / reverting a direct deploy. We intend to do a big deploy which restructures a lot of tables, processes, rule expressions and interfaces. We want to have a rollback plan if anything goes wrong, but i dont find any option in the deploy panel for rollbacks or reverts.any info is welcomed.

I'm planning to run a nightly process that will see if any new application has been created for the past 24 hours, and then send notification with some instructions to the person who created the new application.  is there a way to detect these new application containers? any plug-in I can utilize?  We self manage Appian on Kubernetes, so we have access to logs and Appian metadata. 

Hi Team,  one of the colleague added to UAT environment, but not sure who added that user to environment  and how added to..? is there any way to track that?  Note: He is new to our team. thanks

I hope this message finds you well. I would like to log the event of an interface being opened. However, my understanding is that on the interface itself, unless an action such as clicking a button occurs, it is not possible to write a record or start a process model. When consulting ChatGPT, I received the following idea: Create a Web API on Appian that returns an image as the response and simultaneously saves a log. Place an image on the target interface and set the endpoint of the Web API created in (1) as the image source. As a result, when the interface is opened, the Web API in (1) is called, and the log is recorded. However, it seems that the function a!writeToDataStoreEntity does not get triggered inside the Web API. I have two questions and would appreciate your advice: What should I review to implement the above ChatGPT idea successfully? Are there alternative methods to log when an interface is opened? Thank you in advance for your kind advice.

Hi team, I'm exploring options to fetch user login audit logs for extended periods such as the last 3 months, 6 months, or 1 year. Currently, I only see daily login audit data available. Is there a more efficient or consolidated approach to retrieve historical login activity over longer durations? Any guidance or best practices from the community would be appreciated.

Hi, could you please suggest me better approach like how can get inactive user list in the environment and last login inactive user ? I have seen, we can get to know in admin console but if we want check without admin console like any functions to check? thanks

Hi everyone. The client has asked to use a particular Typeface. I have the Woff2 URL's on the admin console. However, when entering and inspecting the site, the typeface/font gives a 404 error. Investigating further, I notice how on the initial HTML script, the URL for the typeface/font starts with a "/suite" instead of the actual "https://" Has anyone dealt or experience a similar problem before?Thanks!

Hi Appian Community, I'm currently developing a multi-regional application in Appian that will be used by Spanish-speaking users across different countries, including Spain, Mexico, and Colombia. While they all share the same language, I've noticed that number formatting conventions vary significantly between regions, especially in how thousands and decimal separators are used. For example: In Spain: 123.456,78 (dot for thousands, comma for decimals) In Mexico: 123,456.78 (comma for thousands, dot for decimals)  My question is: Does Appian automatically distinguish between regional variants of the Spanish language (like es_ES vs es_MX) when applying number and date formats? Or do we need to explicitly configure the full locale (e.g., es_MX instead of just es) for each user to ensure the correct regional formatting? Additionally, has anyone implemented custom logic to handle formatting based on the user's country? What best practices would you recommend to maintain co

Hi everyone, We recently encountered performance issues in our development environment and requested a restart. Before the full sequence could be executed, we have ran only: Code: appian_services_stop followed by starting it again without stopping the other components: appian_appserver_stop appian_searchserver_stopappian_services_stopappian_dataserver_stop We’d like to understand from the community: What are the potential risks or side effects of restarting only appian_services_stop? Could this lead to instability or partial recovery? Is there any known impact on data integrity, indexing, or service coordination? Appreciate any insights or experiences you can share. Thanks,

Hello Community, Recently, our Appian environment was experiencing performance slowness. To address this, we executed the command: appian_services_stop / appian_services_start After doing so, the system came back up and was running fine with improved performance. Later, when our vendor connected, they insisted that we should only follow the manual stop order described in the documentation: 1. Stop application server 2. Stop search server 3. Stop data service 4. Stop engines They blamed our use of appian_services_stop for later issues. However, when they followed the manual stop/start sequence, the system failed to come back online and has remained down since then. My question is: Is there any risk or problem associated with using appian_services_stop / appian_services_start instead of manually stopping/starting in order? Thanks in advance for clarification.

We got record sync failure for all Record type enable for sync after Appian Upgrade and then we need manually sync the records. Is there any bug on this? Ideally Appian upgrade process should not have post upgrade activity of Record sync.

Hi Team, I had 2 simple questions which I wanted to post here. Please help me if anyone has the answers :  Context : You are given a list of CDT / Dictionary / Map with a few fields, eg :  { { key: 12, val: "ABC" }, { key: 20, val: "DEF" }, { key: 30, val: "GHI" } } Problem statement : Get those CDTs which have key bw 10 & 25  My approaches : I had 2 approaches, both of which I have a roadblock I convert this to list to a data subset using toDataSubset function and then filter on this I create a rule which takes this `key` as an RI and then returns true / false based on condition. I will use this rule in the filter function and use wherecontains to filter out which matches our condition Questions :  Now for the approach 1, I had a question : how do I filter this custom data subset ? because I only see queryEntity and queryRecord but nothing to query this custom dataset  For approach 2 : is there a way we can eliminate the need of creating a differ