-
Recently active
Hi, If a relation does not meet the conditions for getting data, should the output return empty? Example.. The database query returns empty The queryRecordType returns a value This is correct?How can I get an empty value, like in a database? This is a modification of lesson 4 exercise 2, in the associate course certificate. (If I don´t write the "fields: AA Vehicle.maintenance.cost", the output is the same, removing maintenance list) Thanks for the help
After i generate health check report they mention slow smart services (Text doc from template) Description :30435 calls, 10300 ms peak average, 100% chained In this smart service we call one expression to pass data to that template that expression are used decode base64string that decode string length maximum 13000 characters because of this we get this issues?
Please let me know way to delete appian site created namespace. Is thr any way to terminating state as : root@ip-172-31-33-110:~# kubectl get namespaceNAME STATUS AGEappian-operator Active 14dappiandemo Terminating 9dcalico-apiserver Active 14dcalico-system &
Hi All,In our DEV and UAT environment, we are getting below mentioned error repeatedly, which was observed in tomcat-stdOut.log : ERROR com.appiancorp.ps.function.ExecuteStoredProcedureFunction - Error executing: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from UNKNOWN to UNKNOWN is unsupported.Also attaching the detailed logs for reference, please let us know what would be the issue? [View:/cfs-file/__key/communityserver-discussions-components-files/11/UNKNOWN-to-UNKNOWN-is-unsupported.txt:320:240]Regards,Sandeep
Hi , I have a grid which fetches values through API call on clicking a button. I'm able to fetch the values when I click on that button in interface but not in Site. This interface is being called as an action in Process model and I have configured all the rule inputs in the Process model. Here in interface when I click on the Search Multi Agreement Activities I'm able to get values in below grid. . And in Site when I click on the button, its just showing the empty grid Can someone help me what could be the issue or what I missed here.
Hi All, I have a requirement in my project. Stored Procedure TEST2 must have error handling for below exception. i have to handle error handling methods to catch the error and return an error status with message to xyz nightly refresh process model. xyz nightly refresh must be able to retry calling the stored procedure if the duplicate key exception was caught. so below is the code which i was trying but it's not working, as i have used insert within try and inserting error details in a separate record_errors table within catch. But while i am debugging SP through properties but it's not inserting error details in record_errors table so can anyone help me with any other approach or i am missing anything in it.
There is a web api that runs a process model when data is passed in. Upon executing the process model, I receive a failure in the process model due to memory (attached below) which stops the process model. However the web api returns the success payload (error 200) rather than the error payload (error 500). Why doesn't the API return the on failure payload, and how do I configure it to return the failure payload if this memory issue arises again?
Required field validation is working fine in the interface and portal. But in Site the same interface is not showing "A value is required"..
a!textField( label: "Title:", labelPosition: "JUSTIFIED", value: local!data.requestTitle, saveInto: {a!save(local!data.requestTitle, save!value) }, validations:( if(a!isNullOrEmpty(local!data.requestTitle), "Title is Required ", {}, )), refreshAfter: "KEYPRESS", characterLimit: 100, required: true, ), buttons: a!buttonLayout( primaryButtons: { a!buttonWidget_23r3( label: "Submit", style: "PRIMARY", submit: true, saveInto:
Hi All , I used readexcelimportfile() function for reading the Excel , In excel in one field we provided $ symbol and its failed with error= ERROR:Work item cancelled (Data Outputs).Is there any limitation with filed please provide you input. a!localVariables( local!read: readexcelimportfile( excelDocument:pv!file, sheetNumber:0, startRow:1 ).result, a!forEach( items: index(local!read,"values",null), expression:'type!{urn:com:appian:types:PST}PST_ListBill_ExcelData'( CaseId:pv!caseId, NAME:index(fv!item,1,null()), REFERENCE:index(fv!item,2,null()), CONTRACT:index(fv!item,3,null()), DATE:index(fv!item,4,null()), ) ))
The error shown in screenshot #1 is a default, built-in Appian error. That's fine. The question I have is with regards to its behavior. When I upload an empty .txt file I get this error. However I feel like it should go away when I upload another file. In screenshot #2, I uploaded an incorrect file (per my use case, user can only upload .txt or .csv files). The top error in the second screenshot is the validation error I wrote. This is not desired behavior to have both those errors there. Even if I had uploaded a correct file, the default empty file error would still display until I click a button where submit = true. And on another note, if a user tries to upload an empty .txt file again, the error message duplicates itself, as shown in screenshot #3, which I don't feel like is ever correct behavior. I know this is a built-in validation error in Appian, and I don't think there is a way for me to change its behavior, but figured I would ask. Thanks!
Hi Team, We have Requirement of integrating DocuSign and I came to know that Appian have Connected Servicing solution includes electronic signature capture powered by a DocuSign integration from the below Documentation https://docs.appian.com/suite/help/24.1/cs-23.3.2.6/managing-integrations.html#integrating-with-docusign but can anyone help me in understanding how should i get to the access the System Administration Center as mentioned in the Documentation?
I am trying to open Acme Automobile Reference Application (AA) in the community edition portal. But I am getting "403 - Access denied. you don't have permissions to view this page." I need this to complete the activities in Appian Community's self paced course. Any help is appreciable. Also noticed that I got the same error for all the applications in the community edition Env. except "Community Edition Home"
Hi All, In our UAT environment, we are getting below mentioned error repeatedly, which was observed in tomcat-stdOut.log : com.appiancorp.exceptions.LocalizedAppianRuntimeException: com.appiancorp.exceptions.LocalizedAppianRuntimeException$LocalizedAppianException: Contact your application administrator for help resolving this issue. Provide them with the following issue identifier Also attaching the detailed logs for reference, please let us know what would be the issue? [View:/cfs-file/__key/communityserver-discussions-components-files/12/tomcat-logs.txt:320:240] Regards,Sandeep
When i am trying to access when particular dashboardpage in interface for displaying active tasks i am getting the UI error saying like below and i could see group ids was not taking correctly and other thing is through Admin access the page was accesible but specific to group access it was throwing error Expression evaluation error [evaluation ID = 36716:124d6] in rule 'ctest_test_pendingtaskgrid' (called by rules 'cmtest_fies_testdashboard' > 'cmyd_ets_dashboard_requests') at function 'getdistinctusers' [line 114]: [InvalidGroupException] the code available at 114 line was this a!sideBySideItem( showWhen:not(rule!APN_isBlank(ri!acceptedByGroup)), item: a!dropdownField_20r2( label:"Accepted By ", labelPosition: "ADJACENT", choiceLabels:apply(rule!Cfsdsd_getFullnameByUser_LastFirst,getdistinctusers(topeople(ri!acceptedByGroup))), placeholderLabel:"--- Show All ---", choiceValues:getdistinctusers(topeople(ri!accepte
Hi team Here is my use case: Duplicate an app that exists in one schema to a different schema (for data separation) Recreate every object in the SAM app in the SAL app In creating the SAL schema, convert all instances of a!queryEntity() to a!queryRecordType() Temporarily leave the SAM app in place so I can compare SAL functionality against SAM functionality Completed so far: Created the new schema (SAL) Set up the new synchronised record types Duplicated or created every object that exists in SAM into SAL Ensured the SAL site has the same layout as the SAM site Questions I need answers for: Is there a way to do a bulk find and replace to change all references in every expression from SAM to SAL, or do I have to manually update each individual expression? I get a warning that type SAL does not exist every time I try to change 'type!{urn:com:appian:types:SAM}SAM_SoftwareOnboardingCase' Is there a standardised way to convert an a!queryEntity() expression to an a!queryRec
Is there any way to download users list in csv or xlsx format from Administration Console or Designer?
Hi Team, I have requirement to send PDF for print. Ask is to send a document to printer with a button click and not after downloading document. I see a print in document viewer but we want to do it online. Say user selects a document and then click on print button, Appian should be able to initiate print by calling the printer via API. Has anyone done that or better suggestion?
Hi, I am working on a task where the main function is importing excel data to the database. I need to create an interface where I upload the excel file and the file gets saved somewhere in the directory, I did this by simply adding a file upload section which contains this code:a!sectionLayout( label: "Upload Employee File", contents: { a!fileUploadField( label: "File Upload", labelPosition: "ABOVE", value: ri!document, saveInto: ri!document, target: cons!HR_EmployeeDataPointer, maxSelections: 1 ) } )Now, I need to create a process model where first I get the data from this uploaded file, query and match the data in the database and check if the employee exists and if it doesn't I need to update the database or leave it as it is if it exists. After these I need to show all the data in a grid in another interface.Besides the first interface I also created the expression rule to read through the excel file even though it's s
Hi All, I am trying to use communicationChat plug-in functionality by referring the below document, the information that is displayed over there does not help with the understanding. Reference link: see attachment4377.Readme.pdf (appian.com) Can anyone who might have used it before please help me with the sample example? Your help will be appreciated. Regards, Riddhi
Hi all, I have a scenario where I have to send a multiple links in a Google chat in a single message Message format should be like this RequestNo ।। CreatedDate ।। Links 1। Date। Click here And so on How to achieve this Thanks in Advance
Instance of the Process variable(record type) is having two different values but when I configured the event history for that record where the values are storing duplicates. Kindly suggest. Providing below screenshot. Process variable values DB Values Write to Record Event Configuration
Where is option of Prep Mining In Process mining?According to Process Mining Training it says "When you log in to Mining Prep, you'll see two main tabs: Transformation Projects and Data Management."I'm unable to find any option like Mining Prep
We will going to use Appian to remediate one of application. We will need to fetch data from Appian db and load it into our in house database, In our existing set up, where Appian is not used , we are using informatica Power centre to fetch data from external vendor application via CData ODATA connector. Is there any way to do with Appian also?
Hello everyone, I'm encountering an issue with record type. I have a table in my database responsible for storing HTML template code for each user. When retrieving the data through records, I'm not receiving the full length of the HTML code; it's breaking. The column in the database has a VARCHAR data type with a limit of approximately 65,000 characters, while the length of the HTML code string is only 4000 characters. In DB we have full length code.Can anyone provide assistance or suggest a workaround for this problem?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.