|
|
|
|
|
|
|
|
|
|
- Overview
- JNL_FILES.FIC file
- JNL_OPERATION.FIC file
- JNL_USERS.FIC file
Structure of log files (HFSQL Client/Server)
 Disponible solo con este tipo de conexión
The following files are automatically created when logging an HFSQL Client/Server data file: | | | JNL_FILES.FIC | Description of logged files. | | JNL_OPERATION.FIC | Description of actions performed on a logged file. | | JNL_USERS.FIC | Description of users who perform an action on a logged file. | | xxxJNL.FIC | File created for each logged file. Contains the value of records used before and after each operation. |
These files are created according to the following structure: | |  | 1. __JNL directory
This directory contains:- The file log
- The user log
- The operation log
- For each logged file of each database, the corresponding log file. The tree structure used corresponds to the tree structure of the data files associated with the database.
For example, if the Orders file of DataApplicationA is logged, the __JNL\DataApplicationA subdirectory will contain the OrdersJNL.FIC file.Another example: if the Client file of DonneesApplicationB is jounalé, the sub-directory __JNL\DonneesApplicationA\Client will contain the file ClientJNL.FIC. 2. Database directory DataApplicationA 3. Database directory DataApplicationB |
This page presents the structure of these files. The different items found in JNL_FILES.FIC are as follows: | | | JNLFile_ID | File identifier. | | Source_DB_File_Location | Name of database + '\' + relative path of log file. | | Source_File_GUID | GUID of the logged file. | | JNL_File_GUID | GUID of write-to-file log. |
The different items found in JNL_OPERATION.FIC are as follows: | | | Operation_ID | Identifier of the operation. | | USER_ID | Identifier of user who performs the operation. This identifier corresponds to the identifier of JNL_USER.Fic | | JNLFile_ID | Identifier of logged file where the operation is performed. This identifier corresponds to the identifier of JNL_FILES.Fic. | | WLFunction_ID | Identifier of the WLanguage function used in the program. To find out the name of the WLanguage function used, simply check the ListeDéfinitionHF.WL file (located in the "Personal\Extern\" subdirectory of the product) | | Server_Time | Date of operation on the server (in UTC format, universal time) | | Record_Number | Number of the modified record | | Source_Record_Backup_ID | Identifier in the file of values. Corresponds to the record value before the operation. | | Modified_Record_Backup_ID | Identifier in the file of values. Corresponds to the record value after the operation. | | HLogInfoMsg | Value defined by HLogInfo. | | HComputer_ID | Text defined by HComputer. |
The different items found in JNL_USERS.FIC are as follows: | | | USER_ID | User identifier. | | Login | Username. | | Workstation_Name | Name of user computer. | | Workstation_IPAddress | IP address of user computer. | | Application | Application name |
The *JNL.Fic file contains: - the items found in the table below,
- all the logged items of the corresponding logged HFSQL file.
| | | USER_ID | Identifier of the user who performed the operation. This number is used to identify the record in JNL_Users.Fic | | Record_Number | Number of the record in the initial logged file. | | Record_Status | Record status (modified, deleted, added, ...) | | WLFunction_ID | Identifier of the WLanguage function used in the program. To find out the name of the WLanguage function used, simply check the ListeDéfinitionHF.WL file (located in the "Personal\Extern\" subdirectory of the product used) | | Server_Time | Date of operation on the server (in UTC format, universal time) | | HLogInfoMsg | Value defined by HLogInfo. | | HComputer_ID | Text defined by HComputer. | | IDJNL | Identifier of the log |
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|