Data Fabric

hi everyone we just have a trouble in data sync. we have created some record types from the database, but one of them failed in data sync. the status is "failed" in sync history. the detail shows "Alert: Unable to sync due to a system failure. Issue identifier: [e0bcc3cb-4961-443e-be9d-ced7237ae97c]". is there some proboble reasons for this trouble? Thank you all.

Hi all, I have a nice process model, let's call it ProcessModel_A The process model has a PV, of a CDT type. Let's call it CDT_A. This CDT has some text and number attributes and also contains an attribute which type is a second CDT, let's call it CDT_B: CDT_A:    name - text - no multiple    age - number - no multiple ...    moreData - CDT_B - multiple There is no database here, just the process models, and no Records, just CDTs. Please, bear in mind that the moreData is a list. I've created a Process backed record, RecordPM_A, of type ProcessModel_A. When I run a query on the process, like: a!queryRecordType (   recordType: RecordPM_A,   fields: {      [RecordPM_A.fields.moreData.CDT_B] ... when I query it like this, in the attribute moreData it keeps telling me that this is a list of text and is retrieving only the first element of CDT_B. Any idea on how to FORCE it to understand that the list of element

I'm having an issue currently where a single column, very occasionally, will revert back to null soon after it is updated. I set up a trigger that tracks when alterations are made to this column. I then checked all process instances that were running at that time and finally narrowing it down further by searching for PMs that were a depended of the database constant. I find that the only PM that fits the bill is the one that updated from null to 0 in the first place. I was wondering if anyone had experienced an issue like this before. Below are some pictures showing time stamps for when updates occurred.  In both instances it is updated back to null very quickly. The first 11 seconds later the second one within the same second. Anyone have an idea of what this could be?

Millions of data in query entity is possible to query for fetching data

How to add column in cloud database

What should be the best practices in terms of Record Type or Entity  if requirement is as per below- 1- Data structures has to have more then 100+ columns 2- Many attributes are of 4000 Char length Is it safe to use query entity instead of query record with above cases with the perspective that every thing is driven thru record type in future and most of the new featres will be based on record type.

I am using a record type to back some read-only grids via a!recordData. The grids both use the same record type, but with different queryFilters passed into a!recordData. Both instances need to show the OOTB search box, but I need to disable the "My Filters" view and the "Save Filters As..." feature to avoid users getting confused. Furthermore, the application of a saved filter as default will be applied to both instances of the gridField, which is something we must avoid. Is there a way to disable My Filters / "Save Filters As" while retaining the OOTB search box? Else I would need to build a custom search.

First, please let me know if the following is correct regarding transaction control when using the Write to Multiple Data Store Entities Smart Service. If the same entity is accessed by multiple users at the same time, the update executed later will always take effect. I know that procedures can be used as a method to access tables (entities), but do you know if there is a possibility of inconsistency if a procedure and Multiple Data Store Entities have access to the same table (entity) at the same time. Is it an anti-pattern to also access by Write to Multiple Data Store Entities for a table accessed by a procedure? This is a question.

Is it possible to perform multiple inserts or updates in the Query Database? I understand that the method using recordTyoe and relation is recommended by Appian, but I am asking this question to achieve exclusive control of updates to multiple tables. I know that this can be accomplished by a procedure, but I would like to know if QueryDatabase can be used as another technique.

Can Delete Records and Write Records be performed in the same transaction? I would like to do a rollback if either Delete or Register/Update fails.

Hi, My team is trying to create a chart that warns users when an app is used the most. As soon as the user execute a process, we insert in Database some information (timestamp, typology, current user, etc). To generate the chart we use the following code: a!lineChartField( data: 'recordType!{2e39f6f7-a6b0-43c0-a1f2-39a16ddf112a}PGM interaccionesMotivosYCanales', config: a!lineChartConfig( showIntervalsWithNoData: true, primaryGrouping: a!grouping( field: 'recordType!{2e39f6f7-a6b0-43c0-a1f2-39a16ddf112a}PGM interaccionesMotivosYCanales.fields.{88cbc07e-c205-4ccc-8c3f-9245ea2bfbf1}timeStamp', alias: "timeStamp_hour_primaryGrouping", interval: "HOUR_OF_DAY" ), measures: a!measure( function: "COUNT", field: 'recordType!{2e39f6f7-a6b0-43c0-a1f2-39a16ddf112a}PGM interaccionesMotivosYCanales.fields.{dbcf9179-1efb-4c26-aac4-bc7c25fbded7}id', alias: "id_count_measures", ) ) ) The problem is when we use "HOUR_OF_D

In related action , after submitting a form ,the form must gets closed and it must enter details in db  but after submitting the form it is not updating the details in db and the form is not getting closed can someone please with this

I want to access sql result data in Custom Output of Query Database Smart Service, but I get an error. I would like to access the ResultSets, like in the Execute Stored Procedure Smart Service if possible, can I achieve the same operation in the Query Database?

I am using expression to configure a user filter for my record. The expected result for the choices is more than 5000 but the record batch size has a max limit of 5000.  Is there a workaround?

Hi All, We are using a queryentity to retrieve the data from DB View. While retrieving the data we are seeing below intermittent issue. Our query rule is too long, I have attached that. Any suggestions to optimize this rule.   at function a!queryenti[View:/cfs-file/__key/communityserver-discussions-components-files/16/Query_5F00_Code.txt:320:240]ty an error occured while retreiving the data. Details: unexpected error executing query  Thanks

How can I export the data from read only grid (on an interface) with and without any filter, not from any CDT or record type? Need to get only these fields in exported file.

The data store "ISR Data Store" [id=163216, uuid=_a-0000e3b5-3910-8000-9ba5-011c48011c48_35304] will be saved, but will not be published: The data source schema does not match the type mappings: APNX-2-4056-000{Schema-validation: missing column [fundingSource] in table [`ISR_StudyMedicalReview`]} (APNX-2-4053-006 Here:ISR Data store in Data store object,  fundingSource is new column, ISR_StudyMedicalReview is CDT. When I tried to move to another environment during inspection I am getting this error .How can I solve this? Thanks

What are procedures in data base

I have modified the CDT by adding one columns in one environment by XSD .Now I am trying to deploy that CDT object to other environment.Can I directly deploy that CDT object to other environment.or do I need to do anything in the Target environment before deploying.CAn you please suggest me steps to deploy CDT

does it automatically update in all places where it has been used?

How to apply Aggregation (grouping) based on condition as like Group by on condition in Mysql? Example: SELECT * FROM `TABLE` GROUP BY ( CASE WHEN `NAME` = 'AA' THEN `COLUMN1` ELSE `COLUMN2` END );

Hi Team , We are getting intermittent connection issues while  using a expression rule, which retrieves data from DB source . Please find below logs for your reference .  Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: The data store entity does not exist, has been deleted, or you do not have sufficient privileges to access its data. (APNX-1-4261-001) at com.appiancorp.expr.server.fn.query.QueryEntity.getDataStore(QueryEntity.java:253) at com.appiancorp.expr.server.fn.query.QueryEntity.queryentity_appian_internal(QueryEntity.java:155) at com.appiancorp.expr.server.fn.query.QueryEntity.executeQuery(QueryEntity.java:115) at com.appiancorp.expr.server.fn.query.QueryEntity.executeQuery(QueryEntity.java:99) at com.appiancorp.expr.server.fn.query.AbstractQueryExecutor.op(AbstractQueryExecutor.java:66) at com.appiancorp.core.expr.fn.Signature.eval(Signature.java:182) at com.appiancorp.core.expr

We are using data-sync records and allowing Appian to automatically generate the tables. We ran into an issue where the maximum row length of 65535 bytes is being reached in MariaDB so we are unable to add any more columns. The issue here is that Appian defaults text fields to varchar 255 and "long text" to 4000. Therefore, if you have 16 long texts in a record type, you're already at the row limit. Further, there is no way to change the text length in the Record Type Designer. Changing a field length on the DB side require us to go back into the Record Type Designer and re-map the field since the data type has changed. Consequently, we need to also remap all references to the record field, which is a tedious task.  1. Will Appian enable an easier way to change text lengths in Record Type designer without needing to run a SQL script, remap the field, and repoint all field references?  2. Does Data Sync support the TEXT data type instead of VARCHAR? I believe TEX

When creating a service backed record having more around more than 10,000 records, there is a error. How to resolve that error? Should I go for disable sync options and then create.

I am using the export button in a record grid field. However, when the Excel file is downloaded, some of the fields have long URL links in parentheses next to them. I am not sure how to get rid of the URL links. I think this is because one of the links is a a!recordLink() component and another link is created through a personalized expression rule. Wanted to see if anyone else had insight about this on getting the link to show as normal rather than a super long URL. I have provided a screenshot of what the Excel file looks like below.