Data Fabric

Hi All, I am using Oracle DB and in Appian want to create CDT for few tables. I am able to create CDT for few but for few I am not. Below is the statistics I noted.   Total no of columns in DB Total no of rows in DB CDT? Table1 68 9977 Created Table2 51 106881 Failed Table3 45 14 Failed Table4 42 26191 Created Table5 41 14 Failed Table6 36 60354 Failed Table7 32 100878 Failed Table8 32 328 Created Table9 31 2559 Failed Table10 29 39602 Created Table11 29 21581 Created Table12 29 268 created Table13 28 13565 Failed Table14 28 42 Failed Table15 27 83742 Created Table16 27 16792 Created Table17 27 944 Failed Table18 27 497 Failed Table19 26 59 Failed Table20 25 3480 Failed Table21 23 5982 Created Table22 22 195 Created Table23 21 1236 Created Table24 21 1126 Failed Table25 21 339 Created Table26 20 1688 Created Table27 20 501 Created Table28 19 88502 Failed Table29 19 1286 Created Table30 18 1073 Created Table31 18 17

Facing the following error when creating a new record where record sync is enabled. No recent changes in the code or in the record. The record is marked as synced but its data has not yet been synced. More than 50% of the hard disk space is available in the server. Doesn't seem to be a disk space issue. 

Hi, we have migrated Appian to a new infrastructure, so we are trying to align the two environments but the deploy returns errors on some recordTypes.It seems that Appian doesn't see some recordTypes even though they are there. If you click View Record List the message is:The Requested Record Type Is Not Available Expression evaluation error [evaluation ID = XYSYS] at function a!recordList: Record Type {urn:com:appian:recordtype:datatype}4ce79cd7-05b5-40a0-923d-e15cc988b782 does not exist (APNX-1-4198-000). But if I search for the UUID I find it.And the record syncs with the db without error. Has this ever happened to you? Thanks

I'm trying to build a reusable expression rule that queries a RecordType in Appian. I want to pass the fields dynamically via rule inputs to control which fields are selected during the query.

I have an issue I'm stuck on. We have this value writing to the DB for this column: And here it is after the Write to Records node: Does -2137483649 mean anything in the crazy world of data? I tried searching it but didn't return anything useful.

hello I'm on 25.1 and I have the below Use Case: I need to display on a read-only grid a short list (5 or 10 items at least) of last opened Record of a given Record Type. basically I need to store on a table the interactions over a Record List (every time a user clicks on a Record Link) in order to display the "last opened records" as a table I was thinking on replacing the Record Link with a startProcessLink which stores this transaction on a table (recordId, user, timestamp) and then open the Record Summary as a task, but this has several disadvantages: - the record page has several tabs (summary, attachments, other related data ....) which might requires additional effort to refactor - transforming the record interaction into processes might have performance issues any thoughts/suggestion about how to deal with this? thanks

Hi , We have a requirement of Loading Data into a new Table / View from 4 different tables (These 4 tables don't have Record , those are old tables They have CDT) .  In terms of Performance and New features of Records which approach will be better ? 1. Use Store Proc ( Creating a new table > Select required columns from 4 different tables > Insert into new table )  But in this case , everytime if our 4 tables get updated in Prod, We have to run this Store Proc        2. Create a materiliazed view .  but I guess in this case also , we have to update our view if there are entries in those 4 tables       3. Create a normal view from 4 tables  But Record Sync and other data fabric features won't work here I guess Can anyone please help here ? Thank You in Advance

I have create a record type using a view, Which has more than a million data.But in performance im getting the below error "Expression evaluation error [evaluation ID = a8853:4ed82] at function a!recordList_ui_design: An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit.. (APNX-1-4198-000)"

Hi, We have a custom email notification configured for a task and this is done using the tp!id parameter. the Task URL that gets generated looks like: /suite/tempo/tasks/task/<task-id>. When the user gets the task assigned and opens it from the tasks tab, it works fine. The URL for this contains the opaque task id. But when the user open the task via the custom email (tp!id), the task throws the error: The Requested Task Is Not Available The task may not exist or you may not have permission to view it. The same code works in one of our Appian environments - version 25.1.286.0 and it doesn't work in the environment - version : 25.1.236.0. Any idea if this has got anything to do with the Appian version? Thanks

I have an interface where a user is able to click on several choices in a checkbox. Each selection is stored as a separate row in a data table that is linked to their user data.  Adding new choices is easy as you just write a new row for that box. Removing them is a bit more tricky. Is there a standard best practice for this row addition/subtraction process? 

Hi All I am working on version 24.3. I have started exploring Appian AI capabilities and to start of with I find a!recordsChatField() a great component to provide to the user. So as a use case; I have a record which has user filters available. I want to use a!recordsChatField() so that we can provide better experience to the users so that they can use natural language to get filtered records rather than using user filters of records. I have gone through the forum but didn't find any handy tutorial which provides practical example of using the a!recordsChatField(). The only thing i was able to find is the document for the component: https://docs.appian.com/suite/help/24.3/Records_Chat_Component.html Can anyone please guide how can I use this field. Any link to academy online for the same will also be useful.  Thanks in advance!!

I replaced all the cdt to interact with the data using records. for some reason it is not saving the values in the database, nor in the process history fields. But if I check the variables, the values are correctly populated. Is there something I'm missing?

I can't tell if this is an appian problem or a DB problem and am not sure where to begin looking for the problem. When writing to a record I get this error: I wasn't getting this error last week, which is frustrating, but I am now. As far as I can tell, I haven't changed anything that I am aware of that might cause it. The table exists in the db and the table permissions seem to be fine. Doesn't seem to be happening with other tables and I don't have access to appian's error logs. Any ideas as to what I should do next? 

Hi Team, Whether it is possible to add sensitivity level of the document in the excel document generated from Appian

Hi,  I'm trying to find the root cause to why I can't see any records in the "Data Preview" screen of a Synced Record Type. The application works normally and I'm able to push a full sync without any issues. Other records stored in the same database are available in "Data Preview". Context: The data is stored in company hosted SQL Server. Error message: Preview currently unavailable due to an error on the source   Any recommendation to logiles, or actions I can take to understand why the data isn't displaying is appricated.  Thanks for your help  

I'm currently practising in  appian community environment. Is there a way that I can do some hands on on CDT's and Plug Ins.

Hi team,    I have written a expression rule to update a particular row of a record. The Expression rule is working as expected while unit testing but does not work when called in Script task.Could someone please help?

Hi Appian Community, we have one application for which development is completed and planning to migrate it to new UAT instances,  Already have created many records configuring data source in admin console by name like "jdbc/ApnDev001" have plan to create new data source with the name of "jdbc/Appname" in new UAT instance,  while doing to observed that we need to change data source for existing records causing field UUID get changed, and this leads to huge changes at application level wherever we have used these records. Is there any way we could fix this issue (rename or create new data source) without major changes. any form of guidance would be welcomed, Please help.     Thanks,  Shree Krishna tiwari    

Hi Team, I have written query record type with filters to get the records which are reviewed one year back. Filtering based on field "reviewedOn".Currently when i am testing this rule, getting records those have "reviewedOn" is null. How to eliminate these records which have "reviewedOn" is null.Attached Query and output for your reference:Please suggest if any solution available to fix this.a!localVariables( local!lastOneYearReviewedAttestations: index( a!queryRecordType( recordType: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestation', filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestation.fields.{9cc9f1c8-8b6c-4200-94d0-b992949d4303}reviewedOn', operator: "not null" ), a!queryFilter( field: 'recordType!{7e2fbae0-0b6b-4c59-9981-8ea4fef6165c}Attestatio

Hi All,We have an application which will receive various details from an external system including primary keys for documents which are used for retrieving documents from another system. We receive these details via an API and a task is created for the user to process the same. When the task is being processed by the user, the external system might update the data again which includes adding or removing documents. Since the task is opened by the user, he will never know whether some update has happened to the task or not. We thought of using some refresh variable but it does not seem to be a viable solution. Also it might lead to performance issues since the number of users and number of tasks will be high. Is there any way to handle real time updates and show them in UI?? Any suggestions would be helpful 

I'm currently exploring all the possible ways to insert record in a record type (for e.g. StudentDetails is my Record Type) but I have String fields as process variables. one way I know is (i) Gave Input Variable of StudentDetails type and in Script task Output  mapped the values from process variables  and used write records.

Hi Appian Community I am using a web service to fetch the records I have synced all the records successfully but, in the list, there are less records available.  Sync successfully for 10046 records but only 6549 available in the list

Hi everyone, I'm having this issue and trying to find some help/ recommendation.  I'm having this process report that contain 1 row of data. But when I run the expression rule to query it with 2 different user account, I get different results, even though the 2 accounts are in same All Users group and that group has Viewer level security in my report.  With my main user account, when I run the query I get that 1 row of data back as output - expected With my test account, I get null value as output - Even though when I open the report I can still see data displayed.  Is there any other areas apart from security level that I should look at?  This is my code snippet, I just input in the context process model and report if( ri!isMissingMinimumInputs, if( ri!doReturnData, {}, a!dataSubset() ), a!localVariables( local!columnConfigs: if( not(rule!GBL_isEmpty(ri!columnConfigs)), ri!columnConfigs, a!queryProcessAnalytics(

From the Grid Layout list i need to add to the other Selected List which is Related Record Data. So when calling this grid interface i am facing issue in the Parent Interface that. When I am selecting more that one item from the list it throwing me the below error. Please let me know how to rectify it Interface Definition: Expression evaluation error [evaluation ID = 033a4:c74b3] : An error occurred while executing a save: Expression evaluation error: Cannot update List of DIL Product User Trans; length of assign value list (2) does not match length of the list to update (1) 1. No Error while selecting 1 item from the list 2. If select more that on item from the list it throwing the below error

Hi, How we can create dropdown using record data?