Data Fabric

Hi Team, Please find attached  I am using the rule in my process and it fails sometimes, can i know is something issue due to connection or something issue in code How we can avoid this issues

Hi All, In third party database, we have a column (number datatype) which can have more than 10 digit value. How to display the value on Interface. We have tried mapping type = "xsd:integer" and "xsd:long" and "xsd:int" in XSD  xsd:int gives Numeric overflow error, on changing it to xsd:integer / xsd:long, it retrieves blank value on query entity but there is value in DB (which has 14 digits) How to retrieve the values having more than 10 digit value? Any advice. Thanks and Regards,Diksha

Hi, Yesterday my client met this issue in Production (no deployement made since two weeks), this happends with a specific user.     "UI Expression evaluation error:      Expression evaluation error [evaluation ID = BQLBSYMP ] in rule .... at function a!gridField [row: 21]:     The record data does not exist, has been deleted, or you do not have sufficient privileges to access it" Then, he had a HTTP ERROR (code 413). To correct the issue we just emptied the browser cache and it has worked back. but, today, the client met exactly the same problem again on its TEST environnement. This time, emptying the cache did not correct the issue. What I have did, is just to edit the first rule concerned (called by a Report) and edit and re-save it. After that, it has worked back again. Could you tell me if you know what it is behind this error please ?

Our application became terribly slow after adding a Grid column with Related actions. We have a record type with Type "Other Web Service" which calls backend Integration and gets 20 records, it also has 9 Related Actions. Before adding new related actions grid column, page used to load in 5seconds but now it is taking around 40seconds. When checked the performance of grid, grid column is making 20*9 = 180 integration calls which is causing the slowness. Any idea on how to reduce the integration calls?

I have a CDT named "LNE_Servicing" which has 2 foreign keys, one from CDT userList and one from CDT soldAppliance. When I try to create a recordType for Servicing and check the record it gives me the error: The Requested Record Type Is Not Available Expression evaluation error [evaluation ID = Y38GMQ7D] at function a!recordList: Cannot execute a query with a blank field name. (APNX-1-4198-000) In the performance tab of the record type it shows: Could not calculate performance. Please check record type definition. Expression evaluation error [evaluation ID = RUAXQRTA] at function a!recordList_ui_design: Cannot execute a query with a blank field name. (APNX-1-4198-000) On clicking edit list in the List tab it shows: Error Evaluating UI Expression Expression evaluation error at function a!gridField [line 27]: Cannot execute a query with a blank field name. This is my servicing table:

I currently am writing a basic ticketing system which has an interface used as a record summary view, in the interface is a submit form where users will submit comments to be saved to the database. I am wondering what is the best practice for saving that data in the database? Is there a way to initiate a process model on a record view?

Hi, I want to update existing multiple records in appian table having a primary key. How can I do this ? is there a smart service to update bulk records in sql appian table ??

Hi,I have  a view created in DB already, the CDT, constant and Datastore were published. I tried to create a column chart using that view in a interface using Report Builder. I cannot see the table created from view in the dropdown of tables.Can someone help!!

Hello everyone, I am building an interface dynamically for a questionnaire based on previous responses (so I can view the previous answers and then edit them if necessary when re-reviewing). The questions are stored in one database, the items being assessed in another, and the responses to my questions in a third. So, the issue is when I add a new question and answer, I receive the following error: Interface Definition: Expression evaluation error at function a!forEach [line 140]: Error in a!forEach() expression during iteration 25: Expression evaluation error at function a!radioButtonField [line 145]: Invalid index (25) for list: valid range is 1..24 It reads as though it's able to loop through my first 24 questions and then throws up on the new entry, but I am not constraining the index to 24 values. I believe this is because it's not handling the missing values properly (previously assessed items have no response for the new question) so I manually inserted the values into a

Hello,we have a problem using the attached rule, note that the value for batchSize is 10.The following error message appears:Error evaluating expression [....] in rule [...] at function queryEntity [line 3]. An error occurred while retrieving data  The entity being queried is a VIEW in the SqlServer database, and this view contains about 68.000 rowsIn the tomcat-stdOut.log  we found the following rows:2021-05-05 13:12:52,416 [ajp-nio-8009-exec-9] ERROR org.hibernate.util.JDBCExceptionReporter - The query has timed out.2021-05-05 13:14:20,013 [Timer-4] INFO  com.appiancorp.cache.sail.StatefulSailCacheImpl - Stateful SAIL db cache cleanup process executing...removing expired entries from                                                &nb

My requirement is to refresh my related action button when any event happens and the visibility for the related action set to false

I had a CDT which has a couple of primitive datatype fields and a CDT field. When I changed the child CDT (Added two more fields) then the parent CDT became invalid. Now I am not able to refer to it on any interface using type! and also when I try to open the CDT, it opens in read-only and doesn't show any columns. Also, there isn't any option to download the XSD. I have attached all the supporting screenshots below. p.s. None of the CDTs were mapped in a DS. Both were being used on the Appian side only. 

I am trying to change the date format of all values of a colum, and I do not understand the error message I am receiving: a!gridColumn( label: "Deadline", sortField: 'recordType!{foo299792458}Step.fields.{timeGoal}timeGoal', value: a!richTextDisplayField( value: { a!richTextItem( text: { text(fv!row['recordType!{foo299792458}Step.fields.{timeGoal}timeGoal'],"yyyy/MM/dd") }, color: if(fv!row['recordType!{foo299792458}Step.fields.{timeGoal}timeGoal']

I have an interface  with few filters. Now I want to display the editable grid when user clicks on search button.

I have created a site in which have added Record type, when i click on record link then summary interface is opened  then how  to go back to record list from summary interface.

Hi Community, So I am creating a new CDT from scratch, I have 5 fields in it .No database table is created . Primary key is defined in CDT. One of the fields c_address I have defined as text type and checked the array checkbox. All saved , but I am not able to publish the datastore. Getting the below error. Basically I am checking how array functionality works for a text type or any other type. Kindly share some insight. Thanks

We already  have tasks in tempo that displays the pending tasks with basic details then we have task report where we can get the list of tasks and can edit what we need to display. Then what is the concept of custom task report and when should we consider using it?

I have configured a record type which displays me something like the following on the records tab in Tempo I now would like have links in the 3rd column to corresponding records. Here, the "apas_step_config_..." are actually DB table names. I already created constants pointing to the corresponding entities in my data store objects of that specific DB. Also, I created record types for all possible appearing config table names. But how do I configure my display value here? What I can think of is that I introduce another column in the database which contains the URL of the corresponding record page on tempo, but that seems to hard-coded? I would appreciate any guidance.

Hi Friends , Is there any way to  capture error message when we use  a!writeToDataStoreEntity() smart node in Process model and if it fails saving the entity ? I want to show Error interface with Retry button in case of the smart node a!writeToDataStoreEntity() fails . Regards Ravi Babu.

Hi Friends, How to handle inflight processes when we update CDT and release the same to prod ? Regards Ravi Babu.

Can we add multiple action on Record List? If Yes then how?

where can I find this interface with fv!item on

while i am trying to map a process variable which is a forigen key in another table, i got an an error saying that  integer cannot be cast into the datatype "EMS_DATATYPE", so i thought to cast it , but my cast is showing the same error ... this  is the code that i written in scrip task cast(  'type!{urn:com:appian:types:EMS}EMS_J_PROJECT_MEETING'("PROJECT_ID"),  pv!PROJECT_ID) and the error is An error occurred while evaluating expression: EMS_J_PROJECT_MEETING.PROJECT_ID:cast(    'type!{urn:com:appian:types:EMS}EMS_J_PROJECT_MEETING'("PROJECT_ID"),     pv!PROJECT_ID) (Expression evaluation error at function 'cast': Could not cast from EMS_J_PROJECT_MEETING to Number (Integer). Details: CastInvalid) (Data Outputs) any suggestions?

Hi Friends , What is the max length of CDT in Appian ? Regards Ravi Babu.

Hi Friends, Max number of columns in CDT ? Regards Ravi Babu.