Skip to main content
mohits1040
New Participant
Mar 6, 2025 10:28 AM UTC
Question

How to identify unmapped Appian records?

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

Participating Frequently
Mar 6, 2025 10:44 AM UTC

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
Inspiring
Mar 6, 2025 10:44 AM UTC

Hello [mention:7b459ae0fabd4f27b33a5ea534cf45c9:e9ed411860ed4f2ba0265705b8793d05] ,

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

karumurua531442
Participating Frequently
Mar 6, 2025 11:00 AM UTC

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
Genius
Mar 6, 2025 1:30 PM UTC

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