Default host is invalid error when running reports


Default host is invalid error when running reports

Issue/Symptom/Question

In the test database, we are receiving the following error running PENTA legacy reports.

"The default host you have set up is not valid. The default host is the name of the server on which the reports will be run. This is setup in the 'Preferences' window of the 'Report Initiation' window."

Applies To

  • Penta for Windows
  • Linux server
  • PENTA Legacy Reports

Resolution/Fix/Answer

This error usually happens when the process SYP105 is not running on the Linux server.

Checking the Status of SYP105

  1. Log in to the Linux server as the ‘penta’ user.
  2. At the command line type in ‘bgrptctl status’, you should see the following if SYP105 is running. The output can vary depending on the number and name of your environments.

    Comand Output
    prod.penta: SYP105 RUNNING
    train.penta: SYP105 RUNNING
    test.penta: SYP105 RUNNING

    If you see the following output, then SYP105 is not running

    prod.penta: SYP105 NOT RUNNING
    train.penta: SYP105 NOT RUNNING
    test.penta: SYP105 NOT RUNNING

Starting SYP105                          

  1. Log in to the Linux server as the ‘penta’ user.
  2. Type in the following command to start SYP105: ‘bgrptctl start’
  3. Type in the command ‘bgrptctl status’ again to find out if SYP105 is running.

If this issue is not resolved, try stopping and starting the SYP105 process

Stopping and starting SYP105

  1. Type 'bgrptctl stop'
  2. Type 'bgrptctl start'

If this issue is not resolved, it could be an issue with the default_host value in the user_preferences table. The default_host value should be set to the name of the Linux Server.

  1. Login to the database using SQL Plus or Golden
  2. The following query will return the value of default_host in the user_preferences table:
    1. select * from user_preferences where key_name = 'default_host'
  3. If the default_host value is incorrect, you can run the following SQL to update the default_host (Replace ruby with the name of your Linux Server)
    1. update user_preferences set pref_text = 'ruby' where key_name = 'default_host'

If this issue is still not resolved, please submit a Service Desk ticket and reference this article.