General

Curious if any other practitioners are running into issues with Oracle 12.2 and it's use of editionable views? Currently running Appian 23.3, we are upgrading a business Oracle database we connect to from version 12.1.3 to 12.2. With this version of Oracle, the best practice is promoted no longer reference base tables. Instead, editionable views are automatically created to utilize and this is what is mandated by our Oracle teams, via a synonym pointing to the editionable view on the table. Appian (at least in my current version 23.3), does not seem to support the use of synonyms in this new fashion, as in the past we have always used synonyms within Oracle to satisfy data store validation and operation, for objects residing in different schemas, etc. With Oracle 12.2, these editionable views are created automatically from the first 29 characters of a table name such as below: Table: ORACLE_TABLE_NAMEView:  ORACLE_TABLE_NAME# This practice forces changes to the original synony

Can you disable dates in a datefield based on a date? That is, disable calendar dates starting from a specific date

Hi team, We have a requirement to fetch the data from FTP server where the file exceeds 100Mb size or more and we have to store all those files(100GB) into Appian Folders. We are storing the files to display in grid and then download the file whenever required. Is it recommended to store all those files into Appian, If not what is the best way to do so? Thanks.

Hello Everyone, I have recently completed all of my Appian Release showcase trainings and got a revised validity date on my Associate Developer Certificate. Can anyone please suggest how I can download my Associate Developer Certificate with the latest validity date on it. (Also I'm not able to find my old Appian associate developer certificate) Please guide. Thanks & regard

I have some nested CDTs, like a nested in b, b nested in c, I want to cast it to recordtype with relationship, like C has one-to-many relationship to B, B has one-to-many relationship to A. All fields are mapped, how can I cast?

I am migrating Appian instance from 20.1 to 21.2. Post migration, I am receiving error is starting the Data Server. Log file  name : Wachdog.log Per Log: The data server historical store (hs) folder and snapshot(ss) are not empty which is the case ( as it is migrated) but some how lastTxOffset  value is found to be -1 which indicates log should be empty. Error stack {"level":"DEBUG","time":"2021-06-24T02:43:39.333Z","logger":"watchdog","caller":"KafkaConsumer.java:2181","thread":"main","msg":"[Consumer clientId=consumer-1, groupId=dataserver-consumers] Kafka consumer has been closed"}{"level":"ERROR","time":"2021-06-24T02:43:39.333Z","logger":"watchdog","caller":"Watchdog.java:1194","thread":"main","msg":"Shutting down with exit code 1..."}

I am getting this error "Cannot sort by field [teamMemberId] because it is from a one-to-many record relationship." when trying to apply sort field gridcoloumn a!gridColumn( label: "Members", sortField:recordType!WFM RID.relationships.wfmRIDmember.fields.MemberId value: count( fv!row['recordType!WFM RID.relationships.wfmRIDmember.fields.MemberId'] )

Hi everyone After reading this sentence, I wanted to know more, so I would like to ask a question.  [mention:a776b956d9da49b1bbfb78dfc99430ac:46448885d0e64133bbfbf0cd7b0fd6f7]  How can i map a view with record type. As a result of investigation, I was unable to map View to RecordType. Thanks

Hello devs, I need your help. I have two records: 'account' and 'transaction', and the 'balance' field of 'account' varies based on the value of the 'Amount' field of 'Transaction'. I've added conditions to update the 'Balance' (in the saveInto function) when the user clicks 'Create transaction' and it works well in the interface the field in my ruleInput record has been updated, but the update isn't happening at the database level. How can I dynamically change the balance on my site based on the value of the 'Amount' field of the transaction record?

Hi Everyone, We have one functionality as we are validating the data in excel and load the data into db. I uploaded file with 1500 rows and 129 columns each row will have, I am getting below error when i try to upload 1500.   The System Has encountered an error, An error occured while processing your request.  but when i found in server log below is the one,Can anyone of you please mention what is the below error stating? which size it is mentioning as 200,000,00? APNX-1-4532-000,"Expression evaluation error: Max compression size exceeded. Max size=200,000,000, actual size=257,715,470",,0000e69f-7bc4-8000-9844-3d4d983d4d98,,,,SITES Thanks in Advance!!

I want to have a readonly paragraph field with a scroll bar, so when text is long it can be scrolled within a box rather than displayed all in the page. How can I do?

 hello , j'ai besoin d'aide s'il vous plait .Je voudrais traiter cette partie : lorsque l'utilisateur dépose des documents, au moment de la visualisation, les documents PDF doivent être compilés dans un seul visualiseur de PDF. J'ai utilisé la fusion de PDF dans le modèle de processus avec ce code dans l'interface qui s'appel :               projet_docsInterface( fv!item) a!cardLayout( contents: a!documentViewerField( label: ri!record['recordType!**.{c36418cc-1402-4f64-801f-7a433c3ed250}type'], labelPosition: "ABOVE", document: ri!record['****0902-47a3-8490-7833fee28c37}docid'], height: "TALL" ), ) et j'ai fait l'appel de cette interface ici :  a!cardLayout( contents: { a!forEach( items: local!docs, expression: { rule!Projet_docsInterface( fv!item) } ) }, height: "AUTO", style: "#cccccc", shape: "ROUNDED", padding: "STANDARD", marginAbove: "LESS", marginBelow: "S

Hi team,  we have a  requirement to enter a multiple Account Numbers from a Editable grid. but has to validate the entry when there is a duplicate row. I have tried using contains function but not able to solve. please help

HI All, I am using documentDownloadLink to download the document, when clicked on it is routing to another tab and throwing below error

Hey developers, I need some help. I have a folder in which there are documents with an ID and a name. I need to create a condition in an interface to display only a document with a specific name. Is that possible?

I have a button named "Save Decision" on task details page, on clicking it automatically kicks out and returns to the home page(Where all tasks are displayed) and also the task assignee gets changed (to the one who was its original assignee before reassignment) In the code, upon clicking on "Save Decision" we are just saving data to few variables. Tried to debug but could not locate the reason. does anyone know what might be the reason for it ? Thanks

Hello, in a process I am using "Post Comment to Feed Entry", the value of author being passed is a user who is deactivated. This process sometime works fine and intermittently gives me generic error as below- An error occurred while trying to post a comment or hazard to the feed (entry id: [382]). Details: The supplied feed entry [382] is not accessible (APNX-1-4181-100) This is strange behavior, any idea why does it work sometime because I believe passing deactivated user as author should give an error always. TIA!

Hello,  I've created a new Account in Appian Community, but I use to have an older/existing one years ago. What are the steps for linking an existing account an registering as an Appian Partner. I currently work for a company who is an Appian Partner. 

Getting this error when trying go into the application, not only for our application, clicking on other applications in same environment happen the same. But when I switch to another browser (Chrome), no error when opening application Also having this error 'unable to acquire JDBC connection' in many places in our application. Are these same issue?

Hi! Does anyone know if Appian has storage with s3?

Hi Team,I just started learning Appian.  I'm facing this below attached issue when generating the record actions.Can someone help me to solve this issue?Thanks,Gnanavel Sivasankaran

We utilize the XHTML smart service to generate Word documents. Following the generation of multiple Word documents, we merge them to create the final document. Our specific requirement is to include a Table of Contents in the final Word document. Could you please advise on the best approach to accomplish this? Additionally, it's important to note that we do not rely on Word templates for document generation. Instead, we create HTML content using the XHTML smart service, which is then converted into Word documents.

Hello developers, I need some help please !  I have to create a fillable PDF that can be modified by the application users. Here are some pictures to better understand how the process works. I want the PDF to be sent as a task to the user, and the user fills the fields on the PDF. I can't do this, so I decided to use a user input task. The user fills this form, and the PDF will be filled with that information. Now, I don't understand why the PDF is not shown as a task

I am trying to calculate duration given two timestamps.  When I subtract the two, it appears the subtraction is happening with minute-level granularity (i.e. the seconds are being ignored).  Is this the correct subtraction functionality? Here's a comparison I have done trying to subtract various time intervals... a!localVariables( local!epsilon: 0.0000115740740740741, /* one second */ local!times: { { start: "1/1/2000 8:00:00 AM", end: "1/1/2000 8:00:00 AM", expected: 0 }, { start: "1/1/2000 8:00:00 AM", end: "1/1/2000 8:00:01 AM", expected: local!epsilon }, { start: "1/1/2000 8:00:00 AM", end: "1/1/2000 8:00:10 AM", expected: local!epsilon * 10 }, { start: "1/1/2000 8:00:00 AM", end: "1/1/2000 8:00:30 AM", expected: local!epsilon * 30 }, { start: "1/1/2000 8:00:00 AM", end: "1/1/2000 8:00:50 AM", expected: local!epsilon * 50 }, { start: "1/1/2000 8:00:00 AM", end: "1/1/2000 8:00:59 AM", expected: local!epsilon * 59 }, { start: "1/1/2000

Hi, My requirement is to click on a link that re-directs me to a UI, but before that I want to delete all existing documents from a document folder. Is there any way by which I can delete all the documents from a document folder in a go. I know we have a!deleteDocument() smart service which would delete a particular doc. If there is no way to delete all docs in one go, please let me know how to get the doc Ids of all existing documents in a doc folder.