Skip to main content
mohits1040
mohits1040
New Participant
March 6, 2025
Question

How to identify unmapped Appian records?

  • March 6, 2025
  • 4 replies
  • 2 views

Hi team,
Scenario - There are many table for our application and all of these tables have there respective Appian records. Now, if someone adds unique key constraint to any of the column on any table then we also need to re-map column on the respective records.

Ask - Is there any direct way to generate a summary report to fetch all the records whose mapping of columns is breaking/ where we need to remap the columns in our record.

4 replies

V
vyshnavin653512
Participating Frequently
March 6, 2025

Hi [mention:7b459ae0fabd4f27b33a5ea534cf45c9:e9ed411860ed4f2ba0265705b8793d05] 

I think there is no direct feature that automatically generates a summary report showing all Appian Records whose mappings have broken due to database changes. we might need to check for issues in other ways—such as reviewing error logs or monitoring when a record is queried

konduruc733182
konduruc733182
Inspiring
March 6, 2025

Hello [mention:7b459ae0fabd4f27b33a5ea534cf45c9:e9ed411860ed4f2ba0265705b8793d05] ,

No, there is no direct way to generate such a summary report automatically.

karumurua531442
karumurua531442
Participating Frequently
March 6, 2025

Hi [mention:7b459ae0fabd4f27b33a5ea534cf45c9:e9ed411860ed4f2ba0265705b8793d05:label=mohits1040%2C]there is no such way provided in Appian, unless there are any broken mappings due to database schema changes, there might be some sync failures you will be able to see in sync history if you are using sync records

mathieud0001
mathieud0001
Brainy
March 6, 2025

This is unfortunately not possible. But would be a nice feature to add.

    Terms & ConditionsAccessibility statement