Discussion Categories

An error occurred while trying to write to the entity "StudentEducationDetails" [id=d95007c3-ee01-472a-b90c-0dbf8570a6e0@5696, type=StudentEducationDetails (id=4074)] (data store: StudentBasicInformation). Details: javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: could not execute statement: org.hibernate.exception.JDBCConnectionException: could not execute statement: java.sql.SQLTransientConnectionException: (conn=468975) Data truncated for column 'StartYear' at row 1: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Data truncated for column 'StartYear' at row 1: java.sql.SQLException: Data truncated for column 'StartYear' at row 1 Data: TypedValue[it=4074,v={<null>,<null>,Jabar,B.tech,2017-11-01,2021-12-07,90,1,2022-11-28 04:30:00.0,NRT}]

anyone can you please help me for this qustions?

How can we compare now() with the date for example dueDate if its ON TRACK or OVERDUE?

Hi there, Is there a way in Appian of searching all the application objects for the objects which contain certain function or string? just like search/find function of those code editor. it will return the files/or even the location in the file. Best regards, Lin 

i have a requirement to generate the PDF through XSL-FO In table i have a text like 2000 characters in table cell without spaces i need to wrap that text  XSL Code: PDF:

Hi Everyone, I am trying to execute this Stored Procedure in Appian Maria DB  and unable to check how to declare variable in Maria DB. Please let me know if any thoughts, BEGIN  DECLARE COUNT1 VARCHAR(1) DEFAULT 'S'; DECLARE CUR2 ROW TYPE OF SDP_TEST;  DECLARE cur1 CURSOR FOR SELECT * FROM SDP_TEST;   OPEN cur1;        LOOP            FETCH cur1 INTO CUR2;            IF CUR2.id = 6            then          UPDATE SDP_TEST SET id=8,name='Peter',address ='USA',job='Analyst';         SET COUNT1 ='Y';            END IF;   &nbs

 Hi All, I have designed service back records and having some related actions added on it. Having this, i am using new component record action(a!recordActionField) on form to perform some actions.   E.g: Record A           Record B    My design :                                               1. I have interface designed and called on records summary on 'Record A'.     2. In Interface one of the section, i am calling actions of 'Record B' with record action component(a!recordActionField).     3. Now, problem Statement- every time i refresh summary tab/view, call goes to source integration of 'Record B' by record actions added.     It does seems standard behavior of ser

Hi, We are looking for a way to split a large document into small documents of size we want. Is there a way we can achieve this in Appian, please share if any Thank You

Hello guys, in my database ICH_Contracts i have information about my master contract saved in several attributes. In my process model this is saved as a porcess variable: contracts = [startYear=2023, startMonth=1, noOfOccurences=5, isCancelled=N, frequency=FRQ1, active=Y, createdOn=12/1/2022 4:15 PM, createdBy=jmaricl@jci.com, lastUpdateDate=12/1/2022 4:16 PM, lastUpdateBy=jlopeza7, contractType=CTYPE2, contractId=175, contractNumber=FY2300000176] I have a process variable which stores information about the child contract numbers: childcontractsnumber = FY2300000176_1; FY2300000176_2; FY2300000176_3; FY2300000176_4; FY2300000176_5 What i need to achieve is to add these child contract numbers to the contracts DB as new rows, where the contractNumber will be the values from pv!childcontractsnumber and the rest of the attributes will be just copied. So basically extend the contracts pv with these 5 new values. Can you please help me out with this? THanks

for certification exam, does it have exam fee?  what and all we need to prepare for exam. because we will be working on some concepts some concepts, we have not touched while working 

I have created a RPA process to log into a software on our internal network and take screenshots of a machines status and then sends those screenshots to a user outside of the network.  The bot is running unattended on a Virtual Machine.  When I have the remote desktop open, the screenshots take the image of the entire screen.  However, when I allow the bot to run unattended the screen resolution is too small to capture the whole screen (see attached images as examples).  The virtual machine is managed via VMware. Does anyone know how to increase the screen resolution of the bot on the unattended Virtual Machine?

test

Hi We have a data sync enabled Record which uses Database Table as a source. When any data gets updated in the legacy system, We need to sync the updated data in our record. To sync the changed record, in Appian documentation they have suggested to create a web api which includes a!syncRecords() function.1. I wanted know by using a!syncRecords() whether API can sync the changed data by itself? if so, how it will typecast the data into Appian structure?2. If it is not possible, how we can get the updated data and sync the record ? Thanks

Hi I'm trying to use the QUERY DATABASE SMART SERVICE to delete few records from my database tables  My query is as follows : DELETE FROM <TABLE_NAME> WHERE ID = <VALUE> Now I want the value to be dynamic. I dont know how to pass on dynamic value. I tried using the process variables, I created node inputs and tried accessing via ac!. But none works Anyone can please help me in getting dynamic values for the query above ?

Hi Guys. Im trying to make a function where the string contains half-width and full-width spaces, the first and last spaces will be removed. When i used the trim() function in appian it only trim(beginning and trail) half width spaces but if the spaces are full width it will not trim. so i tried to trim and use the substitute function like this: trim(substitute(ri!value,"　"," " )).  It does trim the value perfectly, but it will also substitute the spaces in between the value where it shouldnt be. Example process: "<full-wdith spaces>he<full-wdith spaces>ll<full-wdith spaces>" after executing the process: trim(substitute(ri!value,"　"," " )) result: "he<half wdith space>ll" expected output should be : "he<full-wdith spaces>ll" Do you have any other idea to perform the desired process? Thank You guys [emoticon:2e0881b394ea47039c4b7e5eed46a79e]

Hello All, I need to open an Interface after submit information on a Interface. Can someone help me to achieve this? I have a process model that has a interface as a "StartForm" when the user click on submit, we have some logic to write into DB and other stuff, at the end we need to display to the user an interface with the information successfully added (kind of summary of the process), I tried to use a subprocess with the interface as "StartForm", but this is not displaying anything.  What configuration I'm missing? Also tried chaining the nodes but doesn't work.  NOTE: I DON'T NEED TO CREATE A TASK FOR THIS PURPOSE, THAT'S THE REASON WHY I"M NOT USING THE "USER TASK".

Hi, I have a process model like below I have the data in each of the variable like below. Name                    Type          Multiple     Value --------------------    ----------        ----------     ------------ listOfSubmitters    Text           Yes           [addedby:AA1234]; [addedby:AA1235]; [addedby:AA1236] I need the value of each "addedby". When I am trying to make a loop and get each addedby like below. I am NOT getting required output.  a!localVariables(local!lst: a!forEach(pv!listOfSubmitters,property(fv!item, "addedby", null)),local!lst[pv!totalCountOfSubmitters]) Please advise if I have to declare the process variable with any other type instead of "Text". Or, let me know if anything wrong in a

error is : ???An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.???  I have an excel with 4 columns  Column names are same. I don't understand the error. File name I am passing as process variable. Number of columns to be read is 4 as i have 4 columns in file. Table name is my datatype name and data source is jdbc/mydatabase. What am I missing? 

We have a strict 30 minute session timeout policy, and want to show a countdown on our interfaces (dashboards and forms) warning users how much time they have left. While we can have a 30 minute timeout from load, this isn't accurate because they may keep the session active by navigating or interacting with SAIL components. Is there a way (out-of-the-box, plugin, or API) to show the user how much time they actually have left in their active session / how long since they have been active? Thanks!

Please help me check if the given number is between 1 & 20 digits and doesn't contain any alphabet in it. Like we have like(fv!item,"[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]") to check the given number should be exactly 10 digits and no alphabets in it.

While using a!recordActionItem() to open a pop-up, there is no close option which is by default by Appian to close the dialog box? What can be the solution?

While querying the Entity whatever the first Start index (startindex:1, Batch Size: 20) mentioning up to that only i was able to get the data. When i am trying to increasing the start index > 1 (startindex:21, Batch Size: 20) getting the below error  Errors in Expression: Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [COTAAuditRequestRDT14171], query: [queryentity expression], order by: [[Sort[request_id asc]]], filters:[null])

Hi When i am trying to go for 91 to 100th record in grid i was getting an error like below. Kindly suggest on the same Error in Expression: Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 42]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Customer"] has encountered an error. Expression evaluation error : Invalid index (97) for list: valid range is 1..96

Hi, I am facing a strange issue.. pls let me know if you can see where the problem is or if you need more data to answer this feature is - when an user deletes a record in a table (noc_area) - I am trying to capture the details of noc_area to another table noc_area_audit + 3 more fields. I am triggering this inside the delete function at saveInto rule inputs are areaaudit and record areaaudit is CDT  record is CDT so when the user is deleting a record.. I am capturing the  1) areas (text) from record and passing it to areas (text) of areaaudit 2) areavalue (integer) from record and passing it to areavalue (integer) of areaaudit 3) areacomment (text) from record and passing it to areacomment (text) of areaaudit ------->>>>>>> not happening and some hardcoded and system generated values to the remaining fields of areaaudit.  When I delete a specific record all values are getting successfully populated except for areacomment. It is space