Governance

Hi All, I moved an object from Application A to Application B. When I deploy the object from Application B to higher environment it adds the object successfully to Application B. But I notice that the object is not removed from Application A in the higher environment. What do I need to do for the object removal? Do I deploy the whole Application A? Does anybody have an insight on this? Appreciate your help on this! Regards, Sakshee

Hi, I have a google drive connected system, I use it in an integration to create folders in google drive. It works fine, but after a few minutes of inactivity or sign out my account, the authorization is canceled or expires and I have to re-authorize in my concept connected system for my integration to work again. How can I always leave it active, without the need to authorize it every moment?

Hi All, I wanted to understand how document is stored in Appian . Does Appian store it internally as a stream ? or there is some other sort of mechanism for same ? Please let me know if you have any sort of Appian forum links or you have some sort of understanding for this . This is just for my knowledge . Regards, Sparsh Shangloo

Hello Appian Community, My team and I are in the process of installing Appian version 22.4 on Windows 2016 Standard with IIS 10 and MS SQL Server 2016 Enterprise Edition. After following the steps from the guide and attempting to start the app and all its components (Service Manager, Data Server, Search Server, app) we get an error in the logs that ends with this entry 2023-08-11 13:39:10,957 [localhost-startStop-1] FATAL com.appiancorp.common.web.StartupHaltingServletContextListener - Appian initialization FAILED: see above stacktrace for details and starts with this entry 2023-08-11 13:39:10,935 [localhost-startStop-1] ERROR org.springframework.web.context.ContextLoader - Context initialization failed Here is an excert of the rest of the message: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.security.filterChains': Cannot resolve reference to bean 'org.springframework.security.web.DefaultSecurityFilterCha

We recently had the following scenario on our cloud based Appian environment. 1. We do all our application building / designing / development on our development environment.2. We promote our applications to our QC environment and finally Production.3. Our development environment recently had issues where the Appian support team had to restore it to a point from the previous day.4. Once our development environment had been restored to the previous days recovery point, we had effectively lost all our application development from the recovery point to the time the server became unstable. Question: What is your process to avoid or mitigate this loss of work/code if your dev environment crashes ? I come from a non-Appian environment where we develop our source code and then commit it to a source code repository.From there it automatically checks the source code for quality, builds the application, and deploys it to our development environment.If our development environment crashes

if( not(ri!executeWhen), { data: a!dataSubset( startIndex: ri!pagingInfo.startIndex, batchSize: ri!pagingInfo.batchSize, sort: ri!pagingInfo.sort, totalCount: 0, data: {}, identifiers: {} ) }, a!localVariables( local!employeeList: cast( typeof( { 'type!{urn:com:appian:types:INO}INO_employee'() } ), ri!employeeDataSubset.data ), local!staffList: index( local!employeeList, where( a!forEach( items: local!employeeList, expression: and( tointeger(fv!item.designationId) = cons!INO_DESIG_ID_STAFF, ) ) ), {} ), local!employeeIdList: index(local!staffList, "internalEmpId", {}), local!operationsCodeIdList: index(local!staffList, "operationsCodeId", {}), local!dateList: if( isnull(ri!selectedDateList), {}, todatasubset( a!forEach( items: ri!selectedDateList,

How I can improve the performance if there is long java work queue in engine performance log. Which one I have to do whether I have to increase application server or increase Ram. Which one is correct?

In my current project I need to make a element button integrated in a interactive grid visible for screen readers and if it this posible get this code in HTML: " aria-label=”Delete” And, if this action is not posible, what recomends to use in te grid to eliminate an element? Thank you

Hi! I'm trying to achieve this HTML structure in appian text field: <label class="" for="un">Name</label> The main request to get it: The screen readers must be able to read the text into the text (placeholder aren't visible in their opinion) Many thanks!

I'm working on a module called Query your Data. It's asking for hands on practice. Generate a Record Type Selection Query. It asks me the following: But the Query Your Data App is not available on the Appian Designer page. What can I do about this or did I miss buliding that somewhere along the way?  Numbered divider  Generate a Record Type Selection Query For this exercise, imagine you are an Acme Auto developer. You need to create a query that returns a list of vehicles. That list must include all Vehicle record fields and the cost field from the Maintenance record type. The query should only show the data property. In your Appian Community Edition environment, navigate to your Query Your Data application. Since you're creating a selection query, you will use the query editor to generate this query. Complete the following tasks and check them off when complete. Review the Check Your Work section when done or if you get stuck.

I am attempting to connect to my RDS Postgresql database and cannot get that connection working through Connected Systems. There is mention of opening a support case and having a driver created but whenever I use the Open Case button I get a 401 error. I haven't seen this mentioned, but is that not an option for the community edition? If that is the case, is my only real recourse to import the data to the appian database?

Hi! I made a request one day ago in order to recover my appian site. When I enter in appian community, I see the following information; When I click the "Check status" button, nothing happens. I received a no reply email which said that there would be a delay in my request, but I would like to ask how much time will pass until I can recover my site (or what is the "standard" amount of time), and how can I follow the status of my request. Thanks a lot!

Hi All,  What is the best practice/Appian recommended naming convention for database tables and fields? Previously the database table created by Appian were all lowercase, now in latest version, all (tables and fields) in upper cases. Is there any reason they changed it to upper case? For most databases, recommended naming convention in stored procedure is to keep the key words as upper case and fields in camel case/pascal case and table name in pascal case Please let's know your thoughts/recommendations. SG

When we create a new Record Type, Appian automatically generates a SQL script that can be run (either automatically or manually) to create the database table. It always uses UPPERCASE for both the table and field names. My question: is there a default setting somewhere that can be overridden so Appian instead uses lowercase names for tables and fields when generating the SQL script for us?

I have a data type for a SQL view TOS_CMS_VW_ClergyTitleStatusTypeDSE.  It contains fields describing various clergy members.  I want Clergy Id and Clergy Full Name in a lookup on an interface.  ClergyID is an integer and ClergyFullName is a text field. I created a constant for the data type and I am not trying to create a expression to pull the two fields I want for the dropdown, ClergyID and ClergyFullName. a!queryEntity(  entity: cons!TOS_CMS_VW_ClergyTitleStatusTypeDSE,  query: a!query(    selection: {      a!querySelection(columns: a!queryColumn(cons!TOS_CMS_VW_ClergyTitleStatusTypeDSE.clergyId)),      a!qyerySelection(columns: a!queryColumn(cons!TOS_CMS_VW_ClergyTitleStatusTypeDSE.clergyfullname))    },    pagingInfo: a!pagingInfo(      startIndex: 1,      batchSize: 500,      sort: a!sortInfo(        field: cons!TOS_CMS_VW_Cle

We initially developed our Application on cloud and now we setup the complete database at on-premise and I was not able to connect from cloud Environment. Need help ?

Appian 23.2 We have MariaDB as a default Database. We have our SQL Server Database hosted in AWS. Can someone please provide me with the steps to create a new Data Source? Can I directly go to Admin Console -> Data Sources ->New Data Source -> Add SQL Server Details? or any additional steps that we have to perform? Thanks

Hi All  I have successfully configured a single sign-in solution that is working perfectly for our clients. I am also configured Attribute Mapping like Create New Users Upon Sign-In and Update User Attributes Upon Sign-In it works fine, but when it comes to Group Membership Synchronization I add one group(AD Test) in Azure Ad in which one user will be added and the same group added(AD Test) in appian under the group type (A Brand) when i try to access the appian With that user credential, I am successfully get the acess the appian  but no user will be added to the appian group(AD Test). Could you help with what I did wrong here? 

DB view associated with CDT but don't have primary Key. We used DB View in a!ExportDataStoreEntityToExcel to extract data(20k Records) into Excel File and getting an timeout Error. Is there any way to apply Composite Key for few columns on CDT to extract data to Excel without errors ? In Appian Best Practices mentioned that there is a way to apply composite key but no example. If anyone knows the solution please replay here. Thank you.

Hello All, I have successfully configured a single sign-in solution that is working perfectly for our clients. However, we have a new requirement from our clients. They want to implement a process where a user added to a specific group on the Azure AD side should also be automatically added to a corresponding group on the Appian side. These groups will have the same name and purpose in both environments. To elaborate: - Azure Group: [ABC Accounts] - Appian Group: [ABC Accounts] The aim is to ensure that any user added to the specified group in Azure AD is seamlessly added to the corresponding group in Appian without manual intervention.  Please provide guidance on the steps required to set up this automated user synchronization and any best practices to ensure smooth ongoing operation. Thank you for your attention to this matter. Please let me know if you require any further information from my end. Best regards,Prasad

Hi All, I have successfully configured a single sign-in solution that is working perfectly for our clients,we have a new requirement from our clients. They want to implement a process where a user deactivated from  Azure AD side should also be automatically deactivated  Appian side. Please provide guidance on the steps required to set up this automated user synchronization and any best practices to ensure smooth ongoing operation. Best regards,Prasad

Hi all, we have a application which consist of over 35000 documents and folders. I'm getting the below error while exporting the whole application. Is there any workaround for this?

We are hiring Appian Developers for the following locations  Philadelphia, Delaware, New Jersey. Any one would like to know more about this exciting opportunity please contact me abhilash.p@KGIS.CO  Here is the brief JD: 4+ years related experience working in a technical role Primary responsibilities will involve developing, integrating, and debugging Appian objects; writing validation tests against existing baselines to ensure integrity of the code during Agile development efforts. Create integrations with other enterprise systems using REST APIs. Create Web APIs in Appian and secure them using OAuth 2.0 credentials. Strong background in relational database design and SQL Strong problem solving and design skills Strong communication and presentation skills

We have a client who has been very happy with Appian on the Cloud for a good length of time, but is now questioning whether all the data being generated by our app and the app itself shouldn't be hosted on their own servers.  I know it's not typical to start Cloud and then later go self-managed, but that's what the powers that be are seriously considering.  We have recommended against, but they have what they consider to be compelling arguments to pursue hosting the app themselves. About the only guide we have to go on is the guide for going from On-Prem to Cloud (in reverse?), but I wonder if anyone else has ever had to perform this operation and can steer us clear of some of the pitfalls they discovered during Migration.  What we've been asked to deliver is a guide on how to Migrate the Cloud hosted app to their own server, along with everything we'll need to have in place before we begin. This, thankfully, is just in research phase, but research on

Hi Has anyone done the migration from on prem to appian on kubernetes? Let me know the migration plan steps and any challenges faced?