Discussion Categories

Hi, Wanted to understand on how Appian parses an Expression Rule that uses a!queryAggregation and a!queryAggregationColumn against a Table/View? Does it convert and send a query as-is with GROUP By to the database SQL engine or does it get the data and then do the grouping on-fly in its memory? Thank you in advance for your response.

I'm encountering an intermittent issue when using a!startProcessLink within a a!richTextItem in a task. The process model being called is fully chained from Start to End and works fine when called from a Record as a Record Action. But in this case where I am calling from a Task, once the process ends, I sometimes get the error message: "The Task Could Not Be Submitted. The task has already been submitted." This occurs sporadically. Any insights into why this might be happening and how it can be resolved? Thank you!

Hi All, I have two interface, A and B. When a button in interface A is clicked all the components in B should be refreshed. Is it possible to refresh all the components in interface B without passing parameters in all components in interface B?(I am passing the refresh variable from A to B, but not from B to components in B)

Hi  I am looking for appian admin in Plano TX or Charlotte NC or Chicago IL if any one interested please send me your resume at shekhar@iconma.com

When I select CDT  in datastore. I got this type of error. Error: "An error was encountered while processing your request. Please try again." what should I do with this.

Hello Appian, I'm having trouble with setting SMTP for on-premise appian server. https://docs.appian.com/suite/help/22.2/Mail_Server_Setup.html#sending-emails  I followed the instrtuctions from above link. And getting error like below from the log - tomcatstdout log - mail-listener.log - custom.properties How can I make this work? Thank you

I need to store a user id, along side several picture uploads all in a relational database. My solution for storing the pictures would be to save the pictures locally on appian and save the document ids on the database alongside the user id. However, with the way I have it implemented right now it seems I cannot pass in the user id into the body alongside the picture upload as it takes up the entire body. I also cannot attach several pictures for upload. I need a way to be able to pass in the user id and atleast 3 pictures into the body to be saved in the database.

Hi All, Is there any way to control the size of text in dropdown values?

I wanted to block calendars in google and outlook as per the details received by the user in Appian. 

Hi, I have the need to understand if Appian servers of the customer are already in HA. Is it enough to look at the file appian-topology.xml? Thanks

Title: Appian Admin Location: Charlotte, NC Duration: 11-12 months   Description: We are strictly looking an APPIAN admin with at least 5 years of Appian Admin experience.   Required Skills Bachelor's Degree in Computer Science or Engineering with a minimum of 10+ years of overall experience in support of information technology computer systems and databases. Familiarity with RHEL 8 or above system administration and troubleshooting including network and resource utilization including memory, filesystem, process threads, etc. Familiarity with WebLogic/JBOSS application server administration and the ability to help development teams troubleshoot deployment failures. Familiarity Apache web server administration and configuration. Familiarity with Appian BPM suite, with the ability to assist development teams in resolving dependencies, creating users and groups, and importing plugins. Understanding of SQL, specifically oracle data types and syntax, as well as the ability to

I have a subtask that receives a text variable from the parent in the input and is meant to return 2 variables in the output, an AppianDocument and the name of said document as a Text variable. I have logs put in place to see the results of the expressions that run the queries necessary to fetch the document and it's name. And the logs return the following:[WARN] 2023-12-01 13:08:03 01m 26s (0h) - com.novayre.jidoka.client.api.appian.documents.AppianDocument@5ec6for the log that just returns the Appiandocument pv!Document variable. [WARN] 2023-12-01 13:12:50 55s (0h) - Got Document SEC_195818008_08for the log that returns the string "Got Document" & pv!DocName. But the variables in the console appear as null and as a "" string respectively. As if they never got casted. And when I want to return the variables to the parent robotic task, it returns an error. [ERROR] 2023-12-01 13:12:51 55s (0h) - Error executing action [robotic-subprocess->exitV2]java.lang.

Hi, I am trying to configure the Microsoft SQL local database from my machine into Appian application. While doing this I am seeing timeout exception (as shown below). We looked in to the logs and we are seeing the SQLTimeOutexception in the logs (As shown in below image). Are there any limitations with academy version of Appian to connect to the existing MS-SQL database? OR Am I missing anything here? I have reffered the below topics to resolve the issue… Without much help! docs.appian.com/.../Configuring_Relational_Databases.html https://community.appian.com/discussions/f/data/10274/connection-to-sql-server-2016

Hi team, I've tried to run the following query in Appian DB and im getting syntax errors. Please advise  CREATE PROCEDURE process_batches()BEGIN DECLARE batch_size INT DEFAULT 0; SET batch_size = 10; SET batch_limit = 51; WHILE batch_size <= batch_limit DECLARE CONTINUE HANDLER FOR SQLEXCEPTION; BEGIN ROLLBACK; -- Rollback transaction on error END; START TRANSACTION; UPDATE `CM_AH_Segmentation` SET `Handled`=1 WHERE `RecordID`<= batch_size ; UPDATE `CM_AccountHolder` as ah join `CM_AH_Segmentation` as cas ON ah.AccountHolderID = cas.AccountHolderID and cas.OldSegment <> cas.NewSegment SET ah.Segment= cas.NewSegment WHERE cas.handled = 1; INSERT INTO `GLB_AuditInfo`( `ReferenceID`, `Event`, `Action`, `ActorLoginID`, `AppName`, `Comment`, `CreatedOn` ) SELECT cahl.CaseID, 'Risk Investigation', 'Update Segmentation', 'System Admin', 'Risk Investigation', CONCAT( 'Update segment for AH ', cas.AccountHolderID, ' from &#3

Hello, I keep getting the this error in my process model: "Error: Work Item Cancelled (Data Inputs)" on a Create Group smart service node. I read that this is often caused by the assigned user being deactivated, however the lane assignment is to an active user and all notes as assigned in the lane. What else could be the issue?

Hi , we are trying to access Appian by using mobile apps and we receive an error "An unknown error has occurred". By using a browser we don't have that problem. Any idea how to proceed will be much appreciated. BR,Natasa

I've done some searching on this topic, but it's been awhile since this question has been asked/answered so looking for some updated info.  What is the best way to send a text message  to external cell phones.  And to include some custom text and possibly an image in the text. Any insight into this would be super appreciated.

Hello, we've been trying to use PGP Encryption Utilities plugin. From here we're using encryption smart service and no other node (to begin with). Public key was generated with gpg4win (RSA, 3074 bit). This configuration actually returns a different error than other formats so my assumption is this is the correct one. But then a new error showed up running the encryption smart service node "In order to access this method, this Document needs to be retrieved via ContentService.download()" The output document shows in appian designer, has corresponding extension, but is of size <1KB (0 probably) and it's not downloadable. In the PM, when using PV to store the encrypted document as an output of the smart service, the PV ends up with no value. Any sugggestion what could be going wrong?

Hello,  Is there a project manager  / team lead that uses a template for keeping track of projects besides Jira?  We use Smartsheet and I was wondering if anyone could share a template that they use?

Hi Experts  Is there any limit for the length of the name of any object. For example: an object name could not be more than 27 characters, Is there anything like this ? Thank you in advance 

I was reading this article, creating records and related records using a process model, and I wondered if the code for the form interface, Case, referred to in the article is available on the Appian Community for reference. I'm working on a form (proof-of-concept) which has a similar structure as the Case form, i.e. a base record type and an editable grid of related record type on the form.

Hi Appian, I found that there is a cleanup.sh script that helps data maintenance. ( https://docs.appian.com/suite/help/22.1/Data_Maintenance.html#cleanup-script ) From the documentation, is says that [actions] for [data] cleans up old data files (*.kdb) in the live `gw*` directories. What are the content of the data files (*.kdb) that will be cleaned up from 'gw' directories? And what does the 'gw' directories stand for? Thank you

conventional method to find the gratest number using for loop 

Is it possible to get the robotic task, which is custom developed in IDE (intellij) executed in Appian RPA?I am following the documentation on Custom code dev in Appian RPA. Using Guided configurator initial steps are completed with respect to JDK, Maven and IDE setup. After this I was reading Calculator tutorial and downloaded source code file to try and execute the custom developed bot in RPA console.Due to being novice in Java and Maven I am not able to understand fully how the IDE connects with Appian RPA console, - how do I get this calculator bot imported/deployed and then executed in Appian RPA.- Do I need to create a bot in RPA first and then export it, copy it in my IDE project folder, copy calculator code and then run some deployment command or how?Can someone simplify it for me and explain how to achieve this? If possible, please distil it down in steps.Thanks in Advance.

Hi, I'm just wondering if there are any log file in Appian where I can find: - The request that an integration object send and the response it gets.  - The request that a webApi execution get and the response it sends Is that information logged any where? To get that information, talking about integration, I keep the request in a process variable to help on debug tasks with other development teams, but I prefer not to do that, in order to keep process memory consumption low. Thanks in advance!