IBM Support

JR61945: RUNNING THE RELATIONSHIP MANAGER FAILS WITH THE OJDBC8.JAR JDBC DRIVER INSTALLED

Direct link to fix

workflow.20001.delta.repository

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After you upgrade the Oracle JDBC driver from ojdbc7.jar to
ojdbc8.jar and try to run the Relationship Manager, the
Relationship Manager fails and you might see the following error
 in the SystemOut.log file:

com.ibm.wbiserver.relationshipservice.util.ArtifactLoaderUtility
createRuntimeSchema(<ApplicationName>) CWLAE0005I: An exception
was encountered when the relationship service code was
executing.

In addition, FFDC records might be written that contain stack
traces like this

FFDC
Exception:com.ibm.wbiserver.relationshipservice.exceptions.Relat
ionshipServiceException
SourceId:com.ibm.wbiserver.relationshipservice.util.ArtifactLoad
erUtility.createRuntimeSchema ProbeId:423
com.ibm.wbiserver.relationshipservice.exceptions.RelationshipSer
viceException: table <TABLE_NAME> already exist,but the table
schema is different from current role definition
at
com.ibm.wbiserver.relationshipservice.dblayer.oracle.OracleCreat
or.createRoleBaseSchema(OracleCreator.java:419)
at
com.ibm.wbiserver.relationshipservice.dblayer.oracle.OracleCreat
or.createRoleRuntimeSchema(OracleCreator.java:154)
at
com.ibm.wbiserver.relationshipservice.dblayer.SchemaCreator.crea
teRuntimeSchema(SchemaCreator.java:144)
at
com.ibm.wbiserver.relationshipservice.util.ArtifactLoaderUtility
.createRuntimeSchema(ArtifactLoaderUtility.java:490)

Local fix

  • N/A

Problem summary

  • This issue occurs because the ojdbc7.jar JDBC driver returned
the SQL datatype DECIMAL for a column definition like
NUMBER(10,0) whereas the ojdbc8.jar JDBC driver returns the SQL
datatype NUMERIC.

PRODUCTS AFFECTED
IBM Business Process Manager (BPM) Advanced
IBM BPM Standard
IBM Business Automation Workflow

Problem conclusion

  • A fix is available that handles the different data type naming
between the ojdbc7.jar and ojdbc8.jar JDBC drivers.

Temporary fix

  • Not applicable

Comments

  • 



APAR Information




    

  • APAR number
    JR61945
    • 

  • Reported component name
    BPM
    • 

  • Reported component ID
    5737A5700
    • 

  • Reported release
    860
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2020-01-31
    • 

  • Closed date
    2020-02-28
    • 

  • Last modified date
    2020-02-28
    • 





    

  • 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
    • 

  • Fixed component ID
    5737A5700
    • 



Applicable component levels


    








      
              
                            

              

              [{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SS3PUM","label":"IBM Business Process Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.6.0.0"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            23 September 2022
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback