cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Highlighted
Product Manager
Product Manager

Re: Corruption in APM_ApplicationTemplate table.

Jump to solution

stevenstadel  wrote:

Hello Serena,

Our DBAs did see this KB as well. It didn't apply in our case because we were already beyond the CU level mentioned and the APM_ApplicationTemplate Table only had 850 records in it, less than the > 4000 mentioned in the article.

For testing purposes, we did set up an environment with absolute latest SQL 2016 SP2 CU 10, loaded the Orion environment from before the upgrade, and still had the corruption.

One other suggestion from the team is that if you still have this corruption present on your test environment run the following:

exec sp_tableoption 'dbo.APM_ExternalSetting', 'large value types out of row', '1'

exec sp_tableoption 'dbo.APM_ApplicationTemplate', 'large value types out of row', '1'

exec sp_tableoption 'dbo.APM_ComponentDefinition', 'large value types out of row', '1'

0 Kudos
Highlighted
Level 13

Re: Corruption in APM_ApplicationTemplate table.

Jump to solution

Thank you for the update! We have blown away that environment, unfortunately.

One suggestion I have is to add in a DBCC CHECKTable against the whole database as part of an upgrade process to identify potential issues before a sign off that the upgrade was successful. We will be adding this to our upgrades moving forward. Not sure of the ramifications of adding it to the wizard (It can take some time depending on the DB size) but thought I'd make the suggestion.

Level 11

Re: Corruption in APM_ApplicationTemplate table.

Jump to solution

FYI, an article about this issue was added to the Success Center​, Resolve inconsistencies in SAM SQL tables related to a known Microsoft issue that causes DBCC CHECKTABLE errors.

View solution in original post