Procedure for Removing and Adding AI Center by Dropping Database Tables

Unable to deploy Data labeled, stays in a Deploying loop and never turns to available.

Description: This knowledge-based article provides a comprehensive guide on removing and adding the AI Center in UiPath by dropping database tables. This process is beneficial when encountering issues related to stuck metadata in the database tables.

Steps to Remove and Re-add AI Center in UiPath

  1. Log into ArgoCD
  2. Navigate to UiPath Tile
    • Access App Details Click on App Details > Parameters > Edit
      • Disable AI Center Replace AI Center: true with AI Center: false
1.PNG

This action will remove AI Center

  • Log into SQL Server
  • Run the Following Queries
    • Replace database_name with the AI Center database name in the queries below:


SQL

ALTER DATABASE database_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE; DROP DATABASE database_name;

  1. Repeat Steps 1-2
    • Replace AI Center: false with Ai Center: true
  2. Sync UiPath and Fabric Installer


Enable AI Center for the Tenant Again

  1. Log into Tenant as Admin User
  2. Navigate to Services Go to Admin and click on Services
2.PNG
  1. Remove AI Center Remove AI Center by clicking the three dots on the AI Center tile
3PNG.PNG
  1. Re-add AI Center Click on Add the Service > AI Center again.

Note: These steps involve database operations that can lead to data loss. Always ensure to have a backup and proceed with caution. If unsure, consult with your database administrator or a professional. Additionally, the database schema might change with respect to version. Check with UiPath support, if unsure of the same.