Discussion Categories

Hi there, we are trying to read the data from SAP tables, for instance the table "T001". This table holds maybe only about 100 entries. For this reason we do not have any conditions. We already have a connection to our SAP System and we are using several BAPI's. But with the BAPI "RFC_READ_TABLE" we do have some issues. a!sapInvoke( scsExternalSystemKey: cons!SAP_EXTERNALSYSTEMKEY, usePerUserCredentials: false, hostname: cons!SAP_HOSTNAME, clientNumber: cons!SAP_CLIENTNUMBER, systemNumber: cons!SAP_SYSTEMNUMBER, bapi: "RFC_READ_TABLE", importParameters: { QUERY_TABLE: "T001" }, tableParameters: {} ) Errormessage: Details from external system: java.lang.IllegalArgumentException: InvalidFieldType We have tried unsuccessfully several option for "importParameters" and "tableParameters". Any idea how to create a simple call to read from a SAP table? thanks Yusuf

Hii,   In the process of moving the log files from Appian to AWS cloud watch, I found a way i.e to possibly download the .csv and .log files in bulk amounts and then move them to the Aws S3 Bucket. So to do so I found a function in the SFTP plug-in, "queryappianlogs()" but not sure what are the parameters to pass like the SQL statements. Can you please help me to sort out this one, this allows me to download fixed to 1000 rows.

user gets this error frequently at peak time - "An error occurred  because the record type source is currently unavailable or the query reached out a timeout or memory limit",

Hi,  I have a requirement to add the number of working days to the given date. I'm using caladddays() function. Its behaviour is different sometimes. The same thing works as expected when I use a!addDateTime(). Can anyone explain why it happens? Thanks in advance.

Hi Team How is Appian Support forum  different from community. Is there a documentation to understand the complete features that are provided in the forum. Eg: Raise a support, maintenance activity and monitor environment.  This will help to leverage the use of forum. Thanks.

Hi Team Will system administrator gets all the errors of the app. Is that the default thing. When record type sync fails system administrator of the environment is getting notified. Is there a way to restrict this and main goal is to alert the support group when the instances fail and we have added the support group in the alert in the process model. Team, is there a way to fix this.

Appian is throwing error while statrting the application, by saying QRTZ_LOCKS table is already present. Few points about the environment are below  1. It is new Appain additional server(like UAT2 or SIT2), this is the first time we are trying to start the instance. 2. The  db schema(oarcle DB) was copied from lower environment(i.e. i contains all the tables Business and meta data. as same schema has been used for both) 3.We cannot drop/rename  the QRTZ_LOCKS table, due to some internal reason. Can we skip this table creation part by anyhow? Where can i get the complete list of appian meta data tables? Kindly help me to resolve this issue.

Hello Everyone, I want to check the current license status of our Appian environment. Is there a page to manage licensing? Thanks, Chaitanya

I'm in the appian designer and I'm trying to sort my datasets by description. Normally if you use an underscore "_" as the first character, entries with the "_" as its first character will appear at the top of the list when sorting alphabetically. Not with Appian however  Anything with an "_" as its first character sorts to the bottom of the list, not the top. Example  Any NameBny NameCny Name_ny Name Why? No one else seems to do it this way. I've worked with dozen of applications and none of them sort the "_" character last like this.  Is this a bug or is Appian taking a page from MS' playbook and assumes that it knows better than everyone how sorting should work? How can I fix this or find a work around? I don't want to resort to using 1, 2, 3... in order to force my descriptions to sort properly.

A task within a process for which you are an administrator requires your attention. The task currently has no valid assignees and will not be completed without intervention. Please click the link below to go to the task and reassign it to another user or a group with members.Priority: Normal Even though the task is assigned initiator. I am getting this error. Any suggestion on this?

Hi Team, I have a requirement to execute an expression rule by its UUID/Name. The UUID/Name of the rules to be executed will be saved in the DB, during the runtime the system should read the UUID/Name and execute the rule corresponding to it. Thanks in Advance !

Hi, I want to display an image from an external API call. Currently, I can achieve this on the interface using a button, but it is not ideal. The user wants to load this image from the API on interface/page load without the need to click on the button. Is it possible? Below is the current call I use for the button. thank you. a!buttonArrayLayout( buttons: { a!buttonWidget( label: "View API Image", saveInto: rule!GI_APIExternal_itemImage( imageNumber: Local!ImageNumber, onSuccess: { a!save(local!FTNICallresult, fv!result), a!save( local!AppianInternalDocumentID, rule!LCP_GetNumberOutOfText(local!Callresult.body.imageData) ) }, onError: { a!save( local!CallErrorMessage, fv!error.message ) } ), size: "STANDARD", style: "NORMAL" ) }, align: "START" )

I would like to use a customized large language model in appian.(I am not asking about official connected systems created by openai or appian)I know it is possible to use LLM through API in Appian, but is there any way to implement LLM in Appian? I suppose it might be a bit difficult since you can't use Python in Appian.

How to provide Appian with a list of AWS Principals that will send connection requests to the endpoint service?

Hi, can someone tell me how to create VPC endpoint services in Appian?

I have a doubt in the parameter "Disabled".  I have a form with some fields. For one of the field (Customer) I can select values via 2 options ( one from the dropdown and other is the text field) . These values are stored in dropdownCustomer and textCustomer field.  I want to disabled the button if some fields are blank in my form. My doubt here is, for the customer field, there will be only one value present either the dropdown or the text field.  If I check a!isnullorempty(dropdownCustomer), it maybe null but the other one textCustomer might hold the value. so, I need to check if any one of the field (dropdownCustomer or textCustomer) has a value, then I don't want to disbale it. Can someone please help here.  disabled: or( a!isnullorempty(field1), a!isnullorempty(field2), a!isnullorempty(dropdownCustomer) )

We have created a document upload UI similiar like Image right as user wanted it like that.It has folder>subfolders or option to add one> document are uploaded. I have used for each to show hierarchy of folder then subfolders and file upload.issue is When i want to upload document to a particular subfolder it is populated in others subfolder file upload as value field is same for all.So I want to upload different douments in different subfolders(as we do in our PC) and should be able to save them.I have tried a!map but it does not support append.

I am Facing Some Issues While Mapping Data store entity. I have created a view by joining three tables, and I obtained the exact data. Then, I created a CDT (Custom Data Type). However, when I attempted to map it into a data store, it failed and displayed an error.

Hi, I would want to ask how can I use the related fields (record relationship fields) in a process model. Now I´m passing a null value The relation appears in the "Write Record Inputs" And these are the outputs: Then, I have a XOR to put conditions to the related fields, but I think I´m not passing the values well because the logic is not working. 

Has any one done an expanded/collapse row grid within an expanded/collapse row grid.  I am looking at the https://docs.appian.com/suite/help/23.2/recipe-expand-collapse-rows-in-a-tree-grid.html#expression in the documentation and it look like what I am looking for, I just need a third level.  I am looking at creating a grid that displays primary customers, then expands to show those primary customers ship to's then another expansion to show the ship to's contacts.

Dears, My requirement is to fetch the files from the Network Shared folder (\\shc-abc\xyx\) . Do we have any smart service to get the files from shared folders? Thanks in advance.

Due to resetting one of my colleague's phone, he lost the Google Appian authenticator!  Is there any way to reconnect with the Authenticator?

I am aware of the custom picker feature that functions as a predictive text input. However I want it to have the capability to select a value if it already exists, and if it doesn't exist, allow the user to input a new value.(Similar to Excel). This is necessary to prevent the creation of duplicate entries in a field. Can you provide suggestions on implementing this functionality while avoiding performance issues in the interface

Hi, We are trying to generate CSV with 1 million rows. But when we try to transfer files over SFTP, the file transfer fails. For less number of rows the SFTP transfer goes fine. What is the rows allowed for SFTP file transfer?

Hi All, We have only one rows in DB to sync using record type but record sync is failing with below error: [RecordSyncScheduler_Worker-1] ERROR com.appiancorp.record.service.BulkLoadServiceImpl - Error syncing record type with uuid: ******** com.appiancorp.suiteapi.common.exceptions.AppianException: Unable to sync due to a system issue. Issue identifier: ****** Caused by: com.appian.data.client.AdsException: APNX-3-0300-000: Unable to process the request: java.net.SocketTimeoutException: Read timed out We are getting this error in all cases whenever record sync is triggering. Like immediate sync, Manual sync, through system etc. And it is failing for all record type which has sync enabled. Also because of this CPU and RAM usage on server side reaches to 100% which in turn bring the whole server down. Does anyone faced the issue or if anyone has any solution to fix this. As we are stuck cause of this. Thanks in Advance.