Working with log files in Infor Spreadsheet Designer

Infor Spreadsheet Designer writes logs in multiple small log files instead of a single large log file. The maximum file size is 100 MB.

  1. In Infor Spreadsheet Designer, navigate to Infor > About.
  2. Click View Log Dir.
    All log files are stored there. These files have a base file name of Lawson.SpreadsheetDesigner.log.

Time statistics logging

Time statistics log data lets you check the server and client processing time for Query and Upload, and compute total processing time and log total number of records processed. This can be helpful when troubleshooting performance issues.

The following logging data is included for queries:

Field Description
Start of Log Starting Query Refresh for <Data Area>: <Business Class>

Indicates the start time of the statistics log for a particular query, and the data area and business class of the query
Details per page (note that the number pf pages depends on your Query Page Size setting) A per page list of the time consumed by the Landmark server and the ISD application.
  • Records per page - number of records processed of a certain page
  • Server Time - time consumed by the Landmark server-side to process the query
  • Client Time - time consumed by ISD application
Page Sheet Population Time Time consumed when writing the query results to the sheet
Total Client Processing Time Sum of all pages’ Client Time
Total Server Processing Time Sum of all Pages’ Server Time
Total Processing Time Total Server and Total Client Processing Time combined
Total Records Processed Total number of records processed
End of Log End Query Refresh for <Data Area>: <Business Class>

Indicates the end time of the statistics log for a particular query, and the data area and business class of the query

The following logging data is included for uploads:

Field Description
Start of Log Starting Upload Refresh for <Data Area>: <Business Class>

Indicates the start time of the statistics log for a particular upload, and the data area and business class of the upload
Details per page (note that the number pf pages depends on your Upload Page Size setting A per page list of the time consumed by the Landmark server and the ISD application.
  • Records per page - number of records processed of a certain page
  • Server Time - time consumed by the Landmark server-side to process the upload
  • Client Time - time consumed by ISD application
Total Client Processing Time Sum of all pages’ Client Time
Total Server Processing Time Sum of all Pages’ Server Time
Total Processing Time Total Server and Total Client Processing Time combined
Total Records Processed Total number of records processed
End of Log End Upload Refresh for <Data Area>: <Business Class>

Indicates the end time of the statistics log for a particular upload, and the data area and business class of the upload