Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

TRACE

Optional parameter in PARAM= optional in PARAM sheet                                                                                                                        

Parameter (col A in PARAM)

Mandatory/Optional

Value in col C (example)

Value in col D (example)

Value in col E (example)

Occurrence in PARAM sheet

Comment

FORMS

REPORT

TRACE

Optional parameter in PARAM

Optional parameter in PARAM

TRUE/FALSE

n/a

n/a

1

If parameter or parameter value is missing, then default value is FALSE. If TRUE then the document will be generated in debug mode.

TRACE is a common parameter which can be used as a tool for the template designer and/or for troubleshooting purposes. The parameter should be used for troubleshooting purposes to activate tracing of the SQL-queries created when generating the document. In addition, if the parameter is set as TRUE, then all worksheets in the document (including the hidden worksheets PARAM, PANE sheet etc.), as well as the design area of the template will be visible.

If parameter is TRUE:

  • All hidden worksheets, such as PARAM and PANE, will be visible after generating the document.

  • The design area of the template will be visible after generating the document (column A and row 1).

  • Trace of all SQL-queries towards the database. New trace tables will be created in the database. These tables are unique for each user generating the document.

Access TRACE in Template Design by selecting Parameters > Frequently Used > TRACE > Troubleshooting.

TRUE (checked) or FALSE (unchecked):

TRACE

When generating a document with TRACE set as TRUE, then all worksheets will be visible, as well as the design area of the template. In addition, a new table in the Bizview database will be created where all the run SQL queries can be viewed.

TRACE2

In the database, a new table has been created (or updated if it already existed). The table name will be trc.trc_<user_id>_trace_rows. In this table all run SQL queries can be viewed. To troubleshoot and trace these SQL queries, then copy the queries from the column sql and paste in a new query window.

TRACE3

TRACE4

Published:

TRACE

Optional parameter in PARAM= optional in PARAM sheet                                                                                                                        

Parameter (col A in PARAM)

Mandatory/Optional

Value in col C (example)

Value in col D (example)

Value in col E (example)

Occurrence in PARAM sheet

Comment

FORMS

REPORT

TRACE

Optional parameter in PARAM

Optional parameter in PARAM

TRUE/FALSE

n/a

n/a

1

If parameter or parameter value is missing, then default value is FALSE. If TRUE then the document will be generated in debug mode.

TRACE is a common parameter which can be used as a tool for the template designer and/or for troubleshooting purposes. The parameter should be used for troubleshooting purposes to activate tracing of the SQL-queries created when generating the document. In addition, if the parameter is set as TRUE, then all worksheets in the document (including the hidden worksheets PARAM, PANE sheet etc.), as well as the design area of the template will be visible.

If parameter is TRUE:

  • All hidden worksheets, such as PARAM and PANE, will be visible after generating the document.

  • The design area of the template will be visible after generating the document (column A and row 1).

  • Trace of all SQL-queries towards the database. New trace tables will be created in the database. These tables are unique for each user generating the document.

Access TRACE in Template Design by selecting Parameters > Frequently Used > TRACE > Troubleshooting.

TRUE (checked) or FALSE (unchecked):

TRACE

When generating a document with TRACE set as TRUE, then all worksheets will be visible, as well as the design area of the template. In addition, a new table in the Bizview database will be created where all the run SQL queries can be viewed.

TRACE2

In the database, a new table has been created (or updated if it already existed). The table name will be trc.trc_<user_id>_trace_rows. In this table all run SQL queries can be viewed. To troubleshoot and trace these SQL queries, then copy the queries from the column sql and paste in a new query window.

TRACE3

TRACE4

For an optimal Community experience, Please view on Desktop
Powered by Zendesk