Post reply

Try to create Maintenance plan, get " Cannot find folder "\Maintenance Plans".

  • January 11, 2018 at 7:45 am

    #342363

    I didn't set up the server which I don't think I can redo, so I'll likely fall into a few of these issues.
    -- @@Version;
    Microsoft SQL Server 2014 (SP1-CU9-GDR) (KB3194722) - 12.0.4487.0 (X64)
     Oct  5 2016 19:04:21
     Copyright (c) Microsoft Corporation
     Developer Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

    ===================================

    Exception has been thrown by the target of an invocation. (mscorlib)

    ------------------------------
    Program Location:

       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.GetExistingPackageNames(String serverName, String userName, SqlSecureString securePassword)
       at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.GetNewPackageName(String serverName, String userName, SqlSecureString securePassword)
       at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke()

    ===================================

    Cannot find folder "\Maintenance Plans".
    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Dts.Runtime.Application.GetPackageInfos(String strFolder, String serverName, String serverUserName, String serverPassword)

    ===================================

    Cannot find folder "\Maintenance Plans".
    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetPackageInfos(String bstrPackageFolder, String bstrServerName, String bstrServerUserName, String bstrServerPassword)
       at Microsoft.SqlServer.Dts.Runtime.Application.GetPackageInfos(String strFolder, String serverName, String serverUserName, String serverPassword)

  • January 11, 2018 at 8:15 am

    #1975511

    Suggest you switch from the Maintenance Plans to Ola Hallengren's maintenance scripts, far superior.
    😎

  • January 11, 2018 at 9:19 am

    #1975535

    Permissions? Can you browse to the folder or share? If not does it exists? Personally I replace maintenance plans with SQL agent jobs.

    ...

  • January 11, 2018 at 10:05 am

    #1975544

    ReReplaced - Thursday, January 11, 2018 7:45 AM

    I didn't set up the server which I don't think I can redo, so I'll likely fall into a few of these issues.
    -- @@Version;
    Microsoft SQL Server 2014 (SP1-CU9-GDR) (KB3194722) - 12.0.4487.0 (X64)
     Oct  5 2016 19:04:21
     Copyright (c) Microsoft Corporation
     Developer Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

    ===================================

    Exception has been thrown by the target of an invocation. (mscorlib)

    ------------------------------
    Program Location:

       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.GetExistingPackageNames(String serverName, String userName, SqlSecureString securePassword)
       at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.GetNewPackageName(String serverName, String userName, SqlSecureString securePassword)
       at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke()

    ===================================

    Cannot find folder "\Maintenance Plans".
    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Dts.Runtime.Application.GetPackageInfos(String strFolder, String serverName, String serverUserName, String serverPassword)

    ===================================

    Cannot find folder "\Maintenance Plans".
    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetPackageInfos(String bstrPackageFolder, String bstrServerName, String bstrServerUserName, String bstrServerPassword)
       at Microsoft.SqlServer.Dts.Runtime.Application.GetPackageInfos(String strFolder, String serverName, String serverUserName, String serverPassword)

    I'd first check to see if it exists - you can execute this to see if there is a row with the foldername Maintenance Plans:
    select *
    from msdb.dbo.sysssispackagefolders

    Sue

  • January 11, 2018 at 11:59 am

    #1975588

    Sue_H - Thursday, January 11, 2018 10:05 AM

    ReReplaced - Thursday, January 11, 2018 7:45 AM

    I didn't set up the server which I don't think I can redo, so I'll likely fall into a few of these issues.
    -- @@Version;
    Microsoft SQL Server 2014 (SP1-CU9-GDR) (KB3194722) - 12.0.4487.0 (X64)
     Oct  5 2016 19:04:21
     Copyright (c) Microsoft Corporation
     Developer Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

    ===================================

    Exception has been thrown by the target of an invocation. (mscorlib)

    ------------------------------
    Program Location:

       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.GetExistingPackageNames(String serverName, String userName, SqlSecureString securePassword)
       at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.GetNewPackageName(String serverName, String userName, SqlSecureString securePassword)
       at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke()

    ===================================

    Cannot find folder "\Maintenance Plans".
    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Dts.Runtime.Application.GetPackageInfos(String strFolder, String serverName, String serverUserName, String serverPassword)

    ===================================

    Cannot find folder "\Maintenance Plans".
    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetPackageInfos(String bstrPackageFolder, String bstrServerName, String bstrServerUserName, String bstrServerPassword)
       at Microsoft.SqlServer.Dts.Runtime.Application.GetPackageInfos(String strFolder, String serverName, String serverUserName, String serverPassword)

    I'd first check to see if it exists - you can execute this to see if there is a row with the foldername Maintenance Plans:
    select *
    from msdb.dbo.sysssispackagefolders

    Sue

    Thanks Sue - there is no reference to Maintenance Plans in sysssispackagefolders, just these

    8877FE4B-A938-4A51-84B9-C5BDAD74B0AD    00000000-0000-0000-0000-000000000000    Data Collector
    EBD0A561-215D-4E52-80C3-BE521DE44C8A    8877FE4B-A938-4A51-84B9-C5BDAD74B0AD    Generated
    00000000-0000-0000-0000-000000000000    NULL    
    9EBA0E30-53E1-437C-967B-8C705EEC3B37    00000000-0000-0000-0000-000000000000    RFP

    Is it as simple as adding that folder in (maybe looking at a sister server to match as best I can)?

    And I should have added - My bigger concern: is this is the tip of the iceberg in terms of configuration issues... but I know no one can easily answer that. I am looking at configuration manager soon.

    @HappyGeek Re: permissions  - I didn't even look for the actual folder path, I can hunt and peck for the others, but I'll look.

    @Eirikur Eiriksson Re: Ola Hallengren's set up or @HappyGeeks SQL server agent - I'm looking for centralized backup management which I do realize can be done at least with SQL server agent if not Ola's approach, but neither is simpler, they just offer more flexibility. If I need it, I'll look into Ola's for centralizing efforts. I've just untangled a morass of 14 server backup plans sans documentation from 2005 to 2014 - some using Ola's script, some using variations of SQL server Agent jobs (each setup differently) / .Bat processes / Powershell processes / personal ownership and ownership with most stored in different Folder locations on each server...

    So, Long story short - I want KISS. I want Centralized. Oh, and I want it to work : )

  • January 11, 2018 at 1:00 pm

    #1975605

    ReReplaced - Thursday, January 11, 2018 11:59 AM

    Thanks Sue - there is no reference to Maintenance Plans in sysssispackagefolders, just these

    8877FE4B-A938-4A51-84B9-C5BDAD74B0AD    00000000-0000-0000-0000-000000000000    Data Collector
    EBD0A561-215D-4E52-80C3-BE521DE44C8A    8877FE4B-A938-4A51-84B9-C5BDAD74B0AD    Generated
    00000000-0000-0000-0000-000000000000    NULL    
    9EBA0E30-53E1-437C-967B-8C705EEC3B37    00000000-0000-0000-0000-000000000000    RFP

    Is it as simple as adding that folder in (maybe looking at a sister server to match as best I can)?

    And I should have added - My bigger concern: is this is the tip of the iceberg in terms of configuration issues... but I know no one can easily answer that. I am looking at configuration manager soon.

    @HappyGeek Re: permissions  - I didn't even look for the actual folder path, I can hunt and peck for the others, but I'll look.

    @Eirikur Eiriksson Re: Ola Hallengren's set up or @HappyGeeks SQL server agent - I'm looking for centralized backup management which I do realize can be done at least with SQL server agent if not Ola's approach, but neither is simpler, they just offer more flexibility. If I need it, I'll look into Ola's for centralizing efforts. I've just untangled a morass of 14 server backup plans sans documentation from 2005 to 2014 - some using Ola's script, some using variations of SQL server Agent jobs (each setup differently) / .Bat processes / Powershell processes / personal ownership and ownership with most stored in different Folder locations on each server...

    So, Long story short - I want KISS. I want Centralized. Oh, and I want it to work : )

    That is actually the folder it is looking for - not a file system folder. It's a folder in SSMS under Management. You can look at the stored procedure sp_ssis_addfolder in msdb to use that or figure out the insert. You just pass in the zeros for parent folder like you see on the others - '00000000-0000-0000-0000-000000000000' and then 'Maintenance Plans' for folder name. The folder id is generated using NewID()

    Sue

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply