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. 


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

For a list of all BlueWorx tables and their sizes see the Settings Tab - Sizing

Batch Jobs


#

Instruction

1

Create Job to update the Catalogue Codes (Notification Codes)

  • There is no automatic update so this job should be run after configuration update to the Catalogue Codes and then in each system after code changes have been transported.
  • Can be run periodically in background to ensure Catalogue Code data is ‘fresh’

Program: /SOLTIUS/PM_REFRESH_CATALOGUES

2

Create Job to remove ‘old’ deletion flagged records from the Application Sync Tables

  • This job keeps the table’s sizes to a minimum by removing records that have been flagged for deletion over X days ago. The default is 90 days.
  • The assumption is that all devices have been synchronised within the period specified.
  • Should be scheduled to run periodically, e.g. monthly.

Program: /SOLTIUS/PM_CLEAN

3

Create Job to Add Master Data to the Application Sync Tables.

  • Checks to see whether all objects as specified in the BlueWorx profiles are in the sync tables. Adds any that are found to be missing.
  • Missing entries are usually due to changes in profiles as changes to the objects themselves are picked up by the object change events.
  • Can only be run in background.
  • This job can be schedule to run periodically (i.e. daily) but for customers with a large number of profiles, large PM datasets, or constraints SAP resources we recommend:
    1. Generating on change from within the BlueWorx Admin Profile Config area now delivered (in SP7), or;
    2. Schedule a specific profile update after making changes to run after hours, to both limit disruption for BlueWorx users and minimise impact on SAP system resources
  • Does not remove items that are no longer in the BlueWorx profiles.

Program: /SOLTIUS/PM_PROFILE_ADD_MD

4

Create Job to Validate Master Data in the Application Sync Tables.

  • Checks the validity of data in the Master Data tables, by regenerating entries and comparing against those already in the table.
  • Can only be run in background.
  • Schedule once a month.
  • Flags data which is not in profiles for deletion.  This can be turned off in your variant (Parameter: Skip Master Data Validity Chk) to improve performance if you have split this batch job by profile.  If the parameter is set, consider running Job to Validate Master Data periodically.

Program: /SOLTIUS/PM_PROFILE_RF_MD

5

Create Job to Process Inspection Results

  • This job processes inspection results. Depending on the questions it can: Update Equipment and FL master data; Update Equipment and FL Classification data; Create Measurement Documents for Equipment and FL
  • Should be scheduled to run periodically, e.g. nightly or twice daily. The frequency may be more often if operational requirements dictate

Program: /SOLTIUS/PM_INSP_PROCESS

6

Create Job to Update Material Balances

  • This job processes refreshes the balances for all Materials – configured by Plant/ SLOC and Material Type
  • This program should be run at least daily to catch up on material movements not made through BlueWorx

Program: /SOLTIUS/PM_UPD_MATERIAL_BAL

7

Create Job to Process Material Issues

  • This job processes material issues since last run
  • Suggest setting up to run multiple times per day and potentially with only one of the jobs set to reprocess errors

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

  • This job checks for application syncs that started but have not completed, marking them with error status.
  • Should be run hourly

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

  • Checks master data is in valid profiles.  If not, the master data record is flagged for deletion.
  • All profiles are processed as for a master data record to be valid it must be valid in at least one profile.
  • Optional parameter to skip profile generation.  This improves run time and is appropriate where you have other jobs which frequently update the profile data (likely).
  • Run at most monthly.

Program: /SOLTIUS/PM_PROCESS_MD_VALIDIT

11

Create job to process Permit Updates (Support Pack 07+)

  • This job updates SAP Permit information for Functional Locations, Equipment, and Work Orders.
  • The frequency of the job depends on how often permit master data is updated.     Recommendation is to run nightly unless permit master data is very static.

Program: /SOLTIUS/PM_UPD_MD_PER

12

Create job to generate Order Inspections (Support Pack 07+)

  • Only required when admin setting for background generation of order inspection is active.
  • Should be run daily
  • If this job cannot be run daily then use the parameter offset days so that all the inspections required before the next run are generated.  For example, if running the job weekly use a 7 day offset.
  • Note that the admin parameter for days forward and back is used to time bound the inspections generated.  Each user profile is checked and the greater of the inspection admin parameter or the profile work order days forward and back is used as the generation horizon.

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

  • Can only be run in background.
  • Schedule once a month.
  • Flags features that do not have valid location data  

Program: /SOLTIUS/EM_RF_FEATURES

14

Create Job to update permit master data

  • There is no automatic update so this job should be run after configuration to update the permit master data in each system after code changes have been transported.
  • Can be run periodically in background to ensure Permit data is ‘fresh’

Program: /SOLTIUS/PM_UPD_MD_PER

15 

Create Geo Inheritance Refresh Job

  • This job will generate and update the inheritance for features based on their install location. Flags any duplicate or no longer relevant inherited features as deleted. Change pointers on technical objects should handle most day to day updates.
  • Only required when admin setting for inherit geo is active
  • Should be scheduled to run once a month
Program: /SOLTIUS/EM_RF_GEO_INHERITANCE
16Clear 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.
  • This job deletes transaction logs older than a specified number of days (default: 365 days)
  • It is optional
  • Transaction history is not retained in any other place, and running this job will permanently delete the BlueWorx transaction information
  • It can be run directly or as a scheduled batch job
Program: /SOLTIUS/PM_CLEAR_TRAN_LOGS
17Clear 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. 
  • This job deletes entries older than a specified number of days (default: 30 days).
  • Recommended to run once a month.
  • It can be run directly or as a scheduled batch job.
Program: /SOLTIUS/PM_CLEAR_TDCL_CHANGES
18Clear 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.
  • This job deletes sync temporary data older than a specified number of hours, greater than or equal to 24 hours (default: 24 hours)
  • Recommended to be run daily
  • It can be run directly or as a scheduled batch job
Program: /SOLTIUS/PM_CLEAR_SYNC_RECORDS