BoardServer log file

BoardServers write activities on a monthly log file located in the directory \Board\Dataset\WebLog . The name of the file is Web_YYYYMM.log where YYYYMM represents year and month. Note that the prefix ”r;Web” is used for historical reasons only, it does not refer to any Web activity or feature.

A record in the log file is generated whenever BoardServer accesses an InfoCube to populate a Layout. For example, the execution of a report with a Layout of two InfoCubes and a calculated field, generates two records in the log file. When a single Layout refers to more than one InfoCube, the elapsed time parameter is only recorded  on the first record but refers to the total CPU time required to execute the Layout.

The log file is a fixed length field text file with the following structure

 

Position and width

Field name

Description

   1 – 10

Auto num.

Incremental counter of BoardServer’s action number.

Note! It is not a unique record identifier.

 

11 – 25

profile

It is the user’s security profile.

 

36 – 1

ro/rw access

Indicates whether the infoCube is accessed in read-only or read-wirte mode. The value N when the InfoCube is accessed for reading only, E when for data entry mode.

 

37 – 5

Ununsed

Unused field, filler string N__N1.

 

42 – 25

BdB name

BOARD Database name (without extension).

 

67 – 100

BdB path

Full path of the BOARD Database.

 

167 – 25 

InfoCube

Name of the InfoCube accessed.

 

192 – 5

Version

InfoCube version.

  

197 – 8

Date

Date, in the format yyyymmdd.

 

205 – 6

Time

Time in the format hhmmss.

 

211 – 6

Unused

Unused field, filler character ”r;_”.

  

217 – 1

Data access

P indicates data view is at physical level, L indicates data view is logical.

 

218 – 1

Layout id

Value is 1 on the first record of a Layout object, other records relating to InfoCubes beloging to the same Layout are marked with 0.

 

219 – 3

Unused

Unused field, filler character ”r;_”.

  

221 –10

elapsed time

Time (in seconds) required to execute the Layout.

Note! If the Layout contains more than one InfoCube, this parameter is present only on the first record for that Layout and indicated the execution time required for extracting all InfoCubes (i.e. only on records where the Layout id is 1).