Discussion Categories

Process model is newly added with Write Records of a new record type recently created and when comparing with previous version which doesnt have this record type in dev it is throwing attached error. Anyone faced this issue?

For Appian version 24.2.1295.0 and Excel Tools version 2.6.3, I am getting following error.  ERROR ImportExcelFileToDatabase ORA-17041: Missing IN or OUT parameter at index: 2 Is this due to a version miss match ? Which version will be suitable with my current version of Appian and will upgrading the plugin cause any issues with the older code?

Hi everyone. I have added fields to an SQL Server table. I have refreshed the associated RecordType to add these new fields. Now when I create a new record I face this error (in the "Nombre" field for example): I suposse the recordType have not been refreshed properly but I don't know how to do it because I have sincronized many times. When I experience this problem I usually remove the recordtype and create it again but this workaround is not nice. Do you know how to do it properly without rermove it? Thanks in advance.

Hey!I'm going through the Appian docs for activity chaining https://docs.appian.com/suite/help/25.3/Sub-Process_Activity.html#activity-chaining-into-a-subprocess-activityI see that there is a checkbox to Enable activity-chaining into all initial nodes in the subprocess and Appian recommends(for the sake of design consistency) enabling activity chaining in the subprocess despite selecting this checkbox.  My question is with respect to the following statements as highlighted in image below1. I agree with the first statement and I have tried it out myself 2. The second statement says keep Enable activity-chaining into all initial nodes in the subprocess checkbox cleared if I have a start form in subprocess. Now, my question is - does it matter if I have checked/unchecked this checkbox as I already know the start form will be skipped. Like what am I achieving by clearing the checkbox if I know it's going to skip the start

I am getting some strange values from todate(). { todate("02/28/2025"), todate("02/29/2025"), todate("02/30/2025"), todate("02/31/2025"), todate("02/32/2025"), todate("06/31/2025"), todate("RR/28/B025") } It seems to try to auto-correct an invalid date to a valid date.  But it also seems to allow characters in the date which it evaluates somehow and comes up with wild dates as a result. First Question:  What's going on with todate() that it results in off-the-wall values? My scenarion is this.... I have a webApi that receives a json string which contains structured data that includes multiple date fields.  The webApi uses cast/fromjson to convert the json input string directly to a CDT that uses Date fields.  The CDT is passed to our expression rules that operate on the data. For example... CDT  (SH_Test) Expression rule (faking the WebApi) a!localVariables( local!inputString: "{ ""name"": ""Bob Smith"", ""birthDate"": ""GG/28/2025"",

Hi Team, we have notice below observations, please check and let me know if I missed anything, When we used  Sub-Process as asynchronous and running more than 1000 instances but those instances are not deleting even though  we have selected Allow more than 1000 instance check box....is there any limitations ?  when we used start process smart service  as asynchronous / synchronous way using MNI with 1000 instances then we have notice that even though we have selected Delete previously completed/cancelled instances. check BOX but those completed instances are not deleted in the monitoring dashboard....is there any limitations  ?. and in start process smart service we are unable to run the MNI more than 1000  instances ..if have run more than 1000 instance same like sub process asynchronously. How to achieve this scenario with using batch job ? thanks!

Hi All, i have editable grid in my ui, on that i have textfield which i marked as required. (note: when page loads grid is disabled based on the button action grid will get enabled). but i have couple of validation for that textfield  that is working but with respective to required condition it is not working. please find below the screenshot and code snippet. Kindly help me on the same. a!textField( label: "Dental Members", labelPosition: "ABOVE", value: fv!item.dentalEnr, saveInto: { fv!item.dentalEnr, if( contains( touniformstring(index(local!editList, "intakeId", null)), tostring(fv!item.intakeId) ), { a!save(

i have a sentence that "Benefit Period: To Age 75; Indexation: CPI Linked" in this I need to validate that whether "Indexation: CPI Linked" is found or not  please give me a suggestion

Thank you for your earlier advice on saving logs at application startup. As we approach the production phase of the system, I am attempting to deploy from the development environment to the testing environment, but I am encountering an import error with the aforementioned logging output application. It indicates that there is a problem with the baseURL in the connected system, but I do not see anything particularly wrong. Is there anything specific I should check? What I'm concerned about is that this application connects to a Web API within my server, and it's authenticated with a security account. The security account for the testing environment has not yet been created; could this be a factor? <ERROR>An error occurred while creating connectedSystem [uuid=_a-0000eeac-676e-8000-XXXX-XXXcXXXXXcXX_XXXXX]: The connected system [id= uuid=_a-0000eeac-676e-8000-XXXX-XXXcXXXXXcXX_XXXXX] was not created because a value for baseUrl must be provided in an import customization file

Which function do we use to remove a particular field from a record before persisting it? For example: recordType!sampleRecord1( id: null, column1: A, column2: B, column3: C, column4: D, column5: E, column6: F, column7: G, column8: H, relationA: recordType!relationA( id: null, column1: A1, column2: B2, column3: C3 )) I want to remove the id field from both sampleRecord1 and relationA before persisting them. Reason: The downstream database does not handle id: null well, but if the field is missing or field have a value, it works fine. The output I want to save should be: recordType!sampleRecord1( column1: A, column2: B, column3: C, column4: D, column5: E, column6: F, column7: G, column8: H, relationA: recordType!relationA( column1: A1, column2: B2, column3: C3 )) Which function do we use to achieve this? i want to handle it dynamically rather mapping individual fields and then persisting .

hi , I have requirement, like after downloading the excel sheet though the smart service , is there any possibility to set automatically  label as K3 Confidential, so that user don't want to set manually after downloading the excel.

Requirement: User wants to search across the PDF documents. Currently we store PDF documents generated via HTML in Appian. User wants to have a search box and search through all these PDF documents and return all the documents having matching text. Just wanted to know if there are any OOB features that supports this requirement.  Any suggestions would be appreciated. Thanks in advance.

I am using iCal Plugin 6.0.0 in OnPremise Appian environment, to send an invite to Outlook. The node gets completed successfully in the PM and even a meeting uId is generated. However, meeting invite is not received in recipients' inbox(this recipient is able to receive normal emails from the same environment). On further investigating the tomcat logs, it looks like an issue with smtp/server errors, which is not able to send the invite. Please share thoughts/suggestions. Thanks in advance. Nitika

Hello- Need some advice on the best possible approach to make a servlet POST call from a servlet browser. Our Objective : From Appian user servlet browser, upload large files using graph API to sharepoint using chunking. This solution works perfectly fine on standalone eclipse but getting hiccups on Appian cloud. We cannot do this using traditional route as sharepoint API has a limitation of 250MB, our files are 1gb & beyond. couple of approaches i tried : Moved all the logic directly into the browser, including the session creation...but Azure rejected this approach not allowing to create session from the browser... 2nd approach Appian UI to HTML interface making a Servlet POST call to initiate a upload graph api session & return the token back to HTML & from here making all the grinding to sharepoint, here we are getting CSRF token rejection  Just want to know if there is a best working approach we could use. Any help here is really appreciated. Regar

I have scenario where, I need a link in email body, this link should open a current task for which we have different process model and interface, but I want to open that task in current step once I click on the link from email. How can I achieve that?

When I am trying to create pdf using this smart service if content contains other languages characters for example Hebrew language characters then it replaces with #, is it limitation of this smart service or we can fix it. 

Hi Team, which tool is better to use for testing with appian application for automation testing? thanks!

We are encountering an issue during the integration of our application with an external Angular application via an IFrame. When a record action is invoked as a dialog box from the third-party Angular application through the IFrame, the dialog box renders as a blank page. Conversely, the same record action functions correctly and displays expected content when accessed directly from within Appian. Upon inspection, we observed that the <appian-dialog-body> HTML tag is empty when the action is initiated through the IFrame, which is not the case when accessed natively within Appian. Attached below are images to understand this better Appian IFrame For context we have already updated the following details in server config files to no avail:- on server set Clear-Site-Data: "cache", "cookies", "storage", "executionContexts"  Clear-Site-Data Header Issue The Clear-Site-Data header is being sent with an unrecognized type

Hi, I'm not very knowledgeable about encryption algorithms, but I'm trying to figure out if I can send a text encrypted in AES (with the Encryption Functions plugin) so that it can be decrypted by a service external to Appian, using RSA.My guess is to use the RSA public key and store it in the Secure Credential Store of the plugin. This way, I encrypt in AES but with the RSA public key. Now, can the external service decrypt with its private key? thks

I need to implement a functionality where: SERICE TABLE STRUCTURE planId | scenarioId | iteration | serviceId (PK)| price For some service, there are fee details stored in a separate Fee table, which is structured like this: planId | scenarioId | serviceId (FK)| rowId | sequence | feeAmount The serviceId acts as a foreign key linking the fee details to the service.  service can have multiple fee detail rows (typically 4), and users can also add new fee rows. If a user makes changes to the fee details of a service for one plan/scenario combination, those changes should be applied to the same service in other plan/scenario combinations. We already have a similar functionality for services where changes to the price field can be applied across all combos  . Now, we need to do similar thing for fee details.  Fee details available for particular service . It can have multiple rows of fee details. users can add new rows of fee details. When a new fee row is added for on

I have a record action configured with User input task form , In that interface there is save draft button on the left corner I want to remove it . How can I do that?

Attended RPA Bot on VDI: Installation/Config for User-Present Scenario with Browser + Prox Card 2FA I need clarity on the specific installation and configuration requirements for the RDP Agent when running an attended bot on a VDI where: The user must be physically logged into the VDI session The bot interacts with a browser to access an external site The user manually enters personal credentials (not stored in Appian) + uses a prox card for 2FA The user clicks a button in Appian to trigger the bot (Note: Other use cases run different scripts on the same bot in unattended mode) Question: How does the attended, user-present requirement change the RDP Agent installation, VDI setup, and bot configuration compared to a standard unattended setup? Specifically: RDP Agent install location (user profile vs. machine-wide)? VDI session requirements (persistent? console vs. RDP? interactive session needed?) Browser automation (does the browser need to run in the user’s session? Any rest

Hi when I generate a word document with an image example: {logo: CONS!APP_IMAGE} works perfectly, but when I have more than one image in the template. For example logo2 and I call the smart service as follows {logo: CONS!APP_IMAGE, logo2: CON!APP_IMAGE2} I get the following error: freemarker.core.NonSequenceOrCollectionException: The value you try to list is an extended_hash+string (fr.opensagres.xdocreport.document.images.ByteArrayImageProvider wrapped into f.e.b.StringModel), thus you must specify two loop variables after the "as"; one for the key, and another for the value, like <#... as k, v>). ---- FTL stack trace ("~" means nesting-related): - Failed at: #list logo as logo [in template "fr.opensagres.xdocreport.document.docx.DocxReport@7f2dbfc!word/document.xml" at line 4, column 6773] ---- Plugin: Advanced Document Templating      Version: 1.1.0      Smart Service: DOCX From Dynamic Template

Hi All,  We are facing  issue where record type is involved in all our processWe have requested out Oracle DBA Team to sync production data to lower environments after that we in Appian have synced the record types (using Sync Option- Start Full Sync) as our application is record type driven. We created requests in UI for just testing the flows and all the Process models started failing at the record types with error:  Unable to write to or delete from the source due to a data integrity violation.Error Details: ORA-00001: unique constraint (BPMDEV.SYS_C00153674) violated. So, have just tried hoping this would solve the issue By  going to data model in record type -In Source Selected the option Change source and selected the option database and selected the same table again, now if I'm trying to restart the failed node it is throwing an error like Unable to write to or delete from the source due to a data integrity violation.Error Details: ORA-01400: cannot

I have two objects they all the same type. I want to compare the two objects and extract which properties are different. Besides using a loop to iterate, is there a better way?