Process Automation

Hi All, I have made my Appian Environment through appian community, but i am not able to see admin console and Appian cloud database. they are giving me the basic user permission not system Admin. earlier we are able to see Admin console and cloud database but for new version we are not able to see admin console. so how we can connect data source how we can see value in database if appian cloud database is not visible.

Hi, overview : 1. I am sending a email to process model and store the data's in pv 2. With the use of (Create Eml File from OOTB Poller) smart service generating a document in EML format 3. In classify email AI - passing the generated document as input. I am getting an error saying " The user does not have permission to view document " in classify email All objects(AI,process model,document folder) have Admin access Also the generated doc from step 2 is showing "not in the application" but it is in document folder within the application Pla suggest a solution to resolve this. Thanks in Advance

Hello Everyone ,  so i was having query regarding Doc Extraction skill's , anyone is having idea that how we can achieve Checkbox field extraction without having Reconcile DOC task ? because of this issue i have to look for AWS services for the same , it would be so useful if checkbox and table field we can extract automatic from Appian itself without having reconcile task! 

I have this array {100, 50, 20,50,10} and a variable x = 600, I need help to create a rule that creates an array with the results that must be calculated in this way: The first value of the array must be subtracted with the variable x, the result must be subtracted with the second value of the array, the previous result must be subtracted with the third position and so on. The results must be stored in an array. At the moment I have this code but it does not work correctly a!localVariables( local!regularizaciones: {100, 50, 20,50,10}, local!initialValue: 600, local!resultArray: {local!initialValue}, a!forEach( items: a!forEach( items: local!array, expression: fv!item ), expression: a!localVariables( local!currentValue: fv!item, local!lastResult: index(local!resultArray, length(local!resultArray)), local!newResult: local!lastResult - local!currentValue, local!resultArray: append(local!resultArray, local!newResult) ) ), local!resultArray ) I appreciate any help

Hi everyone,I need to control the font size in an email whose body is generated by an expression rule that generates the corresponding html. The problem is that the font size that I specify in the html does not correspond to what the email finally has. For exmaple, this HTML <p style='font-size: 14px;'> Hola, la solicitud se ha completado y puede generarse el acuerdo en Vistex (adjunto fichero de carga)<p> should be 14 px. However in the emali the font-size is 10.5px.

Hello  I uploaded 10 pdfs, did mark the labeling then submitted for training how long does it take before i can publish, is it 30mins ?  Is there some way to calculate this time 10 docs, 50 fields each page one page doc, structured pdf , ex:insurance Acord form

{ 'a': true, 'b': true, 'c': false, 'd': false } The code above should dynamically be converted to  { { 'a': true }, { 'b': true }, { 'c': false }, { 'd': false } } is that possible? Thanks in advance

How to integrate python script into appian robotic task? I have to create an Appian BOT to convert doc file into pdf. I have created python script for that. I dont know how to intergrate it into appian rpa. can anyone describe whole process of conversion ?

Hi All, I am trying to fetch data from Oracle DB using a query rule with batch size as -1, but the system is throwing the following error : Expression evaluation error at function a!queryEntity [line 2]: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [DataTypeName], query: [queryentity expression], order by: [[Sort[primaryKey asc]]], filters:[((Ts= TypedValue[it=9,v=3000-01-01 00:00:00.0]) AND (Valid= TypedValue[it=3,v=Y]))]) It had data of 147 rows and if I use batch size of 100 with start index 1 it's sometimes working but when I use startindex as 101 it's always failing with the above error.I am facing the same issue with some more tables from the same Oracle schema.Here I am attachinga!queryEntity( entity: cons!DSE_TABLE_NAME, query: a!query( pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1, ) ), fetchTotalCount: true ) the sample Code I have used.

Which types of objects can be called using the "rule domain" prefix? A.   Connected systems, records, expression rules, and interfaces B.  Decisions, expression rules, interfaces, and integrations, C.   Process models, integrations, expression rules, and constants

Hi, I have downloaded the agent yesterday and launched the robot manually and status of the Robot is online. After the testing is done, I have quit the robot. Today, I launched the robot again and the robot status is offline.  it is saying Resource/ nodeNotSet v9.10.1 . If I download the agent again from operations console, its working fine. If I want to use the agent downloaded previous day, it is not working.   [mention:fcc981e8b4ba4f2ca9666e0fe8df41f0:e9ed411860ed4f2ba0265705b8793d05]  help me in this

Hi all, I've been attempting to create a simple AI skill for document extraction on 23.4. I created a new AI skill with basic security, hit "Create First Model" and started going through the steps. First, I uploaded 25 sample documents that fit the Appian requirements (must be .pdf, must be smaller than 7mb individually, must be unique). Once the upload was complete, I proceeded to the next step "Add Fields to Extract." From there on out I will randomly get an Error 403 - Access Denied. It can happen while editing a new field name, sometimes it happens once I start labeling the documents (if I even get that far). I tried scanning the tomcat log file for info but couldn't find anything related to AI Skills in there. Anyone know what's going on? As far as I know there shouldn't be a special privilege group for editing AI skills or I should have seen an Appian error before that, right?

I have a datetime field in DB. When user selects datetime from interface, i want to make sure that date doesn't already exist in DB. Basically, i am trying to fetch duplicate requests for a day.  I cannot use "=" operator since field is of datetime type not date and if i use other operators such as startswith, in, includes , it gives me error i.e. Cannot apply operator [INCLUDES] to field [dateTime] when comparing to value [TypedValue[it=9,v=2024-07-05 05:00:00.0]].

Hi experts, We have been able to establish connectivity to a HANA database successfully. The HANA stored procedure is expecting the values to be passed, enclosed in single quotes - 'Value1, Value2'. A query like below works perfectly fine. SELECT * from DB_SCHEMA.VIEW_NAME('placeholder' = ('$$list_name$$','Value1,Value2')) However when I try to pass this list as a parameter, I am getting an error. SELECT * from DB_SCHEMA.VIEW_NAME('placeholder' = ('$$list_name$$',{parameter})) Has anybody integrated with HANA DB before and has a reference to how we can achieve this by passing dynamic values via parameter with the main criteria being include parameter values in single quotes?

Hey Guys, We are trying to use recordsChatField component in the interface but it is giving the below error. Any help will be appreciated.

Hi All, I have recently utilized the AI skill where I have used it as Document Extraction. Once the Extraction is done I am able to publish the AI skill and utilize it in my Process Model. I am also able to extract the data. I now used the Reconciling SMart service and able to Map certain fields which are not picked by the AI skill. Now How do i train my Model to pick those fields going forward for the Next set of Documents.? Basically How do I retrain my Model. Thanks  Harsha [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] [mention:31db00b785704865b14e5d9b9bef3863:e9ed411860ed4f2ba0265705b8793d05]  Really appreciate your help in this.

I would need to run two wherecontains within this dictionary array, for example to get a country with a POPULATION greater than 1,000,000 and an AREA greater than 150. how can I proceed with two wherecontains? thanks

Hello all, I have a question that I think it should be easy but I cannot figure it out, and also I cannot see any response in this forum. If I have a a!forEach within another a!forEach, is there a way of refering to the items of the outer loop, within the first loop? Example to understand with non real data:  I have two lists: local!text: {"1111 - GREAT", "1000 - BAD", "5600 - MEDIUM"} local!words: {"GREAT", "MEDIUM"} as you can see, "text" is a list of text, and each string contains a code a "-" and a word. I want to create a nested loop that returns a list with the codes only when the words contained in the list "words" are in the list a.In this particular example: {"GREAT", "MEDIUM"} because "GREAT" is included in "1000 - GREAT" and "MEDIUM" is included in "5600 - MEDIUM". I woud like to iterate though every item of list &quo

Hello All, Is there a way to pass system message to Appian Records chat to set the tone to the interactions? To be more specific, I want to display a value as chat response that is dependent on a column of the record type instead of displaying the exact value from the column. I am able to achieve it using prompts, but I cannot expect users to write this prompt every time they interact with the bot. 

Hi, I am going through the RPA Tutorial Browser Module. In same while trying to add action "Enter Search Term", post executing the robotic process, i am getting below warning The element (By.name: q) could not be interacted with because the component is currently disabled or hidden. Can anyone suggest what can be done in this case, as the RPA client is not able to enter value in search box due to above issue

Hi guys, I have create a RPA task and calling it in the process model. In the process model the integration throwing "Execution results must be available on call back to Appian." But the RPA task is running without any errors. Can anyone help on this please?

Hi, I have a problem with a robotic task executed by a service account and the privileges to open a browser. I created a robotic task that starts by opening a browser to download a PDF. When I manually execute the robotic task, it runs without any issues. I'm using an execute robotic task node in a process to run this task. I created the integration with the connected system using an API Key from a valid user (Service Account). This user is included in the security settings of the objects related to the task. When I run the process and the robotic task is executed, as the execution of the node is assigned to the Service Account user, I receive the following error: "[STAT]            - - <ACTION_START> - Start action 'browser->open-browser-v2' - 'Open browser' // dur: - - avg: - etc:[ERROR]       - - Error code APNX-1-4530-000 with message "Unknown error. Please contact administrator with the follow

Hi,  I am using RPA to create an automation which opens up a chrome browser, logs-in into a webiste, filters data and gets a file downloaded into the local host machine There are 2 problems that I am facing  1. It takes ages to even open up the browser  2. While trying to open the browser, it searches for a chromewebdriver to be present inside its assets file in local host machine. Now even though there is a webdriver existing inside the host machine, it gives an error saying :  WebDriver file does not exist. Attempting to auto resolve it from the console... Can anyone help me in getting an idea so as to why such issues are happening ? Screenshot 1 : describing issue 2  Screenshot 2 : File present in the required destination System specs :  Chrome Version : 123.0.6312.87 (Official Build) (arm64) OS : MAC M1 Pro Java Version : 21.0.2

I get an excel file with the process model and store it in "pv!copyTemplateExcel". I specify it in "Open or create workbook(License not required)". But I get an error saying "[Document:10814]" cannot be opened because it does not exist. Could you please tell me the solution?

Hello team. I am trying to automate process that involves downloading a PDF of a quote from an external service application site and emailing it to our company. In Robotic Task, we can specify the file in Upload Document in Robotic Task and the file will be on Appian. I believe I have to upload the document and output it to use it as a variable. However, there is a problem with the file path. It is not known what the name of the file is that PRA downloaded from an external site, and I am facing a problem that I cannot specify it in the development screen of Robotic Task. Below is what we have tried to do for this problem. It was not acceptable for RPA to change the name of the downloaded file before downloading the file (cannot click on the item inside Explorer). I can find out the name of the most recently downloaded file at the command prompt, but RPA cannot enter that code at the command prompt, and RPA could not read the command prompt results. If anyone knows of a workaround, plea