Governance

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

Hii All,  Can we able to migrate entire Environment data from one environment to another environment including Users Everything,is there any approach? Thanks a lot in Advance 

Hey everyone,My company provide Appian as an on prem solution for a client. We need to upgrade the servers we are running their Appian on to Windows 2016 server. I know it's quite an old version of Appian however the client has no interest in upgrading, so I just need to know if Windows server 2016 supports Appian 2016.1.0.0Thanks

Does anyone know what is the earliest version of Appian that uses Tomcat 9,0.76?

After installing latest hotfix 23.2, we cannot start the Appian Service Manager windows service.  Here is the error: Service Kafka failed to start Error running script: Unable to start transaction log. com.appian.komodo.StartKomodo$TransactionLogNotStartedException: Unable to start transaction log. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at org.codehaus.groovy.reflection.CachedConstructor.invoke(CachedConstructor.java:72) at org.codehaus.groovy.runtime.callsite.ConstructorSite$ConstructorSiteNoUnwrapNoCoerce.callConstructor(ConstructorSite.java:105) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:59) Unable to start distributed tran

Is there any official recommendation or does anyone happen to know of any benefit of removing intermediate versions generated while working on an object. For example I'm working on an interface and I happen to save my changes 55 times during the development on the page...... so I have 54 versions saved that I don't need since I only want to save the last one. Other then making the version history cleaner to go through is there any other benefit?

We applied Hotfix 23.2.346 and Kafka will not start when restarting the Services Engines using the Windows Services.  The error log shows the following: Starting Appian Service Manager Found k.sha256 - a74b78fd5ab833a02c740879b7e962074e9b823cf9a08029ddaa003c03e51684 Detected Appian version 23.2.346.0 from build.infoStarting Distributed Transaction Log services: [all]Executing command: '[cmd, /c, start, "Zookeeper", /min, "%JAVA_HOME%\bin\java.exe", -Xms128m, -Xmx256m, -Dzookeeper.log.dir=e:\appian\logs\service-manager\zookeeper, -Duser.timezone=GMT, -cp, e:\appian\services\zookeeper-3.8.1\lib\zookeeper-prometheus-metrics-3.8.1.jar;e:\appian\services\zookeeper-3.8.1\lib\zookeeper-jute-3.8.1.jar;e:\appian\services\zookeeper-3.8.1\lib\zookeeper-3.8.1.jar;e:\appian\services\zookeeper-3.8.1\lib\snappy-java-1.1.7.7.jar;e:\appian\services\zookeeper-3.8.1\lib\slf4j-api-1.7.30.jar;e:\appian\services\zookeeper-3.8.1\lib\simpleclient_servlet-0.9.0.jar;e:\appian\services\zookeeper-3.8.1\l

Hi All, We are working on getting appian data to splunk. Appian has been configured to push the logs to splunk syslog endpoint. We have tried several things but the data received in splunk is still encrypted.  https://docs.appian.com/suite/help/21.2/Log_Streaming_for_Appian_Cloud.html#prerequisite-checklist Below is the config of splunk. Please help us if you have done this is past or have knowledge on how to fix this.  etc\apps\search\local\inputs.conf [tcp://514]connection_host = ipindex = appiansourcetype = syslog [SSL]requireClientCert = falseserverCert =  $SPLUNK_HOME\etc\auth\splunkweb\myDataCertificate.pemsslVersions = tls1.2cipherSuite = ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:DH-DSS-AES256-GCM-SHA384:DHE-DSS-AES256-GCM-SHA384:DH-RSA-AES256-GCM-SHA384:DHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA256:DH-RSA-AES256-SHA256:DH-DSS-AES256-SHA256:ADH-AES256-GCM-SHA384:ADH-AE

Developers can monitor process instances of their application but should not able to edit anything in UAT. Deploying application/package/plugins from UAT to PROD. Creation of new users and adding them in respective groups Editing of process instance in monitoring mode