Debugging the Horizon Database

If you need to debug Day End, Adhoc reports, or the Launcher start up, you can do so using this procedure. The output from this debug is in SQL, so you can decipher the output if you know SQL. Including portions of the output in your problem logs to customer support can be helpful. This procedure is useful for finishing and correcting database problems, not data problems.

You may want to periodically find and delete debug logs as regular system maintenance.

To debug the Horizon database

1 Unless you are debugging the Horizon launcher.exe, you must establish the connection to the server by starting Horizon.
2 At a DOS command line, enter this command:

set hzdebug=dbcommand,dbtime,dbcomment

3 Enter the location and file name of the debug log file.

For example, enter this command:

set hzoutput=c:\horizon74\bug.out

4 Enter the program name and any arguments needed to launcher the program.

For example, enter any of these commands:

Command

Description

deoverdu /d

Starts Day End Overdues.

denotice /d

Starts Day End Notices.

destat /d

Starts the Day End daily statistics processing.

destat /m

Starts the Day End monthly statistics processing.

adhoc

Starts the Adhoc reports.

Note: You can enter this command to display the hzoutput variable’s current setting:

set hzoutput

Possible problem: The command returns the variable’s current setting:

set hzoutput = xxxxx

Note that there is a space on the left side of the “=”. DOS interprets this as set hzouput.

You can enter this command to release (or turn off) the variable:

Set hzoutput

Possible problem: This command returns nothing and “set hzoutput” is not set.

Set hzoutput= xxxxx

Note that there is only one space on the right side of the “=”. DOS interprets this as “set hzoutput=” and deletes the variable.

To turn off debugging

1 At a DOS command line, log in to your Horizon database.
2 Enter this command:

set hzdebug=

3 Enter this command, or close the DOS window:

set hzoutput=

 


© 1998-2017 Sirsi Corporation