Process Modeling

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

We have a sent functionality having "Appian Group" in the To field. Group have users and it is working fine in our DEV and SIT environment.But the problem is, not working and getting this error in UAT and PROD environment alone. I gone through some existing threads and they suggested to use toemailrecipient() function. We didn't use, but it is working good in DEV and SIT. So, please suggest what could be teh problem with higher environments. Problem:  An error occurred in executing an Activity Class. Details:  No valid recipients resolved Recommended Action:  Examine the activity class to correct the error and then resume. Priority of this problem: High Priority

Hi, I am trying to use Start Process Smart Service to initiate processes conditionally. It is a MNI. Sometimes the process runs without any issue, however, sometimes the child process that was started gets stuck at start node without any errors in the instance. Does anyone have an idea regarding this? Any help is appreciated.Refer the flow below :-1st PM - the smart service runs as an MNI, triggers multiple instances  3rd PM - Review Process:It gets stuck at start node or script task node and does not move forward. Thanks

i am trying to use import csv to db, with using these columns, but only 3 columns value is going to save and other columns save with null values. give me quick solution for it ="Region, Country, ItemType, SalesChannel, OrderPriority, OrderDate, OrderID, ShipDate, UnitsSold, UnitPrice, UnitCost, TotalRevenue,T otalCost, TotalProfit"

hello,  I have to record types as rule inputs in an interface and I wanted to just save the record types through process model. Record type A is getting updated using write record smart service. where as record type B , I am not sure, how to do it. Can you please guide. 

Hello Folks, I got this below error in my process. I am not updating anything in the process. Please assist An error occurred while trying to write to the entity "EMP_CASE " [id=916ee3cb-938e-4931-a61b-ba630fe5a543@61527, type=EMP_CASE (id=5350)] (data store: EMP Main DS). Details: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement: org.hibernate.exception.ConstraintViolationException: could not execute statement: java.sql.SQLIntegrityConstraintViolationException: (conn=7948467) Duplicate entry '229' for key 'EmpID': org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Duplicate entry '229' for key 'EmpID': java.sql.SQLException: Duplicate entry '229' for key 'EmpID' Data: TypedValue[it=5351,v={{<null>,229,eFront,89777,<null>,<null>,Open,0,TEST,Case,1,1,0,,1.0,56777,<null>,<null>,,,<null>,,<null>,,<

Any latest plugin or smart service to call subprocess dynamically ?

Hi All, There is only one instance failed when calling a start process smart service  - Error when parsing process details or variables Activity chaining enabled in child process. Error Logs - TimeoutException: Timed out sending PROCESS.getProcessDetails to execution04 ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=3271473, classname=com.appiancorp.process.runtime.activities.StartProcessSmartService2 com.appiancorp.suiteapi.process.exceptions.SmartServiceException: userMsg[error.processDetails.userMsg=Error when parsing process details or variables] alertMsg[error.processDetails.alertMsg=Error when parsing process details or variables] at com.appiancorp.suiteapi.process.exceptions.SmartServiceException$Builder.build(SmartServiceException.java:145) at com.appiancorp.process.runtime.utils.SmartServiceExceptionFactory.createException(SmartServiceExceptionFactory.java:14) at com.appiancorp.process.runtime

Hi All , How can we manage memory consumption in process model , so that it wont be more than  10,00,00 AMU .   ( the ways we can follow to reduce memory consumption in Process Model ) .

Hi All, When starting the process model again and agian facing below issue can you. Please help to find the best possible solutions? Error when parsing process details or variables Regards Nishtha Bhatnagar

I have a requirement where the processes are scheduled within a range of 12 hours, let's say 3 PM to 3 AM, with a time gap of 1 hour. So my batch process should start at 3 PM but after first instance it should be triggered after every 1 hour till 3 AM. Is there any way we can achieve this using Timer event? Also, I am recording the scheduled date and time in the database. Is it possible to directly get that time and start the process with it? Any ideas how we can achieve this?

Hi everyone, I am trying to fetch archived process instance details based on process model and date. I have tried below approach: - 1.Using find archive smart service which is part of Process Management Utilities plug-in, but the smart service isn't returning any output regardless of the details I have provided. 2.Through log file but the file which is generated in system logs are dynamic (based on timestamp) due to which I am not able to use this approach. Please help me to find a way through which I can fetch archived process instance details.

What is the maximum size limit of process variable in Appian?

I want to delay the Timer Event for Exactly for 1 second and followed the appian recommneded process  accordingly still there has been no effect  The Duration of that node is always less than 1 second some times  like 0.58,0.060.8,0.36 these were the values seen.I want to see Exactly 1 second. Is there a way to configure to delay the node for exactly one second Thanks In Advance

Please help me. Zar file inside log4j.properties are missing as per command.  i m very new in Appian.if you have any link from where i can learn testing . Please share. Thank you very much in Advance.Fitnesse tools i downloaded from below link https://community.appian.com/b/appmarket/posts/fitnesse-for-appian.  where log4j files are missing as per error.

We have a handful of process instances not archiving: 1. Process model's data management is set to archiving 3 days after completion or cancellation, and there are no previous versions of the process model object 2. Instance shows up in monitoring with a green checkmark and all nodes in Process Node under Process Details are completed 3. Nothing shows up under Current Tasks, Quick Tasks, or Sub-Process 4. It looks like the process was manually restarted (start node in the middle of process history) - this restart did successfully run until End Node. End Node also finished at the same time as another node.  Was just curious if this was expected behavior or something that needs more investigation.

Currently, after submitting a form, a new form appears with the previous values for some of the fields , how to fix this issue

Hi, I have a process model with an Export DSE to Excel smart service and it exports to an Excel file stored in a  folder dedicated for this functionality in my application. During QA testing, 2 different basic users who are in the same parent group and the group has Viewer access for the folder security. One user can successfully download the exported Excel file, while the other user's process instance gets the folder security error "The specified Save in Folder doesnt exist or you do not have enough privileges to access it ". I resolved it by setting the Export DSE to Excel smart service's assignment to "whoever designed the process model" but still would like to understand why 2 basic users will see different behaviour in the process when that node is set to "whoever started the process" as the assignment. TIA

Hi Everyone , I am getting an error in write to record node in the process model. we had relationship between two records, the table name of the parent  record was modified and it was throwing an error in Process model. telling: table does not exist  "The table name(old table name) " ,later the parent record was removed from application ,and the relationship is also removed. Even now I am getting the same error. when I am not even referring that record ,I am getting an error saying the older table name does not exist ,the table name is modified and record is removed ,why am I facing the error still? Pls let me know the solution

Hi there! I'm facing this timeout issue - "The amount of time allocated for the completion of an unattended activity was insufficient to allow the activity to complete" in process model SFTP Smart Service. This issue occurs in the last instance of 20+ iterated instances and it resolves as soon as I retrigger the node. That last instance has only 4.87 KB JPG file to transfer. Anyone faced such kind of issue and how did you resolved?