12 Replies Latest reply on Feb 12, 2015 11:57 AM by Bill Robinson

    Bladelogic Cleanup delete Users and Roles there marked for deletion

    Jens Heilmann

      Hi,

       

      in my Development-Environment (BL 8.5.01.260) is have delete same users an roles manually with the blconsole.

      In the database this users and role a marked with is_deleted=1.

      Now i run  the blcli-command:

       

      Delete - performFullCleanupJob

      Description :

      This command performs a full clean-up job. The clean-up deletes all objects marked for deletion and cleans all unused files from the file server and the temporary file storage area on the Application Server.

      Return type : java.lang.Object

      blcli -r BLAdmins Delete performFullCleanupJob

      this command will skip the class SBLRole and SBLUser.

      No entries are deleted there are marked with is_deleted=1 in the DB-Tables BLUSER and BLROLE .


      Is the any commands to delete users and Roles from the Bladelogic-Database?


      in our Production-Bladelogic we have


      select count (*) from bluser where is_deleted ='1'

      520

      select count (*) from blrole where is_deleted ='1'

      627


      So our DB will be grow and grow, but i can not delete this old entries with a cleanup-job.


      Regards,


      Jens Heilmann

        • 1. Re: Bladelogic Cleanup delete Users and Roles there marked for deletion
          Bill Robinson

          how many users and roles are you thinking of adding and deleting here that you'll really have a problem w/ these tables?  i mean, 500 rows... that's nothing...

           

          this command will skip the class SBLRole and SBLUser.

          -> how do you determine this?  because no rows were deleted or is there some log message ?

           

          can you run 'blcli Delete cleanupDatabase'  and then 'blcli Delete hardDeleteAllSharedObjects true 600' and return the output of those ?  that may show why the roles / users aren't being removed.



          • 2. Re: Bladelogic Cleanup delete Users and Roles there marked for deletion
            Jens Heilmann

            Hi Bill,

             

            It's not about how many users / roles are to be deleted, but the user / Rolen be deleted.

             

            I have bought a product to delete users and roles. The documentation says that the command Delete perfomFullCleanupJob all objects and deletes files that are marked as deleted.

             

            It is this characteristic is not met.

             

            I have executed the commands.


            Here are the results:


            select count (*) from bluser where is_deleted ='1';

            41

            select count (*) from blrole where is_deleted ='1';

            6

            iw0529by% blcli -r BLAdmins Delete cleanupDatabase

            [Thu Jan 22 15:27:07 CET 2015] Executing available patches.

            [Thu Jan 22 15:27:07 CET 2015] Successfully executed available patches.

            [Thu Jan 22 15:27:07 CET 2015] Remaining Duration In Minutes : 239

            [Thu Jan 22 15:27:07 CET 2015] Executing stored procedure: ComplianceResult

            [Thu Jan 22 15:27:07 CET 2015] Finished Executing stored procedure: ComplianceResult

            [Thu Jan 22 15:27:07 CET 2015] Remaining Duration In Minutes : 239

            [Thu Jan 22 15:27:07 CET 2015] Executing stored procedure: SnapshotResult

            [Thu Jan 22 15:27:07 CET 2015] Finished Executing stored procedure: SnapshotResult

            [Thu Jan 22 15:27:07 CET 2015] Remaining Duration In Minutes : 239

            [Thu Jan 22 15:27:07 CET 2015] Executing stored procedure: AuditResult

            [Thu Jan 22 15:27:07 CET 2015] Finished Executing stored procedure: AuditResult

            [Thu Jan 22 15:27:07 CET 2015] Remaining Duration In Minutes : 239

            [Thu Jan 22 15:27:07 CET 2015] Executing stored procedure: JobRunEventHardDelete

            [Thu Jan 22 15:27:07 CET 2015] Finished Executing stored procedure: JobRunEventHardDelete

            [Thu Jan 22 15:27:07 CET 2015] Starting deletion of objects in database.

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SBlfileCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDbdSpecificDiagnosisMeasure

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SSymmetricKey

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDbdResultStatus

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SLoadType

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SMouse

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SBlAssetClassCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SBlAssetClassHierarchy

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDbdParam

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SStatusType

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SADDMConfig

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SInbox

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDotNetAssemblyCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SFileLocation

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: STemplateUpgradeResultInvalidPart

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDiscoveryAction

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SBlPatchSingleUserMode

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDbdTypeData

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SVMwareObjectCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDbdDiagnosisXcutnResult

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SApprovalChangeTiming

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SOsComponent

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SSoftwareDefaultOs

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDepotObjectLocationType

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SPatchConstants

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDepotSoftwareDeb

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SLocale

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SApprovalUrgency

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SHkCleanupProcedure

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDbdLoadDiagnosisMeasureInf

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDbdSpecificDiagnosisParam

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SHkRequireNoDependents

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SARServerDetails

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SOsObjectType

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SBlObjectLock

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SSystemPackageTypePart

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SComponentExceptionMap

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SWinLocaleLangGroup

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SPatchResultStatus

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SConditionResultHierarchy

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SPropertyMetadata

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: STransactionAuditTrail

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SRoleAuth

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SPropertyMetadataJoins

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SExecutionTaskSnapshot

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SPmImageCreationConfig

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDbdSpecificDiagnosisSp

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDefaultRoutingPolicy

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDbdOraclePriv

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SCompEntryResultDetail

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SBlAssetClassLibCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SProvJobRslvdSysPkgCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SJobApprovalConfig

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SGpoSettingCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SHkAllowedClasses

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SPartitionType

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SRbacDeviceCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SOsUserCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SPatchConfigGlobalOptions

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDeviceState

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SNimbusUuidAddress

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SObjectOverflowColAttr

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDayOfWeek

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDbdDbmeasureMeasurePopSp

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SPropertyCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SPatchMasterFilter

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SAtriumOrchestratorConfig

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SAuditGenericAsset

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: STemplateUpgradeResultInvalidRule

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SSCAPJobRuleResultType

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: STransactionIdGen

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SOsGroupCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SBlPatchImpact

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SNimbusMacAddress

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SBlAuthNotification

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SAixUpdateType

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SIconCondition

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SApprovalChangeType

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SApprovalRiskLevel

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDbdMeasurePopErr

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDeviceCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDbdDbobjectName

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SServiceCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SGroupDeviceCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SSoftwareInfoPart

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDbdDiagnosisXcutn

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDbRemediationLog

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SAtriumToBlConfig

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SSoftwareCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SRbacAclPolicyCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SRoleAggAuth

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDbdMeasurePopSp

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SExecutionTaskOverriddenComponentPropMap

            [Thu Jan 22 15:27:07 CET 2015] Deleting top level objects of type : SLdapSyncQuery

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SAuditGenericAssetFolder

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SHkDbTempFileList

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SApprovalImpact

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SAsTimeZone

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: STemplateNameGroup

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SHotfixType

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SAgentState

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SActionEnableCondition

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SSCAPJobResultScoringModelType

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SGpoPolicyCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SHkPreference

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SBl2atrAIEServerConfig

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SWinLangGroup

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: STokenRule

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SRbacJobCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SBlMntWindow

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SSnapshotGenericAssetFolder

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SGpoPolicyDisplayFormat

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: STemplateUpgradeResultInvalidJobPart

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SSoftwareDefault

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SBlAclPolicyAggAuth

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SComplianceRuleGroupResultHierarchy

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SSoftwareInfo

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SMetabaseObjectCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SRoutingRuleRepeater

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SPropertyMetadataPropJoins

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SDbdOraclePrivSpecifDiagSp

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SPatchConfigFile

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SConfigFileObjectValueCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SComplianceRuleGroupHierarchy

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SPmState

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SSCAPJobResultOvalResultTypeEnum

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SBl2atrBSARADBConfig

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SOmSmartGroupMembers

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SKeyboard

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SRegistryObjectCdc

            [Thu Jan 22 15:27:07 CET 2015] Skipping class: SBLModularExponential

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SComObjectCdc

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: STimezone

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SUcsStorageAllocInfo

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SPersistenceType

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SOsComponentGroup

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SBroadcastMessages

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SPatchType

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SConditionHierarchy

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SApplicationServerCodeLock

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SConfigFileObjectCdc

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SAsLocale

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SApplicationServer

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SEventType

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SSystemProperty

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SRoutingRuleAppServer

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SHkFsTempFileList

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SRoutingRuleRemoteHostAuthentication

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SGpoPolicy

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SAtriumOrchestratorModule

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SPmConfiguration

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SBlPatchRebootMode

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SCustomCommand

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SDbdOraclePrivMeasurePopSp

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SDbdDiagnosisXcutnParam

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SGroupComponentCdc

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SDbdDbmeasureName

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SGpoCategory

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SRoutingRuleNetProxy

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SGpo

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SEventLogCdc

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SPmDevice

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SPatchGlobalConfiguration

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SBl2atrVersionInfo

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SSystemInfoObjectCdc

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SApplicationServerActivity

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SOsComponentDependency

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SBl2atrCustomizationData

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SBLRoleAutomationPrincipal

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SGenericAssetCdc

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SDbdDbmeasure

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SCustomizationInfo

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: STemplateUpgradeResultInvalidCondition

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SSchedule

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SBlfileVersionCdc

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SDbdDbobjectType

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SPatchDeviceExcludeList

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SJobPriority

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SExecutionTask

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfVirtualGuestJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfWorkflowJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfBatchJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfAuditJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfDeployJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfDeployJobAttempt

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfDeployJobDryRun

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfDeployJobStaging

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfDeployJobApply

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfDeployJobUndo

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfPolicyUpgradeJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfPluginDistributionJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfComplianceJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfPluginDeregistrationJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfSnapshotJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfBLPackageBuilderJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfFileDeployJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfNSHScriptJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfProvisionJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfUcsProvisionJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfPatchDownloadJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfPatchRMDJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SJobRunOfRpmLinuxPatchAnalysisJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfSolarisPatchAnalysisJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfAixPatchAnalysisJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfWindowsPatchAnalysisJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfRedhatPatchAnalysisJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SJobRunOfDebianPatchAnalysisJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfOtherLinuxPatchAnalysisJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfAgentInstallerJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfVSMDiscoveryJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfSCAPComplianceJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfVMCaptureJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfAtriumToBlSyncJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunVGTemplateEnrollment

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfPctPushJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfVMImportJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfApplicationDiscoveryJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SJobRunOfWindowsImageCaptureJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SJobRunOfLinuxImageCaptureJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SJobRunOfDebianCatalogUpdateJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfDiscoveryJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfRedhatCatalogUpdateJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfAclPushJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfWindowsCatalogUpdateJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfOtherLinuxCatalogUpdateJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfAixCatalogUpdateJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfSolarisCatalogUpdateJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfUpdateServerPropertyJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SJobRunOfRpmLinuxCatalogUpdateJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfSolarisPatchingJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfOtherLinuxPatchingJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfAixPatchingJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SJobRunOfDebianPatchingJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfWindowsPatchingJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SJobRunOfRedhatPatchingJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SJobRunOfRpmLinuxPatchingJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SPolicyUpgradeJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SBLPackageBuilderJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SFileDeployJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SNSHScriptJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SDeployJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SVirtualGuestJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : STemplate

            [Thu Jan 22 15:27:08 CET 2015] 35 entries were marked as deleted. We are deleting 100 per transaction.

            [Thu Jan 22 15:27:08 CET 2015] Starting hard delete for class type: STemplate

            [Thu Jan 22 15:27:08 CET 2015] Successfully deleted objects of class type: STemplate

            [Thu Jan 22 15:27:08 CET 2015] Deleted 0 entries of type STemplate

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SPatchDownloadJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SRedhatPatchingJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SOtherLinuxPatchingJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SSolarisPatchingJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SAixPatchingJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SWindowsPatchingJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SDebianPatchingJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SRpmLinuxPatchingJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SUcsProvisionJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SProvisionJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SAgentInstallerJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SDeployJobAttempt

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SVSMDiscoveryJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SSCAPComplianceJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SXccdfContentFileMap

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SDepotObject

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SAuditJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SComplianceJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SBatchJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SPluginDeregistrationJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SPluginDistributionJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SSnapshotJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SComponent

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SDiscoveryJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SApplicationDiscoveryJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SRpmLinuxPatchAnalysisJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SOtherLinuxPatchAnalysisJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SDebianPatchAnalysisJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SSolarisPatchAnalysisJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SWindowsPatchAnalysisJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SRedhatPatchAnalysisJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SAixPatchAnalysisJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SPatchRemediationJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SDeployJobTemplate

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SBlAclPolicy

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SRoutingPolicy

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SBlAuthProfile

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SApprovalStatus

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SRemoteHostAuthentication

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SApplicationServerModel

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SWindowsImageCaptureJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SLinuxImageCaptureJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SRpmLinuxCatalogUpdateJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SWindowsCatalogUpdateJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SUpdateServerPropertyJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SAixCatalogUpdateJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SPctPushJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SDebianCatalogUpdateJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SRedhatCatalogUpdateJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SVMImportJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SAtriumToBlSyncJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SAclPushJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SVMCaptureJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SVGTemplateEnrollmentJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SOtherLinuxCatalogUpdateJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SSolarisCatalogUpdateJob

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SWorkflowJob

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SRepeaterServer

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SDevice

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: SImplApplicability

            [Thu Jan 22 15:27:08 CET 2015] Skipping class: STokenRuleSet

            [Thu Jan 22 15:27:08 CET 2015] Deleting top level objects of type : SBLGroup

            [Thu Jan 22 15:27:08 CET 2015] 77 entries were marked as deleted. We are deleting 100 per transaction.

            [Thu Jan 22 15:27:08 CET 2015] Starting hard delete for class type: SBLGroup

            [Thu Jan 22 15:27:08 CET 2015] Delete in the range of 2000006 to 2007402

            [Thu Jan 22 15:27:08 CET 2015] Marking child of class 'SBLGroup' for deletion: SBLGroupCondition

            [Thu Jan 22 15:27:08 CET 2015] Update count was : 10

            [Thu Jan 22 15:27:08 CET 2015] Marking child of class 'SBLGroupCondition' for deletion: SCondition

            [Thu Jan 22 15:27:08 CET 2015] Update count was : 10

            [Thu Jan 22 15:27:08 CET 2015] Marking child of class 'SCondition' for deletion: SAssetAttributeCondition

            [Thu Jan 22 15:27:08 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:08 CET 2015] Marking child of class 'SAssetAttributeCondition' for deletion: SBlValue

            [Thu Jan 22 15:27:08 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:08 CET 2015] BLValueObjectDeleter : SKIPPING children of SBlValue for soft delete.

            [Thu Jan 22 15:27:08 CET 2015] Marking child of class 'SAssetAttributeCondition' for deletion: SBlValue

            [Thu Jan 22 15:27:08 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:08 CET 2015] Marking child of class 'SCondition' for deletion: SConditionSubCondition

            [Thu Jan 22 15:27:08 CET 2015] Update count was : 15

            [Thu Jan 22 15:27:08 CET 2015] Marking child of class 'SConditionSubCondition' for deletion: SCondition

            [Thu Jan 22 15:27:08 CET 2015] Update count was : 15

            [Thu Jan 22 15:27:08 CET 2015] Marking child of class 'SCondition' for deletion: SAssetAttributeCondition

            [Thu Jan 22 15:27:08 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:08 CET 2015] Marking child of class 'SCondition' for deletion: SConditionSubCondition

            [Thu Jan 22 15:27:08 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:08 CET 2015] Marking child of class 'SCondition' for deletion: SPropertyCondition

            [Thu Jan 22 15:27:08 CET 2015] Update count was : 18

            [Thu Jan 22 15:27:08 CET 2015] Marking child of class 'SPropertyCondition' for deletion: SBlValue

            [Thu Jan 22 15:27:08 CET 2015] Update count was : 18

            [Thu Jan 22 15:27:08 CET 2015] BLValueObjectDeleter : SKIPPING children of SBlValue for soft delete.

            [Thu Jan 22 15:27:08 CET 2015] Marking child of class 'SPropertyCondition' for deletion: SBlValue

            [Thu Jan 22 15:27:08 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:08 CET 2015] Marking child of class 'SPropertyCondition' for deletion: SBlValue

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SCondition' for deletion: SSimpleCondition

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SSimpleCondition' for deletion: SAssetSelector

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SAssetSelector' for deletion: SAssetSelectorInclude

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SAssetSelector' for deletion: SAssetSelectorAssetAttribute

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SAssetSelector' for deletion: SAssetSelectorPropertyReference

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SAssetSelectorPropertyReference' for deletion: SBlValue

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SAssetSelectorPropertyReference' for deletion: SBlValue

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SAssetSelector' for deletion: SAssetSelectorExclude

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SSimpleCondition' for deletion: SBlValue

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SCondition' for deletion: SSelectorCondition

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SSelectorCondition' for deletion: SBlValue

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SSelectorCondition' for deletion: SBlValue

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SSelectorCondition' for deletion: SAssetSelector

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SCondition' for deletion: SPropertyCondition

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SCondition' for deletion: SSimpleCondition

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SCondition' for deletion: SSelectorCondition

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SBLGroup' for deletion: SBLGroupComponent

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SBLGroup' for deletion: SCatalogUpdateJobAssociation

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Updated 2 file location entries for deletion

            [Thu Jan 22 15:27:09 CET 2015] Updating deletion status for Patch Catalog Update Jobs

            [Thu Jan 22 15:27:09 CET 2015] Updated 0 Patch Catalog Update Jobs.

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SBLGroup' for deletion: SPajobRunCatalogAssoc

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SBLGroup' for deletion: SBlValue

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 77

            [Thu Jan 22 15:27:09 CET 2015] BLValueObjectDeleter : SKIPPING children of SBlValue for soft delete.

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SBLGroup' for deletion: SSmartGroupQuery

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 10

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SSmartGroupQuery' for deletion: SObjectOverflowDetail

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 4

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SSmartGroupQuery' for deletion: SObjectOverflow

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 4

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SBLGroup' for deletion: SBLGroupDevice

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 3

            [Thu Jan 22 15:27:09 CET 2015] Marking child of class 'SBLGroup' for deletion: SPajobCatalogAssociation

            [Thu Jan 22 15:27:09 CET 2015] Update count was : 0

            [Thu Jan 22 15:27:09 CET 2015] We cannot delete SBLGroup in the range of 2000006 to 2007402.

            [Thu Jan 22 15:27:09 CET 2015] We found entries for the following top-level model references:

            [Thu Jan 22 15:27:09 CET 2015] Source SBLGroup[groupId] Target SBLGroup.SBLGroup[parentGroupId]

            [Thu Jan 22 15:27:09 CET 2015] Deleted 0 entries of type SBLGroup

            [Thu Jan 22 15:27:09 CET 2015] Deleting top level objects of type : SBlAssetClass

            [Thu Jan 22 15:27:09 CET 2015] Deleting top level objects of type : SLdapQuery

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SBLUser

            [Thu Jan 22 15:27:09 CET 2015] Deleting top level objects of type : SLdapConnection

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SBLRole

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SBlAclTemplate

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SOperationType

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SOs

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SFileServer

            [Thu Jan 22 15:27:09 CET 2015] Deleting top level objects of type : SAutomationPrincipal

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SAuditTrail

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SBlAuth

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SAuditTrailSettingEnum

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SSystemPackageType

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SSoftwareProperty

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SCompEntryResult

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SPxeBootImage

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SBlAuthType

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SBlAssetClassLibrary

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SNotification

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SNotificationType

            [Thu Jan 22 15:27:09 CET 2015] Deleting top level objects of type : SKeyStore

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SDeviceType

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SPatchConfigFileType

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SBl2atrBlDataSource

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SBl2atrCmdbClass

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SBlAuthEnum

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SRepairOption

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SExecutionProtocol

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SApprovalType

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SFrequencyType

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SDaalPlugin

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SRoutingPolicyType

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SAgentPlatform

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SConfigFileGrammar

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SCharacterEncoding

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SOperator

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SCardinalityOption

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SObjectType

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SBLOption

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SProgressStatus

            [Thu Jan 22 15:27:09 CET 2015] Skipping class: SExitCode

            [Thu Jan 22 15:27:09 CET 2015] Successfully deleted objects from database.

            [Thu Jan 22 15:27:09 CET 2015] Executing available patches.

            [Thu Jan 22 15:27:09 CET 2015] Successfully executed available patches.

            void

            select count (*) from bluser where is_deleted ='1';

            41

            select count (*) from blrole where is_deleted ='1';

            6

              

            iw0529by% blcli -r BLAdmins Delete hardDeleteAllSharedObjects true 600

            [Thu Jan 22 15:31:33 CET 2015] Starting hard delete for class type: SBlValue

            [Thu Jan 22 15:31:33 CET 2015] Range for deletion fromIndex:toIndex:0:95

            [Thu Jan 22 15:31:33 CET 2015] Hard deleting objects of class 'SPropertySetInstanceOverriddenValueMap'

            [Thu Jan 22 15:31:33 CET 2015] Delete count was : 671

            [Thu Jan 22 15:31:33 CET 2015] Hard deleting objects of class 'SPropertySetInstance'

            [Thu Jan 22 15:31:33 CET 2015] Delete count was : 95

            [Thu Jan 22 15:31:33 CET 2015] Hard deleting objects of class 'SBlValue'

            [Thu Jan 22 15:31:33 CET 2015] Delete count was : 95

            [Thu Jan 22 15:31:33 CET 2015] Successfully deleted objects of class type: SBlValue

            [Thu Jan 22 15:31:33 CET 2015] Starting hard delete for class type: SBlAcl

            [Thu Jan 22 15:31:33 CET 2015] Range for deletion fromIndex:toIndex:0:2

            [Thu Jan 22 15:31:33 CET 2015] Hard deleting objects of class 'SBlAclAggAuth'

            [Thu Jan 22 15:31:33 CET 2015] Delete count was : 254

            [Thu Jan 22 15:31:33 CET 2015] Hard deleting objects of class 'SBlAclBlAce'

            [Thu Jan 22 15:31:33 CET 2015] Delete count was : 3

            [Thu Jan 22 15:31:33 CET 2015] Hard deleting objects of class 'SBlAclBlAclPolicy'

            [Thu Jan 22 15:31:33 CET 2015] Delete count was : 0

            [Thu Jan 22 15:31:33 CET 2015] Hard deleting objects of class 'SBlAcl'

            [Thu Jan 22 15:31:33 CET 2015] Delete count was : 2

            [Thu Jan 22 15:31:33 CET 2015] Successfully deleted objects of class type: SBlAcl

            [Thu Jan 22 15:31:35 CET 2015] Starting hard delete for class type: SBlValue

            [Thu Jan 22 15:31:35 CET 2015] Range for deletion fromIndex:toIndex:0:4

            [Thu Jan 22 15:31:35 CET 2015] Hard deleting objects of class 'SPropertySetInstanceOverriddenValueMap'

            [Thu Jan 22 15:31:35 CET 2015] Delete count was : 40

            [Thu Jan 22 15:31:35 CET 2015] Hard deleting objects of class 'SPropertySetInstance'

            [Thu Jan 22 15:31:35 CET 2015] Delete count was : 4

            [Thu Jan 22 15:31:35 CET 2015] Hard deleting objects of class 'SBlValue'

            [Thu Jan 22 15:31:35 CET 2015] Delete count was : 4

            [Thu Jan 22 15:31:35 CET 2015] Successfully deleted objects of class type: SBlValue

              

            select count (*) from bluser where is_deleted ='1';

            41

            select count (*) from blrole where is_deleted ='1';

            6

            iw0529by% blcli -r BLAdmins Delete performFullCleanupJob

            [Thu Jan 22 15:33:22 CET 2015] Starting full cleanup.

            [Thu Jan 22 15:33:22 CET 2015] Executing available patches.

            [Thu Jan 22 15:33:22 CET 2015] Successfully executed available patches.

            [Thu Jan 22 15:33:22 CET 2015] Remaining Duration In Minutes : 240

            [Thu Jan 22 15:33:22 CET 2015] Executing stored procedure: ComplianceResult

            [Thu Jan 22 15:33:22 CET 2015] Finished Executing stored procedure: ComplianceResult

            [Thu Jan 22 15:33:22 CET 2015] Remaining Duration In Minutes : 239

            [Thu Jan 22 15:33:22 CET 2015] Executing stored procedure: SnapshotResult

            [Thu Jan 22 15:33:22 CET 2015] Finished Executing stored procedure: SnapshotResult

            [Thu Jan 22 15:33:22 CET 2015] Remaining Duration In Minutes : 239

            [Thu Jan 22 15:33:22 CET 2015] Executing stored procedure: AuditResult

            [Thu Jan 22 15:33:22 CET 2015] Finished Executing stored procedure: AuditResult

            [Thu Jan 22 15:33:22 CET 2015] Remaining Duration In Minutes : 239

            [Thu Jan 22 15:33:22 CET 2015] Executing stored procedure: JobRunEventHardDelete

            [Thu Jan 22 15:33:22 CET 2015] Finished Executing stored procedure: JobRunEventHardDelete

            [Thu Jan 22 15:33:22 CET 2015] Starting deletion of objects in database.

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBlfileCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdSpecificDiagnosisMeasure

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SSymmetricKey

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdResultStatus

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SLoadType

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SMouse

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBlAssetClassCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBlAssetClassHierarchy

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdParam

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SStatusType

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SADDMConfig

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SInbox

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDotNetAssemblyCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SFileLocation

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: STemplateUpgradeResultInvalidPart

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDiscoveryAction

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBlPatchSingleUserMode

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdTypeData

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SVMwareObjectCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdDiagnosisXcutnResult

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SApprovalChangeTiming

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SOsComponent

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SSoftwareDefaultOs

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDepotObjectLocationType

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPatchConstants

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDepotSoftwareDeb

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SLocale

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SApprovalUrgency

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SHkCleanupProcedure

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdLoadDiagnosisMeasureInf

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdSpecificDiagnosisParam

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SHkRequireNoDependents

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SARServerDetails

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SOsObjectType

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBlObjectLock

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SSystemPackageTypePart

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SComponentExceptionMap

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SWinLocaleLangGroup

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPatchResultStatus

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SConditionResultHierarchy

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPropertyMetadata

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: STransactionAuditTrail

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SRoleAuth

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPropertyMetadataJoins

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SExecutionTaskSnapshot

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPmImageCreationConfig

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdSpecificDiagnosisSp

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDefaultRoutingPolicy

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdOraclePriv

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SCompEntryResultDetail

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBlAssetClassLibCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SProvJobRslvdSysPkgCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SJobApprovalConfig

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SGpoSettingCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SHkAllowedClasses

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPartitionType

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SRbacDeviceCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SOsUserCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPatchConfigGlobalOptions

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDeviceState

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SNimbusUuidAddress

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SObjectOverflowColAttr

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDayOfWeek

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdDbmeasureMeasurePopSp

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPropertyCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPatchMasterFilter

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SAtriumOrchestratorConfig

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SAuditGenericAsset

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: STemplateUpgradeResultInvalidRule

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SSCAPJobRuleResultType

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: STransactionIdGen

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SOsGroupCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBlPatchImpact

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SNimbusMacAddress

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBlAuthNotification

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SAixUpdateType

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SIconCondition

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SApprovalChangeType

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SApprovalRiskLevel

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdMeasurePopErr

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDeviceCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdDbobjectName

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SServiceCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SGroupDeviceCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SSoftwareInfoPart

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdDiagnosisXcutn

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbRemediationLog

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SAtriumToBlConfig

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SSoftwareCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SRbacAclPolicyCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SRoleAggAuth

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdMeasurePopSp

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SExecutionTaskOverriddenComponentPropMap

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SLdapSyncQuery

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SAuditGenericAssetFolder

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SHkDbTempFileList

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SApprovalImpact

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SAsTimeZone

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: STemplateNameGroup

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SHotfixType

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SAgentState

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SActionEnableCondition

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SSCAPJobResultScoringModelType

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SGpoPolicyCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SHkPreference

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBl2atrAIEServerConfig

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SWinLangGroup

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: STokenRule

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SRbacJobCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBlMntWindow

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SSnapshotGenericAssetFolder

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SGpoPolicyDisplayFormat

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: STemplateUpgradeResultInvalidJobPart

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SSoftwareDefault

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBlAclPolicyAggAuth

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SComplianceRuleGroupResultHierarchy

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SSoftwareInfo

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SMetabaseObjectCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SRoutingRuleRepeater

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPropertyMetadataPropJoins

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdOraclePrivSpecifDiagSp

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPatchConfigFile

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SConfigFileObjectValueCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SComplianceRuleGroupHierarchy

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPmState

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SSCAPJobResultOvalResultTypeEnum

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBl2atrBSARADBConfig

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SOmSmartGroupMembers

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SKeyboard

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SRegistryObjectCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBLModularExponential

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SComObjectCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: STimezone

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SUcsStorageAllocInfo

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPersistenceType

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SOsComponentGroup

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBroadcastMessages

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPatchType

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SConditionHierarchy

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SApplicationServerCodeLock

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SConfigFileObjectCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SAsLocale

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SApplicationServer

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SEventType

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SSystemProperty

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SRoutingRuleAppServer

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SHkFsTempFileList

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SRoutingRuleRemoteHostAuthentication

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SGpoPolicy

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SAtriumOrchestratorModule

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPmConfiguration

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBlPatchRebootMode

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SCustomCommand

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdOraclePrivMeasurePopSp

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdDiagnosisXcutnParam

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SGroupComponentCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdDbmeasureName

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SGpoCategory

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SRoutingRuleNetProxy

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SGpo

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SEventLogCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPmDevice

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SPatchGlobalConfiguration

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBl2atrVersionInfo

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SSystemInfoObjectCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SApplicationServerActivity

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SOsComponentDependency

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBl2atrCustomizationData

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBLRoleAutomationPrincipal

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SGenericAssetCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdDbmeasure

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SCustomizationInfo

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: STemplateUpgradeResultInvalidCondition

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SSchedule

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SBlfileVersionCdc

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDbdDbobjectType

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SPatchDeviceExcludeList

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SJobPriority

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SExecutionTask

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfVirtualGuestJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfWorkflowJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfBatchJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfAuditJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfDeployJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfDeployJobAttempt

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfDeployJobDryRun

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfDeployJobStaging

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfDeployJobApply

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfDeployJobUndo

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfPolicyUpgradeJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfPluginDistributionJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfComplianceJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfPluginDeregistrationJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfSnapshotJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfBLPackageBuilderJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfFileDeployJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfNSHScriptJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfProvisionJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfUcsProvisionJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfPatchDownloadJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfPatchRMDJob

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SJobRunOfRpmLinuxPatchAnalysisJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfSolarisPatchAnalysisJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfAixPatchAnalysisJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfWindowsPatchAnalysisJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfRedhatPatchAnalysisJob

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SJobRunOfDebianPatchAnalysisJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfOtherLinuxPatchAnalysisJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfAgentInstallerJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfVSMDiscoveryJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfSCAPComplianceJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfVMCaptureJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfAtriumToBlSyncJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunVGTemplateEnrollment

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfPctPushJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfVMImportJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfApplicationDiscoveryJob

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SJobRunOfWindowsImageCaptureJob

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SJobRunOfLinuxImageCaptureJob

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SJobRunOfDebianCatalogUpdateJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfDiscoveryJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfRedhatCatalogUpdateJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfAclPushJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfWindowsCatalogUpdateJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfOtherLinuxCatalogUpdateJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfAixCatalogUpdateJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfSolarisCatalogUpdateJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfUpdateServerPropertyJob

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SJobRunOfRpmLinuxCatalogUpdateJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfSolarisPatchingJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfOtherLinuxPatchingJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfAixPatchingJob

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SJobRunOfDebianPatchingJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfWindowsPatchingJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SJobRunOfRedhatPatchingJob

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SJobRunOfRpmLinuxPatchingJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SPolicyUpgradeJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SBLPackageBuilderJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SFileDeployJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SNSHScriptJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SDeployJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SVirtualGuestJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : STemplate

            [Thu Jan 22 15:33:22 CET 2015] 35 entries were marked as deleted. We are deleting 100 per transaction.

            [Thu Jan 22 15:33:22 CET 2015] Starting hard delete for class type: STemplate

            [Thu Jan 22 15:33:22 CET 2015] Successfully deleted objects of class type: STemplate

            [Thu Jan 22 15:33:22 CET 2015] Deleted 0 entries of type STemplate

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SPatchDownloadJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SRedhatPatchingJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SOtherLinuxPatchingJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SSolarisPatchingJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SAixPatchingJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SWindowsPatchingJob

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDebianPatchingJob

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SRpmLinuxPatchingJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SUcsProvisionJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SProvisionJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SAgentInstallerJob

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SDeployJobAttempt

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SVSMDiscoveryJob

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SSCAPComplianceJob

            [Thu Jan 22 15:33:22 CET 2015] Skipping class: SXccdfContentFileMap

            [Thu Jan 22 15:33:22 CET 2015] Deleting top level objects of type : SDepotObject

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SAuditJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SComplianceJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SBatchJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SPluginDeregistrationJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SPluginDistributionJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SSnapshotJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SComponent

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SDiscoveryJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SApplicationDiscoveryJob

            [Thu Jan 22 15:33:23 CET 2015] Skipping class: SRpmLinuxPatchAnalysisJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SOtherLinuxPatchAnalysisJob

            [Thu Jan 22 15:33:23 CET 2015] Skipping class: SDebianPatchAnalysisJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SSolarisPatchAnalysisJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SWindowsPatchAnalysisJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SRedhatPatchAnalysisJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SAixPatchAnalysisJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SPatchRemediationJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SDeployJobTemplate

            [Thu Jan 22 15:33:23 CET 2015] Skipping class: SBlAclPolicy

            [Thu Jan 22 15:33:23 CET 2015] Skipping class: SRoutingPolicy

            [Thu Jan 22 15:33:23 CET 2015] Skipping class: SBlAuthProfile

            [Thu Jan 22 15:33:23 CET 2015] Skipping class: SApprovalStatus

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SRemoteHostAuthentication

            [Thu Jan 22 15:33:23 CET 2015] Skipping class: SApplicationServerModel

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SWindowsImageCaptureJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SLinuxImageCaptureJob

            [Thu Jan 22 15:33:23 CET 2015] Skipping class: SRpmLinuxCatalogUpdateJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SWindowsCatalogUpdateJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SUpdateServerPropertyJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SAixCatalogUpdateJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SPctPushJob

            [Thu Jan 22 15:33:23 CET 2015] Skipping class: SDebianCatalogUpdateJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SRedhatCatalogUpdateJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SVMImportJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SAtriumToBlSyncJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SAclPushJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SVMCaptureJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SVGTemplateEnrollmentJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SOtherLinuxCatalogUpdateJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SSolarisCatalogUpdateJob

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SWorkflowJob

            [Thu Jan 22 15:33:23 CET 2015] Skipping class: SRepeaterServer

            [Thu Jan 22 15:33:23 CET 2015] Skipping class: SDevice

            [Thu Jan 22 15:33:23 CET 2015] Skipping class: SImplApplicability

            [Thu Jan 22 15:33:23 CET 2015] Skipping class: STokenRuleSet

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SBLGroup

            [Thu Jan 22 15:33:23 CET 2015] 77 entries were marked as deleted. We are deleting 100 per transaction.

            [Thu Jan 22 15:33:23 CET 2015] Starting hard delete for class type: SBLGroup

            [Thu Jan 22 15:33:23 CET 2015] Delete in the range of 2000006 to 2007402

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SBLGroup' for deletion: SBLGroupCondition

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 10

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SBLGroupCondition' for deletion: SCondition

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 10

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SCondition' for deletion: SAssetAttributeCondition

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SAssetAttributeCondition' for deletion: SBlValue

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] BLValueObjectDeleter : SKIPPING children of SBlValue for soft delete.

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SAssetAttributeCondition' for deletion: SBlValue

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SCondition' for deletion: SConditionSubCondition

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 15

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SConditionSubCondition' for deletion: SCondition

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 15

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SCondition' for deletion: SAssetAttributeCondition

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SCondition' for deletion: SConditionSubCondition

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SCondition' for deletion: SPropertyCondition

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 18

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SPropertyCondition' for deletion: SBlValue

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 18

            [Thu Jan 22 15:33:23 CET 2015] BLValueObjectDeleter : SKIPPING children of SBlValue for soft delete.

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SPropertyCondition' for deletion: SBlValue

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SPropertyCondition' for deletion: SBlValue

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SCondition' for deletion: SSimpleCondition

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SSimpleCondition' for deletion: SAssetSelector

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SAssetSelector' for deletion: SAssetSelectorInclude

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SAssetSelector' for deletion: SAssetSelectorAssetAttribute

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SAssetSelector' for deletion: SAssetSelectorPropertyReference

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SAssetSelectorPropertyReference' for deletion: SBlValue

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SAssetSelectorPropertyReference' for deletion: SBlValue

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SAssetSelector' for deletion: SAssetSelectorExclude

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SSimpleCondition' for deletion: SBlValue

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SCondition' for deletion: SSelectorCondition

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SSelectorCondition' for deletion: SBlValue

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SSelectorCondition' for deletion: SBlValue

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SSelectorCondition' for deletion: SAssetSelector

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SCondition' for deletion: SPropertyCondition

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SCondition' for deletion: SSimpleCondition

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SCondition' for deletion: SSelectorCondition

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SBLGroup' for deletion: SBLGroupComponent

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SBLGroup' for deletion: SCatalogUpdateJobAssociation

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Updated 2 file location entries for deletion

            [Thu Jan 22 15:33:23 CET 2015] Updating deletion status for Patch Catalog Update Jobs

            [Thu Jan 22 15:33:23 CET 2015] Updated 0 Patch Catalog Update Jobs.

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SBLGroup' for deletion: SPajobRunCatalogAssoc

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SBLGroup' for deletion: SBlValue

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 77

            [Thu Jan 22 15:33:23 CET 2015] BLValueObjectDeleter : SKIPPING children of SBlValue for soft delete.

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SBLGroup' for deletion: SSmartGroupQuery

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 10

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SSmartGroupQuery' for deletion: SObjectOverflowDetail

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 4

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SSmartGroupQuery' for deletion: SObjectOverflow

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 4

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SBLGroup' for deletion: SBLGroupDevice

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 3

            [Thu Jan 22 15:33:23 CET 2015] Marking child of class 'SBLGroup' for deletion: SPajobCatalogAssociation

            [Thu Jan 22 15:33:23 CET 2015] Update count was : 0

            [Thu Jan 22 15:33:23 CET 2015] We cannot delete SBLGroup in the range of 2000006 to 2007402.

            [Thu Jan 22 15:33:23 CET 2015] We found entries for the following top-level model references:

            [Thu Jan 22 15:33:23 CET 2015] Source SBLGroup[groupId] Target SBLGroup.SBLGroup[parentGroupId]

            [Thu Jan 22 15:33:23 CET 2015] Deleted 0 entries of type SBLGroup

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SBlAssetClass

            [Thu Jan 22 15:33:23 CET 2015] Deleting top level objects of type : SLdapQuery

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SBLUser

            [Thu Jan 22 15:33:24 CET 2015] Deleting top level objects of type : SLdapConnection

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SBLRole

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SBlAclTemplate

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SOperationType

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SOs

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SFileServer

            [Thu Jan 22 15:33:24 CET 2015] Deleting top level objects of type : SAutomationPrincipal

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SAuditTrail

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SBlAuth

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SAuditTrailSettingEnum

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SSystemPackageType

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SSoftwareProperty

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SCompEntryResult

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SPxeBootImage

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SBlAuthType

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SBlAssetClassLibrary

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SNotification

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SNotificationType

            [Thu Jan 22 15:33:24 CET 2015] Deleting top level objects of type : SKeyStore

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SDeviceType

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SPatchConfigFileType

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SBl2atrBlDataSource

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SBl2atrCmdbClass

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SBlAuthEnum

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SRepairOption

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SExecutionProtocol

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SApprovalType

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SFrequencyType

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SDaalPlugin

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SRoutingPolicyType

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SAgentPlatform

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SConfigFileGrammar

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SCharacterEncoding

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SOperator

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SCardinalityOption

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SObjectType

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SBLOption

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SProgressStatus

            [Thu Jan 22 15:33:24 CET 2015] Skipping class: SExitCode

            [Thu Jan 22 15:33:24 CET 2015] Successfully deleted objects from database.

            [Thu Jan 22 15:33:24 CET 2015] Executing available patches.

            [Thu Jan 22 15:33:24 CET 2015] Successfully executed available patches.

            [Thu Jan 22 15:33:24 CET 2015] Starting deletion of files from file server.

            [Thu Jan 22 15:33:24 CET 2015] Starting to delete files marked for deletion.

            [Thu Jan 22 15:33:24 CET 2015] Successfully deleted files marked for deletion.

            [Thu Jan 22 15:33:24 CET 2015] Starting to remove empty directories from appserver.

            [Thu Jan 22 15:33:24 CET 2015] Successfully removed empty directories from appserver.

            [Thu Jan 22 15:33:24 CET 2015] Starting to remove empty directories from file server.

            [Thu Jan 22 15:33:24 CET 2015] Cleaning directory : //bl_fileserver/opt/bmc/BladeLogic/8.5/bl_fileserver/Content

            [Thu Jan 22 15:33:24 CET 2015] Cleaning directory : //bl_fileserver/opt/bmc/BladeLogic/8.5/bl_fileserver/extended_objects

            [Thu Jan 22 15:33:24 CET 2015] Cleaning directory : //bl_fileserver/opt/bmc/BladeLogic/8.5/bl_fileserver/tmp

            [Thu Jan 22 15:33:24 CET 2015] Cleaning directory : //bl_fileserver/opt/bmc/BladeLogic/8.5/bl_fileserver/grammars

            [Thu Jan 22 15:33:24 CET 2015] Cleaning directory : //bl_fileserver/opt/bmc/BladeLogic/8.5/bl_fileserver/blpackages

            [Thu Jan 22 15:33:29 CET 2015] Cleaning directory : //bl_fileserver/opt/bmc/BladeLogic/8.5/bl_fileserver/patch

            [Thu Jan 22 15:33:33 CET 2015] Cleaning directory : //bl_fileserver/opt/bmc/BladeLogic/8.5/bl_fileserver/PB-CEIL-MOM-74240.0.2.7-windowsnt-x86.zip

            [Thu Jan 22 15:33:33 CET 2015] Cleaning directory : //bl_fileserver/opt/bmc/BladeLogic/8.5/bl_fileserver/blassetclasses

            [Thu Jan 22 15:33:37 CET 2015] Cleaning directory : //bl_fileserver/opt/bmc/BladeLogic/8.5/bl_fileserver/scripts

            [Thu Jan 22 15:33:37 CET 2015] Cleaning directory : //bl_fileserver/opt/bmc/BladeLogic/8.5/bl_fileserver/installables

            [Thu Jan 22 15:33:37 CET 2015] Cleaning directory : //bl_fileserver/opt/bmc/BladeLogic/8.5/bl_fileserver/imported

            [Thu Jan 22 15:33:37 CET 2015] Cleaning directory : //bl_fileserver/opt/bmc/BladeLogic/8.5/bl_fileserver/PB-CEIL-MOM-74240.0.2.7-windowsnt-x86-config

            [Thu Jan 22 15:33:37 CET 2015] Cleaning directory : //bl_fileserver/opt/bmc/BladeLogic/8.5/bl_fileserver/depotfiles

            [Thu Jan 22 15:33:37 CET 2015] Cleaning directory : //bl_fileserver/opt/bmc/BladeLogic/8.5/bl_fileserver/PB-CEIL-MOM-74240.0.2.7-windowsnt-x86-setup.bat

            [Thu Jan 22 15:33:37 CET 2015] Successfully removed empty directories from file server.

            [Thu Jan 22 15:33:37 CET 2015] Starting to remove tmp FileDeployJob directories from file server.

            [Thu Jan 22 15:33:37 CET 2015] Starting to remove tmp SCAP Compliance Job directories from file server.

            [Thu Jan 22 15:33:37 CET 2015] Starting to remove temporary BLPackage directories from file server tmp.

            [Thu Jan 22 15:33:37 CET 2015] Successfully deleted files from file server.

            [Thu Jan 22 15:33:37 CET 2015] Successfully finished full cleanup.

            void

            select count (*) from bluser where is_deleted ='1';

            41

            select count (*) from blrole where is_deleted ='1';

            6

              

            No user and roles are deleted.

             

            • 3. Re: Bladelogic Cleanup delete Users and Roles there marked for deletion
              Bill Robinson

              can you run:

               

              blasadmin show cleanup databasecleanupfilterenabled

              ?

               

              there are a number of object types that are apparently not a part of cleanup by default and that's likely the issue.  i'm not sure what the implications of setting the filter to false would be so let me find that out...

              • 4. Re: Bladelogic Cleanup delete Users and Roles there marked for deletion
                Jens Heilmann

                Hi Bill,

                 

                ./blasadmin -s default sh cleanup all

                 

                blasadmin now running against deployment: default
                [Cleanup]
                AutoGeneratedRetentionTime:5
                DatabaseCleanupFilterEnabled:true
                DefaultDatabaseCleanupDurationInMin:240
                DefaultFileServerCleanupDurationInMin:240
                DependencyGraphMaximumNodeCount:500
                EnableRetentionPolicy:true
                GroupsMustBeEmpty:false
                MaxObjectsPurgedPerTransaction:100
                SkipDependantAccessChecksOnServerDecomm:

                 

                I have not found information about this item "DatabaseCleanupFilterEnabled" on docs.bmc.com.

                This is the original entry. I have changed nothing.

                • 5. Re: Bladelogic Cleanup delete Users and Roles there marked for deletion
                  Bill Robinson

                  yep, it’s set to true by default.  let me see why we are excluding some objects from cleanup… if you want you can open a support ticket to track.

                  • 6. Re: Bladelogic Cleanup delete Users and Roles there marked for deletion
                    Jens Heilmann

                    Hi Bill,

                     

                    I have opened a call at BMC support. I am still waiting for the ticket ID.

                    regards,

                    Jens

                    • 7. Re: Bladelogic Cleanup delete Users and Roles there marked for deletion
                      Jens Heilmann

                      Hi Bill,

                       

                      the Support-Ticket is

                      ISS04417155.

                       

                      In my test environment i changed the DatabaseCleanupFilterEnabled to false.

                      Now, the blcli Command will delete the entries but do not delete.

                       

                      blcli -r BLAdmins Delete performFullCleanupJob
                      [Fri Jan 23 10:44:33 CET 2015] Starting full cleanup.
                      [Fri Jan 23 10:44:33 CET 2015] Executing available patches.
                      [Fri Jan 23 10:44:33 CET 2015] Successfully executed available patches.
                      [Fri Jan 23 10:44:33 CET 2015] Remaining Duration In Minutes : 239
                      [Fri Jan 23 10:44:33 CET 2015] Executing stored procedure: ComplianceResult
                      [Fri Jan 23 10:44:33 CET 2015] Finished Executing stored procedure: ComplianceResult
                      [Fri Jan 23 10:44:33 CET 2015] Remaining Duration In Minutes : 239
                      [Fri Jan 23 10:44:33 CET 2015] Executing stored procedure: SnapshotResult
                      [Fri Jan 23 10:44:33 CET 2015] Finished Executing stored procedure: SnapshotResult

                      snipp

                      [Fri Jan 23 10:44:34 CET 2015] Deleting top level objects of type : STemplate
                      [Fri Jan 23 10:44:34 CET 2015] 35 entries were marked as deleted. We are deleting 100 per transaction.
                      [Fri Jan 23 10:44:34 CET 2015] Starting hard delete for class type: STemplate
                      [Fri Jan 23 10:44:34 CET 2015] Successfully deleted objects of class type: STemplate
                      [Fri Jan 23 10:44:34 CET 2015] Deleted 0 entries of type STemplate

                      snipp

                      [Fri Jan 23 10:44:35 CET 2015] Deleting top level objects of type : SBlAclPolicy
                      [Fri Jan 23 10:44:35 CET 2015] 10 entries were marked as deleted. We are deleting 100 per transaction.
                      [Fri Jan 23 10:44:35 CET 2015] Starting hard delete for class type: SBlAclPolicy
                      [Fri Jan 23 10:44:35 CET 2015] Successfully deleted objects of class type: SBlAclPolicy
                      [Fri Jan 23 10:44:35 CET 2015] Deleted 0 entries of type SBlAclPolicy

                      snipp

                      [Fri Jan 23 10:44:35 CET 2015] 41 entries were marked as deleted. We are deleting 100 per transaction.
                      [Fri Jan 23 10:44:35 CET 2015] Starting hard delete for class type: SBLUser
                      [Fri Jan 23 10:44:35 CET 2015] Successfully deleted objects of class type: SBLUser
                      [Fri Jan 23 10:44:35 CET 2015] Deleted 0 entries of type SBLUser

                      snipp

                      [Fri Jan 23 10:44:35 CET 2015] Deleting top level objects of type : SBLRole
                      [Fri Jan 23 10:44:35 CET 2015] 6 entries were marked as deleted. We are deleting 100 per transaction.
                      [Fri Jan 23 10:44:35 CET 2015] Starting hard delete for class type: SBLRole
                      [Fri Jan 23 10:44:35 CET 2015] Successfully deleted objects of class type: SBLRole
                      [Fri Jan 23 10:44:35 CET 2015] Deleted 0 entries of type SBLRole

                       

                      I'am not happy.

                      Regards,

                       

                      Jens

                      • 8. Re: Bladelogic Cleanup delete Users and Roles there marked for deletion
                        Bill Robinson

                        the short answer is that there are a number of object types that must be skipped because of the dependency relationships. eg, a role is created and then creates a bunch of objects.  we can soft delete the role, but if we hard delete it, the relationship is broken for the objects it created, modified, etc.  would we show just <Deleted Row> in the 'ROLE_CREATED' field on these objects ?  or in the audit trail ?

                        • 9. Re: Bladelogic Cleanup delete Users and Roles there marked for deletion
                          Jens Heilmann

                          Hi Bill,

                           

                          You are right. A deletion of users and roles from the database may not be possible.

                          This leads to inconsistencies !!

                          Which values should have the properties of objects that were created by the role / user?

                          I come to this realization with a little thought.

                          The documentation should also be adjusted.

                          Thank you for your Support.


                          Regards,


                          Jens

                          • 10. Re: Bladelogic Cleanup delete Users and Roles there marked for deletion
                            Bill Robinson

                            we updated the docs here:

                            https://docs.bmc.com/docs/display/public/bsa85/Understanding+database+cleanup

                             

                            Certain objects are not deleted due to potential object dependencies. The cleanup process deletes all top-level model objects of the classes listed in the hk_allowed_classes database table, as well as all their child classes (which are not listed in this table). BMC recommends that you do NOT modify the contents of the hk_allowed_classes table.

                            • 11. Re: Bladelogic Cleanup delete Users and Roles there marked for deletion
                              Jens Heilmann

                              Hi Bill,

                               

                              here are the answer from the BL-Support:

                               

                              To delete any table data we add that in the hk_allowed_classes.

                              However we do not delete the data for user and roles in BSA.

                              The users and role cannot be deleted however they will remain as soft deleted.

                               

                              So, there is no way the delete (remove) Users and Roles from the Database. Deleted users and Roles will be flaged with is-deleted=1 only.

                               

                              Regards,

                               

                              Jens Heilmann

                              • 12. Re: Bladelogic Cleanup delete Users and Roles there marked for deletion
                                Bill Robinson

                                It should be made clear though that we don’t support users adding to that table.  what the tables ships w/ is what we support.  there are some objects we don’t delete due to dependencies and such and ideally these are object types that don’t consume a lot of db space.