7595:Operation not allowed: an online archive logging is currently active on <database_name>

Cause:

This is caused by having the online logging already enabled for this particular object.

 

Solution:

Use the following SQL to check online logging is in use:

select

  CreateTimeStamp,

  DatabaseName (VARCHAR(30)),

  TVMName (VARCHAR(30))

from

  DBC.ArchiveLoggingObjsV;

 

CreateTimeStamp

DatabaseName

TVMName

2018-05-25 14:36

DatabaseA

Table1

 

 

This example stops online archive logging on Table1.
LOGGING ONLINE ARCHIVE OFF FOR (DatabaseA.Table1);


This example stops online archive logging on all the tables in the DatabaseA.
LOGGING ONLINE ARCHIVE OFF FOR (DatabaseA);

 

Comments