time-clock-circle multiple-users-1 bin-paper-1 smiley-indifferent view-off alert-diamond envelope-letter rating-star network-browser pencil-write ticket-1 button-record headphones-customer-support close synchronize-arrows-1 common-file-stack close-quote arrow-down-2 multiple-circle attachment-1 folder-file-1 disable smiley-indifferent shield-warning love-it smiley-smile-1_1 check-circle-1 time-clock-midnight floppy-disk view smiley-unhappy book-star lock-unlock-1 arrow-right-1 archive smiley-unhappy send-email-1 hierarchy-9 open-quote add-circle-bold search remove-circle cog-1 filter-1 hyperlink-2 analytics-pie-2 flying-insect-honey navigation-menu-horizontal pencil-1 smiley-thrilled check-1 arrow-up-1 lock-2 navigation-menu add layout-module-1 archive arrow-left-1 wench arrow-down-1 multiple-neutral-1 expand-6 close drawer-send alarm-bell-1 social-media-twitter keyboard-arrow-up ticket-1 copy-paste rating-star download-thick-bottom information-circle smiley-sad-1 single-neutral-actions remove-square-1 file-code pencil-1 keyboard-arrow-down smiley-sad-1 cog single-neutral add-circle move-to-top list-bullets expand-6 undo tags-double smiley-happy view-1 messages-bubble-square print-text add-square smiley-happy credit-card-1 envelope-letter diagram-fall-down

Resolving SQL databases plan error 0x0000000a

Behavior

The checkup report may report error 0x0000000a in the result column of a SQL databases type protection plan execution. A second entry for the same plan starting at almost the same time may be present in the checkup report with an OK result. See image.

Further, if your support person initiated a SqlPlanLaunch log file, the SqlPlanLaunch.log may indicate a log truncation error.
2019-03-09 04:11:49,197 [6] DEBUG SqlPlanLaunch [(null)] - Trying to launch SMO Truncate
2019-03-09 04:11:49,213 [6] DEBUG SqlPlanLaunch [(null)] - MinerResultsSuceeded, 
TruncateLogs set to true
2019-03-09 04:11:49,213 [6] ERROR SqlPlanLaunch [(null)] - 
An error occurred while attempting to truncate logs!!!
System.IO.FileNotFoundException: 
Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=11.0.0.0,

Issue

SQL log truncation for databases configured with the full recovery model fails because components required for log truncation are not present on the SQL Server.

Resolution

To resolve the issue install the required items listed below.

Microsoft® System CLR Types for Microsoft® SQL Server® 2012
Microsoft® SQL Server® 2012 Shared Management Objects

Both items are available here: https://www.microsoft.com/en-us/download/details.aspx?id=29065# under the Install Instructions section.