Administration

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

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,

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, 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

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  

We are trying to set up a Single sign-on for one of our environments and generated a self-signed certificate for SAML authentication using Apache OpenSSL. Now can we use the same generated certificate for one of our higher environments as well?Looking forward to the response. Thanks

Hi Team, I am configuring SSO in my application, but the flow isn't working. The logs indicate: "Signature was either invalid or signing key could not be established as trusted." In my SAML response, I see the authentication method x509 used by the IDP. Do I need to add any additional information besides the SAML configuration? </Attribute> <Attribute Name="">schemas.microsoft.com/.../authnmethodsreferences"> <AttributeValue>schemas.microsoft.com/.../AttributeValue> <AttributeValue>schemas.microsoft.com/.../AttributeValue> <AttributeValue>schemas.microsoft.com/.../AttributeValue> </Attribute>

Hi team, We recently planned to migrate the IDP configuration from one to another. During this migration, we did not delete the old IDP (IDP1) but added a new one (IDP2). However, when testing the new IDP (IDP2), we encountered a 401 error. Remarks: I have accounts in both IDPs with similar Email IDs. The first IDP (IDP1) works properly. When testing IDP2, the SAML response shows success (<samlp:Status><samlp:StatusCode Value="urn:oasis:names:tc:SAML:2.0:status:Success"/></samlp:Status>), but we are receiving a 401 response. where i find the SMAL responce logs in appian In Idp2 responce we recevied name id and attribute(email) was different but we are using email id as AttributeValue of Username in appian Could you please assist in resolving this issue with IDP2? Thank you.

Please tell me how to set up dynamiclink when switching between interfaces.

Good afternoon, I am trying to compare in a foreach loop a data with the previous iteration, but I am not able to access this iteration, is there any way? I need to sort a list, but if there are two equal values ​​they have the same order, with the array{ name:"aaaaa", valor:2 name:"bbbbb", valor:10 name:"ccccc", valor:10 name:"ddddd", valor:10 name:"eeeee", valor:45}get as a result{ name:"aaaaa", pos:1 name:"bbbbb", pos:2 name:"ccccc", pos:2 name:"ddddd", pos:2 name:"eeeee", pos:3}I am trying to save the pos outside of the foreach in a local variable, or recover the value saved in pos of the previous item Thank you very much

Can I create a process model or a plugin to listen to user logins? I would like to create the user based on another API.

Hi all, I have a user account that was mysteriously deactivated. It may have been due to account inactivity but I would like to be sure. Are user account deactivations stored in the logs anywhere whether they are done manually or due to passing the inactivity threshold? Thanks, Christian W. Harris

Hi! Does anyone know how can I increase the rolling period for getting the login-audit.csv zipped using the log4j configuration? right now is a month and I need it to be three months.