Governance

 I would like to use a SAML Group claim, like <Appian Admin> so that when a user signs in, and they are in that IdP Group (from Azure Entra ID) that they are created as an admin console admin... Is there a way to use a "Common Object group" in Designer to manage admin console admins?

I am looking to use SAML 'Attribute Mapping' configuration to 'create new users upon sign in'. Is there a way I could create a user as a system administrator based on SAML attribute mapping?

our current appian primary database is on oracle which we are migrating to PostgreSQL we are using GCP DMS for migration from oracle to PostgreSQL after migration we found few column which is as  BLOB in oracle is migrated as bytea in postgresql no when we are starting tomcat we are getting error  org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: wrong column type encountered in column [edit_events] in table [app_edit_history]; found [bytea (Types#BINARY)], but expecting [oid (Types#BLOB)] is any one faced this issue please help with resolution

1) I am using appian community account. I need to change my first name but 'Update' button is not enabled in edit profile 2) Is there any way to download certificate from appian community account

Hi Folks, There is a requirement to reset the password dynamically for a user, but I don't see any specific smart service for this purpose. Regards, Ghanashyam

Hi All, I have main process and calls sup process. Suppose sub process will iterate 10 time and each iteration it will generate new id. I want all new generated id by sub process in main process. I have implemented output option in sub process but it return only last generated id by sub process. It is possible to get all the id generated  by sub process in main process. Regards, Umesh 

Hello,  I am no longer able to save and publish process models. Where should I be looking to verify that I have permissions to do so? I am in groups with process administrator level access to the process models. This issue is across all process models in my environment across different applications. Thank you, Nick

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!