IBM Support

JR56283: EMPTY SEARCH RESULT WHEN STORING TIME VALUE INCLUDING FRACTIONS OF A SECOND IN PROCESS VARIABLE WITH ORACLE AS IBM BPM DATABASE

Direct links to fixes

bpm.8570.cf2016.09.delta.repository.1of2
bpm.8570.cf2016.09.delta.repository.2of2
Downloading IBM Business Process Manager V8.5.7 Cumulative Fix 2016.09

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Process instances or tasks are not retrieved while you search by
using Oracle as IBM BPM database and a JavaScript object of
type TWSearch that specifies the date value or date values as a
search parameter, even though the value or values match existing
process instances or tasks.

Local fix

  • 



Problem summary


    

  • If you store time values in process variables that are marked as
Visible in Process Portal, the time values include fractions of
a second, you use Oracle as the IBM BPM database, and you run a
search specifying an exact match filter with a time value that
includes fractions of a second, an empty result might be
returned.

On Oracle, IBM BPM stores searchable variables of type "time" in
columns of type DATE. During insertion, fractions of a second
are truncated. If you compare the stored date value to a time
with fractions of a second, the date value is cast to a
timestamp value before the comparison is complete. If the input
value has fractions of a second, the comparison fails because of
the truncation. As a result, corresponding process instances or
tasks cannot be retrieved.

PRODUCTS AFFECTED
IBM Business Process Manager (BPM) Advanced
IBM BPM Standard
IBM BPM Express

    



Problem conclusion


    

  • A fix is included in IBM BPM V8.5.7 cumulative fix 2016.09 that
resolves the problem by truncating the milliseconds from the
search parameter values of type "date" so that the comparison
succeeds.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR56283
    • 

  • Reported component name
    BPM STANDARD
    • 

  • Reported component ID
    5725C9500
    • 

  • Reported release
    857
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2016-07-11
    • 

  • Closed date
    2016-09-09
    • 

  • Last modified date
    2016-09-09
    • 





    

  • 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


    








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"857","Line of Business":{"code":"LOB45","label":"Automation"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            04 September 2023
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback