Discussion Categories

After installing latest hotfix 23.2, we cannot start the Appian Service Manager windows service.  Here is the error: Service Kafka failed to start Error running script: Unable to start transaction log. com.appian.komodo.StartKomodo$TransactionLogNotStartedException: Unable to start transaction log. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at org.codehaus.groovy.reflection.CachedConstructor.invoke(CachedConstructor.java:72) at org.codehaus.groovy.runtime.callsite.ConstructorSite$ConstructorSiteNoUnwrapNoCoerce.callConstructor(ConstructorSite.java:105) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:59) Unable to start distributed tran

a!gridField( data:index(local!datasubset,"data",{}), columns:{ a!gridColumn( value:apply(concat(_,"-",_),merge(index(fv!row,"id",{}),index(fv!row,"exhibit_id",{})) ) ) } ) Error comes:---- at merge() function  only  list are allowed .how i change fv!row to list  

Hi, I have a requirement where I need to duplicate a particular section on clicking add button. In the section I have some text fields and clicking on the "Add" button the text fields should get duplicated where I have to enter new values in the field. Is it achievable? or is there any other method where I can duplicate the fields on clicking the button ?Please let me know Thanks

Is there any official recommendation or does anyone happen to know of any benefit of removing intermediate versions generated while working on an object. For example I'm working on an interface and I happen to save my changes 55 times during the development on the page...... so I have 54 versions saved that I don't need since I only want to save the last one. Other then making the version history cleaner to go through is there any other benefit?

Hi, for the process we are automating, we need to display a document saved in the S3 bucket. To do this we used: 1) an integration for downloading from the bucket to an Appian folder 2) a safelink with web API/ a documentDownloadLink to download/view it from the user. Our requirement in terms of user experience would be to use a single click for both activities. How can we handle our problem?  Thank you for suggestions, Eleonora

We applied Hotfix 23.2.346 and Kafka will not start when restarting the Services Engines using the Windows Services.  The error log shows the following: Starting Appian Service Manager Found k.sha256 - a74b78fd5ab833a02c740879b7e962074e9b823cf9a08029ddaa003c03e51684 Detected Appian version 23.2.346.0 from build.infoStarting Distributed Transaction Log services: [all]Executing command: '[cmd, /c, start, "Zookeeper", /min, "%JAVA_HOME%\bin\java.exe", -Xms128m, -Xmx256m, -Dzookeeper.log.dir=e:\appian\logs\service-manager\zookeeper, -Duser.timezone=GMT, -cp, e:\appian\services\zookeeper-3.8.1\lib\zookeeper-prometheus-metrics-3.8.1.jar;e:\appian\services\zookeeper-3.8.1\lib\zookeeper-jute-3.8.1.jar;e:\appian\services\zookeeper-3.8.1\lib\zookeeper-3.8.1.jar;e:\appian\services\zookeeper-3.8.1\lib\snappy-java-1.1.7.7.jar;e:\appian\services\zookeeper-3.8.1\lib\slf4j-api-1.7.30.jar;e:\appian\services\zookeeper-3.8.1\lib\simpleclient_servlet-0.9.0.jar;e:\appian\services\zookeeper-3.8.1\l

We are trying to connect to Box and using the box connected system. We have followed the steps to set up an app in Box however when trying to authorize the connected system in Appian using the client Id and Secret it is giving the below error. 

i am trying to save the selected data into some local variable but it was saving as id i need full data to be save in the local or RI this is my code: a!localVariables( local!items: { a!map(id: 1, firstName: "John"), a!map(id: 2, firstName: "Michael"), a!map(id: 3, firstName: "Mary") }, local!selectedReport, local!data, a!gridLayout( headerCells: { a!gridLayoutHeaderCell(label: "Summary"), a!gridLayoutHeaderCell(label: "Qty", align: "RIGHT"), }, columnConfigs: { a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 5), a!gridLayoutColumnConfig(width: "DISTRIBUTE"), }, rows: a!forEach( items: local!items, expression: { a!gridRowLayout( id: fv!index, contents: { a!textField( /* Labels are not visible in grid cells but are necessary to meet accessibility requirements */ label: "summary " & fv!index, value: fv!item.firstName, readOnly: true ), a!integerField( value: fv!item.id, readOnly: true,

Hi everyone, I would create a note entry for my application in the record details page to create a history of the actions performed by a user who accesses the following interface. I created a manual action that allows you to write these notes in an anonymous field of the record. However what I want to create is a history of these notes: from the note entry screen in the screenshot I would like that every time a note is entered the old one is no longer selectable and a new line appears in the record detail screen under the appropriate section, as depicted in the screenshot. So the result has to be like this in the record details page. What the record call does is simply an override in a field of the selected record. Thanks everyone for the help. P.S: i don't want to simply write note in a box field in the interface: this information must be visible into 2 different sites, so i have to memorize this notes somewhere in the records

Hi All, i am developing an application in whcih I have to fetch all the records from table. now the problem in doing so is while running the expression tule it's failing which i think is failing because  i am fetching everything at a time. I want to fetch it in batches how can I make it in such a way that it fetch in batches but while writing, it should write it all at once. And also one thing this table will increase everyday by 5-7k rows. And also if i fetch data in batches won't it hit db multiple times ? What should be preffered batch size ? Please suggest me good practice to achieve the above.

Hi All, I downloaded the health check report, in that report for description column for user input task i am getting below Description. 29 calls, 1.2MB max interface, 360 max component count, 84.6KB average interface, 296 average component count. .what is the exact meaning of this description Thanks in Advance.

Hi All, If i have  two tables where possible relationship can be configured, is it better to create view from both table OR create relationship to query data from both table? Thanks in advance

Though it's an extension to below thread: https://community.appian.com/discussions/f/user-interface/20858/merged-or-nested-column-headers-in-an-editable-grid I was trying to follow the approach in above thread to achieve grid format I have attached as image in this thread post. The above logic works good but there are lots of alignment issues when grid is viewed across different environment screen like wide desktop, mobile, etc. The column widths in read only grid changes on different screens which most of the times cross the limits of above cards, for example - I have one main header "A" under this I have two headers "AA", "AB" and one more main header "B", have only one under it  "BA", when I change screen to wide the width changes and unaligns. Mostly, I see columns which should only be under "A", some part of those columns move under "B" header. Also, with paging grid, it is getting diffic

Hi, Is there any option to generate below 3d report in Appian.    Thanks in Advance.

Hi All, I am trying to update data from one table to other table using execute store procedure smart service but i am getting below error while executing smart service. (conn=8566693) Incorrect string value: '\xAC\xED\x00\x05ur...' for column. can any one suggest what it is referring for.   Thanks in Advance

Hello, I'm trying to parse a pdf that contains data in a table format and table data cells contain decimal values. However, some cells are blank and contain no data. When I use getpdftext() function to parse the data, the delimiter between 2 adjacent cells and between 2 cells with a missing cell value in between is always a <space>. Due to this, I'm unable to map the correct values to the correct column/header. Let me know if someone has an approach to resolving this issue. Thanks,

Hello! I have a Form with multiple input fields, this form works well when the users are using a PC, the problems start when they use Smartphones. If the users uses the phone in LandScape View: It all goes well: And then i tap in "Ofertar": But whe i use the smartphone in VerticalView: This happens: Then i tap "Ofertar": The value gets inverted its showing 999991 instead of 199999.

HI team, we are using the DocuSign Connected system to send Envelopes. we have a requirement to send Envelopes based on number of clients . so can the Json format in the create and Send Envelope had to be Dynamically Accept the Inputs based on the Number of Clients. i need support in creating the Json format that Accepts and send Docusign mails for Multiple Sender.  some times there will be one client or  Two or N. Thank you. Neelapala GowriPriya

Hi everyone, I would like to know if files in appian folders are deleted by default (and if so, how often) or not. Also is it possible to change this time setting if there is? Is it possible to find any related documentation on this part? Thanks all in advance.

Hi all, My problem is that I am trying to delete multiple rows from a DB table at once. All the rows I'm trying to delete have the same PK as the PK is a FK from another table. This is the code I thought would work but didn't: = {     a!forEach(          items: pv!CTI_mnthlyrevene_cntrctmnths,          expression: a!entityDataIdentifiers(               entity: cons!CTI_ENTITY_MRCM,               identifiers: fv!item.ctmnthlyrvCntrctmnthRcrdd          )     )} I've tried not using the foreach and it still gives me the exact same error:  An error occurred while trying to delete data. No data was deleted. Details: javax.persistence.PersistenceException: org.hibernate.jdbc.BatchedTooManyRowsAffectedException: Batch update returned unexpected row count from update [0]; actual row coun

Multiple Excel formulas are not working. For example xlookup when used is not giving value in preview mode means data is not going to the database hence output also not generated properly.

Hi Champs, I want to have a card with Background color as shown in Below image. I tried achieving the same using tag field as I am unable to use card layout in grid column. But the issue is that all the tags are coming in diff width bases on the text size. I am unable to set fixed width for that which is not matching with UI design as shown below. Is there any other way I can achieve this apart from using tag component which will fulfil the use case as per UX framework? Regards, Ghanashyam

I am trying to use the move documents smart service in  MNI mode to move multiple documents to a folder. It's  only moving the first document and the next documents are getting deleted from appian. I can't find them by name or document id anywhere in Appian.  When I try to find the document using getcontentobjectdetailsbyid function, it returns this response.  "Content Object [Name: SamplePDF3.pdf, UUID: _a-0000e63c-719f-8000-9bb5-011c48011c48_148201, Parent: , Parent Id: 0, Type: Document, Created by: 00001, Created on: 2021-07-02 06:57:50.0, Last updated by: 00001, Last updated on: 2021-07-02 07:05:39.0, Latest version: 1, State: Active Published, Internal file name: accdocs3/7285/10005248.pdf]"(Text) But the document is not visible anywhere - old or new folders. Additionally this is only happening on version 21.1 and not on 21.2 

Hi All, I am having two times saves in 2 variables  Eg: 1)  2/5/2023 9:00 AM GMT+05:30.  2)   2/5/2023 8:00 PM GMT+05:30 now my ask is what function we should use in order to get the output like output : 11 hrs or in minuts and also same for dates  Thank you 

I added a tab component to an interface I was building and added 4 additional tabs to the 3 that come with it automatically. I had all 7 formatted the same and working perfectly fine as each was clicked. However, I discovered that I had missed a needed tab that meant to go in the 5th slot, so I added another tab, moved it up to the 5th spot in the component configuration section, and then went through that it along with the 3 that moved down were all updated and formatted correctly. Now however, when clicking through the tabs, only the first 4 tabs become selected and show their given information below it, the new tab along with the others that moved down the list are selectable now, clicking on them just updates the page but does not change the selected button. I've been through the code and everything looks as it should I think, does anyone have any thoughts why it wouldn't be working now? Coding for the tabs: a!localVariables( local!selectedTab: 1,