View source | Discuss this page | Page history | Printable version   

Reporting Server/At Runtime Topics


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 - product_category --> loaded + committed in 0 seconds
 [loadData] 2019-12-11 11:21:17,300 [pool-2-thread-3] INFO - bpartner --> Start of load data
 [loadData] 2019-12-11 11:21:17,302 [pool-2-thread-2] INFO - POS TouchPoint --> Reindexing table took 0 seconds
 [loadData] 2019-12-11 11:21:17,308 [pool-2-thread-2] INFO - POS TouchPoint --> loaded + committed in 0 seconds
 [loadData] 2019-12-11 11:21:17,309 [pool-2-thread-2] INFO - sales order lines --> Start of load data
 [loadData] 2019-12-11 11:21:17,323 [pool-2-thread-3] INFO - bpartner --> before commit, loading 24 records took 0 seconds
 [loadData] 2019-12-11 11:21:17,327 [pool-2-thread-3] INFO - 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 ""

This page has been accessed 2,837 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.