BSA: Error while running DatabaseCleanup:delete objects for class:SJobRunOfDeployJob

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BladeLogic Server Automation Suite


    COMPONENT:

    BladeLogic Server Automation Suite


    APPLIES TO:

    BSA 8.9 (Not specifically) where Database cleanup jobs completes with the error "Failed to delete objects for class:SJobRunOfDeployJob" and the appserver contains the error "ORA-01652: unable to extend temp segment by 64 in tablespace TEMP"



    PROBLEM:

    Database cleanup job completes with errors and the error drom the job run log is as below.

    "Failed to delete objects for class:SJobRunOfDeployJob    at com.bladelogic.om.infra.app.service.cleanup.CleanupOperationImpl.hardDeleteObjectsByClass(CleanupOperationImpl.java:630)    at com.bladelogic.om.infra.app.service.cleanup.CleanupOperationImpl.hardDeleteAllObjectsByClass(CleanupOperationImpl.java:506)    at com.bladelogic.om.infra.app.service.cleanup.CleanupOperationImpl.hardDeleteAllTopLevelObjects(CleanupOperationImpl.java:160)    at com.bladelogic.om.infra.app.service.cleanup.CleanupOperationImpl.hardDeleteAllObjects(CleanupOperationImpl.java:96)    at com.bladelogic.om.infra.app.service.cleanup.BaseCleanupServiceImpl.internal_hardDeleteAllObjects(BaseCleanupServiceImpl.java:1621)    at com.bladelogic.om.infra.app.service.cleanup.BaseCleanupServiceImpl.hardDeleteAllObjects(BaseCleanupServiceImpl.java:1563)    at com.bladelogic.om.infra.app.service.cleanup.BaseCleanupServiceImpl.cleanupDatabase(BaseCleanupServiceImpl.java:1494)    at com.bladelogic.om.infra.app.api.factory.DeleteServiceImpl.cleanupDatabase(DeleteServiceImpl.java:517)    at com.bladelogic.om.infra.app.api.DeleteServiceRequestHandlerImpl.cleanupDatabase_28(DeleteServiceRequestHandlerImpl.java:1330)    at com.bladelogic.om.infra.app.api.DeleteServiceRequestHandlerImpl.execute(DeleteServiceRequestHandlerImpl.java:289)    at com.bladelogic.om.infra.app.api.manage.APIMethodInvocationProvider.executeRequest(APIMethodInvocationProvider.java:54)    at com.bladelogic.om.infra.app.api.manage.APIMethodInvocationProvider.invoke(APIMethodInvocationProvider.java:39)    at com.bladelogic.om.infra.app.service.routing.RoutingServiceImpl.invokeMethodLocally(RoutingServiceImpl.java:267)    at com.bladelogic.om.infra.app.service.routing.RoutingServiceImpl.invoke(RoutingServiceImpl.java:210)    at com.bladelogic.om.infra.app.api.manage.APIRequestManager.executeRequest(APIRequestManager.java:31)    at com.bladelogic.om.infra.message.app.frame.APIMessageFrame.service(APIMessageFrame.java:122)    at com.bladelogic.om.infra.mfw.net.ClientWorkerThread.processRequest(ClientWorkerThread.java:394)    at com.bladelogic.om.infra.mfw.net.ClientWorkerThread.processClientRequest(ClientWorkerThread.java:289)    at com.bladelogic.om.infra.mfw.net.ClientWorkerThread.handleClientRequest(ClientWorkerThread.java:189)    at com.bladelogic.om.infra.mfw.net.ClientWorkerThread.execute(ClientWorkerThread.java:108)    at com.bladelogic.om.infra.mfw.net.ClientWorkerThread.execute(ClientWorkerThread.java:34)    at com.bladelogic.om.infra.app.service.thread.BlBlockingThread.run(BlBlockingThread.java:95)"



     


    CAUSE:

    when the error "ORA-01652: unable to extend temp segment by 64 in tablespace TEMP" this means that the BSA database is running out of TEMP space


    SOLUTION:

    When the error  "ORA-01652: unable to extend temp segment by 64 in tablespace TEMP" or "ORA-01652: unable to extend temp segment by 128 in tablespace TEMP" occurs in the appserver logs this means that the BSA database is running out of temp space.

    The resolve the issue. Please request the DBA to increase the TEMP space on the database


    Article Number:

    000131512


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles