Governance

We’re wondering if anyone have any recommendation in applying hotfixes after a major upgrade, I see that hotfixes are released weekly.Can the hot fixes be done via rolling restarts(with no downtime of the environment) ?

We are trying to deploy SQL scripts through Appian's compare and deploy, but we ran into this error: Access denied; you need (at least one of) the SUPER, SET USER privilege(s) for this operation The user who requested this package to be deployed has system admin permissions in the target environment, and I'm 99% sure they have system admin permissions in the source environment too. They weren't the ones who built the package itself though, but I'm not too sure if that matters here? Does anyone know what this error is referring to?

Hi Team, I have observed a strange case happening, For one of my account "XYZ", I'm unable to receive emails using "Send Email Smart service" from past two days. My hunch is, in the system logs, I see it as locked. Is this issue due to that or what could be case, here? Workflow: I have process model, that sends an email. That has input of a group as constant with the users included.

Hi all,  We need to configure SAML as Identity Providers for SSO in Appian. We have been looking into the configuration and we have some doubts about the Signature Hashing Algorithm. As far as we have seen there are only two available algorithms: SHA-1 and SHA-256,but after reviewing this topic with our client and people from Azure AD they told as the algorithm they use is AES. Does anyone know if it's possible to use different algorithms for this or are those two the only possibilities? Has someone had this same issue before and was able to solve it? Thanks in advance

Good morning, I am experiencing issues accessing the admin console via the Community Edition of Appian. Despite being the only user, it appears that I do not have the necessary permissions to access it. This also prevents me from accessing the cloud database. What steps should I follow to resolve this issue? I am unable to modify my credentials on my own. I would appreciate any help on this matter. Thanks in advance to anyone who will respond.

Hi All, I have configured appian HA environment and able to successfully start all Appian engines and servers for the appian version 23.3. When I tried to log in using valid credentials page is refreshing and going back to same login page. Any suggestions in resolving this issue? Thanks, Veera

I have handle two XML files daily, each with a size of 50MB or more. These files are transferred via SFTP or FTP. Our goal is to extract specific values from these files, check their existence in our database, and either update existing records or insert new ones as necessary.Requirements: File Retrieval: Automate the retrieval of XML files from an SFTP or FTP server. Store the files temporarily within Appian or an external file storage service. Data Extraction: Parse the XML files to extract a list of values. Given the large file sizes, efficient parsing and processing strategies are needed. Data Validation and Update: Compare extracted values against existing database records. Update existing records with the latest values or insert new records as required. Performance Considerations: Handle large files efficiently, possibly by processing in chunks. Ensure database operations (updates and inserts) are optimized for performance.can any one suggest some best approach to do this.

HI Team, is there any documentation around Appian's Secure Coding practices which can relate to OWASP ? ~Gaurav

How does too many nodes in a process model increase memory footprint? Too many nodes in a process mode reduce readability and maintainability. However, not sure how it impacts(increase) memory footprint. Please provide your thoughts..

What will happen to the objects that are last modified by a user whose account is going to be deactivated soon?What are the precautionary steps that need to be taken while deactivating a user in appian? What about process models which are configured to run as whoever designed the process model??

Dear all, Imagine that I have a Cognito pool with identities. I would like to ask if there is a chance to expose a link to Appian login page and authenticate users through AWS Cognito? Could someone give me directions if Appian supports an authentication flow through Cognito? Did anyone accomplish that? Regards, Dimitrios

Hi all,  I'd like to know how to configure this section of the admin console. In other clients we have it has been configured as follows: But it is not clear to me where these values ​​should be taken from the SAML assertion. From what it says in the documentation, I understand that the name of the attribute should be taken, right? Thanks in advance.

Hello all, Recently we have found that the Appian servers has the following vulnerability in the Engines using the port 7070.  Web Server Uses Plain Text Basic Authentication. Vulnerability Result GET / HTTP/1.0 Host: appian1.example.com:7070 User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; .NET CLR 1.1.4322) Performing a 401 HTTP actionService Name: HTTP on TCP port 7070. HTTP Service Accepting Basic Auth Credentials Detected I have been checking in the documentation, but there is no information about how to change the configuration to avoid using text plain authentication for the engines communication. Thanks a lot in advance, Best regards,

These two functions are returning the same thing.is there any difference? 

how can I generate in this format randomly "4SpPsO&CybFwb#KeoocAeS0WFb&EPn+A*WH$g%#4" can you suggest the logic in Appian?

Hi Team, What is the easiest way to get no of columns in all record in the application and also what is the easiest way to get no of nodes in a process model? Regards, Ghanashyam

I am following the ESG Portal Application Tutorial (https://academy.appian.com/#/online-course-player/07769a88-b0b5-44ee-a08b-8f2200355f87) However, during Step 2 when I create a Portal and go on to create a Service account, I am simply unable to access the field. Furthermore, I cannot publish the portal that I created. Why is this? I believe it might be because I am a basic user instead of system admin but I do not know how to switch and give myself the correct permissions. Please help!

Hi team, There are two interfaces, namely interfaceA and interfaceB, and interfaceB is a sub-interface of interfaceA. In the sub interfaceB, two localVariables are defined, namely b1 and b2. In the parent interfaceA, there is a button. I want to implement a function. When the button in interfaceA is clicked, b1 and b2 in interfaceB can be operated. How to achieve it? Is there a recommended solution? Thanks a lot!

Hi, I have a requirement where I need to add validation in editable grid Eg:  combination of (A+B+C+D) that should be unique for every entry but for D we need to add condition that all (A+B+C) should be unique, when we enter the data for D (or) it should throw error msg that having duplicate entries.

Using Version 23.1. When trying to start up, 3 of my engines are in CRASHLOOPBACKOFF state. When I look at the logs, it tells me that the engine was at transaction 235098772, but the transaction log ends at transaction 235097176. How is it possible that the engine has more transactions than the transaction log? Is there a way to resync the transaction log?

How to update the log file  or create a custom log file for tomcat-access.log with new fields inorder to have more details like username  and the action of user

Hi everyone. I am planning to implemnet sso using GOOGLE account credential. does any one implemented this. Please share if we have any documentation or any video tutorials on the same. Thanks Venkat

Hello Techies, I am looking for ways to extract a list of environment constants in my application. I know I can export entire list of constants and look up the properties file but is there a better way within designer to achieve it?Thank you!

Requirement: Implement Single Sign-On (SSO) for your application. Updated the Service Provider Signing Certificate in Appian. Generated a metadata file and sent it to clients. Configured the file and received an "Identity Provider Metadata" file, which was then configured in Appian under "Identity Provider Information". Questions: If I change the certificate that is already configured on the Appian side, will SSO authentication fail due to a metadata mismatch? If it should fail due to a certificate change, why is it that in my case, when I change the certificates on the Appian side, the SSO works fine, and I am able to sign in to the website? The certificates are generated by the IIS manager on my system.

I'd like to implement SSO using https://keystonelogin.external.beta.pa.gov/swagger/ui/index#/.I've implemented this in two different LowCode/NoCode environments and all that I need to get working is: /api/v1/session/login /api/v1/app/user/data Both RESTFul API endpoints. Can you point me to any tutorials or guides on how I can set this up? Thanks, pete