Automic Continuous Delivery Automation

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

ERROR CODU00029108 SQL_ERROR Database handles DB-HENV: 43ca270 DB-HDBC: 43c1f00

  • 1.  ERROR CODU00029108 SQL_ERROR Database handles DB-HENV: 43ca270 DB-HDBC: 43c1f00

    Posted Dec 18, 2020 09:17 AM

    Hi team,

    We are having a frequent error in connection with the database server, this error seems to have been reported in other cases in the community without response like this

    https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=787604 

    We have the following error trace

    ----------------------------------------------------------

    20201210/035058.191 - U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.
    20201210/035058.191 - U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 43ca6d0  DB-HDBC: 43c1f00
    20201210/035058.191 - U00003591 UCUDB - DB error info: OPC: 'SQLExecDirect' Return code: 'ERROR'
    20201210/035058.191 - U00003592 UCUDB - Status: '42000' Native error: '9002' Msg: 'The transaction log for database 'AUTOMICAE' is full due to 'LOG_BACKUP'.'
    20201210/035058.191 - U00003536 UCUDB: FATAL DATA BASE ERROR: Re-connection will be attempted in 10 seconds.
    20201210/035058.206 - U00003590 UCUDB - DB error: 'SQLDriverConnect', 'SUCC+INF', '01000', 'Changed database context to 'AUTOMICAE'.'
    20201210/035058.206 - U00003592 UCUDB - Status: '01000' Native error: '5701' Msg: 'Changed database context to 'AUTOMICAE'.'
    20201210/035058.206 - U00003590 UCUDB - DB error: 'SQLDriverConnect', 'SUCC+INF', '01000', 'Changed language setting to us_english.'
    20201210/035058.206 - U00003592 UCUDB - Status: '01000' Native error: '5703' Msg: 'Changed language setting to us_english.'
    20201210/035058.206 - U00003538 UCUDB: Re-connection to database successful. Processing will continue.
    20201210/035100.113 - U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.
    20201210/035100.113 - U00003594 UCUDB Ret: '6' opcode: 'INSR' SQL Stmnt: 'INSERT INTO MQ1DWP (MQDWP_System, MQDWP_CAddr, MQDWP_CSRName, MQDWP_CAcv, MQDWP_BAddr, MQDWP_BSRName, MQDWP_BAcv, MQDWP_FAddr, MQDWP_LogAddr, MQDWP_PhysAddr, MQDWP_BTable, MQDWP_SchedTime, MQDWP_Status, MQDWP_Priority, MQDWP_DRole, MQDWP_LAddr, MQDWP_Len, MQDWP_Msg) VALUES (?, ?, ?, ?, ?, NULL, ?, ?, ?, ?, ?, convert(datetime,convert(varchar(max),getutcdate(),20),20), ?, ?, NULL, NULL, ?, ?)'

    -----------------------------------------------------------

    This error is affecting the access to the AWI because no connection is being generated between the AE engine and the database.

    Could you help us verify what might be going on?

    many thanks



    ------------------------------
    Computer Engineer
    N.A
    ------------------------------


  • 2.  RE: ERROR CODU00029108 SQL_ERROR Database handles DB-HENV: 43ca270 DB-HDBC: 43c1f00

    Broadcom Employee
    Posted Jan 11, 2021 09:32 AM

    Hi @Johnny andrey

    did you already talked to your database admins to fix the reported error 9002?

    This might help https://docs.microsoft.com/en-us/sql/relational-databases/logs/troubleshoot-a-full-transaction-log-sql-server-error-9002?view=sql-server-ver15​



    ------------------------------
    Engineering Program Manager
    Broadcom
    ------------------------------

    Original Message