2510968 - "[file] is an invalid transaction log" when starting SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2510968 - "[file] is an invalid transaction log" when starting SAP IQ

Symptom

Upon starting an SAP IQ 15.x or 16.x database, the following error occurs:

I. 07/27 14:41:58. Starting database "mydb" (/usr/local/sybase16/IQ-16_0/mydb.db) at Thu Jul 27 2017 14:41
I. 07/27 14:41:58. Database recovery in progress
I. 07/27 14:41:58. Last checkpoint at Thu Jul 27 2017 14:26
I. 07/27 14:41:58. Checkpoint log...
I. 07/27 14:42:03. Transaction log: /usr/local/sybase16/IQ-16_0/mydb.log
E. 07/27 14:42:03. Error: Cannot open transaction log file -- /usr/local/sybase16/IQ-16_0/mydb.log is an invalid transaction log
E. 07/27 14:42:04. Cannot open transaction log file -- /usr/local/sybase16/IQ-16_0/mydb.log is an invalid transaction log
I. 07/27 14:42:04. Database server shutdown due to startup error
I. 07/27 14:42:06. Database server stopped at Thu Jul 27 2017 14:42

The error often occurs after restarting the SAP IQ server after the filesystem containing SAP IQ files has filled up.


Read more...

Environment

  • SAP IQ 16.1
  • SAP IQ 16.0
  • SAP IQ 15.4
  • SAP Sybase IQ 15.2

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

KBA , BC-SYB-IQ , Sybase IQ , 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.