Process Modeling

Hi All, I'm getting an error when I'm trying to write multiple rows to the database at the same time. When I only give one item to the process variable it works just fine, but when is multiple it throws this error. Details: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement: org.hibernate.exception.SQLGrammarException: could not execute statement: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table . I have everything correctly set up to accept multiple already, such as the process variable and the write to database smart service. any ideas of what could it be?

I am trying to remove user (System Admin) from all the groups he is part of by using "Remove Group Members" and "Remove Group Admins" in a process and running it as MNI one for each group but still the user was not removed from any group at all.I made the PM lane as Run as whoever designed this process model and I am also a sys Admin but still the Smart service is not working.Am I missing anything here?

I have two process variable that is CDT type. I need to if any of the process variable is null then related to that process variable entity data not executed. Like this:  = {    if(    a!isnotnullorempty(pv!dependencies),             null,    a!entityData(             entity: cons!DSE_COMMUNITIES,          data: pv!communityAllocation  ) ),     if(    a!isnotnullorempty(pv!dependencies),             null,           a!entityData(               entity: cons!DSE_DEPENDENCIES,               data: pv!dependencies    )  )} But it gives error: An error occurred while trying to write to the data store [Tables]. No values have been written. Details: org.hibernate.PropertyVal

I'm using Export to csv smart service but when i export the data it returns only the timestamp for the data time column.I want the date & time .here is my table on UI: here s the column in db: here is the CDT column: and here is the csv column:

Hi, Do we have any chance of removing the above highlighted mail ID and change to custom mail ID?? Thanks in Advance, Gousii.

 Is there any way to check how each node of a process model is performing? Like how long a node is taking to complete. I know we have two(Default Process Model Optimization Metrics,Default Process Optimization Metrics) out of the box reports present in appian objects but can we use them if the process model does not have any attended nodes? or is there any way around to get this info?

The properties in the process model is not opening. Please suggest some solution for it. I have the rights to modify the process model as well.

I need to implement duplicate functionality. for that, I have a grid view and corresponding to each row i have a button for duplicate.  On button click, I am using a!startProcess() to call process model in which passing a parameter in which we pass the id of that row. In Process model, we are passing that id to the stored procedure in which we have written the insert query for the same data as that id has. And as a output we are receiving the new id.  With this new id, we have to open a interface for which I have used User Input Task. But the process runs and stuck on the User input Task i.e. the interface is not called through UI. How to solve this?? Please suggest anyone....

I submitted an user input task but when supervisor rejects. It should come back to the user input task where an user can again submit the form by editing details. I did this but I'm unable to resubmit the form. Can anyone please help?

If an user task completed in the process but I again want to go for it to complete. How will I do that?

Hi All, I have a list of strings saved as one of my process variables, I'm just trying to display this list in a table for an email . Each item creating a new row in the table. Any Idea how can achieve this? 

Hi all, I am generating XML document....based on that...i have to display the  xml text  in docx template.is there any way i can achieve this?

In sync record smart service ,How can we sync more than 1000 identifiers list of primary key values?

Hi ,  I have a requirement to generate PDF File and pass some value from outside , when i am using .PDF File as template i am not getting ###value### replace with option how can i resolve this ?

User will complete one task namely task A today and the next task named task B should be created only at 5AM EST the next day. Until 5AM EST, the process has to be in waiting stage. Task A can be completed at any time the previous day. How to achieve this?Thanks in advance

Hi All,When I run the process, I am getting the error in "Send Email" node. Error Details - "index (Data Inputs)".Assignment of the node, it is set as run whoever started the process.Please suggest if anyone had an idea about this.Thankyou in advance!

Hi, Question for the community. I have a process id and which is the efficient way to find the process status. I don't need any other info from the status only whether it is completed or now.

Hi All, We are facing an issue with execute store procedure.  The stored procedure involves an OPENQUERY statement that connects to another server's database table and inserts data into it. Previously, we were using the deprecated Execute Stored Procedure method without any issues. As part of our version upgrade, we have updated with Execute Stored Procedure (Native) method, which is not functioning as expected. Please find the sample query in the stored procedure - INSERT OPENQUERY (<linkedServerName>, 'Select <columns from linked server DB Table>') SELECT <columns from current DB Table>; Error Message:  The operation could not be performed due to the OLE DB provider "MSOLEDBSQL" for linked server "dxbkdb01_edms" being unable to begin a distributed transaction. Thanks for your guidance in advance!!

I have a Process Model in which last node is as same as start node's interface , this last node is just showing some grid on the same interface after getting few details, But the problem is this , the last node is working if I monitor it but it won't show it's result on site instead it refreshes the page and start a new form to get submit.

I have read the documentation and I think I have followed what is suggested but I still cannot start the process- from the interface. this is the section of the interface where I am calling the process model: a!sideBySideItem( item: a!imageField( images: a!userImage( user: local!currentuser, link: a!dynamicLink( value: local!imageuser, saveInto: a!startProcess( processModel: cons!GLP_UPDATEPROFILEPICTURE, processParameters: { userToUpdate: local!currentuser }, onSuccess: a!save( target: local!imageuser, value: fv!processInfo ) ) ) ), isThumbnail: true(), style: "AVATAR" ), width: "MINIMIZE" ),

I have created a process model that produces an Excel file and places it in a knowledge center. Is there a way to automatically download the excel file from the process model without using a user form with a download link? It seems like such a basic functionality that I am a bit confused as to why it is so complicated.

Hi, My requirement is that user can select already uploaded word template document(some substitution keys included in the template already) from a dropdown on a form. After selecting, I have to scan all the substitution keys from the template and show in the grid on the same screen with 2 columns - field name(substitution key) and value(that will replace substitution key). So, after submitting the form, the word document will be populated with those values. I know we can do this from process model with word from template smart service but my requirement is that substitution keys can vary in number. So, I have to get the values from the interface only.

Hi, In my Process Model I have a Write Records Smart Service. When I go to the "Data" tab, I see only Pause On Error (Boolean) under the node inputs. I don't see "Records"(any type). When I try to add it manually I see a dialog box saying "The Activity Class Parameter name is already in use". I don't know what to do...

I am generating an excel with Export DSE to EXCEL.The smartservice consults a view with the data ordered by a date field.The result obtained in the smartservice is ordered by id (PK), not by date.How can we order by the date field in this smartservice or collect the records as they are in the view without ordering them by pk?

Hi! I´m trying to make a process in which a document (pdf) is uploaded, then some values are extracted and reconciliated and, finally, those values are saved into a record. By now I managed to create a process until the reconciliation of the document: First of all, the process start form allows the user to upload the document After that, I start the doc extraction and, when it is finished, the user is allow to supervise and reconcile the values which are not correct and "train" the program. By now, this step appears as a task in tempo (I don´t know how to make it appear in the process, by now I have to click into" reconcile doc straction" and "execute the task", manually My doubt here is how to save the values, mapping them with specific columns of a created record. By now I have a data type (general) only with the fields (id factura, nomProveedor, NIF...).