IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR51707

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-11-03

  • Closed date

    2014-11-20

  • Last modified date

    2014-11-20

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
20 November 2014