Question 1

Your organization is launching a new "Customer 360" initiative. They need to unify customer data that currently resides in two separate silos: a legacy on-premises SQL database and a third-party SaaS platform accessed via a REST API. The business requirements are: Unified View: Support agents must see a single, combined record for each customer. Performance: The application must handle high-volume traffic without lagging, even when fetching data from the external API. Business Intelligence: Management wants to use Process HQ to analyze this customer data and identify bottlenecks in the support lifecycle. As a senior developer, how would you architect this solution using Appian’s Data Fabric ? In your response, please address the following: How would you use Record Types to bridge these disparate data sources? What Sync Options would you configure for these records to meet the performance and reporting requirements ? How does your architectural choice enable the data to be accessed and analyzed within Process HQ ?

Accepted Answer

In the context of the senior developer scenario, you would use Record Types as the primary building blocks of the Data Fabric to unify the legacy SQL database and the REST API into a single customer view. To architect this solution, you would follow these steps based on the sources: 1. Define Individual Record Types You would create two separate Record Type objects to represent the data from each silo: Legacy SQL Record: This record type would point directly to your on-premises database table. SaaS Platform Record: You would first create an Integration object to connect to the third-party REST API. This integration then serves as the data source for a service-backed record type. 2. Unify via the Data Fabric Using the Data Fabric , you would define relationships within the Record Type objects to link these two disparate sources. By establishing a relationship (e.g., using a common Customer ID), you allow Appian to treat the separate silos as a single, unified data model for the support agents. 3. Configure Data Synchronization for Performance To meet the high-volume performance requirement and the reporting needs of Process HQ , you must Configure Sync Options for both record types…

Question 2

When deploying a package to QC env, deployment is failing throwing the error : "The Constant [uuid = ..] was created because a value for the constant must be provided in an import customize file when it environment specific"

Accepted Answer

Error : The deployment is failing due to environment constant ,As suggesting in error we need to imported customize file importing the package in QC environment Download the customize the file and edit the the customize just uncomment last line in the comment ## ---------------------------------------------------------------------- ## Instructions ## ## All of the properties in this file are commented out; they have a pound ## symbol at the start of each line that renders them inert. ## ## Instructions and headings are marked with two preceding pound ## symbols (##). ## ## On import, all commented-out properties are ignored, and the ## corresponding values in the destination environment remain ## unchanged. ## ## To set or change a property on import using this file, ## uncomment the property by removing the pound symbol from the start ## of its line. Then enter a value for the property after the equals ## sign (=) at the end of that import customization file. ## ## If you uncomment a property, but provide no value, the value of ## that property will be set to null in the destination environment. ## Properties that correspond to admin console settings and require a value ## will b…

Question 3

You're designing a new Appian application that needs to integrate with three external systems: a legacy SOAP-based mainframe, a modern REST API with OAuth2, and a real-time event stream (e.g., Kafka or a webhook-based system). The business also requires that if any downstream system is unavailable, the user should never lose data they've entered, and processes must resume automatically once the system recovers. How would you architect this integration layer, and what Appian-specific patterns would you use to guarantee resilience?

Accepted Answer

I wouldn't treat all three integrations the same way, since Appian gives you different tools depending on the protocol and timing requirements. For the SOAP mainframe, I'd use an Appian Connected System with a SOAP-based integration, or a custom web service smart service if the WSDL is complex or legacy-heavy. Since mainframes are often slow and unreliable, I'd never call this synchronously from a user-facing interface — I'd push it into a process model where I can control timeouts and retries. For the REST API with OAuth2, I'd configure a Connected System with OAuth2 authentication so Appian handles token refresh natively rather than me hand-rolling token management in expressions, which keeps credentials secure and centralizes auth logic. For the real-time event stream, I'd expose a web API, or use Appian's native Kafka connected system if available in that version, as the ingestion point, landing events into a process model via a start event or message event rather than polling. The most critical requirement here is guaranteeing no data loss, so I'd separate data capture from data transmission entirely. The interface would save user input into an Appian data store or record typ…

Question 4

Provide all of the steps you would take to analyze feedback from users of an existing application, plan design changes, and complete a refactor of the application. At your firm's financial services client, a senior transaction advisory group has complained about an existing application. The group handles hundreds of high-value, current financial transaction approvals, related to many thousands of previously approved clients. Because these transactions are time-sensitive, multiple executives often monitor the same queue simultaneously to complete reviews assigned to their group. Their primary issues are not knowing when tasks are completed by other group members, abandoned tasks that have an "in progress" status, delayed task completion time, lack of transparency into assigned tasks, and an inability to reassign tasks they've accepted. Additionally, the group complains about load times for the high volume of data they manage, and irrelevant transactions and tasks showing in their dashboard.

Accepted Answer

This question addresses delivery methodology and multiple technical design aspects (task locking, UI/UX, and query performance improvement). Delivery Methodology First, to address this group's feedback in a holistic approach, start by capturing and analyzing the specific pain points the group has with the current application and workflow. Then, get group approval and prioritization of user stories to address the feedback as well as a project plan with estimated number of development sprints (or duration) to complete the work. For example, while it is clear that the group would like to approach the problem using a form of task locking, it is critical to determine the group's preference for optimistic or pessimistic locking. Task Lock and Communication UI/UX After determining that pessimistic locking is likely the best approach, the application will require developing the lock mechanism, UI improvements to display assignments, task lock timers, and alerts for assignments and completed tasks. Additionally, the group prioritized adding task reassignment functionality. For example, if transactions requiring review are displayed in a grid, add a column showing the currently-assigned use…

Question 5

A UAT user shares a production error screenshot displaying the generic message: "Contact your administrator." It includes an error number (e.g., 954c8:bb743). You do not have production screen or data access, but you do have access to the Development environment and the production server logs. How would you debug and resolve this issue?

Accepted Answer

Locate the Root Cause in the Logs Analyze stdout Logs: I will first check the "tomcat-stdOut.log" file on the production server to locate the time of the error and see if the stack trace is exposed there. I nspect Design Errors: If the stdout log only repeats the generic user message, I will open the design_errors.csv file. I will search the CSV for the specific evaluation ID provided by the user (e.g., 954c8:bb743) to find the exact line of failing code. Analyze the Error Snippet Based on the log entry in design_errors.csv : Expression evaluation error [evaluation ID = 954c8:bb743] in rule 'av_userform' at function a!forEach [line 72]: Error in a!forEach() expression during iteration 1: Expression evaluation error in rule 'av_uicard' at function 'fixed' [line 398]: A null parameter has been passed as parameter 1. Identify the Culprit: The root cause is a null pointer exception. The fixed() function inside the interface av_uicard (called during the first iteration of a!forEach on line 72 of av_userform) is receiving a null value in its first parameter on line 398. Most production bugs in Appian stem from missing security permissions or unexpected null data being passed into functi…

Question 6

What happens when we run as whoever started the process and run as whoever designed this process model?

Accepted Answer

When we select Run as whoever started the Process (Process Initiator) then that node will be executed with Initiator permission. When we select Whoever designed the Process model (Process Designer) then that node will be executed with the permission of user who last publishes the process model. In Event Booking Application, If the Event is associated with Hotel Reservation service, then Event Manager initiates the Hotel Booking Process which includes sending an email to Hotel Staff for Rooms Request. So, in this scenario if we select Run as whoever started the Process then Send Email smart service will throw an error because Event Manager doesn’t have permission to view Hotel Staff group. So, we need to select Whoever designed the Process model then Send Email smart service node will execute.

Question 7

One of the process instances in Production encountered an issue. When we checked the error details, it showed ‘Unprivileged/Insufficient User Access.’ What could be the possible reasons for this?

Accepted Answer

The error "Unprivileged/insufficient user access" in an Appian process instance typically occurs because the user (or the service account) executing a specific node does not have the necessary permissions to interact with an object or perform an action. Primary Reasons for this Error Deactivated User : If the user who initiated the process or the user assigned to a specific node has been deactivated in the system, they lose all permissions to execute or progress the process. Object-Level Security Mismatch : The user may not have at least Viewer or Initiator rights to an object the process is trying to access, such as: Sub-processes : The user lacks Initiator access to the sub-process model. Data Stores/Records : The user lacks Viewer access to the Data Store or Record Type required for a Write to Data Store or Write to Records smart service. Document Folders : If a process attempts to upload or move a document to a folder where the user lacks "Editor" rights, it will fail. Assignment & "Run As" Settings : By default, smart services often run as the User who initiated the process . If that user is a "Basic User" but the smart service requires "System Administrator" or "Designer…

Question 8

Your user interface contains three independent sections, each displaying data from different database tables. These tables have no foreign key relationships or any other relational links. The requirement is to allow users to update the data in all three sections and save the changes back to the database using Write to Records . Question 1: How would you design the process model to handle writing data from all three unrelated sections back to their respective tables? Question 2: Based on your initial design, restructure the process model to demonstrate: How an End shape would be incorporated How a Terminate shape would be incorporated Explain the purpose and placement of each within the redesigned flow.

Accepted Answer

Question 1: Designing for Multiple Unrelated Sections When your UI contains three independent sections (A, B, and C) that map to three different database tables with no relational links, the most efficient approach is Parallel Writing . The Design: Start Form : Use a single interface with three distinct rule inputs (e.g., ri!dataA, ri!dataB, ri!dataC). Parallel Flow : After the Start Node or User Input Task, use an AND Gateway (Parallel Gateway). Independent Nodes : Branch the flow into three separate paths, each containing a Write Records or Write to Data Store Entity smart service. Convergence : Use a second AND Gateway/ Script Task to collect the paths before the process concludes. Why this works: It allows Appian to initiate these writes independently, ensuring that data is persisted to all three tables without needing complex nested CDTs or artificial relationships. Question 2: Error Handling with End and Terminate Shapes A basic flow works when everything goes right. But what happens if Section B fails to write while A and C succeed? To make your process "production-ready," you must incorporate specific termination logic. 1. The Regular "End" Shape Purpose : Represents the n…

Question 9

Imagine you have a form with two optional fields. The requirement is that the user must fill out at least one of them, and the error message should only appear after the user clicks Submit. How would you implement this behavior in Appian?

Accepted Answer

To achieve this, I will be using a!validationMessage() Here is sample code a!localVariables( local!phone, local!email, a!formLayout( titleBar: "Example: Showing Form Errors on Submission", contents:{ a!textField( label: "Phone Number", value: local!phone, saveInto: local!phone ), a!textField( label: "Email Address", value: local!email, saveInto: local!email ) }, buttons: a!buttonLayout( primaryButtons: a!buttonWidget( label: "Submit", submit: true ) ), /* * This validation occurs at the form level and is useful when the form or * section's validation checks are non-field specific. */ validations: { if( and(isnull(local!phone), isnull(local!email)), a!validationMessage( message: "You must enter either a phone number or an email address!", validateAfter: "SUBMIT" ), {} ) } ) ) If email or phone both are null , it will throw validation on submit If I enter email ,the validation message will go off

Question 10

Other system is using Appian's Web API, In case of any process failure how would you show custom error message to requester.

Accepted Answer

You can handle and return custom error messages in a Web API by configuring the onError parameter of the a!startProcess() function. This ensures that if the system fails to initiate the process, the requester receives a meaningful JSON response instead of a generic server error. Node-Level Implementation (Web API Expression) When defining your Web API, you use a!startProcess() to trigger your business logic. You must configure both outcomes: onSuccess: Returns a success code (typically HTTP 200 or 201) and any relevant process information. onError: Catches failures in process initiation and returns your custom error message using the a!httpResponse() function. Example Implementation Logic: a!startProcess( processModel: cons!AV_PROCESS_MODEL, processParameters: { data: http!request.body }, onSuccess: a!httpResponse( statusCode: 200, body: a!toJson({ status: "SUCCESS", message: "Process started" }) ), onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson({ status: "ERROR", errorCode: "PROC-001", customMessage: "The process could not be initiated. Please check the input payload." }) ) ) Use code with cauti…

Question 11

Suppose your sprint planning is completed you have committed target for current sprint to clients, you are assigned to a 8 pointer story other members are also assigned some priority task or 8 pointers, What you'll do in case of any member who worked on that story for 2 days and unavailable due to some reasons or health issues. How you'll complete the target.

Accepted Answer

1. Reassess the story status First, I check what has already been completed in those two days. Identify what’s pending, any blockers, and whether the work is partially usable. 2. Bring transparency to the team I immediately inform the Scrum Master and team during the daily stand‑up. Agile values transparency — hiding the issue only makes it worse. 3. Re‑distribute the work We look at team capacity and see who can take over the remaining tasks. Even if others are on priority tasks, we balance workload based on: Skillset Availability Impact on sprint goals 4. Pair programming or knowledge sharing If the story is complex, we may use: Pair programming Quick knowledge transfer Reviewing the existing work to reduce ramp‑up time 5. Re‑evaluate sprint scope (if needed) If the story is too large or risky to complete within the sprint: We discuss with the Product Owner Possibly split the story Deliver a meaningful, shippable part Move the remaining part to the next sprint 6. Maintain commitment to the client The goal is to deliver what we committed, but not at the cost of quality. We adjust scope intelligently rather than rushing and creating defects. In summary, I would not try to be a her…

Question 12

You have an organization worth 20 Employees, you need to pass a survey to all and track the data filled by individuals, how will you design the system?

Accepted Answer

To design a survey for 20 employees in Appian, I would use a Process Model with a User Input Task configured for Multi-Node Instances (MNI) . While you can assign a task directly to a Group, simply putting a Group in the Assignment tab creates a 'shared queue' where the first person to accept the task 'claims' it, preventing the other 19 from responding. To avoid this and ensure individual tracking, the design must follow these three steps: 1. Task Configuration (The "Other" Tab) First, I would enable Multi-Node Instances on the User Input Task. I would select the option to 'Run one instance for each assignee' and set them to run simultaneously . This tells Appian to spawn 20 independent copies of the process node. 2. Direct Group Assignment (The "Assignment" Tab) In the Assignment tab, I would input the Group constant directly. Crucially, I would then check the box: 'There should be one-to-one assignment of task instances to assignees.' This forces Appian to expand the group members into 20 individual owners, so each employee sees their own private task. 3. Tracking and Data Integrity By using this MNI approach: Granular Tracking: I can build a process report to see exactly which…

Question 13

Explain, step by step, how you would design and implement a retry mechanism in Appian to handle integration failures?

Accepted Answer

Step-by-Step Process to Build a Retry Mechanism 1.Define Variables: cons!AV_INT_INTEGRATION_MAX_RETRIES (Number (Integer)): The maximum number of retry attempts (e.g., 3). pv!retryCount (Number (Integer)): A counter initialized to 0 to track the current attempts. pv!success (Boolean): A flag initialized to false to indicate if the integration was successful. 2.Model the Integration Loop: In your process model, place the Integration Smart Service node inside a loop structure. This loop will contain the integration call, a script task, a timer, and XOR gateways. Use an XOR Gateway after the integration node to check the pv!success variable or analyze the pv!integrationError details from the integration's output. The integration node's outputs tab allows you to store the success/error parameters into process variables. 3.Configure Success/Error Paths: Success Path: If the integration call is successful (pv!success is true), the process should exit the loop and continue with the normal workflow. Error Path (within loop): If the call fails, the flow goes down the error path which should include: A Script Task to increment pv!retryCount (pv!retryCount: pv!retryCount + 1). A Timer Event…

Question 14

Can you describe a database‑related challenge you faced in one of your recent projects and explain how you resolved it?

Accepted Answer

Challenge: In one of my projects, users started entering emojis in text fields such as names, comments, and messages. Our MySQL database was using the utf8 character set, which only supports up to 3‑byte characters. Emojis require 4 bytes, so the application began throwing errors like “Incorrect string value” whenever an emoji was submitted. Root Cause: MySQL’s utf8 encoding is not true UTF‑8. It cannot store 4‑byte characters such as emojis, certain symbols, and some multilingual characters. Solution: I migrated the affected columns—and eventually the entire database—to utf8mb4, which fully supports 4‑byte Unicode characters. Here’s the SQL change applied: Code ALTER TABLE your_table MODIFY COLUMN your_column VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; Outcome: After the migration, all fields successfully accepted emojis and other 4‑byte characters. The application stopped throwing encoding errors, and user experience improved significantly.

Question 15

Sometimes we encounter memory threshold issues while querying data in Appian. Why does this happen, and what are the best practices to avoid it?

Accepted Answer

Why Memory Threshold Issues Happen in Appian 1. Appian has a built-in memory cap for query results Appian imposes a memory threshold on query rules to prevent excessively large results from consuming too much heap memory on the application server. When a query returns too much data (e.g., selecting many columns or millions of rows), Appian stops the operation and throws the memory threshold error. 2. Occurs especially when querying huge datasets For example, trying to pull 1 million rows or entire tables without filters or pagination easily hits this limit — even if the database can return that data, Appian won’t load it all at once into memory. 3. Happens during output conversion The error often shows up as something like: Memory threshold reached during output conversion (threshold: 1,048,576 bytes) — indicating Appian hit its configured limit (default ~1 MB) while converting DB results into Appian objects How to Avoid the Memory Threshold Issue 1. Use Paging Instead of Pulling All Rows Don’t retrieve rows all at once. Use paging (a!pagingInfo() or batchSize) so each query returns limited data per call. 👉 Example principle: a!queryEntity( entity: ..., pagingInfo: a!pagingInfo(s…

Question 16

How can you integrate an external Oracle database or any database with Appian Cloud?

Accepted Answer

This can be accomplished via the Admin Console . Within the Integrations section, you can configure connections to an external database Just need to enter Oracle DB connection string, username, and password. If it is Appian Cloud already includes the supported JDBC drivers (Oracle, SQL Server, MySQL, PostgreSQL, etc

Question 17

You are given two tables: Employee and Department. Each employee is associated with a department through the dept_id column. Write an SQL query to retrieve the number of employees in each department.Ensure that the result includes all departments, even those that currently have no employees.

Accepted Answer

Assuming Tables: Department Table | dept_id | department_name | | ------- | --------------- | | 1 | HR | | 2 | IT | | 3 | Finance | | 4 | Marketing | Employee Table | employee_id | employee_name | dept_id | | ----------- | ------------- | ------- | | 101 | John | 1 | | 102 | Alice | 2 | | 103 | Bob | 2 | | 104 | David | 3 | | 105 | Emma | 2 | SQL Query SELECT d.dept_id, d.department_name, COUNT(e.employee_id) AS employee_count FROM department d LEFT JOIN employee e ON d.dept_id = e.dept_id GROUP BY d.dept_id, d.department_name ORDER BY d.dept_id; This query joins department and employee tables using a LEFT JOIN to ensure all departments are listed and uses COUNT with GROUP BY to calculate the number of employees in each department. Output | dept_id | department_name | employee_count | | ------- | --------------- | -------------- | | 1 | HR | 1 | | 2 | IT | 3 | | 3 | Finance | 1 | | 4 | Marketing | 0 | LEFT JOIN ensures departments without employees are included COUNT(employee_id) ignores NULL values, returning 0 when no employees exist

Question 18

I added new columns to an existing database table, but the CDT is not reflecting these changes. How can you update the CDT to include the new columns?

Accepted Answer

First, I download the XSD for the CDT from Appian. Then I open the XSD file and manually add the new fields. For example: @Column(name="REQUEST_STATUS_ID", nullable=false, columnDefinition="INT UNSIGNED") @JoinColumn(name="REQUEST_STATUS_ID") @Column(name="IS_ACTIVE", columnDefinition="BIT") While adding the columns, I make sure that: The name, @Column, and columnDefinition match exactly with the database table. The data types in XSD and DB are aligned properly. Any foreign key column includes the correct @JoinColumn. After updating the XSD, I upload it back to the CDT in Appian.Once it is uploaded successfully, I validate and publish the corresponding Data Store to ensure everything maps correctly and no mismatches exist.

Question 19

A user uploads documents while submitting Form-1. These documents are stored both in a database table and in an Appian folder. Now, the requirement is to copy the same documents to Form-2 when the user creates it. How would you implement this in Appian?

Accepted Answer

When Form-1 is created, Generate a dedicated folder such as Form_1_Folder and store all uploaded documents inside it and also store the document IDs in the corresponding database table so they can be retrieved later. Steps in the process model: Retrieve Form-1 document IDs Using the Form-1 ID, query the database table and fetch the list of document IDs associated with Form-1. Copy documents to the Form-2 folder Form-2 will also have a dedicated folder (e.g., Form_2_Folder ). To copy documents from Folder-1 to Folder-2, I use the plugin: "Copy Document Service" (from Appian AppMarket). This smart service takes: Source document IDs Target folder ID It returns the newly created (copied) document IDs. Update Form-2 From the smart service output (AC variables), I capture the copied document IDs. These IDs are written to Form-2’s database table entry so that they are linked properly. Sample Design of the Process model Copy Document Service Preview: Takes destination folder & Documents as Input In output storing documents id which are copied from form -2 This

Question 20

How do you configure a record action in Appian so that it is visible only to specific users? For example, if a Senior Reviewer opens a record as Senior Reviewer, they should only see the 'Manage User' action. How can this be designed?

Accepted Answer

To control the visibility of record actions in Appian, we use record action security combined with group-based access control . In this scenario, Senior Reviewers are part of a dedicated Appian group, for example: cons!MTS_SENIOR_REVIWER. Inside your Record Type: Go to Record Actions . Select the “Manage User” action. Open the Security settings for that action. Set the Visibility condition using an expression rule such as: a!isUserMemberOfGroup( username: loggedInUser(), groups: cons!MTS_SENIOR_REVIWER ) How it works If the logged-in user is a member of the Senior Reviewer group, the expression returns true, and the Manage User action becomes visible. If not, the action is hidden completely.

Question 21

Consider a process with three parallel approval tasks assigned to three different users. You need to design the process so that if any one user completes their task, the other two pending tasks are automatically canceled, and the process moves to the next stage. How would you approach this design in Appian?

Accepted Answer

This question was asked in one of my interviews. In the process model shown, there are three parallel approval tasks assigned to three different users . The requirement is: if any one user approves, the remaining two tasks should automatically be cancelled and the process should move forward. To achieve this, I configured a end node as Terminate End Event which all three paths are connected. As soon as any one of the tasks is completed by user, the flow reaches the terminate node, which immediately cancels all other active tasks and ends the process model. This deactivates the other pending active tasks and change process model from active to completed.

Question 22

In our application, a third-party vendor group currently has access to the system and contains more than 10,000 users across multiple organizations. We want to completely remove this access — meaning we must deactivate all third-party users in the database and also remove them from the Appian third-party group. How would you design this end-to-end solution?

Accepted Answer

Start With Follow-Up Questions (Very Important in Interviews) Before jumping into the solution, I would ask clarifying questions such as: Where is the user–role–organization mapping stored? Example: Is it stored in a table like USER_ROLE_ORG with columns: USER_ID, ROLE_ID, ORG_ID, IS_ACTIVE? Can a third-party user belong to multiple orgs or groups? Is there an audit requirement or rollback requirement? Should the users be permanently deleted or only deactivated? These questions help confirm assumptions and avoid designing the wrong solution. Database Cleanup – Deactivating Third-Party Users Assuming we have a table like: USER_ROLE_ORG USER_ID ROLE_ID ORG_ID IS_ACTIVE And ROLE_ID = 3 represents third-party users. Approach 1: Direct SQL Update A simple solution is: UPDATE USER_ROLE_ORG SET IS_ACTIVE = 0 WHERE ROLE_ID = 3; But this has issues: We don’t know exactly who was deactivated. There may be 10,000+ users , so traceability is important. If something goes wrong, rollback is difficult. Better Approach: Use Audit + Stored Procedure I would design a stored procedure with the following steps: Identify the users to be deactivated Save them in a TEMP_USER_LIST. Insert the same list i…

Question 23

What major challenge did you face in your project, and how did you resolve it?

Accepted Answer

One of the major challenges I faced in my project occurred within my first week of joining. I was assigned a complex task to implement validation logic for detecting duplicate forms and identifying potentially risky forms based on certain fields during the reviewer submission stage. The challenge was that I was completely new to the project, and a single form’s data was stored across 10–15 different tables . I did not have a full understanding of the table structure yet or the existing validation mechanism yet. How I approached and resolved it: Understanding the table structure: I started by thoroughly studying the application and identifying where each field of the form was being stored. I created a list of all relevant tables and columns that were required for validation. Analyzing existing validation logic: There was some basic validation already implemented through a stored procedure. I was new to stored procedures, so I carefully went through the logic, understood how errors were logged, and used that as a reference. Learning and designing the new stored procedure: This was the first time I created a stored procedure from scratch. I had to use temporary tables to store the cu…

Appian Scenario Based Interview Questions

2.When deploying a package to QC env, deployment is failing throwing the error : "The Constant [uuid = ..] was created because a value for the constant must be provided in an import customize file when it environment specific"

6.What happens when we run as whoever started the process and run as whoever designed this process model?

7.One of the process instances in Production encountered an issue. When we checked the error details, it showed ‘Unprivileged/Insufficient User Access.’ What could be the possible reasons for this?

9.Imagine you have a form with two optional fields. The requirement is that the user must fill out at least one of them, and the error message should only appear after the user clicks Submit. How would you implement this behavior in Appian?

10.Other system is using Appian's Web API, In case of any process failure how would you show custom error message to requester.

12.You have an organization worth 20 Employees, you need to pass a survey to all and track the data filled by individuals, how will you design the system?

13.Explain, step by step, how you would design and implement a retry mechanism in Appian to handle integration failures?

14.Can you describe a database‑related challenge you faced in one of your recent projects and explain how you resolved it?

15.Sometimes we encounter memory threshold issues while querying data in Appian. Why does this happen, and what are the best practices to avoid it?

16.How can you integrate an external Oracle database or any database with Appian Cloud?

17.You are given two tables: Employee and Department. Each employee is associated with a department through the dept_id column. Write an SQL query to retrieve the number of employees in each department.Ensure that the result includes all departments, even those that currently have no employees.

18.I added new columns to an existing database table, but the CDT is not reflecting these changes. How can you update the CDT to include the new columns?

19.A user uploads documents while submitting Form-1. These documents are stored both in a database table and in an Appian folder. Now, the requirement is to copy the same documents to Form-2 when the user creates it. How would you implement this in Appian?

20.How do you configure a record action in Appian so that it is visible only to specific users? For example, if a Senior Reviewer opens a record as Senior Reviewer, they should only see the 'Manage User' action. How can this be designed?

23.What major challenge did you face in your project, and how did you resolve it?