Discussion Categories

Hi Team, Currently we are reading excel but due to confidential file it is throwing below error. Expression evaluation error at function 'readexcelsheetpaging': org.apache.pol.openxml4j.exceptions.OLE2NotOfficexmlFileException. The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (eg HSSF Instead of XSSF) Can anyone help on this to which function help to check format in excel  Thanks  Divya 

Hi Dears, I am receiving Below Error while Viewing record data view All the Record Types. The Requested Record Type Is Not Available Expression evaluation error [evaluation ID = MFH3P] at function a!recordList: Type RecordType constructor passed 17 fields, but expected 50 fields (APNX-1-4198-000) Though the records are successfully crated, data is inserted in the table and no integrations in place.

Hi Experts, Third party app admin has provided me API to call along the bearer token to authorize. Kindly suggest if  Appian can use such bearer token Authorize the API calls or not if yes then can we use it in our connected system or not, for now I have used it directly in the integration object as header but its not working. While using below Request payload in Appian Integration object its not being read properly because of the [ ] brackets.{ "advanced_search": { "condition_rules_attributes": [ { "type": "ProfileTypeRule", "comparison_operator": "==", "value": "some vale" }, { "type": "ProfileStatusRule", "comparison_operator": "==", "value": "Active" }, { "type": "ProfileAttributeRule", "condition_object_id": "some value", "object_type": "NeAttribute", "comparison_operator": "==", "value": "some value" } ] } }

Hi All, We were previously using AI Document Center 2.9, and whenever we created a classification model, the system would automatically create the corresponding classification AI skills in the Generated Objects application. Recently, we upgraded to Document Center 3.1. After the upgrade, when we create a classification model, the AI skill is no longer created automatically. Upon reviewing the Create Classification process model, I noticed that it was updated as part of the upgrade and no longer calls the “create objects” process model, which the earlier version did. Is this the expected behavior in Doc Center 3.1? Or is there any additional configuration or post‑upgrade step that we might have missed to enable automatic AI skill creation? Thanks in advance

I am not able to get the course or learning path for Appian Process Mining? Where can i get it?

We're using Appian 25.4. We have a ReadOnly Grid that gets it data from a Record, which has a DataSource of a Process Model. Recently, we added 3 new fields to a CDT used in this Process Model as a Process Variable (note this CDT does not get written to the database at any point), and updated the grid to include one of these new fields. Since then, when we export the grid to Excel, we get the error "Query has failed: null". Undoing the changes we made results in the same problem, which has lead me to believe it's a problem with the data in the process instances, especially as when we filter the data on the grid to exclude instances that have these changes, we don't get this error at all. The really strange thing is this error isn't consistent, as we've been able to export data that includes the changes we've made to the process model, the CDT, and the grid. Has anyone else encountered this particular error message?

The grid was working fine before 2 days but now started to face this issue. None of the grid is loading

Hi Team, We've run into a unique problem with the Excel Tools plugin.  Scenario is as follows: We have a set of records with various data types and a pre-formatted Excel template where cell types are already configured. For most values the export is unproblematic as the standard Appian 4-byte integer is enough to handle the integer values. However, there's a new requirement that allows us to handle values beyond that limit (i.e. LongInt), which can be used on database side, but cannot be mapped to Appian Records where we have to rely on Text values instead. While there are plugins like Big Numbers Functions that support big decimal and integer numbers, this doesn't change the fact that we are still providing the Excel Tools plugin with a text values. Although the text is all natural numbers, the cell format in the exported Excel is of type Text and must be manually changed after download before it can be used downstream. My question to you all is whether you have

Hi all,  I am starting to build a custom plugin for our Appian Cloud setup. I need the Appian plugin SDK jar to compile the plugin. Can someone please help me or point me to how to access the SDK jar.

I am deploying a package to PROD in Appian. One object got depkoyed while other couldn't as deployment completed with errors. When I checked the log, it said the particular object is open. But thing is the object isn't open anywhere. Besides, i also logged out and logged in once to check but still, deployment was failing for the particular object and it is saying the object is being edited by me.

Hi, I'm trying to insert a break line inside the xml that will build the docx from Dynamic template, I tried with <br>, char(10), but I don't know what to try anymore. anyone have ideas?   the error log: "Changed to The value of attribute "daybefore" associated with an element type "rowvalues" must not contain the '<' character." if I use <br>

Consider blue path only! I used activity chain to start "Choose policy" interface immediately after the main interface. The process is started by a startProcess inside a saveinto of a buttonWidget. After clicking the button the process starts, but the interface isn't automatically loaded. The owner of the task is set as pp!initiator. What could I miss?

We are encountering the following error in our Appian application: ERROR com.appiancorp.record.service.visitor.DiscoverAllRecordBindings - Exception encountered in grid field tree visitor, falling back in try catch.java.lang.NullPointerException This issue appears while working with a grid component (record-based or interface grid). There are no obvious breaking changes, but the error is being logged intermittently. We suspect it may be related to: Null values in grid field bindings Record type relationships Nested field references in grid columns However, we are unable to pinpoint the exact cause. What typically causes this DiscoverAllRecordBindings NullPointerException? Are there recommended best practices to avoid this issue in grid configurations? How can we effectively debug which field or binding is causing the problem? Any guidance or suggestions would be greatly appreciated!

Hello Everyone, I’m using a Styled Text Editor for my comment thread component. If the character count exceeds 500 characters, I need to trim the text and display a "Show more" link outside the Styled Text Editor. The problem I’m facing is that the Styled Text Editor stores values with HTML tags, so when I trim the content directly, it can cut through tags and break the markup. This results in invalid HTML and rendering issues. Has anyone implemented an approach to safely truncate HTML without breaking tags? Any suggestions or best practices would be appreciated.

Good Day Expert, Is it possible to call Appian actions and related actions using OpenAI ChatGPT in Appian?If yes, could you please guide me on this? Thanks in advance. Cheers, Kalai.

Hi All, There is a scheduler process that runs hourly and fetches data from a third-party system, then syncs it into an Appian table. This process is handling around 1,400 records. For each record, data needs to be queried from an integration. Currently, the parent process batches 50 records at a time and calls a sub-process to process each record. Inside the sub-process, the integration call is made, and the data is constructed and synced into the Appian table. In total, 29 batches are running. Since this runs hourly, it is taking around 12 minutes to complete in production for all 29 batches. However, the sub-process is being highlighted as one of the top processes consuming engine time, and it is also consuming a noticeable amount of CPU. I’m not sure if this is missing any design guidance. Can someone help how to resolve this health check highlight? Note- Each integration call takes around 600 ms. Health check Highlight is below.

Hi All, In our Test environment, monitoring tab is not opening. Getting 504 error. Also none of the record types are opening. Including the Maria DB Sync records. External record type(SQL) sync is failing & I was notified in email with below error. When I click view record type getting 504 error. A scheduled sync failed. The [X record type] is unavailable and cannot be queried. Review the sync history for more information.    Also When I query Appian sync record type(present in Maria DB), getting the below error. Expression evaluation error at function a!queryRecordType_24r4: java.lang.RuntimeException: java.util.concurrent.TimeoutException. I have tested external data source connection in admin console, which says Test successful. Does anyone ever faced similar kind of issue?

Hi All,I have record type which is configured as a service backed record using an expression rule that call an integration to an external system.Additionally, we have configured the schedule full sync at 12 am daily. I have few queries regarding this:1. Since the record type is service backed, does Appian store any data internally when the scheduled sync runs?2. will a!queryRecordType() always hit the external system even after the scheduled job runs?3. If data stores internally, does appian consume memory? if yes how much?4. If it hits external system every query, what is the recommended approach if we want to avoid repeated API calls and Improve performance?Any guidance or best practices would be helpful.Thanks in advance

As you can see in the images, if you use translations in a record field, Appian will not display the correct value, it seems to display the reference to the translation. Is this a bug or am I missing something?

Im having case table where using record data and showing values in grid. The requirement is to show the high priority data at first initial sort should be applied with condition of high priority records Can someone help me

Hello, I am currently working with a Grid-only view that includes sorting functionality. My goal is to sort records first by "Received Date" and then by "Priority" (High, Medium, Low). However, my "Received Date" is stored as a "Date and Time" data type, which makes sorting by date challenging because the time component (hours, minutes, seconds) is unique and affects the sorting. I would like to sort the records primarily by date and then by priority. To achieve this, I need to convert the "Date and Time" field to a "Date Only" format so that records with the same date can be sorted by priority. I attempted to use toDate() directly on the record type, but conversion cannot be applied directly. I also tried toUniformString(todate()), but it resulted in null values and caused issues with the UI. I don't want to change from the record type, and reset it to date only. Could you please provide guidance on how to address this is

Hello Folks, I have a case when data need to be sorted in one to many relationship.  For example: There is a grid where one column is not sorted because it has one-to-many record relationship. However, I cannot change the relationship. Can anyone guide me on this please? Thanks

Hi All, I have recorded an RPA to Login to Appian  I have configured credentials. Screenshots are below When I start Testing the RPA running and opening the url in the browser, but Username and password are not set After sometime I'm receiving this the below error(attached) and task is terminating. Please suggest some solutions and let me know if you need anything else 

Hi, Need help in below scenario. when a record sync fails for an instance, the record becomes unavailable. We have enabled the recovery option and the system applies full sync of all records. Is there an alternative approach to not let the record become unavailable/recover only the impacted record instance on recovery without triggering a full record sync? Please suggest