Discussion Categories

Hi, I have created a record link in a read-only grid. When I click on the link in interface it takes me to the summary page of the record but when I click on the link in site it is giving me Access Denied error.  Below is code I created for record link and I have administrator level access. a!linkField( links: a!recordLink( label: fv!row.country_txt, recordType: 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country', identifier: ri!labelChangeCountryId, dashboard: "summary", openLinkIn: "NEW_TAB" )

Hi teamWe have moved an existing application to a new schema, and we are also getting rid of the old CDTs in order to use Record Types instead.I need to know how to apply the 'type' function where the new schema name is SierraUniformMike and the recordtype name will be SUM Onboarding Case 'type!{urn:com:appian:types:PRE}PRE_OnboardingCase'( id: null, case: rule!DCM_newCase( reference: joinarray( { "PRE", text( rule!APP_default(value: now(), default: today()), "yymmdd" ), rule!APP_generateUUIDSegment(6) }, "/" ), parentID: null, priority: null, milestone: rule!PRE_getCaseMilestoneByUUID( milestoneUUID: cons!PRE_UUID_ONBOARDING_CASE_MILESTONE_OPEN ), assignment: null, type: rule!DCM_getCaseTypeByUUID( uuid: cons!PRE_UUID_CASE_TYPE_ONBOARDING_CASE ), createdOn: now(), createdBy: loggedInUser() ), createdOn: now(), createdBy: loggedInUser() )OK, I

I am using PostgreSQL database for my application. This database is hosted on the AWS cloud server. I want to move it to the Appian Cloud server. How can I achieve this?

I am getting this error on Export to Excel function when I am exporting the data in excel via SQL query-  The following error was raised by the Export to Excel function: Attempting to write a row[4] in the range [0,157943] that is already written to disk. We have this functionality where there is a Create and Modify workflow and we want to create a excel template in both scenarios using SQL query. The strange thing is  - We are using same excel base template on both Create and Modify workflow but this error only occurs when executing Modify workflow. We have formula on A column which is populated on 4th row and excel headers till 3 rows so the starting cell is B5.  Can anyone please help me out to understand the root cause here?

I have a robotic task that gets triggered from the smart service node in Process model. I am providing some details with respect to the bot so that I can get help exactly where we can improve the performance.Robotic task -> The robotic task receives an excel document, downloads it (download doc step), then it has to open the doc, and perform some excel actions(Sort,Find value,Filter etc) that we have configured using excel actions. The catch is that the bot first needs to check which action is it that it needs to perform (so we use if expression true to confirm the action, since this comes from the process model + DB).Now we have robotic sub tasks as well since there are close to 40 actions, therefore we have divided them.Configuration --> Download > Open workbook > Select sheet > Loop in actions > Pick first action > Run if expressions (present in sub bots) to confirm which action it is > Apply action > Will check other action until comes out of loop after e

Can I export an application, change its name and import it as a new application, so that there are 2 copies of the application in the same environment?

When I duplicate certain objects from Application A to Application B (that is, I moved them from A to B, by selecting the "Move to App" option), it doesn't create a separate object but just pastes a reference of original object, as when I try to make changes to my original object my duplicate object also gets changed. Can I get a solution to this problem, such that the duplicate object will not get affected by the changes made to the original object?

Hi All, We are working with on-premise version of Appian (23.3) which is hosted on a private cloud. When I run load test on my environment process models are taking more time to complete (ex: 35 mints to complete).we increased process and execution engines also but still having latency. each node is taking around 2- 3 minutes to execute , even a simple is null logic also taking same time.  We have done the health check but could not see any major issues. Any suggestions to debug this issue would be greatly appreciated. Note : Load test time we are not running any background Process Thanks in advance.

we are using ldap authentication to get user, ldap password was reset now we are not able to login in appian and we do not have any admin user, any solution to create admin user from server or db level

Hi Everyone, Is there any option to import excel data into Difference Database tables, Pls let me know if any. Thanks, Nagesh.

Hi, we are attempting to use the Appian PowerBi plugin.  We are able to successfully connect.  However, when we attempt to use operations like "Get all Groups" we are getting error code 401 unauthorized.  I would appreciate any help. Here's a screenshot of the error:

I am trying to cast record fields, and I am having that one field that is referenced in another record and when using the casting rule i am including this field. now when i write into the record using write record node: The input "Records" cannot insert or update a record which is referring to different referenced records via mbappid at the same time. To create a reference to a related record, include either a relationship reference or the required common field value for "mbappid". Location of conflicting changes: record(id: 123570) my approach was: a!forEach( items: pv!familyMembersDetails, expression: rule!CR_recordType( record: fv!item, status: "DEACTIVATE", mbAppId: fv!item['recordType!{record}record.relationships.{record}relrecord.fields.{}mbAppId'] ) ) but it still returns the error 

Hi, I am facing some issue with site object. Steps: I have logged in to the site with some appian user. The default tab is not selected here. It should not be the case right? Kindly help me with this. I have selected navigation bar as "sidebar". This issue is not for "headerbar"

Hi, I have 180 process models in system, based on the business need we want to change the process model data management value to come from constant. Currently we are changing all PMs manually and deploying them again again and its a pain. Is there a way to do this OOB.

HI Team, while I am Training about 75 PDFS while Labeling the fields, All of the Sudden  the page will reload and shows Access Denied or it will ask me to login again. i have faced this Many times and my teams also faced this Issue. we are not able to understand the root cause of the issue. Did any know the reason or faced this earlier? Thank you in advance

Is anyone aware of any frameworks or apps available for user-managed reference data? This is, a component for users to add/edit/remove lookup data, add/remove relationships, etc. 

I am using the AWS Assume Role plugin with the Amazon S3 plugin. Entering the credentials (e.g., Access Key, Access Key Secret, Role ARN, Role, etc.) directly in the Appian designer console when creating the connected system is non-ideal. An ideal solution would be to natively integrate with AWS Secrets Manager, which would allow for automated secrets rotation. In the interim I would like to use Appian's SCS. How can I inject the secrets in the Assume Role Plug-in using the SCS? From what I've read the Third Party Credentials can only be used by Java plugins. Do I need to create a new plugin? Do you have an example that goes through this kind of use case step-by-step? This is the only documentation I've found -- how would the custom plugin then inject the secrets into the AWS Assume Role plugin?

we have couple of user tasks , we need a history of it to track when the task is assigned to users and accepted by users and reassigned to different persons , how do we track this records ,  Do we have any table that stores this information ? will appian have relations created to individual records to Task table so we can create events ? Please let me know ? 

Hi all, I am loading thousands of rows in a sync-enabled record through Import Excel into database plugin. How to deal with errors from process execution when trying to import date/time Excel columns with no current date (or Null). Is it any alternative rather than inserting a default date/time value?  Thank you for any suggestion, 

Hi, Which jar I need to import to get classes of  com.appiancorp.services package? Below are the jars I have in my system. But these jars doesn't have classed  from   com.appiancorp.services compileOnly 'com.appian:connected-systems-core:1.2.0' implementation 'com.appian:connected-systems-client:1.1.0'

As part of my requirement, I need to get application name by passing deployment uuid. I am trying a!deployment(uuid,"application") which is returning application id and name which is of type application. I am not able to cast the application type object to string to fetch the application name. 

Hi Team ,   I am developing a connected system component which require to handle Appian documents. How can I get ContentService  instance  to my integrationTemplate class which is extended  from SimpleIntegrationTemplate . Thanks

What is the purpose of Deny option in security level

Hello I am trying to change the format of the displayed date in the date field. Currently it is mm/dd/yyyy. I found a solution in admin console -> internationalization. It changes the format if I pick locale to en_UK, however then process model names and descriptions become three question marks "???". How to fix this or maybe there is another way to do this date formatting? I am on Appian 23.3

Please provide possible fix regarding below issues. 1.) 1 error occurred in Report: NGP_RPT_PliDecisionSummaryGrid 100% of errors due to: Expression evaluation error : Rule 'ngp_tab_plidecisionsummarygrid' has 2 parameters, but instead passed 0 parameters. 2.) 7 calls, 12037 ms peak average, 0.7% of total, 0.1% prepare, 96.4% execute, 3.5% transform, depth: 0, breadth: 12 3.) 5680 ms peak average - NGP_PAR_Send_Notifications (0002e36e-a0f5-8000-a2f0-010000010000) -> GOA Request Cancelled