2271710 - Temp_extract options can overwrite critical database files - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2271710 - Temp_extract options can overwrite critical database files - SAP IQ

Symptom

  • TEMP_EXTRACT option if used incorrectly can result in overwriting the database file or any other files owned by the user running the database.
    This could end up in database corruption and database files being invalid.

  • The error one gets is something like :
    E. 01/07 13:50:00. Fatal error:  database error
    terminate called after throwing an instance of 'DBException'
      what():  Fatal error:  database error

  • After the above error, if we start the database then we get the following error:
    E. 01/07 13:52:17. iqdemo.db is not a valid database file
    I. 01/07 13:52:17. Database server shutdown due to startup error
    I. 01/07 13:52:18. Database server stopped at Thu Jan 07 2016 13:52
    DBSPAWN ERROR:  -84
    Specified database is invalid
    -e
    iqdemo.db is not a valid database file
    Server failed to start

Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 15.4

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

Sybase IQ ; stacktrace ; stacktrc ; signal ; corruption ; , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.