View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

Reporting Server/At Runtime Topics

Contents


In production the data loader application will run periodically. The log will show statements like this:

 [loadData] 2019-12-11 11:21:17,299 [pool-2-thread-3] INFO  org.openbravo.reporting.tools.dataloader.BaseDataLoader - product_category --> loaded + committed in 0 seconds
 [loadData] 2019-12-11 11:21:17,300 [pool-2-thread-3] INFO  org.openbravo.reporting.tools.dataloader.BaseDataLoader - bpartner --> Start of load data
 [loadData] 2019-12-11 11:21:17,302 [pool-2-thread-2] INFO  org.openbravo.reporting.tools.dataloader.PostgresInsertStatementHelper - POS TouchPoint --> Reindexing table took 0 seconds
 [loadData] 2019-12-11 11:21:17,308 [pool-2-thread-2] INFO  org.openbravo.reporting.tools.dataloader.BaseDataLoader - POS TouchPoint --> loaded + committed in 0 seconds
 [loadData] 2019-12-11 11:21:17,309 [pool-2-thread-2] INFO  org.openbravo.reporting.tools.dataloader.BaseDataLoader - sales order lines --> Start of load data
 [loadData] 2019-12-11 11:21:17,323 [pool-2-thread-3] INFO  org.openbravo.reporting.tools.dataloader.StandardDataLoader - bpartner --> before commit, loading 24 records took 0 seconds
 [loadData] 2019-12-11 11:21:17,327 [pool-2-thread-3] INFO  org.openbravo.reporting.tools.dataloader.BaseDataLoader - bpartner --> loaded + committed in 0 seconds

The name of the load step is printed first with the relevant message. Note that the data loader application runs script tasks in parallel, log statements of parallel tasks are intertwined.

The obrpttl_parameters table

The obrpttl_parameters table is an important table. When a script is run a record is created or updated in that table. The record has two columns name and timestamp_value. The name corresponds to the load step. The timestamp value is the last time that script ran minus 5 minutes. The 5 minutes is subtracted for detailed reasons to make sure that data is not missed when doing incremental loads.

The parameters record has two important purposes:

Force reload-full or reload-from or re-execute an execute-once script

So with this purpose of the obrtpttl_parameters table there are several things which can be achieved by updating the obrpttl_parameters table directly:

Retrieved from "http://wiki.openbravo.com/wiki/Reporting_Server/At_Runtime_Topics"

This page has been accessed 2,449 times. This page was last modified on 11 December 2019, at 10:27. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.