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

Resolving SQL databases plan error 0x0000000a


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!!!
Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=,


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.


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: under the Install Instructions section.