Data Fabric

Hi All, We're executing load tests on our testing environment. We notice that during the high peak, simple operations like write or query records take longer to execute (2-4 sec). The CPU memory utilization of the instance is very high too. The records are light weighted and not heavy to take this long. Any ideas as to what might be the cause of this slowness and how to debug this? Regards, Sakshee

Hello, I have a record action which shows "Add comment" and after completing/adding the comment details the record action should get updated to database or record. But it is not refreshing dashboard or interface. Only after page refresh page only it's refreshing but not immediately after the action submission.  a!columnLayout( contents: { a!recordActionField( actions: a!recordActionItem( action: 'recordType!{6d2a7f52-9952-4737-bb95-d3f3a29c06ac}PIMS Project Details.actions.{4e341a40-54be-42c6-ac1e-7e52004c1fca}comment', identifier: ri!projectDetails['recordType!{6d2a7f52-9952-4737-bb95-d3f3a29c06ac}PIMS Project Details.fields.{dedeac6d-7da7-4635-82db-b4816e2daa36}projectId'] ), style: "SIDEBAR_PRIMARY", display: "LABEL" ), }, Thanks, Chiranjeevi

Hi all, I am working on an existing project that uses records, where I am used to CDTs. This project utilizes one central record type of "metrics" and each metric has metadata (fields), some of which is tied to other record types with one-to-many and many-to-one relationships. I can't include pictures, so writing out the general set up in dummy code: Record Type: Metric Fields: id / integer metricName / text ... riskType / integer  User Filters: metricName / a!recordFilterList(...filter: a!queryFilter(field: Metric.metricName, operator: "="...)) riskType / Risk Type.value  Record Type: Risk Type Fields: id / integer value / text The relationship: Metric.riskType = Risk Type.id  The "Risk Type" field is a many to one record type relationship with the Metric record type, and is selected via the front end in a single dropdown. I would like to change this to a multidropdown, but was unable to change the field to take multiple integers. I created a

Read Only grid is working in Dev and test environment but in preprod it is giving error that {something like UUID } field does not exists. I have tried to comment all grid columns and uncommented one by one. Two Grid columns are giving error. But I am not able to find out why. As same Record Fields are used multiple places in interface and its working as expected there. Only in Grid Column its giving error.

I have a scenario where I need to  create a pie chart based on a record type for example cmgt_task.I want to show two datas in a pie chart (20%-80%),one having due date as today and completed on as today date and other one will be all open work items that is having due date as today.How can I proceed with this,like do i need to do two seperate queries or it is possible to implement using one query using aggregation.Kindly help me with this scenario ,If I can do it through aggregation then how can I will give different filters for thsese two  datas1.all the completed work items having "due date" as today and "completed on" date as today.And also "is completed "as true and "status" as completeda!queryFilter( field: 'recordType!{ee5aa46d-0228-430f-a794-1134a11fbcc0}CMGT_Task.fields.{3d96454c-776f-4b29-9413-d7fffa3ebaeb}statusId', operator: "=", value: cons!CMGT_REFID_STATUS_TASK_COMPLETED ),

We have deployed a table to higher environment  and used in required objects to perform operations, we want t o add 2 columns to it . How can we achieve this , also will there be any impact on the objects as its already in higher environments .

We are getting the following error every minute in the stdout.log. java.util.concurrent.ExecutionException: com.appian.data.client.AdsUserInputException: APNX-3-1100-022: Query target must be a valid table reference. Invalid: "df_records"."10414987-1995-45eb-9baf-eebaf764386a_live" at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:205) at com.appiancorp.record.query.ads.ComplexSyncedRecordQueryRunner.runQuery(ComplexSyncedRecordQueryRunner.java:156) at com.appiancorp.record.query.semanticsearch.LowLevelSearchDecorator.runQuery(LowLevelSearchDecorator.java:46) at com.appiancorp.record.data.sourcedataaccessors.RecordReplicaDataAccessor.lambda$getRecordsInner$2(RecordReplicaDataAccessor.java:132) at com.appiancorp.record.data.sourcedataaccessors.RecordReplicaDataAccessor.getRecordsOptimistically(RecordReplicaDataAccessor.java:176) Sync has not been scheduled for the record. (UUID:

I have a scenario where I need to  create a pie chart based on a record type for example cmgt_task.I want to show two datas in a pie chart (20%-80%),one having due date as today and completed on as today date and other one will be all open work items that is having due date as today.How can I proceed with this,like do i need to do two seperate queries or it is possible to implement using one query using aggregation.Kindly help me with this scenario ,If I can do it through aggregation then how can I will give different filters for thsese two  datas1.all the completed work items having "due date" as today and "completed on" date as today.And also "is completed "as true and "status" as completeda!queryFilter( field: 'recordType!{ee5aa46d-0228-430f-a794-1134a11fbcc0}CMGT_Task.fields.{3d96454c-776f-4b29-9413-d7fffa3ebaeb}statusId', operator: "=", value: cons!CMGT_REFID_STATUS_TASK_COMPLETED ),

We are updating an old application from CDT/DSE to Record Types.  In a certain process a parent record is written, then child records are generated with foreign key values for the parent and they are written.  This is all done with the existing CDTs and DSEs.  The data propagates to the new Record Types as desired. However, we have a business critical sync filter on the Child record type that is intended to prevent certain statuses on the parent record from allowing anyone to find related children.  This filter is not being applied by the data propagation feature.   Believing that perhaps it was a syncing issue, I tried using the Sync Records smart service in various combinations with both the Parent and Child records.  Syncing the Child records, then the Parent, then I tried the Parent first and then the Child.  Nothing worked. It is my belief, that the Sync Records smart service is not sourcing the Related record when applying the sync filter.

. Getting error while executing . Pls advice where i am making mistake configuring

Hi, I'm trying to create a user filter in a record that filters a combination of 2 fields. I've tried to use a!queryLogicalExpression() inside a!recordFilterListOption() for the filter and didn't work. Is there any other way to do this? My other option is to create an interface with this filter but i think it would be better to have it as a user filter in the record. Thanks, Ignacio

Hi All, I have a web service record type with some related actions, currently I'm facing an issue when I click on the record action on an interface, the record action consists of a very long form , but what I believe is triggering the error are the paragraph fields, some have a character limit of 500, and 3000, but when the record has empty values the form shows as normal or when the sum combined of the characters of the fields is less than 1700 it also opens as normal, as soon as one of the fields is more than 1700 characters or one is 1300 and the other field is 500 the interface is showing  an error with no details. I checked the main data type of the form the length for each field is correct.  "An Error has occurred" is all it says. If anyone has seen this before I would appreciate the help thanks!

how to skip sync record node in process module if no change in the data to previous data  here there is no change in data so it is showing error

Has anyone run into this error before? We have a rule that calls a stored procedure given an input, then returns results. One day a user ran into an issue where the SP was returning null, but the next day the SP was returning results. We've done no code changes, so I took a look into the logs and found this error: Where it says Error Msg = ORA-01013: user requested cancel of current operation. However, I know the user ran into this on the UI only and didn't cancel anything on the backend. It also seems like it was not a timeout issue since upon checking rdbms logs, the execution times were very low. Does anyone have any suggestions on what this might be or what we should look at for further investigation?

Hello! I have a task report which shows tasks from all users that have the current logged in user as their supervisor.   The problem I'm facing is that tasks with the status "Assigned" are not being shown in the report, which in turn creates a problem where if I reassign a task from someone it immediately goes to status "Assigned" and stops being shown in the report.  Here is how I pick up tasks from my subordinates. a!localVariables( local!currentUser: loggedInUser(), local!directReportUsers: a!queryRecordType( recordType: 'recordType!{SYSTEM_RECORD_TYPE_USER}User', fields: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.relationships.{SYSTEM_RECORD_TYPE_USER_RELATIONSHIP_directReportUsers}directReportUsers.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_username}username', filters: a!queryFilter( field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_username}usernam

context:I have 3 interfaces that communicate with each other, What I need to do is give users the ability to open a project and from the project detail interface have a button in related action that opens another interface that allows the user to add employees to the project.This is the path they take:"GP_ProgettoInterfaccia" > "GP_ProgettoSummary" > "GP_CreateOrUpdateGPprogettoAnagrafica"here all in order:[View:/cfs-file/__key/communityserver-discussions-components-files/16/GP_5F00_ProgettoInterfaccia.txt:233:29]>[View:/cfs-file/__key/communityserver-discussions-components-files/16/GP_5F00_ProgettoSummary.txt:223:27]>[View:/cfs-file/__key/communityserver-discussions-components-files/16/GP_5F00_CreateOrUpdateGPprogettoAnagrafica.txt:335:25]. The record types involved are: . The problem is that once I get to "GP_CreateOrUpdateGPprogettoAnagrafica," I can't populate the multipleDropdownField. In the standalone interface, I c

Historically, we’ve used Data Sources and Custom Data Types (CDTs) to manage our data integrations. As we transition to using synced records for our new application, we’ve encountered a challenge related to schema access in SQL Server. Currently, our SQL Server Data Source is configured with a username that has access to the database. However, any synced record created under this data source only has access to tables within the default schema. Our data model spans multiple schemas within the same database, and ideally, we need to connect tables across these schemas within a single synced record. One workaround is to create separate data sources for each schema, each using a different username. However, this would require maintaining multiple data sources for the same database, which adds unnecessary complexity and overhead. We’re seeking guidance on the best way to configure our SQL Server connection so that synced records can access tables across multiple schemas wit

I have a readonly grid with a record as a source. This record Lets say "Main Record" is having a relation ship with other record - "Related Record". Grid has fields from both records. When Applying filters I want to avoid getting records from "Related Record" which are not active. Lets take below sample data of "Related Record". Relationship is one to Many. ID_MainRecord Division Is Active 1 Sports 0 1 Study 1 I have applied filter as  a!queryFilter( field:Main Record.Related Record.Division Operator: = Value: "Sports" ), a!queryFilter( field:Main Record.Related Record.isActive Operator: = Value: true ) Still I am getting one record in Grid I am expecting no records at all. And the record I am getting is having "Study" in division grid field. How can I get it work.  Some how how the first filter is not working as "Sports is there in the relationship field I guess. Thanks in advance for your atten

Unable to see "create new data type (CDT) in community edition . Is it removed permanently .

IN Date Range User Filter  I have to restrict user not to select any Future date in To Date 

Do you know if there's a maximum limit on the number of record types that can be created in an application? I have a database with 700 tables, and I'm not sure if Appian can create this many record types, or if I need to create an architecture that only creates the main tables. Thanks!

Background on the issue: 1. Created a related action against a synced record. Created a record parameter inside process model. 2. Mapped the action inside Interface: a!recordActionField( actions: { a!recordActionItem( action: 'recordType!{7aeac830-25f0}Task Assignment.actions.{596dfe95-567c-36ec}acceptAndTakeAction', identifier: fv!row['recordType!{7aeac830-25f0-44}Task Assignment.fields.{2acffd98-059fd5a2}TaskId'] ) } ) 3. rv!record is passed as input to Process model { rtTaskAssignment: rv!record  /* Task Assignment */} 4. Received only few information inside process model:  {TaskId=3, Workflow={WfId=8173, Label=4501_PRA110_WEEKLY}, Owner=} Expected: {TaskId=3, WfId=8173, rptId=89, Stage=23, Status=17, RoleId=9, ActionId=, Owner=,  isActive=1, createdBy=System, createdOn=25/06/2025 10:18, updatedBy=System, updatedOn=25/06/2025 10:18, GrpId=14575} We are observing this with other related actions as well. All the fields are correctly mapped inside record. How to

When trying to export a report to an Excel file, I get this error in UI and Logs: 2025-06-20 17:41:28,077 [ajp-nio-0.0.0.0-8009-exec-698] ERROR com.appiancorp.rest.shared.AppianExceptionMapper - Internal Server Error on REST API invocation. com.appiancorp.exceptions.LocalizedAppianRuntimeException$LocalizedAppianException: Expression evaluation error [evaluation ID = 1Y9KI] in rule 'taskfilters' (called by rules 'tasks' > 'dashboard') : An error occurred while executing a save: java.lang.InternalError: java.lang.reflect.InvocationTargetException (APNX-1-4198-019) I've searched in the community for similar behavior and tried some suggestions, but the problem persists and no one has resolved it.

So i created a constant for all the company names which is normally a best practise in the appian application.  and then i called this constant in a filter But then when i was using the filter it wasnt working and all the values were showing in the same line idk why this is happening can anyone guide me how to rectify this error.

I am currently streaming logs onto a syslog server and would like to come up with a series of programmed alerts to identify potential security risks. But it's not always clear how to use the log fields to come up with these alerts. Has anyone done this exercise before and can provide some more info on which fields can be used in which ways to identify potential security risks? *For example*, the authz-audit.csv log records information about the authorization of already authenticated users within the system. I could check the Decision field to see if someone was DENIED access to a certain uri (Action Target and Action Name fields), but (a) it's hard to understand some of the info within the fields and (b) it's unclear how to distinguish a legitimate denial from a potential security threat. Any ideas would be much appreciated. FWIW, I'm currently grabbing the Streaming logs and have already looked through the Logging Documenation.