SAP Knowledge Base Article - Preview

1735624 - MSSQL: SQL Error 3930 shortly after midnight

Symptom

You recognize that SQL Error 3930 occurs shortly after midnight.

The error can be found in:

  • The syslog (transaction SM21):
    > [Microsoft][SQL Server Native Client 10.0][SQL Server]The
    > current transaction cannot be committed and cannot support
    > operations that write to the log file. Roll back the
    > transaction.
    Database error 3930
  • The developer traces (transaction ST11 / work-directory on operating system level): 
    B  ***LOG BY2=> sql error 3930       performing OPC        [dbds 398]
    B  ***LOG BY0=> [Microsoft][SQL Server Native Client 10.0][SQL Server]
                    The current transaction cannot be committed and cannot support
                    operations that write to the log file. Roll back the transaction.
                    [dbds 398]
    B  ***LOG BY1=> sql error 3930       [dbacds       1496]

 


Read more...

Environment

ABAP-stack SAP systems based on Microsoft SQL Server
SAP Basis Support Package lower than 7.30 SP8.

Keywords

KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.