---
id: change/bcapps/8745
type: change
title: "#8745 Bug 640098: Make Table Information Cache refresh resilient to duplicate table numbers"
summary: The Table Information Cache refresh now aggregates metrics when duplicate table numbers are encountered instead of failing with a duplicate-key error. This makes the Data Administrator page's refresh action resilient to orphaned or renamed SQL tables.
tier: official
language: en
tags:
  - fix
  - main
  - bc30
  - codeunit table information cache impl.
system: development
review:
  state: reviewed
  by: opus
  at: "2026-10-08T02:12:24.818Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-change: 1
  input_hash: 60f6f954ab12d51bca7dab5e01e464525a51d052
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/pull/8745
    title: "microsoft/BCApps#8745: Bug 640098: Make Table Information Cache refresh resilient to duplicate table numbers"
    date: "2026-07-17"
    commit: 60f6f954ab12d51bca7dab5e01e464525a51d052
    t: null
    quote: null
links:
  learn: []
  objects:
    - object/codeunit/8700
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes: []
number: 8745
repo: microsoft/BCApps
source_id: bcapps-prs
url: https://github.com/microsoft/BCApps/pull/8745
kind: pr
base_branch: main
major: "30"
merged_at: "2026-07-17T09:01:11Z"
author: Groenbech96
author_type: User
community_contribution: false
labels:
  - "AL: System Application"
  - "Team: Integrations"
change_class: code
change_kind: fix
behavior_change: true
breaking: false
files:
  count: 1
  additions: 17
  deletions: 1
  al: 1
apps:
  - System Application
objects_touched:
  - key: codeunit/8700
    page: codeunit/8700
    type: codeunit
    id: 8700
    name: Table Information Cache Impl.
    app: System Application
    status: modified
objects_unjoined: []
obsoletions: []
backports: []
fixes_issues: []
work_items:
  - 640098
systems:
  - development
quote: null
joined_against:
  major: "30"
  commit: ecbc028c25dbe83b61313bc566e6c1d41184bb1c
---

# #8745 Bug 640098: Make Table Information Cache refresh resilient to duplicate table numbers

> The Table Information Cache refresh now aggregates metrics when duplicate table numbers are encountered instead of failing with a duplicate-key error. This makes the Data Administrator page's refresh action resilient to orphaned or renamed SQL tables.

[Pull request](https://github.com/microsoft/BCApps/pull/8745) · merged into `main` (BC30) on 2026-07-17 by Groenbech96 · 1 file (+17 -1), 1 AL · fix · tier official · reviewed (checked by Opus)

## What changed

- Fixes the Data Administrator Refresh action failing with a duplicate-key error
- The platform's Table Information table can return several rows with the same Table No. but different table names
- Instead of inserting a duplicate, the refresh now adds No. of Records, Size, Data Size and Index Size into the existing cache row
- The full refresh no longer aborts with NavCSideDuplicateKeyException
- Behaviour changes for users or extensions.

## AL objects touched

- [Codeunit 8700 "Table Information Cache Impl."](../../objects/codeunit/8700.md), System Application: modified

## Context

- Work items: AB#640098
- Labels: AL: System Application, Team: Integrations
- Systems: development

Source: metadata of a merged pull request in microsoft/BCApps (bcapps): title, labels, changed paths and counts, with a summary in our words. No source text and no description beyond one short quote (D10, D61).