General
The BlueWorx tables maintain the last update timestamp for a BlueWorx relevant change in the master record. This enables delta synchronisation of records to the application.
Key Tables
Below is a list of the key tables, those highlighted in orange are updated in real time by actions on events. The other tables are updated by routine background jobs.
- /SOLTIUS/PM_PROB – Profile to Technical Object
- /SOTLIUS/PM_PRKL – Profile to Class/
- SOLTIUS/PM_PRCA – Profile to Characteristic
- /SOLTIUS/PM_EQUI – Equipment
- /SOLTIUS/PM_FL – Functional Locations
- /SOLTIUS/PM_KLAH – Classes
- /SOLTIUS/PM_CABN - Characteristics
- /SOLTIUS/PM_CAWN – Characteristic Text
- /SOLTIUS/PM_KSML – Class to Characteristic
- /SOLTIUS/PM_KSSK – Technical Object to Class
- /SOLTIUS/PM_AUSP – Technical Object Characteristic Value
- /SOLTIUS/PM_MPNT – Measurement Points Last Reading
- /SOLTIUS/PM_T352 – Catalog Profiles
- /SOLTIUS/PM_QPCD – Catalog Codes
- /SOLTIUS/PM_QPGR – Catalog Groups
- /SOLTIUS/PM_MAT – Material Master
- /SOLTIUS/PM_MATB – Material Batches
- /SOLTIUS/PM_MATS – Material Serial Numbers
- /SOLTIUS/PM_MATD – Material Storage Location Inventory
- /SOLTIUS/PM_PER – Permit master
- /SOLTIUS/PM_PETO – Permits links to objects
- /SOLTIUS/PM_EVTL - BlueWorx Event locks
For a list of all BlueWorx tables and their sizes see the Settings Tab - Sizing
Batch Jobs
Set up the following batch jobs in SAP using transaction SM36:
# | Instruction |
1 | Create Job to update the Catalogue Codes (Notification Codes)
Program: /SOLTIUS/PM_REFRESH_CATALOGUES |
2 | Create Job to remove ‘old’ deletion flagged records from the Application Sync Tables
Program: /SOLTIUS/PM_CLEAN |
3 | Create Job to Add Master Data to the Application Sync Tables.
Program: /SOLTIUS/PM_PROFILE_ADD_MD |
4 | Create Job to Validate Master Data in the Application Sync Tables.
Program: /SOLTIUS/PM_PROFILE_RF_MD |
5 | Create Job to Process Inspection Results
Program: /SOLTIUS/PM_INSP_PROCESS |
6 | Create Job to Update Material Balances
Program: /SOLTIUS/PM_UPD_MATERIAL_BAL |
7 | Create Job to Process Material Issues
Program: /SOLTIUS/PM_PROCESS_MATERIALS Run with parameter p_errors = ‘X’ to automatically retry processing issues (for example locked Material or Orders) |
8 | Create Job to Check Sync Times
Program: /SOLTIUS/PM_SLOW_SYNC |
9 | Create BlueWorx Queue Processing Job You can via Admin settings (https://blueworx.freshdesk.com/a/solutions/articles/19000006709-maintain-core-settings-settings-tab > Sync Settings) optionally process master data change events in their entirety using a separately scheduled job. When on this removes the load from the SAP Event Queue which will just register an event for BlueWorx processing and not fully execute the evaluation and action. After enabling the BlueWorx Admin setting schedule a job using the program below. You can use different schedules and variants to process some events at different times and according to your needs. To get a list of the Events look at the Events FOLDER in the Class /SOLTIUS/PM_CHGOBJ. Program: /SOLTIUS/PM_EVTQ_PROCESS |
10 | Create job to Process Master Data Validity
Program: /SOLTIUS/PM_PROCESS_MD_VALIDIT |
11 | Create job to process Permit Updates (Support Pack 07+)
Program: /SOLTIUS/PM_UPD_MD_PER |
12 | Create job to generate Order Inspections (Support Pack 07+)
Program: /SOLTIUS/PM_INSP_ORDER_GEN |
13 | Create Refresh Feature Location and Rendering Job (Support Pack 07 Update 06+) As of Support Pack 7 Patch 06 a job can be configured to update the location and rendering of features based on the characteristic values of the equipment and functional locations they represent. Only affects features belonging to layers with the switch ‘value based rendering’ or ‘update geometry from characteristic’ turned on
Program: /SOLTIUS/EM_RF_FEATURES |
14 | Create Job to update permit master data
Program: /SOLTIUS/PM_UPD_MD_PER |
15 | Create Geo Inheritance Refresh Job
|
16 | Clear Transaction Logs BlueWorx logs the temporary Notification, Order, and Operation IDs created in BlueWorx with the SAP IDs once the objects have been created in SAP. The link is used when updating downstream items such as Notification Items, or ensuring a Document is linked to the correct object. In addition a log of each object saved is kept, primarily to ensure that no item is created twice if Sync in interrupted before BlueWorx gets confirmation of success. With Support Pack 10 the transaction log can be searched and contains the payload, for example a SAVE_ORDER transaction payload contains the fields in the Order header.
|
17 | Clear Order and Notification Change Logs BlueWorx logs the timestamp of when a Notification or Order has last been changed in SAP. This data is collected in the table /SOLTIUS/PM_TDCL. This table is read from during a delta sync to check whether any of the Orders and Notifications on the user's device that have been changed since the user last synced. The list of Orders and Notifications builds up in a log and needs to be periodically cleared.
|
18 | Clear Temporary Sync Data BlueWorx stores temporary data during a sync to prevent recalculation of vital sync records in each sync step. These records are cleared when the sync completes. If a sync fails to complete then the records can be left in place causing the temporary data tables to grow.
|
19 | Refresh Inspection Question Data Question data such as the number of characters for a characteristic may change over time but is not automatically updated in the Inspection Question Master Data. This job read then re-saves Inspection Questions, updating such fields.
|
20 | Refresh SAP Standard Text Data Changes to SAP Standard Text are not automatically updated in BlueWorx. This job updates the SAP Standard Text in BlueWorx.
|
21 | Refresh Time Zone Data The BlueWorx app uses SAP time zone data but requires it to be converted into another format. This job creates time zone data in the required format.
|
22 | Clear Temporary Master Data Join Records Support Pack 12 introduced collective generation and update of BlueWorx Master Data. There are three processing types, the default is to favour database selects using JOINS. To make that work efficiently key data for the records being processed are temporarily written to the database. In case of error or incomplete processing the temporary data can be left in the database. This job clears temporary data older than a specified number of days.
Program: /SOLTIUS/PM_DEL_MD_RF_JOIN_DAT |
23 | Clear BlueWorx Event Locks Support pack 13.5.2 and onwards introduces a BlueWorx Event lock. This Event Lock is used to reduce change events from firing repeatedly for a single SAP Object (e.g. Order). If in the event that a lock remains, this may cause issues due to change events not being able to fire.
|
24 | Clear Deletion Flagged Inspection Master Data (optional) Release 14.2.0 introduces a new program which will remove inspection master data (from the database) records that have been deletion flagged for longer than a specified number of days. In prior releases these records were removed as part of the program to "...remove ‘old’ deletion flagged records from the Application Sync Tables" as they are also part of the data synchronised to the application. It was recognised that the Inspection Master Data may be subject to different retention policy as once deleted, the records cannot be restored. This new optional program can be set up according to your organisation's policy. Program: /SOLTIUS/PM_CLEAR_INSP_MD |
25 | Clear Deletion Flagged Geospatial Features (optional) Release 14.2.0 introduces a new program which will remove geospatial feature (from the database) records that have been deletion flagged for longer than a specified number of days. In prior releases these records were removed as part of the program to "...remove ‘old’ deletion flagged records from the Application Sync Tables" as they are also part of the data synchronised to the application. It was recognised that the geospatial features may be subject to different retention policy as once deleted they cannot be restored. This new optional program can be set up according to your organisation's policy. Program: /SOLTIUS/EM_CLEAR_GEO_FT_DATA |
26 | Write table update queue to sync table log (optional) Releases 13.5.6/14.4.0 introduced a change to the way the sync table log is updated. Prior to this release the table was updated with each write to a BlueWorx database table. This meant there were a large number of writes and could result in database locks. This has been changed so that the need for an update is recorded once per table and then during sync the sync table log is updated from that queue to ensure changes are picked up in the sync. The update of the sync table log (table /SOLTIUS/PM_SYTL) form the queue can also be done by scheduling a background program. This is optional. The advantage is that when this done in a sync, the following sync will also analysis the updated tables for changes. Running the background job minimises this, however the repeat analysis in the sync is fast and will likely not be noticed.
|