How To Fix HH014 - The specified value is active after an Informix reboot

SAP Error Message - Details

• Message type: E = Error

• Message class: HH - (Long) text for check tool 'infcfgcheck'

• Message number: 014

• Message text: The specified value is active after an Informix reboot

What causes this issue?

Simple warning:
The specified parameter is not set in the ONCONFIG file. Since the
Informix default value for this parameter is different from the value
which is currently set, this default value will become active once the
Informix server has been started up.

System Response

How to fix this error?

To avoid this, edit the file
'$INFORMIXDIR/etc/$ONCONFIG' (as user 'informix').

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message HH014 - The specified value is active after an Informix reboot ?

  The SAP error message HH014, which states "The specified value is active after an Informix reboot," typically occurs in environments where SAP is integrated with an Informix database. This error indicates that a certain value or setting is still active or in use after the Informix database has been restarted, which can lead to inconsistencies or issues in the application.
  Cause:
  
  Active Sessions: The error may arise if there are active sessions or transactions that were not properly closed before the Informix database was rebooted.
  Configuration Issues: There may be configuration settings in the SAP system or Informix database that are not aligned, leading to conflicts after a reboot.
  Database Locks: If there are locks on certain database objects that were not released before the reboot, it can cause this error.
  Inconsistent State: The database may be in an inconsistent state due to improper shutdown or other issues, causing certain values to remain active.
  
  Solution:
  
  Check Active Sessions: Use Informix tools to check for any active sessions or transactions that may be causing the issue. Terminate any unnecessary sessions.
  Review Configuration: Ensure that the configuration settings in both SAP and Informix are correctly set and compatible. This includes checking database connection parameters and settings.
  Release Locks: If there are locks on database objects, try to release them. You may need to use Informix commands to identify and release these locks.
  Database Consistency Check: Run a consistency check on the Informix database to ensure that it is in a stable state. This may involve using Informix utilities to check for corruption or inconsistencies.
  Restart Services: If the issue persists, consider restarting both the Informix database and the SAP application server to clear any lingering states.
  Consult Logs: Check the Informix and SAP logs for any additional error messages or warnings that could provide more context on the issue.
  
  Related Information:
  
  Informix Documentation: Refer to the official Informix documentation for commands and procedures related to session management, locking, and database consistency checks.
  SAP Notes: Check SAP's support portal for any specific notes or patches related to this error message. There may be known issues or updates that address this problem.
  Community Forums: Engage with SAP and Informix community forums for insights from other users who may have encountered similar issues.
  
  If the problem continues after trying the above solutions, it may be beneficial to reach out to SAP support or Informix support for further assistance.