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 ONE Support launchpad (Login required).

Search for additional results

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