Clarity

Expand all | Collapse all

Load Data Warehouse fails in 5 minutes:  resource busy and acquire with NOWAIT specified or timeout expired

  • 1.  Load Data Warehouse fails in 5 minutes:  resource busy and acquire with NOWAIT specified or timeout expired

    Posted 01-19-2016 12:56 PM

    It does this for different tables as I re-run on failures. This happened on Full load.

     

    ETL Job timeout is 10 hours!

     

    dwh_db_check_ - An error occurred executing this job entry :

    Couldn't execute SQL: TRUNCATE TABLE DWH_FIN_PLAN

     

    [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired



  • 2.  Re: Load Data Warehouse fails in 5 minutes:  resource busy and acquire with NOWAIT specified or timeout expired

    Broadcom Employee
    Posted 01-19-2016 02:09 PM

    Hi Suhas,

     

    This error usually indicates that something (another session) is already using this table, so the SQL statements issued by the Load Data Warehouse job could not be executed.

     

    Please check with your DBA to ensure any queries using PPM_DWH table DWH_FIN_PLAN are stopped, and re-run your job again.

     

    This should resolve your issue. Hope this helps!

     

    Kind Regards

     

    Nika Hadzhikidi
    CA Technologies
    Principal Support Engineer