Hello @atripp
This the Manual Execution Cleanup.

This process is really annoying.

You have no SQL scripts to cleanup the table ?

Hi @atripp
The problem is stil present.
Do you have any magic sql scripts to purge my huge tables ?
Thanks in advance

Hello @atripp

I repaired the index, and it seems to help :)
I let you know what I still have the problem

Best Regards
PhilippeC.

Hello
The SQL Serve is anormally overloaded since release 6.2.22.
One request :
DELETE [Executions]
WHERE [Execution_Id] = @Execution_Id
seems to impact a lot the server

I have seen two big table (7 Go and 12 Go):
dbo.ScopedExecutionLogs / dbo.ScopedExecutionLogEntries

any advice is welcome
Best regards
Philippe

ManualExecutions: 162 K records / 8 Go of data
ScopedExecutionsLogsentries : 1099K records / 1.3 Go ofdata

@philippe-camelio_3885

Thanks @atripp, I made some space using using script based on your SQL and
I succeed to reinstall the service (thanks @rhessinger - cmd console has to be in admin mode).
I purged more logs from BM itself.
Therefore, the dbo.ManualExecutions did not change a lot .

I did not found a way to purge it from BM.

any Sql available ? - I made a test where I truncated the table and it was a very bad idea :)

@philippe-camelio_3885

I have seen the dbo.ManualExecutions is the largest table 8 Go ....
It contains mainly Infrastructure sync info

Can I clear it safely ?

@atripp
Thanks a lot.

I will try this to restore BM access
I had a plan to move to SQL Std, I will do it

Hi
I haven't seen your answer.
I modify the topic as it is a DB problem not related to the upgrade
thanks for the fast reply

I think if I clean the DB, bmservice will work.

Any sql magic command to clean the DB ?

Hello
I upgraded BM to 6.2.20 from 6.2.19 and the service Buildmaster is gone :(
I haven't seen the DB BuildMaster on the SQL Xpress was up to the 10 Gb limit.

any help is welcome

Best Regards

PhilippeC.

You're welcome

Hi @rhessinger
Sorry for the delay

Yes this is exactly what it should be.

Hello

By default, the module from the default asset are not suffixed by Default:: when you select it form the visual editor.
when you use it from a plan located in a different asset, you have the error : Unable to resolve method: *******
One should search in the default asset when the asset is not defined for the module to avoid the pb
or you must add default:: suffixe when you select a module form the UI - I think :-)

Test case:
In the default asset :
Create a module Test

##AH:UseTextMode
module test
{
    Log-Debug Module from Default Asset;
}

In a test asset (in my case it is a Git Repository)
Create a Plan TestPlan
Select Test module from graphic mode

##AH:UseTextMode
call test();

Execution fail

DEBUG: 2020-10-07 20:42:25Z - Job 1675 directly targets 1 server(s) by name.
DEBUG: 2020-10-07 20:42:25Z - Skipping collection run; execute only.
INFO : 2020-10-07 20:42:25Z - Collection run succeeded.
DEBUG: 2020-10-07 20:42:25Z - Beginning execution run...
ERROR: 2020-10-07 20:42:26Z - Unable to resolve method: test
DEBUG: 2020-10-07 20:42:26Z - Cleaning up temporary files on Inedo Agent (v??, VM000037:46336)...

Edit the Plan and add asset suffix to the module (in text mode)

##AH:UseTextMode
call default::test();

Execution succeed

DEBUG: 2020-10-07 20:47:50Z - Job 1676 directly targets 1 server(s) by name.
DEBUG: 2020-10-07 20:47:50Z - Skipping collection run; execute only.
INFO : 2020-10-07 20:47:50Z - Collection run succeeded.
DEBUG: 2020-10-07 20:47:50Z - Beginning execution run...
DEBUG: 2020-10-07 20:47:50Z - Module from Default Asset
INFO : 2020-10-07 20:47:50Z - Execution run succeeded.
DEBUG: 2020-10-07 20:47:50Z - Cleaning up temporary files on Inedo Agent (v??, VM000037:46336)...

Hope this help

OTTER Version 2.2.23 (Build 1)

Best regards
PhilippeC.

@atripp
Good news
Thank you

@rhessinger
Good news thank you

The Invoke-DscRessource allows this.
Ensure-DSC should be improved, if possible. It's been a long time since Otter was updated

Invoke-DscResource -Method Test -Name WindowsFeature -Property @{Name='RSAT-AD-PowerShell'; IncludeAllSubFeature=$true; ensure='Present'} -ModuleName @{ModuleName=’PSDscResources’; ModuleVersion=2.2.0.0’} -Verbose

As enhancement, it would be nice to have a function Ensure-Module in order to manage properly PS Module.

I have done a small set of functions based on PackageManagement but it does not work properly for the Module installation as it does remove the old version.

##AH:UseTextMode
##AH:Description Définition d'un dépôt
module PackageManagementSource<$Nom, $Ensure = present, $SourceLocation, $ProviderName = PowerShellGet, $InstallationPolicy = Untrusted>
{
    Ensure-DscResource
    (
        ConfigurationKey: Name,
        Name: PackageManagementSource,
        Module: PackageManagement,
        Properties: %(Name:$Nom,ProviderName:$ProviderName,SourceLocation:$SourceLocation,InstallationPolicy:$InstallationPolicy,Ensure:$Ensure)
    )
}

##AH:UseTextMode
##AH:Description Installation de modules PS à partir d'un dépôt
module PackageManagement<$Module, $Version, $Source = internal-psm, $Ensure = Present>
{
    log-information Module: $Module - $Version - $Ensure;
    Ensure-DscResource
    (
        ConfigurationKey: Name,
        Name: PackageManagement,
        Module: PackageManagement,
        Properties: %(Name:$Module,RequiredVersion:$Version,Source:$Source,Ensure:$Ensure)
    );
}

note:
There are some prerequisites to have PackageManagement 1.4.7.

Hello

As PS Module version management is a mess, I am looking to call Ensure-DSC with a specific version of a module as it is possible with the Invoke-DscResource unsuccessfully.
Any exemple might helpfull

Thanks in advance

Best Regards

PhilippeC.

Hi @rhessinger
I will be out of office for the next weeks.
I ll make the test when I come back
Best regards
PhilippeC.

Hi Rich
Using the extension Gitlab 1.7.6-RC2, it is working as expected if the Secure Resource is defined at the application level.

Best Regards

Tested with Buildmaster 6.2.14

Hello @rhessinger
Thanks