Process Modeling

Hi All, I have a scenario where i am facing some issue: I have a process model to create a data into db by using import excel to database, when i add the data in excel and upload its working as usual, but when i miss some rows in excel while adding data and uploading. process model is not writing that data in Database, its simply completing the flow but not writing the data.

In table we have two fields id and status but according to id i want condition like if status chnaged to cancelled then it should move to end node how i can use this condition in XOR gateway ?

Hi, understand from the documentations that the limit of activity chaining is < 50 nodes. Want to understand if the limit includes the nodes within synchronous sub-processes? Also what if the sub-processes ran multiple times?  For e.g., parent process has 40 nodes, including a synchronous sub-process with 15 nodes. Does that mean that somewhere along, the activity chaining would break? What about this other scenario - parent process has 20 nodes, including a synchronous sub-process with 10 nodes but it runs multiple times (let's say 4) - would activity chaining break in this scenario as well?  For some context: We are trying to implement a search feature for our client that requires the integration between 3 APIs... in our interface we are using a!StartProcess to trigger a process model and using processInfo to get the process variable to display the results of the integration. But ofc our process model is too large (with each integration as their own sub-pro

Dear Appian Community, I'm seeking clarification on process upgrades in Appian and how to address failed requests in production. I've been unable to locate a specific plugin for process upgrades. Currently, I have numerous requests in production that are failing due to exceptions. I need to update the process for these old instances to resolve the issue. Could you please advise on the following: Is process upgrade functionality still available in Appian? If so, how can I perform a process upgrade? How can I effectively handle failed requests in production and update the process for existing instances? Your insights and guidance would be greatly appreciated. Thank you for your time and expertise.

When triggering a process model from the Receive message event by sending a simple mail, it works fine. I'm having an error like the above when adding an Attachment to the Start process triggering mail also, I'm having an Error with Create Eml File from OOTB Poller "An error occurred while creating the note. (APNX-1-4101-005)" These are the PV ...

Hello everyone, I am building an Appian process that needs to have only one instance running at a time, since every instance would be inserting to/ truncating the same database table. In order to achieve this, at the beginning of the process I check if the current instance is the oldest among the active instances of the process, through a query to a process report.  This works just fine, the problem is that I want to also check if the oldest instance has, for whatever reason, a node with error and therefore it's flow has been blocked. This way I could kill that instance or skip it in order not to block the other instances in the queue. What I noticed is that even though a process may have a node with errors, the status in the process report remains "Active", so I couldn't find a way to verify through the Report. Even the functions num_problem_tasks() and num_active_tasks() are not helping.  Do you guys know of any efficient way to make this control

We are using Write to Multiple Data Store Entity smart service to write multiple Process variables at once ( In that couple of Process Variables are null. ). After writing to DB in output we are trying to get data written back to PV using ac!storedValues.   However even though PVs are null, after writing to DB it is returning empty CDT instead of null.

Hi Team,I have a PM which will trigger every 1hr and waits until the time resulted by a rule. So while testing this is working fine in development and certification environments but in pre production environment it somehow converting the time in different format. for example: the date mentioned in the DB is 12:30 AM but the rule giving 12: 30pm in the script task of the PM.Anyone knows what is happening here? [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05]Thanks in advance

Hi Team, I am currently using 22.4 Appian community version and while trying to submit a record using write records smart service, i am getting the below error: Please help me fix this. Thanks, Kiruthika S

We have 9 years process model which has few instances running currently on production. In which they have assigned tasks to one particular user who had left the organization now. How we can handle this one? 

Is it possible to direct flow from Write to DSE Smart Service on error?  Ideal scenario would have the DSE node fail, and based on error, flow would continue to different node.  Right now process pauses when DSE fails and email goes out. Is it possible to continue process flow on DSE fail?

An Award Record has 3 sections: Section 1, Section 2, and Section 3. Section 1 and 2 combine to serve as a unique identifier. When you edit Section 3 of an Award Record, all of the Awards with the same values for Section 1 and 2 should be updated as well. This process model updates the value for Section 3, but it does not check to see if there are other awards with the same combination of Section 1&2 before writing to the DB. I was told to "build a dictionary in building the CDT before the DB write and write the array". Any help would be greatly appreciated! Thank you

Hai, I'm currently creating a Process model for adding employees... I had done all the things... the data also stores perfectly... but the process model variables... shows only the auto generated id... in my colleagues account... it shows all details... I had attached the screenshot of both.

I have a process model in DEV that I have modified to use a Write Records node to store the data. The model is running perfectly and the data is being stored into the record and database. Issue is that when I use Compare & Deploy and click on the "Conflict Detected" link to check the differences between DEV and TEST its throwing this error:   If we delete the Write Records node C&D of the differences works. Any idea why its throwing an error?

Hi team, I'm getting this error in a start process node. I'm using a expression rule which will get and merge the date and time from DB and pass it to the don't start this node until this time option. This rule is working fine in other nodes such as xor or in script task. I don't know how to trace the error. If I'm using now() to that delay option it's working fine. Help please [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05]

Hi Team, I need to set a delay to the process model to trigger exactly at 00 clock. Example: If I am publishing a model at 10:36 the delay should be at 11:00 or if I'm publishing at 11:00 it should be at 11:00 itself).The requirement is simple : we keep the time recurrence at an interval of 1hr. So to maintain a proper interval gap, I planned to execute this in the delay, so that for the next time recurrence will be at 00 clock.I need help in this case.Thanks in advance 

I had created a process model to add employees, leave request, and leave approval. in leave approval, it doesn't get the employee id by itself. I had configured everything. it is showing an error in the expression rule... that the value should not be null... the value is not null at the table... I had checked with the expression rule... it gives the data by entering the id...  but here its showing error.

Is it possible that when authentication with SAML is successful, it triggers a process or a rule where any type of logic can be applied using the user's information?

While executing PM i am getting error how can i resolve ?a!localVariables( local!currGrantWorkflow: rule!GAI_getWorkflow(workflowId: ri!workflowId).data, local!refDecTree: if( rule!SCO_isBoolNotEmptyAndTrue( local!currGrantWorkflow['recordType!{f8c3f153-12d0-4850-97d9-bd6878795255}GAI Workflow.fields.{5febe064-3783-49f6-ac2c-1f69ce22e5b5}isCustomWorkflow'] ), null, rule!GAI_getRefWorkflowDecisionTree( currStatusId: local!currGrantWorkflow['recordType!{f8c3f153-12d0-4850-97d9-bd6878795255}GAI Workflow.fields.{7cd66171-e9d3-45ae-9967-fe88fbd9f594}fkWorkflowTypeStatusId'], taskDecisionId: ri!taskDecisionId ).data ), local!customDecTree: if( rule!SCO_isBoolBlankOrEmptyOrFalse( local!currGrantWorkflow['recordType!{f8c3f153-12d0-4850-97d9-bd6878795255}GAI Workflow.fields.{5febe064-3783-49f6-ac2c-1f69ce22e5b5}isCustomWorkflow'] ), null, rule!GAI_getCustomWorkflowDecisionTree( currStatusId: local!currGrantWorkflow['reco

Hi Team,I have a few doubts in start node triggers. My requirement is to trigger a process model when certain conditions are met. So, what we are doing is we created a interface for users to schedule the process when to occur. we storing the date & time in separate constants. Try 1: then in the process model start node trigger we added a time recurrence to daily and it's time to value from the time constant = pm!timezone and checking whether the date constant is today or not in timer conditions (advanced options) and delay to 0 mins. each time after the trigger the process model will update the date constant to future date. Issue: working for the first time only(while publishing) after the constant update its not working.Try 2: process model will trigger daily at 00:00 , a xor to check whether its today or not, and a script task with scheduler (delay until the datetime mentioned in the constant). Issue: if the user sets the schedule to 06:00 but trigger star

I have "requestID" as a foreign key in 2 tables "attachment" and "Document"  i passed it as process variable through a task script. When i debug the process it works but it saves the foreign key "Null".  what might be the reason? 

Hello  How to pass the Values of the local variables to the Docx????   a!localVariables( local!data:ri!DocData, local!name:rule!SKJ_GetCustomerByAcc(AccountNum:ri!Number), local!resonDes:ri!resDes, /*to collect the data*/ concat( /*Parent */ "", /*Name*/ "", local!name['recordType!{a0871cca-bd3d-4d03-b9ce-d1652bfa9dc0}SKJ Customer.fields.{b06eb39c-bf2f-4bb4-b283-cdbb894e406d}name'], "", /*Reson Des*/ "", local!resonDes, "", "", datetext(now(),"yyyy/MM/dd"), "", /*for each*/ a!forEach( items: local!data, expression: "" ), "", ), )

Hi when the process hits the Post comment to feed entry smart service it was errored out saying like below: An error occurred while trying to post a command or hazard to feed(entry id(1.840,280) Details: The supply feed entry (1,840,280) is not accessible (APNX-1-4181-100)  Kindly just on this

I am getting an Invalid Process Parameter error in my interface, and i made sure that the parameters have the same name and type in both process model and Interface. what might be the reason of this error ?  a!startProcess( processModel: cons!GeneratePDF, processParameters: { customerNum:ri!customerNum, descriptionReason:ri!reqDetails.reasonDesc, data:ri!DocDetails, }, onSuccess: {a!save( local!pdfId, fv!processInfo.pv.CreatedPDF )} ), 

HI everyone,  I'm building a process model to write a record to record type table. I have two nodes for my process for now, one is script task and one is write to record. At script task node, I use a!map function and hard code data like below. When I start process for debugging, I get the error (key can not be null). However, my key has value. I wonder do you have idea how to fix it ?