Governance

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?

Hi All, I am starting up Appian for the first time after following the instructions mentioned in the Quick start guide.  After started the appian i can see, appian engines, data-server, search-server started sucessfully, and then i started the tomcat server and i tried access the appian through browser multiple times and  after looking into the tomcat-stdOut.log i found out the below observation I'm using 23.2 version Thanks In advance. Please find the logs below. Using CATALINA_BASE: "C:\appian_23.2\appian\tomcat\apache-tomcat"Using CATALINA_HOME: "C:\appian_23.2\appian\tomcat\apache-tomcat"Using CATALINA_TMPDIR: "C:\appian_23.2\appian\tomcat\apache-tomcat\temp"Using JRE_HOME: "C:\appian_23.2\appian\java"Using CLASSPATH: "C:\appian_23.2\appian\tomcat\apache-tomcat\bin\bootstrap.jar;C:\appian_23.2\appian\tomcat\apache-tomcat\bin\tomcat-juli.jar"Using CATALINA_OPTS: " -Dfile.encoding=UTF-8 -Duser.timezone=GMT -Djava.na

Hi,          We have a HA Setup with Two Nodes. Appian Mandates both to be of the same version. So we need to have a downtime and upgrade both the nodes. Is there any way to do an upgrade without downtime.

I'm looking for suggestions for an Authorized Use Policy for individuals granted admin permissions in our Appian site. 

Hi, We are experiencing issues while trying to import an application from version 23.2 to another running version 22.4"content _a-0000e9b4-aa73-8000-9ba7-011c48011c48_31355: The data for content [id= uuid=_a-0000e9b4-aa73-8000-9ba7-011c48011c48_31355] could not be read from the XML. Cause: javax.xml.bind.UnmarshalException: java.lang.RuntimeException: An error occurred while trying to get the TypedValue type (Id) from XML. XML node: null" To enable the system to allow the import of the application, we have modified the 'MANIFEST.MF' file, and this has worked on previous occasions.

Hello Community,the more I am working on bigger scale projects with multiple devlopers, I am thinking about a kind of code merging functionality.Currently we have an "overwrite" principle. If i did changes to that interface/expression rule etc and press save then all changes previously done are overwritten. So if person a and person b are working on the same interface, the last one who saves "wins" and the changes of the earlier saver are essentially gone.Does anyone has insights if something in this direction is planned?I can see that difficult for records, decision tables or process models. But for interfaces and expression rules, it should be possible in my mind.Perhaps my idea is totally off the chart :)I am open to your opinions on that. kind regards form Hamburg Germany, Richard

local!supervisorList: if( contains({ 3, 6 }, ri!selectedDashboard), index( /*a!isNotNullOrEmpty(tointeger(ri!reportingEmployeeList)),*/ ri!reportingEmployeeList, wherecontains( cons!INO_DESIG_ID_SUPERVISOR, tointeger( index( ri!reportingEmployeeList, "designationId", 0 ) ) ), {} ), null ), local!supervisorHierarchyList: if( contains({ 3, 6 }, ri!selectedDashboard), a!forEach( items: local!supervisorList, expression: 'type!{urn:com:appian:types:INO}INO_employeeHierarchyHelper'( employee: fv!item, directReportEmployeeList: index( typeof(ri!reportingEmployeeList), wherecontains( index(local!supervisorList, "internalEmpId"), tointeger( index( ri!reportingEmployeeList, "currentReportingManagerId", 0 )

HI I am fetching data from appian report. I have applied filter also so it won't fetch all the data everytime. but for the very first time it has to fetch everything  from the reocrd and then store in database. Now just to be on safer side I want to fetch the data in batches and then want to consume it.I am doing it with the following way a!localVariables( local!latestDate: cast( typeof(now()), index( rule!MO_GetLatestAuditDetails().data , "endTime" , now()-60) ), local!processModelUuids: rule!MO_GetAllProcessModels().processModelUuid, local!totalCount: index( rule!NEW_MO_ExtractProcessMetricsFromPortalReport( batchSize: 1, startIndex: 1, date: local!latestDate, processModelUuids: local!processModelUuids ), "totalCount", 0 ), local!numberOfIterations: = fn!ceiling(local!totalCount / ri!batchSize), local!listOfIntegers: = enumerate(local!numberOfIterations), a!forEach( items: local!listOfIntegers, expression: rule!NEW_MO_ExtractProcessMetricsFromPortal

I  was working with the editable grid . i want the all the updated values from the editable grid from the cdt ?

how to get the different values form the array ?  eg. local!a:{"a,"b") local!b:{"a","b","c") i want the output as c how can i get that ? 

I have taken the free appian community access . i am new to appian . i wanted to know from where i can open appian designer . or what to do next ? I only able to open appian community not appian designer ?? Please help