Thursday, August 27, 2015

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
Posted by at No comments:
Labels: , , , , , , , ,

Monday, August 24, 2015

IBM BPM PO types table (BPM DB Part)

IBM BPM 8.5.5 PO types table (BPM DB Part)
    

  1.  PO_TYPE   Name                        BPMDB table  
    2. 

    3. 

  3.  1      TWProcess (Service)           LSW_PROCESS
    4. 

  4.  2      IC (IntegrationComponent)     LSW_IC
    5. 

  5.  3      Connector                     LSW_CONNECTOR
    6. 

  6.  4      UCA (UnderCoverAgent)         LSW_UCA
    7. 

  7.  7      WebService                    LSW_WEB_SERVICE
    8. 

  8.  8      WebScript
    9. 

  9.  11     Report                        LSW_REPORT
    10. 

  10.  12     TWClass (VariableType)        LSW_CLASS
    11. 

  11.  13     Scoreboard                    LSW_SCBD
    12. 

  12.  14     TrackingGroup                 LSW_TRACKING_GROUP
    13. 

  13.  15     TimingInterval                LSW_TIMING_INTERVAL
    14. 

  14.  16     TrackingPoint                 LSW_TRACKING_POINT
    15. 

  15.  17     TrackedVariable               LSW_TRACKED_VARIABLE
    16. 

  16.  20     Layout                        LSW_LAYOUT
    17. 

  17.  21     EPV                           LSW_EPV
    18. 

  18.  22     GlobalVariable                deprecated
    19. 

  19.  24     Participant                   LSW_PARTICIPANT
    20. 

  20.  25     BPD                           LSW_BPD
    21. 

  21.  30     Priority                      LSW_PRIORITY
    22. 

  22.  31     Calendar                      deprecated
    23. 

  23.  40     CustomStatus                  deprecated
    24. 

  24.  42     AlertSeverity                 deprecated
    25. 

  25.  43     InfoPathForm                  LSW_INFOPATH_FORM
    26. 

  26.  47     SLA                           LSW_SLA
    27. 

  27.  49     Metric                        LSW_METRIC
    28. 

  28.  50     ResourceBundleGroup           LSW_RESOURCE_BUNDLE_GROUP
    29. 

  29.  51     UserAttributeDefinition       LSW_USER_ATTRIBUTE_DEF
    30. 

  30.  52     SimulationScenario            LSW_SIM_SCENARIO
    31. 

  31.  53     HistoricalScenario            LSW_HIST_SCENARIO
    32. 

  32.  54     OrgChart                      deprecated
    33. 

  33.  60     ExternalActivity              LSW_EXTERNAL_ACTIVITY
    34. 

  34.  61     ManagedAsset                  LSW_MANAGED_ASSET
    35. 

  35.  62     EnvironmentVariableSet        LSW_ENV_VAR_SET
    36. 

  36.  63     ProjectDefaults               LSW_PROJECT_DEFAULTS
    37. 

  37.  64     CoachView                     BPM_COACH_VIEW
    38. 

  38.  65     CoachViewBindingType          BPM_COACH_VIEW_BINDING_TYPE
    39. 

  39.  66     CoachViewConfigOption         BPM_COACH_VIEW_CONFIG_OPTION
    40. 

  40.  67     CoachViewResource             BPM_COACH_VIEW_RESOURCE
    41. 

  41.  68     CoachViewInlineScript         BPM_COACH_VIEW_INLINE_SCRIPT
    42. 

  42.  69     CoachViewLocalization         BPM_COACH_VIEW_LOCAL_RES
    43. 

  43.  70     CoachViewAMDDependency        BPM_COACH_VIEW_AMD_DEP
    44. 

  44.  71     EventSubscription             BPM_EVENT_SUBSCRIPTION
    45. 

  45.  1989   ExtendedPropertySet           LSW_EXTENDED_PROPERTY_SET
    46. 

  46.  2000   ExtendedProperty              LSW_EXTENDED_PROPERTY
    47. 

  47.  2001   AlertType                     deprecated
    48. 

  48.  2002   SapConnection                 LSW_SAP_CONNECTION
    49. 

  49.  2005   Breakpoint                    LSW_BREAKPOINT
    50. 

  50.  2006   BpdEvent                      LSW_BPD_EVENT
    51. 

  51.  2007   BpdParameter                  LSW_BPD_PARAMETER
    52. 

  52.  2008   BpmEvent                      BPM_BPD_EVENT
    53. 

  53.  2013   EpvVar                        LSW_EPV_VAR
    54. 

  54.  2014   EpvVarValue                   LSW_EPV_VAR_VALUE
    55. 

  55.  2015   Favorite                      LSW_FAVORITE
    56. 

  56.  2018   ICInputProperty               LSW_IC_INPUT_PROPERTY
    57. 

  57.  2019   ICOutputProperty              LSW_IC_OUTPUT_PROPERTY
    58. 

  58.  2020   TimingIntervalBound           LSW_TIMING_INTERVAL_BOUND
    59. 

  59.  2022   Launcher                      LSW_LAUNCHER
    60. 

  60.  2023   LayoutParam                   LSW_LAYOUT_PARAM
    61. 

  61.  2025   ProcessItem                   LSW_PROCESS_ITEM
    62. 

  62.  2026   ProcessItemLogVar             deprecated
    63. 

  63.  2027   ProcessLink                   LSW_PROCESS_LINK
    64. 

  64.  2028   ProcessLabel                  LSW_PROCESS_LABEL
    65. 

  65.  2029   ProcessItemPrePost            LSW_PROCESS_ITEM_PRE_POST
    66. 

  66.  2030   ReportPage                    LSW_REPORT_PAGE
    67. 

  67.  2031   ReportChart                   LSW_REPORT_CHART
    68. 

  68.  2032   ReportDatasource              LSW_REPORT_DATASOURCE
    69. 

  69.  2033   ReportDatasourceICLink        LSW_REPORT_DATASOURCE_IC_LINK
    70. 

  70.  2034   ReportDatasourceLayoutLink    LSW_REPORT_DS_LAYOUT_LINK
    71. 

  71.  2035   ReportVariable                LSW_REPORT_VARIABLES
    72. 

  72.  2036   ReportEpvLink                 LSW_REPORT_EPV_LINK
    73. 

  73.  2037   ReportTGLink                  LSW_REPORT_TG_LINK
    74. 

  74.  2038   ResourceBundle                LSW_RESOURCE_BUNDLE
    75. 

  75.  2039   ResourceBundleKey             LSW_RESOURCE_BUNDLE_KEY
    76. 

  76.  2040   SavedSearch                   LSW_SAVED_SEARCHES
    77. 

  77.  2041   ScoreboardReportLink          LSW_SCBD_RPT_LINK
    78. 

  78.  2043   ScriptLanguage
    79. 

  79.  2044   SyncQueue                     LSW_UCA_SYNC_QUEUE
    80. 

  80.  2045   UCABlackout                   LSW_UCA_BLACKOUT
    81. 

  81.  2046   UCAParam                      LSW_UCA_PARM
    82. 

  82.  2047   ProviderUser                  LSW_USR
    83. 

  83.  2048   User                          LSW_USR_XREF
    84. 

  84.  2049   UserAttribute                 LSW_USR_ATTR
    85. 

  85.  2050   UserAttributeDefinitionValue  LSW_USER_ATTR_DEF_VALUES
    86. 

  86.  2052   WebServiceOperation           LSW_WEB_SERVICE_OP
    87. 

  87.  2054   ParameterMapping              LSW_PARAMETER_MAPPING
    88. 

  88.  2055   ProcessParameter              LSW_PROCESS_PARAMETER
    89. 

  89.  2056   ProcessVariable               LSW_PROCESS_VARIABLE
    90. 

  90.  2057   ProcessGlobalVariableLink     deprecated
    91. 

  91.  2058   EpvProcessLink                LSW_EPV_PROCESS_LINK
    92. 

  92.  2059   ResourceProcessLink           LSW_RESOURCE_PROCESS_LINK
    93. 

  93.  2060   ExternalActivityParameter     LSW_EXTACT_PARAMETER
    94. 

  94.  2061   ExternalActivityProperty      LSW_EXTACT_PROPERTY
    95. 

  95.  2063   Branch                        LSW_BRANCH
    96. 

  96.  2064   Snapshot                      LSW_SNAPSHOT
    97. 

  97.  2065   Deployment                    LSW_DEPLOYMENT
    98. 

  98.  2066   Project                       LSW_PROJECT
    99. 

  99.  2068   Server                        LSW_SERVER
    100. 

  100.  2069   ProjectDependency             LSW_PROJECT_DEPENDENCY
    101. 

  101.  2070   ParameterMappingParent
    102. 

  102.  2072   BPDInstance                   LSW_BPD_INSTANCE
    103. 

  103.  2073   BPDInstanceData               LSW_BPD_INSTANCE_DATA
    104. 

  104.  2075   UserGroup                     LSW_USR_GRP_XREF
    105. 

  105.  2076   Release                       LSW_RELEASE
    106. 

  106.  2077   EnvironmentVariableValue      LSW_ENV_VAR_VAL
    107. 

  107.  2078   Task                          LSW_TASK
    108. 

  108.  2079   UserFavorite                  LSW_USER_FAVORITE
    109. 

  109.  2080   TaskAttachment                LSW_FILE
    110. 

  110.  2081   TaskNarrative                 LSW_TASK_NARR
    111. 

  111.  2082   TaskSendToList                LSW_TASK_ADDR
    112. 

  112.  2084   TaskExecutionContext          LSW_TASK_EXECUTION_CONTEXT
    113. 

  113.  2085   TaskInfopathFormData          LSW_TASK_IPF_DATA
    114. 

  114.  2086   ExternalTaskData              LSW_TASK_EXTACT_DATA
    115. 

  115.  2087   UserAssume                    LSW_USR_ASSUME
    116. 

  116.  2089   BPDNotification               LSW_BPD_NOTIFICATION
    117. 

  117.  2090   DependencyPath                LSW_DEP_PATH
    118. 

  118.  2091   POReference                   LSW_PO_REFERENCE
    119. 

  119.  2092   EnvironmentVariableDefault    LSW_ENV_VAR_DEFAULT
    120. 

  120.  2093   EnvironmentType               LSW_ENV_TYPE
    121. 

  121.  2094   EnvironmentVariable           LSW_ENV_VAR
    122. 

  122.  2095   RTReference                   LSW_RT_REFERENCE
    123. 

  123.  2097   TimePeriod                    LSW_TIME_PERIOD
    124. 

  124.  2098   TimeSchedule                  LSW_TIME_SCHEDULE
    125. 

  125.  2099   HolidaySchedule               LSW_HOLIDAY_SCHEDULE
    126. 

  126.  2100   TWAclEntry                    LSW_ACL_ENTRY
    127. 

  127.  2101   SmartFolder                   LSW_SMART_FOLDER
    128. 

  128.  2102   ReportDatasourceServiceLink   LSW_REPORT_DATASOURCE_SRV_LINK
    129. 

  129.  2103   Installation                  LSW_INSTALLATION
    130. 

  130.  2104   BlueprintSubscription         LSW_BLUEPRINT_SUBSCRIPTION
    131. 

  131.  2105   ReportRbgLink                 LSW_REPORT_RBG_LINK
    132. 

  132.  2106   EnvironmentVariableType       LSW_ENV_VAR_TYPE
    133. 

  133.  2107   ServerCapability              LSW_SERVER_CAPABILITY
    134. 

  134.  2108   CapabilityType                LSW_CAPABILITY_TYPE
    135. 

  135.  2109   SharedObject                  BPM_SHARED_OBJECT
    136. 

  136.  2110   SharedObjectInstance          BPM_SHARED_OBJECT_INSTANCE
    137. 

  137.  2111   SharedObjectValue             BPM_SHARED_OBJECT_VALUE
    138. 

  138.  2112   OSLCProvider                  BPM_OSLC_PROVIDER
    139. 

  139.  2113   BPDSoapHeader                 BPM_BPD_SOAPHEADER
    140. 

  140.  2114   EventSubscriptionType         BPM_EVENT_SUBSCRIPTION_TYPE
    141. 

  141.  2115   UCAEventType                  BPM_UCA_EVENT_TYPE
    142. 

  142.  2116   BPDInstanceMeasures           BPM_BPD_INSTANCE_MEASURES
    143. 

  143.  2117   BPMAsset                      BPM_ASSET
    144. 

  144.  2118   BPDActivityInstance           LSW_BPD_ACTIVITY_INSTANCE
    145. 

  145.  2119   UserAvatar                    BPM_USR_AVATAR
    146. 

  146.  2120   BPDInstanceCorrelation        LSW_BPD_INSTANCE_CORRELATION
    147. 

  147.  2121   BPDInstanceExtData            LSW_BPD_INSTANCE_EXT_DATA
    148. 

  148.  2122   BPDResourceLink               BPM_BPD_RESOURCE_LINK
    149. 

  149.  3000   Component
    150. 

  150.  3003   Coach                         LSW_COACH
    151. 

  151.  3004   CoachResource                 LSW_COACH_RESOURCE
    152. 

  152.  3005   CoachButton                   LSW_COACH_BUTTON
    153. 

  153.  3007   Exception                     LSW_EXCEPTION
    154. 

  154.  3008   ExitPoint                     LSW_EXIT_POINT
    155. 

  155.  3009   InvokeUCA                     LSW_INVOKE_UCA
    156. 

  156.  3010   Step                          LSW_STEP
    157. 

  157.  3011   Script                        LSW_SCRIPT
    158. 

  158.  3012   SubProcess                    LSW_SUBPROCESS
    159. 

  159.  3013   Switch                        LSW_SWITCH
    160. 

  160.  3014   SwitchCondition               LSW_SWITCH_CONDITION
    161. 

  161.  3015   TaskAction                    LSW_TASK_ACTION
    162. 

  162.  3016   TaskSender                    LSW_TASK_SENDER
    163. 

  163.  3017   TaskSenderExcludedVar         LSW_TASK_SENDER_EXVAR
    164. 

  164.  3018   TaskSenderAddr                LSW_TASK_SENDER_ADDR
    165. 

  165.  3019   TaskSenderFile                LSW_TASK_SENDER_FILE
    166. 

  166.  3020   TrackingPoint                 LSW_TRACKING_POINT
    167. 

  167.  3021   TrackedVariableUse            LSW_TRACKED_VARIABLE_USE
    168. 

  168.  3022   JavaConnector                 LSW_JAVA_CONNECTOR
    169. 

  169.  3023   WSConnector                   LSW_WS_CONNECTOR
    170. 

  170.  3024   ILOGConnector                 LSW_ILOG_CONNECTOR
    171. 

  171.  3025   SCAConnector                  LSW_SCA_CONNECTOR
    172. 

  172.  3026   ILOGDecision                  LSW_ILOG_DECISION
    173. 

  173.  3027   ICMCaseConnector              LSW_ICMCASE_CONNECTOR
    174. 

  174.  3028   CoachNG                       BPM_COACHNG
    175. 

  175.  3029   CoachNGBoundaryEvent          BPM_COACHNG_BOUNDARY_EVENT
    176. 

  176.  3030   ECMConnector                  BPM_ECM_CONNECTOR
    177. 

  177.  3031   StayOnPage                    LSW_STAY_ON_PAGE
    178. 

  178.  3032   CoachFlow
    179. 

  179.  5000   Repository
    180. 

  180.  6001   Contribution                  BPM_CONTRIBUTION
    181. 

  181.  6002   ContributionProperty          BPM_CTRB_PROPERTY
    182. 

  182.  6003   Artifact                      BPM_ARTIFACT
    183. 

  183.  6004   ContributionDependency        BPM_CTRB_DEPENDENCY
    184. 

  184.  6005   ProcessArtifactReference      BPM_PROC_ARTIFACT_REF
    185. 

  185.  6006   ClassArtifactReference        BPM_CLS_ARTIFACT_REF
    186. 

  186.  6007   BPDArtifactReference          BPM_BPD_ARTIFACT_REF
    187. 

  187.  6008   MonitorProjectInterchange     BPM_MON_MODEL_DATA
    188. 

  188.  6009   PCRegistration                BPM_REGISTRATION
    189. 

  189.  6010   RepositoryLog                 BPM_REPOSITORY_LOG
    190. 

  190.  6011   SharedToolKitUsage            BPM_SHARED_TK_USAGES
    191. 

  191.  6012   BPMSnapshotStatus             BPM_SNAPSHOT_STATUS
    192. 

  192.  6014   ProjectSubscription           BPM_PROJECT_SUBSCRIPTION
    193. 

  193.  6015   ProjectSubscribed             BPM_PROJECT_SUBSCRIBED
    194. 

  194.  6016   TaskMarker                    BPM_TASK_MARKERS
    195. 

  195.  6017   PCIndexAction                 BPM_PC_IDX_ACTION
    196. 

  196.  6018   PCIndexer                     BPM_PC_INDEXER
    197. 

  197.  6019   GovernanceEvent               BPM_GOVERNANCE_EVENT
    198. 

  198.  6020   GovernanceAssignment          BPM_GOVERNANCE_ASSIGNMENT
    199. 

  199.  6021   TWClassExtension              BPM_TWCLASS_EXTENSION
    200. 

  200.  6022   CaseProperty                  BPM_CASE_PROPERTY
    201. 

    202.
IBM BPM 8.5.5 PO types table (PDW DB Part)
    

  1.  PO_TYPE   Name                        PDWDB table  
    2. 

    3. 

  3.  4000   SystemDefinition              LSW_SYSTEM
    4. 

  4.  4002   Task                          LSW_TASK
    5. 

  5.  4003   TrackedField                  LSW_TRACKED_FIELD
    6. 

  6.  4004   TrackedFieldUse               LSW_TRACKED_FIELD_USE
    7. 

  7.  4005   TrackedValue
    8. 

  8.  4006   TrackingGroup                 LSW_TRACKING_GROUP
    9. 

  9.  4007   TrackingPoint                 LSW_TRACKING_POINT
    10. 

  10.  4008   TrackingPointValue            LSW_TRACKING_POINT_VALUE
    11. 

  11.  4009   TimingIntervalValue           LSW_TIMING_INTERVAL_VALUE
    12. 

  12.  4010   TimingIntervalBound           LSW_TIMING_INTERVAL_BOUND
    13. 

  13.  4011   TimingInterval                LSW_TIMING_INTERVAL
    14. 

  14.  4012   LoadTrace                     LSW_LOAD_TRACE
    15. 

  15.  4013   User                          LSW_USR_XREF
    16. 

  16.  4014   Table                         LSW_TABLE
    17. 

  17.  4015   Column                        LSW_COLUMN
    18. 

  18.  4016   View                          LSW_VIEW
    19. 

  19.  4017   Snapshot                      LSW_SNAPSHOT
    20.
Posted by at No comments:
Labels: , ,
Subscribe to: Posts (Atom)