Process Modeling

I have inserted a new value in a database . (Scenario here is I have used a parent process to capture the values and sub process to write into the database.) Then again I update that particular value (Scenario here is I used different process to get all the updated values and used the same sub process to write it to the database). But the updated values are not getting reflected in the variables tab .It is showing the values that I used while inserting  but in Process history tab the values are updated properly. I have mapped the input tabs properly. Can anyone please help me with this scenario.

I want to publish all process models using a single user. Is there an efficient way to publish all of them at once, rather than publishing each one individually?

I tried upload the template(Doc) many times after editing those not working fields plenty of times  but still the fields seems like above

Hi All, I have a record type process variable  - MAC User (list), This record type contains the list of users and their information like name, email, last name etc.  I'm trying to create the users within appian with the Create User Smart Service, but since its a list is not allowing and its throwing an error, do I have to do a loop for this? I was thinking the smart service could create more than one user at the time. If looping is the only option - can someone recommend what would the best way? thanks in advance

Hello Folks, I am getting this error while write to Data store entity.:"An error occurred while trying to write to the data store. No values have been written. Details: org.hibernate.PropertyValueException: not-null property references a null or transient value :" Can anyone help me on this? Actually I want one column in a table is non nullable that is also behave as a foreign key. Thanks

Hi everyone, I was tasked with creating a process model to rename users using the rename users smart service. I only have the Start Node, the Rename Users node and End Node. I have multiple questions that I need answered that can hopefully help me get started as I am unable to find the guidance I need in documentation and other threads. Here are my questions: What other nodes do I need/should I have? When configuring the Rename Users Node what do I put for "Value" and "Save Into" for Inputs? For the Rename Users Node how should I configure the Outputs? I would also appreciate any other reference material you all might think is helpful. This is all I've found so far, and it wasn't enough to help me get started: Rename Users Smart Service - Appian 24.3 

I am creating a vehicle rental application. I wanted to change the rental status of the application after the supervisor accepts the task Here in this process model, how do I get the value after supervisor (supervisor change status node) accepts a task. I want to use write records to change the value of rental status to false.  Could someone help me with this.

am getting this warning

Hello, I have a process for parsing data, and in one of the nodes, I'm checking whether the respective alert exists for a specific event. The script task has one output, which uses a QR rule to retrieve the alert based on the event's alert ID. The retrieved alert is then stored in another variable. The QR rule returns a single alert, which works as expected in all other environments, but in production, the result is null in the process model. This issue has also occurred with other processes using the same rule and having multiple outputs, but when we split the logic into two subtasks, it worked fine. However, for this process, the problem persists. Could you suggest what might be causing this issue?

I am creating a practice application that takes in a pet's owner, and the pets that the owner has. Because the owner can have more than one pet, I have created an editable grid that passes the input pets in to a rule input that stores them as a "list of recordType!w0428pv pet". I would like to be able to use the write records smart service to take that list and input it in to the database as individual records but I'm not sure if that is possible or the right way to go about doing this. I believe the process variable is storing the array of pets correctly, as it looks correct in the preview on the design page. Any advice would be greatly appreciated! 

hi  i would like to know if there is anyway to stop the scheduled process model during deployment

Hi Team, The custom sender email functionality was working fine until last day in the environment. Suddenly it had stopped working and the send email node is getting errored, and error message says, "Failed to send email". Have anyone faced a similar issue, we have also observed that all the other mail functionality like process model is working fine. Please help us on this issue. Thanks.

HI Team, I see sometimes my form is not submitting and moving back to home screen but backend the process is moving furthure?, Is this an environmental issue ? This issue is causing only for few open tasks but not all of them ? Below is the submit button code  a!buttonWidget( label: "Submit", submit: true(), validate: true(), value: true(), saveInto: { a!save(ri!submit,save!value), a!forEach( items: local!data, expression: a!save(ri!II_DT_DocumentClassification, append(ri!II_DT_DocumentClassification,fv!item)) ) }, style: "PRIMARY" )

Hi  I have a parent process which is deciding startDateTime and  delayMinutes and then passing this parameter to start process smart node which is delaying the subprocess with this set up: pv!startDateTime + intervalds(0,pv!delayMinutes,0) . However, this should delay the process by calculated time. But it is not delaying it at all.  I want to ask,  How to implement Dynamic delay in timer? Does intervalds does not work with process variables as parameters?

I am executing a process model from an interface on button click using a!startProcess, and saving some of the process variables (lists) on the OnSuccess parameter of a!startProcess into UI variables. The process model has chaining enabled on all connections, both in the parent process and two sub-processes.  Both sub processes run synchronously, and execute at the same time.  In both sub processes, I loop over an integration using a counter variable (not MNI). The issue that I am seeing is that the saves on the OnSuccess parameter of a!startProcess execute before the process is complete, so I either get no results from the process at all, or partial lists.  When I monitor the process, it executes successfully and all the expected values are there. How can I ensure that the entire process executes before the OnSuccess saves execute?   The process typically takes between 1-3 minutes to finish.   Note: The goal of this process is

I have this statement as the SQL statement on a Query Database node:UPDATE `ThisTable` SET `Status`= ac!closedStatus WHERE `TableId` in (ac!ListOfTableIds) ac!closedStatus is an Int, ac!ListOfTableIds is a list of ints. When I run the process, the Query Database node errors with this error: There was a problem executing the SQL query. SQL Message : class [Ljava.lang.Long; cannot be cast to class java.lang.Long ([Ljava.lang.Long; and java.lang.Long are in module java.base of loader 'bootstrap') I know I've gotten "IN" working on query database before, I just always forget the trick. Does anyone know it?

Hi, I am trying to call a process from parent process model but the start form in child process does not open and flow just pass through it. I tried with activity chaining or used subprocess but nothing worked. One way i know to change the process start form to task based form but wanted to check if there is any other way without it? Parent PM: Child PM:

Hello All, I need to create a Scheduler which marks all the existing records under in table against column Is_observed = 1 at the end of each year starting December 31, 2024. Is this good to go?

Is there a way to get some output back to the interface after executing a!startProcessLink(), or a way to update some variable inside the interface to insure process has been executed  

Hi, we are having a problem executing an expression rule, which contains an a!queryRecordType, where we have: - 1 grouping field - 1 measure field - 4 filters,  on a batchsize of 500 items. In detail, every time we try the rule from expression rule the result is correct but when we insert it in a script task from process model it randomly gives wrong results (correct measure corresponding to wrong group fields). A delay of 1 minute after last node has also been inserted in the process  activity. What could be the problem? Thanks,  Francesca

I have an integration that I save the output into a DataSubset object and want to use to update a table in the database with a Query Database task. The DataSubset is as followed: DataSubset startindex null ... data [List of Dictionary - 1,000 items] Dictionary EMPLOYEE_ID "1" PAY "Hourly" ... In my Integration task, which is the first task, I save the output to a Result variable (which is type of DataSubset). Now in the next task, I add a Query Database task that I want to use to update a table where the EMPLOYEE_IDs match Would it be: "Update users set pay = ac!Result.data.PAY where employee_id = ac!Result.data.EMPLOYEE_ID;"? This doesn't seem to work. What am I doing wrong or what's the right way?

I developed a process model with a form that collects employee details. If the "submit" button is clicked, it moves to a user input task with "Approve" button. Upon pressing this, the details are updated in the database. The issue is that when I run the process model in debug mode, it works perfectly, but when I run it through the site action button, the first page is displayed but doesn’t proceed to the user input task. Instead, it stayed on that page. Please provide a solution.

Hi, i've this pm with the following error in interface I post the code of interface but not so precisely where the error may be a!localVariables( /*utente e lavorazione*/ local!utente: rule!TES_getUtenteWeb(utente: ri!utente), local!idUtente: index(local!utente, "id", null), local!lavorazioneFO: a!isNotNullOrEmpty(local!idUtente), local!tesseratoDB: rule!TES_getTesseratoByIdTesserato(id_tesserato: ri!richiesta.idTesserato), /*modifica anagrafica: nome, cognome, dt_nascita tesserato*/ local!anagraficaModificata: a!refreshVariable( value: rule!TES_checkModificaAnagraficaTesserato( tesseratoDB: local!tesseratoDB, tesseratoModificato: ri!tesserato ), refreshOnVarChange: { ri!tesserato } ), /*gestione omocodia per disabilitare controllo congruitÃ%A0 e calcolo automatico del codice fiscale*/ local!is_omocodia: false, /*variabili per selezionare il tesserato dalla grliglia omonimi/giÃ%A0 censiti*/ local!confermaAttivit

Hi, I am Using Send E-Mail Smart Service for this email sends. I am sending HTML code to display an image in the body of the mail. when the recipient's email is from microsoft, this work correctly but when the email is from Gmail it is not displayed. I am sending to build the image: <img style='display: block; margin: auto;' src='data:image/png;base64, -- base64 -- alt='Logo' width='200' height='50'> What could be the reason?Gracias

I am trying to upload data from CSV to DB with these columns value -  Region, Country, ItemType, SalesChannel, OrderPriority, OrderDate, OrderID, ShipDate, UnitsSold, UnitPrice, UnitCost, TotalRevenue, TotalCost, TotalProfit" but having a issue while save the data to db... it save the first 2 columns value and orderId value(PK) only and other columns saving with null value..... please give me a quick solution