JR51707: UNKNOWN TYPE SHOWS FOR BUSINESS ALIASES WHEN NO INSTANCES ARE PRESENT AND <USE-BUSINESS-ALIASES-FOR-PROCESS-INSTANCES> IS TRUE

8.5.0.1-WS-BPM-IFJR51707
8.0.1.3-WS-BPM-IFJR51707
8.0.1.2-WS-BPM-IFJR51707
Version 8.5 Refresh Pack 6 for the IBM Business Process Manager products
Version 8.5.0 Fix Pack 2 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• When the business data aliases cache is populated by using only
  business process definition (BPD) instance data, no instances
  are available, and <use-business-aliases-for-process-instances>
  is set to true, searches on specific aliases are not found in
  the cache and resolve to Unknown. If no instances are present,
  the cache should show all available data.
  
  
  In this WLE.*=all trace example, the business variable
  CustomerAddress is not properly initialized. Note that the data
  name is labeled "Unknown"
  
  wle_search 1
  com.lombardisoftware.server.core.pse.impl.ProcessSearchQueryEngi
  ne prepareQuery propertyNames [instanceId, instanceStatus,
  businessData.CustomerAddress@Unknown]
  wle_search 1
  com.lombardisoftware.server.core.pse.impl.ProcessSearchQueryEngi
  ne prepareQuery searchConstraints
  [SimpleConstraint(PropertyValueExpression(instanceStatus)
  Operator(=) ConstantExpression(Active)),
  SimpleConstraint(BusinessDataConstraintVariableNameExpression(va
  riable name: CustomerAddress, type: Unknown ) Operator(=)
  BusinessDataValueExpression(CSEZS0258845368))]
  
  In the SystemOut.log files, you see the following exception
  stack related to looking up values in the pivot tables. However,
  the STRING_VALUE column is not a pivot table column.
  
  Caused by: [TeamworksException name='<JSScript>',
  message='PreparedStatementCallback; bad SQL grammar [SELECT *
  FROM (
  SELECT searchWithInstanceIdx.*, ROW_NUMBER() OVER ( order by
  instanceId, taskDueDate, taskPriorityRanking, taskId ) AS
  search_result_row_idx
  FROM (
  SELECT actualSearch.*, ROW_NUMBER() OVER ( PARTITION BY
  instanceid order by instanceId, taskDueDate,
  taskPriorityRanking, taskId ) AS instance_result_row_idx
  FROM (
  select t.bpd_instance_id as instanceId, istatus.name as
  instanceStatus, vp.CUSTOMERID AS PSCUSTOMERID, t.due_date as
  taskDueDate, tpriority.ranking as taskPriorityRanking,
  t.task_id as taskId
   from lsw_task t
  inner join lsw_bpd_instance i on t.bpd_instance_id =
  i.bpd_instance_id
  left join lsw_bpd_status_codes istatus on i.execution_status =
  istatus.status_id
  left join lsw_priority tpriority on t.priority_id =
  tpriority.priority_id
  inner join lsw_bpd_instance_vars_pivot vp on
  vp.bpd_instance_id=i.bpd_instance_id
   where ( UPPER(istatus.name) = UPPER(?) AND  (
  (CAST(vp.DATE_VALUE AS VARCHAR(128))  || CAST(vp.DATE_VALUE AS
  VARCHAR(128))  || CAST(vp.DEC_VALUE AS VARCHAR(128))  ||
  CAST(vp.INT_VALUE AS VARCHAR(128))  || CAST(vp.BOOLEAN_VALUE AS
  VARCHAR(128))  || CAST(vp.STRING_VALUE AS VARCHAR(512)) ) =
  UPPER(?) )  )
  
  ) actualSearch
  ) searchWithInstanceIdx
  WHERE searchWithInstanceIdx.instance_result_row_idx = 1
  ) searchWithRowIdx
  WHERE search_result_row_idx <= ?
   order by instanceId, taskDueDate, taskPriorityRanking, taskId
  ]; nested exception is java.sql.SQLSyntaxErrorException:
  ORA-00904: "VP"."STRING_VALUE": invalid identifier
  ', line=42, pos=0 nested=<none>]
   at
  com.lombardisoftware.core.script.js.JavaScriptRunner$MyErrorRepo
  rter.runtimeError(JavaScriptRunner.java:568)
   at
  org.mozilla.javascript.Context.reportRuntimeError(Context.java:9
  38)
   at
  org.mozilla.javascript.Context.reportRuntimeError(Context.java:9
  94)
   at
  com.lombardisoftware.core.script.js.TWSearchScriptable.executeSe
  archInternal(TWSearchScriptable.java:381)
   at
  com.lombardisoftware.core.script.js.TWSearchScriptable.jsFunctio
  n_execute(TWSearchScriptable.java:180)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
  Method)
   at
  sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
  Impl.java:60)
   at
  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
  AccessorImpl.java:37)
   at java.lang.reflect.Method.invoke(Method.java:611)
   at
  org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161)
   ... 83 more
  
  
  PRODUCTS AFFECTED:
  IBM Business Process Manager (BPM) Advanced
  IBM BPM Standard
  IBM BPM Express
  

Local fix

Problem summary

• No additional information is available.
  

Problem conclusion

• A fix is available for IBM BPM that modifies the loading
  behavior of the business data aliases cache when the operational
   flag to use process instances is set to true and only applies
  when there are no instances available.
  
  On Fix Central (http://www.ibm.com/support/fixcentral), search
  for JR51707:
  
  1. Select IBM Business Process Manager with your edition from
  the product selector, the installed version to the fix pack
  level, and your platform, and then click Continue.
  2. Select APAR or SPR, enter JR51707, and click Continue.
  
  When you download fix packages, ensure that you also download
  the readme file for each fix. Review each readme file for
  additional installation instructions and information about the
  fix.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  BPM STANDARD

• Fixed component ID

  5725C9500

Applicable component levels

• R801 PSY

     UP