Direct link to fix
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