E1: 42: TDA: Can a Corrupted Table in Microsoft SQL Server (MS SQL) Be Rebuilt For Sales Table (F49219) Sales Order Detail Tag History? (Doc ID 2889255.1)

Last updated on AUGUST 17, 2022

Applies to:

Goal

The Sales Order Detail Tag records (F49211) are moved to the Sales Order Detail Tag History File (F49219) at Sales Update Update (R42800).
The table F49219 in MS SQL Server is corrupted and shows the below message. Can the table be safely truncated or rebuilt from another table as restoring from backup is not an option since all backups show the same problem with this table?

8954: CHECKTABLE found 0 allocation errors and 2 consistency errors not associated with any single object.
2536: DBCC results for 'PRODDTA.F49219'.
2593: There are 12608621 rows in 2151311 pages for object "PRODDTA.F49219".
8990: CHECKTABLE found 0 allocation errors and 8 consistency errors in table 'PRODDTA.F49219' (object ID 1646680964).
8958: repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (JDE_PRODUCTION.PRODDTA.F49219).
2528: DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Table F49219 in MS Sql Server is corrupted
8990: CHECKTABLE found 0 allocation errors and 8 consistency errors in table 'PRODDTA.F49219' (object ID 1646680964).

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.