Process Automation

Hi Everyone, I am returning a cursor from Oracle SP, When using new executeStoredProcedureForQuery, i am getting "Invalid Column Type:2012" error.  can see in "Appian Community", Updating ojdbc8.jar solved error, Please advise whether we can follow this solution for our Project.  

Hello folks, in my current solution i use an expression rule which queries a View in DB and returns the data based on filter. The Contract Number is an array of Text type, so far as operator i used "in" which worked perfectly even with multiple values. Now there is a new requirement from the business that instead of using exact values they want to have something like contains ("includes" or "start with"). It works if i change the type from array to single value, but not working with array. Is there any way how to make this work even for array? I am getting the following error message while using array: a!queryEntity_22r2( fetchTotalCount: TRUE, entity: cons!ICH_ENTITY_ICH_V_ContractReferenceData, query: a!query( selection: if( rule!GBL_isBlankOrEmpty(ri!fields), null, a!querySelection( columns: a!forEach( items: ri!fields, expression: a!queryColumn(field: fv!item) ) ) ), logi

Hi All,  I am working on the Appian IDP application. I have trained it on some single-page documents, and it is perfectly working for single-page documents. Now, I have a document that consists of some text fields and a table. The table is starting from page 1 and going up to page 2, but for this document only the single page is getting extraction for the table. I am not able to select the table details from the next page. Can someone else also face this problem, and do we have any solutions for it? Thanks in advance.

Hi All,  I am working on Appian IDP application.  I have trained some single paged documents and it is perfectly working for single paged documents.  Now, I have a document which consists of some text fields and a table, table is starting from page 1 and going up to 2 page, for this document only single page is getting selection for the table. I am not able to select the table details from the next page.  Can someone also face this problem and do we have any solution for this.  Thanks in Advance. 

Hi All ,  I have values stored in database in a particular field i.e. say previousValues, like below  "{"name":"xyz","regDate":"2012-07-01","regStatus":"Completed"}"  --   (Text) Now my requirement is to fetch regStatus value from this format .  How can I achieve this

I'm trying to connect the UIpath orchestrator in Appian connected system. Eventhough my credentials are correct, its showing invalid credetial URL I tried- platform.uipath.com/[organization name]/[[Logical name]/orchestrator_ https://cloud.uipath.com/[organization name]/[[Logical name]/orchestrator_ https://platform.uipath.com/ https://cloud.uipath.com/ I got the below error for all the URL's i tried

Hi, I am getting below cast invalid error for below rule. Please help in resolving this. The same code is working fine in one of our environments but not in another environment. "Expression evaluation error at function a!queryEntity_22r2: Could not cast from Boolean to Data Store Entity. Details: CastInvalidCould not cast from Boolean to Data Store Entity. Details: CastInvalid" a!queryEntity_22r2( entity: cons!RGRACSLBL_ENTITY_NEW_PROJECTS_EVENTS_VIEW, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "processId_int", operator: "not null" ), a!queryFilter( field: "isExistingCountry_bool", operator: "=", value: ri!isExistingCountry_bool ) } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: - 1 ) ), fetchTotalCount:true() ).data

I need get a document from the external cloud source and need to do data extraction using IDP process model and convert the data into the CSV file and source the file in another external cloud folder can it be done in IDP  or RPA ? if yes how to do that. 

Hello,I'm trying to create an RPA that fetches data from a table from a system and then do operations on that data.I'm able to fetch the table data, and I have a section with a expression rule that does the correct parsing on that data, but I'm not able to use them in junction.I'm trying to pass the data like this (the value is not empty), but the value being passed is always empty, according to logs.Anyone can help me with what I'm doing wrong?

Hi, We have a requirement to generate a document which contains some information of a user that needs to be encoded by the guidelines provided. We need to format the value in such a way that it's length remains fixed always which is provided to us. So any value which has less digits than the required number of digits should be formatted like for eg: If the input is 1250000 and the max limit is 20, then it should be encoded as 00000000000001250000. How can we do that, thanks in advance.

We have integrated the automated rule testing to our CI/CD pipeline. We are using a!startRuleTestsApplications to start the test. We notice on an average the entire test takes under 15 mins to complete, but on occasions the test takes a long time and we ultimately have to kill the build.  Want to know how I can debug this. Unable to find anything in the tomcat logs. Is there any debug log I can enable to check where the test execution is stuck?

Hello guys,We're dealing it some issue on attempting this:Right now with find() function or exact() you can't achieve the following:Let's say we have an e-mail with this phrase "I am an idealist", and on the other hand we have a key defined as: "ideal", right now because the body considers all the text, if you try with find(), the output is true because it finds "ideal" on "I am an [ideal]ist", and the exact() will not work as well because "I am an idealist" is not the same as "ideal", even if the key was "idealist" it will output false as well. Any ideas?

Hi, I'm new to Appian RPA and trying to use task recorder feature to record browser interactions and convert them into robotic task action. However when I click on start Recording, my page is stuck at this   and there is no recording started. Can anyone help me with this and tell what I'm doing wrong?

While configuring Execute Robotic Process Smart Service I am getting the Error "Node 2 contains a notification escalation with no recipients.". Any idea how to fix it ? 

Hi, Whenever I'm trying to use any actions under File system for Appian RPA ,simple actions like "Copy file/folder" ,"Get Properties of file" there's always an error being thrown .Any help/suggestions would be appreciated.

Hi , I am trying to upload an excel file from my local desktop to Appian folder.  I am using upload document action from Appian RPA. I am able to locate the file and get file properties but facing null pointer issue when trying to upload the file to Appian folder. Please refer to the execution log below. Any insights on this would be helpful.  [WARN] 2023-03-09 19:19:40 - - Method manageException invoked[ERROR] 2023-03-09 19:19:40 - - java.lang.reflect.InvocationTargetException    at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:119)    at java.base/java.lang.reflect.Method.invoke(Method.java:577)    at com.novayre.jidoka.client.RobotClientExecutor.invokeMethod(RobotClientExecutor.java:1546)    at com.novayre.jidoka.client.RobotClientExecutor.onManageExceptionMethodCall(RobotClientExecutor.java:778)    at com.novayre.jidoka.cli

Hi all, I'm following the tutorial RPA Tutorial: Parse Excel Files to learn how to retrieve files from a resource. From this example, I'm using my pc as resource. In one speficic documentation steps, there is the note If you’re using your own desktop as your resource, do not use your mouse or keyboard while the test is running. So, when I launch  the robotic process, I don't touch my mouse or my keyboard. So, system gives me the expected results for file properties, but, when I move the mouse, to read it, it appears a pop up with a message error. I try however to configure the process and I receive another error with request status ENQUEUED. Which could the problem be?  Thanks in advance. Regard, Juri Monti

Hi, I have below rule which gives output for distinct values only, but I want get output for indistinct values also. For Ex: If I give rule input for groupId_int as {496,496,498} , I should get output for all 3 values though it repeats for 496 two times. But here I'm getting only for 2 items as below screen shot. Can anyone please help me how to approach  index( a!queryEntity_22r2( entity: cons!RGRACSLBL_ENTITY_APPIAN_GROUPS, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "Id_int", operator: "in", value: ri!groupId_int, applyWhen: not( rule!APN_isBlank( ri!groupId_int ) ) ), a!queryFilter( field: "groupName_txt", operator: "in", value: ri!groupName_txt, applyWhen: not( rule!APN_isBlan

Hi, is there a way to task record unsupported element in RPA.

Hi, I need to modify time stamp given by caladddays to 12:00AM always. How do I do that. Thanks

How to get the Rule Id of the Expression I want to update, since I want this dynamically based on the rule name I am extracting elsewhere and passing as a process parameter? Here when I select the rule by typing and prompt, and save it into a pv created using (+), it is showing the value for that particular rule, I but I want it to be dynamically populated.

For the word "technology", Eg t-1 e-1 c-1 I need character count of unique elements of this string

I have three CDTs that contain some fields with the same value. I want to create an expression rule that matches them and extracts only the fields that don't overlap. What function can I use to make it?

I am attempting to display a CSV file stored in CDT in the UI using the documentViewerField. Here is the code.However, I just get a blank rectangle in the UI. Does the documentViewerField component not work for CSV files? a!documentViewerField( label: index(ri!variable, "documentName", {}), document: index(ri!variable, "document", {}), height: "TALL" ),

Hi, I have a interface from where i want to invoke process model having user input interface. I have used start process it invoked the process model but showing stuck in node having interface configured and noting is displayed in parent interface also. However same process model is configured in Record action of record type design objects , it's working fine.