SAP Knowledge Base Article - Preview

3228632 - Refresh Database is not working - Received Cannot open transaction log file -- No such file or directory - SAP IQ

Symptom

  • Moving a server to a new location. 
  • Same data moving from production (PRD) to Disaster Recovery (DR).
  • There seems to be a problem when trying to rename the transaction log:
     I. 07/22 14:12:19.005317 Starting database "DRIQ" (/DRIQ/data/DRIQ.db) at Fri Jul 22 20xx 14:12
    HOS_MEMMGR: Heap memory tracking is enabled.
    [hos_InMemMsgLog] Using perThreadBufferLength=1048576 bytes...
    Starting database "DRIQ" (/DRIQ/data/DRIQ.db) at Fri Jul 22 20xx 14:12
    I. 07/22 14:12:19.008417 Database recovery in progress
    Database recovery in progress
    I. 07/22 14:12:19.008469     Last checkpoint at Fri Jul 22 20xx 14:06
        Last checkpoint at Fri Jul 22 20xx 14:06
    I. 07/22 14:12:19.008500     Checkpoint log...
        Checkpoint log...
    I. 07/22 14:12:22.603411 UTC time zone offset for "DRIQ" set to -420 minutes
    I. 07/22 14:12:22.603480     Transaction log: /DRIQ/data/tlog1 ...
    I. 07/22 14:12:19. IQ OpenDatabase, checkpointblock: 13105938, recover: 1
    I. 07/22 14:12:20. Using AIO based prefetch manager
    I. 07/22 14:12:21. Using AIO based prefetch manager
    I. 07/22 14:12:22. 140468089861888 [MpxTrace-GFLSHT]-stcxtlib/st_globalFlMgr.cxx:00076 The Diagnostic toggle value for st_globalFlMgr is set to 0
    UTC time zone offset for "DRIQ" set to -420 minutes
        Transaction log: /DRIQ/data/tlog1...
    E. 07/22 14:12:22.604004 Error: Cannot open transaction log file -- No such file or directory
    Error: Cannot open transaction log file -- No such file or directory

E. 07/22 14:12:25.114777 Cannot open transaction log file -- No such file or directory
Cannot open transaction log file -- No such file or directory
I. 07/22 14:12:25.114841 Database server shutdown due to startup error
Database server shutdown due to startup error
07/22 14:12:25.135673 Completing server shutdown


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

KBA , BC-SYB-IQ , Sybase IQ , How To

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.