Process Modeling

when user upload any kind of excel sheet then interface will extract data and show the user the data. I have created a Expression rule  readexcelsheetpaging(excelDocument : todocument(ri!ExtratExcel), sheetNumber : 0,pagingInfo:a!pagingInfo(startIndex:1,batchSize:1000),) but don't know how to add it in script task and make process model out from this.

Hi All, I have updated a CDT and table by adding a new column and deployed those changes to PROD. Now I have couple of active process instance of each request in PROD which is using old CDT version and I need to fill new column with a specific value as per customer request. Since we have " write to data store entity" smart service in active process instance, even though if i try to update backend table directly to update that specific column for each request, the column value changes to Null when process moves forward(Specifically after "Write to DS entity"). Please suggest an approach to resolve this issue. Thanks in advance

Hi Appian, There is a Process model(A) and within it there is Process model(B) as sub-process. When executing the process, it works fine with great performance for the first loop. (less than 1 sec) But for the loops after the frist loop, the process performance slows down massively (more than 13~16 sec, at least 13 times the first loop performance.)     The preformance of the process slows down massively. And this is a critical problem for us. What might be the reason for slow down of the performance. And how could we fix this? Thank you

Hi, I have a very basic process model where I'm setting a new value for a users first name and last name, then setting a new value for the username and finally deactivating the user. The process has been working as expected for approx. 1 month but is now showing this error on the Rename Users Smart Service: The amount of time allocated for the completion of an unattended activity was insufficient to allow the activity to complete. It also sporadically shows the following error, again on the same Rename Users Smart Service node: An error occurred in executing an Activity Class. Error in the tomcat.stdOut log: 2022-03-23 09:46:44,983 [ajp-nio-0.0.0.0-8009-exec-836] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=536877698, classname=com.appiancorp.process.runtime.activities.StartProcessSmartService2 com.appiancorp.suiteapi.process.exceptions.SmartServiceException: userMsg[error.initiateProcess.userMsg=Failed to st

I am trying to create an excel sheet with the data present in my PV variable, this data is not directly from the SQL database as i have to modify it before writing it to the excel. Can you please tell me which smart service i can use. Export Data Store Entity to Excel/CSV isn't giving me the desired result as the requirement is to use the data in PV variable not from the DB. Please help me here. Thanks, Preji

how to import old data for task report? We are migrating old data to db and  we have some process/task report which is not updating tha db data to UI grids.

How to ensure a process have a well-defined life cycle? (select multiple from bellow options) a. configure process data management settings b. use a terminate end node to complete workflow c. configure all processes as sub-process that are quick task d. configure exceptions on every node in process. 

how can we import the process instance from one env to another??

I am trying to Execute a SP from Query database Smart Service in Process model and getting a Timeout Error.I wish to Handle the Process flow and not let the Process stop immediately and continue the Exception path. Note : i cannot use Execute Store Procedure Smart Service as my SP is taking longer than 10 min.

I have configured a start node that with a receive message trigger that essentially captured information from an email. I have configured all the proper fields but I the "Attachments" field does not seem to work. Documentation has not been particularly helpful in this case.  I have a PV of type Integer that can also handle multiples and the following is mapped to that PV: property(msg!properties, "Attachments", null) When I send an email to the process using its UUID, it captures all the fields correctly except for the attachments. Is my configuration incorrect?

How to Start a process model with out start form or how write expressions for for button to start process model in interface

"java.lang.ArrayIndexOutOfBoundsException" error thrown while running parse Excel to CDT process

There is a new column added to the table and accordingly made changes in the CDT.I am receiving this error while saving data to the table. Can Anyone help with this? Thanks in Advance.

Hi everyone, apologise if this question has been asked before as I couldn't find the it anywhere :) I want to update date time value of 2 columns (createdDateTime and updatedDateTime)  in my data table by using Write To Data Store Entity.  I already have a CDT that has primary key matching with my data table. For configuring Write to Data Store smart service node, I want to config this node to update the 2 columns (createdDateTime = pv!createdDateTime  and updatedDateTime = pv!updatedDateTime) where Id (primary key column) = pv!id. How do I achieve that? Thank you! P/s:  I tried Execute Store Procedure smart service but not sure why it updated only 1 column with my input date time, but the other column was not updated, and I couldn't find the reason for that. That's why I tried to change to Write To Data Store Entity to see if this works

Hi All, Please see the below screenshot on PM user input task node I have enabled the option Execution Options --> When this node is chained:---> Allow users to step back to this node from the next chained activity. But on the last user input task form go back button not showing, Please suggest where I'm lacking

i have a process i d which is getting stored in the Db and getting data using exprule and displaying the data in the readonly grid. now my question is  i have one grid column which is have icon on click on it should trigger the process instance of the particular record how can i achive it ?

How to do mathematical calculations based on the received value. Example : «${d.cost.price}» * «${f.quantity}» how to product of these two values and what is format to use to get the final result of this product. even for addition. Please suggest .Thanks in advance.

Hello Everyone, I am trying to pass the data into the word document but facing an error.I have followed the required annotations for the girds even though couldnt able to run sucessfully. Please suggest if anyone also faced the same problem or how to resolve. Thanks in advance.

Hi All, One of the user from our organization has left he has some 300 active task's assigned to his name, how we can close this task's.  Thanks in Advance

Hi, what we need to do if process model is consuming a lot of memory and due to  this appian environment getting very slow.I have already set archive (3) day from data management tab. Is Manually delete processes that have already been completed or cancelled is a another good option?

Hi , My process was getting errored out at Parse XLSX file node saying  Error: An error occurred while evaluating expression: Output:rule!s_CRDoc(pv!changeRequestFile_doc) (Expression evaluation error in rule 'c_doc' at function 'readexcelsheetpaging' [line 8]: com.github.pjfanning.xlsx.exceptions.OpenException: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Invalid byte 1 of 1-byte UTF-8 sequence.) (Data Outputs)

So I have an interface that is saving two array of CDTs the idea I was having is that it would store each iteration of the array into its own respective row for the array example: {[uuid:1, fkuuid: ab32, date: today], [uuid:2, fkuuid: cd43, date: tomorrow]}. In the database there would be a row for UUID 1 and a row for UUID 2 but when I execute the write to data store entry I only get uuid 1. To push this even further I am doing this two times for separate tables and its only putting 1 entry into 1 table.  If there is any more information that is needed let me know! Any Ideas on how to get it to save all the information in the array of cdt to each of its separate rows?

Hi,  I have Process Model with user Input Task, I am assigning task For Task Approver if that task Approver Not Approve that task In 24 hours, that task was automatically Approved After 24 Hours. How I can  achieve this  Thanks  Prashanth  

Hello, I'm working right now on increase the performance of my project and I'm been searching what could I do, in the academy the suggestions are, to replace subprocess for Startprocess etc. Well, I have a few question that I could testing but i want to hear if anyone has this answers. 1: in a process model, if I put 3 script task with diferent action, does anyone knows if its better to put all in 1 script or is the same?  2: which is faster, put multiple nodes of smart service to Write no DSE or put 1 of Write to multipleDatastore? 3: I have seen multiple flows that do not need to wait for the previous node, is it viable to use the "AND" GATEWAY to execute multiple nodes at the same time and this shorten the time or has that affect the performance of the process?

I have a condition where i wanted to do null check if either of the IDs are null it shoudn't write to database. I am using this code in task output. remove( wherecontains( or(a!isNullOrEmpty(pv!primaryId)), a!isNullOrEmpty(pv!selected) rule!NV_constructCDT( formId: pv!form.FormId, primaryId: pv!primaryId, secIds: pv!selected, ), )) Do you have any ideas to optimize this implementation? Thank you