Discussion Categories

Hi, In one of our applications, we are using an Integration object, but when we try to acces the object in Designer, we are getting the following error -- PFB the screenshot of the error. Also, when I check the logs, this is the error, I am seeing : 2022-10-17 04:48:25,899 [http-nio-8080-exec-10] ERROR com.appiancorp.rest.shared.AppianExceptionMapper - Internal Server Error on REST API invocation.com.appiancorp.exceptions.LocalizedAppianRuntimeException$LocalizedAppianException: Expression evaluation error [evaluation ID = 733a0:cd8cd] : Could not cast from Encrypted Text to Text. Details: CastInvalid (APNX-1-4198-000) at com.appiancorp.exceptions.LocalizedAppianRuntimeException.<init>(LocalizedAppianRuntimeException.java:16) at com.appiancorp.sail.server.ServerExceptionTransformer.createLocalizedObfuscatedException(ServerExceptionTransformer.java:46) at com.appiancorp.sail.AbstractUiService.localizeException(AbstractUiService.java:113) at com.appiancorp.sail.AbstractUiService.r

HI ,I am trying to update a process variable of type datasubset,I am using the following code to update a particular index value,a!update( data: pv!dataSubset, index: index( index( pv!dataSubset.data, wherecontains( 1, tointeger( index(pv!dataSubset.data, "verse_no", {}) ) ), {} ), "sentOn", {} ), value: now() ) As the data is an array and at each index again is a CDT.And I am trying to store it in the PV(type Datasubset) but I could not able to do it I am getting an error "(Expression evaluation error at function a!update: Invalid index: Cannot use multiple numeric indices into record for update) (Data Outputs)"

I created successfully a web api (image bellow) then i copy the URL in the browser and its works (check image bellow) But when I copy the URL in an incognito browse, shoe this error:  {"resource":"\/suite\/webapi\/CWAOECClients","error":"APNX-1-4187-000","message":"Authentication failed. Please check your credentials and try again.","title":"An Error Has Occurred"}Help please ///////////////////////////////////////////////////

Hi, We are planning to use LDAP for users and groups and control Appian security. Do we still need to create the same set of users again in Appian. Can someone advice on this. Thanks

Hi all, We are doing some cleansing in our environments and we want to know what was the last time a process model has been used. I tried the process reports, when analysing the process models, I can't get other than the last modification, but not the last usage. In monitoring or process reports for Tasks, I can get what is currently active or recently active, but not any kind of historical view. In the health check, there is a tab named process sizing that looked promising but does not contain that information either. I wonder if we can get any other source, of in anyone knows in table in the Appian model that we can query. Thanks.

Hi, I want to execute a SQL query, is there any function like executestoredprocedure that is used to execute an sp? I am trying to run a SQL query through the process model and trying to see the result of that query, so is there a way how to get the result of that select statement? Can anyone please help?

Hello everyone,   How to display the table format in appian using expression rules?  If anyone has the idea how to generate the table using html please help me . Thanks in advance. The finally format in pdf should be like this and data is coming from database.

i have written the expression rule to show the data in table. but how to remove these semicolons from the table a!localVariables( local!contractData: rule!generatecontracttable( cif_int: ri!cif_int ), local!rowItemsdata: { " " & index( local!contractData.value_txt, wherecontains( 1, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & index( local!contractData.value_txt, wherecontains( 5, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & index( local!contractData.value_txt, wherecontains( 6, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & index( local!contractData.value_txt, wherecontains( 7, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & inde

User demonstrated an error that is continuously occurring for them. The functionality previously worked for the user. I do not receive the error following the same steps. The error also has no details and it is not shown in the tomcat logs. What can I look in to?

Hi Community,I am trying to query form Active Task assigned to users in my application from a Process report. I was not able to create a filter for the same to check assigned tasks for selected users.= a!queryProcessAnalytics( report: cons!I_MY_OPEN_TASKS, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "c0", operator: "includes", value: ri!taskName ), a!queryFilter( field: "c3", operator: "between", value: { ri!assignedOnFrom, a!defaultValue(ri!assignedOnTo, today()) } ), a!queryFilter( field: "c4", operator: "in", value: ri!assignedTo /*issue at this filter*/ ) }, ignorefilterswithemptyvalues: true() ), pagingInfo: a!defaultValue( ri!pagingInfo, a!pagingInfo( startIndex: 1, batchSize: -

Hi, I am trying to use readexcelsheetpaging(), it shows totalCount value but not retrieving any data *note: the excel is generated using export to excel smart service what may be the issue, is there any work around?

Hi All, I have a scenario where i need to filter the data from db based on the date. Filter values will be something like below. Today Yesterday Last 7 days FYI, In Db,  date column is stored in date time format. Can an someone suggest me how to achieve the filtering thing from db based on the date when db value is date time? Thanks 

I'm working on a integration project where data is coming out of appian, here I have a situation Where I need to specify if data is missing In a particular field let's say "name" under "personal details" section then "error type" should be "personal details" and "error details" should be "name". Likewise I have many fields under section "personal details" - for this i have created a record. Can anyone please help me to achieve this situation

Hello community,  In our current project we are using "Move To Collab", lately we are facing a problem with moving Login Audit Files. Error details states:  com.appiancorp.suiteapi.content.exceptions.InsufficientNameUniquenessException: Name is insufficiently unique  Also, please find the error log attached at the end and suggest a method to over come this problem. Thanks and Regards, Vishnu Devalla [View:/cfs-file/__key/communityserver-discussions-components-files/62/ErrorLog.txt:150:120]

how to create end user to enter the insurance number and get a report. 

Hello everyone,   How to display the table format in appian using expression rules?  If anyone has the idea how to generate the table using html please help me . Thanks in advance. The finally format in pdf should be like this

What is the difference between quick apps and application builders to create an application?

hi I was able to make the connection between google sheets and appian, using the google sheets connected system (vuram)... i want to store the data of my appian cloud database to a  google sheets, is it possible? this is the integration that i have creates, connection successfully

I have created an integration s shown below: I am able to run this integration when values are null however, it is giving the below error when I give any values: sample request body with values: { "range": "Sheet1!A2:B2", "majorDimension": "ROWS", "values": { {"ABC"} }} Error:  The external system did not understand the request error-result-guidance The request was missing required details or was improperly formatted HTTP/1.1 400 Bad Request

Hi, I have deployed a new process with the Deployer tool, and few minutes after, I've noticed that this process has been launched itself automatically without any user action. The only particular settings is that the process is configured with a Timer trigger set with a weekly value : saturday on 7:00 am The process has been deployed today (friday 2022-10-13 at 12:00 am) so the day and hour does not match with the timer. Would you have any explanation ? is this an Appian ou Deployer bug ? Regards

I have data stored in db as row wise. that data i have to show in column wise is that possible if so please let me know  data stored in database like below  Contact ID  Contact Limit   AED (000)  Contact Outstanding  (AED’000)  Value of Extension Sought   AED (000)  Capital Amount  AED (000)  Interest Payment Due  (AED’000)  Current Due Date  Days to be Extended  New Maturity Date   From CrP  =Contract Limit  = Value of Full Contract - Outstanding    =Value of Extension Sought  = capital amount  = Interest Payment   =Current Maturity Date of Payment being extended  =Number of days extension sought (B)  =New Extended Maturity Date                    Total    100,000  5,555    1,192&nb

Query API fails with 500 Error because of Memory threshold reached during output conversion "An error occurred while retrieving the data. Details: Memory threshold reached during output conversion (rule: [queryentity expression], type: [YMXXDT4282], threshold: [1,048,576 bytes], objects successfully converted: [2,431])" Is there any pagination option which we can use? Any insight would help a lot. Thanks

I am unable to get a milestone for a particular id . Can anyone help me with it please

Hi Everyone, I have the requirement of impelmenting SSO login for users while they are approving the items present in interface. Can anyone please help me out? Thanks, Shubham

""