User Tools

Site Tools


implementation:wms:app_config

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
implementation:wms:app_config [2018/03/26 08:49]
csuhaa logging into db
implementation:wms:app_config [2018/03/26 09:17] (current)
csuhaa
Line 187: Line 187:
 It is possible to insert the logs into an UDT in the given database or into a manually created table in a separate database. It is possible to insert the logs into an UDT in the given database or into a manually created table in a separate database.
  
-====10.1. Logging into an UDT==== +====10.6.1. Logging into an UDT==== 
-===10.1.1. Create UDT===+===10.6.1.1. Create UDT===
 First create the user defined table in SAP Business One. First create the user defined table in SAP Business One.
  
Line 205: Line 205:
 |  SessionName ​ |  Alphanumeric ​ |  Regular ​ |  50  | |  SessionName ​ |  Alphanumeric ​ |  Regular ​ |  50  |
  
-===10.1.2. Modify config file===+===10.6.1.2. Modify config file===
 Download an example for the fat client config file from here: Download an example for the fat client config file from here:
-  * MSSQL: Produmex.Sbo.Logex.Execute.FatClient.exe_WITH SQL Log_1.config +  * MSSQL: ​{{:​implementation:​wms:​config:​appconfig:​produmex.sbo.logex.execute.fatclient.exe_with_sql_log_1.zip|Produmex.Sbo.Logex.Execute.FatClient.exe_WITH SQL Log_1.config}} 
-  * HANA: Produmex.Sbo.Logex.Execute.FatClient.exe_WITH HANA Log_1.config+  * HANA: {{:​implementation:​wms:​config:​appconfig:​produmex.sbo.logex.execute.fatclient.exe_with_hana_log_1.zip|Produmex.Sbo.Logex.Execute.FatClient.exe_WITH HANA Log_1.config}}
  
-==10.1.2.1. Trigger Ado Net Appender==+==10.6.1.2.1. Trigger Ado Net Appender==
 In order to trigger the Ado Net Appender, add the following to the root tag:  In order to trigger the Ado Net Appender, add the following to the root tag: 
 <​code><​appender-ref ref="​AdoNetAppender"​ /></​code>​ <​code><​appender-ref ref="​AdoNetAppender"​ /></​code>​
  
-kép+{{ :​implementation:​wms:​config:​appconfig:​root2.png |}}
  
 If there is no logging level defined in the root tag, then the logging level is the minimum logging level set for the AdoNetAppender. If there is no logging level defined in the root tag, then the logging level is the minimum logging level set for the AdoNetAppender.
  
-kép+{{ :​implementation:​wms:​config:​appconfig:​ado_net_appender_logging_level2.png |}}
  
 If there is a logging level defined in the root tag, then that logging level is used regardless of the minimum logging level set for the AdoNetAppender. If there is a logging level defined in the root tag, then that logging level is used regardless of the minimum logging level set for the AdoNetAppender.
  
-==10.1.2.2. Edit appender tag==+{{ :​implementation:​wms:​config:​appconfig:​root1.png |}} 
 + 
 +==10.6.1.2.2. Edit appender tag==
 Then insert the following before the <​root>​ tag:  Then insert the following before the <​root>​ tag: 
  
Line 383: Line 385:
 </​code>​ </​code>​
  
-==10.1.2.3. Adjust the log4net connection string==+==10.6.1.2.3. Adjust the log4net connection string==
 Adjust the dummy connection string in the log4net part to point to your database/​schema. Adjust the dummy connection string in the log4net part to point to your database/​schema.
  
Line 392: Line 394:
 The USER ID is the database user and the PASSWORD is the password of the user. \\ The USER ID is the database user and the PASSWORD is the password of the user. \\
  
-kép+{{ :​implementation:​wms:​config:​appconfig:​log4net_config01.png |}}
  
 **HANA** **HANA**
Line 401: Line 403:
 The UID is the database user ID and the PWD is the password of the user. \\ The UID is the database user ID and the PWD is the password of the user. \\
  
-kép+{{ :​implementation:​wms:​config:​appconfig:​connection_string_hana.png |}}
  
-====10.2. Logging into a separate database==== +====10.6.2. Logging into a separate database==== 
-===10.2.1. Create the log table=== ​+===10.6.2.1. Create the log table=== ​
 First create a new database/​schema for the log table. Then run the following query on the database/​schema:​ First create a new database/​schema for the log table. Then run the following query on the database/​schema:​
  
Line 437: Line 439:
 Where the //schema// is the new schema and the //PMX_log// is the name of the table where the log entries will be inserted. Where the //schema// is the new schema and the //PMX_log// is the name of the table where the log entries will be inserted.
  
-===10.2.2. Modify config file===+===10.6.2.2. Modify config file===
 Download an example for the fat client config file from here: Download an example for the fat client config file from here:
-  * MSSQL: Produmex.Sbo.Logex.Execute.FatClient.exe_WITH SQL Log_2.config +  * MSSQL: ​{{:​implementation:​wms:​config:​appconfig:​produmex.sbo.logex.execute.fatclient.exe_with_sql_log_2.zip|Produmex.Sbo.Logex.Execute.FatClient.exe_WITH SQL Log_2.config}} 
-  * HANA: Produmex.Sbo.Logex.Execute.FatClient.exe_WITH HANA Log_2.config+  * HANA: {{:​implementation:​wms:​config:​appconfig:​produmex.sbo.logex.execute.fatclient.exe_with_hana_log_2.zip|Produmex.Sbo.Logex.Execute.FatClient.exe_WITH HANA Log_2.config}}
  
-==10.2.2.1. Edit appender tag==+==10.6.2.2.1. Edit appender tag==
 Insert the following before the <​root>​ tag:  Insert the following before the <​root>​ tag: 
  
Line 602: Line 604:
 </​code>​ </​code>​
  
-==10.2.2.2. Trigger Ado Net Appender== +==10.6.2.2.2. Trigger Ado Net Appender== 
-Please see: //10.1.2.1. Trigger Ado Net Appender//+Please see: //10.6.1.2.1. Trigger Ado Net Appender//
  
-==10.2.2.3. Adjust the log4net connection string==+==10.6.2.2.3. Adjust the log4net connection string==
 Adjust the dummy connection string in the log4net part to point to the extra database/​schema where the created log table is located. Adjust the dummy connection string in the log4net part to point to the extra database/​schema where the created log table is located.
  
Line 614: Line 616:
 The USER ID is the database user and the PASSWORD is the password of the user. \\ The USER ID is the database user and the PASSWORD is the password of the user. \\
  
-kép+{{ :​implementation:​wms:​config:​appconfig:​sql_extra_config2.png |}}
  
 **HANA** \\ **HANA** \\
Line 622: Line 624:
 The CURRENTSCHEMA is the new schema where the log table is located. \\ The CURRENTSCHEMA is the new schema where the log table is located. \\
 The UID is the databse user ID and the PWD is the password of the user. \\ The UID is the databse user ID and the PWD is the password of the user. \\
 +
 +{{ :​implementation:​wms:​config:​appconfig:​hana_extra_config2.png |}}
implementation/wms/app_config.txt · Last modified: 2018/03/26 09:17 by csuhaa