Post-installation inbox/outbox health check

To ensure inbox/outbox (Oracle AQ) integrity between Mobile Maintenance for Aviation and Maintenix after installation or database changes, you can run a script. This script generates a command-line summary, followed by an HTML-based SQL report that captures the statistics of all queues used in your environment.

Run the post-installation inbox/outbox health check

1. Go to the Maintenix installation folder and navigate to the install folder.

2. Open the build.properties file using a text editor, and provide the following information with regard to your Oracle database installation:

   a. Host

   b. Port

   c. Service

   d. System username

   e. System password

   

3. Save the build.properties file.

4. Double-click the aq-healthcheck.bat (Windows) or aq-healthcheck.sh (Linux) file to execute the script.

5. Review the report summary on the command line and press any key to close the command line window.

6. Return to the install folder and review the report in the SRDC_AQ_HEALTHCHECK_IFSCDB_CDB_YES_<Timestamp>.htm file.

Troubleshooting common error scenarios

Scenario	Error	Resolution
The queue is disabled while consuming messages.	ORA-25207: Enqueue failed, queue is disabled from enqueueing.	Start the disabled queue using the dbms_aqadm.start_queue command. For more information about the START_QUEUE procedure, see Oracle documentation.
The database is unplugged and plugged in while consuming messages.	ORA-01014: Oracle shutdown in progress.	Query the queue table and verify that all messages have been dequeued after plugging in the database.

For more information about these errors, refer the SCHEDULER JOB LAST RUN DETAILS table in the report.