Governance

Hello,  I am having trouble with the following use case : we receive 3 large Excel files daily (~60 000 rows and 40 columns), that we need to read and write into Appian Cloud Database. So far, we've been doing that this way :  1. Use an ETL to read the file and batch the extracted JSON data 2. Send the data in batches to Appian with an API exposed by Appian 3. The API triggers a process that write the data to the table (Using the node Write to Data Store Entity) However, this approach is starting to cause some memory issues, as there is more than 150 processes trigerred daily, and each of these processes contains large process variables (even with batching, we still have 150 processes dealing with 500 rows each). I am wondering what would be the best way to deal with this issue according to best practices. I've thought about using a!writeToMultipleDataStoreEntities directly in our API instead of triggering a process, to avoid having too many process running, but

Hi, I am currently interested about best practices for process deployment, and I've read a thread (please see the link below) about a critical issue. I've read a reply explaining that "key-value pair mapping" is a best practice for connecting Interface/SAIL with process to avoid deployment issues. Could you explain me what this best practice is about please ? or just give me a litlle example ? Deployment issue :[mention:92d5c8846e574db9a3de2720dbfefcc8:46448885d0e64133bbfbf0cd7b0fd6f7] Process Best practice :[mention:d6e94ce985b94acfbda1889c02640965:f586769b0822468ab7f3a94d480ed9b0] Regards

Hi  While starting data server received "Configuration file custom.properties does not exist." error. What might be the issue >

We have an Appian sandbox server for training on our on-premise Appian servers, and we're facing an issue with component plug-in approval verification failing. When attempting to add a newly developed component, can you advise on how to bypass this process? We are using our on-premise servers and do not plan to upload these components to the Appian Market.

Upgrading to Appian version 24.4 and cannot get the Tomcat server to initialize completely. The following is a snippet from the tomcat-stdout.log:"host [http://localhost:9200], URI [/], status line [HTTP/1.1 401 Unauthorized]{"error":{"root_cause":[{"type":"security_exception","reason":"missing authentication credentials for REST request [/]","header":{"WWW-Authenticate":["Basic realm=\"security\", charset=\"UTF-8\"","ApiKey"]}}],"type":"security_exception","reason":"missing authentication credentials for REST request [/]","header":{"WWW-Authenticate":["Basic realm=\"security\", charset=\"UTF-8\"","ApiKey"]}},"status":401}" ..... [wait-for-component] INFO  com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Search Server to be healthy... I've ensured the apiKeys match in <APPIAN_H

Hi there. If I select the “Generate groups and folders to protect and organize objects” option when creating a new Application, what groups are created by default? I think they were “Administrators” and “Users” but I saw in a forum that someone was talking about the “Designers” group being created as well. Is this true?

Hi, I have section of questions using 15 fields of a cdt (cdt has total 30+ fields).  Based on a dropdown value change, I want to make all 15 fields to null.  Is there any way I can make all 15 fields to null in one go, instead of writing 15 a!save.

Hello Devs, I have created a webAPI of template type : "StartProcess". Now this webAPI is starting the process when triggered but I want to open a form as a result of it. How can I achieve that?  Do I have to handle it inside body ? inside httpResponse of onSuccess? how to achieve that. Here is my current code for the webAPI: a!startProcess( processModel: cons!PFM_APPIANFORMTOLAUNCHROUTER_PM, processParameters: { formToLaunchLabel_txt: http!request.queryParameters.formToLaunchLabel_txt, formToLaunchParameters_txt: http!request.queryParameters.formToLaunchParameters_txt, processInstanceAppianId_int: http!request.queryParameters.processInstanceAppianId_int, }, onSuccess: a!httpResponse( statusCode: 200, headers: { a!httpHeader( name: "Content-Type", value: "application/json" ) }, body: a!toJson( { taskID:getactivetaskidsforprocess( fv!processInfo.pp.id ) } ) ), onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader( name: "Content-Type", value: "application/jso

The following error appears in the logs every 5 minutes from feb 15 , and it seems like the leader election is occurring at this interval for some reason. Is this something to be concerned about? Should I open a support case, or is this behavior normal? Could you please clarify? [2025-02-19 08:53:03,034] TRACE [Controller id=0] Leader imbalance ratio for broker 1 is 1.0 (kafka.controller.KafkaController) [2025-02-19 08:53:03,034] INFO [Controller id=0] Starting replica leader election (PREFERRED) for partitions triggered by AutoTriggered (kafka.controller.KafkaController) [2025-02-19 08:53:03,034] DEBUG [Controller id=0] Topics not in preferred replica for broker 2 HashMap() (kafka.controller.KafkaController) [2025-02-19 08:53:03,034] TRACE [Controller id=0] Leader imbalance ratio for broker 2 is 0.0 (kafka.controller.KafkaController) [2025-02-19 08:58:03,034] INFO [Controller id=0] Processing automatic preferred replica leader election (kafka.controller.KafkaController) [2025-02-19 0

We are trying to find out the current utilization of LIMS so wanted to know if you have any monitoring tools to check the current active users

Hello i m follow this guide https://academy.appian.com/#/online-course-player/270dc9fc-ad42-4d30-94db-ebfcc2f39331   But on Create the Part Record Type in step 8 I have this error when I click on new relationship.   HTTP Code: 500 APNX-1-4198-000 Error Evaluating UI Expression Expression evaluation error [evaluation ID = KP48I] : Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!getInterchangeableTypes [line 27]: The data source [_a-0000eada-3d9b-8000-9ba4-011c48011c48_12846-w1857] was not found   Can you help me please? Im new in appian.       Best regards!

Is there any possibility that load() and with() will be discontinued ??  is there any possibility that load() and with() will be deprecated We have a!localvariables to do the same thing more efficiently.

Hi Team, I have below text and I want to convert it into a Date and Time. Example: Text:  "01/07/2025 12:00:35 PM" Date and Time: 01/07/2025 12:00:35 PM or 01/07/2025 12:00:35 PM GMT+00:00

i just have a general question about this statement in the documentation, "By default Appian runs with 3 shards each of the execution and analytics engines. The maximum number of shards for each of these engines is 32. Because they store unique data, once you have added a new shard for execution and analytics, you cannot remove that shard from your configuration."  Does this mean one engine can have between 3 to 32 shards? 1 : 3 ... 1: 32. Thank you.

I have an process model , getting ids and looping via batch vise. Im npt getting a error or data is not updating the same process model is showing in the Health Check Report that {<PROCESS MODEL NAME>tGet list of caseIds scheduled to process- (11 nodes in loop)}

Hello All, Our new RHEL9 Acceptance environment is upgraded to version 24.3 but after upgrade we are unable to access the one app server directly (without load balancer). Previously we could access app server directly using URL "https://{HOSTNAME}/suite/?signin=native" But now I can login but it gives me CORS request rejected error message. Previously before upgrade I added {HOSTNAME} to embedded interface list in admin console and it was working. can you please help me in this how to bypass or update CORS valid list directly in database. Not sure but looks like it is wiped out after upgrade.  Here is error details : 2025-01-14 22:50:40,903 [ajp-nio-0.0.0.0-8009-exec-1] ERROR com.appiancorp.security.cors.CorsFilter - CORS request rejected; invalid request from XXX.XXX.XXX.25 to /auth jakarta.servlet.ServletException: CORS origin denied: {HOSTNAME} is not on the allowed list:[ Thanks, Bhushan

Hi,  We have a requirement that some communications between Appian and external systems have to be encrypted with mTLS. Does anyone know what is needed to generate a mTLS certificate and how to configure it in Appian? Thanks in advance

Hi all, I am writing with regards to an issue that we have found while upgrading from Appian 22.4 to Appian 24.3 in both the Dev and Test environments.We followed the procedure described in the documentation and found no issues during the upgrade process. However, when starting the Appian engines, we noticed the 3 analytics engines and the 3 execution engines were in CRASHLOOPBACKOFF state. The other engines were in RUNNING state as expected. We resolved the issue running the recovery script with these parameters: ./recovery.sh -p <password> -s <failing_engines> -ni  Then, the engines started correctly, and all the servers started up fine as well. However, the exiting process instances had disappeared from the Appian design view. Is there any way to refine the parameters used in the recovery script or another solution to recover the engines in CRASHLOOPBACKOFF state? As the same issue has happened in the Dev and Test environments we are concerned that it could happe

I have got a input string like "[key1:value1,key2:value2]", how to get the value by key?

1) Which log file is used to view users' activity like password Chage, user type change, reactivate/deactive, username change? 2) Which log file to view the process failure in detail? 3) Log file to view the user login audit? 4) Log file to give details about slow queries?

It doesn't appear the option from the menu

We are running a HA env with 3 app servers behind the Apache. We are using mod_jk and JKWorkerProperty to set up the load balancing in httpd.conf as provided in the Appian documentation. Issue is, we notice that whenever one of the tomcat servers are down, requests are still routed to the instance. This doesn't happen when entire instance is down.  I assume Apache is doing a basic TCP to determine the health of the backend server. I want to know if I can configure a tomcat health check GET url in my Apache config to determine the health of the instance from apache?

How to get the memory occupied by the knowledge center documents in Appian server? Tried with Admin console -> Monitoring, and it is providing size for the list of documents uploaded/downloaded? My requirements is get the actual space occupied by the knowledge center documents in Appian cloud environment.

Dear Team, I am new comer to Appian have background of IBM BPM, Can you please guide where to find  inner exception details (log for this error) of a smart service ( Move to Collab). It is giving error  com.appiancorp.suiteapi.process.exceptions.SmartServiceException: java.lang.Exception: Invalid File Path: /webattachments/path/foldername//info@alwaha-qatar.com/qid20220327080031286QID_&_PP.pdf we are using to move files from file server to appian mount path but it is completed sometimes & gives above error some times.

Are there any official, generic guide lines when it comes to retention of information stored in the database and the documentation stored in knowledge centers (when to archive, eliminate, how to handle such situation)? It's obvious we'd have to tailor it to our specific application but I wanted to start by observing any suggestions given by Appian.  Best Regards.