Limiting Inbox search result for IBM BPM

sometimes if we have lots of instances assigned to a user or usergroup then refreshing inbox for user become very slow as IBM BPM tries to get details about all cases and it might take upto 10 minutes.

This performance issues is due to large number of cases so there are only two solutions,
1.) close the cases and keep only required cases open and available, which does not work in all scenarios
2.) limit the number of instances fetched by a saved search/inbox in IBM BPM Portal. which can be done by below steps.

-> In newer version this value is by default set to 500 which is good and you might need to make it higher if you want to see more instances in result.

Optimize the number of loaded search result entries

You can optimize the number of retrieved results entries of your saved searches.

The saved searches are optimized to process 500 result entries. The displayed pages of the result contains up to 500 entries, which are retrieved from the server. In addition, the total number of entries is displayed.

If you expect more than 500 records for a call, for example, if you are using the TWSearch function or the saved search in an API format, you can increase this number.

To retrieve a different number of entries, complete the following steps:

1. Insert the following section into the 100custom.xml file:

   <properties>
       <server merge="mergeChildren">
     <process-search-engine-count-optimization merge="replace">500</process-search-engine-count-optimization>
          </server>
   </properties>

2. Adjust the 500 value to meet your needs. The larger the value, the more memory and time is needed to retrieve the entries.
3. After saving changes to the 100custom.xml file, restart the server.

You can find more details about his in blow tech-note by IBM

http://www-01.ibm.com/support/knowledgecenter/SS964W/com.ibm.wbpm.admin.doc/topics/ctuneprocportal.html

IBM BPM - How to find a group membership of dynamic group(type 4 groups)

We stuck in situation once where dynamic group was locking everything and no users can log into the portal. We struggled to get details about dynamic groups, like what all is included in dynamic groups, we were especially interested in which all LDAP groups were part of that dynamic groups.

By following the below steps you can get details about Dynamic groups or which all groups are added in dynamic groups.

First you need to have name of the dynamic groups. Mostly dynamic group name will be something like 'Filtered set of users' so in our example lets take same name.

Step 1.) 
select * FROM LSW_DYNAMIC_GROUP where NAME like 'Filtered set of users'

take dynamic_group_id from there and use it in below query.

Step 2.)
select * from LSW_DYNAMIC_GROUP_CONSTRAINT where DYNAMIC_GROUP_ID=<Group_ID>

Here you may find one or more rows depending on creation of your dynamic group. if it is only created with users, there will be list of users in Value and you can use that.
If PG is being used as part of dynamic group you will get a row with value in Library_element_type = 24. here Library Element type is same as PO_type in lsw_po_versions and details for other type can be found using below blog entry I wrote earlier,

http://randombpmsolutions.blogspot.co.uk/2015/08/ibm-bpm-855-po-types-table-bpm-db-part.html

Step 3.)
You can get table name based on Library_element_type and then find details in perticular table. In our case for type 24 we can check below table

select * from LSW_PARTICIPANT where PARTICIPANT_ID='<LIBRARY_ELEMENT_ID>'

and from here you can go to LSW_PARTICIPANT_GROUP table to get group_ID

select GROUP_ID from LSW_PARTICIPANT_GROUP where PARTICIPANT_ID='<LIBRARY_ELEMENT_ID>'

Step 4.)
once you have group ID, you can put it in below query to get LDAP or internal groups used in dynamic group.

select gg.*, g.GROUP_NAME from LSW_GRP_GRP_MEM_XREF gg, LSW_USR_GRP_XREF g where gg.GROUP_ID=g.GROUP_ID and gg.CONTAINER_GROUP_ID=<GROUP_ID>


IF you have more then one entry of type 24 or any other in LSW_DYNAMIC_GROUP_CONSTRAINT then you can repeat step 3 and 4 to get all details

IBM BPM - Deactivating Dynamic Group(type 4) Update - Performance improvement specially while login

What are Dynamic Groups?
Dynamic groups are created whenever a team or a task assignment is created using an expression. These expressions select users based on user attributes, group membership, and various other criteria. As a result, a dynamic group is created in the database. They are also known as Type 4 groups or in LSW_USR_GRP_XREF they will be having value of group_type = 4

Why Dynamic Groups get updated?

As mentioned earlier Dynamic Groups are set of other type of groups which includes external groups. so whenever any external or security gets updated, dynamic group also needs to get updated in order to be in sync with other groups.

When are dynamic groups updated?

There are several triggers that can cause dynamic group updates:

• When IBM Business Process Manager internal groups or a member of an internal group are updated in the Process Admin Console.
• When a user logs in to a IBM Business Process Manager web interface, the external group membership is replicated based on the external security provider settings. If changes are detected, dynamic groups are recalculated.
• When a user updates user attributes in the Process Admin Console or while using a REST API.
• During task creation using dynamic group expression.

Configuring IBM Business Process Manager to deactivate dynamic group updates

Modify the 100Custom.xml configuration file to deactivate updates for the specified triggers, as shown in the following example:

<properties>
<server merge="mergeChildren">
<update-dynamic-groups-on-login>false</update-dynamic-groups-on-login>
<update-dynamic-groups-on-task-creation>false</update-dynamic-groups-on-task-creation>
<update-dynamic-groups-on-uadchange>false</update-dynamic-groups-on-uadchange>
</server>
</properties>

Cleaning TEMP GROUPS and LSW_USR_GRP_MEM_XREF

There is a procedure available which cleans the TEMP Groups which deletes all temporary groups that are no longer referenced by a task.

LSW_ERASE_TEMP_GROUPS

I believe, we can use this procedure to clean all the unwanted groups and group member references from DB.

Please Note that, this procedure is already included in ‘LSW_BPD_INSTANCE_DELETE’ and ‘LSW_ERASE_TASK’, so if we are deleting instances or task using  stored procedure it automatically calls this proc.

Content of Procedure is as below(just if anyone is curious) – 

CREATE PROCEDURE LSW_ERASE_TEMP_GROUPS

(

)

LANGUAGE SQL

  -- This procedure deletes all temporary groups that are no longer referenced by a task. --

  BEGIN

 

    DECLARE groupId DECIMAL

(

   12,0

)

;

DECLARE sqlCmd VARCHAR(500)

;

DECLARE at_end DECIMAL(1,0)

;

DECLARE not_found CONDITION for SQLSTATE '02000'

;

DECLARE CONTINUE HANDLER for not_found SET at_end = 1

;

BEGIN

        DECLARE groupsToDelete CURSOR FOR stmt1

;

SET sqlCmd = 'SELECT DISTINCT g.GROUP_ID FROM LSW_USR_GRP_XREF g WHERE NOT EXISTS (SELECT 1 FROM LSW_TASK t WHERE g.GROUP_ID = ABS(t.GROUP_ID)) AND g.GROUP_TYPE = 2'

;

PREPARE stmt1

FROM sqlCmd

;

OPEN groupsToDelete

;

DELETE_GROUP_LOOP:

        LOOP

            SET at_end = 0

;

FETCH groupsToDelete INTO groupId

;

IF (at_end = 1) THEN

                LEAVE DELETE_GROUP_LOOP

;

END IF

;

DELETE

FROM LSW_USR_GRP_MEM_XREF

WHERE GROUP_ID = groupId

;

DELETE

FROM LSW_USR_GRP_XREF

WHERE GROUP_ID = groupId

;

END LOOP

;

CLOSE groupsToDelete

;

END

;

END

;

IBM BPM Process Center Admin Tab is not visible to tw_admins and getting Authorization error while import

When you log into the process center, if you are in the tw_admins group, and no one as messed with any settings, you are a repository admin. This means that you get a 4th tab at the top of the page called "Admin" where you can control who can login to the Process Center, and if that person also sees this admin tab (as well as other features). By default tw_admins are in this list and have "Admin" checked as a property. Now if someone went and unchecked this for tw_admins, and didn't add anyone else back in.

You can see below issues - Problem Statement

1. Admin tab is not visible in ProcessCenter Console even for tw_admins
2. Sometimes get Authorization error while importing applications.
• Exception:com.lombardisoftware.client.security.AuthorizationDeniedException SourceId:com.ibm.ws.uow.UOWManagerImpl.runUnderNewUOW
3. The button to add a new offline process server is missing

Cause

If any user account in the "tw_admins" group removes the administrative privilege, the group loses its administrative privilege as well. Thus, every user that belongs to the "tw_admins" group cannot see the "Add a New Offline Server" button under the Servers tab nor access the Admin tab.

Diagnosing the problem

To determine whether administrative privileges are set, complete the following steps:

1. Open the LSW_ACL_ENTRY table for the ACL of the "tw_admins" group.
2. Check the row whose "GROUP_ID" is 3, and "ACL_ENTRY_ID" is 1. If the value of "MASK" column is 127, the group "tw_admins" has administrative privilege. Otherwise, the "tw_admins" group does not have any administrative privileges.

Resolving the problem

To resolve this issue, complete the following steps:

1. Stop the Process Center server.
2. Review the LSW_ACL_ENTRY table in Business Process Manager database and ensure that the value of the "MASK" column with "GROUP_ID" = 3 and the "ACL_ENTRY_ID" = 1 is 127.
3. Restart the Process Center server.
4. Log onto the Process Center console with any user account in the "tw_admins" group.

IBM BPM Application Server Tuning - Cache settings

IBM BPM applications are heavily dependent on Database and caching is the most important thing while it comes to tuning, as good caching values solved lots of performance issues.

Below are few of the cache settings I have tried earlier and they gave really good result. Please note you have to keep changing cache values and try again and again to identify the best values for these cache settings.

Branch Cache
One entry in the branch cache is used for each project-branch combination that is loaded into the memory cache. For example, if a process application depends on two toolkits, three branch cache entries are required: one for the process application and one for each toolkit. Each entry in the branch cache contains a snapshot cache. Therefore, the number of entries in the branch cache is tunable, independently from the snapshot cache.

You can determine approximate value for branch cache by following equation

(# of unique Process Application snapshots + # of unique toolkit snapshots) x size_constant       
Where value can size_constant be taken as 5 (MB) and tuned to get best result.

Configuration
We can add tag 'branch-context-max-cache-size' in 100Custom.xml file to configure Branch Cache.
We can add below tag in 100Custom.xml to configure BranchCache.
<server merge="mergeChildren">
  <repository merge="mergeChildren">
    <branch-context-max-cache-size merge="replace">64</branch-context-max-cache-size>
  </repository>

</server>

Snasphot Cache
the snapshot cache is tuned independently from the branch cache. Each branch cache entry contains a snapshot cache. In a Process Server environment, each deployed snapshot is deployed to a unique branch. Therefore, in Process Server, the snapshot cache (which is part of each branch cache entry) contains only one entry.

Configuration
We can add tag 'snapshot-cache-size-per-branch' in 100Custom.xml file to configure Branch Cache.
We can add below tag in 100Custom.xml to configure BranchCache.
<server merge="mergeChildren">
  <repository merge="mergeChildren">
    <snapshot-cache-size-per-branch merge="replace">64</snapshot-cache-size-per-branch>
  </repository>

</server>

indexes

The versioning system in IBM BPM depends on a correctly tuned database. In addition to properly tuning the branch cache, it is important to optimize the indexes on the LSW_PO_VERSIONS table. The following indexes improve performance on IBM BPM V7.5 and later:

CREATE INDEX IDXA_PO_VERSIONS ON lsw_po_versions (PO_TYPE,BRANCH_ID,START_SEQ_NUM,END_SEQ_NUM,PO_VERSION_ID) COMPUTE STATISTICS;

CREATE INDEX IDXB_PO_VERSIONS ON lsw_po_versions (BRANCH_ID,END_SEQ_NUM) COMPUTE STATISTICS;

CREATE INDEX IDXC_PO_VERSIONS ON lsw_po_versions (BRANCH_ID,START_SEQ_NUM,END_SEQ_NUM) COMPUTE STATISTICS;

CREATE INDEX IDXD_PO_VERSIONS ON lsw_po_versions (PO_VERSION_ID,PO_TYPE,BRANCH_ID,START_SEQ_NUM,END_SEQ_NUM)

Source - http://www.ibm.com/developerworks/bpm/library/techarticles/1404_booz/1404_booz.html

Issue while migrating instances in IBM BPM - Instances are not migrating

Problem :: We were facing issue in one of our Process App where we cannot migrate any instances from older version and also not getting any error in SystemOut logs. We have tried everything and finally raised PMR to IBM. PMR went on for few months and finally we got the problem.

Issue: This is happening if you are creating new instances of ProcessApp using REST-API. in IBM BPM Process Server environment, we should not have any instance in LSW_BPD_INSTANCE table with value TIP='T' as there are not TIP version in Process Server Environment.
Though if you are creating new instance using REST-API on Default snapshot that instance will have value TIP='T' in LSW_BPD_INSTACE table, which is defect.
When we migrate instances to one snapshot to another, IBM BPM ignore all the instances having TIP='T' and thus these instances are not getting migrated.

SOLUTION: there are two things we can do.
1.) Change value for all instances from 'T' to 'F' in TIP column of LSW_BPD_INSTACES. This will let us migrate all older instances which we were not able to migrate earlier.

2.) there is an I-Fix which we should install to fix this problem for future instances.
Below are the detail for Permanent fix using IFIX.
http://www-01.ibm.com/support/docview.wss?uid=swg1JR44597

IBM BPM PO types table (BPM DB Part)

IBM BPM 8.5.5 PO types table (BPM DB Part)

 PO_TYPE   Name                        BPMDB table  

 1      TWProcess (Service)           LSW_PROCESS
 2      IC (IntegrationComponent)     LSW_IC
 3      Connector                     LSW_CONNECTOR
 4      UCA (UnderCoverAgent)         LSW_UCA
 7      WebService                    LSW_WEB_SERVICE
 8      WebScript
 11     Report                        LSW_REPORT
 12     TWClass (VariableType)        LSW_CLASS
 13     Scoreboard                    LSW_SCBD
 14     TrackingGroup                 LSW_TRACKING_GROUP
 15     TimingInterval                LSW_TIMING_INTERVAL
 16     TrackingPoint                 LSW_TRACKING_POINT
 17     TrackedVariable               LSW_TRACKED_VARIABLE
 20     Layout                        LSW_LAYOUT
 21     EPV                           LSW_EPV
 22     GlobalVariable                deprecated
 24     Participant                   LSW_PARTICIPANT
 25     BPD                           LSW_BPD
 30     Priority                      LSW_PRIORITY
 31     Calendar                      deprecated
 40     CustomStatus                  deprecated
 42     AlertSeverity                 deprecated
 43     InfoPathForm                  LSW_INFOPATH_FORM
 47     SLA                           LSW_SLA
 49     Metric                        LSW_METRIC
 50     ResourceBundleGroup           LSW_RESOURCE_BUNDLE_GROUP
 51     UserAttributeDefinition       LSW_USER_ATTRIBUTE_DEF
 52     SimulationScenario            LSW_SIM_SCENARIO
 53     HistoricalScenario            LSW_HIST_SCENARIO
 54     OrgChart                      deprecated
 60     ExternalActivity              LSW_EXTERNAL_ACTIVITY
 61     ManagedAsset                  LSW_MANAGED_ASSET
 62     EnvironmentVariableSet        LSW_ENV_VAR_SET
 63     ProjectDefaults               LSW_PROJECT_DEFAULTS
 64     CoachView                     BPM_COACH_VIEW
 65     CoachViewBindingType          BPM_COACH_VIEW_BINDING_TYPE
 66     CoachViewConfigOption         BPM_COACH_VIEW_CONFIG_OPTION
 67     CoachViewResource             BPM_COACH_VIEW_RESOURCE
 68     CoachViewInlineScript         BPM_COACH_VIEW_INLINE_SCRIPT
 69     CoachViewLocalization         BPM_COACH_VIEW_LOCAL_RES
 70     CoachViewAMDDependency        BPM_COACH_VIEW_AMD_DEP
 71     EventSubscription             BPM_EVENT_SUBSCRIPTION
 1989   ExtendedPropertySet           LSW_EXTENDED_PROPERTY_SET
 2000   ExtendedProperty              LSW_EXTENDED_PROPERTY
 2001   AlertType                     deprecated
 2002   SapConnection                 LSW_SAP_CONNECTION
 2005   Breakpoint                    LSW_BREAKPOINT
 2006   BpdEvent                      LSW_BPD_EVENT
 2007   BpdParameter                  LSW_BPD_PARAMETER
 2008   BpmEvent                      BPM_BPD_EVENT
 2013   EpvVar                        LSW_EPV_VAR
 2014   EpvVarValue                   LSW_EPV_VAR_VALUE
 2015   Favorite                      LSW_FAVORITE
 2018   ICInputProperty               LSW_IC_INPUT_PROPERTY
 2019   ICOutputProperty              LSW_IC_OUTPUT_PROPERTY
 2020   TimingIntervalBound           LSW_TIMING_INTERVAL_BOUND
 2022   Launcher                      LSW_LAUNCHER
 2023   LayoutParam                   LSW_LAYOUT_PARAM
 2025   ProcessItem                   LSW_PROCESS_ITEM
 2026   ProcessItemLogVar             deprecated
 2027   ProcessLink                   LSW_PROCESS_LINK
 2028   ProcessLabel                  LSW_PROCESS_LABEL
 2029   ProcessItemPrePost            LSW_PROCESS_ITEM_PRE_POST
 2030   ReportPage                    LSW_REPORT_PAGE
 2031   ReportChart                   LSW_REPORT_CHART
 2032   ReportDatasource              LSW_REPORT_DATASOURCE
 2033   ReportDatasourceICLink        LSW_REPORT_DATASOURCE_IC_LINK
 2034   ReportDatasourceLayoutLink    LSW_REPORT_DS_LAYOUT_LINK
 2035   ReportVariable                LSW_REPORT_VARIABLES
 2036   ReportEpvLink                 LSW_REPORT_EPV_LINK
 2037   ReportTGLink                  LSW_REPORT_TG_LINK
 2038   ResourceBundle                LSW_RESOURCE_BUNDLE
 2039   ResourceBundleKey             LSW_RESOURCE_BUNDLE_KEY
 2040   SavedSearch                   LSW_SAVED_SEARCHES
 2041   ScoreboardReportLink          LSW_SCBD_RPT_LINK
 2043   ScriptLanguage
 2044   SyncQueue                     LSW_UCA_SYNC_QUEUE
 2045   UCABlackout                   LSW_UCA_BLACKOUT
 2046   UCAParam                      LSW_UCA_PARM
 2047   ProviderUser                  LSW_USR
 2048   User                          LSW_USR_XREF
 2049   UserAttribute                 LSW_USR_ATTR
 2050   UserAttributeDefinitionValue  LSW_USER_ATTR_DEF_VALUES
 2052   WebServiceOperation           LSW_WEB_SERVICE_OP
 2054   ParameterMapping              LSW_PARAMETER_MAPPING
 2055   ProcessParameter              LSW_PROCESS_PARAMETER
 2056   ProcessVariable               LSW_PROCESS_VARIABLE
 2057   ProcessGlobalVariableLink     deprecated
 2058   EpvProcessLink                LSW_EPV_PROCESS_LINK
 2059   ResourceProcessLink           LSW_RESOURCE_PROCESS_LINK
 2060   ExternalActivityParameter     LSW_EXTACT_PARAMETER
 2061   ExternalActivityProperty      LSW_EXTACT_PROPERTY
 2063   Branch                        LSW_BRANCH
 2064   Snapshot                      LSW_SNAPSHOT
 2065   Deployment                    LSW_DEPLOYMENT
 2066   Project                       LSW_PROJECT
 2068   Server                        LSW_SERVER
 2069   ProjectDependency             LSW_PROJECT_DEPENDENCY
 2070   ParameterMappingParent
 2072   BPDInstance                   LSW_BPD_INSTANCE
 2073   BPDInstanceData               LSW_BPD_INSTANCE_DATA
 2075   UserGroup                     LSW_USR_GRP_XREF
 2076   Release                       LSW_RELEASE
 2077   EnvironmentVariableValue      LSW_ENV_VAR_VAL
 2078   Task                          LSW_TASK
 2079   UserFavorite                  LSW_USER_FAVORITE
 2080   TaskAttachment                LSW_FILE
 2081   TaskNarrative                 LSW_TASK_NARR
 2082   TaskSendToList                LSW_TASK_ADDR
 2084   TaskExecutionContext          LSW_TASK_EXECUTION_CONTEXT
 2085   TaskInfopathFormData          LSW_TASK_IPF_DATA
 2086   ExternalTaskData              LSW_TASK_EXTACT_DATA
 2087   UserAssume                    LSW_USR_ASSUME
 2089   BPDNotification               LSW_BPD_NOTIFICATION
 2090   DependencyPath                LSW_DEP_PATH
 2091   POReference                   LSW_PO_REFERENCE
 2092   EnvironmentVariableDefault    LSW_ENV_VAR_DEFAULT
 2093   EnvironmentType               LSW_ENV_TYPE
 2094   EnvironmentVariable           LSW_ENV_VAR
 2095   RTReference                   LSW_RT_REFERENCE
 2097   TimePeriod                    LSW_TIME_PERIOD
 2098   TimeSchedule                  LSW_TIME_SCHEDULE
 2099   HolidaySchedule               LSW_HOLIDAY_SCHEDULE
 2100   TWAclEntry                    LSW_ACL_ENTRY
 2101   SmartFolder                   LSW_SMART_FOLDER
 2102   ReportDatasourceServiceLink   LSW_REPORT_DATASOURCE_SRV_LINK
 2103   Installation                  LSW_INSTALLATION
 2104   BlueprintSubscription         LSW_BLUEPRINT_SUBSCRIPTION
 2105   ReportRbgLink                 LSW_REPORT_RBG_LINK
 2106   EnvironmentVariableType       LSW_ENV_VAR_TYPE
 2107   ServerCapability              LSW_SERVER_CAPABILITY
 2108   CapabilityType                LSW_CAPABILITY_TYPE
 2109   SharedObject                  BPM_SHARED_OBJECT
 2110   SharedObjectInstance          BPM_SHARED_OBJECT_INSTANCE
 2111   SharedObjectValue             BPM_SHARED_OBJECT_VALUE
 2112   OSLCProvider                  BPM_OSLC_PROVIDER
 2113   BPDSoapHeader                 BPM_BPD_SOAPHEADER
 2114   EventSubscriptionType         BPM_EVENT_SUBSCRIPTION_TYPE
 2115   UCAEventType                  BPM_UCA_EVENT_TYPE
 2116   BPDInstanceMeasures           BPM_BPD_INSTANCE_MEASURES
 2117   BPMAsset                      BPM_ASSET
 2118   BPDActivityInstance           LSW_BPD_ACTIVITY_INSTANCE
 2119   UserAvatar                    BPM_USR_AVATAR
 2120   BPDInstanceCorrelation        LSW_BPD_INSTANCE_CORRELATION
 2121   BPDInstanceExtData            LSW_BPD_INSTANCE_EXT_DATA
 2122   BPDResourceLink               BPM_BPD_RESOURCE_LINK
 3000   Component
 3003   Coach                         LSW_COACH
 3004   CoachResource                 LSW_COACH_RESOURCE
 3005   CoachButton                   LSW_COACH_BUTTON
 3007   Exception                     LSW_EXCEPTION
 3008   ExitPoint                     LSW_EXIT_POINT
 3009   InvokeUCA                     LSW_INVOKE_UCA
 3010   Step                          LSW_STEP
 3011   Script                        LSW_SCRIPT
 3012   SubProcess                    LSW_SUBPROCESS
 3013   Switch                        LSW_SWITCH
 3014   SwitchCondition               LSW_SWITCH_CONDITION
 3015   TaskAction                    LSW_TASK_ACTION
 3016   TaskSender                    LSW_TASK_SENDER
 3017   TaskSenderExcludedVar         LSW_TASK_SENDER_EXVAR
 3018   TaskSenderAddr                LSW_TASK_SENDER_ADDR
 3019   TaskSenderFile                LSW_TASK_SENDER_FILE
 3020   TrackingPoint                 LSW_TRACKING_POINT
 3021   TrackedVariableUse            LSW_TRACKED_VARIABLE_USE
 3022   JavaConnector                 LSW_JAVA_CONNECTOR
 3023   WSConnector                   LSW_WS_CONNECTOR
 3024   ILOGConnector                 LSW_ILOG_CONNECTOR
 3025   SCAConnector                  LSW_SCA_CONNECTOR
 3026   ILOGDecision                  LSW_ILOG_DECISION
 3027   ICMCaseConnector              LSW_ICMCASE_CONNECTOR
 3028   CoachNG                       BPM_COACHNG
 3029   CoachNGBoundaryEvent          BPM_COACHNG_BOUNDARY_EVENT
 3030   ECMConnector                  BPM_ECM_CONNECTOR
 3031   StayOnPage                    LSW_STAY_ON_PAGE
 3032   CoachFlow
 5000   Repository
 6001   Contribution                  BPM_CONTRIBUTION
 6002   ContributionProperty          BPM_CTRB_PROPERTY
 6003   Artifact                      BPM_ARTIFACT
 6004   ContributionDependency        BPM_CTRB_DEPENDENCY
 6005   ProcessArtifactReference      BPM_PROC_ARTIFACT_REF
 6006   ClassArtifactReference        BPM_CLS_ARTIFACT_REF
 6007   BPDArtifactReference          BPM_BPD_ARTIFACT_REF
 6008   MonitorProjectInterchange     BPM_MON_MODEL_DATA
 6009   PCRegistration                BPM_REGISTRATION
 6010   RepositoryLog                 BPM_REPOSITORY_LOG
 6011   SharedToolKitUsage            BPM_SHARED_TK_USAGES
 6012   BPMSnapshotStatus             BPM_SNAPSHOT_STATUS
 6014   ProjectSubscription           BPM_PROJECT_SUBSCRIPTION
 6015   ProjectSubscribed             BPM_PROJECT_SUBSCRIBED
 6016   TaskMarker                    BPM_TASK_MARKERS
 6017   PCIndexAction                 BPM_PC_IDX_ACTION
 6018   PCIndexer                     BPM_PC_INDEXER
 6019   GovernanceEvent               BPM_GOVERNANCE_EVENT
 6020   GovernanceAssignment          BPM_GOVERNANCE_ASSIGNMENT
 6021   TWClassExtension              BPM_TWCLASS_EXTENSION
 6022   CaseProperty                  BPM_CASE_PROPERTY

IBM BPM 8.5.5 PO types table (PDW DB Part)

 PO_TYPE   Name                        PDWDB table  

 4000   SystemDefinition              LSW_SYSTEM
 4002   Task                          LSW_TASK
 4003   TrackedField                  LSW_TRACKED_FIELD
 4004   TrackedFieldUse               LSW_TRACKED_FIELD_USE
 4005   TrackedValue
 4006   TrackingGroup                 LSW_TRACKING_GROUP
 4007   TrackingPoint                 LSW_TRACKING_POINT
 4008   TrackingPointValue            LSW_TRACKING_POINT_VALUE
 4009   TimingIntervalValue           LSW_TIMING_INTERVAL_VALUE
 4010   TimingIntervalBound           LSW_TIMING_INTERVAL_BOUND
 4011   TimingInterval                LSW_TIMING_INTERVAL
 4012   LoadTrace                     LSW_LOAD_TRACE
 4013   User                          LSW_USR_XREF
 4014   Table                         LSW_TABLE
 4015   Column                        LSW_COLUMN
 4016   View                          LSW_VIEW
 4017   Snapshot                      LSW_SNAPSHOT